Certified Raw Material (Organic or Sustainable Cotton etc.) Traceability and Mass Balance Report
Short answer: A custom ALV report that traces the receipt of certified raw material such as organic, recycled or sustainable cotton, its consumption in production, the output of certified finished goods and their shipment to customers with batch and certificate data, and gives the period mass balance of receipts, consumption and sales. The quantity evidence and transaction certificate references requested in certification audits are prepared from one list.
- Estimated effort
- L · 10–15 working days
- System
- ECC and S/4HANA
- Tables
- 10
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
In the standard system the batch where-used list and MB51 show where a single batch went, but there is no report that adds up all receipts, consumptions, certified production output and sales of a period by certificate type and calculates the certified saleable quantity with a yield rate. The certificate number and the supplier's transaction certificate are usually kept in batch characteristics and do not show in standard movement lists. The custom report builds this chain and the mass balance on one screen.
Who uses it? Sustainability and certification managers, quality, production planning and sales teams.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| MSEGMaterial Document Item | Receipt (101), consumption (261/262) and sales (601) movements (driving table) | — | ECC only |
| MATDOCMaterial Documents (S/4HANA) | In S/4HANA all movements are read from this table | — | S/4HANA only |
| MKPFMaterial Document Header | Posting date of the movement | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC only |
| MCHABatches (Plant Level) | Batch master | MCHA-MATNR = MSEG-MATNR AND MCHA-WERKS = MSEG-WERKS AND MCHA-CHARG = MSEG-CHARG | ECC + S/4 |
| AUSPCharacteristic Values of Objects | Certificate type, certificate and transaction certificate number (batch characteristics) | AUSP-OBJEK = INOB-CUOBJ AND AUSP-KLART = '023' | ECC + S/4 |
| CABNCharacteristics | Internal number of the certificate characteristics | CABN-ATINN = AUSP-ATINN | ECC + S/4 |
| AFPOOrder Item | Production order item and the finished batch it produced | AFPO-AUFNR = MSEG-AUFNR | ECC + S/4 |
| LIPSDelivery Item Data | Delivery items of the certified finished batch | LIPS-MATNR = AFPO-MATNR AND LIPS-CHARG = AFPO-CHARG | ECC + S/4 |
| LIKPDelivery Header | Delivery header: customer and goods issue date | LIKP-VBELN = LIPS-VBELN | ECC + S/4 |
| I_BatchBatch Information | In S/4HANA it can be read for batch data with a clean core approach | Material = MSEG-MATNR AND Batch = MSEG-CHARG | S/4HANA only |
S/4HANA notes
- MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
- MKPF → MATDOC: In S/4HANA new material documents are written to MATDOC; reading MKPF works through a compatibility view. Use MATDOC or I_MaterialDocumentItem_2 directly in new reports.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MSEG-WERKS | Yes | 1000 |
| S_BUDAT | Period (posting date) | Range / multiple | MKPF-BUDAT | Yes | 01.07.2026 – 30.09.2026 |
| P_CERT | Certificate type (batch characteristic value) | Single value | AUSP-ATWRT | Yes | ORGANIK |
| S_MATNR | Raw material | Range / multiple | MSEG-MATNR | No | IP-3020 |
| P_YIELD | Yield rate (%) | Single value | — | No | 92 |
| R_CHAIN | Batch chain view | Radio button | — | No | X |
| R_SUMM | Mass balance summary | Radio button | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Certificate type | Calculated AUSP-ATWRT, certificate type characteristic |
| 2 | Transaction certificate no. | Calculated AUSP-ATWRT, transaction certificate characteristic |
| 3 | Raw material batch | MSEG-CHARG |
| 4 | Raw material | MSEG-MATNR |
| 5 | Received quantity | Calculated Σ movement 101 (in the period) |
| 6 | Vendor | MSEG-LIFNR |
| 7 | Production order | AFPO-AUFNR |
| 8 | Consumption | Calculated Σ 261 − Σ 262 |
| 9 | Finished batch | AFPO-CHARG |
| 10 | Delivery | LIPS-VBELN |
| 11 | Quantity sold | LIPS-LFIMG |
| 12 | Balance status | Calculated Compliant if sold ≤ consumption × yield, otherwise quota exceeded |
Sample output
| Certificate type | Transaction certificate no. | Raw material batch | Raw material | Received quantity | Vendor | Production order | Consumption | Finished batch | Delivery | Quantity sold | Balance status |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Organic cotton | TC-2026-00418 | L2609-14 | IP-3020 | 12,000 | 100915 | 1000412 | 9,800 | F2610-03 | 80012944 | 8,900 | Compliant |
| Organic cotton | TC-2026-00418 | L2609-14 | IP-3020 | 0 | 100915 | 1000437 | 2,200 | F2610-11 | 80013010 | 2,100 | Quota exceeded (76 KG) |
| Recycled polyester | TC-2026-00502 | L2610-05 | IP-4410 | 5,000 | 101022 | 1000441 | 3,100 | F2611-01 | 0 | Compliant; finished goods in stock |
How does the report work?
- Certified batches are found from the certificate type and certificate number characteristics in batch classification (AUSP, CABN); the certificate type is entered on the selection screen.
- Receipts: goods receipts (101) of these batches in the period are read from MSEG with vendor and transaction certificate number.
- Consumption: issues (261) and returns (262) of the batches to production orders are read from MSEG; the production order is read from AFPO and the finished batches it produced (101 with order reference) are marked as certified output.
- Sales: deliveries of certified finished batches are read from LIPS and goods issues (601) from MSEG; customer and delivery number come from LIKP.
- Mass balance: opening certified stock + receipts − consumption = closing raw material stock; consumption × yield rate = certified saleable finished quota. If the certified quantity sold exceeds the quota, the line is flagged.
- In the batch chain view the report shows the link from raw material batch to customer delivery; the summary view gives the balance per certificate type and period.
Performance notes
First find the batches with a filled certificate characteristic in AUSP and read MSEG only for these batches and the period. For the production order link, read AFPO in bulk by order number; in S/4HANA the movement totals can be calculated in the database on MATDOC.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document From the batch you can drill down to the material document, production order and delivery.
- Export to Excel The period balance is exported to Excel for the audit.
- Runs as a background job
Authorization objects
- M_MSEG_WMBMaterial document display authorization by plant
- C_TCLA_BKAClassification display authorization by class type
Frequently asked questions
Which certification programs can it be used for?
The report is not tied to one standard; it is used for programs that require a mass balance or segregation, such as organic content, recycled content and sustainable cotton. The certificate type, yield rate and quota rule are kept as settings.
What if certified and non-certified raw material are used in the same order?
The report shows certified and non-certified quantities issued to the order separately and calculates the certified share proportionally. For programs that require segregation, mixed orders are flagged separately so it is clear whether the finished goods may be sold as certified.
Does it work on S/4HANA?
Yes. In S/4HANA movements are read directly from MATDOC and batch classification stays in AUSP. If clean core is preferred, batch data can be read from I_Batch and movements from I_MaterialDocumentItem_2.
Related reports
Batch Shelf Life Tracking Report (Batches Close to Expiry)
A custom ALV report that lists batches close to or past their expiry date with remaining days, remaining shelf life percentage and stock value. Food, …
Stock Aging Report
A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …
Customer Complaints Traced to Delivery, Batch and Inspection Lot Report
A custom ALV report that shows customer complaint notifications on the same line as the delivery, the batch, the inspection lot of that batch, its …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.