P_BOOVersionPRT

DDL: P_BOOVERSIONPRT Type: view_entity COMPOSITE
33 Fields 4 Data Sources 5 Associations

P_BOOVersionPRT is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_BOOOperationPRTChangeState, I_BOOVersionOperationActivity, I_OpActyBOOProdnRsceToolAssgmt, I_ProdnRsceToolMasterData) and exposes 33 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsVersion, BillOfOperationsSequence. It has 5 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_BOOOperationPRTChangeState BOOperationPRT inner
I_BOOVersionOperationActivity BOOVersionOpActy inner
I_OpActyBOOProdnRsceToolAssgmt OpActyBOOProdnRsceToolAssgmt from
I_ProdnRsceToolMasterData PRT inner

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_MaterialPRTByInternalKey MaterialPRT MaterialPRT.ProductionResourceType = BOOperationPRT.ProductionResourceType and MaterialPRT.ProductionResourceInternalID = BOOperationPRT.ProductionResourceInternalID
[0..1] I_EquipmentPRTByInternalKey EquipmentPRT EquipmentPRT.ProductionResourceType = BOOperationPRT.ProductionResourceType and EquipmentPRT.ProductionResourceInternalID = BOOperationPRT.ProductionResourceInternalID
[0..1] I_MiscPRTByInternalKey MiscPRT MiscPRT.ProductionResourceType = BOOperationPRT.ProductionResourceType and MiscPRT.ProductionResourceInternalID = BOOperationPRT.ProductionResourceInternalID
[0..1] I_DocumentPRTByInternalKey DocPRT DocPRT.ProductionResourceType = BOOperationPRT.ProductionResourceType and DocPRT.ProductionResourceInternalID = BOOperationPRT.ProductionResourceInternalID
[1..1] I_BOOVersionOperationActivity _BOOVersionOpActy _BOOVersionOpActy.OperationActivity = OpActyBOOProdnRsceToolAssgmt.OperationActivity and _BOOVersionOpActy.OperationActyVersionCounter = OpActyBOOProdnRsceToolAssgmt.OperationActyVersionCounter

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType I_BOOVersionOperationActivity BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_BOOVersionOperationActivity BillOfOperationsGroup Group
KEY BillOfOperationsVariant I_BOOVersionOperationActivity BillOfOperationsVariant Group Counter
KEY BillOfOperationsVersion I_BOOVersionOperationActivity BillOfOperationsVersion Routing Version
KEY BillOfOperationsSequence I_BOOVersionOperationActivity BillOfOperationsSequence Sequence
KEY BOOOperationInternalID I_BOOVersionOperationActivity BOOOperationInternalID Task list node
KEY OpActyNtwkSegmentType I_BOOVersionOperationActivity OpActyNtwkSegmentType
KEY OperationActivity I_OpActyBOOProdnRsceToolAssgmt OperationActivity Operation Activity
KEY OperationActyVersionCounter I_OpActyBOOProdnRsceToolAssgmt OperationActyVersionCounter OA Version
KEY BOOOperationPRTInternalID I_OpActyBOOProdnRsceToolAssgmt BOOOperationPRTInternalID Test equipment
ShopFloorRtgPRTIsRegistrable I_BOOOperationPRTChangeState ShopFloorRtgPRTIsRegistrable Registrable
ProdnRsceToolItemNumber I_BOOOperationPRTChangeState ProdnRsceToolItemNumber Item Number
ProductionResourceType I_BOOOperationPRTChangeState ProductionResourceType Object Type
ProductionResourceInternalID I_BOOOperationPRTChangeState ProductionResourceInternalID Object ID
ProdnRsceToolControlProfile I_BOOOperationPRTChangeState ProdnRsceToolControlProfile PRT Control Profile
ProdnRsceToolStandardTextCode I_BOOOperationPRTChangeState ProdnRsceToolStandardTextCode Std Text Key
ProdnRsceToolText I_BOOOperationPRTChangeState ProdnRsceToolText Text for PRT
ProdnRsceToolStdWorkQtyUnit I_BOOOperationPRTChangeState ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty I_BOOOperationPRTChangeState ProdnRsceToolStandardWorkQty Quantity
ProdnRsceToolTotQtyCalcFormula I_BOOOperationPRTChangeState ProdnRsceToolTotQtyCalcFormula Formula
ProdnRsceToolUsageQuantityUnit I_BOOOperationPRTChangeState ProdnRsceToolUsageQuantityUnit Usage Val. Unit
ProdnRsceToolUsageQuantity I_BOOOperationPRTChangeState ProdnRsceToolUsageQuantity Usage Value
ProdnRsceToolUsageQtyCalcFmla I_BOOOperationPRTChangeState ProdnRsceToolUsageQtyCalcFmla Formula
ProdnRsceToolCategory I_ProdnRsceToolMasterData ProdnRsceToolCategory PRT Category
Material MaterialPRT Material Vehicle Model
Plant MaterialPRT Plant Valuation Area
Equipment EquipmentPRT Equipment Equipment check
MiscProductionResourceTool MiscPRT MiscProductionResourceTool
DocumentType DocPRT DocumentType Order Type
DocumentInfoRecord DocPRT DocumentInfoRecord Document
DocumentVersion DocPRT DocumentVersion Docu. Version
DocumentPart DocPRT DocumentPart Document Part
_BOOVersionOpActy _BOOVersionOpActy

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_BOOVersionPRT.
-- 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_BOOVersionPRT AS
SELECT
  BOOVersionOpActy.BillOfOperationsType AS BillOfOperationsType,
  BOOVersionOpActy.BillOfOperationsGroup AS BillOfOperationsGroup,
  BOOVersionOpActy.BillOfOperationsVariant AS BillOfOperationsVariant,
  BOOVersionOpActy.BillOfOperationsVersion AS BillOfOperationsVersion,
  BOOVersionOpActy.BillOfOperationsSequence AS BillOfOperationsSequence,
  BOOVersionOpActy.BOOOperationInternalID AS BOOOperationInternalID,
  BOOVersionOpActy.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyBOOProdnRsceToolAssgmt.OperationActivity AS OperationActivity,
  OpActyBOOProdnRsceToolAssgmt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyBOOProdnRsceToolAssgmt.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  BOOperationPRT.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  BOOperationPRT.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  BOOperationPRT.ProductionResourceType AS ProductionResourceType,
  BOOperationPRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  BOOperationPRT.ProdnRsceToolControlProfile AS ProdnRsceToolControlProfile,
  BOOperationPRT.ProdnRsceToolStandardTextCode AS ProdnRsceToolStandardTextCode,
  BOOperationPRT.ProdnRsceToolText AS ProdnRsceToolText,
  BOOperationPRT.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  BOOperationPRT.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  BOOperationPRT.ProdnRsceToolTotQtyCalcFormula AS ProdnRsceToolTotQtyCalcFormula,
  BOOperationPRT.ProdnRsceToolUsageQuantityUnit AS ProdnRsceToolUsageQuantityUnit,
  BOOperationPRT.ProdnRsceToolUsageQuantity AS ProdnRsceToolUsageQuantity,
  BOOperationPRT.ProdnRsceToolUsageQtyCalcFmla AS ProdnRsceToolUsageQtyCalcFmla,
  PRT.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  MaterialPRT.Material AS Material,
  MaterialPRT.Plant AS Plant,
  EquipmentPRT.Equipment AS Equipment,
  MiscPRT.MiscProductionResourceTool AS MiscProductionResourceTool,
  DocPRT.DocumentType AS DocumentType,
  DocPRT.DocumentInfoRecord AS DocumentInfoRecord,
  DocPRT.DocumentVersion AS DocumentVersion,
  DocPRT.DocumentPart AS DocumentPart
