I_ActyTypeDIPProfile

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 I_ActyTypeDIPProfile.
-- 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: IACTTYPDPPR

CREATE VIEW I_ActyTypeDIPProfile AS
SELECT
  cast ( '9DIP' as actytypewhereusedobjecttype ) AS ActyTypeWhereUsedObjType,
  cast( '105' as setclass ) AS SetClass,
  cast(ControllingArea as subclass) AS SetSubClass,
  cast( '' as setname ) AS UniversalHierNodeParentID,
  _CostCenterActivityType.CostCtrActivityType AS CostCtrActivityType,
  ControllingArea,
  ValidityStartDate,
  ValidityEndDate,
  DynItemProcessorPrfl,
  RRBDynItmProfileUsage,
  DIPProfileMaterialDetnLineNmbr,
  DIPProfileItemSelSrceLineNmbr,
  ActivityTypeFieldName,
  DIPProfileUsageText,
  DIPProfileText,
  Material,
  DIPProfileSource,
  cast(AllocationSetId as setid) AS AllocationSetId,
  DIPProfileSelectionSrceText,
  cast( '' as settext) AS ActivityTypeGroupName,
  _CostCenterActivityType._Text[ Language = $session.system_language ].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _CostCenterActivityType.ValidityStartDate AS CostCtrActyTypeValdtyStartDate,
  CostCtrActyTypeValdtyEndDate
FROM I_ActyTypeDIPSourceMatlDetnRef AS _ActyTypeDIPSourceMatlDetnRef
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCenterActivityType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ActyTypeDIPGroupRefActyType AS _ActyTypeDipGroupRefActyType ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_ActyTypeDIPSourceMatlDetnRef
;