C_MRPChangeRequestList

DDL: C_MRPCHANGEREQUESTLIST Type: view_entity CONSUMPTION
50 Fields 2 Data Sources 3 Associations

List of MRP Change Requests

C_MRPChangeRequestList is a Consumption CDS View that provides data about "List of MRP Change Requests" in SAP S/4HANA. It reads from 2 data sources (I_MRPChangeRequestList, I_SDMAreaOfResponsibility) and exposes 50 fields with key fields MRPElement, MRPElementItem, MRPElementScheduleLine, Material, MRPPlant. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MRPChangeRequestList MRPChangeRequestList from
I_SDMAreaOfResponsibility SDMAreaOfResponsibility inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MRPChangeRequestCalcValue _ChangeRequestHistory MRPChangeRequestList.MRPElement = _ChangeRequestHistory.MRPElement and MRPChangeRequestList.MRPElementItem = _ChangeRequestHistory.MRPElementItem and MRPChangeRequestList.MRPElementScheduleLine = _ChangeRequestHistory.MRPElementScheduleLine and MRPChangeRequestList.Material = _ChangeRequestHistory.Material and _ChangeRequestHistory.SolutionRequestStatus = '03'
[0..1] I_UnitOfMeasure _BaseUnit $projection.QuantityUnit = _BaseUnit.UnitOfMeasure
[1] E_MRPRequestNote _MrpRqNoteExtension $projection.ChangeRequestUUID = _MrpRqNoteExtension.ChangeRequestUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label List of MRP Change Requests view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY MRPElement I_MRPChangeRequestList MRPElement MRP element number
KEY MRPElementItem I_MRPChangeRequestList MRPElementItem MRP elemnt item
KEY MRPElementScheduleLine I_MRPChangeRequestList MRPElementScheduleLine Scheduling
KEY Material I_MRPChangeRequestList Material Vehicle Model
KEY MRPPlant I_MRPChangeRequestList MRPPlant Plant
MRPController I_MRPChangeRequestList MRPController MRP Controller
MRPArea I_MRPChangeRequestList MRPArea MRP Area
CompanyCode I_MRPChangeRequestList CompanyCode Receiver Company Code
ChangeRequestUUID I_MRPChangeRequestList ChangeRequestUUID
OrderOpenQuantity I_MRPChangeRequestList OrderOpenQuantity PBE Entry Open Qty
QuantityUnit I_MRPChangeRequestList QuantityUnit Unit of measure
MaterialName I_MRPChangeRequestList MaterialName Material Description
ChangeRequestProposedDate I_MRPChangeRequestList ChangeRequestProposedDate
ExceptionMessageID I_MRPChangeRequestList ExceptionMessageID
ExceptionMessageText I_MRPChangeRequestList ExceptionMessageText
DeliveryDate I_MRPChangeRequestList DeliveryDate Delivery Date
MRPElementChgAvailyOrRqmtDate I_MRPChangeRequestList MRPElementChgAvailyOrRqmtDate
ChangeRequestProposedQty I_MRPChangeRequestList ChangeRequestProposedQty
TotalQuantity I_MRPChangeRequestList TotalQuantity Activity Quantity
NmbrOfDiscardedChangeRequests _ChangeRequestHistory NmbrOfDiscardedChangeRequests
MRPRequestSupplierResponse I_MRPChangeRequestList MRPRequestSupplierResponse
MRPRequestSupplierResponseText I_MRPChangeRequestList MRPRequestSupplierResponseText
SolutionRequestStatus
SolutionRequestStatusName I_MRPChangeRequestList SolutionRequestStatusName
MRPExcptnPrpslDataSource I_MRPChangeRequestList MRPExcptnPrpslDataSource
MRPPlanningSegment I_MRPChangeRequestList MRPPlanningSegment Plng Segmnt No.
Supplier I_MRPChangeRequestList Supplier Supplier
SupplierName I_MRPChangeRequestList SupplierName Supplier Name
SenderCompanyCodeName I_MRPChangeRequestList SenderCompanyCodeName
SupplierPlant I_MRPChangeRequestList SupplierPlant Plant
GoodsReceiptDurationInDays I_MRPChangeRequestList GoodsReceiptDurationInDays GR proc. time
ChangeRequestNote I_MRPChangeRequestList ChangeRequestNote Short Description
MRPRequestPriority I_MRPChangeRequestList MRPRequestPriority
MRPRequestPriorityName I_MRPChangeRequestList MRPRequestPriorityName
MRPRequestReason I_MRPChangeRequestList MRPRequestReason
MRPRequestReasonName I_MRPChangeRequestList MRPRequestReasonName
MRPRequestRejection I_MRPChangeRequestList MRPRequestRejection
MRPRequestRejectionName I_MRPChangeRequestList MRPRequestRejectionName
MRPRequestCostOfChangeAmount I_MRPChangeRequestList MRPRequestCostOfChangeAmount
Currency I_MRPChangeRequestList Currency Valuation Crcy
UnitOfMeasureNumberOfDecimals _BaseUnit UnitOfMeasureNumberOfDecimals
UnitOfMeasureDspNmbrOfDcmls _BaseUnit UnitOfMeasureDspNmbrOfDcmls
MRPChangeReqSendingStatus I_MRPChangeRequestList MRPChangeReqSendingStatus
MRPChangeReqSendingStatusName
CreationDateTime I_MRPChangeRequestList CreationDateTime Timestamp
ChangedDateTime I_MRPChangeRequestList ChangedDateTime Time Stamp
MRPChangeReqSendingDateTime I_MRPChangeRequestList MRPChangeReqSendingDateTime
_PurchaseOrderQuantityUnit I_MRPChangeRequestList _PurchaseOrderQuantityUnit
AuthorizationGroup I_MRPChangeRequestList AuthorizationGroup AuthorizGroup
_Supplier I_MRPChangeRequestList _Supplier

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 C_MRPChangeRequestList.
-- 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 C_MRPChangeRequestList AS
SELECT
  MRPChangeRequestList.MRPElement AS MRPElement,
  MRPChangeRequestList.MRPElementItem AS MRPElementItem,
  MRPChangeRequestList.MRPElementScheduleLine AS MRPElementScheduleLine,
  MRPChangeRequestList.Material AS Material,
  MRPChangeRequestList.MRPPlant AS MRPPlant,
  MRPChangeRequestList.MRPController AS MRPController,
  MRPChangeRequestList.MRPArea AS MRPArea,
  MRPChangeRequestList.CompanyCode AS CompanyCode,
  MRPChangeRequestList.ChangeRequestUUID AS ChangeRequestUUID,
  MRPChangeRequestList.OrderOpenQuantity AS OrderOpenQuantity,
  MRPChangeRequestList.QuantityUnit AS QuantityUnit,
  MRPChangeRequestList.MaterialName AS MaterialName,
  MRPChangeRequestList.ChangeRequestProposedDate AS ChangeRequestProposedDate,
  MRPChangeRequestList.ExceptionMessageID AS ExceptionMessageID,
  MRPChangeRequestList.ExceptionMessageText AS ExceptionMessageText,
  MRPChangeRequestList.DeliveryDate AS DeliveryDate,
  MRPChangeRequestList.MRPElementChgAvailyOrRqmtDate AS MRPElementChgAvailyOrRqmtDate,
  MRPChangeRequestList.ChangeRequestProposedQty AS ChangeRequestProposedQty,
  MRPChangeRequestList.TotalQuantity AS TotalQuantity,
  _ChangeRequestHistory.NmbrOfDiscardedChangeRequests AS NmbrOfDiscardedChangeRequests,
  MRPChangeRequestList.MRPRequestSupplierResponse AS MRPRequestSupplierResponse,
  MRPChangeRequestList.MRPRequestSupplierResponseText AS MRPRequestSupplierResponseText,
  coalesce(MRPChangeRequestList.SolutionRequestStatus ,'') AS SolutionRequestStatus,
  MRPChangeRequestList.SolutionRequestStatusName AS SolutionRequestStatusName,
  MRPChangeRequestList.MRPExcptnPrpslDataSource AS MRPExcptnPrpslDataSource,
  MRPChangeRequestList.MRPPlanningSegment AS MRPPlanningSegment,
  MRPChangeRequestList.Supplier AS Supplier,
  MRPChangeRequestList.SupplierName AS SupplierName,
  MRPChangeRequestList.SenderCompanyCodeName AS SenderCompanyCodeName,
  MRPChangeRequestList.SupplierPlant AS SupplierPlant,
  MRPChangeRequestList.GoodsReceiptDurationInDays AS GoodsReceiptDurationInDays,
  MRPChangeRequestList.ChangeRequestNote AS ChangeRequestNote,
  MRPChangeRequestList.MRPRequestPriority AS MRPRequestPriority,
  MRPChangeRequestList.MRPRequestPriorityName AS MRPRequestPriorityName,
  MRPChangeRequestList.MRPRequestReason AS MRPRequestReason,
  MRPChangeRequestList.MRPRequestReasonName AS MRPRequestReasonName,
  MRPChangeRequestList.MRPRequestRejection AS MRPRequestRejection,
  MRPChangeRequestList.MRPRequestRejectionName AS MRPRequestRejectionName,
  MRPChangeRequestList.MRPRequestCostOfChangeAmount AS MRPRequestCostOfChangeAmount,
  MRPChangeRequestList.Currency AS Currency,
  _BaseUnit.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _BaseUnit.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  MRPChangeRequestList.MRPChangeReqSendingStatus AS MRPChangeReqSendingStatus,
  MRPChangeRequestList. MRPChangeReqSendingStatusName AS MRPChangeReqSendingStatusName,
  MRPChangeRequestList.CreationDateTime AS CreationDateTime,
  MRPChangeRequestList.ChangedDateTime AS ChangedDateTime,
  MRPChangeRequestList.MRPChangeReqSendingDateTime AS MRPChangeReqSendingDateTime,
  MRPChangeRequestList._PurchaseOrderQuantityUnit AS _PurchaseOrderQuantityUnit,
  MRPChangeRequestList.AuthorizationGroup AS AuthorizationGroup,
  MRPChangeRequestList._Supplier AS _Supplier
FROM I_MRPChangeRequestList AS MRPChangeRequestList
INNER JOIN I_SDMAreaOfResponsibility AS SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MRPChangeRequestCalcValue AS _ChangeRequestHistory ON MRPChangeRequestList.MRPElement = _ChangeRequestHistory.MRPElement AND MRPChangeRequestList.MRPElementItem = _ChangeRequestHistory.MRPElementItem AND MRPChangeRequestList.MRPElementScheduleLine = _ChangeRequestHistory.MRPElementScheduleLine AND MRPChangeRequestList.Material = _ChangeRequestHistory.Material AND _ChangeRequestHistory.SolutionRequestStatus = '03'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON QuantityUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_MRPRequestNote AS _MrpRqNoteExtension ON ChangeRequestUUID = _MrpRqNoteExtension.ChangeRequestUUID  -- association [1]
;

Learn More