PP Program Custom development Mass upload Textile and Apparel

Dyeing and Finishing Recipe Versioned Upload and Management Program

Short answer: A custom program that loads lab-approved dyeing and finishing recipes (dyestuffs, chemicals, concentrations, liquor ratio) into SAP as bills of material per colour, versioned with a change number. Every recipe change becomes a new dated version; production orders take the recipe valid on that day and the old recipe stays in the history.

Estimated effort
M · 7–10 working days
System
ECC and S/4HANA
Tables
6
Scope
Global · 1 industries
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

CS01/CS02 maintain the bill of material manually, item by item; they do not convert concentrations (% on weight of fabric or g/l) into quantities for the base quantity and do not show the difference between the old and new recipe. Recipes from the lab therefore often stay outside SAP, and costing and stock consumption do not reflect reality. The program calculates the recipe and loads it with a difference list and a change number.

Who uses it? Dye house and finishing supervisors, colour lab, production master data and costing teams.

Closest standard alternatives

  • CS02 Change Material BOM. Changes the BOM manually; no concentration calculation and no difference upload from a file.
  • CS01 Create Material BOM. Creates a new BOM item by item; no bulk transfer from the lab recipe.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
MASTMaterial to BOM LinkMaterial-to-BOM link; created with the first recipeRead / writeECC + S/4
STKOBOM HeaderBOM header: alternative, base quantity, validityWriteECC + S/4
STPOBOM ItemRecipe items: dyestuff and chemical quantitiesWriteECC + S/4
AENRChange MasterChange number and validity date for versioningReadECC + S/4
MKALProduction Versions of MaterialCheck that the production version points to the right alternativeReadECC + S/4
MARAGeneral Material DataComponent existence and deletion flag checkReadECC + S/4

BAPIs and functions used

  • CSAP_MAT_BOM_CREATECreate Material BOM. Creates the first BOM for a colour without a recipe
  • CSAP_MAT_BOM_READDisplay Material BOM. Reads the valid recipe version for the difference list
  • CSAP_MAT_BOM_MAINTAINMaintain Material BOM. Saves the new recipe version with the change number

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
P_FILERecipe file (XLSX or CSV)Single value—YesC:\temp\recete_2026-11.xlsx
P_WERKSPlantSingle valueMAST-WERKSYes1000
P_STLANBOM usageSingle valueMAST-STLANYes1
P_AENNRChange numberSingle valueAENR-AENNRYes500000000412
P_TESTTest mode (difference list only)Checkbox—NoX

Input file columns

The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.

#ColumnTarget fieldRequired
1Colour / product materialMAST-MATNRYes
2AlternativeSTKO-STLALNo
3Base quantitySTKO-BMENGYes
4Base unitSTKO-BMEINYes
5Lab recipe no.By rule Recipe number from the lab system; written to the BOM header textNo
6Component (dyestuff/chemical)STPO-IDNRKYes
7ConcentrationBy rule Value in % on weight of fabric or g/lNo
8Concentration typeBy rule OWF (% on weight of fabric) or GL (g/l)No
9Liquor ratioBy rule Fabric to bath ratio, e.g. 1:8No
10Component unitSTPO-MEINSYes
11Valid fromAENR-DATUVYes

Sample upload file

1Colour / product material *AlternativeBase quantity *Base unit *Lab recipe no.Component (dyestuff/chemical) *ConcentrationConcentration typeLiquor ratioComponent unit *Valid from *
2BYK-NAVY-11801100KGLAB-26-0418DYE-RB-2211.85OWF1:8KG12/01/2026
3BYK-NAVY-11801100KGLAB-26-0418DYE-YL-1140.42OWF1:8KG12/01/2026
4BYK-NAVY-11801100KGLAB-26-0418CHM-SALT-0160GL1:8KG12/01/2026
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1RowCalculated Row number in the file
2MaterialMAST-MATNR
3AlternativeSTKO-STLAL
4ComponentSTPO-IDNRK
5Old quantityCalculated STPO-MENGE in the valid version
6New quantitySTPO-MENGE
7Change numberAENR-AENNR
8StatusCalculated Added, changed, unchanged, removed or error
9MessageCalculated Check or function return message

Sample result list

RowMaterialAlternativeComponentOld quantityNew quantityChange numberStatusMessage
2BYK-NAVY-11801DYE-RB-2211.721.85500000000412ChangedConcentration raised from 1.72% to 1.85%
3BYK-NAVY-11801DYE-YL-1140.420.42500000000412Unchanged
4BYK-NAVY-11801CHM-SALT-014048500000000412Changed60 g/l × liquor 1:8 → 48 kg per 100 kg fabric
BYK-NAVY-11801DYE-RD-3050.080500000000412RemovedNot part of the new recipe
A view built with fictional sample data; not real system data.

How does the program work?

  1. The file exported from the lab or dye dispensing system is read: colour/product material, recipe number, dyestuffs and chemicals, concentration and its type (% on weight of fabric or g/l), liquor ratio.
  2. Concentrations are converted into quantities for the BOM base quantity (e.g. 100 kg fabric): for % on weight of fabric, quantity = base × % / 100; for g/l, quantity = base × liquor ratio × g/l / 1000.
  3. The components are checked to exist in MARA without a deletion flag; the change number given must be open and valid in AENR.
  4. If the material has no BOM in MAST, CSAP_MAT_BOM_CREATE creates the first alternative. If it has one, CSAP_MAT_BOM_READ reads the valid version, a difference list (added, removed, changed components) is prepared and CSAP_MAT_BOM_MAINTAIN saves the new version under the change number with its validity date.
  5. If colour variants are kept as separate alternatives (STKO-STLAL), the program checks that the related production version (MKAL) points to that alternative and warns if not.
  6. In test mode only the difference list is shown; in a real run the result of every row is logged.

Performance notes

Read the materials and components in the file from MARA and MAST in one pass. Read the BOM of each colour material once and save all its lines in a single maintenance call; do not call per line.

Features

  • Test mode (check without posting) Test mode shows the old and new recipe side by side; nothing is saved.
  • Line-by-line result and error log
  • Download failed lines as a separate file
  • Export to Excel An empty upload template can be downloaded as Excel.

Authorization objects

  • C_STUE_WRKBOM change authorization by plant
  • C_STUE_BERAuthorization by BOM authorization group
  • C_AENR_BGRAuthorization to use the change number

Frequently asked questions

What if the liquor ratio differs by machine?

The quantity of chemicals given in g/l depends on the liquor ratio. A separate alternative can be kept per machine group, or the g/l chemicals can be recalculated with the machine's liquor ratio and order quantity when the production order is created. The second option needs extra development and is estimated separately.

Does it work for companies using PP-PI master recipes?

Yes. Components are still kept in the BOM and loaded the same way. If process parameters such as temperature and time should also be written to the master recipe, the scope grows; that part is assessed separately during setup.

How can older versions of a recipe be seen?

Each version is dated by its change number, so the old recipe is displayed in CS03 by choosing the validity date. The program also offers a report mode that lists all recipe versions of a material in date order.

Related reports

PP Program Custom Mass upload

Mass BOM Component Replacement Upload Program

A custom program that replaces, adds or deletes components or updates quantities in many material BOMs from Excel or CSV rows. Validity is set with a …

MAST · STKO · STPO · MARA

PP Program Custom Mass upload

Mass Routing Creation Upload Program from Excel

A custom program that creates material routings in bulk from operation rows in an Excel or CSV file, with header, operations, work centers, control …

MARC · CRHD · PLKO · MAPL

Let us build this program 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: Dyeing and Finishing Recipe Versioned Upload and Management Program