SD Report Custom development ALV report Textile and Apparel

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

  • VL06O Outbound Delivery Monitor. Lists deliveries by shipping point and date; it does not show the dye lot of the batches or check for mixed shades.
  • MSC3N Display Batch. Shows the characteristics of one batch; it does not compare them at delivery or order item level.

Tables used

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

TableRoleJoinSystem
LIKPDelivery HeaderDelivery header: shipping point, planned goods issue, ship-to party (driving table)—ECC + S/4
LIPSDelivery Item DataDelivery items: material, batch (roll), quantity and order referenceLIPS-VBELN = LIKP-VBELNECC + S/4
KNA1Customer Master (General Section)Customer nameKNA1-KUNNR = LIKP-KUNNRECC + S/4
INOBLink Between Internal Number and ObjectLink 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 ObjectsDye lot (shade) characteristic valueAUSP-OBJEK = INOB-CUOBJ AND AUSP-ATINN = CABN-ATINNECC + S/4
CABNCharacteristicsTranslation of the characteristic name to its internal numberCABN-ATNAM = P_ATNAMECC + S/4
VBFASales Document FlowEarlier deliveries for the same order itemVBFA-VBELV = LIPS-VGBEL AND VBFA-POSNV = LIPS-VGPOSECC + S/4
I_DeliveryDocumentItemDelivery Document ItemIn S/4HANA it can replace LIPS with a clean core approachDeliveryDocument = LIPS-VBELNS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_VSTELShipping pointRange / multipleLIKP-VSTELYes1000
S_WADATPlanned goods issue dateRange / multipleLIKP-WADATNo17.11.2026 – 21.11.2026
S_KUNNRShip-to partyRange / multipleLIKP-KUNNRNo200145
S_VBELNDeliveryRange / multipleLIKP-VBELNNo—
P_ATNAMDye lot (shade) characteristicSingle valueCABN-ATNAMYesDYE_LOT
P_GIAlso show deliveries with goods issue postedCheckbox—No—
P_DEVOnly lines with deviationsCheckbox—NoX

Output columns

#ColumnSource
1DeliveryLIKP-VBELN
2Planned goods issueLIKP-WADAT
3Customer nameKNA1-NAME1
4Sales orderLIPS-VGBEL
5Order itemLIPS-VGPOS
6MaterialLIPS-MATNR
7Batch (roll no.)LIPS-CHARG
8QuantityLIPS-LFIMG
9UnitLIPS-VRKME
10Dye lot (shade)AUSP-ATWRT
11Dye lots in order itemCalculated Number of distinct dye lot values across all delivery batches of the order item
12Shade already shippedCalculated Dye lot values read from the batches of earlier deliveries in VBFA
13StatusCalculated Consistent / Mixed shades / No shade value

Sample output

DeliveryPlanned goods issueCustomer nameSales orderOrder itemMaterialBatch (roll no.)QuantityUnitDye lot (shade)Dye lots in order itemShade already shippedStatus
8004121011/18/2026Örnek Tekstil A.Ş.120034510KM-PNY-220-LACT26110452182.50MBP-2611-071Consistent
8004121111/18/2026Demo Moda Ltd.120035120KM-SAT-150-SYHT2611051796MBP-2611-122BP-2610-31Mixed shades
8004121111/18/2026Demo Moda Ltd.120035120KM-SAT-150-SYHT26110521104MBP-2611-122BP-2610-31Mixed shades
8004122511/19/2026Anadolu Konfeksiyon A.Ş.120036210KM-KTN-180-BEJT26110608150M0No shade value
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. 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.
  4. Earlier deliveries for the same order item are found via VBFA and the dye lots already shipped are collected.
  5. 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”.
  6. 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

SD Report Custom ALV report

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 …

LIKP · VBUK · LIPS · KNA1

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: Dye Lot (Shade) Consistency Check Report for Outbound Deliveries