I_MRPDiscardedChangeRequest

DDL: I_MRPDISCARDEDCHANGEREQUEST SQL: IMRPDISCR Type: view TRANSACTIONAL

I_MRPDiscardedChangeRequest is a Transactional CDS View in SAP S/4HANA. It reads from 1 data source (I_MRPRequestNote) and exposes 9 fields with key fields ChangeRequestUUID, MRPElement, MRPElementItem, MRPElementScheduleLine. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_MRPRequestNote Note from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MRPChangeRequestLine _ChangeRequestLineRequested $projection.ChangeRequestUUID = _ChangeRequestLineRequested.ChangeRequestUUID and _ChangeRequestLineRequested.ChangeRequestLineType = '02'

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMRPDISCR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChangeRequestUUID I_MRPRequestNote ChangeRequestUUID
KEY MRPElement I_MRPRequestNote MRPElement
KEY MRPElementItem I_MRPRequestNote MRPElementItem
KEY MRPElementScheduleLine I_MRPRequestNote MRPElementScheduleLine
Material I_MRPRequestNote Material
SolutionRequestStatus I_MRPRequestNote SolutionRequestStatus
MRPElementChgAvailyOrRqmtDate _ChangeRequestLineRequested DeliveryDate
TotalQuantity _ChangeRequestLineRequested TotalQuantity
QuantityUnit _MRPPurOrdSchLine QuantityUnit 
@AbapCatalog.sqlViewName: 'IMRPDISCR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: {serviceQuality: #C , sizeCategory: #L, dataClass: #TRANSACTIONAL }
define view I_MRPDiscardedChangeRequest
  as select from           I_MRPRequestNote               as Note
    left outer to one join I_MRPPurchaseOrderScheduleLine as _MRPPurOrdSchLine on  Note.MRPElement             = _MRPPurOrdSchLine.PurchaseOrder
                                                                               and Note.MRPElementItem         = _MRPPurOrdSchLine.MRPElementItem
                                                                               and Note.MRPElementScheduleLine = _MRPPurOrdSchLine.ScheduleLine
  association [0..1] to I_MRPChangeRequestLine as _ChangeRequestLineRequested on  $projection.ChangeRequestUUID                     = _ChangeRequestLineRequested.ChangeRequestUUID
                                                                              and _ChangeRequestLineRequested.ChangeRequestLineType = '02'

{

  key    Note.ChangeRequestUUID,
  key    Note.MRPElement,
  key    Note.MRPElementItem,
  key    Note.MRPElementScheduleLine,
         Note.Material,
         Note.SolutionRequestStatus,
         _ChangeRequestLineRequested.DeliveryDate as MRPElementChgAvailyOrRqmtDate,
         @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
         _ChangeRequestLineRequested.TotalQuantity,
         @Semantics.unitOfMeasure:true
         _MRPPurOrdSchLine.QuantityUnit           as QuantityUnit

}
where
  Note.SolutionRequestStatus = '03'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MRPCHANGEREQUESTLINE",
"I_MRPPURCHASEORDERSCHEDULELINE",
"I_MRPREQUESTNOTE"
],
"ASSOCIATED":
[
"I_MRPCHANGEREQUESTLINE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More