I_COSTCENTERACTIVITYTYPE

CDS View

Cost Center Activity Type

I_COSTCENTERACTIVITYTYPE is a CDS View in S/4HANA. Cost Center Activity Type. It contains 8 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
A_CostCenterActivityType view from BASIC Activity Type
C_CostCenterActivityType view from CONSUMPTION Cost Center Activity Type
C_Costcenteractivityvalhlp view from CONSUMPTION Cost Center Activity Value Help
C_ProjDemandActivityTypeVH view from CONSUMPTION Activity Type Demand for Work
C_WhereUsedListActivityTypeVH view_entity from CONSUMPTION Where Used List Activity Type
ESH_ACTIVITYTYPE_BASIS view from Basis view for ESH ActivityType
FAC_CDS_UH_ACTIVITYTYPE_MD view from Activity Type Master Data
FAC_CDS_UH_CCACTIVITYTYPE view from Cost Center Activity Type Master Data
I_ActyTypeDIPProfile view left_outer COMPOSITE DIP Profile
I_CostCenterActivityTypeStdVH view from COMPOSITE Cost Center Activity Type
I_CostCenterActivityTypeVH view from BASIC Cost Center Activity Type Value Help
I_EngmntProjCostCenterActyType view from COMPOSITE Engagement Project Cost Center Activity Type
P_ActivityTypeChangeLogVH view_entity from CONSUMPTION Activity Type Change Log Value Help
P_ActivityTypeChangeLogVH view_entity union CONSUMPTION Activity Type Change Log Value Help
P_ActyTypeValidCurrent view from BASIC Cost Center Activity Types Valid Today
P_ActyTypeValidLatest view from BASIC Cost Center Activity Types With Max End Date
P_CostCenterActivityTypeTP view from COMPOSITE
P_EngmntProjActyRsceType view left_outer COMPOSITE
P_NextCostCtrActivityType view from COMPOSITE
P_PreviousCostCtrActivityType view from COMPOSITE
R_CostCtrActyTpValdtyPerdEvt view_entity from TRANSACTIONAL Cost Center Activity Type Business Event

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ControllingArea ControllingArea 5
KEY CostCtrActivityType CostCtrActivityType 5
KEY ValidityEndDate ValidityEndDate 4
_ControllingArea _ControllingArea 1
_CostCtrActivityTypeCategory _CostCtrActivityTypeCategory 1
CostCtrActivityTypeCategory CostCtrActivityTypeCategory 1
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit 3
ValidityStartDate CostCtrActyTypeValdtyStartDate,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 Center Activity Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_COSTCENTERACTIVITYTYPE (
    CONTROLLINGAREA,
    COSTCTRACTIVITYTYPE,
    VALIDITYENDDATE,
    _CONTROLLINGAREA,
    _COSTCTRACTIVITYTYPECATEGORY,
    COSTCTRACTIVITYTYPECATEGORY,
    COSTCTRACTIVITYTYPEQTYUNIT,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CONTROLLINGAREA, COSTCTRACTIVITYTYPE, VALIDITYENDDATE)
);