Dye Lot (Shade) Consistency Check Report for Outbound Deliveries
Short answer: A custom ALV report that reads from batch classification which dye lot (shade) each fabric roll on an outbound delivery comes from, and flags sales order items that receive rolls from more than one dye lot. Shipping teams see mixed-shade deliveries before goods issue, swap the rolls, and returns caused by shade differences go down.
- Estimated effort
- M · 5–7 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Standard batch determination can propose batches with given characteristic values through a selection class, but it does not check whether rolls sent to the same order item in different deliveries come from the same dye lot, and it does not catch batches that were changed manually. VL06O shows deliveries and MSC3N shows the characteristics of one batch; no screen combines the two and lists mixed shades. The custom report joins delivery batches with the dye lot characteristic, compares them with shades already shipped and lists the deviations in one place.
Who uses it? Shipping and warehouse teams, sales operations, quality assurance and customer service representatives.
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 |
|---|---|---|---|
| LIKPDelivery Header | Delivery header: shipping point, planned goods issue, ship-to party (driving table) | — | ECC + S/4 |
| LIPSDelivery Item Data | Delivery items: material, batch (roll), quantity and order reference | LIPS-VBELN = LIKP-VBELN | ECC + S/4 |
| KNA1Customer Master (General Section) | Customer name | KNA1-KUNNR = LIKP-KUNNR | ECC + S/4 |
| INOBLink Between Internal Number and Object | Link between batch and classification object (class type 023) | INOB-OBJEK = parti nesne anahtarı (malzeme + parti) AND INOB-KLART = '023' | ECC + S/4 |
| AUSPCharacteristic Values of Objects | Dye lot (shade) characteristic value | AUSP-OBJEK = INOB-CUOBJ AND AUSP-ATINN = CABN-ATINN | ECC + S/4 |
| CABNCharacteristics | Translation of the characteristic name to its internal number | CABN-ATNAM = P_ATNAM | ECC + S/4 |
| VBFASales Document Flow | Earlier deliveries for the same order item | VBFA-VBELV = LIPS-VGBEL AND VBFA-POSNV = LIPS-VGPOS | ECC + S/4 |
| I_DeliveryDocumentItemDelivery Document Item | In S/4HANA it can replace LIPS with a clean core approach | DeliveryDocument = LIPS-VBELN | S/4HANA only |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_VSTEL | Shipping point | Range / multiple | LIKP-VSTEL | Yes | 1000 |
| S_WADAT | Planned goods issue date | Range / multiple | LIKP-WADAT | No | 17.11.2026 – 21.11.2026 |
| S_KUNNR | Ship-to party | Range / multiple | LIKP-KUNNR | No | 200145 |
| S_VBELN | Delivery | Range / multiple | LIKP-VBELN | No | — |
| P_ATNAM | Dye lot (shade) characteristic | Single value | CABN-ATNAM | Yes | DYE_LOT |
| P_GI | Also show deliveries with goods issue posted | Checkbox | — | No | — |
| P_DEV | Only lines with deviations | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Delivery | LIKP-VBELN |
| 2 | Planned goods issue | LIKP-WADAT |
| 3 | Customer name | KNA1-NAME1 |
| 4 | Sales order | LIPS-VGBEL |
| 5 | Order item | LIPS-VGPOS |
| 6 | Material | LIPS-MATNR |
| 7 | Batch (roll no.) | LIPS-CHARG |
| 8 | Quantity | LIPS-LFIMG |
| 9 | Unit | LIPS-VRKME |
| 10 | Dye lot (shade) | AUSP-ATWRT |
| 11 | Dye lots in order item | Calculated Number of distinct dye lot values across all delivery batches of the order item |
| 12 | Shade already shipped | Calculated Dye lot values read from the batches of earlier deliveries in VBFA |
| 13 | Status | Calculated Consistent / Mixed shades / No shade value |
Sample output
| Delivery | Planned goods issue | Customer name | Sales order | Order item | Material | Batch (roll no.) | Quantity | Unit | Dye lot (shade) | Dye lots in order item | Shade already shipped | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80041210 | 11/18/2026 | Örnek Tekstil A.Ş. | 1200345 | 10 | KM-PNY-220-LAC | T26110452 | 182.50 | M | BP-2611-07 | 1 | Consistent | |
| 80041211 | 11/18/2026 | Demo Moda Ltd. | 1200351 | 20 | KM-SAT-150-SYH | T26110517 | 96 | M | BP-2611-12 | 2 | BP-2610-31 | Mixed shades |
| 80041211 | 11/18/2026 | Demo Moda Ltd. | 1200351 | 20 | KM-SAT-150-SYH | T26110521 | 104 | M | BP-2611-12 | 2 | BP-2610-31 | Mixed shades |
| 80041225 | 11/19/2026 | Anadolu Konfeksiyon A.Ş. | 1200362 | 10 | KM-KTN-180-BEJ | T26110608 | 150 | M | 0 | No shade value |
How does the report work?
- LIKP is read by shipping point, planned goods issue date, delivery and ship-to party; depending on the selection, deliveries with goods issue already posted are included or left out.
- Batch items are taken from LIPS. In deliveries with batch split, the sub-items are linked to the order reference (VGBEL, VGPOS) of their higher-level item.
- For each batch the batch classification object (class type 023) is found in INOB; the dye lot characteristic given on the selection screen is converted to its internal number via CABN and its value is read from AUSP.
- Earlier deliveries for the same order item are found via VBFA and the dye lots already shipped are collected.
- The number of distinct dye lots per order item is calculated. If there is more than one, or the lot on the new delivery differs from what was already shipped, the line is flagged “Mixed shades”; if the characteristic is empty it is flagged “No shade value”.
- The ALV is sorted by shipping point and delivery; optionally only lines with deviations are shown.
Performance notes
Limit the LIKP selection by shipping point and date range. Read INOB and AUSP once with the selected batch keys via FOR ALL ENTRIES and determine the internal characteristic number (ATINN) only once. Read VBFA only for the selected order items.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the delivery opens VL03N; double-clicking the batch opens MSC3N.
- Export to Excel
- Runs as a background job
- Send the result by email Every morning the mixed-shade lines on deliveries due for loading can be sent to the shipping lead.
Authorization objects
- V_LIKP_VSTDelivery display authorization by shipping point
- C_TCLA_BKAAuthorization to read batch classification (class type 023)
Frequently asked questions
Which field holds the dye lot?
By default it is read from a characteristic in batch classification; the characteristic name is given on the selection screen. If the dye lot is kept in part of the batch number or in the vendor/manufacturer batch number, the report reads that field instead.
Can goods issue be blocked for a mixed-shade delivery?
On its own the report only informs. The same check can be moved into an enhancement that runs when the delivery is saved and raises a warning or an error for mixed shades; this adds 2–3 days to the estimate.
Does it work on S/4HANA?
Yes. LIKP, LIPS, VBFA and the batch classification tables are the same in S/4HANA. If clean core is preferred, delivery items can be read via I_DeliveryDocumentItem.
Related reports
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 …
On-Time In-Full (OTIF) Delivery Performance Report by Customer
A custom ALV report that compares every sales order item with the customer's requested delivery date and ordered quantity, and works out whether the …
Picked but Not Goods-Issued Deliveries Report
A custom ALV report that lists deliveries whose picking is complete but whose goods issue has not been posted, with the number of days they have been …
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.