R_ProdnRtgOpMatlPRTAssgmtTP_2

DDL: R_PRODNRTGOPMATLPRTASSGMTTP_2 Type: view_entity TRANSACTIONAL Package: VDM_PP_MD_RTG
31 Fields 2 Data Sources 1 Associations

Material PRT Assignment

R_ProdnRtgOpMatlPRTAssgmtTP_2 is a Transactional CDS View that provides data about "Material PRT Assignment" in SAP S/4HANA. It reads from 2 data sources (I_MaterialPRTByInternalKey, I_ProdnRtgOpPRTAssgmtToOp) and exposes 31 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingOpIntID, BOOOperationPRTInternalID. It has 1 association to related views. Part of development package VDM_PP_MD_RTG.

Data Sources (2)

SourceAliasJoin Type
I_MaterialPRTByInternalKey Matl inner
I_ProdnRtgOpPRTAssgmtToOp OpPRTAssgmt inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] R_ProductionRoutingHeaderTP_2 _Header $projection.ProductionRoutingGroup = _Header.ProductionRoutingGroup and $projection.ProductionRouting = _Header.ProductionRouting and $projection.ValidityEndDate >= _Header.ValidityStartDate and $projection.ValidityStartDate <= _Header.ValidityEndDate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Material PRT Assignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ProductionRoutingGroup PRTAssgmt ProductionRoutingGroup
KEY ProductionRouting PRTAssgmt ProductionRouting
KEY ProductionRoutingSequence PRTAssgmt ProductionRoutingSequence
KEY ProductionRoutingOpIntID PRTAssgmt ProductionRoutingOpIntID
KEY BOOOperationPRTInternalID PRTAssgmt BOOOperationPRTInternalID
KEY BOOOperationPRTIntVersCounter PRTAssgmt BOOOperationPRTIntVersCounter
ProductionResourceType PRTAssgmt ProductionResourceType Object Type
ProductionResourceInternalID PRTAssgmt ProductionResourceInternalID Object ID
Material I_MaterialPRTByInternalKey Material Vehicle Model
Plant I_MaterialPRTByInternalKey Plant Valuation Area
ProdnRsceToolItemNumber PRTAssgmt ProdnRsceToolItemNumber Item Number
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
ChangedDateTime _NonSqncTP ChangedDateTime Time Stamp
_NonSqncTP _NonSqncTP
_ProdnRtgTP _ProdnRtgTP
_Header _Header

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 R_ProdnRtgOpMatlPRTAssgmtTP_2.
-- 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 R_ProdnRtgOpMatlPRTAssgmtTP_2 AS
SELECT
  PRTAssgmt.ProductionRoutingGroup AS ProductionRoutingGroup,
  PRTAssgmt.ProductionRouting AS ProductionRouting,
  PRTAssgmt.ProductionRoutingSequence AS ProductionRoutingSequence,
  PRTAssgmt.ProductionRoutingOpIntID AS ProductionRoutingOpIntID,
  PRTAssgmt.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  PRTAssgmt.BOOOperationPRTIntVersCounter AS BOOOperationPRTIntVersCounter,
  PRTAssgmt.ProductionResourceType AS ProductionResourceType,
  PRTAssgmt.ProductionResourceInternalID AS ProductionResourceInternalID,
  Matl.Material AS Material,
  Matl.Plant AS Plant,
  PRTAssgmt.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  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,
  _NonSqncTP.ChangedDateTime AS ChangedDateTime
INNER JOIN I_MaterialPRTByInternalKey AS Matl ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProdnRtgOpPRTAssgmtToOp AS OpPRTAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_ProductionRoutingHeaderTP_2 AS _Header ON ProductionRoutingGroup = _Header.ProductionRoutingGroup AND ProductionRouting = _Header.ProductionRouting AND ValidityEndDate >= _Header.ValidityStartDate AND ValidityStartDate <= _Header.ValidityEndDate  -- association [1..*]
;

Learn More