SAP ABAP Table SDM_MATERIAL_KPI_SHORTAGE (Material KPI + Shortage)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ PP-MRP (Application Component) Material Requirements Planning
⤷ PPH_GENERAL (Package) PP on HANA: General Functions
⤷ PP-MRP (Application Component) Material Requirements Planning
⤷ PPH_GENERAL (Package) PP on HANA: General Functions
Basic Data
Table Category | INTTAB | Structure |
Structure | SDM_MATERIAL_KPI_SHORTAGE | Table Relationship Diagram |
Short Description | Material KPI + Shortage |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
2 | MATERIALNAME | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
3 | MATERIALTYPE | MTART | MTART | CHAR | 4 | 0 | Material type | * | |
4 | MATERIALABCCLASSIFICATION | MAABC | MAABC | CHAR | 1 | 0 | ABC indicator | * | |
5 | MATERIALPROCUREMENTCATEGORY | BESKZ | BESKZ | CHAR | 1 | 0 | Procurement Type | ||
6 | MATERIALPROCUREMENTCATNAME | VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Short Text for Fixed Values | ||
7 | MATERIALBASEUNIT | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
8 | MRPPLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
9 | MRPPLANTNAME | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
10 | MRPAREA | BERID | BERID | CHAR | 10 | 0 | MRP Area | * | |
11 | MRPAREATEXT | BERTX | BERTX | CHAR | 40 | 0 | MRP area text | ||
12 | MRPCONTROLLER | DISPO | DISPO | CHAR | 3 | 0 | MRP controller | * | |
13 | MRPCONTROLLERNAME | DSNAM | TEXT18 | CHAR | 18 | 0 | Name of MRP controller | ||
14 | MRPTYPE | DISMM | DISMM | CHAR | 2 | 0 | MRP Type | * | |
15 | MRPTYPENAME | DIBEZ | DIBEZ | CHAR | 30 | 0 | Material requirements planning description | ||
16 | MATERIALPROCUREMENTSUBTYPE | SOBSL | SOBSL | CHAR | 2 | 0 | Special procurement type | * | |
17 | MATERIALPROCUREMENTSUBTYPENAME | MATERIALPROCUREMENTSUBTYPENAME | TEXT40 | CHAR | 40 | 0 | Material Procurement Subtype Description | ||
18 | MATERIALUSABILITYPROFILE | MMSTA | MMSTA | CHAR | 2 | 0 | Plant-Specific Material Status | * | |
19 | MATERIALUSABILITYPROFILENAME | MTSTB | TEXT25 | CHAR | 25 | 0 | Description of material status from MM/PP view | ||
20 | MATERIALGROUP | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
21 | MATERIALGROUPNAME | WGBEZ | TEXT20 | CHAR | 20 | 0 | Material Group Description | ||
22 | PURCHASINGGROUP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | * | |
23 | PURCHASINGGROUPNAME | EKNAM | TEXT18 | CHAR | 18 | 0 | Description of purchasing group | ||
24 | MRPGROUP | DISGR | DISGR | CHAR | 4 | 0 | MRP Group | * | |
25 | MRPGROUPNAME | MRPGROUPNAME | TEXT40 | CHAR | 40 | 0 | MRP Group Description | ||
26 | MRPPLANNINGSEGMENTTYPE | PLAAB | PLAAB | NUMC | 2 | 0 | Material requirements planning segment | ||
27 | MRPPLANNINGSEGMENT | PLANR | PLANR | CHAR | 20 | 0 | Planning segment number | ||
28 | MRPAVAILABLESTOCKQTY | MRPAVAILABLESTOCKQTY | MENG13 | QUAN | 13 | 3 | Current Stock Quantity Available for MRP | ||
29 | MRPAVAILABLESTOCKQTYAMOUNT | MRPAVAILABLESTOCKQTYAMOUNT | WERT | CURR | 13 | 2 | Value of Current Stock Available for MRP | ||
30 | COMPANYCODECURRENCY | KWAER | WAERS | CUKY | 5 | 0 | Controlling area currency | * | |
31 | MATERIALSAFETYSTOCKQTY | EISBE | MENG13 | QUAN | 13 | 3 | Safety stock | ||
32 | NUMBEROFOVERDUERECEIPTS | NUMBEROFOVERDUERECEIPTS | INT4 | 10 | 0 | Number Of Overdue Receipts | |||
33 | NUMBEROFPLNDORDSINOPENINGHRZN | NUMBEROFPLNDORDSINOPENINGHRZN | INT4 | 10 | 0 | Number of Planned Orders in Opening Horizon | |||
34 | NUMBEROFUNRELDMFGORDSINRELHRZN | NUMBEROFUNRELDMFGORDSINRELHRZN | INT4 | 10 | 0 | Number of Unreleased Manufacturing Orders in Release Horizon | |||
35 | MATERIALGOODSRECEIPTDURATION | WEBAZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
36 | MATERIALPLANNEDPRODUCTIONDURN | DZEIT | DEC3 | DEC | 3 | 0 | In-house production time | ||
37 | MATERIALPLANNEDDELIVERYDURN | PLIFZ | DEC3 | DEC | 3 | 0 | Planned delivery time in days | ||
38 | TOTALREPLENISHMENTLEADDURATION | WZEIT | DEC3 | DEC | 3 | 0 | Total replenishment lead time (in workdays) | ||
39 | MRPSAFETYDURATION | SHZET | NUMC2 | NUMC | 2 | 0 | Safety time (in workdays) | ||
40 | PLANNINGTIMEFENCE | FXHOR | FXHOR | NUMC | 3 | 0 | Planning time fence | ||
41 | .INCLUDE | 0 | 0 | Material Shortage | |||||
42 | DAYSOFSUPPLYPROFILE | DAYSOFSUPPLYPROFILE | SDM_PROFILE | CHAR | 12 | 0 | Days' Supply Profile | ||
43 | DAYSOFSUPPLYPROF_CNT | SDM_COUNTER | NUMC3 | NUMC | 3 | 0 | Counter for SDM customizing settings | ||
44 | DAYSOFSUPPLYPROFILENAME | DAYSOFSUPPLYPROFILENAME | TEXT40 | CHAR | 40 | 0 | Days of Supply Profile Description | ||
45 | DAYSOFSUPPLYDURATION | DAYSOFSUPPLYDURATION | INT4 | INT4 | 10 | 0 | Days' Supply | ||
46 | DAYSOFSUPPLYENDDATE | DAYSOFSUPPLYENDDATE | DATUM | DATS | 8 | 0 | Date that Demand is no Longer Covered by Plant Stock | ||
47 | DAYSOFSUPPLYCOVERAGEINPERCENT | DAYSOFSUPPLYCOVERAGEINPERCENT | DEC5_2 | DEC | 7 | 2 | Demand Coverage on First Shortage Date in Percent | ||
48 | MATERIALSHORTAGEQUANTITY | MATERIALSHORTAGEQUANTITY | MENG13 | QUAN | 13 | 3 | Shortage Quantity at First Shortage Date | ||
49 | NUMBEROFWORKDAYSWITHSHORTAGE | NUMBEROFWORKDAYSWITHSHORTAGE | INT4 | INT4 | 10 | 0 | Number of Workdays with Shortage | ||
50 | AVAILCHART21 | CHAR22 | CHAR22 | CHAR | 22 | 0 | Text string 22 characters |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 618 |