Textile Article Master Data Setup Screen and Technical Analysis Sheet (Yarn, Fabric, Design, Colour)
Short answer: A custom app where width, weight, warp and weft density, yarns, design and colour are entered on one screen when a new fabric or carpet quality is opened. The material, its alternative units, the classification and a BOM with yarn consumption calculated from the construction are created in one save; the technical analysis sheet is printed from the same data.
- Estimated effort
- L · 12–16 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
In the standard system the material is created view by view in MM01, the classification on a separate screen and the yarn BOM in CS01; yarn consumption is usually calculated in Excel and the technical analysis sheet is kept outside SAP. This leads to inconsistent master data between qualities and wrong costs. The app calculates consumption from the construction and creates all objects together.
Who uses it? Product development and design teams, technical management, master data and costing teams.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| MARAGeneral Material Data | New quality: material type, base unit, width | Write | ECC + S/4 |
| MAKTMaterial Descriptions | Quality description | Write | ECC + S/4 |
| MARCPlant Data for Material | Plant view | Write | ECC + S/4 |
| MARMUnits of Measure for Material | M2 and KG alternative unit factors | Write | ECC + S/4 |
| KLAHClass Header Data | Material class holding the quality construction | Read | ECC + S/4 |
| CABNCharacteristics | Definition of the construction characteristics (width, weight, density, design, colour) | Read | ECC + S/4 |
| AUSPCharacteristic Values of Objects | Characteristic values of the quality | Write | ECC + S/4 |
| STKOBOM Header | Yarn BOM header | Write | ECC + S/4 |
| STPOBOM Item | Yarn items and calculated consumption | Write | ECC + S/4 |
BAPIs and functions used
- BAPI_MATERIAL_SAVEDATACreate and change material master data. Creates the material, plant view and alternative units
- BAPI_OBJCL_CREATEClassification: Create Object Assignment. Writes the construction characteristics to the material class
- CSAP_MAT_BOM_CREATECreate Material BOM. Creates the yarn BOM with the calculated consumption
- SSF_FUNCTION_MODULE_NAMEGet Smart Form Function Module Name. Calls the technical analysis sheet form
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_WERKS | Plant | Single value | MARC-WERKS | Yes | 1000 |
| P_MTART | Material type | Single value | MARA-MTART | Yes | FERT |
| P_CLASS | Construction class | Single value | KLAH-CLASS | Yes | TEKSTIL_YAPI |
| P_REFMAT | Reference quality (for copying) | Single value | MARA-MATNR | No | KMS-24017 |
| P_PRINT | Print the technical analysis sheet after saving | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Quality code | MARA-MATNR | Yes |
| 2 | Description | MAKT-MAKTX | Yes |
| 3 | Base unit | MARA-MEINS | Yes |
| 4 | Width (cm) | MARA-BREIT | Yes |
| 5 | Weight (g/m²) | AUSP-ATFLV | Yes |
| 6 | Warp density (ends/cm) | AUSP-ATFLV | No |
| 7 | Weft density (picks/cm) | AUSP-ATFLV | No |
| 8 | Yarn | STPO-IDNRK | Yes |
| 9 | Use | By rule Warp, weft or pile | No |
| 10 | Yarn count | By rule Nm, Ne or dtex; converted to Nm for the calculation | No |
| 11 | Design number | AUSP-ATWRT | No |
| 12 | Colour | AUSP-ATWRT | No |
Sample upload file
| 1 | Quality code * | Description * | Base unit * | Width (cm) * | Weight (g/m²) * | Warp density (ends/cm) | Weft density (picks/cm) | Yarn * | Use | Yarn count | Design number | Colour |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | KMS-24031 | Chenille upholstery fabric 330 g/m² | M | 140 | 330 | 28 | 22 | IP-PES-NM60 | Warp | Nm 60 | D-3108 | Anthracite |
| 3 | KMS-24031 | Chenille upholstery fabric 330 g/m² | M | 140 | 330 | 28 | 22 | IP-SNL-NM8 | Weft | Nm 8 | D-3108 | Anthracite |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Quality | MARA-MATNR |
| 2 | Plant | MARC-WERKS |
| 3 | Yarn | STPO-IDNRK |
| 4 | Calculated consumption (kg/m) | Calculated Yarn length (m/m) / Nm / 1000 |
| 5 | Calculated weight (g/m²) | Calculated Σ yarn consumption (kg/m) × 1000 / width (m) |
| 6 | Status | Calculated Created, warning or error |
| 7 | Message | Calculated Check or function return message |
Sample result list
| Quality | Plant | Yarn | Calculated consumption (kg/m) | Calculated weight (g/m²) | Status | Message |
|---|---|---|---|---|---|---|
| KMS-24031 | 1000 | IP-PES-NM60 | 0.07 | 333.70 | Created | Warp: 3,920 ends × 1.08 take-up |
| KMS-24031 | 1000 | IP-SNL-NM8 | 0.40 | 333.70 | Created | Weft: 2,200 picks × 1.40 m × 1.03 |
| KMS-24032 | 1000 | IP-SNL-NM8 | 0.40 | 0 | Error | Weight characteristic is missing |
How does the program work?
- Optionally the user picks a reference quality; values are copied from MARA, MAKT, AUSP and the BOM (STKO/STPO).
- The construction is entered: width (cm), weight (g/m²), warp and weft density (threads/cm), for each yarn its use (warp/weft/pile), yarn count (Nm, Ne or dtex), take-up, design number and colour variants. The characteristics come from the material class definition (KLAH, CABN).
- Yarn consumption is calculated: for warp, yarn length = density × width (cm) × (1 + take-up) metres per metre of fabric; for weft = weft density × 100 × width (m) × (1 + selvedge allowance). Weight (kg/m) = length / Nm / 1000; Ne and dtex counts are converted to Nm first.
- Save: BAPI_MATERIAL_SAVEDATA creates the material (base unit M, alternative units M2 and KG in MARM) and the plant view (MARC); BAPI_OBJCL_CREATE writes the construction characteristics to the material class (class type 001, AUSP); CSAP_MAT_BOM_CREATE creates the yarn BOM with the calculated consumption.
- Colour variants are kept either as separate materials (quality + colour suffix) or with variant configuration, according to the method chosen during setup.
- The technical analysis sheet (construction, yarns, consumption, weight check) is printed as a Smart Form or stored as PDF.
Performance notes
Read the characteristic definitions (CABN) and the class structure once when the screen opens. On save, run the material, classification and BOM calls in the same logical unit of work; if one fails, save none of them.
Features
- Line-by-line result and error log The results for material, classification and BOM appear in one list.
- Double-click drill-down to the document The material and BOM display screens open from the created quality.
Authorization objects
- M_MATE_MARMaterial create authorization by material type
- M_MATE_WRKMaterial authorization by plant
- C_KLAH_BKLClassification maintenance authorization
- C_STUE_WRKBOM create authorization by plant
Frequently asked questions
What if the calculated weight differs from the weight entered?
The app shows both values side by side and warns if the difference exceeds the configured percentage. This catches a wrong yarn count or density before the material is created; the user corrects the values and recalculates.
Can it be used with variant configuration?
Yes. If a configurable material is used instead of separate materials for colour and design variants, the app writes the characteristic values to fit the configuration profile. The method is chosen during setup.
Does it work on S/4HANA?
Yes. BAPI_MATERIAL_SAVEDATA and the classification and BOM functions are also used on S/4HANA, where material numbers of up to 40 characters are supported. The front end is built as a Fiori app.
Related reports
Mass Material Master Upload Program
A custom program that creates or updates material master data in bulk from Excel or CSV rows, including the basic data, plant and valuation views. It …
Materials Missing Required Views by Plant Report (S/4HANA Migration Check)
A custom ALV report that shows, on one row per material and plant, which of the purchasing, MRP, accounting, storage and sales views are missing for …
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 …
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.