| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZEIM_AFPO | Order item | 8 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
2 | ZEIM_VBEP | Sales Document: Schedule Line Data | 50 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPBasic Functions |
3 | A345 | Ceiling Duty Rate: Import Country/Orig.Country/Ceiling No. | 7 | PLNUM | Quota or Ceiling Number for Import Processing | nvarchar | 10 | 0 | | |
4 | EIPO | Foreign Trade: Export/Import: Item Data | 91 | PLNUM | Quota or Ceiling Number for Import Processing | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
5 | VVBEP | Sales Document: Schedule Line Data | 50 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPData Collection |
6 | S022 | SFIS: Order Operation Data for Work Center | 13 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPInformation System |
7 | MCAFPOV | Versions: Order Item | 27 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
8 | MCSFIS | R/2 SFIS Data: Old | 61 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPInventory Management |
9 | RESB | Reservation/dependent requirements | 28 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPKANBAN |
10 | PKPS | Control Cycle Item / Kanban | 11 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPMaster Data |
11 | KDPL | Index customer order -> planned order | 5 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
12 | MDSM | Simulative dependent requirements | 68 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
13 | PKTMP | Conversion table for PKPS / please do not use | 10 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
14 | PLAF | Planned Order | 2 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
15 | PLPW | Index of the production/delivery plant in the planned order | 4 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
16 | PSPL | Index project -> planned order | 3 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
17 | RSDB | Index of the RESB for the Direct Procurement Element | 6 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPProduction Campaign |
18 | PCMP | Production campaign item | 5 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPProduction Orders |
19 | AFPO | Order item | 8 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPRepetitive Manufacturing |
20 | BLPR | Document Log Index and Planned Order (Backflush) | 3 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
21 | RMIO | Input Structure of Repetitive Manufacturing Confirmation | 42 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
22 | RMUSER | User Settings for REM Backflush Transactions | 11 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPSales |
23 | VBEP | Sales Document: Schedule Line Data | 50 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPScheduling |
24 | KBED | Capacity Requirements Records | 36 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
25 | KBKO | Header Record for Capacity Requirements | 5 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
TOPSimulation |
26 | VSAFPO_CN | Version: Order items in PP orders | 9 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
27 | VSKBED_CN | Version: Capacity requirement records | 37 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
28 | VSKBKO_CN | Version: Capacity requirements header for an order | 6 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
29 | VSPLAF_CN | Version: Planned order | 3 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
30 | VSRESB_CN | Version: Reservation/Dependent requirements | 29 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
31 | VSRSDB_CN | Version: Index of RESB for direct procurement elements | 7 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |
32 | VSVBEP_CN | Version: Sales document: Schedule line data | 51 | PLNUM | Planned order number | nvarchar | 10 | 0 | | |