FROM I_OpActyBOOProdnRsceToolAssgmt AS OpActyBOOProdnRsceToolAssgmt
INNER JOIN I_BOOVersionOperationActivity AS BOOVersionOpActy ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOOperationPRTChangeState AS BOOperationPRT ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProdnRsceToolMasterData AS PRT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialPRTByInternalKey AS MaterialPRT ON MaterialPRT.ProductionResourceType = BOOperationPRT.ProductionResourceType AND MaterialPRT.ProductionResourceInternalID = BOOperationPRT.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_EquipmentPRTByInternalKey AS EquipmentPRT ON EquipmentPRT.ProductionResourceType = BOOperationPRT.ProductionResourceType AND EquipmentPRT.ProductionResourceInternalID = BOOperationPRT.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_MiscPRTByInternalKey AS MiscPRT ON MiscPRT.ProductionResourceType = BOOperationPRT.ProductionResourceType AND MiscPRT.ProductionResourceInternalID = BOOperationPRT.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_DocumentPRTByInternalKey AS DocPRT ON DocPRT.ProductionResourceType = BOOperationPRT.ProductionResourceType AND DocPRT.ProductionResourceInternalID = BOOperationPRT.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_BOOVersionOperationActivity AS _BOOVersionOpActy ON _BOOVersionOpActy.OperationActivity = OpActyBOOProdnRsceToolAssgmt.OperationActivity AND _BOOVersionOpActy.OperationActyVersionCounter = OpActyBOOProdnRsceToolAssgmt.OperationActyVersionCounter  -- association [1..1]
;

Learn More