| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 110 | PSEGMENT | | nvarchar | 10 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 110 | PSEGMENT | | nvarchar | 10 | 0 | | |
3 | /BIC/B0000171000 | PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances | 26 | PSEGMENT | | nvarchar | 10 | 0 | | |
4 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 154 | PSEGMENT | | nvarchar | 10 | 0 | | |
5 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 27 | PSEGMENT | | nvarchar | 10 | 0 | | |
6 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 29 | PSEGMENT | | nvarchar | 10 | 0 | | |
7 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 29 | PSEGMENT | | nvarchar | 10 | 0 | | |
8 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 73 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
9 | BSEG | Accounting Document Segment | 319 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
10 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 73 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
11 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 73 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
12 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 73 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
13 | FAGLFLEXC | EMU: Sum of Open Items of Table FAGLFLEXT | 36 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
14 | FAGLFLEXD | EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT | 38 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
15 | FAGLFLEXT_BAK | General Ledger: Totals | 38 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
16 | FAGLFLEXT_DIF | Delta Table: G/L Totals | 38 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
17 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 308 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
18 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 308 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
19 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 308 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
20 | GLPOS_C_CT | FI Document: Entry View | 203 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
21 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 203 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
22 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 203 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
23 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 203 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
24 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 208 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
25 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 208 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
26 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 414 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
27 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 414 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPControlling |
28 | COKEY2 | CO Key Subnumbers Enhancement Table | 10 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
29 | ACCTIT | Compressed Data from FI/CO Document | 157 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
30 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 73 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
31 | BSIS | Accounting: Secondary Index for G/L Accounts | 73 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
32 | FBICRC003A | ICRC: Open Items Customers/Vendors: Documents | 46 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
33 | KOMU | Account Assignment Templates for G/L Account Items | 96 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
34 | VBSEGA | Document Segment for Document Parking - Asset Database | 72 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
35 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 140 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
36 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 74 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
37 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 73 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
38 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 73 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
39 | FAGLFLEX06 | General ledger: Sender SAP additional account assignment | 7 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
40 | FAGLFLEXA | General Ledger: Actual Line Items | 29 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
41 | FAGLFLEXP | General Ledger: Plan Line Items | 31 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
42 | FAGLFLEXT | General Ledger: Totals | 38 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
43 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 30 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
44 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 28 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
45 | FAGL_SPLINFO | Splittling Information of Open Items | 16 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Reorganization |
46 | FAGL_R_APAR | Reorganization: Object List for Receivables and Payables | 18 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
47 | FAGL_R_BLNCE | Reorganization: Balances to Be Transferred | 27 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
48 | FAGL_R_MAP_SAP | Reorganization: Object Number of the Included SAP Fields | 7 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
49 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 15 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPGL Account Posting |
50 | TCJ_POSITIONS | Cash Journal Document Items | 97 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
51 | JVGLFLEX06 | General ledger: Sender SAP additional account assignment | 7 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
52 | JVGLFLEXA | General Ledger: Actual Line Items | 28 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
53 | JVGLFLEXP | General Ledger: Plan Line Items | 30 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
54 | JVGLFLEXT | General Ledger: Totals | 37 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPOverhead Cost Controlling |
55 | COEJ | CO Object: Line Items (by Fiscal Year) | 197 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
56 | COEP | CO Object: Line Items (by Period) | 76 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
57 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 78 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
TOPProfitability Analysis |
58 | CECOEJ | CO-PA Account Based Line Items | 199 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |
59 | CECOEP | CO-PA Account Based Line Items | 78 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | | |