I_COSTELEMENTONCONTROLLINGAREA
Cost element depend on controlling area
I_COSTELEMENTONCONTROLLINGAREA is a CDS View in S/4HANA. Cost element depend on controlling area. It contains 8 fields. 20 CDS views read from this table.
CDS Views using this table (20)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_AllocationSenderGLAcctVH | view | inner | CONSUMPTION | Allocation Sender GL Account |
| C_OverheadAllocationAccountVH | view | inner | CONSUMPTION | Overhead Allocation Account Value Help |
| C_OvhdAllocAcctWithCtrlgAreaVH | view_entity | inner | CONSUMPTION | Overhead Alloc Account Controlling Area |
| C_UnivAllocOverheadAccountVH | view_entity | inner | CONSUMPTION | Overhead Allocation Account |
| C_UnivAllocOvhdAcctWthCtrlArVH | view_entity | inner | CONSUMPTION | Overhead Allocation Account |
| I_CostElement | view | inner | COMPOSITE | Cost Element |
| I_CostElmntOnCtrlgAreaStdVH | view | from | COMPOSITE | Cost element depend on controlling area |
| I_InternalOrderCostElementVH | view_entity | from | COMPOSITE | Cost Element |
| I_SrvcDocBslnPlannedCost | view | inner | COMPOSITE | Baseline Planned Cost of Srv Transaction |
| I_SrvcDocBslnPlannedRevenue | view | inner | COMPOSITE | Baseline Planned Revenue of Srv Txn |
| I_SrvcDocContnsPlannedCost | view_entity | inner | COMPOSITE | Ongoing Planned Cost of Srv Transaction |
| I_SrvcDocContnsPlannedRevenue | view_entity | inner | COMPOSITE | Ongoing Planned Revenue of Srv Trans |
| I_SrvcDocItmBslnPlannedCost | view | inner | COMPOSITE | Baseline Planned Cost of Srv Txn Item |
| I_SrvcDocItmBslnPlannedRevenue | view | inner | COMPOSITE | Baseline Planned Revenue of Srv Txn Item |
| I_SrvcDocItmContnsPlannedCost | view_entity | inner | COMPOSITE | Ongoing Planned Cost Srv Trans Item |
| I_SrvcDocItmContnsPlndRevenue | view_entity | inner | COMPOSITE | Ongoing Planned Revenue Srv Trans Item |
| P_DMVCECCostElement | view_entity | from | BASIC | |
| P_EffctvCostElmntOnCtrlgArea | view | from | COMPOSITE | |
| P_GLAccountVH | view | inner | CONSUMPTION | gl account vh |
| P_GLOverheadAccountVH | view | inner | CONSUMPTION | gl account vh |
Fields (8)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ControllingArea | ControllingArea | 4 |
| KEY | CostElement | CostElement | 3 |
| ConsumptionQtyIsRecorded | ConsumptionQtyIsRecorded | 1 | |
| CostElementCategory | CostElementCategory | 2 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| UnitOfMeasure | UnitOfMeasure | 1 | |
| ValidityEndDate | ValidityEndDate | 2 | |
| ValidityStartDate | ValidityStartDate | 2 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Cost element depend on controlling area
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COSTELEMENTONCONTROLLINGAREA (
CONTROLLINGAREA,
COSTELEMENT,
CONSUMPTIONQTYISRECORDED,
COSTELEMENTCATEGORY,
LASTCHANGEDATETIME,
UNITOFMEASURE,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
PRIMARY KEY (CONTROLLINGAREA, COSTELEMENT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA