| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 96 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 97 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
3 | /OPT/VIM_1ITEM_S | Document Item | 102 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
4 | /OPT/VIM_TITEM | Document Item | 102 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
5 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 80 | PRODPER | | nvarchar | 6 | 0 | | |
6 | BSEG | Accounting Document Segment | 345 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
7 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 80 | PRODPER | | nvarchar | 6 | 0 | | |
8 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 74 | PRODPER | | nvarchar | 6 | 0 | | |
9 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 74 | PRODPER | | nvarchar | 6 | 0 | | |
10 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 327 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
11 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 327 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
12 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 327 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
13 | GLPOS_C_CT | FI Document: Entry View | 357 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
14 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 351 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
15 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 351 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
16 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 351 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
17 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 366 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
18 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 360 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
19 | YVIM_1ITEM | Document Item | 102 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
TOPAccounting Interface |
20 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 428 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
21 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 428 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
TOPControlling |
22 | COKEY2 | CO Key Subnumbers Enhancement Table | 13 | PRODPER | Production Month for JVA in CO | nvarchar | 6 | 0 | | |
TOPFinancial Accounting |
23 | /OPT/VIM_1ITEM | Document Item | 102 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
24 | ACCTIT | Compressed Data from FI/CO Document | 193 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
25 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 81 | PRODPER | | nvarchar | 6 | 0 | | |
26 | BSIS | Accounting: Secondary Index for G/L Accounts | 81 | PRODPER | | nvarchar | 6 | 0 | | |
27 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 83 | PRODPER | | nvarchar | 6 | 0 | | |
28 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 153 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
TOPGeneral Ledger Accounting |
29 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 74 | PRODPER | | nvarchar | 6 | 0 | | |
30 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 74 | PRODPER | | nvarchar | 6 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
31 | JVSO1 | JV LI Table with Objects for JVTO1 | 82 | PRODPER | Production Month (Date to find period and year) | nvarchar | 8 | 0 | | |
32 | T8JTPM | Joint Venture Production Month Summary Data | 12 | PRODPER | | nvarchar | 6 | 0 | | |
TOPOverhead Cost Controlling |
33 | COEP | CO Object: Line Items (by Period) | 79 | PRODPER | Production Month for JVA in CO | nvarchar | 6 | 0 | | |
34 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 81 | PRODPER | Production Month for JVA in CO | nvarchar | 6 | 0 | | |
TOPProfitability Analysis |
35 | CECOEP | CO-PA Account Based Line Items | 81 | PRODPER | Production Month for JVA in CO | nvarchar | 6 | 0 | | |