C_ActyTypeProdnWrkCtr

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ActyTypeProdnWrkCtr.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CACTYTYPEPWRKCTR

CREATE VIEW C_ActyTypeProdnWrkCtr AS
SELECT
  ActyTypeWhereUsedObjType,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  CostCenterAllocation,
  cast( case when ValidityEndDate < CostCtrActyTypeValdtyEndDate then ValidityEndDate else CostCtrActyTypeValdtyEndDate end as actytypewhereusedwrkctrvalidto preserving type ) AS ValidityEndDate,
  CostCtrActivityType,
  cast( case when ValidityStartDate > CostCtrActyTypeValdtyStartDate then ValidityStartDate else CostCtrActyTypeValdtyStartDate end as actytypewhereusedwcvalidfrom preserving type ) AS ValidityStartDate,
  WorkCenter,
  WorkCenterText,
  Plant,
  PlantName,
  ControllingArea,
  CostCtrActivityTypeName,
  CostCtrActivityTypeQtyUnit,
  cast(CostCenterActivityTypeFormula as actytypewhereusedwcformula preserving type ) AS CostCenterActivityTypeFormula,
  CostCtrActyTypeIsReferenced,
  cast(CostCtrActyTypeIncntvWageCode as actytypewhereusedwcincntvwgind preserving type ) AS CostCtrActyTypeIncntvWageCode,
  cast(CostCtrActyTypeRecdTypeGrpCode as actytypewhereusedwcrectypegrp preserving type ) AS CostCtrActyTypeRecdTypeGrpCode,
  cast(CostCtrActyTypeValdtyStartDate as activitytypevaliditystartdate preserving type ) AS CostCtrActyTypeValdtyStartDate,
  cast(CostCtrActyTypeValdtyEndDate as activitytypevalidityenddate preserving type ) AS CostCtrActyTypeValdtyEndDate,
  ProdnRsceToolQtyCalcFmlaName,
  StandardWorkFormulaParameter,
  StandardWorkFormulaParamName,
  WorkCenterCategoryCode,
  LastChangeDate,
  LastChangedByUser
FROM I_ActyTypeProdnWrkCtr
;