| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Interface |
1 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 179 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
2 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 179 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
TOPActual CostingMaterial Ledger |
3 | CKMLDUVCO | Usage Differences for Each Account Assignment Object | 20 | AUFPS | Order item number | nvarchar | 2 | 0 | | |
4 | MLITMB | Material valuation document row information | 20 | AUFPS | Order item number | nvarchar | 2 | 0 | | |
TOPBalance Sheet Valuation Procedures |
5 | MYSEG_EXTRACT | Document Segment: Material | 13 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
TOPBatches |
6 | CHVW_INC | Batch Where-Used List- N:M Assignment for Order | 6 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
7 | CHVW_PRE | Preliminary Batch Where-used List According to Order/PO | 7 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
TOPConfirmations |
8 | AFFW | Goods Movements with Errors from Confirmations | 37 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
TOPDistribution of Usage Variances |
9 | CKMLDUVACTCO | Distribution Acty Differences: Diff. Per Acct Assgnmt object | 19 | AUFPS | Order item number | nvarchar | 2 | 0 | | |
10 | CKMLDUVNCO | Usage Differences for Each Account Assignment Object | 20 | AUFPS | Order item number | nvarchar | 2 | 0 | | |
11 | DUVMSEG_EXTRACT | duv mseg extract for performance | 17 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
TOPFinancial Accounting |
12 | ACCTIT | Compressed Data from FI/CO Document | 155 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
TOPInformation System |
13 | DSKOP | Balance Audit Trail | 63 | AUFPS | Order item number | nvarchar | 2 | 0 | | |
TOPInventory Management |
14 | CHVW | Table CHVW for Batch Where-Used List | 7 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
15 | MSEG | Document Segment: Material | 117 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
16 | MWXMSEG | ZMSEG: Interface for Posting of Value | 117 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
17 | MWZMSEG | ZMSEG:Interface for Posting of Value | 117 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
18 | RESB | Reservation/dependent requirements | 90 | AUFPS | Order item number | nvarchar | 2 | 0 | | |
TOPMaterials Management |
19 | /ISDFPS/CHVW_E | External Batch Where-Used List | 7 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
TOPQuality Inspection |
20 | QALS | Inspection lot record | 184 | AUFPS | Item Number of Reservation/Dependent Requirement | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
21 | /BEV1/CLCONT1 | Container Information | 6 | AUFPS | Order Item Sales | nvarchar | 6 | 0 | | |
TOPRepetitive Manufacturing |
22 | COMPMOVE | Goods Movement of Components | 153 | AUFPS | Order Item Number | nvarchar | 4 | 0 | | |
TOPSimulation |
23 | VSRESB_CN | Version: Reservation/Dependent requirements | 91 | AUFPS | Order item number | nvarchar | 2 | 0 | | |