P_ProdnModBOOOPActyGroup

DDL: P_PRODNMODBOOOPACTYGROUP Type: view_entity COMPOSITE
9 Fields 4 Data Sources

Production Model BOO Op. Activity Group

P_ProdnModBOOOPActyGroup is a Composite CDS View that provides data about "Production Model BOO Op. Activity Group" in SAP S/4HANA. It reads from 4 data sources (I_OpActyNtwkGroup, I_OpActyNtwkGroupElement, I_OpActyNtwkElement, I_OpActyNtwkElement) and exposes 9 fields with key fields OperationActivityNetwork, OpActyNtwkVersionCounter, OpActyNtwkElementElement, OpActyNtwkElementElmntVersCntr.

Data Sources (4)

SourceAliasJoin Type
I_OpActyNtwkGroup OpActyGroup from
I_OpActyNtwkGroupElement OpActyGrpNtwkElement inner
I_OpActyNtwkElement OpActyNtwkElementActy inner
I_OpActyNtwkElement OpActyNtwkElementGrp inner

Annotations (8)

NameValueLevelField
EndUserText.label Production Model BOO Op. Activity Group view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OperationActivityNetwork I_OpActyNtwkElement OperationActivityNetwork Object ID
KEY OpActyNtwkVersionCounter I_OpActyNtwkElement OpActyNtwkVersionCounter Object Version
KEY OpActyNtwkElementElement I_OpActyNtwkElement OpActyNtwkElementElement Operation Activity
KEY OpActyNtwkElementElmntVersCntr I_OpActyNtwkElement OpActyNtwkElementElmntVersCntr OA Version
OpActyNtwkGroupType I_OpActyNtwkGroup OpActyNtwkGroupType Worklist Type
OperationActivityNetworkGroup I_OpActyNtwkGroup OperationActivityNetworkGroup WorklistID
OpActyNtwkGroupVersionCounter I_OpActyNtwkGroup OpActyNtwkGroupVersionCounter Version No
OpActyNtwkGroupExternalID I_OpActyNtwkElement OpActyNtwkElementExternalID Op. Activity
OpActyNtwkGroupParentElement I_OpActyNtwkGroupElement OpActyNtwkGroupParentElement Element Number

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 P_ProdnModBOOOPActyGroup.
-- 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 P_ProdnModBOOOPActyGroup AS
SELECT
  OpActyNtwkElementActy.OperationActivityNetwork AS OperationActivityNetwork,
  OpActyNtwkElementActy.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  OpActyNtwkElementActy.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyNtwkElementActy.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OpActyGroup.OpActyNtwkGroupType AS OpActyNtwkGroupType,
  OpActyGroup.OperationActivityNetworkGroup AS OperationActivityNetworkGroup,
  OpActyGroup.OpActyNtwkGroupVersionCounter AS OpActyNtwkGroupVersionCounter,
  OpActyNtwkElementGrp.OpActyNtwkElementExternalID AS OpActyNtwkGroupExternalID,
  OpActyGrpNtwkElement.OpActyNtwkGroupParentElement AS OpActyNtwkGroupParentElement
FROM I_OpActyNtwkGroup AS OpActyGroup
INNER JOIN I_OpActyNtwkElement AS OpActyNtwkElementGrp ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyNtwkGroupElement AS OpActyGrpNtwkElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyNtwkElement AS OpActyNtwkElementActy ON /* join condition not captured in parsed metadata */
;

Learn More