I_COSTELEMENTONCONTROLLINGAREA

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);