I_MRPCHANGEREQUESTLIST
List of MRP Change Requests
I_MRPCHANGEREQUESTLIST is a CDS View in S/4HANA. List of MRP Change Requests. It contains 45 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MRPChangeRequestList | view_entity | from | CONSUMPTION | List of MRP Change Requests |
Fields (45)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Material | Material | 1 |
| KEY | MRPElement | MRPElement | 1 |
| KEY | MRPElementItem | MRPElementItem | 1 |
| KEY | MRPElementScheduleLine | MRPElementScheduleLine | 1 |
| KEY | MRPPlant | MRPPlant | 1 |
| _PurchaseOrderQuantityUnit | _PurchaseOrderQuantityUnit | 1 | |
| _Supplier | _Supplier | 1 | |
| AuthorizationGroup | AuthorizationGroup | 1 | |
| ChangedDateTime | ChangedDateTime | 1 | |
| ChangeRequestNote | ChangeRequestNote | 1 | |
| ChangeRequestProposedDate | ChangeRequestProposedDate | 1 | |
| ChangeRequestProposedQty | ChangeRequestProposedQty | 1 | |
| ChangeRequestUUID | ChangeRequestUUID | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CreationDateTime | CreationDateTime | 1 | |
| Currency | Currency | 1 | |
| DeliveryDate | DeliveryDate | 1 | |
| ExceptionMessageID | ExceptionMessageID | 1 | |
| ExceptionMessageText | ExceptionMessageText | 1 | |
| GoodsReceiptDurationInDays | GoodsReceiptDurationInDays | 1 | |
| MaterialName | MaterialName | 1 | |
| MRPArea | MRPArea | 1 | |
| MRPChangeReqSendingDateTime | MRPChangeReqSendingDateTime | 1 | |
| MRPChangeReqSendingStatus | MRPChangeReqSendingStatus | 1 | |
| MRPController | MRPController | 1 | |
| MRPElementChgAvailyOrRqmtDate | MRPElementChgAvailyOrRqmtDate | 1 | |
| MRPExcptnPrpslDataSource | MRPExcptnPrpslDataSource | 1 | |
| MRPPlanningSegment | MRPPlanningSegment | 1 | |
| MRPRequestCostOfChangeAmount | MRPRequestCostOfChangeAmount | 1 | |
| MRPRequestPriority | MRPRequestPriority | 1 | |
| MRPRequestPriorityName | MRPRequestPriorityName | 1 | |
| MRPRequestReason | MRPRequestReason | 1 | |
| MRPRequestReasonName | MRPRequestReasonName | 1 | |
| MRPRequestRejection | MRPRequestRejection | 1 | |
| MRPRequestRejectionName | MRPRequestRejectionName | 1 | |
| MRPRequestSupplierResponse | MRPRequestSupplierResponse | 1 | |
| MRPRequestSupplierResponseText | MRPRequestSupplierResponseText | 1 | |
| OrderOpenQuantity | OrderOpenQuantity | 1 | |
| QuantityUnit | QuantityUnit | 1 | |
| SenderCompanyCodeName | SenderCompanyCodeName | 1 | |
| SolutionRequestStatusName | SolutionRequestStatusName | 1 | |
| Supplier | Supplier | 1 | |
| SupplierName | SupplierName | 1 | |
| SupplierPlant | SupplierPlant | 1 | |
| TotalQuantity | TotalQuantity | 1 |
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'List of MRP Change Requests'
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@AccessControl.personalData.blocking: #REQUIRED
define view entity I_MRPChangeRequestList
as select from I_MRPPurchaseOrderList as PurOrdList
inner join I_MRPPurchaseOrderScheduleLine as _MRPPurOrdSchLine on PurOrdList.MRPElement = _MRPPurOrdSchLine.PurchaseOrder
and PurOrdList.MRPElementItem = _MRPPurOrdSchLine.MRPElementItem
and PurOrdList.MRPElementScheduleLine = _MRPPurOrdSchLine.ScheduleLine
association [1..1] to I_MRPExceptionList as _MPRExceptions on $projection.MRPElement = _MPRExceptions.MRPElement
and $projection.MRPElementItem = _MPRExceptions.MRPElementItem
and $projection.MRPElementScheduleLine = _MPRExceptions.MRPElementScheduleLine
and $projection.MRPPlant = _MPRExceptions.MRPPlant
and $projection.Material = _MPRExceptions.Material
association [1..1] to I_MaterialPlant as _MaterialPlant on $projection.Material = _MaterialPlant.Material
and $projection.MRPPlant = _MaterialPlant.Plant
association [0..1] to P_MRPChangeRequest as _MRPChangeReq on $projection.MRPElement = _MRPChangeReq.MRPElement
and $projection.MRPElementItem = _MRPChangeReq.MRPElementItem
and $projection.MRPElementScheduleLine = _MRPChangeReq.MRPElementScheduleLine
and $projection.Material = _MRPChangeReq.Material
and _MRPChangeReq.SolutionRequestStatus != '03' // Discarded
and _MRPChangeReq.SolutionRequestStatus != 'C1' // Closed
and _MRPChangeReq.SolutionRequestStatus != '02' // Applied
{
key PurOrdList.MRPElement as MRPElement,
key PurOrdList.MRPElementItem as MRPElementItem,
key PurOrdList.MRPElementScheduleLine as MRPElementScheduleLine,
key PurOrdList.MRPPlant as MRPPlant,
key PurOrdList.Material as Material,
key PurOrdList.MRPArea as MRPArea,
_MPRExceptions.ExceptionMessageID,
_MPRExceptions.ExceptionMessageText,
@Semantics.quantity.unitOfMeasure: 'QuantityUnit'
_MRPPurOrdSchLine.OpenQuantity as OrderOpenQuantity,
_MPRExceptions.MRPElementReschedulingDate as ChangeRequestProposedDate,
_MPRExceptions.MRPExcptnPrpslDataSource,
@Semantics.quantity.unitOfMeasure: 'QUANTITYUNIT'
_MPRExceptions.ExcessStockQty as ChangeRequestProposedQty,
_MRPChangeReq.ChangeRequestUUID,
_MRPChangeReq.SupplierPlant,
_MaterialPlant.MRPController,
_MRPChangeReq.CreatedByUser,
_MRPChangeReq.TotalQuantity,
_MRPChangeReq.SolutionRequestStatus,
_MRPChangeReq.SolutionRequestStatusName,
_MRPChangeReq.MRPRequestSupplierResponse,
_MRPChangeReq.MRPRequestSupplierResponseText,
_MRPChangeReq.MRPElementAvailyOrRqmtDate,
_MRPChangeReq.MRPElementChgAvailyOrRqmtDate,
_MRPChangeReq.ChangeRequestNote,
_MRPChangeReq.MRPPlanningSegment,
case
when _MRPChangeReq.MRPRequestPriority is not null
then _MRPChangeReq.MRPRequestPriority
when _MPRExceptions.MRPRequestPriority is not null
then _MPRExceptions.MRPRequestPriority
else
''
end as MRPRequestPriority,
case
when _MRPChangeReq.MRPRequestPriority is not null
then _MRPChangeReq.MRPRequestPriorityName
when _MPRExceptions.MRPRequestPriority is not null
then _MPRExceptions.MRPRequestPriorityName
else
''
end as MRPRequestPriorityName,
case
when _MRPChangeReq.MRPRequestReason is not null
then _MRPChangeReq.MRPRequestReason
when _MPRExceptions.MRPRequestReason is not null
then _MPRExceptions.MRPRequestReason
else
''
end as MRPRequestReason,
case
when _MRPChangeReq.MRPRequestReason is not null
then _MRPChangeReq.MRPRequestReasonName
when _MPRExceptions.MRPRequestReason is not null
then _MPRExceptions.MRPRequestReasonName
else
''
end as MRPRequestReasonName,
_MRPChangeReq.MRPRequestRejection,
_MRPChangeReq.MRPRequestRejectionName,
_MRPChangeReq.MRPRequestDistributionStatus as MRPChangeReqSendingStatus,
_MRPChangeReq.MRPChangeReqSendingStatusName,
_MRPChangeReq.MRPRequestDistributedDateTime as MRPChangeReqSendingDateTime,
_MRPPurOrdSchLine._CompanyCode.CompanyCodeName as SenderCompanyCodeName,
@Semantics.amount.currencyCode: 'CURRENCY'
_MRPChangeReq.MRPRequestCostOfChangeAmount,
_MRPChangeReq.Currency,
_MRPChangeReq.HasAttachment,
_MRPChangeReq.AuthorizationGroup,
_MRPChangeReq.CreationDateTime,
_MRPChangeReq.ChangedDateTime,
_MRPPurOrdSchLine.QuantityUnit,
_MRPPurOrdSchLine.DeliveryDate,
_MRPPurOrdSchLine.DeliveryTime,
_MRPPurOrdSchLine.MaterialName,
_MRPPurOrdSchLine.Supplier,
_MRPPurOrdSchLine._Supplier.BPSupplierName as SupplierName,
_MRPPurOrdSchLine.PurchasingGroup,
_MRPPurOrdSchLine.PurchasingOrganization,
_MRPPurOrdSchLine.StorageLocation,
_MRPPurOrdSchLine.CompanyCode,
_MRPPurOrdSchLine.BaseUnit,
_MRPPurOrdSchLine.IncotermsClassification,
_MRPPurOrdSchLine.GoodsReceiptDurationInDays,
_MRPPurOrdSchLine._PurchaseOrderQuantityUnit,
_MRPPurOrdSchLine._CompanyCode,
_MRPPurOrdSchLine._Supplier
}