I_EWM_ProdnMatlReqHeader

DDL: I_EWM_PRODNMATLREQHEADER Type: view_entity COMPOSITE Package: VDM_EWM_DLV
21 Fields 1 Data Sources 6 Associations

Production Material Request Header

I_EWM_ProdnMatlReqHeader (Composite)

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

Warehouse Production Material Request · Supply Chain

I_EWM_ProdnMatlReqHeader is a Composite CDS View that provides data about "Production Material Request Header" in SAP S/4HANA. It reads from 1 data source (I_EWM_ProdnMatlReqHdrBasic) and exposes 21 fields with key field EWMProductionMaterialRequest. It has 6 associations to related views. Part of development package VDM_EWM_DLV.

SAP Help Documentation

CategoryCDS Views for Production Material Requests
StatusManufacturing Status
Purpose
This CDS view provides a comprehensive overview of production material requests. It aggregates and presents data related to production material requests, including their status, associated manufacturing orders, and relevant timestamps, facilitating efficient tracking and management of production materials. This CDS view provides the data to answer the following business questions: Which manufacturing orders are associated with specific production material requests? What are the planned start and end times for production related to these production material requests? Who created and last modified these production material requests, and when did these actions occur? 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: SCWM_LGNU (Warehouse Number/Warehouse Complex) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description EWMProductionMaterialRequest Document Number EWMWarehouse Warehouse Number/Warehouse Complex ManufacturingOrder Manufacturing Order ID EWMProductionInformation Finished Product or Order Text EWMManufacturingOrderStatus Manufacturing Status

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSupply Chain
Application ComponentSCM-EWM-DLP-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSupply Chain for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides a comprehensive overview of production material requests. It aggregates and presents data related to production material requests, including their status, associated manufacturing orders, and relevant timestamps, facilitating efficient tracking and management of production materials.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li> <p>Which manufacturing orders are associated with specific production material requests?</p></li> <li> <p>What are the planned start and end times for production related to these production material requests?</p></li> <li> <p>Who created and last modified these production material requests, and when did these actions occur?</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
I_EWM_ProdnMatlReqHdrBasic I_EWM_ProdnMatlReqHdrBasic from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_EWM_WarehouseRequestRefDoc _ManufacturingOrder $projection.EWMProductionMaterialReqUUID = _ManufacturingOrder.EWMWarehouseRequestUUID and $projection.EWMProdnMatlReqDocCategory = _ManufacturingOrder.EWMWhseRequestDocumentCategory and _ManufacturingOrder.EWMReferenceDocumentCategory = 'PPO'
[0..1] I_EWM_DeliveryType_2 _EWMProdnMatlReqDocumentType $projection.EWMProdnMatlReqDocumentType = _EWMProdnMatlReqDocumentType.EWMDeliveryDocumentType and $projection.EWMProdnMatlReqDocCategory = _EWMProdnMatlReqDocumentType.EWMDeliveryDocumentCategory
[0..1] I_EWM_DeliveryDateAndTime _EWMPlndProdnStartUTCDateTime $projection.EWMProductionMaterialReqUUID = _EWMPlndProdnStartUTCDateTime.DeliveryOrderUUID and $projection.EWMProdnMatlReqDocCategory = _EWMPlndProdnStartUTCDateTime.EWMDeliveryDocumentCategory and _EWMPlndProdnStartUTCDateTime.DeliveryDateTimeType = 'SPRODUCTION' and _EWMPlndProdnStartUTCDateTime.DeliveryDateTimeCategory = 'PLAN'
[0..1] I_EWM_DeliveryDateAndTime _EWMPlndProdnEndUTCDateTime $projection.EWMProductionMaterialReqUUID = _EWMPlndProdnEndUTCDateTime.DeliveryOrderUUID and $projection.EWMProdnMatlReqDocCategory = _EWMPlndProdnEndUTCDateTime.EWMDeliveryDocumentCategory and _EWMPlndProdnEndUTCDateTime.DeliveryDateTimeType = 'EPRODUCTION' and _EWMPlndProdnEndUTCDateTime.DeliveryDateTimeCategory = 'PLAN'
[0..*] I_EWM_WhseReqStatusValueText _EWMManufacturingOrdStatusTxt $projection.EWMManufacturingOrderStatus = _EWMManufacturingOrdStatusTxt.EWMWarehouseRequestStatus and _EWMManufacturingOrdStatusTxt.EWMWarehouseRequestStatusType = 'DMC'
[0..*] I_EWM_WhseReqStatusValueText _EWMInconstcyBlockStatusTxt $projection.EWMInconsistencyBlockStatus = _EWMInconstcyBlockStatusTxt.EWMWarehouseRequestStatus and _EWMInconstcyBlockStatusTxt.EWMWarehouseRequestStatusType = 'DBC'

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Production Material Request Header view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name WarehouseProductionMaterialReq view
VDM.viewType #COMPOSITE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY EWMProductionMaterialRequest EWMProductionMaterialRequest Document Number
EWMWarehouse EWMWarehouse Warehouse Number/Warehouse Complex
EWMProdnMatlReqDocCategory EWMProdnMatlReqDocCategory Document Category
EWMProdnMatlReqDocumentType EWMProdnMatlReqDocumentType Document Type
ManufacturingOrder Manufacturing Order ID
EWMProductionInformation EWMProductionInformation Finished Product or Order Text
EWMProdnMatlReqPriority EWMProdnMatlReqPriority Order Priority
EWMManufacturingOrderStatus EWMManufacturingOrderStatus Status Value
EWMInconsistencyBlockStatus EWMInconsistencyBlockStatus Status Value
EWMArchivingStatus EWMArchivingStatus Status Value
EWMProdnMatlReqCrtnUTCDateTime EWMProdnMatlReqCrtnUTCDateTime Created On
EWMProdnMatlReqCreatedByUser EWMProdnMatlReqCreatedByUser Created By
EWMProdnMatlReqLstChgUTCDteTme EWMProdnMatlReqLstChgUTCDteTme Changed On
EWMProdnMatlReqLastChgdByUser EWMProdnMatlReqLastChgdByUser Changed By
EWMPlndProdnStartUTCDateTime _EWMPlndProdnStartUTCDateTime DeliveryRelatedStartDateTime Creation Date/Time
EWMPlndProdnEndUTCDateTime _EWMPlndProdnEndUTCDateTime DeliveryRelatedEndDateTime Creation Date/Time
EWMProductionMaterialReqUUID EWMProductionMaterialReqUUID Document ID
_ManufacturingOrder _ManufacturingOrder
_EWMManufacturingOrdStatusTxt _EWMManufacturingOrdStatusTxt
_EWMInconstcyBlockStatusTxt _EWMInconstcyBlockStatusTxt
_EWMProdnMatlReqDocumentType _EWMProdnMatlReqDocumentType

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_EWM_ProdnMatlReqHeader.
-- 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_EWM_ProdnMatlReqHeader AS
SELECT
  EWMProductionMaterialRequest,
  EWMWarehouse,
  EWMProdnMatlReqDocCategory,
  EWMProdnMatlReqDocumentType,
  cast( _ManufacturingOrder.EWMWhseReqRefDocumentNumber as manufacturingorder ) AS ManufacturingOrder,
  EWMProductionInformation,
  EWMProdnMatlReqPriority,
  EWMManufacturingOrderStatus,
  EWMInconsistencyBlockStatus,
  EWMArchivingStatus,
  EWMProdnMatlReqCrtnUTCDateTime,
  EWMProdnMatlReqCreatedByUser,
  EWMProdnMatlReqLstChgUTCDteTme,
  EWMProdnMatlReqLastChgdByUser,
  _EWMPlndProdnStartUTCDateTime.DeliveryRelatedStartDateTime AS EWMPlndProdnStartUTCDateTime,
  _EWMPlndProdnEndUTCDateTime.DeliveryRelatedEndDateTime AS EWMPlndProdnEndUTCDateTime,
  EWMProductionMaterialReqUUID
