_ACTIVITY

23 Fields

_ACTIVITY is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CostEstimate CostEstimate 2
KEY ProcessCategory ProcessCategory 2
CompanyCode CompanyCode 3
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CostCenterName CostCenterName 2
CostCtrActivityType CostCtrActivityType 1
CostCtrActivityTypeName CostCtrActivityTypeName 1
Currency Currency 3
ObjectInternalID ObjectInternalID 2
Operation Operation 1
Plant Plant 3
ProcessRouteActivityType ProcessRouteActivityType 1
ProfitCenter ProfitCenter,ProfitCenterMD 2
ProfitCenterMD ProfitCenterMD 1
ReferenceDocument ReferenceDocument 1
StatryRptCategory StatryRptCategory 1
StatryRptgEntity StatryRptgEntity 1
StatryRptPhaseUUID StatryRptPhaseUUID 1
SuperiorOperation SuperiorOperation 1
SuperiorOperationInternalID SuperiorOperationInternalID 1
ValuationArea ValuationArea 3
ValuationQuantityUnit ValuationQuantityUnit 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 _ACTIVITY (
    COSTESTIMATE,
    PROCESSCATEGORY,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCENTERNAME,
    COSTCTRACTIVITYTYPE,
    COSTCTRACTIVITYTYPENAME,
    CURRENCY,
    OBJECTINTERNALID,
    OPERATION,
    PLANT,
    PROCESSROUTEACTIVITYTYPE,
    PROFITCENTER,
    PROFITCENTERMD,
    REFERENCEDOCUMENT,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTPHASEUUID,
    SUPERIOROPERATION,
    SUPERIOROPERATIONINTERNALID,
    VALUATIONAREA,
    VALUATIONQUANTITYUNIT,
    PRIMARY KEY (COSTESTIMATE, PROCESSCATEGORY)
);

Learn More