MM Report Custom development ALV report Textile and Apparel

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

  • MB51 Material Document List. Lists movements per batch; no balance by certificate type, no yield and no quota calculation.
  • MSC3N Display Batch. Shows the characteristics and certificate data of one batch; no batch chain and no mass balance.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
MSEGMaterial Document ItemReceipt (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 HeaderPosting date of the movementMKPF-MBLNR = MSEG-MBLNR AND MKPF-MJAHR = MSEG-MJAHRECC only
MCHABatches (Plant Level)Batch masterMCHA-MATNR = MSEG-MATNR AND MCHA-WERKS = MSEG-WERKS AND MCHA-CHARG = MSEG-CHARGECC + S/4
AUSPCharacteristic Values of ObjectsCertificate type, certificate and transaction certificate number (batch characteristics)AUSP-OBJEK = INOB-CUOBJ AND AUSP-KLART = '023'ECC + S/4
CABNCharacteristicsInternal number of the certificate characteristicsCABN-ATINN = AUSP-ATINNECC + S/4
AFPOOrder ItemProduction order item and the finished batch it producedAFPO-AUFNR = MSEG-AUFNRECC + S/4
LIPSDelivery Item DataDelivery items of the certified finished batchLIPS-MATNR = AFPO-MATNR AND LIPS-CHARG = AFPO-CHARGECC + S/4
LIKPDelivery HeaderDelivery header: customer and goods issue dateLIKP-VBELN = LIPS-VBELNECC + S/4
I_BatchBatch InformationIn S/4HANA it can be read for batch data with a clean core approachMaterial = MSEG-MATNR AND Batch = MSEG-CHARGS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleMSEG-WERKSYes1000
S_BUDATPeriod (posting date)Range / multipleMKPF-BUDATYes01.07.2026 – 30.09.2026
P_CERTCertificate type (batch characteristic value)Single valueAUSP-ATWRTYesORGANIK
S_MATNRRaw materialRange / multipleMSEG-MATNRNoIP-3020
P_YIELDYield rate (%)Single value—No92
R_CHAINBatch chain viewRadio button—NoX
R_SUMMMass balance summaryRadio button—No—

Output columns

#ColumnSource
1Certificate typeCalculated AUSP-ATWRT, certificate type characteristic
2Transaction certificate no.Calculated AUSP-ATWRT, transaction certificate characteristic
3Raw material batchMSEG-CHARG
4Raw materialMSEG-MATNR
5Received quantityCalculated Σ movement 101 (in the period)
6VendorMSEG-LIFNR
7Production orderAFPO-AUFNR
8ConsumptionCalculated Σ 261 − Σ 262
9Finished batchAFPO-CHARG
10DeliveryLIPS-VBELN
11Quantity soldLIPS-LFIMG
12Balance statusCalculated Compliant if sold ≤ consumption × yield, otherwise quota exceeded

Sample output

Certificate typeTransaction certificate no.Raw material batchRaw materialReceived quantityVendorProduction orderConsumptionFinished batchDeliveryQuantity soldBalance status
Organic cottonTC-2026-00418L2609-14IP-302012,00010091510004129,800F2610-03800129448,900Compliant
Organic cottonTC-2026-00418L2609-14IP-3020010091510004372,200F2610-11800130102,100Quota exceeded (76 KG)
Recycled polyesterTC-2026-00502L2610-05IP-44105,00010102210004413,100F2611-010Compliant; finished goods in stock
A view built with fictional sample data; not real system data.

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.

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

MM Report Custom ALV report ChemicalsFood and Beverage

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, …

MCHB · MCHA · MARA · MAKT

MM Report Custom ALV report

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, …

MARD · MARA · MAKT · MBEW

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.

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