R_ProdnRtgOpDocPRTAssgmtTP_2
Document PRT Assignment
R_ProdnRtgOpDocPRTAssgmtTP_2 is a Transactional CDS View that provides data about "Document PRT Assignment" in SAP S/4HANA. It reads from 1 data source (I_DocumentPRTByInternalKey) and exposes 33 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingOpIntID, BOOOperationPRTInternalID. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_DocumentPRTByInternalKey | Doc | inner |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Document PRT Assignment | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view |
Fields (33)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 | ||
| ProductionResourceInternalID | PRTAssgmt | ProductionResourceInternalID | ||
| DocumentType | I_DocumentPRTByInternalKey | DocumentType | ||
| DocumentInfoRecord | I_DocumentPRTByInternalKey | DocumentInfoRecord | ||
| DocumentVersion | I_DocumentPRTByInternalKey | DocumentVersion | ||
| DocumentPart | I_DocumentPRTByInternalKey | DocumentPart | ||
| ProdnRsceToolItemNumber | PRTAssgmt | ProdnRsceToolItemNumber | ||
| ProdnRsceToolStandardTextCode | PRTAssgmt | ProdnRsceToolStandardTextCode | ||
| ProdnRsceToolText | PRTAssgmt | ProdnRsceToolText | ||
| ProdnRsceToolControlProfile | PRTAssgmt | ProdnRsceToolControlProfile | ||
| ProdnRsceToolStandardWorkQty | PRTAssgmt | ProdnRsceToolStandardWorkQty | ||
| ProdnRsceToolStdWorkQtyUnit | PRTAssgmt | ProdnRsceToolStdWorkQtyUnit | ||
| ProdnRsceToolTotQtyCalcFormula | PRTAssgmt | ProdnRsceToolTotQtyCalcFormula | ||
| ProdnRsceToolUsageQuantity | PRTAssgmt | ProdnRsceToolUsageQuantity | ||
| ProdnRsceToolUsageQuantityUnit | PRTAssgmt | ProdnRsceToolUsageQuantityUnit | ||
| ProdnRsceToolUsageQtyCalcFmla | PRTAssgmt | ProdnRsceToolUsageQtyCalcFmla | ||
| ChangeNumber | PRTAssgmt | ChangeNumber | ||
| ValidityStartDate | PRTAssgmt | ValidityStartDate | ||
| ValidityEndDate | PRTAssgmt | ValidityEndDate | ||
| CreationDate | PRTAssgmt | CreationDate | ||
| CreatedByUser | PRTAssgmt | CreatedByUser | ||
| LastChangeDate | PRTAssgmt | LastChangeDate | ||
| LastChangedByUser | PRTAssgmt | LastChangedByUser | ||
| ChangedDateTime | _NonSqncTP | ChangedDateTime | ||
| _NonSqncTP | _NonSqncTP | |||
| _ProdnRtgTP | _ProdnRtgTP | |||
| _Header | _Header |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Document PRT Assignment'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
@VDM: { viewType: #TRANSACTIONAL, lifecycle.contract.type: #SAP_INTERNAL_API }
define view entity R_ProdnRtgOpDocPRTAssgmtTP_2
as select distinct from P_ProductionRoutingPRTAssgmt as PRTAssgmt
inner join I_DocumentPRTByInternalKey as Doc on Doc.ProductionResourceType = PRTAssgmt.ProductionResourceType
and Doc.ProductionResourceInternalID = PRTAssgmt.ProductionResourceInternalID
association [1..*] to R_ProductionRoutingHeaderTP_2 as _Header on $projection.ProductionRoutingGroup = _Header.ProductionRoutingGroup
and $projection.ProductionRouting = _Header.ProductionRouting
and $projection.ValidityEndDate >= _Header.ValidityStartDate
and $projection.ValidityStartDate <= _Header.ValidityEndDate
association to R_ProductionRoutingTP_2 as _ProdnRtgTP on $projection.ProductionRoutingGroup = _ProdnRtgTP.ProductionRoutingGroup
and $projection.ProductionRouting = _ProdnRtgTP.ProductionRouting
association to parent R_ProdnRtgNonHistoricSqncTP_2 as _NonSqncTP on $projection.ProductionRoutingGroup = _NonSqncTP.ProductionRoutingGroup
and $projection.ProductionRouting = _NonSqncTP.ProductionRouting
and $projection.ProductionRoutingSequence = _NonSqncTP.ProductionRoutingSequence
{
key PRTAssgmt.ProductionRoutingGroup,
key PRTAssgmt.ProductionRouting,
key PRTAssgmt.ProductionRoutingSequence,
key PRTAssgmt.ProductionRoutingOpIntID,
key PRTAssgmt.BOOOperationPRTInternalID,
key PRTAssgmt.BOOOperationPRTIntVersCounter,
PRTAssgmt.ProductionResourceType,
PRTAssgmt.ProductionResourceInternalID,
Doc.DocumentType,
Doc.DocumentInfoRecord,
Doc.DocumentVersion,
Doc.DocumentPart,
PRTAssgmt.ProdnRsceToolItemNumber,
PRTAssgmt.ProdnRsceToolStandardTextCode,
PRTAssgmt.ProdnRsceToolText,
PRTAssgmt.ProdnRsceToolControlProfile,
@Semantics.quantity.unitOfMeasure: 'ProdnRsceToolStdWorkQtyUnit'
PRTAssgmt.ProdnRsceToolStandardWorkQty,
PRTAssgmt.ProdnRsceToolStdWorkQtyUnit,
PRTAssgmt.ProdnRsceToolTotQtyCalcFormula,
@Semantics.quantity.unitOfMeasure: 'ProdnRsceToolUsageQuantityUnit'
PRTAssgmt.ProdnRsceToolUsageQuantity,
PRTAssgmt.ProdnRsceToolUsageQuantityUnit,
PRTAssgmt.ProdnRsceToolUsageQtyCalcFmla,
PRTAssgmt.ChangeNumber,
@Semantics.businessDate.from: true
PRTAssgmt.ValidityStartDate,
@Semantics.businessDate.to: true
PRTAssgmt.ValidityEndDate,
PRTAssgmt.CreationDate,
PRTAssgmt.CreatedByUser,
PRTAssgmt.LastChangeDate,
PRTAssgmt.LastChangedByUser,
_NonSqncTP.ChangedDateTime,
/*Associations*/
_NonSqncTP,
_ProdnRtgTP,
@Consumption.hidden: true
_Header
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTPRTBYINTERNALKEY",
"P_PRODUCTIONROUTINGPRTASSGMT",
"R_PRODNRTGNONHISTORICSQNCTP_2"
],
"ASSOCIATED":
[
"R_PRODNRTGNONHISTORICSQNCTP_2",
"R_PRODUCTIONROUTINGHEADERTP_2",
"R_PRODUCTIONROUTINGTP_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA