| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPF15/XXBPDJ | F15 FI DUMMY | 6 | WRTTP | | nvarchar | 2 | 0 | | |
2 | AUAW | Settlement Document: Accounts for WIP Settlement | 9 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
3 | CNV_20100_COES | Duplicate COES keys (target values) | 8 | WRTTP | | nvarchar | 2 | 0 | | |
TOPAccounting |
4 | RPSCO | Project info database: Costs, revenues, finances | 4 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
5 | RPSQT | Project info database: quantities | 3 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPActual Payments and Forecast |
6 | COFP | Document Lines (project cash management) | 9 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPAvailability Control |
7 | FMAVCUPDFILTV | AVC Filter Settings for Posting Data: Excluded Value Types | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPBudgeting |
8 | BUWRTTP | Mapping rules for migration from FBS to BCS - Field WRTTP | 1 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
9 | FMKF_TERM_RB | Key Figures - FM Terms | 8 | WRTTP | Key Figures - Value Type | nvarchar | 2 | 0 | | |
TOPBudgeting and Availability Control |
10 | FMFCTRMV | Store Bgt vals. returned before moving funds ctr. | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
11 | FMKOBP | Local Authority Funds Management Additional Data | 4 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPCost Center Accounting |
12 | COSPR | CO Objekt: Enhancement to COSP for Dependency Planning | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
13 | TKSR3 | Summarization - value type | 3 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
14 | TKSR3H | Summarization log - value types | 5 | WRTTP | Value type | nvarchar | 2 | 0 | | |
TOPCost Element Accounting |
15 | COFIO2 | Transaction-dependent fields for reconciliation ledger | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
16 | COFIP | Single plan items for reconciliation ledger | 37 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
17 | COFIS | Actual line items for reconciliation ledger | 37 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
18 | COFIT | Totals Records for Reconciliation Ledger | 36 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPCost Object |
19 | COEPB | CO Object: Line Items Variance/Period-Based Results Analysis | 17 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
20 | COSB | CO Object: Total Variances/Results Analyses | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPCosting |
21 | COER | Sales Order Value Revenue | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
22 | COES | CO Object: Sales Order Value Line Items | 7 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPData Collection |
23 | CF003 | Projects | 34 | WRTTP | Value type in order cost segment | nvarchar | 1 | 0 | | |
TOPExpense-Related Billing |
24 | PRSD_DMRP_ACC_CH | Engagement Mgmt: Accrual Characteristics for DMR Lines | 15 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPFunctions for U.S. Federal Government |
25 | FMFG_UO_OBL_FMVT | SO Adjustmnt Prog: Value Types to include in Obligations | 2 | WRTTP | Unfilled Orders: Value Type | nvarchar | 2 | 0 | | |
TOPFunds Management |
26 | BPCG | Controlling Object, by Year | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
27 | BPCJ | Controlling Object, by Year | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
28 | BPCK | Controlling objects, activated objects | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
29 | BPDG | Total Values Entry Document | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
30 | BPDJ | Annual Values Entry Document | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
31 | BPDP | Period Values Entry Document | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
32 | BPEG | Line Item Overall Values Controlling Obj. | 12 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
33 | BPEJ | Line Item Annual Values Controlling Obj. | 13 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
34 | BPEP | Line Item Period Values Controlling Obj. | 41 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
35 | BPGE | Totals Record for Total Value Controlling obj. | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
36 | BPGV | Prel.entry, overall | 8 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
37 | BPHI | Cross-hierarchy Data Controlling obj. | 3 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
38 | BPIG | Budget Object Index (Overall Budget) | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
39 | BPIJ | Budget Object Index (Annual Budget) | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
40 | BPJA | Totals Record for Annual Total Controlling Obj. | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
41 | BPJV | Prel.entry - annual values | 8 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
42 | BPPE | Totals Record for Period Values Controlling Obj. | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
43 | BPTR | Object Data Controlling Obj. | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
44 | BPTX | Budgeting Text | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
45 | FCABK | FI-CA: Document Header | 7 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
46 | FCABP | FI-CA: Document Item | 10 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
47 | FM01DF | Budget Type: Assignment to Cover Eligibility | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
48 | FM2BLACTC | FM2BL - Activation of Commitment/Actual Value Types | 4 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
49 | FMAC2 | FM to FI - GL Account Assignment | 3 | WRTTP | Generic entry for FM value types | nvarchar | 2 | 0 | | |
50 | FMBE | FI-FM Cash Levels | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
51 | FMCCFD | Fiscal Year Change Documents (FM) | 34 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
52 | FMCCFLOT | Commitment Carryforward of Held Documents (Approval Proc.) | 20 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
53 | FMCFC1 | FYC Commitment Control | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
54 | FMCFC1R | FYC Commtiment Control (Carryforward Parameter) | 4 | WRTTP | FM Cmmt Carryfwd:Vlue Catgs of Docs that can be Carried Frwd | nvarchar | 2 | 0 | | |
55 | FMCFSI | TR-FM Selected Open Commitments | 19 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
56 | FMCFSIF | FI-FM: Selected Open Documents from FI Update | 16 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
57 | FMCFSIF_TR | Selected Open FI Documents (Settlement) | 16 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
58 | FMCFSIO | FI-FM: Selected Open Commitment Documents | 19 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
59 | FMCFSIO_TR | FI-FM: Selected Open Commitment Documents | 19 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
60 | FMCHA1 | Work List for Reassignment Tool | 13 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
61 | FMCNAI | FM Line Items with Active CCN Logic | 8 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
62 | FMCOPI | CO-FM: Plan Data Transfer - Annual/Overall Values | 15 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
63 | FMEP | FI-FM Line Items | 7 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
64 | FMICOIT | FM/CO integration: Line item | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
65 | FMIFIIT | FI Line Item Table in Funds Management | 26 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
66 | FMIO | Object Table for Funds Management | 11 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
67 | FMIOI | Commitment Documents Funds Management | 32 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
68 | FMREF | Active availability ctrl: Cross commitments reference table | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
69 | FMSU | FI-FM Totals Records | 7 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
70 | FMUP01 | Update Control with Value Type Dependency | 2 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
71 | FMUP02 | Customizbare Felder zum Fortschreibungsprofil | 3 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
72 | TBP1C | Budget/Plan Profile | 4 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
73 | TBP1T | Budget / Plan Profile Texts | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
74 | TBP3A | Budget / plan versions from rel.3.0 | 4 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
75 | TBP3B | Texts for planning / budgeting versions | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
76 | TBPFD | Cost Budget Availability Control: Tolerance Limits | 3 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
77 | TBPFE | FM Availability Control: Tolerance Limits | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
78 | TBPFPV | Commitment Types: Control | 4 | WRTTP | Commitment value type | nvarchar | 2 | 0 | | |
TOPInformation System |
79 | BIWTCSH_CV | Texts: Payment Characteristics | 2 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
80 | BIW_CSH_CV | Conversion Table for Payments | 2 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPInformation system |
81 | FMKF_REPTERM | Key Figure Terms for Reporting Because of New Budget Tables | 6 | WRTTP | Key Figures - Value Type | nvarchar | 2 | 0 | | |
TOPInformation System, iViews |
82 | COOI_PI | BW CO-OM: Commitment Management: Deleted Line Items | 17 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPLocal Currency Changeover |
83 | EWUCOK | Exception table for TWAER conversion | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPLocalization |
84 | VIXCFRBUDGET | Budget Seasonality Data | 3 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPMaintenance History |
85 | /OLC/PMCO_OP | OLC: PMCO for operations | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
86 | PMCO | Cost structure of maintenance order | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
87 | PMCO3 | Plan version: Estimated costs for maintenance orders | 4 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
88 | PMCO_OP | Cost structure of maintenance order | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPMaintenance Orders |
89 | PMCOQT | Quantity structure for the maintenance order | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
90 | PMCOQT_OP | Quantity structure for the maintenance order | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPMaster Data Distribution |
91 | /ISDFPS/FMWRTTP | Value Types | 1 | WRTTP | Version Number Component | nvarchar | 2 | 0 | | |
92 | /ISDFPS/FMWRTTPH | Value Types | 1 | WRTTP | Version Number Component | nvarchar | 2 | 0 | | |
TOPOrders for Projects |
93 | COSPP | Transfer of the Order in the COSP Table to the Project | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
94 | COSSP | Transfer of the Order COSS Table to the Project | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
95 | FMSP | Copy FMSU table order to project | 7 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPOverhead Cost Controlling |
96 | COEJ | CO Object: Line Items (by Fiscal Year) | 169 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
97 | COEJL | CO Object: Line Items for Activity Types (by Fiscal Year) | 109 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
98 | COEJR | CO Object: Line Items for Stat. Key Figures (by Fiscal Year) | 44 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
99 | COEJT | CO Object: Line Items for Prices (by Fiscal Year) | 105 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
100 | COEP | CO Object: Line Items (by Period) | 19 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
101 | COEPL | CO Object: Line Items for Activity Types (by Period) | 19 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
102 | COEPR | CO Object: Line Items for Stat. Key Figs (by Period) | 14 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
103 | COEPT | CO Object: Line Items for Prices (by Period) | 15 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
104 | COKP | CO Object: Control Data for Primary Planning | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
105 | COKR | CO Object: Control Data for Statistical Key Figures | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
106 | COKS | CO Object: Control Data for Secondary Planning | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
107 | COSL | CO Object: Activity Type Totals | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
108 | COSP | CO Object: Cost Totals for External Postings | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
109 | COSR | CO Object: Statistical Key Figure Totals | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
110 | COSS | CO Object: Cost Totals for Internal Postings | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
111 | COST | CO Object: Price Totals | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
112 | COVP_DELTA_LOG | Log of COVP Delta Queue for Error Analysis | 21 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPOverhead Cost Orders |
113 | AUAK | Document Header for Settlement | 33 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
114 | COOI | Commitments Management: Line Items | 17 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
115 | COSBD | CO Object: Total of variances/accruals, of which settled | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
116 | COSLD | CO Object: Activity Type Totals - of Which Settled | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
117 | COSPD | CO Object: Settled Primary Cost Totals | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
118 | COSSD | CO Object: Settled Secondary Cost Totals | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPPegging, Grouping, and Distribution |
119 | DIS_TOBJS | Distribution: cost objects posted to per group | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
120 | DIS_TOBJS_COSP | Distribution: Objects distributed to per Group WBS (Cost) | 7 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
121 | DIS_TOBJS_COSS | Distribution: Objects distributed to per Group WBS (Cost) | 6 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
122 | DIS_TOBJS_FMSU | Distribution: Objects distributed to per Group WBS (Cash) | 8 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPPersonnel Management |
123 | /BKC/S21_A_WRTTP | Clone and Test - AC - Planned Value Types | 2 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPProfitability Analysis |
124 | CECOEJ | CO-PA Account Based Line Items | 171 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
125 | CECOEP | CO-PA Account Based Line Items | 21 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPProfitability Analysis Basic Functions |
126 | K840001 | Summarization level KT: 800 KK 01 KKROBJ 000001 | 21 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
127 | K840003 | Summarization level KT: 800 KK 01 KKROBJ 000002 | 16 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
128 | K840005 | Summarization level KT: 800 KK 01 KKROBJ 000003 | 23 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
129 | K840007 | Summarization level KT: 800 KK 01 KKROBJ 000004 | 18 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
130 | K840009 | Summarization level KT: 800 KK 01 KKROBJ 000005 | 24 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
131 | K840011 | Summarization level KT: 800 KK 01 KKROBJ 000006 | 19 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPRevenues and Earnings |
132 | AD01DLI | Dynamic items (DI) | 14 | WRTTP | Value Type | nvarchar | 2 | 0 | | |
TOPSimulation |
133 | VSRPSCO_CN | Version: Cumulation table for project reporting | 5 | WRTTP | Value Type | nvarchar | 2 | 0 | | |