I_ProdnRoutingMatlAssgmtDEX

DDL: I_PRODNROUTINGMATLASSGMTDEX Type: view_entity BASIC
27 Fields 1 Data Sources 1 Associations

Production Routing Material Assignment

I_ProdnRoutingMatlAssgmtDEX (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

ProductionRoutingMatlAssgmt · Manufacturing

I_ProdnRoutingMatlAssgmtDEX is a Basic CDS View (Dimension) that provides data about "Production Routing Material Assignment" in SAP S/4HANA. It reads from 1 data source (P_ProdnRoutingMatlAssgmtDEX) and exposes 27 fields with key fields Product, Plant, BillOfOperationsType, ProductionRoutingGroup, ProductionRouting. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Basic Routing Data
Data CategoryDIMENSION
Purpose
This CDS view is designed to provide a structured representation of production routing material assignments within a manufacturing context. It captures essential details such as product, plant, and routing information, along with validity dates and change tracking data. The view is intended to support analytical and data extraction purposes, enabling users to analyze and manage production routing assignments effectively. This CDS view provides the data to answer the following business questions: Which materials are assigned to specific production routings within a plant? What are the validity periods for each production routing material assignment? How have production routing material assignments changed over time, and who made these changes? Are there any deleted or implicitly deleted production routing material assignments? Which suppliers and customers are associated with specific production routing material assignments? How do production routing material assignments relate to specific sales orders and sales order items? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: C_ROUT - Authorizations for Routings

Structure
Important Fields Important fields in this view include the following: Field Name Description Product Material Plant Plant BillOfOperationsType Task List Type ProductionRoutingGroup Group ProductionRouting Group Counter ProductionRoutingMatlAssgmt Addit. Crit. Cntr ProductionRtgMatlAssgmtIntVers Counter ValidityStartDate Valid From ValidityEndDate Valid to ChangeNumber Change Number CreationDate Created On CreatedByUser Created By LastChangeDate Changed On LastChangedByUser Changed By IsDeleted Deletion Indicator IsImplicitlyDeleted Deletion Indicator Supplier Supplier Customer Customer SalesOrder Sales Document SalesOrderItem Sales Document Item

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD
CapabilitiesAssociation Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is designed to provide a structured representation of production routing material assignments within a manufacturing context. It captures essential details such as product, plant, and routing information, along with validity dates and change tracking data. The view is intended to support analytical and data extraction purposes, enabling users to analyze and manage production routing assignments effectively.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which materials are assigned to specific production routings within a plant?</p></li> <li><p>What are the validity periods for each production routing material assignment?</p></li> <li><p>How have production routing material assignments changed over time, and who made these changes?</p></li> <li><p>Are there any deleted or implicitly deleted production routing material assignments?</p></li> <li><p>Which suppliers and customers are associated with specific production routing material assignments?</p></li> <li><p>How do production routing material assignments relate to specific sales orders and sales order items?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_ProdnRoutingMatlAssgmtDEX P_ProdnRoutingMatlAssgmtDEX from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ProductionRoutingDEX _ProductionRouting $projection.BillOfOperationsType = _ProductionRouting.BillOfOperationsType and $projection.ProductionRoutingGroup = _ProductionRouting.ProductionRoutingGroup and $projection.ProductionRouting = _ProductionRouting.ProductionRouting

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.representativeKey ProductionRtgMatlAssgmtIntVers view
EndUserText.label Production Routing Material Assignment view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.internalName #LOCAL view
ObjectModel.sapObjectNodeType.name ProductionRoutingMatlAssgmt view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Product Product Material Number
KEY Plant Plant Valuation Area
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY ProductionRoutingGroup ProductionRoutingGroup Key for Task List Group
KEY ProductionRouting ProductionRouting Referenced BOO Variant
KEY ProductionRoutingMatlAssgmt ProductionRoutingMatlAssgmt Counter for Additional Criteria
KEY ProductionRtgMatlAssgmtIntVers ProductionRtgMatlAssgmtIntVers Internal counter
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Valid-to date
ChangeNumber ChangeNumber Change Number
CreationDate CreationDate Date Record Created On
CreatedByUser CreatedByUser Created By User
LastChangeDate LastChangeDate Last Changed On
LastChangedByUser LastChangedByUser Last Changed By User
IsDeleted IsDeleted Deletion Indicator
IsImplicitlyDeleted IsImplicitlyDeleted Deletion Indicator
Supplier Supplier Supplier's Account Number
Customer Customer Account number of customer
SalesOrder SalesOrder Sales Document
SalesOrderItem SalesOrderItem Sales Document Item
_BillOfOperations _BillOfOperations
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType
_BOOMaterialAssignment _BOOMaterialAssignment
_Plant _Plant
_Product _Product
_ProductionRouting _ProductionRouting

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 I_ProdnRoutingMatlAssgmtDEX.
-- 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 I_ProdnRoutingMatlAssgmtDEX AS
SELECT
  Product,
  Plant,
  BillOfOperationsType,
  ProductionRoutingGroup,
  ProductionRouting,
  ProductionRoutingMatlAssgmt,
  ProductionRtgMatlAssgmtIntVers,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  IsDeleted,
  IsImplicitlyDeleted,
  Supplier,
  Customer,
  SalesOrder,
  SalesOrderItem
FROM P_ProdnRoutingMatlAssgmtDEX
LEFT OUTER JOIN I_ProductionRoutingDEX AS _ProductionRouting ON BillOfOperationsType = _ProductionRouting.BillOfOperationsType AND ProductionRoutingGroup = _ProductionRouting.ProductionRoutingGroup AND ProductionRouting = _ProductionRouting.ProductionRouting  -- association [1..1]
;

Learn More