Stock figures
Listed criteria for each key figure is based on Standard SAP inventory process and is aligned in all BW queries (where applicable).
All figures are based on following specifications:
| Purchasing document type | INFLOW | OUTFLOW |
|---|---|---|
| Other transaction/vendor | Other receipt | Other issue |
| Purchase order/vendor | Goods receipt/vendor | Returns receipt/vendor |
| Scheduling agreement/vendor | Matl transfer posting/receipt | Matl trnsfr posting/outbound |
| Returns order/vendor | StAdj InvD+ | StAdj InvD- |
| Returns/vendor | StAdj Other+ | StAdj Other- |
| Other transaction/within a CC | Receipt from transfer posting | Issue from transfer posting |
Total stock
Total stock = Receipt Quantity* (Inflow) - Issue Quantity* (Outflow)
*Value of Total stock is not measured
Total Stock can be divided into Internal, External and Other Stock based on Stock type:
Internal stock
Internal stock = Unrestricted Use (A) + Restricted Use (E) + Stock in Transit + Q Stock + Blocked Stock + Block Stock returns (C)
External stock
External stock = Customer Consignment, unrestricted use (K, N) + Stock in subcontractors (R, Q) + Customer consignment. restricted use (M)
Other stock
Other stock = Stock Transfer (F) + Material Provided By Customer (G) + Customer Consignment in Quality Inspection (L) + Customer Returnable Packaging in Quality Inspection (O) + Customer Returnable Packaging, Restricted Use (P) + Stock of Material Provided to Vendor, Restricted Use (S) + Tied Empties (T) + Consumption (V)
Valuated stock
Valuated stock = Receipt Quantity/Value (Inflow)* - Issue Quantity/Value (Outflow)**
| Stock category | Sales order stock (E) or Project stock (Q) |
|---|---|
| Indicator: Valuation of Special Stock | Valuation without reference to sales document (A) or Separate valuation with ref. to sales document/project (M) |
*Inflow in PF1 application: Debit/credit indicator = Debit Posting or Receiver Debit Posting
**Outflow in PF1 application: Debit/credit indicator = Credit Posting or Sender Credit Posting
Stock in quality inspection (Q-Stock)
Q-Stock = Receipt Quantity/Value (Inflow) - Issue Quantity/Value (Outflow)
| Stock category | Valuated stock ( ) or Sales order stock (E) or Returnable transport packaging (M) or Project stock (Q) Excluded categories: Vendor consignment stock (K) or Blocked stock returns (R) or Consumption (V)* |
|---|---|
| Stock type | Quality Inspection (B) or Customer Consignment in Quality Inspection (L) or Customer Returnable Packaging in Quality Inspection (O) or Materials Provided to Vendor in Quality Inspection (R) |
*to be verified
Stock in transit
Stock in transit = Receipt Quantity/Value (Inflow) - Issue Quantity/Value (Outflow)
| Stock type | Stock Transfer (F) or Transit (H) |
|---|
Blocked stock
Blocked stock = Receipt Quantity/Value (Inflow) - Issue Quantity/Value (Outflow)
| Stock category | Valuated stock ( ) or Sales order stock (E) or Returnable transport packaging (M) or Project stock (Q) Excluded categories: Vendor consignment stock (K) or Blocked stock returns (R) or Consumption (V)* |
|---|---|
| Stock type | Blocked Stock (D) |
*to be verified
Consignment stock
Consignment stock = Receipt Quantity/Value* (Inflow) - Issue Quantity/Value* (Outflow)
*Value measured at Customer
| Stock category | Vendor consignment stock (K) |
|---|---|
| Stock type | Customer Consignment, Unrestricted Use (K) or Customer Consignment in Quality Inspection (L) or Customer Consignment, Restricted Use (M) or Restricted-Use (E)* |
*to be verified
Scrap
Issue Quantity/Value
Specification not applicable, Scrap is measured via following Movement Types:
| Movement type | 551 | GI scrapping |
|---|---|---|
| 552 | RE scrapping | |
| 553 | GI scrapping QI | |
| 554 | RE scrapping QI | |
| 555 | GI scrapping blocked | |
| 556 | RE scrapping blocked |
Production figures
Listed criteria for each key figure is AS-IS analysis based on "BW - Stock Movement All Types (core query)" query.
After the initial analysis, we will progress with functional re-validation, adjustments and alignment of all queries.
Global Sales
Sales = external + inter company + intraco + consignment
External Sales
External = Sale external (+) - Sale external (-)
| Quantity/Value | Movement Type | Description |
|---|---|---|
| Sale external (+) | 231 | GI for sales order (WP1&PF1) |
| Sale external (+) | 232 | RE for sales order (WP1&PF1) |
| Sale external (+) | 601 | GD goods issue:delvy (WP1&PF1) |
| Sale external (+) | 602 | RE goods deliv. rev. (WP1&PF1) |
| Sale external (-) | 651 | GD ret.del. returns (WP1&PF1) |
| Sale external (-) | 652 | GD ret.del. retn rev (WP1&PF1) |
| Sale external (-) | 653 | GD returns unrestr. (WP1&PF1) |
| Sale external (-) | 654 | GD returns unr. rev. (WP1&PF1) |
| Sale external (-) | 655 | GD returns QI (WP1&PF1) |
| Sale external (-) | 656 | GD returns QI rev. (WP1&PF1) |
| Sale external (-) | 657 | GD returns blocked (WP1&PF1) |
| Sale external (-) | 658 | GD returns blk. rev. (WP1&PF1) |
Inter company
Inter company = Sale inter company (+) - Sale inter company (-)
| Quantity/Value | Movement Type | Description |
|---|---|---|
| Sale inter company (+) | 643 | TF to cross company (WP1&PF1) |
| Sale inter company (+) | 644 | TR to cross company (WP1&PF1) |
| Sale inter company (+) | 645 | TF cross company (WP1&PF1) |
| Sale inter company (+) | 646 | TR cross company (WP1&PF1) |
| Sale inter company (-) | 673 | TF to cross company (WP1&PF1) |
| Sale inter company (-) | 674 | TR to cross company (WP1&PF1) |
| Sale inter company (-) | 675 | TR cross company (WP1&PF1) |
| Sale inter company (-) | 676 | TF cross company (WP1&PF1) |
Intracompany
Intraco = Sale Intraco (+) - Sale Intraco (-)
| Quantity/Value | Debit/credit indicator | Movement Type | Description |
|---|---|---|---|
| Sale Intraco (+) | H (credit) | 303 | TF rem.fm.stor.to pl (WP1&PF1) |
| Sale Intraco (+) | H (credit) | 641 | TF to stck in trans. (WP1&PF1) |
| Sale Intraco (+) | H (credit) | 647 | TF to stck in trans. (WP1&PF1) |
| Sale Intraco (+) | H (credit) | 672 | TF to stck in trans. (WP1&PF1) |
| Sale Intraco (+) | H (credit) | 678 | TF to stck in trans. (WP1&PF1) |
| Sale Intraco (-) | S (debit) | 304 | TR rem.fm.stor.to pl (WP1&PF1) |
| Sale Intraco (-) | S (debit) | 642 | TR to stck in trans. (WP1&PF1) |
| Sale Intraco (-) | S (debit) | 648 | TR to stck in trans. (WP1&PF1) |
| Sale Intraco (-) | S (debit) | 671 | TR to stck in trans. (WP1&PF1) |
| Sale Intraco (-) | S (debit) | 677 | TR to stck in trans. (WP1&PF1) |
Consignment
Consignment = Sale Consignment (+) - Sale Consignment (-)
| Quantity/Value | Debit/credit indicator | Movement Type | Description |
|---|---|---|---|
| Sale Consignment (+) | H (credit) | 631 | GI consgmt: lending (WP1&PF1) |
| Sale Consignment (-) | S (debit) | 632 | GI consgmt:ret.delvy (WP1&PF1) |
Global Consumption
Consumption = internal + sub-contracting
Internal
| Quantity/Value | Movement Type | Description |
|---|---|---|
| internal | 261 | GI consgmt: lending (WP1&PF1) |
| internal | 262 | GI consgmt:ret.delvy (WP1&PF1) |
Sub-contracting
| Quantity/Value | Movement Type | Description |
|---|---|---|
| sub-contracting | 543 | GI consgmt: lending (WP1&PF1) |
| sub-contracting | 544 | GI consgmt:ret.delvy (WP1&PF1) |
Global Procurement
Global Procurement = Procurement External + Procurement Inter Company + Procurement Intraco + Procurement Consignment
External
Procurement External = Procurement External (+) - Procurement External (-)
| Quantity/Value | movement indicator | Item category in purchasing document | special stock indicator | supplying plant | order type (purchasing) | Movement Type | Description |
|---|---|---|---|---|---|---|---|
| Procurement External (+) | B (movement for a purchase order) | 0 (standard) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | ≠UB; LU (not equal Stock transport ord. or Transp. sched. agmt.) | 101 | GR goods receipt |
| Procurement External (+) | B (movement for a purchase order) | 0 (standard) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | ≠UB; LU (not equal Stock transport ord. or Transp. sched. agmt.) | 102 | GR for PO reversal |
| Procurement External (+) | B (movement for a purchase order) | 0 (standard) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | ≠UB; LU (not equal Stock transport ord. or Transp. sched. agmt.) | 131 | Goods receipt |
| Procurement External (+) | B (movement for a purchase order) | 0 (standard) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | ≠UB; LU (not equal Stock transport ord. or Transp. sched. agmt.) | 132 | Goods receipt |
| Procurement External (-) | B (movement for a purchase order) | 0 (standard) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | ≠UB; LU (not equal Stock transport ord. or Transp. sched. agmt.) | 122 | RE return to vendor |
| Procurement External (-) | B (movement for a purchase order) | 0 (standard) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | ≠UB; LU (not equal Stock transport ord. or Transp. sched. agmt.) | 123 | RE rtrn vendor rev. |
Inter Company
Procurement Inter Company = Procurement Inter Company (+) - Procurement Inter Company (-)
| Quantity/Value | movement indicator | special stock indicator | supplying plant | order type | Movement Type | Description |
|---|---|---|---|---|---|---|
| Procurement Inter Company (+) | B (movement for a purchase order) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | NB (Standard PO) | 101 | GR goods receipt |
| Procurement Inter Company (+) | B (movement for a purchase order) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | NB (Standard PO) | 102 | GR for PO reversal |
| Procurement Inter Company (+) | B (movement for a purchase order) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | NB (Standard PO) | 131 | Goods receipt |
| Procurement Inter Company (+) | B (movement for a purchase order) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | NB (Standard PO) | 132 | Goods receipt |
| Procurement Inter Company (-) | B (movement for a purchase order) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | NB (Standard PO) | 161 | GR returns |
| Procurement Inter Company (-) | B (movement for a purchase order) | ≠K (not equal to Consignment (vendor)) | # (not assigned) | NB (Standard PO) | 162 | GR rtrns reversal |
Intraco
Procurement Intraco = Procurement Intraco (+) - Procurement Intraco (-)
| Quantity/Value* | debit/credit | Movement Type | Description |
|---|---|---|---|
| Procurement Intraco (+) | H (credit) | 304 | TR rem.fm.stor.to pl |
| Procurement Intraco (+) | H (credit) | 642 | TR to stck in trans. |
| Procurement Intraco (+) | H (credit) | 648 | TR to stck in trans. |
| Procurement Intraco (+) | H (credit) | 671 | TR to stck in trans. |
| Procurement Intraco (+) | H (credit) | 677 | TR to stck in trans. |
| Procurement Intraco (-) | S (debit) | 303 | TF rem.fm.stor.to pl |
| Procurement Intraco (-) | S (debit) | 641 | TF to stck in trans. |
| Procurement Intraco (-) | S (debit) | 647 | TF to stck in trans. |
| Procurement Intraco (-) | S (debit) | 672 | TF to stck in trans. |
| Procurement Intraco (-) | S (debit) | 678 | TF to stck in trans. |
*different use of KF: 0QUANT_B instead of K_MOVEQTY
Consignment
Procurement Consignment = Procurement Consignment (with order) - Procurement Consignment (without order)
| Quantity/Value | special stock indicator | Movement Type | Description |
|---|---|---|---|
| Procurement Consignment (with order) | K (Consignment (vendor)) | 501 | Receipt w/o PO |
| Procurement Consignment (with order) | K (Consignment (vendor)) | 502 | RE receipt w/o PO |
| Procurement Consignment (without order) | K (Consignment (vendor)) | 102 | GR for PO reversal |
| Procurement Consignment (without order) | K (Consignment (vendor)) | 101 | GR goods receipt |
| Procurement Consignment (without order) | K (Consignment (vendor)) | 131 | Goods receipt |
| Procurement Consignment (without order) | K (Consignment (vendor)) | 132 | Goods receipt |
Global Production
Production = Internal Production + Sub Contracting Production
Internal
Internal Production = Principal Production + Co-product Production + By-product Production
| Quantity/Value | movement indicator | subcontracting flag | material co-product | Movement Type | Description |
|---|---|---|---|---|---|
| Principal | F (movement for a work order) | ≠S (no flag) | - | 101 | GR goods receipt |
| Principal | F (movement for a work order) | ≠S (no flag) | - | 102 | GR for PO reversal |
| Principal | F (movement for a work order) | ≠S (no flag) | - | 131 | Goods receipt |
| Principal | F (movement for a work order) | ≠S (no flag) | - | 132 | Goods receipt |
| Co-product* | - | - | C | 531 | Receipt by-product |
| Co-product* | - | - | C | 532 | RE by-product |
| By-product** | - | - | ≠C | 531 | Receipt by-product |
| By-product** | - | - | ≠C | 532 | RE by-product |
*Co-product is produced along with with the main product and carries equal importance**By-product is an output from a production process which can be useful/sellable or only waste. It is not a planned product
Sub Contracting
Sub Contracting Production = Sub Contractor Production MM + Sub Contractor Production PP + Sub Contractor Co-product Production + Sub Contractor By-product Production
| Quantity/Value | movement indicator | subcontracting flag | material co-product | Item category in purchasing document | special stock indicator | Movement Type | Description |
|---|---|---|---|---|---|---|---|
| Sub Contractor MM | B (movement for a purchase order) | - | - | 3 (subcontracting) | ≠K (not equal to Consignment (vendor)) | 101 | GR goods receipt |
| Sub Contractor MM | B (movement for a purchase order) | - | - | 3 (subcontracting) | ≠K (not equal to Consignment (vendor)) | 102 | GR for PO reversal |
| Sub Contractor MM | B (movement for a purchase order) | - | - | 3 (subcontracting) | ≠K (not equal to Consignment (vendor)) | 131 | Goods receipt |
| Sub Contractor MM | B (movement for a purchase order) | - | - | 3 (subcontracting) | ≠K (not equal to Consignment (vendor)) | 132 | Goods receipt |
| Sub Contractor PP | F (movement for a work order) | S | - | - | - | 101 | GR goods receipt |
| Sub Contractor PP | F (movement for a work order) | S | - | - | - | 102 | GR for PO reversal |
| Sub Contractor PP | F (movement for a work order) | S | - | - | - | 131 | Goods receipt |
| Sub Contractor PP | F (movement for a work order) | S | - | - | - | 132 | Goods receipt |
| Sub Contractor Co-product | - | - | C | - | - | 545 | Rcpt SC by-product |
| Sub Contractor Co-product | - | - | C | - | - | 546 | GI issue SC by-prod. |
Sub Contractor By-product | - | - | ≠C | - | - | 545 | Rcpt SC by-product |
| Sub Contractor By-product | - | - | ≠C | - | - | 546 | GI issue SC by-prod. |
Neutralized Production (LIP00)
Neutralized Production (LIP00) = Principal + Co-Product + By-product + Sub Contractor PP + Sub Contractor Co-product + Sub Contractor By-product - Global Consumption - Neutralized Consumption (LIP00)
| Quantity/Value | Movement Type | Description |
|---|---|---|
| Neutralized Consumption (LIP00) | 261 | GI for order |
| Neutralized Consumption (LIP00) | 262 | RE for order |
| Neutralized Consumption (LIP00) | 543 | GI issue sls.ord.st. |
| Neutralized Consumption (LIP00) | 544 | GI receipt sls.or.st |
Transfer Debit
| Quantity/Value | Debit/credit indicator | Movement Type | Description |
|---|---|---|---|
Transfer Debit | S (debit) | 311 | TF tfr. within plant |
| Transfer Debit | S (debit) | 323 | TF quality in plant |
| Transfer Debit | S (debit) | 325 | TF blocked in plant |
Transfer Credit
| Quantity/Value | Debit/credit indicator | Movement Type | Description |
|---|---|---|---|
Transfer Credit | H (credit) | 311 | TF tfr. within plant |
| Transfer Credit | H (credit) | 323 | TF quality in plant |
| Transfer Credit | H (credit) | 325 | TF blocked in plant |