C_ActyTypeWhereUsed

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_ActyTypeWhereUsed.
-- 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: CACTTPWHEREUSD

CREATE VIEW C_ActyTypeWhereUsed AS
SELECT
  ActyTypeWhereUsedObjType,
  cast ('' as filterhash) AS FioriUIFilterHash,
  cast ('' as actytypewhereusedobjecttypetxt) AS ActyTypeWhereUsedObjTypeText,
  cast (0 as actytypewhereusedobjcount) AS NumberOfUniqueObjects,
  cast (0 as actytypewhereusedobjmatch) AS NumberOfMatches,
  cast('' as kokrs) AS ControllingArea,
  cast('' as lstar) AS CostCtrActivityType,
  cast('19700101' as validondate) AS ActivityTypeValidOnDate,
  cast('19700101' as datab) AS ValidityStartDate,
  cast('19700101' as datbi) AS ValidityEndDate
FROM C_ActyTypeWhereUsedObjTypeVH
LEFT OUTER JOIN C_ActyTypeSndgCostCtrObj AS _ActyTypeSndgCostCtr ON ActyTypeWhereUsedObjType = _ActyTypeSndgCostCtr.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeSndgCostCtr.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeSndgCostCtrItmObj AS _ActyTypeSndgCostCtrItm ON ActyTypeWhereUsedObjType = _ActyTypeSndgCostCtrItm.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeSndgCostCtrItm.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeRcvgCostCtrItmObj AS _ActyTypeRcvgCostCtrItm ON ActyTypeWhereUsedObjType = _ActyTypeRcvgCostCtrItm.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeRcvgCostCtrItm.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeRcvgOrdItmObj AS _ActyTypeRcvgOrdItm ON ActyTypeWhereUsedObjType = _ActyTypeRcvgOrdItm.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeRcvgOrdItm.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeRcvgWBSElmntItmObj AS _ActyTypeRcvgWBSElmntItm ON ActyTypeWhereUsedObjType = _ActyTypeRcvgWBSElmntItm.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeRcvgWBSElmntItm.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeActyTypeGrpObj AS _ActyTypeActyTypeGrp ON ActyTypeWhereUsedObjType = _ActyTypeActyTypeGrp.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeActyTypeGrp.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeProdnRtgObj AS _ActyTypeProdnRtg ON ActyTypeWhereUsedObjType = _ActyTypeProdnRtg.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeProdnRtg.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeProdnWrkCtrObj AS _ActyTypeProdnWrkCtr ON ActyTypeWhereUsedObjType = _ActyTypeProdnWrkCtr.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeProdnWrkCtr.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeDIPProfileObj AS _ActyTypeDIPProfile ON ActyTypeWhereUsedObjType = _ActyTypeDIPProfile.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeDIPProfile.FioriUIFilterHash  -- association [1..1]
LEFT OUTER JOIN C_ActyTypeGlobAcctgHierObj AS _ActyTypeGlobAcctgHier ON ActyTypeWhereUsedObjType = _ActyTypeGlobAcctgHier.ActyTypeWhereUsedObjType AND FioriUIFilterHash = _ActyTypeGlobAcctgHier.FioriUIFilterHash  -- association [1..1]
;