P_MstrRcpOpDocPRTAssgmt

DDL: P_MSTRRCPOPDOCPRTASSGMT Type: view_entity COMPOSITE Package: VDM_PP_MD_MRC
29 Fields 1 Data Sources

Document PRT Assignment

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

Data Sources (1)

SourceAliasJoin Type
I_DocumentPRTByInternalKey Doc 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 (29)

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
DocumentType I_DocumentPRTByInternalKey DocumentType Order Type
DocumentInfoRecord I_DocumentPRTByInternalKey DocumentInfoRecord Document
DocumentVersion I_DocumentPRTByInternalKey DocumentVersion Docu. Version
DocumentPart I_DocumentPRTByInternalKey DocumentPart Document Part
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_MstrRcpOpDocPRTAssgmt.
-- 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_MstrRcpOpDocPRTAssgmt 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,
  Doc.DocumentType AS DocumentType,
  Doc.DocumentInfoRecord AS DocumentInfoRecord,
  Doc.DocumentVersion AS DocumentVersion,
  Doc.DocumentPart AS DocumentPart,
  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_DocumentPRTByInternalKey AS Doc ON /* join condition not captured in parsed metadata */
;

Learn More