| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 31 | BRTWR | | decimal | 15 | 0 | | |
TOPAgency Business Global Trade |
2 | WBRK | Agency business: Header | 35 | BRTWR | Agenncy Business: Gross value in document currency | decimal | 15 | 2 | | |
3 | WBRP | Agency business: Item | 28 | BRTWR | Gross value of the item in document currency | decimal | 15 | 2 | | |
4 | WLFD_IVRHDR | Agency Bus.: DB table for Invoice Request Header | 10 | BRTWR | Agenncy Business: Gross value in document currency | decimal | 15 | 2 | | |
5 | WLFD_IVRITM | Agency Bus.: DB table for Invoice Request Item | 10 | BRTWR | Gross value of the item in document currency | decimal | 15 | 2 | | |
TOPBasic Functions |
6 | FDLF | Cash Management Line Items for Agency Business | 9 | BRTWR | Agenncy Business: Gross value in document currency | decimal | 15 | 2 | | |
7 | FDLF2 | Cash Management Line Items for Agency Business (As of 604) | 10 | BRTWR | Agenncy Business: Gross value in document currency | decimal | 15 | 2 | | |
TOPBilling |
8 | VBRP | Billing Document: Item Data | 152 | BRTWR | Gross value of the billing item in document currency | decimal | 15 | 2 | | |
TOPContract Accounts Receivable and Payable |
9 | FKK_JLRK_SHORT | Header Data for IS-M/SD Service Settlement - Extracts | 18 | BRTWR | IS-M/SD: Gross Value of Billing Document in Doc. Currency | nvarchar | 17 | 0 | | |
10 | FKK_JLRPCM_SHORT | Item Data for IS-M/SD Commission Settlement - Extracts | 13 | BRTWR | IS-M/SD: Gross Value of Item in Document Currency | nvarchar | 17 | 0 | | |
11 | FKK_JLRPHD_SHORT | Item Data for IS-M/SD Home Delivery Settlement - Extracts | 9 | BRTWR | IS-M/SD: Gross Value of Item in Document Currency | nvarchar | 17 | 0 | | |
TOPContract Handling |
12 | S462 | IS-BEV-CH: Sales in BUn | 28 | BRTWR | Gross value of the billing item in document currency | decimal | 15 | 2 | | |
13 | S463 | IS-BEV-CH: Sales in Stat. UoM | 28 | BRTWR | Gross value of the billing item in document currency | decimal | 15 | 2 | | |
TOPData Collection |
14 | S270 | Do not use! | 26 | BRTWR | Gross order value in order currency | decimal | 13 | 2 | | |
15 | S270BIW1 | Do not use! | 26 | BRTWR | Gross order value in order currency | decimal | 13 | 2 | | |
16 | S270BIW2 | Do not use! | 26 | BRTWR | Gross order value in order currency | decimal | 13 | 2 | | |
17 | S272 | Do not use! | 35 | BRTWR | Gross value of the billing item in document currency | decimal | 15 | 2 | | |
18 | S272BIW1 | Do not use! | 35 | BRTWR | Gross value of the billing item in document currency | decimal | 15 | 2 | | |
19 | S272BIW2 | Do not use! | 35 | BRTWR | Gross value of the billing item in document currency | decimal | 15 | 2 | | |
20 | S275 | Transfer BW: Einkaufsdaten | 21 | BRTWR | Bruto bestelwaarde in bestelvaluta | decimal | 13 | 2 | | |
21 | S275BIW1 | S275BIW1 * Transfer to BW: Purchasing Data | 21 | BRTWR | Gross order value in order currency | decimal | 13 | 2 | | |
22 | S275BIW2 | S275BIW2 * Transfer to BW: Purchasing Data | 21 | BRTWR | Gross order value in order currency | decimal | 13 | 2 | | |
TOPDownstream |
23 | S414BIW1 | S414BIW1 * SSR DTF statistics | 22 | BRTWR | SSR PC: Gross value | decimal | 13 | 2 | | |
24 | S414BIW2 | S414BIW2 * SSR DTF statistics | 22 | BRTWR | SSR PC: Gross value | decimal | 13 | 2 | | |
TOPExternal Services |
25 | ESLL | Lines of Service Package | 22 | BRTWR | Gross Price | decimal | 11 | 2 | | |
26 | ESVC | Vendor confirmation for service lines | 16 | BRTWR | Gross Price | decimal | 11 | 2 | | |
TOPPeriodical Sales and Distribution |
27 | JLRK | IS-M/SD: Settlement Header Data | 21 | BRTWR | IS-M: Gross Value in Document Currency | decimal | 15 | 2 | | |
28 | JLRP | IS-M/SD: Item Data for Settlement | 12 | BRTWR | IS-M: Gross Value in Document Currency | decimal | 15 | 2 | | |
29 | JLSK | IS-M/SD: Header for Settlement in Collective Processing | 17 | BRTWR | IS-M: Gross Value in Document Currency | decimal | 15 | 2 | | |
30 | JLSS | IS-M/SD: Settlements in Collective Processing | 5 | BRTWR | IS-M: Gross Value in Document Currency | decimal | 15 | 2 | | |
TOPPurchasing |
31 | EKPO | Purchasing Document Item | 28 | BRTWR | Gross order value in PO currency | decimal | 13 | 2 | | |
32 | WDFR_POS | Perishables Planninng Item | 49 | BRTWR | Gross order value in PO currency | decimal | 13 | 2 | | |
TOPPurchasing Information System |
33 | MCEKS | R/2 PURCHIS Data (Status: Last Data Transmission) | 20 | BRTWR | Gross order value in base unit of measure | decimal | 15 | 2 | | |
TOPService Station Retailing |
34 | OIRADBT | Document base table | 29 | BRTWR | SSR PC: Gross value | decimal | 13 | 2 | | |
35 | OIREUPLKXXXX | SSR PC: Template for generated DTF tables (header) | 23 | BRTWR | SSR PC: Gross value | decimal | 13 | 2 | | |
36 | OIREUPLPXXXX | SSR PC: DTF table for item information | 10 | BRTWR | SSR PC: Gross value | decimal | 13 | 2 | | |
37 | OIRE_RECON_ADM | Administration data for the reconciliation files | 6 | BRTWR | SSR PC: Total Value (of Upload) | decimal | 13 | 2 | | |
38 | OIRE_RECON_AGG | Aggregated reconciliation data | 8 | BRTWR | SSR PC: Gross value | decimal | 13 | 2 | | |
39 | OIRE_RECON_DET | Detailed reconciliation data | 9 | BRTWR | SSR PC: Gross value | decimal | 13 | 2 | | |
40 | S414 | SSR DTF statistics | 22 | BRTWR | SSR PC: Gross value | decimal | 13 | 2 | | |