I_ActyTypeDIPGroupRefActyType

DDL: I_ACTYTYPEDIPGROUPREFACTYTYPE SQL: IATDGRAT Type: view COMPOSITE Package: ODATA_WHERE_USED_ACTIVITY_TYPE
13 Fields

DIP Profiles Group Reference to Activity Type

I_ActyTypeDIPGroupRefActyType is a Composite CDS View that provides data about "DIP Profiles Group Reference to Activity Type" in SAP S/4HANA. Part of development package ODATA_WHERE_USED_ACTIVITY_TYPE.

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IATDGRAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label DIP Profiles Group Reference to Activity Type view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #META view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ActyTypeWhereUsedObjType ActyTypeWhereUsedObjType
KEY SetClass SetClass Set Class
KEY SetSubClass SetSubClass
KEY UniversalHierNodeParentID UniversalHierNodeParentID
KEY CostCtrActivityType CostCtrActivityType Activity Type
KEY ControllingArea ControllingArea Controlling Area
KEY ValidityStartDate ValidityStartDate Validity Start Date
KEY ValidityEndDate ValidityEndDate ValidTo
ActivityTypeGroupName ActivityTypeGroupName
CostCtrActivityTypeName CostCtrActivityTypeName
CostCtrActyTypeValdtyStartDate CostCtrActyTypeValdtyStartDate
CostCtrActyTypeValdtyEndDate CostCtrActyTypeValdtyEndDate
AllocationSetId

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_ActyTypeDIPGroupRefActyType.
-- 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: IATDGRAT

CREATE VIEW I_ActyTypeDIPGroupRefActyType AS
SELECT
  ActyTypeWhereUsedObjType,
  SetClass,
  SetSubClass,
  UniversalHierNodeParentID,
  CostCtrActivityType,
  ControllingArea,
  ValidityStartDate,
  ValidityEndDate,
  ActivityTypeGroupName,
  CostCtrActivityTypeName,
  CostCtrActyTypeValdtyStartDate,
  CostCtrActyTypeValdtyEndDate,
  cast( concat(concat( SetClass, SetSubClass), UniversalHierNodeParentID) as setid ) AS AllocationSetId
;

Learn More