| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GLPCA_CT | Profit Center Documents | 46 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
2 | GLPCA_T_CT | Profit Center Documents | 62 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
3 | P2RA_SP | Payroll Results: Special Payments | 30 | AUTOM | Automatic indicator | nvarchar | 1 | 0 | | |
4 | P2RB_SP | Payroll Results: Special Payments | 30 | AUTOM | Automatic indicator | nvarchar | 1 | 0 | | |
5 | P2RD_SP | Payroll Results: Special Payments | 30 | AUTOM | Automatic indicator | nvarchar | 1 | 0 | | |
6 | P2RE_SP | Payroll Results: Special Payments | 30 | AUTOM | Automatic indicator | nvarchar | 1 | 0 | | |
7 | P2RI_SP | Payroll Results: Special Payments | 30 | AUTOM | Automatic indicator | nvarchar | 1 | 0 | | |
8 | P2RN_SP | Payroll Results: Special Payments | 30 | AUTOM | Automatic indicator | nvarchar | 1 | 0 | | |
9 | P2RR_SP | Payroll Results: Special Payments | 30 | AUTOM | Automatic indicator | nvarchar | 1 | 0 | | |
10 | ZZSPECA | Actual line item table | 31 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
11 | ZZSPECP | Plan line item table | 95 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPBasic Functions |
12 | FILCA | FI-LC: Actual journal entry table with 2 object tables | 41 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
13 | FILCP | FI-LC: Plan line items for object table | 120 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
14 | GLFUNCA | Actual Line Items Table for Cost of Sales Accounting | 31 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
15 | GLFUNCP | Plan Line Items Table for Cost of Sales Accounting | 95 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
16 | GLFUNCU | Rollup line item tables with function area for IDES | 31 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
17 | GLFUNCV | Rollup plan line items table with function area for IDES | 95 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
18 | GLP0 | Local Logical General Ledger Plan Line Items | 71 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
19 | GLPO1 | Plan Line Items for Object Table | 121 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
20 | GLPO2 | Plan Line Items for Object Table Global | 129 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
21 | GLPO3 | Plan Line Items for Object Table | 121 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
22 | GLREFU | Example for FI-SL Rollup Line Items (Actual) | 33 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
23 | GLREFV | Example for Rollup FI-SL Line Items (Plan) | 113 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
24 | GLSO1 | FI-SL Line Item Table with Objects for GLTO1 | 41 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
25 | GLSO2 | FI-SL Table with Objects, Structure corresponds to GLS2 | 49 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
26 | GLSO3 | FI-SL LI Table with Objects for GLTO3 | 41 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPCollectionsDisbursements |
27 | GLISDEA | Actual Line Item Tables for Insurance (DE) | 43 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
28 | GLISDEP | Plan Line Item Table for Insurance (DE) | 107 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
29 | GRISDEA | Actual Line Item Table for Insurance (DE) - Rollup | 43 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
30 | GRISDEP | Plan Line Item Table for Insurance (DE) - Rollup | 107 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPConsolidation |
31 | ECMCA | SAP Cons.: Journal Entry Table (Actual) | 40 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPCost Element Accounting |
32 | COFIP | Single plan items for reconciliation ledger | 107 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
33 | COFIS | Actual line items for reconciliation ledger | 43 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPFunds Management |
34 | FMIA | Actual Line Item Table for Funds Management | 34 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
35 | FMIP | Plan Line Items Table for Funds Management | 66 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
36 | JVPO1 | JVA: Plan Line Items | 105 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
37 | JVSO1 | JV LI Table with Objects for JVTO1 | 41 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
38 | JVSO2 | JV Billing FI-SL Line Item | 25 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPProcess Controls |
39 | GRPCCTRLPROPOSAL | GRPC:Control Proposal | 16 | AUTOM | Automation | nvarchar | 10 | 0 | | |
TOPProfit Center Accounting |
40 | GLPCA | EC-PCA: Actual Line Items | 38 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
41 | GLPCP | EC-PCA: Plan Line Items | 99 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPTariffs, Duties and Permits |
42 | OIHSLA | TDP (excise duty) special ledger actual line item table | 50 | AUTOM | Indicator: Automatic posting lines | nvarchar | 1 | 0 | | |
TOPTravel Planning |
43 | FTPT_CAR | Travel Request Item - Car Rental Service | 66 | AUTOM | Automatic Transmission Requested | nvarchar | 1 | 0 | | |
44 | FTPT_CAR_PREF | Rental car service preferences of a travel plan | 12 | AUTOM | Automatic Transmission Requested | nvarchar | 1 | 0 | | |
45 | PA0473 | HR master record infotype 0473 (rental car preferences) | 27 | AUTOM | Automatic Transmission Requested | nvarchar | 1 | 0 | | |
TOPWarranty Claim Processing |
46 | CWTYA04 | Action Matrix | 6 | AUTOM | Call Up Action Automatically | nvarchar | 1 | 0 | | |