| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPF15/XXBPDJ | F15 FI DUMMY | 4 | LEDNR | | nvarchar | 4 | 0 | | |
2 | AUAW | Settlement Document: Accounts for WIP Settlement | 7 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
3 | CNVTDMS_05_COEP | Collected Header Object Numbers for TDMS_Time-CO-OBJNR | 3 | LEDNR | LEDNR f0r CNVTDMS_05_* | nvarchar | 2 | 0 | | |
TOPAccounting |
4 | RPSCO | Project info database: Costs, revenues, finances | 3 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
TOPActual Payments and Forecast |
5 | COFP | Document Lines (project cash management) | 63 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
TOPBasic Functions |
6 | T872 | Equity Holdings Adjustments | 2 | LEDNR | Ledger | nvarchar | 2 | 0 | | |
7 | T873 | Hidden reserves | 2 | LEDNR | Ledger | nvarchar | 2 | 0 | | |
8 | T874 | Elimination of hidden reserves | 2 | LEDNR | Ledger | nvarchar | 2 | 0 | | |
TOPBudgeting |
9 | FMKF_TERM_RB | Key Figures - FM Terms | 7 | LEDNR | Key Figures - Ledger | nvarchar | 2 | 0 | | |
TOPCost Center Accounting |
10 | COSPR | CO Objekt: Enhancement to COSP for Dependency Planning | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
11 | TKSR1H | Summarization log (header) | 5 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPCost Object |
12 | COEPB | CO Object: Line Items Variance/Period-Based Results Analysis | 14 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
13 | COSB | CO Object: Total Variances/Results Analyses | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
14 | TKKAB | Posting Rules for Results Analysis Data | 4 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPCosting |
15 | COER | Sales Order Value Revenue | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPFunds Management |
16 | BPDG | Total Values Entry Document | 4 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
17 | BPDJ | Annual Values Entry Document | 4 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
18 | BPDP | Period Values Entry Document | 4 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
19 | BPEG | Line Item Overall Values Controlling Obj. | 8 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
20 | BPEJ | Line Item Annual Values Controlling Obj. | 9 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
21 | BPEP | Line Item Period Values Controlling Obj. | 37 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
22 | BPGE | Totals Record for Total Value Controlling obj. | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
23 | BPGV | Prel.entry, overall | 4 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
24 | BPJA | Totals Record for Annual Total Controlling Obj. | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
25 | BPJV | Prel.entry - annual values | 4 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
26 | BPPE | Totals Record for Period Values Controlling Obj. | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
27 | FCABK | FI-CA: Document Header | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
28 | FCABP | FI-CA: Document Item | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
29 | FMBE | FI-FM Cash Levels | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
30 | FMCFSI | TR-FM Selected Open Commitments | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
31 | FMEP | FI-FM Line Items | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
32 | FMREF | Active availability ctrl: Cross commitments reference table | 11 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
33 | FMSU | FI-FM Totals Records | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
34 | TBP0L | Budget/Planning Ledger | 4 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
TOPInformation System, iViews |
35 | COOI_PI | BW CO-OM: Commitment Management: Deleted Line Items | 9 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPLocal Currency Changeover |
36 | EWUCOK | Exception table for TWAER conversion | 3 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPLocalization |
37 | VIXCFRBUDGET | Budget Seasonality Data | 5 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPOrders for Projects |
38 | COSPP | Transfer of the Order in the COSP Table to the Project | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
39 | COSSP | Transfer of the Order COSS Table to the Project | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
40 | FMSP | Copy FMSU table order to project | 2 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |
TOPOverhead Cost Controlling |
41 | COEJ | CO Object: Line Items (by Fiscal Year) | 166 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
42 | COEJL | CO Object: Line Items for Activity Types (by Fiscal Year) | 106 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
43 | COEJR | CO Object: Line Items for Stat. Key Figures (by Fiscal Year) | 41 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
44 | COEJT | CO Object: Line Items for Prices (by Fiscal Year) | 102 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
45 | COEP | CO Object: Line Items (by Period) | 16 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
46 | COEPL | CO Object: Line Items for Activity Types (by Period) | 16 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
47 | COEPR | CO Object: Line Items for Stat. Key Figs (by Period) | 11 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
48 | COEPT | CO Object: Line Items for Prices (by Period) | 12 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
49 | COKL | CO Object: Control Data for Activity Types | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
50 | COKP | CO Object: Control Data for Primary Planning | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
51 | COKR | CO Object: Control Data for Statistical Key Figures | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
52 | COKS | CO Object: Control Data for Secondary Planning | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
53 | COSL | CO Object: Activity Type Totals | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
54 | COSP | CO Object: Cost Totals for External Postings | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
55 | COSR | CO Object: Statistical Key Figure Totals | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
56 | COSS | CO Object: Cost Totals for Internal Postings | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
57 | COST | CO Object: Price Totals | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
58 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 18 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPOverhead Cost Orders |
59 | COOI | Commitments Management: Line Items | 9 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
60 | COSBD | CO Object: Total of variances/accruals, of which settled | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
61 | COSLD | CO Object: Activity Type Totals - of Which Settled | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
62 | COSPD | CO Object: Settled Primary Cost Totals | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
63 | COSSD | CO Object: Settled Secondary Cost Totals | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPPegging, Grouping, and Distribution |
64 | DIS_TOBJS_FMSU | Distribution: Objects distributed to per Group WBS (Cash) | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPProduct Cost Planning |
65 | CKHS | Header: Unit Costing (Control + Totals) | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
66 | CKHT | Texts for CKHS | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
67 | CKIP | Unit Costing: Period Costs Line Item | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
68 | CKIS | Items Unit Costing/Itemization Product Costing | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
69 | CKIT | Texts for CKIS | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPProfitability Analysis |
70 | CECOEJ | CO-PA Account Based Line Items | 168 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
71 | CECOEP | CO-PA Account Based Line Items | 18 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPReport Selection for Product Costing |
72 | CKBOB | KKB: Object Record (Fixed Database Portion) | 2 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | | |
TOPSimulation |
73 | VSRPSCO_CN | Version: Cumulation table for project reporting | 4 | LEDNR | Budget/Planning Ledger | nvarchar | 4 | 0 | | |