P_OpActyReferenceComp

DDL: P_OPACTYREFERENCECOMP Type: view_entity COMPOSITE
19 Fields 1 Data Sources

Reference component of an OA

P_OpActyReferenceComp is a Composite CDS View that provides data about "Reference component of an OA" in SAP S/4HANA. It reads from 1 data source (I_MfgWorkInstructionVariable) and exposes 19 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, InheritedNodeNumberForBOMItem, BillOfMaterialVersion.

Data Sources (1)

SourceAliasJoin Type
I_MfgWorkInstructionVariable MfgWorkInstructionVariable inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Reference component of an OA view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory OpActyBOOCharcAssgmt BillOfMaterialCategory BOM category
KEY BillOfMaterial OpActyBOOCharcAssgmt BillOfMaterial BOM
KEY BillOfMaterialVariant OpActyBOOCharcAssgmt BillOfMaterialVariant AlternativeBOM
KEY InheritedNodeNumberForBOMItem OpActyBOOCharcAssgmt InheritedNodeNumberForBOMItem Nodes
KEY BillOfMaterialVersion OpActyBOOCharcAssgmt BillOfMaterialVersion BOM Version
KEY LogicalComponentUUID OpActyBOOCharcAssgmt LogicalComponentUUID
KEY OperationActivity OpActyBOOCharcAssgmt OperationActivity Operation Activity
KEY OperationActyVersionCounter OpActyBOOCharcAssgmt OperationActyVersionCounter OA Version
_OperationActivity OpActyBOOCharcAssgmt _OperationActivity
BillOfMaterialCategory BOM category
KEY BillOfMaterial I_MfgWorkInstructionVariable BillOfMaterial BOM
KEY BillOfMaterialVariant I_MfgWorkInstructionVariable BillOfMaterialVariant AlternativeBOM
KEY InheritedNodeNumberForBOMItem I_MfgWorkInstructionVariable InheritedNodeNumberForBOMItem Nodes
KEY BillOfMaterialVersion I_MfgWorkInstructionVariable BillOfMaterialVersion BOM Version
KEY LogicalComponentUUID I_MfgWorkInstructionVariable LogicalComponentUUID
KEY OperationActivity OpActyWorkInstructionAssgmt OperationActivity Operation Activity
KEY OperationActyVersionCounter OpActyWorkInstructionAssgmt OperationActyVersionCounter OA Version
_OperationActivity OpActyWorkInstructionAssgmt _OperationActivity
_OperationActivityInternalId OpActyWorkInstructionAssgmt _OperationActivityInternalId

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_OpActyReferenceComp.
-- 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_OpActyReferenceComp AS
SELECT
  OpActyBOOCharcAssgmt.BillOfMaterialCategory AS BillOfMaterialCategory,
  OpActyBOOCharcAssgmt.BillOfMaterial AS BillOfMaterial,
  OpActyBOOCharcAssgmt.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyBOOCharcAssgmt.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  OpActyBOOCharcAssgmt.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyBOOCharcAssgmt.LogicalComponentUUID AS LogicalComponentUUID,
  OpActyBOOCharcAssgmt.OperationActivity AS OperationActivity,
  OpActyBOOCharcAssgmt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyBOOCharcAssgmt._OperationActivity AS _OperationActivity,
  OpActyWorkInstructionAssgmt._OperationActivityInternalId AS _OperationActivityInternalId
INNER JOIN I_MfgWorkInstructionVariable AS MfgWorkInstructionVariable ON /* join condition not captured in parsed metadata */
;

Learn More