| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000535 | TVV1 | 5 | KVGR1 | | nvarchar | 3 | 0 | | |
2 | /1CADMC/00000536 | TVV1T | 6 | KVGR1 | | nvarchar | 3 | 0 | | |
3 | /BIC/B0000176000 | PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header | 24 | KVGR1 | | nvarchar | 3 | 0 | | |
4 | /BIC/B0000177000 | PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item | 14 | KVGR1 | | nvarchar | 3 | 0 | | |
5 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 24 | KVGR1 | | nvarchar | 3 | 0 | | |
6 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 37 | KVGR1 | | nvarchar | 3 | 0 | | |
7 | /BIC/B0000180000 | PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch. | 27 | KVGR1 | | nvarchar | 3 | 0 | | |
8 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 19 | KVGR1 | | nvarchar | 3 | 0 | | |
9 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 47 | KVGR1 | | nvarchar | 3 | 0 | | |
10 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 47 | KVGR1 | | nvarchar | 3 | 0 | | |
11 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 39 | KVGR1 | | nvarchar | 3 | 0 | | |
12 | /SMD/MD_____00YW | SID-Tabelle fuer Customer group 1 | 3 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
13 | ZEIM_LIPS | SD document: Delivery: Item data | 89 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
14 | ZEIM_VBAK | Sales Document: Header Data | 53 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPBasic Functions |
15 | TVV1 | Customer Group 1 | 2 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
16 | TVV1T | Customer group 1: Description | 3 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPBilling |
17 | VBRP | Billing Document: Item Data | 89 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPCross-Application Components |
18 | VVBAK | Sales Document: Header Data | 53 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPCustomer Master |
19 | KNVV | Customer Master Sales Data | 43 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPData Collection |
20 | S260 | SD - Sales order | 22 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
21 | S260BIW1 | SD - Sales order | 22 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
22 | S260BIW2 | SD - Sales order | 22 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
23 | S261 | SD - Delivery note | 67 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
24 | S261BIW1 | SD - Delivery note | 67 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
25 | S261BIW2 | SD - Delivery note | 67 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
26 | S262 | SD - Billing document | 55 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
27 | S262BIW1 | SD - Billing document | 55 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
28 | S262BIW2 | SD - Billing document | 55 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
29 | S263 | SD - Sales order/delivery note | 19 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
30 | S263BIW1 | SD - Sales order/delivery note | 19 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
31 | S263BIW2 | SD - Sales order/delivery note | 19 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
32 | S264 | SD- Offer | 22 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
33 | S264BIW1 | S264BIW1 * SD - Quotation | 22 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
34 | S264BIW2 | S264BIW2 * SD - Quotation | 22 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
35 | /BEV1/RBVBAK | Sales Document: Header Data | 53 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPSales |
36 | VBAK | Sales Document: Header Data | 53 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPShipping |
37 | LIPS | SD document: Delivery: Item data | 89 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPSimulation |
38 | VSVBAK_CN | Version: Sales document: Header data | 54 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |
TOPTariffs, Duties and Permits |
39 | OIHL | License Master Data | 8 | KVGR1 | Customer group 1 | nvarchar | 3 | 0 | | |