Created new report based on Composite provider - CPMATCLS |
Description | BW -Material Master Key Information |
|---|---|
| Technical Name | BW_QRY_CPMATCLS_0001 |
Application | PM |
Info-provider | CPMATCLS |
Usage type | |
Expected users |
Workbook/Query General Description
Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display | Insert screenshot | |
| Rows/Columns | Insert screenshot | |
| Value Display | Insert screenshot | |
| Planning | Insert screenshot | |
| Extended | Insert screenshot |
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
| Cross-Distribution Material Status | V_C_MSTAV_001 | Selection option | No | Not Mandatory variable |
| Cross-Plant Material Status | V_C_MMSTA_001 | Selection option | No | Not Mandatory variable |
| Deletion flag for Material | V_C_DEL_FLAG_02 | Selection option | No | Not Mandatory variable |
| Material | V_C_MATNR2_0001 | Selection option | No | Not Mandatory variable |
| Division | V_DIVISION | Selection option | No | Not Mandatory variable |
| Material type | V_C_MAT_TYP_0001 | Selection option | No | Not Mandatory variable |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Ex : Status of the trading partner | Ex : <> 1 | Ex : Exclude intercompanies |
Add screenshot if relevant
Key figures
Key Figure 1
Description
Text/name of the variable and explanation
Calculation rule detail
Quantity x Price
Text Replacement Variable
If relevant, add the text replacement rule used for the key figure
Currency Conversion
Exchange Rate Type : Ex ZRH0
Currency : Variable, or fixed currency used
Time Reference : Current date / Based on infoobject X / Variable
Unit Conversion
Unit : Variable or fixed unit
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
Row | C_MATNR2 | Material | |
| Row | C_MAT_GRP | Material group | |
| Row | C_DIVISN | Division | |
| Row | 0BASIC_MATL | Basic Material | |
| Row | C_PEIND | Period Indicator for shelf life expiration date | |
| Row | 0DEL_FLAG | Deletion flag for Material | |
| Row | C_MMSTA | Cross-Plant Material Status | |
| Row | C_MSTAV | Cross-Distribution Material Status | |
| Row | C_PROFL | DG Indicator Profile | |
| Row | 0BASE_UOM | Base UOM | |
| Row | C_MATSUCT | Material Subcategory | |
| Row | C_SLTYPE | Sublot Type | |
| Row | C_SHELFBE | Shelf Life Begins | |
| Row | C_BSKDT | Basic Data Text | |
Free characteristics | C_BRAND | Brand (Trademark) | |
| Free characteristics | C_ENGPROJ | Engineering project | |
| Free characteristics | C_SRESTYP | Fiber Tradename | |
| Free characteristics | C_TSIZE | Fiber Tow Size | |
| Free characteristics | C_FIBLDEF | Fiber Fabric Lot Definition | |
| Free characteristics | C_FIBTWT | Fiber twist | |
| Free characteristics | C_FIBMOD | Fiber Modulus | |
| Free characteristics | C_FRAWU | FAW/RESIN/ADH Weight | |
| Free characteristics | C_MAT_TYP | Material type | |
| Free characteristics | C_MAT_FMT | Material Format | |
| Free characteristics | C_PRDTECH | Product Technology | |
| Free characteristics | C_PRDFORM | Product Form | |
| Free characteristics | C_PRDINST | Product Instructions | |
| Free characteristics | C_RITYPE | Reinforcement Type | |
| Free characteristics | C_RELTDEF | Resin Lot Definition | |
| Free characteristics | C_STOSTAT | Recommended Storage | |
| Free characteristics | C_FABSTYL | Reinforcement Architecture | |
| Free characteristics | C_RESNAM | Resin Name | |
| Free characteristics | C_RESTYPE | Resin Type | |
| Free characteristics | C_SIZING | Sizing | |
| Free characteristics | C_THEPLST | Thermoplastic / Thermoset | |
| Free characteristics | C_BISMT | Old Material Number | |
| Free characteristics | C_WUOM | Width UOM | |
| Columns | K_TSHELFL | Total Shelf Life | |
| Columns | K_RESOLID | Resin Solids | |
| Columns | K_WIDTH | Width | |
| Columns | K_RESCONT | Resin Content | |
| Columns | K_NETWT | Net Weight | |
| Columns | K_MATHCK | Material Thickness (µm) | |
| Columns | K_FAWT | Fiber Areal Weight | |
| Columns | K_DENS | Density | |
| Columns | K_ADHESWT | Adhesive Weight | |
Cells
If you have 2 structures and special cells calculations, explain here.
Conditions
If you have conditions, explain here.
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
| Ex : Excl if <=10 | Yes/No | Sales Value | Greater Than | 10 | Ex : All Independently |
Exceptions
If you have conditions, explain here.
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Ex : Red if <=10 | Yes/No | Bad 3 | Lesser Than | 10 | |