P_MstrRcpOpEquipPRTAssgmt

DDL: P_MSTRRCPOPEQUIPPRTASSGMT Type: view_entity COMPOSITE Package: VDM_PP_MD_MRC
26 Fields 1 Data Sources

Equipment PRT Assignment

P_MstrRcpOpEquipPRTAssgmt is a Composite CDS View that provides data about "Equipment PRT Assignment" in SAP S/4HANA. It reads from 1 data source (I_EquipmentPRTByInternalKey) and exposes 26 fields with key fields MasterRecipeGroup, MasterRecipe, BillOfOperationsSequence, MasterRecipeOperationIntID, BOOOperationPRTInternalID. Part of development package VDM_PP_MD_MRC.

Data Sources (1)

SourceAliasJoin Type
I_EquipmentPRTByInternalKey Equip inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MasterRecipeGroup PRTAssgmt BillOfOperationsGroup Group
KEY MasterRecipe PRTAssgmt BillOfOperationsVariant Group Counter
KEY BillOfOperationsSequence PRTAssgmt BillOfOperationsSequence Sequence
KEY MasterRecipeOperationIntID PRTAssgmt BOOOperationInternalID Task list node
KEY BOOOperationPRTInternalID PRTAssgmt BOOOperationPRTInternalID
KEY BOOOperationPRTIntVersCounter PRTAssgmt BOOOperationPRTIntVersCounter
Equipment I_EquipmentPRTByInternalKey Equipment Equipment check
ProdnRsceToolItemNumber PRTAssgmt ProdnRsceToolItemNumber Item Number
ProductionResourceType PRTAssgmt ProductionResourceType Object Type
ProductionResourceInternalID PRTAssgmt ProductionResourceInternalID Object ID
ProdnRsceToolStandardTextCode PRTAssgmt ProdnRsceToolStandardTextCode
ProdnRsceToolText PRTAssgmt ProdnRsceToolText
ProdnRsceToolControlProfile PRTAssgmt ProdnRsceToolControlProfile
ProdnRsceToolStandardWorkQty PRTAssgmt ProdnRsceToolStandardWorkQty Quantity
ProdnRsceToolStdWorkQtyUnit PRTAssgmt ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolTotQtyCalcFormula PRTAssgmt ProdnRsceToolTotQtyCalcFormula
ProdnRsceToolUsageQuantity PRTAssgmt ProdnRsceToolUsageQuantity
ProdnRsceToolUsageQuantityUnit PRTAssgmt ProdnRsceToolUsageQuantityUnit
ProdnRsceToolUsageQtyCalcFmla PRTAssgmt ProdnRsceToolUsageQtyCalcFmla
ChangeNumber PRTAssgmt ChangeNumber Change Number
ValidityStartDate PRTAssgmt ValidityStartDate Validity Start Date
ValidityEndDate PRTAssgmt ValidityEndDate ValidTo
CreationDate PRTAssgmt CreationDate Time Stamp
CreatedByUser PRTAssgmt CreatedByUser User Name
LastChangeDate PRTAssgmt LastChangeDate Time Stamp
LastChangedByUser PRTAssgmt LastChangedByUser User Name

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_MstrRcpOpEquipPRTAssgmt.
-- 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_MstrRcpOpEquipPRTAssgmt AS
SELECT
  PRTAssgmt.BillOfOperationsGroup AS MasterRecipeGroup,
  PRTAssgmt.BillOfOperationsVariant AS MasterRecipe,
  PRTAssgmt.BillOfOperationsSequence AS BillOfOperationsSequence,
  PRTAssgmt.BOOOperationInternalID AS MasterRecipeOperationIntID,
  PRTAssgmt.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  PRTAssgmt.BOOOperationPRTIntVersCounter AS BOOOperationPRTIntVersCounter,
  Equip.Equipment AS Equipment,
  PRTAssgmt.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  PRTAssgmt.ProductionResourceType AS ProductionResourceType,
  PRTAssgmt.ProductionResourceInternalID AS ProductionResourceInternalID,
  PRTAssgmt.ProdnRsceToolStandardTextCode AS ProdnRsceToolStandardTextCode,
  PRTAssgmt.ProdnRsceToolText AS ProdnRsceToolText,
  PRTAssgmt.ProdnRsceToolControlProfile AS ProdnRsceToolControlProfile,
  PRTAssgmt.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  PRTAssgmt.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  PRTAssgmt.ProdnRsceToolTotQtyCalcFormula AS ProdnRsceToolTotQtyCalcFormula,
  PRTAssgmt.ProdnRsceToolUsageQuantity AS ProdnRsceToolUsageQuantity,
  PRTAssgmt.ProdnRsceToolUsageQuantityUnit AS ProdnRsceToolUsageQuantityUnit,
  PRTAssgmt.ProdnRsceToolUsageQtyCalcFmla AS ProdnRsceToolUsageQtyCalcFmla,
  PRTAssgmt.ChangeNumber AS ChangeNumber,
  PRTAssgmt.ValidityStartDate AS ValidityStartDate,
  PRTAssgmt.ValidityEndDate AS ValidityEndDate,
  PRTAssgmt.CreationDate AS CreationDate,
  PRTAssgmt.CreatedByUser AS CreatedByUser,
  PRTAssgmt.LastChangeDate AS LastChangeDate,
  PRTAssgmt.LastChangedByUser AS LastChangedByUser
INNER JOIN I_EquipmentPRTByInternalKey AS Equip ON /* join condition not captured in parsed metadata */
;

Learn More