| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPF15/F15 | F15 Belege (Kopfdaten) | 37 | TWAER | Transaktionswährung | nvarchar | 5 | 0 | | |
2 | /SAPF15/F15H | F15 Belege (Kopfdaten Historie) | 38 | TWAER | Transaktionswährung | nvarchar | 5 | 0 | | |
3 | /SAPF15/XXBPDJ | F15 FI DUMMY | 8 | TWAER | | nvarchar | 5 | 0 | | |
4 | AUAS | Settlement Document: Totals Segment | 9 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
5 | AUAT | Settlement Document: Totals Segment Per Period | 10 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
6 | AUAW | Settlement Document: Accounts for WIP Settlement | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
7 | CMCBD_BGT_CLAIM | Budget claims based on suggest level | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
8 | CNV_20100_COES | Duplicate COES keys (target values) | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
9 | FKKSK_VATLED | FI-CA Slovakia: VAT Ledger Exported Data | 22 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
10 | FLQITEMMMPARK_FC | Liquidity Calculation - Forecast Line Items for MM Documents | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
11 | FLQITEMPARK_FC | Liquidity Calculation - Forecast Line Items for FI Documents | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPAccounting |
12 | RPSCO | Project info database: Costs, revenues, finances | 12 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
13 | RPSQT | Project info database: quantities | 11 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPActual Payments and Forecast |
14 | COFP | Document Lines (project cash management) | 5 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPBasic Functions |
15 | FDS2 | CM&F Line Items in SD Documents (fromr Release 4.0) | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
16 | FLQITEMC1_FC | Liquidity Calculation: Forecast from Securities | 8 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPBudgeting and Availability Control |
17 | FMKOBP | Local Authority Funds Management Additional Data | 9 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPCollectionsDisbursements |
18 | VVKKTAXREP | Tax Reporting ITA: Data for Tax Report | 21 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPContract Accounts Receivable and Payable |
19 | DFKKITVATM | VAT monthly report for Italy: history table | 6 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
20 | DFKKITVATQ | VAT quarterly report for Italy: history table | 6 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
21 | DFKKREP06 | Tax Report Data (Invoicing Time or Triggered) | 19 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
22 | DFKKREP06_S | Tax Report Data - Shadow Table for Posting Date | 19 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
23 | DFKKREP07 | Tax Report Data (Clearing Time) | 25 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
24 | DFKKREP07_T | Tax Report Data (Additional Data for Transfer Posting) | 12 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
25 | DFKKREV06 | Report for Tax on Sales/Purchases (bill. time or triggered) | 15 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
26 | DFKKREV07 | Report on Tax on Sales/Purchases (clearing time) | 21 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPCost Center Accounting |
27 | COSPR | CO Objekt: Enhancement to COSP for Dependency Planning | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPCost Object |
28 | COEPB | CO Object: Line Items Variance/Period-Based Results Analysis | 27 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
29 | COSB | CO Object: Total Variances/Results Analyses | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPCosting |
30 | COER | Sales Order Value Revenue | 10 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
31 | COES | CO Object: Sales Order Value Line Items | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPData Retention Tool |
32 | TXW_S_COEP | Retrieve COEP from archive | 42 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPExpense-Related Billing |
33 | PRSD_DMRP_ACC_CH | Engagement Mgmt: Accrual Characteristics for DMR Lines | 6 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPFlexible Real Estate Management |
34 | VIAKHO13 | WEG-Verwaltung: Umlage Eigentümerabrechnung | 29 | TWAER | Transaktionswährung | nvarchar | 5 | 0 | | |
TOPFunds Management |
35 | BPDG | Total Values Entry Document | 8 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
36 | BPDJ | Annual Values Entry Document | 8 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
37 | BPDP | Period Values Entry Document | 8 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
38 | BPEG | Line Item Overall Values Controlling Obj. | 16 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
39 | BPEJ | Line Item Annual Values Controlling Obj. | 18 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
40 | BPEP | Line Item Period Values Controlling Obj. | 46 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
41 | BPGE | Totals Record for Total Value Controlling obj. | 10 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
42 | BPGV | Prel.entry, overall | 12 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
43 | BPJA | Totals Record for Annual Total Controlling Obj. | 11 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
44 | BPJV | Prel.entry - annual values | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
45 | BPPE | Totals Record for Period Values Controlling Obj. | 11 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
46 | FCABP | FI-CA: Document Item | 6 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
47 | FMBE | FI-FM Cash Levels | 9 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
48 | FMCFBPAKS | FM-FYC: Budget/Planning Updates (Interim Storage) | 29 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
49 | FMCFSI | TR-FM Selected Open Commitments | 10 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
50 | FMCFSIF | FI-FM: Selected Open Documents from FI Update | 9 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
51 | FMCFSIF_TR | Selected Open FI Documents (Settlement) | 9 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
52 | FMCFSIO | FI-FM: Selected Open Commitment Documents | 16 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
53 | FMCFSIO_TR | FI-FM: Selected Open Commitment Documents | 16 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
54 | FMEP | FI-FM Line Items | 10 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
55 | FMICOIT | FM/CO integration: Line item | 6 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
56 | FMIFIIT | FI Line Item Table in Funds Management | 30 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
57 | FMIOI | Commitment Documents Funds Management | 36 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
58 | FMREF | Active availability ctrl: Cross commitments reference table | 12 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
59 | FMSU | FI-FM Totals Records | 10 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
60 | FMUDBSEG | Addtl Info on Revenues Increasing Budget for Recovery Order | 22 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
61 | FMUDBSEGH | Addtl Info on Revenues Increasing Budget for Recovery Order | 20 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
62 | FMUDKBLP | Addtl Info re Revenues Increasing Budget for Fcst of Revenue | 20 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
63 | FMUDKBLPH | Addtl Info re Revenues Increasing Budget for Fcst of Revenue | 25 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPInformation System, iViews |
64 | COOI_PI | BW CO-OM: Commitment Management: Deleted Line Items | 23 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPLocalization |
65 | ITFM_D_RESIDUALS | ITFM: Residuals: EFD Residuals data Table | 17 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
66 | VIXCFRBUDGET | Budget Seasonality Data | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPOrders for Projects |
67 | COSPP | Transfer of the Order in the COSP Table to the Project | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
68 | COSSP | Transfer of the Order COSS Table to the Project | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
69 | FMSP | Copy FMSU table order to project | 11 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPOverhead Cost Controlling |
70 | COEJ | CO Object: Line Items (by Fiscal Year) | 180 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
71 | COEP | CO Object: Line Items (by Period) | 30 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
72 | COKP | CO Object: Control Data for Primary Planning | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
73 | COKS | CO Object: Control Data for Secondary Planning | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
74 | COSP | CO Object: Cost Totals for External Postings | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
75 | COSS | CO Object: Cost Totals for Internal Postings | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
76 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 32 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPOverhead Cost Orders |
77 | COOI | Commitments Management: Line Items | 23 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
78 | COSBD | CO Object: Total of variances/accruals, of which settled | 14 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
79 | COSPD | CO Object: Settled Primary Cost Totals | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
80 | COSSD | CO Object: Settled Secondary Cost Totals | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPPegging, Grouping, and Distribution |
81 | DIS_TOBJS_COSP | Distribution: Objects distributed to per Group WBS (Cost) | 12 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
82 | DIS_TOBJS_COSS | Distribution: Objects distributed to per Group WBS (Cost) | 12 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
83 | DIS_TOBJS_FMSU | Distribution: Objects distributed to per Group WBS (Cash) | 11 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPProduct Cost Planning |
84 | CKHS | Header: Unit Costing (Control + Totals) | 72 | TWAER | Item Foreign Currency | nvarchar | 5 | 0 | | |
85 | CKTC_CBEW | Costing Master Data - Attributes | 7 | TWAER | Currency Key | nvarchar | 5 | 0 | | |
TOPProfitability Analysis |
86 | CECOEJ | CO-PA Account Based Line Items | 182 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
87 | CECOEP | CO-PA Account Based Line Items | 32 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPReal Estate Management |
88 | IVBP | Line Item (Settlement: Service Charge Collector) (Obsolete) | 21 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
89 | VIAK13 | Apportionment Result for List Evaluation (SCSettlement) | 28 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPRevenues and Earnings |
90 | AD01DLI | Dynamic items (DI) | 5 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPSimulation |
91 | VSRPSCO_CN | Version: Cumulation table for project reporting | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
TOPTreasury |
92 | FLQITEMBS | Liquidity Calculation - Line Items for Bank Statement Docs | 15 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
93 | FLQITEMD1_FC | Liquidity Calculation: Forecast Line Items from Loans | 11 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
94 | FLQITEMFI | Liquidity Calculation - Line Items for Other FI Documents | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
95 | FLQITEMFI_FC | Liquidity Calculation - Forecast Line Items for FI Documents | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
96 | FLQITEMFI_TP | Liquidity Calculation: Actual Line Items at Top Level | 15 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
97 | FLQITEMMA | Liquidity Calculation - Line Items for Manual Transfers | 9 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
98 | FLQITEMPO_FC | Liquidity Calculation - Forecast Line Items for MM POs | 13 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
99 | FLQITEMPR_FC | Liquidity Calc. Forecast - Line Items, Purchase Requisitions | 10 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
100 | FLQITEMSO_FC | Liquidity Calculation-Forecast Line Items from Sales Orders | 9 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
101 | FLQITEMT1_FC | Liquidity Calculation: Forecast Line Items from TR Trans. | 12 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
102 | FLQSUM | Liquidity Calculation - Totals Records | 4 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
103 | FLQSUM_FC | Liquidity Calculation - Forecast Totals Records | 9 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |
104 | FLQSUM_TP | Liquidity Calculation: Totals Records at Top Level | 4 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | |