| 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 | 27 | AUPOS | | nvarchar | 6 | 0 | | |
2 | /BIC/B0000186000 | PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond. | 26 | AUPOS | | nvarchar | 6 | 0 | | |
3 | GLPCA_CT | Profit Center Documents | 45 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
4 | GLPCA_T_CT | Profit Center Documents | 61 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPAccounting Interface |
5 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 254 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
6 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 254 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPAdvertising Management |
7 | JHFREV2 | IS-M/AM: Key Dates for Billing Document Revenue Recognition | 68 | AUPOS | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
8 | JHFREV4 | IS-M/AM: Billing Document Revenue Recognition Key Date Qties | 65 | AUPOS | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
9 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 12 | AUPOS | IS-M: Order Item Number | nvarchar | 3 | 0 | | |
TOPAlternative Valuation Run |
10 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 51 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPBilling |
11 | VBRP | Billing Document: Item Data | 29 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPConditions |
12 | A185 | Order no./Item/Configuration no./Material/Preference zone | 5 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPCosting |
13 | COER | Sales Order Value Revenue | 74 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPData Collection |
14 | S008 | Communications Table SD -> CO/Projects | 65 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
15 | S262 | SD - Billing document | 71 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
16 | S262BIW1 | SD - Billing document | 71 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
17 | S262BIW2 | SD - Billing document | 71 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPData Retention Tool |
18 | TXW_S_VBRP | Retrieve VBRP from archive | 16 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPEmpties Management |
19 | /BEV1/EMLGBWDP | Empties Movement Account Customer | 31 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPFinancial Accounting |
20 | ACCTIT | Compressed Data from FI/CO Document | 160 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPGeneral Ledger Reorganization |
21 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 23 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPIntegration |
22 | FKK_VBRP_SHORT | Item Data for SD Billing Document - Extracts | 12 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPLocalization |
23 | IDGT_INFO | GTI China: Data sent to GT | 58 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPMaterials Management |
24 | J_1GVL_ML | Material Ledger | 105 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |
TOPNon-Ferrous Metal enhancements |
25 | /NFM/TPROVHIS | Provision: History | 12 | AUPOS | Document Item Number | nvarchar | 6 | 0 | | |
TOPProfit Center Accounting |
26 | GLPCA | EC-PCA: Actual Line Items | 78 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | | |