| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BBP_PCACC | Procurement Card: Accounting Data | 44 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
2 | BBP_PCMOD | Procurement Card: Modified Statement Data | 46 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
3 | BSEG | Accounting Document Segment | 29 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
4 | GLPOS_C_CT | FI Document: Entry View | 384 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
5 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 378 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
6 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 378 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
7 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 378 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
8 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 393 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
9 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 387 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
10 | ZZSL01O | Custom Special Ledger Table Group | 14 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPAccounting Interface |
11 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 371 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
12 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 371 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPActual CostingMaterial Ledger |
13 | MLCO | Material valuation document account assignment information | 45 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPControlling |
14 | COPPP_ITM | CO Postprocessing List - Items | 97 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPElectronic Bank Statement |
15 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 79 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
16 | FEB_ACT | Acct Assignment Templates | 79 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPExternal Services |
17 | ESKN | Account Assignment in Service Package | 46 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
18 | ACCRFI | Accruals/Deferrals Master Data FI/CO Account Assignment | 25 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
19 | ACCTIT | Compressed Data from FI/CO Document | 132 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
20 | KMZEI | FI: Account Assignment Model Item Information | 78 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
21 | KOMU | Account Assignment Templates for G/L Account Items | 78 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
22 | VBSEGA | Document Segment for Document Parking - Asset Database | 84 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
23 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 135 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPFunds Management |
24 | FMFG_SAV_FACTS1A | Saved FACTS1A data for docs excluded from SL Repost for 600 | 76 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
25 | FMFG_SAV_FACTS2A | Saved FACTS2A data for docs excluded from SL Repost for 600 | 74 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
26 | FMIA | Actual Line Item Table for Funds Management | 64 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
27 | FMIFIIT | FI Line Item Table in Funds Management | 47 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
28 | FMIOI | Commitment Documents Funds Management | 53 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
29 | FMUSFGFACTS1A | 4Actual line item table | 76 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
30 | FMUSFGFACTS2A | Actual line item table | 74 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
31 | KBLP | Document Item: Manual Document Entry | 57 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPFunds Management-Specific Postings |
32 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 128 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Accounting |
33 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 93 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
34 | FAGL_SPLINFO | Splittling Information of Open Items | 50 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPGL Account Posting |
35 | TCJ_POSITIONS | Cash Journal Document Items | 86 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPGrantee Management |
36 | GMIA | Actual Line Item Table | 88 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPInventory Management |
37 | MSEG | Document Segment: Material | 136 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
38 | MWXMSEG | ZMSEG: Interface for Posting of Value | 136 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
39 | MWZMSEG | ZMSEG:Interface for Posting of Value | 136 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
40 | RKPF | Document Header: Reservation | 47 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPInvoice Verification |
41 | RBCO | Document Item, Incoming Invoice, Account Assignment | 43 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPOverhead Cost Controlling |
42 | COEP | CO Object: Line Items (by Period) | 91 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
43 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 93 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPPayment Transactions |
44 | CRACC | Payment Cards: Account Assignments in Card Master Record | 43 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
45 | CRNUM | Payment cards: Card master record | 64 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPProfitability Analysis |
46 | CECOEP | CO-PA Account Based Line Items | 93 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPPurchasing |
47 | EBKN | Purchase Requisition Account Assignment | 48 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
48 | EKKN | Account Assignment in Purchasing Document | 51 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPReal Estate Management |
49 | VIAKBSEG | Document Line Item from SCS for Interface | 17 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPRepetitive Manufacturing |
50 | COMPMOVE | Goods Movement of Components | 149 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |
TOPSimulation |
51 | VSEBKN_CN | Version: Purchase requisition account assignment | 52 | ZZSTATE | State/Province Code | nvarchar | 3 | 0 | | |