I_WorkCenterGroup

DDL: I_WORKCENTERGROUP Type: view_entity COMPOSITE Package: VDM_PP_WORKCENTER_GROUP
12 Fields 1 Data Sources 3 Associations

Work Center Group View

I_WorkCenterGroup is a Composite CDS View that provides data about "Work Center Group View" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterHierHeader) and exposes 12 fields with key fields WorkCenterGroupTypeCode, WorkCenterGroupInternalID. It has 3 associations to related views. Part of development package VDM_PP_WORKCENTER_GROUP.

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterHierHeader crhh from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_WorkCenterGroupText _Text $projection.WorkCenterGroupTypeCode = _Text.WorkCenterGroupTypeCode and $projection.WorkCenterGroupInternalID = _Text.WorkCenterGroupInternalID
[0..1] I_WorkCenterGroupTypeText _WorkCenterTypeText $projection.WorkCenterGroupType = _WorkCenterTypeText.WorkCenterGroupType
[0..1] I_WorkCenterGroupObjectCount _ObjectCount $projection.WorkCenterGroupTypeCode = _ObjectCount.ObjectTypeCode and $projection.WorkCenterGroupInternalID = _ObjectCount.ObjectInternalID

Annotations (6)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Work Center Group View view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterGroupTypeCode WrkCtrHierObjType Prj. Obj. Type
KEY WorkCenterGroupInternalID WrkCtrHierObjID Work Center
WorkCenterGroup WrkCtrHierName Zone name
WorkCenterGroupDescription
Plant WrkCtrHierPlant Receiving Plant
WorkCenterGroupType WorkCenterGroupType Group Type
WorkCenterGroupTypeDescription
IsDeleted IsDeleted TRUE
_Text _Text
_ObjectCount _ObjectCount
ShiftNoteType ShiftNoteType Shift Note Type
ShiftReportType ShiftReportType Report Type

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_WorkCenterGroup.
-- 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.

CREATE VIEW I_WorkCenterGroup AS
SELECT
  WrkCtrHierObjType AS WorkCenterGroupTypeCode,
  WrkCtrHierObjID AS WorkCenterGroupInternalID,
  WrkCtrHierName AS WorkCenterGroup,
  _Text[1:Language = $session.system_language].WorkCenterGroupDescription AS WorkCenterGroupDescription,
  WrkCtrHierPlant AS Plant,
  WorkCenterGroupType,
  _WorkCenterTypeText[1:Language = $session.system_language].WorkCenterGroupTypeDescription AS WorkCenterGroupTypeDescription,
  IsDeleted,
  ShiftNoteType,
  ShiftReportType
FROM I_WorkCenterHierHeader AS crhh
LEFT OUTER JOIN I_WorkCenterGroupText AS _Text ON WorkCenterGroupTypeCode = _Text.WorkCenterGroupTypeCode AND WorkCenterGroupInternalID = _Text.WorkCenterGroupInternalID  -- association [0..*]
LEFT OUTER JOIN I_WorkCenterGroupTypeText AS _WorkCenterTypeText ON WorkCenterGroupType = _WorkCenterTypeText.WorkCenterGroupType  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterGroupObjectCount AS _ObjectCount ON WorkCenterGroupTypeCode = _ObjectCount.ObjectTypeCode AND WorkCenterGroupInternalID = _ObjectCount.ObjectInternalID  -- association [0..1]
;

Learn More