| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /1CADMC/00000513 | TVFS | 5 | FAKSP | | nvarchar | 2 | 0 | | |
2 | /1CADMC/00000514 | TVFST | 6 | FAKSP | | nvarchar | 2 | 0 | | |
3 | /BIC/B0000177000 | PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item | 30 | FAKSP | | nvarchar | 2 | 0 | | |
4 | /BIC/B0000178000 | PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item | 48 | FAKSP | | nvarchar | 2 | 0 | | |
5 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 58 | FAKSP | | nvarchar | 2 | 0 | | |
6 | /BIC/B0000180000 | PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch. | 42 | FAKSP | | nvarchar | 2 | 0 | | |
7 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 38 | FAKSP | | nvarchar | 2 | 0 | | |
8 | /BIC/B0000183000 | PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item | 43 | FAKSP | | nvarchar | 2 | 0 | | |
9 | /SMD/MD_____00PB | SID-Tabelle fuer Central billing block | 3 | FAKSP | Block | nvarchar | 2 | 0 | | |
10 | /SMD/MD_____00ZU | SID-Tabelle fuer Billing block for sales area | 3 | FAKSP | Block | nvarchar | 2 | 0 | | |
11 | TVFSP | Billing: Blocking Reasons | 2 | FAKSP | Block | nvarchar | 2 | 0 | | |
12 | ZEIM_LIPS | SD document: Delivery: Item data | 32 | FAKSP | Block | nvarchar | 2 | 0 | | |
13 | ZEIM_VBAP | Sales Document: Item Data | 39 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
TOPAdvertising Management |
14 | JHAGVX | IS-M/AM: Order Sales Agent Assignment Settlement Index | 13 | FAKSP | IS-M: Billing Block | nvarchar | 2 | 0 | | |
15 | JHTFX | IS-M/AM: Billing Index - Order Billing | 27 | FAKSP | IS-M: Billing Block | nvarchar | 2 | 0 | | |
16 | JHTVAABK | IS-M/AM: Contract Settlement Header Data | 35 | FAKSP | Block | nvarchar | 2 | 0 | | |
17 | JHTVAARI | IS-M/AM: Contract Settlement Payer/Advertiser Record | 22 | FAKSP | Block | nvarchar | 2 | 0 | | |
18 | TJHAP | IS-M/AM: Order-Publishing-Media: Item Categories | 33 | FAKSP | IS-M: Billing Block | nvarchar | 2 | 0 | | |
TOPBasic Functions |
19 | FPLT | Billing Plan: Dates | 13 | FAKSP | Billing block for billing plan/invoice plan dates | nvarchar | 2 | 0 | | |
20 | FPLTPO | Billing Plan: Dates | 13 | FAKSP | Billing block for billing plan/invoice plan dates | nvarchar | 2 | 0 | | |
21 | TFPLT | Date Type for Billing Plan Type | 7 | FAKSP | Billing block for billing plan/invoice plan dates | nvarchar | 2 | 0 | | |
22 | TVAP | Sales Document: Item Categories | 14 | FAKSP | Block | nvarchar | 2 | 0 | | |
23 | VFPLT | Billing Plan: Dates | 13 | FAKSP | Billing block for billing plan/invoice plan dates | nvarchar | 2 | 0 | | |
TOPBilling |
24 | TVFS | Billing: Reasons for Blocking | 2 | FAKSP | Block | nvarchar | 2 | 0 | | |
25 | TVFST | Billing : Blocking Reason Texts | 3 | FAKSP | Block | nvarchar | 2 | 0 | | |
TOPCPE in SD |
26 | CPEC_SD_BLOCKING | CPE Billing Blocks: Assignment to SD Blocking Reason | 3 | FAKSP | Block | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
27 | VVBAP | Sales Document: Item Data | 39 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
TOPData Collection |
28 | S260 | SD - Sales order | 39 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
29 | S260BIW1 | SD - Sales order | 39 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
30 | S260BIW2 | SD - Sales order | 39 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
31 | S261 | SD - Delivery note | 54 | FAKSP | Block | nvarchar | 2 | 0 | | |
32 | S261BIW1 | SD - Delivery note | 54 | FAKSP | Block | nvarchar | 2 | 0 | | |
33 | S261BIW2 | SD - Delivery note | 54 | FAKSP | Block | nvarchar | 2 | 0 | | |
34 | S263 | SD - Sales order/delivery note | 35 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
35 | S263BIW1 | SD - Sales order/delivery note | 35 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
36 | S263BIW2 | SD - Sales order/delivery note | 35 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
37 | S264 | SD- Offer | 41 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
38 | S264BIW1 | S264BIW1 * SD - Quotation | 41 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
39 | S264BIW2 | S264BIW2 * SD - Quotation | 41 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
40 | JKAK | Sales Order Header Data | 22 | FAKSP | Billing Block | nvarchar | 2 | 0 | | |
41 | JKAP | Sales Order - Item Data | 61 | FAKSP | Billing Block | nvarchar | 2 | 0 | | |
42 | JVTZAEM2 | Sales Order Header Data | 24 | FAKSP | Billing Block | nvarchar | 2 | 0 | | |
43 | TJAPZ | IS-M/SD: Item Type-Sales Document Type Assignment | 11 | FAKSP | Block | nvarchar | 2 | 0 | | |
44 | TJK14 | IS-M/SD: Lock Limit - Release for Returns/Complaint | 8 | FAKSP | Block | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
45 | /BEV1/RBVBAP | Sales Document: Item Data | 39 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
46 | /BEV1/RSFKS | Billing Blocks That Are not Automatic. Removed Upon Release | 2 | FAKSP | Block | nvarchar | 2 | 0 | | |
TOPSales |
47 | VBAP | Sales Document: Item Data | 39 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |
TOPShipping |
48 | LIPS | SD document: Delivery: Item data | 32 | FAKSP | Block | nvarchar | 2 | 0 | | |
TOPSimulation |
49 | VSFPLT_CN | Version: Billing schedule: Dates | 14 | FAKSP | Billing block for billing plan/invoice plan dates | nvarchar | 2 | 0 | | |
50 | VSVBAP_CN | Version: Sales document: Item data | 40 | FAKSP | Billing block for item | nvarchar | 2 | 0 | | |