| 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 | 104 | VGBEL | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 83 | VGBEL | | nvarchar | 10 | 0 | | |
3 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 90 | VGBEL | | nvarchar | 10 | 0 | | |
4 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 65 | VGBEL | | nvarchar | 10 | 0 | | |
5 | FIEUD_SDINV_I | SAFT: Invoices from SD module(Item) | 16 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
6 | ZEIM_LIPS | SD document: Delivery: Item data | 41 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
7 | ZEIM_VBAK | Sales Document: Header Data | 75 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
8 | ZEIM_VBAP | Sales Document: Item Data | 63 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
9 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 55 | VGBEL | IS-M: Document Number of Template Document | nvarchar | 10 | 0 | | |
10 | JHTVAABP | IS-M/AM: Contract Settlement Item Data | 19 | VGBEL | IS-M: Document Number of Template Document | nvarchar | 10 | 0 | | |
TOPBasic Functions |
11 | FDS1 | Cash Management & Forecast: Line Items of SD Documents | 18 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPBasis Components |
12 | ZSALES_ORD_HEAD | Sales Order Header (IDES DEMO) | 10 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPBilling |
13 | VBRP | Billing Document: Item Data | 25 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPConditions |
14 | A372 | Sales org./Ref.doc./Ref.item | 5 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
15 | A923 | Organisation/Practice/Matter/Grade | 6 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
16 | VVBAK | Sales Document: Header Data | 75 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
17 | VVBAP | Sales Document: Item Data | 63 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPCross-Application Topics |
18 | /SPE/CD_PROC_ITM | Cross-Docking Process: Item Information | 8 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPData Collection |
19 | S008 | Communications Table SD -> CO/Projects | 66 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
20 | S073 | Cumulative Delivered Quantities | 4 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
21 | S261 | SD - Delivery note | 55 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
22 | S261BIW1 | SD - Delivery note | 55 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
23 | S261BIW2 | SD - Delivery note | 55 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
24 | S262 | SD - Billing document | 72 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
25 | S262BIW1 | SD - Billing document | 72 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
26 | S262BIW2 | SD - Billing document | 72 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
27 | TXW_S_LIPS | Retrieve LIPS from archive | 23 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
28 | TXW_S_VBAK | Retrieve VBAK from archive | 9 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
29 | TXW_S_VBAP | Retrieve VBAP from archive | 17 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
30 | TXW_S_VBRP | Retrieve VBRP from archive | 12 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPEmpties Management |
31 | /BEV1/EMLGBWDP | Empties Movement Account Customer | 28 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPIntegration |
32 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 8 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPMedia Product Sales and Distribution |
33 | JKSDORDERINDEX | Index Table for IS-M Orders | 18 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
34 | JKSDRETURNCHECK | IS-M: Quantity Check on Return | 24 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPPatient Accounting |
35 | NVBRP | IS-H: Billing document item data | 14 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPPeriodical Sales and Distribution |
36 | JLRP | IS-M/SD: Item Data for Settlement | 16 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
37 | /BEV1/RBVBAK | Sales Document: Header Data | 75 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
38 | /BEV1/RBVBAP | Sales Document: Item Data | 63 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
39 | /BEV1/REMIETE | Rental Items: Shadow Table for VBAK/VBAP/VBEP | 16 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
40 | /BEV1/RSDIF | Differences of Route Settlement | 4 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPSales |
41 | VBAK | Sales Document: Header Data | 75 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
42 | VBAP | Sales Document: Item Data | 63 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPSales Activities |
43 | VBKA | Sales Activities | 32 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPShipping |
44 | DVK02 | R/2-R/3 Link: Delivery Item Data R2 -> R3 | 25 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
45 | LIPS | SD document: Delivery: Item data | 41 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
TOPSimulation |
46 | VSVBAK_CN | Version: Sales document: Header data | 76 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |
47 | VSVBAP_CN | Version: Sales document: Item data | 64 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | | |