PPH_CACHE_ITEM - Supply demand items and uncovered demand items
Supply demand items and uncovered demand items information is stored in SAP table PPH_CACHE_ITEM.
It is part of development package PPH_DDIC in software component PP-MRP. This development package consists of objects that can be grouped under "PP on HANA: Dictionary objects".
It is part of development package PPH_DDIC in software component PP-MRP. This development package consists of objects that can be grouped under "PP on HANA: Dictionary objects".
Fields for table PPH_CACHE_ITEM
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| MRPPLANT | Plant | X | WERKS_D | CHAR | 8 | * |
| MATERIAL | Material Number | X | MATNR | CHAR | 80 | * |
| MRPAREA | MRP Area | X | BERID | CHAR | 20 | * |
| MRPPLANNINGSEGMENTTYPE | Material requirements planning segment | X | PLAAB | NUMC | 4 | |
| MRPPLANNINGSEGMENTNUMBER | Planning segment number | X | PLANR | CHAR | 40 | |
| MRPELEMENTCATEGORY | MRP element | X | DELKZ | CHAR | 4 | |
| MRPELEMENT | MRP element number | X | DEL12 | CHAR | 24 | |
| MRPELEMENTITEM | MRP element item | X | DELPS | NUMC | 12 | |
| MRPELEMENTSCHEDULELINE | Schedule Line Number MRP Element | X | DELET | NUMC | 8 | |
| MATERIALSHORTAGEPROFILE | Material Shortage Profile | X | MATERIALSHORTAGEPROFILE | CHAR | 24 | |
| MATERIALSHORTAGEPROF_CNT | Counter for SDM Customizing Settings | X | SDM_COUNTER | NUMC | 6 | |
| MRPELEMENTAVAILYORRQMTDATE | Date of Availability or Requirement for MRP element | X | MRPELEMENTAVAILYORRQMTDATE | DATS | 16 | |
| MRPELEMENTENDDATE | Field of type DATS | DATS | DATS | 16 | ||
| MRPELEMENTSTARTDATE | Field of type DATS | DATS | DATS | 16 | ||
| MRPELEMENTQUANTITYISFIRM | Indicator: Fixing of Lot Size in Planned Order | FIX01 | CHAR | 2 | ||
| MRPELEMENTOPENQUANTITY | DEC 20 3 | PPH_DEC_20_3 | DEC | 11 | ||
| MRPELEMENTTYPEIMPORTANCE | Sort indicator 01 | SORT1 | CHAR | 2 | ||
| PRODUCTIONVERSION | Production Version | VERID | CHAR | 8 | * | |
| SUPPLIER | Account Number of Supplier | LIFNR | CHAR | 20 | * | |
| CUSTOMER | Customer Number | KUNNR | CHAR | 20 | * | |
| ISSUINGORRECEIVINGPLANT | Plant | WERKS_D | CHAR | 8 | * | |
| STORAGELOCATION | Storage location | LGORT_D | CHAR | 8 | * | |
| SOURCEMRPELEMENTCATEGORY | MRP element | DELKZ | CHAR | 4 | ||
| SOURCEMRPELEMENT | MRP element number | DEL12 | CHAR | 24 | ||
| SOURCEMRPELEMENTITEM | MRP element item | DELPS | NUMC | 12 | ||
| MRPELEMENTUNCOVEREDQUANTITY | DEC 20 3 | PPH_DEC_20_3 | DEC | 11 | ||
| MRPELEMENTDELAYEDQUANTITY | DEC 20 3 | PPH_DEC_20_3 | DEC | 11 | ||
| MAXIMUMDELAYDATE | Field of type DATS | DATS | DATS | 16 | ||
| MAXIMUMDELAYINDAYS | Maximum Delay In Days | MAXIMUMDELAYINDAYS | INT4 | 4 | ||
| MAXIMUMDELAYINWORKDAYS | Maximum Delay In Workdays | MAXIMUMDELAYINWORKDAYS | INT4 | 4 | ||
| PROCUREMENTPROGRESSINDICATOR | Procurement Progress Indicator | PROCUREMENTPROGRESSINDICATOR | CHAR | 2 |