P_ProdnRoutingDocPRTAssgmtDEX

DDL: P_PRODNROUTINGDOCPRTASSGMTDEX Type: view_entity BASIC Package: VDM_PP_MD_RTG
41 Fields 2 Data Sources 3 Associations

Production Routing Document PRT

P_ProdnRoutingDocPRTAssgmtDEX is a Basic CDS View that provides data about "Production Routing Document PRT" in SAP S/4HANA. It reads from 2 data sources (crvd_a, plfh) and exposes 41 fields with key fields BillOfOperationsType, ProductionRoutingGroup, BOOOperationPRTInternalID. It has 3 associations to related views. Part of development package VDM_PP_MD_RTG.

Data Sources (2)

SourceAliasJoin Type
crvd_a crvd_a inner
plfh plfh from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup
[1..1] I_BOOOpPRTInternalID _BOOOperationPRTInternalID $projection.BillOfOperationsType = _BOOOperationPRTInternalID.BillOfOperationsType and $projection.ProductionRoutingGroup = _BOOOperationPRTInternalID.BillOfOperationsGroup and $projection.BOOOperationPRTInternalID = _BOOOperationPRTInternalID.BOOOperationPRTInternalID

Annotations (9)

NameValueLevelField
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.representativeKey BOOOperationPRTIntVersCounter view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.internalName #LOCAL view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plfh plnty Task List Type
KEY ProductionRoutingGroup plfh plnnr Task List Group
KEY BOOOperationPRTInternalID plfh pzlfh Test equipment
zaehlasBOOOperationPRTIntVersCounter
ProductionRouting plfh plnal Referenced BOO Variant
ProductionRoutingSequence plfh plnfl Sequence
ProductionRoutingOpIntID plfh plnkn Task list node
BillOfOperationsVersion plfh versn Version
ProdnRsceToolItemNumber plfh psnfh Item Number
ProductionResourceType plfh objty Prj. Obj. Type
ProductionResourceInternalID plfh objid Work Center
DocumentType crvd_a dokar SW Document Type
DocumentInfoRecord crvd_a doknr Document
DocumentVersion crvd_a dokvr Doc. Version
DocumentPart crvd_a doktl Document Part
ProdnRsceToolCategory
ProdnRsceToolControlProfile plfh steuf PRT Control Profile
ProdnRsceToolStandardTextCode plfh ktsch Std Text Key
ProdnRsceToolText plfh txtz1 Text for PRT
CreationDate plfh datui Created On
LastChangeDate plfh datuc Changed On
ChangeNumber plfh aennr Change Number
ValidityStartDate plfh datuv Valid-from date
ValidityEndDate plfh valid_to Validity End Time
IsDeleted plfh loekz Status
IsImplicitlyDeleted plfh loekz_inherited Deletion Ind.
ProdnRsceToolStdWorkQtyUnit plfh mgeinh Unit
ProdnRsceToolStandardWorkQty plfh mgvgw Quantity
ProdnRsceToolTotQtyCalcFormula plfh mgform Formula
ProdnRsceToolUsageQuantityUnit plfh eweinh Usage Val. Unit
ProdnRsceToolUsageQuantity plfh ewvgw Usage Value
ProdnRsceToolUsageQtyCalcFmla plfh ewform Formula
StartDateOffsetReferenceCode plfh bzoffb Reference Date
StartDateOffsetDurationUnit plfh ehoffb Unit
StartDateOffsetDuration plfh offstb Offset
EndDateOffsetReferenceCode plfh bzoffe Reference
EndDateOffsetDurationUnit plfh ehoffe Unit
EndDateOffsetDuration plfh offste Offset to finsh
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BOOOperationPRTInternalID _BOOOperationPRTInternalID

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_ProdnRoutingDocPRTAssgmtDEX.
-- 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_ProdnRoutingDocPRTAssgmtDEX AS
SELECT
  plfh.plnty AS BillOfOperationsType,
  plfh.plnnr AS ProductionRoutingGroup,
  plfh.pzlfh AS BOOOperationPRTInternalID,
  plfh.plnal AS ProductionRouting,
  plfh.plnfl AS ProductionRoutingSequence,
  plfh.plnkn AS ProductionRoutingOpIntID,
  plfh.versn AS BillOfOperationsVersion,
  plfh.psnfh AS ProdnRsceToolItemNumber,
  plfh.objty AS ProductionResourceType,
  plfh.objid AS ProductionResourceInternalID,
  crvd_a.dokar AS DocumentType,
  crvd_a.doknr AS DocumentInfoRecord,
  crvd_a.dokvr AS DocumentVersion,
  crvd_a.doktl AS DocumentPart,
  'D' AS ProdnRsceToolCategory,
  plfh.steuf AS ProdnRsceToolControlProfile,
  plfh.ktsch AS ProdnRsceToolStandardTextCode,
  plfh.txtz1 AS ProdnRsceToolText,
  plfh.datui AS CreationDate,
  plfh.datuc AS LastChangeDate,
  plfh.aennr AS ChangeNumber,
  plfh.datuv AS ValidityStartDate,
  plfh.valid_to AS ValidityEndDate,
  plfh.loekz AS IsDeleted,
  plfh.loekz_inherited AS IsImplicitlyDeleted,
  plfh.mgeinh AS ProdnRsceToolStdWorkQtyUnit,
  plfh.mgvgw AS ProdnRsceToolStandardWorkQty,
  plfh.mgform AS ProdnRsceToolTotQtyCalcFormula,
  plfh.eweinh AS ProdnRsceToolUsageQuantityUnit,
  plfh.ewvgw AS ProdnRsceToolUsageQuantity,
  plfh.ewform AS ProdnRsceToolUsageQtyCalcFmla,
  plfh.bzoffb AS StartDateOffsetReferenceCode,
  plfh.ehoffb AS StartDateOffsetDurationUnit,
  plfh.offstb AS StartDateOffsetDuration,
  plfh.bzoffe AS EndDateOffsetReferenceCode,
  plfh.ehoffe AS EndDateOffsetDurationUnit,
  plfh.offste AS EndDateOffsetDuration
FROM plfh
INNER JOIN crvd_a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND ProductionRoutingGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_BOOOpPRTInternalID AS _BOOOperationPRTInternalID ON BillOfOperationsType = _BOOOperationPRTInternalID.BillOfOperationsType AND ProductionRoutingGroup = _BOOOperationPRTInternalID.BillOfOperationsGroup AND BOOOperationPRTInternalID = _BOOOperationPRTInternalID.BOOOperationPRTInternalID  -- association [1..1]
;

Learn More