| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ZEIM_LIPS | SD document: Delivery: Item data | 185 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPAllocation |
2 | AUPO | Allocation Table Document Item | 15 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPAssortment List |
3 | WDLSP | POS outbound log: IDoc (items) | 14 | RSPOS | Item created due to restart | nvarchar | 1 | 0 | | |
TOPBasic Functions |
4 | FPLA | Billing Plan | 25 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
5 | FPLAPO | Billing Plan | 25 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
6 | VFPLA | Billing Plan | 25 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPBatches |
7 | CHVW_PRE | Preliminary Batch Where-used List According to Order/PO | 11 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPClinical System |
8 | N1DRUGDOC | IS-H*MED: Drug Documentation | 14 | RSPOS | Medication: Document Number of Reservation | nvarchar | 4 | 0 | | |
TOPConfirmations |
9 | AFFW | Goods Movements with Errors from Confirmations | 27 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPConstruction Equipment Management |
10 | J_3GBELP | Document Data - Item Data | 192 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPConsumer Products for Food Beverage |
11 | CFB_BACKFLUSH | Backflush of Batches | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
12 | ONROK | Object number index for material component/reservation | 4 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPInformation System |
13 | MCCOMPV | Versions: Material Components | 6 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPInventory Management |
14 | MSEG | Document Segment: Material | 74 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
15 | MWXMSEG | ZMSEG: Interface for Posting of Value | 74 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
16 | MWZMSEG | ZMSEG:Interface for Posting of Value | 74 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
17 | RESB | Reservation/dependent requirements | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
18 | T159A | Test Data for Batch Input in Inventory Management | 22 | RSPOS | Item number of reservation (batch input format) | nvarchar | 4 | 0 | | |
TOPKANBAN |
19 | PKPS | Control Cycle Item / Kanban | 18 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPLogbook |
20 | DIACL_CLIST | DI CLIST: Component data | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPMaintenance History |
21 | HIMA | PM order history - materials | 4 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPMaintenance Orders |
22 | AUFM | Goods movements for order | 31 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPMaster Data |
23 | PKTMP | Conversion table for PKPS / please do not use | 17 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
24 | REUL | Material stock transfer reservation index | 5 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
25 | RSDB | Index of the RESB for the Direct Procurement Element | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPMaterial |
26 | RSADD | Additional fields for reservation | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
27 | RSDBS | Index of purchasing documents for individual customer stock | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
28 | RSPSP | Index: Reservations for WBS elements/Sales order items | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPMaterial Identification and Reconciliation |
29 | BEREIT | Material identification: staging data | 5 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
30 | HUM_KOMMI | HUM Picking with Partial GI Posting | 11 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
31 | MISTATUS | Status Table for Material Identification on Mat./Batch Level | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPNetwork and Activity |
32 | TCNTM05 | Assignment Components to Groups | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
33 | TCNTM06 | Dates for Components, Events and Date Type | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
34 | TCNTM07 | Status of a Date Type for a Component | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPPegging, Grouping, and Distribution |
35 | PEG_TACTASS | Pegging: Current Assignments Based on Goods Movements | 13 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPProduction Backflush |
36 | PPC_MAT | Super BOM for Backflushed Materials | 14 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPProduction Orders |
37 | FTIND | Missing parts index | 5 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPProject System |
38 | PSHLPDB_HIER_TMP | Table to store temporary hierarchy data | 24 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPRepetitive Manufacturing |
39 | COMPMOVE | Goods Movement of Components | 49 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPSCM Basis |
40 | CIFRVMAP | Mapping Table NR/POS/ET <-> APO GUID (Sales Orders) | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPSelf-Service Procurement |
41 | /SRMERP/D_SC_ITM | Shopping Cart Item | 68 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPShipping |
42 | LIPS | SD document: Delivery: Item data | 185 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
43 | VRSLI | Receipt of Materials from Deliveries | 8 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPSimulation |
44 | VSFPLA_CN | Version: Billing schedule | 26 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
45 | VSHIST_OK | Transfer history material components | 3 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
46 | VSRESB_CN | Version: Reservation/Dependent requirements | 4 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
47 | VSRSADD_CN | Version: Additional fields for reservation | 4 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
48 | VSRSDB_CN | Version: Index of RESB for direct procurement elements | 4 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPStructures Workbench |
49 | /ISDFPS/MATSPPLN | Materials Planned for Force Element | 69 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPWarehouse Management |
50 | LTAP | Transfer order item | 104 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
51 | LTBP | Transfer requirement item | 33 | RSPOS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |