| 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 | 61 | KZWI6 | | decimal | 13 | 0 | | |
2 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 57 | KZWI6 | | decimal | 13 | 0 | | |
3 | ZEIM_LIPS | SD document: Delivery: Item data | 85 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
4 | ZEIM_VBAP | Sales Document: Item Data | 118 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPAdvertising Management |
5 | JHAGA | IS-M/AM: Order-Publishing-Media Billing Dataset | 239 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
6 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 113 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPAgency Business Global Trade |
7 | WBRP | Agency business: Item | 34 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPBasic Functions |
8 | FPLT | Billing Plan: Dates | 45 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
9 | FPLTPO | Billing Plan: Dates | 45 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
10 | VFPLT | Billing Plan: Dates | 45 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPBilling |
11 | VBRP | Billing Document: Item Data | 83 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPCross-Application Components |
12 | VVBAP | Sales Document: Item Data | 118 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPData Collection |
13 | S260 | SD - Sales order | 97 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
14 | S260BIW1 | SD - Sales order | 97 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
15 | S260BIW2 | SD - Sales order | 97 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
16 | S262 | SD - Billing document | 93 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
17 | S262BIW1 | SD - Billing document | 93 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
18 | S262BIW2 | SD - Billing document | 93 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
19 | S264 | SD- Offer | 100 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
20 | S264BIW1 | S264BIW1 * SD - Quotation | 100 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
21 | S264BIW2 | S264BIW2 * SD - Quotation | 100 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
22 | S270 | Do not use! | 38 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
23 | S270BIW1 | Do not use! | 38 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
24 | S270BIW2 | Do not use! | 38 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
25 | S272 | Do not use! | 32 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
26 | S272BIW1 | Do not use! | 32 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
27 | S272BIW2 | Do not use! | 32 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
28 | S275 | Transfer BW: Einkaufsdaten | 29 | KZWI6 | Conditie-tussentotaal 6 uit calculatieschema | decimal | 13 | 2 | | |
29 | S275BIW1 | S275BIW1 * Transfer to BW: Purchasing Data | 29 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
30 | S275BIW2 | S275BIW2 * Transfer to BW: Purchasing Data | 29 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
31 | S276 | Transfer BW: Vertriebsdaten | 26 | KZWI6 | Conditie-tussentotaal 6 uit calculatieschema | decimal | 13 | 2 | | |
32 | S276BIW1 | S276BIW1 * Transfer to BW: Sales and Distribution Data | 26 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
33 | S276BIW2 | S276BIW2 * BW Transfer: Sales and Distribution Data | 26 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPData Retention Tool |
34 | TXW_S_VBRP | Retrieve VBRP from archive | 42 | KZWI6 | Subtotal 6 from pricing procedure for condition | nvarchar | 20 | 0 | | |
TOPFreight Processing |
35 | VFKP | Shipment Costs: Item Data | 64 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
36 | VFSI | Shipment Costs: Sub-item Data | 17 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPIntegration |
37 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 38 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPLogistics - General |
38 | WBHI | Trading Contract: Item Data | 116 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPPeriodical Sales and Distribution |
39 | JFRP | IS-M/SD: Billing Document - Item Data | 43 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
40 | JKEP | Sales Order: Schedule Line Data | 43 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
41 | JLRP | IS-M/SD: Item Data for Settlement | 45 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPPurchasing |
42 | EKPO | Purchasing Document Item | 160 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPRemaining Beverage - Obsolete Objects |
43 | /BEV1/RBVBAP | Sales Document: Item Data | 118 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPSales |
44 | VBAP | Sales Document: Item Data | 118 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPShipping |
45 | LIPS | SD document: Delivery: Item data | 85 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
TOPSimulation |
46 | VSFPLT_CN | Version: Billing schedule: Dates | 46 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |
47 | VSVBAP_CN | Version: Sales document: Item data | 119 | KZWI6 | Subtotal 6 from pricing procedure for condition | decimal | 13 | 2 | | |