I_MRPRequestNote

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMRPREQUESTNOTE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED,
    personalData.blocking: #NOT_REQUIRED
}

@ObjectModel: {
    usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL },
    semanticKey:  [ 'ChangeRequestUUID' ]
}

@EndUserText.label: 'MRP Request Note'

@VDM.viewType: #BASIC
define view I_MRPRequestNote
  as select from mrp_req_note
{
  key request_id                                                                as ChangeRequestUUID,
      mrpplant                                                                  as MRPPlant,
      matnr                                                                     as Material,
      mrparea                                                                   as MRPArea,
      createdon                                                                 as CreationDateTime,
      crenam                                                                    as CreatedByUser,
      materialgoodsreceiptduration                                              as GoodsReceiptDuration,
      mrpelement                                                                as MRPElement,
      mrpelementitem                                                            as MRPElementItem,
      mrpelementscheduleline                                                    as MRPElementScheduleLine,
      mrpplanningsegmentnumber                                                  as MRPPlanningSegment,
      mrpplanningsegmenttype                                                    as MRPPlanningSegmentType,
      note                                                                      as ChangeRequestNote,
      status                                                                    as SolutionRequestStatus,
      type                                                                      as ChangeRequestType,
      updatedon                                                                 as ChangedDateTime,
      updnam                                                                    as LastChangedByUser,
      vendor                                                                    as Supplier,
      vendorplant                                                               as SupplierPlant,
      vendorstatus                                                              as MRPRequestSupplierResponse,
      mrpcrstate                                                                as MRPRequestDistributionStatus,
      distributedon                                                             as MRPRequestDistributedDateTime,
      prioritycode                                                              as MRPRequestPriority,
      reasoncode                                                                as MRPRequestReason,
      rejectioncode                                                             as MRPRequestRejection,
      costofchange                                                              as MRPRequestCostOfChangeAmount,
      currencykey                                                               as Currency,
      attachment                                                                as HasAttachment
            
}