| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSEG | Accounting Document Segment | 63 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
2 | BSSEG | Accounting Document Segment | 52 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
3 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 52 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
4 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 52 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
5 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 52 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
6 | GLPOS_C_CT | FI Document: Entry View | 109 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
7 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 109 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
8 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 109 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
9 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 109 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
10 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 111 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
11 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 111 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
12 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 273 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
13 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 273 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPBasic Functions |
14 | FDD1 | Cash mgmt and forecast-Loan line items-Memo records | 10 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
15 | FDFIEP | CM: FI Line Items (OP of Deb/Cred for Drilldown) | 8 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
16 | FDI1 | Cash Management Line Item for RE Classic Planning Records | 10 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
17 | FDLF | Cash Management Line Items for Agency Business | 10 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
18 | FDLF2 | Cash Management Line Items for Agency Business (As of 604) | 11 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
19 | FDM1 | Cash Management & Forecast: Line Items of MM Documents | 13 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
20 | FDM2 | Cash management line items from MM purchase requisition | 9 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
21 | FDMV | Cash Planning Line Items of Earmarked Funds | 17 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
22 | FDRE | Cash Management Line Items from RE-FX (Real Estate) | 7 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
23 | FDS2 | CM&F Line Items in SD Documents (fromr Release 4.0) | 12 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
24 | FDSP | Cash Mgmt Adjustment Items from Document Splitting | 27 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
25 | FDT1 | CMF Line Items for Forex, Money Market, Derivatives | 12 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
26 | FDW1 | Cash Mgt and Forecast - Securities Line Items- Planned Flows | 11 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPCollectionsDisbursements |
27 | DIMAIOBPAR | IO: Insurance Object-Partner Relationship in FS-CD | 15 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
28 | VVKKFOP | Single Doc in Posting Data Interface | 70 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
29 | VVKKFOPT | Table for FS-CD Test Data of Structure VKKKFOP | 47 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
30 | VVSCITEM | Bill Scheduling: Scheduling Document | 57 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
31 | VVSCITEM_MAN | Scheduling Items: Temp. Storage for Manual -> Auto Change | 57 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
32 | VVSCPOS | Payment Plan Item | 125 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPContract Accounts Receivable and Payable |
33 | DFKKCASHFC | Interim Table for Cash Management and Forecast Data | 6 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
34 | DFKKIP_GRP | Payment Specification: Header Data | 36 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
35 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 38 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
36 | DFKKMOP | Items in contract account document | 78 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
37 | DFKKOP | Items in contract account document | 78 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
38 | DFKKOP_REP | Open Items from FPO4 | 82 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
39 | DFKKORDERPOS | Requests: Items | 67 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
40 | DFKKORDERPOS_S | Request Templates: Items | 52 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
41 | DFKKPP | Promises to Pay Header Table | 17 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
42 | FKKVKP | Contract Account Partner-Specific | 42 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPContract Billing |
43 | ERCH | Billing Doc. Data | 85 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
44 | VBSEGD | Document Segment for Customer Document Parking | 34 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
45 | VBSEGK | Document Segment for Vendor Document Parking | 39 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
46 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 31 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPFunds Management-Specific Postings |
47 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 32 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
48 | PSOSEGD | Document Segment: Recurring Request, Customer | 35 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
49 | PSOSEGK | Recurring Request Document Segment, Vendors | 40 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
50 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 31 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPInvoicing |
51 | DEABPS | Customer change table: Logical view of BB amounts | 71 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPMaster Data |
52 | T012K | House Bank Accounts | 11 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
53 | TFICA_DEF | Samples for Contract Account Types | 22 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPReal Estate Management |
54 | VIAKBSEG | Document Line Item from SCS for Interface | 55 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
55 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 54 | FDGRP | Planning Group | nvarchar | 10 | 0 | | |