| 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 | 26 | AUBEL | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 25 | AUBEL | | nvarchar | 10 | 0 | | |
3 | GLPCA_CT | Profit Center Documents | 42 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
4 | GLPCA_T_CT | Profit Center Documents | 58 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
5 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 253 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
6 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 253 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPAdvertising Management |
7 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 67 | AUBEL | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
8 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 64 | AUBEL | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
9 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 11 | AUBEL | IS-M/AM: Sales Document Number | nvarchar | 10 | 0 | | |
TOPBilling |
10 | VBRP | Billing Document: Item Data | 28 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPConditions |
11 | A185 | Order no./Item/Configuration no./Material/Preference zone | 4 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
12 | A995 | Sales Doc./Item/Pers.No. | 4 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
13 | DFKKREP06 | Tax Report Data (Invoicing Time or Triggered) | 30 | AUBEL | Document Number Of Document To Be Triggered | nvarchar | 12 | 0 | | |
14 | DFKKREP06_S | Tax Report Data - Shadow Table for Posting Date | 30 | AUBEL | Document Number Of Document To Be Triggered | nvarchar | 12 | 0 | | |
15 | DFKKREP07 | Tax Report Data (Clearing Time) | 36 | AUBEL | Document Number Of Document To Be Triggered | nvarchar | 12 | 0 | | |
16 | DFKKREV06 | Report for Tax on Sales/Purchases (bill. time or triggered) | 27 | AUBEL | Document Number Of Document To Be Triggered | nvarchar | 12 | 0 | | |
17 | DFKKREV07 | Report on Tax on Sales/Purchases (clearing time) | 33 | AUBEL | Document Number Of Document To Be Triggered | nvarchar | 12 | 0 | | |
TOPCosting |
18 | COER | Sales Order Value Revenue | 73 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPData Collection |
19 | S008 | Communications Table SD -> CO/Projects | 64 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
20 | S262 | SD - Billing document | 70 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
21 | S262BIW1 | SD - Billing document | 70 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
22 | S262BIW2 | SD - Billing document | 70 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
23 | TXW_S_VBRP | Retrieve VBRP from archive | 15 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPEmpties Management |
24 | /BEV1/EMLGBWDP | Empties Movement Account Customer | 30 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
25 | ACCTIT | Compressed Data from FI/CO Document | 159 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Reorganization |
26 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 22 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPIntegration |
27 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 11 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPLocalization |
28 | IDGT_INFO | GTI China: Data sent to GT | 57 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
29 | IDPL_DP | Poland: Downpayments made and cleared | 2 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPMaterials Management |
30 | J_1GVL_ML | Material Ledger | 104 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPNon-Ferrous Metal enhancements |
31 | /NFM/TPROVHIS | Provision: History | 11 | AUBEL | Document Number | nvarchar | 10 | 0 | | |
TOPProfit Center Accounting |
32 | GLPCA | EC-PCA: Actual Line Items | 77 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
33 | /BEV1/BO_DATA | Proof Table for Rebate Processing | 22 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |
34 | /BEV1/RBWE | Itemized Proof Rebate Settlement | 48 | AUBEL | Sales Document | nvarchar | 10 | 0 | | |