| 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 | 118 | FBUDA | | nvarchar | 8 | 0 | | |
2 | /BIC/B0000179000 | PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule | 98 | FBUDA | | nvarchar | 8 | 0 | | |
3 | /BIC/B0000181000 | PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond. | 63 | FBUDA | | nvarchar | 8 | 0 | | |
4 | /BIC/B0000185000 | PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item | 38 | FBUDA | | nvarchar | 8 | 0 | | |
5 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 33 | FBUDA | | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
6 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 252 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
7 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 252 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPAdvertising Management |
8 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 44 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
9 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 41 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
10 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 41 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPAgency Business Global Trade |
11 | WBRP | Agency business: Item | 108 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPBasic Functions |
12 | FDS1 | Cash Management & Forecast: Line Items of SD Documents | 15 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPBilling |
13 | VBRP | Billing Document: Item Data | 20 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPConditions |
14 | VBOX | SD Document: Billing Document: Rebate Index | 5 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPContract Accounts Receivable and Payable |
15 | FKK_JFRP_SHORT | Item Data for IS-M/SD Billing Document - Extracts | 14 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
16 | FKK_JLRPCM_SHORT | Item Data for IS-M/SD Commission Settlement - Extracts | 11 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
17 | FKK_JLRPHD_SHORT | Item Data for IS-M/SD Home Delivery Settlement - Extracts | 7 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPCosting |
18 | COER | Sales Order Value Revenue | 72 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
19 | VVBKD | Sales Document: Business Data | 23 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPData Collection |
20 | S008 | Communications Table SD -> CO/Projects | 60 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
21 | S260 | SD - Sales order | 71 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
22 | S260BIW1 | SD - Sales order | 71 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
23 | S260BIW2 | SD - Sales order | 71 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
24 | S262 | SD - Billing document | 38 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
25 | S262BIW1 | SD - Billing document | 38 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
26 | S262BIW2 | SD - Billing document | 38 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
27 | S264 | SD- Offer | 73 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
28 | S264BIW1 | S264BIW1 * SD - Quotation | 73 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
29 | S264BIW2 | S264BIW2 * SD - Quotation | 73 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPData Retention Tool |
30 | TXW_S_VBRP | Retrieve VBRP from archive | 21 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPIntegration |
31 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 17 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPPatient Accounting |
32 | NVBRP | IS-H: Billing document item data | 9 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
33 | JFRP | IS-M/SD: Billing Document - Item Data | 9 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
34 | JKKD | Sales Order: Business Data | 25 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
35 | JLRP | IS-M/SD: Item Data for Settlement | 10 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPSales |
36 | VBKD | Sales Document: Business Data | 23 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |
TOPSimulation |
37 | VSVBKD_CN | Version: Sales document - commercial data | 24 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | | |