| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 214 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
2 | BBP_TMP_VEN | Obsolete from 2.0C Onwards. Was Never used Before | 11 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
3 | BBP_TMP_VEN000 | Temporary: Request 'Bidder', Purchasing Data | 11 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
4 | VEN000 | Business Partner: General Vendor Data | 11 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPAllocation |
5 | AUFI | Allocation Table, Document Sub-item, Stores | 36 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
6 | AUVT | Shipping-Specific Data of Plants for Delivery Generation | 15 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
7 | AUVZ | Distribution Center | 15 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPCross-Application Components |
8 | FRE_DB_PROCYC | Procurement cycle | 7 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
9 | MMARC | Plant Data for Material | 18 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
10 | PLLPO | Task list - operation/activity | 101 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPDefense Forces and Public Security |
11 | /ISDFPS/ZEBAN | Copy of EBAN | 111 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPDistribution Requirements Planning |
12 | MDRP_POCO | Event Table: Deployment Run | 12 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPInventory Management |
13 | MWZDM07M1 | ZDM07M1 | 181 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPMaintenance History |
14 | HIVG | PM order history - operations | 41 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPMaster Data |
15 | MDMA | MRP Area for Material | 44 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPMaster Data Distribution |
16 | /ISDFPS/TL1 | Task List - Operation/Activity | 101 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPMaterial Master |
17 | MARC | Plant Data for Material | 18 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
18 | MARC_TMP | File for Incorrect Data in Direct Input | 21 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
19 | MDIP | Material: MRP Profiles (Field Contents) | 7 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
20 | MVRC | Cross-version fields for MARC | 18 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPMaterials Management |
21 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 117 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPPerishables Procurement |
22 | FIP_D_PDT_TO_CUS | Internal planned delivery time from suppl. Plant to customer | 7 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
23 | FIP_D_PDT_TO_DC | External planned delivery time from vendor to suppl. plant | 6 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
24 | FIP_D_PDT_TO_ST | Internal planned delivery time from suppl. plant to store | 6 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPProduction Orders |
25 | AFVV | DB structure of the quantities/dates/values in the operation | 39 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPPurchasing |
26 | EBAN | Purchase Requisition | 111 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
27 | EKPO | Purchasing Document Item | 83 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
28 | EKPV | Shipping Data For Stock Transfer of Purchasing Document Item | 14 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
29 | EQUP | Quota File: Item | 22 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
30 | MEREQX | Purchase Requisition Change Parameter | 111 | PLIFZ | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPRouting |
31 | PLPO | Task list - operation/activity | 101 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPSelf-Service Procurement |
32 | /SRMERP/D_SC_ITM | Shopping Cart Item | 22 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPSimulation |
33 | VSAFVV_CN | Version: Quantities/Dates/Values in order operation | 40 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
34 | VSEBAN_CN | Version: Purchase requisition | 112 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
TOPVendor Master |
35 | LFM1 | Vendor master record purchasing organization data | 25 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
36 | LFM2 | Vendor Master Record: Purchasing Data | 27 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |
37 | WYT5 | Changes to Vendor Master Record | 12 | PLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | | |