# Certified Raw Material (Organic or Sustainable Cotton etc.) Traceability and Mass Balance Report

> 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.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: L (10–15 working days)
- Industry: Textile and Apparel
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/certified-raw-material-traceability-and-mass-balance-report/


## 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.

### Closest standard alternatives

- MB51: Lists movements per batch; no balance by certificate type, no yield and no quota calculation.
- MSC3N: Shows the characteristics and certificate data of one batch; no batch chain and no mass balance.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MSEG | Receipt (101), consumption (261/262) and sales (601) movements (driving table) | Read | - | ECC only |
| MATDOC | In S/4HANA all movements are read from this table | Read | - | S/4HANA only |
| MKPF | Posting date of the movement | Read | MKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHR | ECC only |
| MCHA | Batch master | Read | MCHA-MATNR = MSEG-MATNR AND MCHA-WERKS = MSEG-WERKS AND MCHA-CHARG = MSEG-CHARG | ECC + S/4 |
| AUSP | Certificate type, certificate and transaction certificate number (batch characteristics) | Read | AUSP-OBJEK = INOB-CUOBJ AND AUSP-KLART = '023' | ECC + S/4 |
| CABN | Internal number of the certificate characteristics | Read | CABN-ATINN = AUSP-ATINN | ECC + S/4 |
| AFPO | Production order item and the finished batch it produced | Read | AFPO-AUFNR = MSEG-AUFNR | ECC + S/4 |
| LIPS | Delivery items of the certified finished batch | Read | LIPS-MATNR = AFPO-MATNR AND LIPS-CHARG = AFPO-CHARG | ECC + S/4 |
| LIKP | Delivery header: customer and goods issue date | Read | LIKP-VBELN = LIPS-VBELN | ECC + S/4 |
| I_Batch | In S/4HANA it can be read for batch data with a clean core approach | Read | Material = MSEG-MATNR AND Batch = MSEG-CHARG | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MSEG-WERKS | Yes |
| S_BUDAT | Period (posting date) | Range / multiple | MKPF-BUDAT | Yes |
| P_CERT | Certificate type (batch characteristic value) | Single value | AUSP-ATWRT | Yes |
| S_MATNR | Raw material | Range / multiple | MSEG-MATNR | No |
| P_YIELD | Yield rate (%) | Single value | - | No |
| R_CHAIN | Batch chain view | Radio button | - | No |
| R_SUMM | Mass balance summary | Radio button | - | No |

## Output columns

| Column | Source |
|---|---|
| Certificate type | Calculated: AUSP-ATWRT, certificate type characteristic |
| Transaction certificate no. | Calculated: AUSP-ATWRT, transaction certificate characteristic |
| Raw material batch | MSEG-CHARG |
| Raw material | MSEG-MATNR |
| Received quantity | Calculated: Σ movement 101 (in the period) |
| Vendor | MSEG-LIFNR |
| Production order | AFPO-AUFNR |
| Consumption | Calculated: Σ 261 − Σ 262 |
| Finished batch | AFPO-CHARG |
| Delivery | LIPS-VBELN |
| Quantity sold | LIPS-LFIMG |
| Balance status | Calculated: Compliant if sold ≤ consumption × yield, otherwise quota exceeded |

## How does the report work?

1. 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.
2. Receipts: goods receipts (101) of these batches in the period are read from MSEG with vendor and transaction certificate number.
3. 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.
4. Sales: deliveries of certified finished batches are read from LIPS and goods issues (601) from MSEG; customer and delivery number come from LIKP.
5. 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.
6. 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.

## Authorization objects

- M_MSEG_WMB: Material document display authorization by plant
- C_TCLA_BKA: Classification 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-certified-material-traceability