FROM I_EWM_ProdnMatlReqHdrBasic
LEFT OUTER JOIN I_EWM_WarehouseRequestRefDoc AS _ManufacturingOrder ON EWMProductionMaterialReqUUID = _ManufacturingOrder.EWMWarehouseRequestUUID AND EWMProdnMatlReqDocCategory = _ManufacturingOrder.EWMWhseRequestDocumentCategory AND _ManufacturingOrder.EWMReferenceDocumentCategory = 'PPO'  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryType_2 AS _EWMProdnMatlReqDocumentType ON EWMProdnMatlReqDocumentType = _EWMProdnMatlReqDocumentType.EWMDeliveryDocumentType AND EWMProdnMatlReqDocCategory = _EWMProdnMatlReqDocumentType.EWMDeliveryDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryDateAndTime AS _EWMPlndProdnStartUTCDateTime ON EWMProductionMaterialReqUUID = _EWMPlndProdnStartUTCDateTime.DeliveryOrderUUID AND EWMProdnMatlReqDocCategory = _EWMPlndProdnStartUTCDateTime.EWMDeliveryDocumentCategory AND _EWMPlndProdnStartUTCDateTime.DeliveryDateTimeType = 'SPRODUCTION' AND _EWMPlndProdnStartUTCDateTime.DeliveryDateTimeCategory = 'PLAN'  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryDateAndTime AS _EWMPlndProdnEndUTCDateTime ON EWMProductionMaterialReqUUID = _EWMPlndProdnEndUTCDateTime.DeliveryOrderUUID AND EWMProdnMatlReqDocCategory = _EWMPlndProdnEndUTCDateTime.EWMDeliveryDocumentCategory AND _EWMPlndProdnEndUTCDateTime.DeliveryDateTimeType = 'EPRODUCTION' AND _EWMPlndProdnEndUTCDateTime.DeliveryDateTimeCategory = 'PLAN'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _EWMManufacturingOrdStatusTxt ON EWMManufacturingOrderStatus = _EWMManufacturingOrdStatusTxt.EWMWarehouseRequestStatus AND _EWMManufacturingOrdStatusTxt.EWMWarehouseRequestStatusType = 'DMC'  -- association [0..*]
LEFT OUTER JOIN I_EWM_WhseReqStatusValueText AS _EWMInconstcyBlockStatusTxt ON EWMInconsistencyBlockStatus = _EWMInconstcyBlockStatusTxt.EWMWarehouseRequestStatus AND _EWMInconstcyBlockStatusTxt.EWMWarehouseRequestStatusType = 'DBC'  -- association [0..*]
;

Learn More