| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSEG | Accounting Document Segment | 62 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
2 | BSSEG | Accounting Document Segment | 51 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
3 | CNV_20100_SKB1 | CNV backup copy for SKB1 | 11 | FDLEV | | nvarchar | 2 | 0 | | |
4 | FLQITEMMMPARK_FC | Liquidity Calculation - Forecast Line Items for MM Documents | 18 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
5 | FLQITEMPARK_FC | Liquidity Calculation - Forecast Line Items for FI Documents | 19 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
6 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 51 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
7 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 51 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
8 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 51 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
9 | GLPOS_C_CT | FI Document: Entry View | 110 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
10 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 110 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
11 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 110 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
12 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 110 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
13 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 112 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
14 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 112 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
15 | TFK036S | Planning Levels with Payment Locks | 2 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
16 | TFK036V | Different Planning Levels By Transactions | 3 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
17 | VIYCADVPAY | Advance Payments | 77 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
18 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 271 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
19 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 271 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPBasic Functions |
20 | FDFIEP | CM: FI Line Items (OP of Deb/Cred for Drilldown) | 9 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
21 | FDI1 | Cash Management Line Item for RE Classic Planning Records | 9 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
22 | FDLF | Cash Management Line Items for Agency Business | 11 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
23 | FDLF2 | Cash Management Line Items for Agency Business (As of 604) | 12 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
24 | FDM1 | Cash Management & Forecast: Line Items of MM Documents | 14 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
25 | FDM2 | Cash management line items from MM purchase requisition | 10 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
26 | FDMV | Cash Planning Line Items of Earmarked Funds | 18 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
27 | FDRE | Cash Management Line Items from RE-FX (Real Estate) | 6 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
28 | FDS2 | CM&F Line Items in SD Documents (fromr Release 4.0) | 15 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
29 | FDSP | Cash Mgmt Adjustment Items from Document Splitting | 25 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
30 | FLQITEMC1_FC | Liquidity Calculation: Forecast from Securities | 12 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
31 | SKB1 | G/L account master (company code) | 10 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
32 | SKM1 | Sample G/L accounts | 10 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPCollectionsDisbursements |
33 | VVSCITEM | Bill Scheduling: Scheduling Document | 59 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
34 | VVSCITEM_MAN | Scheduling Items: Temp. Storage for Manual -> Auto Change | 59 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
35 | DFKKCASHFC | Interim Table for Cash Management and Forecast Data | 7 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
36 | DFKKIP_GRP | Payment Specification: Header Data | 37 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
37 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 39 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
38 | DFKKMOP | Items in contract account document | 79 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
39 | DFKKMOPK | Items in contract account document | 17 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
40 | DFKKOP | Items in contract account document | 79 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
41 | DFKKOPK | Items in contract account document | 17 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
42 | DFKKOP_REP | Open Items from FPO4 | 83 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
43 | DFKKORDERPOS | Requests: Items | 68 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
44 | DFKKORDERPOS_S | Request Templates: Items | 53 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
45 | DFKKPOH | Payment Order: Header Data | 28 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
46 | DFKKPP | Promises to Pay Header Table | 18 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
47 | DFKKSUM | Posting totals from FI-CA | 26 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPDefault Risk and Limit System |
48 | KLCMMAPPING | Mapping Table for CM and Business Partner | 4 | FDLEV | Credit Limit: Level for Cash Management and Forecasting | nvarchar | 2 | 0 | | |
49 | KLXCMRT | CM Data for Risk Objects Derived from Cash Management | 6 | FDLEV | Credit Limit: Level for Cash Management and Forecasting | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
50 | VBSEGD | Document Segment for Customer Document Parking | 33 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
51 | VBSEGK | Document Segment for Vendor Document Parking | 38 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
52 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 30 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPFunds Management-Specific Postings |
53 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 31 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
54 | PSOSEGD | Document Segment: Recurring Request, Customer | 34 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
55 | PSOSEGK | Recurring Request Document Segment, Vendors | 39 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
56 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 30 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPInvoice Verification |
57 | RBKP | Document Header: Invoice Receipt | 120 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPInvoicing |
58 | DEABPS | Customer change table: Logical view of BB amounts | 72 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPPayment Transactions |
59 | PYORDH | Payment order header data | 14 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPPayments |
60 | DFKKBOH | Boleto: Header data | 31 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPReal Estate Contract |
61 | VICDCFOBJ | Object-Related Cash Flow | 74 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
62 | VICDCFPAY | Payment-Related Cash Flow | 73 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPReal Estate Management |
63 | VIAKBSEG | Document Line Item from SCS for Interface | 56 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
64 | VIBEPP | Flow data - Planned items for real estate management | 35 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
65 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 53 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
TOPTreasury |
66 | FLQITEMD1_FC | Liquidity Calculation: Forecast Line Items from Loans | 15 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
67 | FLQITEMFI_FC | Liquidity Calculation - Forecast Line Items for FI Documents | 18 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
68 | FLQITEMPO_FC | Liquidity Calculation - Forecast Line Items for MM POs | 18 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
69 | FLQITEMPR_FC | Liquidity Calc. Forecast - Line Items, Purchase Requisitions | 16 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
70 | FLQITEMSO_FC | Liquidity Calculation-Forecast Line Items from Sales Orders | 15 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
71 | FLQITEMT1_FC | Liquidity Calculation: Forecast Line Items from TR Trans. | 16 | FDLEV | Planning level | nvarchar | 2 | 0 | | |
72 | FLQSUM_FC | Liquidity Calculation - Forecast Totals Records | 8 | FDLEV | Planning level | nvarchar | 2 | 0 | | |