| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 105 | VGPOS | | nvarchar | 6 | 0 | | |
2 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 84 | VGPOS | | nvarchar | 6 | 0 | | |
3 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 91 | VGPOS | | nvarchar | 6 | 0 | | |
4 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 66 | VGPOS | | nvarchar | 6 | 0 | | |
5 | FIEUD_SDINV_I | SAFT: Invoices from SD module(Item) | 17 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
6 | ZEIM_LIPS | SD document: Delivery: Item data | 42 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
7 | ZEIM_VBAP | Sales Document: Item Data | 64 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPAdvertising Management |
8 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 56 | VGPOS | IS-M: Item Number of the Template Business Item | nvarchar | 6 | 0 | | |
9 | JHTVAABP | IS-M/AM: Contract Settlement Item Data | 20 | VGPOS | IS-M: Item Number of the Template Business Item | nvarchar | 6 | 0 | | |
TOPBasic Functions |
10 | FDS1 | Cash Management & Forecast: Line Items of SD Documents | 19 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPBilling |
11 | VBRP | Billing Document: Item Data | 26 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPConditions |
12 | A372 | Sales org./Ref.doc./Ref.item | 6 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPCross-Application Components |
13 | VVBAP | Sales Document: Item Data | 64 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPCross-Application Topics |
14 | /SPE/CD_PROC_ITM | Cross-Docking Process: Item Information | 9 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPData Collection |
15 | S008 | Communications Table SD -> CO/Projects | 67 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
16 | S073 | Cumulative Delivered Quantities | 5 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
17 | S261 | SD - Delivery note | 56 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
18 | S261BIW1 | SD - Delivery note | 56 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
19 | S261BIW2 | SD - Delivery note | 56 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
20 | S262 | SD - Billing document | 73 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
21 | S262BIW1 | SD - Billing document | 73 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
22 | S262BIW2 | SD - Billing document | 73 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPData Retention Tool |
23 | TXW_S_LIPS | Retrieve LIPS from archive | 24 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
24 | TXW_S_VBAP | Retrieve VBAP from archive | 18 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
25 | TXW_S_VBRP | Retrieve VBRP from archive | 13 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPEmpties Management |
26 | /BEV1/EMLGBWDP | Empties Movement Account Customer | 29 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPIntegration |
27 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 9 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPMedia Product Sales and Distribution |
28 | JKSDORDERINDEX | Index Table for IS-M Orders | 19 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
29 | JKSDRETURNCHECK | IS-M: Quantity Check on Return | 25 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPPatient Accounting |
30 | NVBRP | IS-H: Billing document item data | 15 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPPeriodical Sales and Distribution |
31 | JLRP | IS-M/SD: Item Data for Settlement | 17 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
32 | /BEV1/RBVBAP | Sales Document: Item Data | 64 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
33 | /BEV1/REMIETE | Rental Items: Shadow Table for VBAK/VBAP/VBEP | 17 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPSales |
34 | VBAP | Sales Document: Item Data | 64 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPShipping |
35 | DVK02 | R/2-R/3 Link: Delivery Item Data R2 -> R3 | 26 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
36 | LIPS | SD document: Delivery: Item data | 42 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |
TOPSimulation |
37 | VSVBAP_CN | Version: Sales document: Item data | 65 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | | |