_COSTCENTERACTIVITYTYPE

9 Fields

_COSTCENTERACTIVITYTYPE is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ControllingArea ControllingArea 2
KEY CostCtrActivityType ActivityType,CostCtrActivityType,CostCtrActyTypeSearchElement 3
KEY FiscalYear FiscalYear 1
KEY ValidityEndDate CostCtrActyTypeValdtyEndDate,ValidityEndDate 2
KEY ValidityStartDate CostCtrActyTypeValdtyStartDate,ValidityStartDate 3
_Text _Text 1
AllocationCostElement AllocationCostElement 1
CostCtrActivityTypeCategory CostCtrActivityTypeCategory 1
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _COSTCENTERACTIVITYTYPE (
    CONTROLLINGAREA,
    COSTCTRACTIVITYTYPE,
    FISCALYEAR,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    _TEXT,
    ALLOCATIONCOSTELEMENT,
    COSTCTRACTIVITYTYPECATEGORY,
    COSTCTRACTIVITYTYPEQTYUNIT,
    PRIMARY KEY (CONTROLLINGAREA, COSTCTRACTIVITYTYPE, FISCALYEAR, VALIDITYENDDATE, VALIDITYSTARTDATE)
);

Learn More