| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSEG | Accounting Document Segment | 60 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
2 | BSSEG | Accounting Document Segment | 49 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
3 | CNVA_COA_CONV_CC | CoA and Comp.Code to conversion analysis | 7 | ALTKT | Indicator for filling alternative account field | nvarchar | 1 | 0 | | |
4 | CNV_20100_SKB1 | CNV backup copy for SKB1 | 33 | ALTKT | | nvarchar | 10 | 0 | | |
5 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 49 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
6 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 49 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
7 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 49 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
8 | GLPOS_C_CT | FI Document: Entry View | 36 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
9 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 36 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
10 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 36 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
11 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 36 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
12 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 36 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
13 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 36 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
14 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 91 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
15 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 91 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
TOPBasic Functions |
16 | GSBLCA | Business area consolidation: deviating records | 10 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
17 | SKB1 | G/L account master (company code) | 32 | ALTKT | Alternative account number in company code | nvarchar | 10 | 0 | | |
18 | SKM1 | Sample G/L accounts | 30 | ALTKT | Alternative account number in company code | nvarchar | 10 | 0 | | |
TOPData Retention Tool |
19 | TXW_S_BSEG | Retrieve BSEG from archive | 112 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
20 | ACCTIT | Compressed Data from FI/CO Document | 33 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
21 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 32 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
22 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 20 | ALTKT | Group account number | nvarchar | 10 | 0 | | |
TOPInformation System |
23 | DKKOP | Balance Audit Trail | 16 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
24 | DKOKP | Open Item Account Balance Audit Trail | 23 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
25 | DKOKS | Open Item Account Balance Audit Trail Master Record | 8 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
26 | DSKOP | Balance Audit Trail | 15 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
27 | DSKOS | Balance Audit Trail | 21 | ALTKT | Account Number in Group | nvarchar | 10 | 0 | | |
TOPLocalization |
28 | J_1BECD_HISTORY | Electronic-Accounting-File History | 25 | ALTKT | Issue Alternative Account Number | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
29 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 51 | ALTKT | Group account number | nvarchar | 10 | 0 | | |