| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 193 | PGRANT_NBR | | nvarchar | 20 | 0 | | |
2 | /BIC/B0000218000 | PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs | 31 | PGRANT_NBR | | nvarchar | 20 | 0 | | |
3 | /BIC/B0000223000 | PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta | 57 | PGRANT_NBR | | nvarchar | 20 | 0 | | |
4 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 75 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
5 | BSEG | Accounting Document Segment | 332 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
6 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 75 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
7 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 320 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
8 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 320 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
9 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 322 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
10 | GLPOS_C_CT | FI Document: Entry View | 192 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
11 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 192 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
12 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 192 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
13 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 192 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
14 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 195 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
15 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 195 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPAccounting Interface |
16 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 403 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
17 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 403 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPControlling |
18 | COKEY2 | CO Key Subnumbers Enhancement Table | 8 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPFinancial Accounting |
19 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 75 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
20 | BSIS | Accounting: Secondary Index for G/L Accounts | 75 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
21 | VBSEGA | Document Segment for Document Parking - Asset Database | 87 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
22 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 143 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPFunds Management-Specific Postings |
23 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 140 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPGeneral Ledger Accounting |
24 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 77 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
25 | FAGL_SPLINFO | Splittling Information of Open Items | 73 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPOverhead Cost Controlling |
26 | COEJ | CO Object: Line Items (by Fiscal Year) | 195 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
27 | COEP | CO Object: Line Items (by Period) | 73 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
28 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 75 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
TOPProfitability Analysis |
29 | CECOEJ | CO-PA Account Based Line Items | 197 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |
30 | CECOEP | CO-PA Account Based Line Items | 75 | PGRANT_NBR | Partner Grant | nvarchar | 20 | 0 | | |