Rohstoffe (Raw material)
- Sami Abbas (Unlicensed)
- Daniela Ludwig
The information about the raw materials of an article refers to the material of a product. For the master data server, the price-relevant raw materials of a product should be transferred. Multiple raw materials with detailed information can be specified per article.
Content | Description | Structure |
Material | Raw material to which the information refers | Indication according to the code list https://itek-branchenwissen.atlassian.net/wiki/x/jYNbY |
Weight basis | Total weight of the article/product. | Decimal number |
Base unit | Unit of weight as specified in the value list | Indication according to the code list English DQR 10.0 Units (Mengeneinheiten) |
Weight percentage | Weight percentage of the specified raw material, e.g., percentage | Decimal number |
Share unit | Share unit of the raw material | Indication according to the code list English DQR 10.0 Units (Mengeneinheiten) |
Raw material quotation | Raw material quotation with which the price was calculated: each based on 100 kilograms of the raw material. | Decimal number |
Example raw material details
Length: 50 meters
Price: 10,000.00€ per 1,000 meters
Copper weight: 96 kilograms per 100 meters
Calculated price based on copper price: 150.00€ per 100 kilograms
Current copper price: 300€ per 100 kilograms
Discount: 10%
Transferred data:
Data Content | Example |
Inquiry/Quotation Quantity (AM) | 50 |
Inquiry/Quotation Quantity Unit (AME) | “MTR" for Meters |
Quotation Price (AP) | 10000 |
Net Price (NP) | 522 |
Price Basis (PB) | 1000 |
Raw Material (R) | "CU" for Copper |
Weight Percentage Value (GAW) | 96 |
Weight Percentage Unit (GAE) | “KGM" for Kilograms |
Base Value (BW) | 100 |
Base Unit (BE) | "MTR" for Meters |
Base DEL Quotation per 100 Kilograms (BN) | 150 |
Current DEL Quotation per 100 (AN) | 300 |
Discount (R) | 10,00% |
Calculation
Copper Surcharge (KZ) = AM * (GAW / BW) * (AN - BN)
= 50 m * (96 kg / 100 m) * ((300 € / 100 kg) – (150 € / 100 kg))
= 72 €
Net Price (NP) = (AM * (AP / PB) – R + KZ )
= (50 m * ((10.000 € / 1000 m ) -1.000 € / 1000 m))+ 72 €
= 50 m * (9.000 € / 1.000 m) +72 €
= 522 €