I_MRPChangeRequestLine

DDL: I_MRPCHANGEREQUESTLINE SQL: IMRPCHREQLINE Type: view BASIC

MRP Change Request Line

I_MRPChangeRequestLine is a Basic CDS View that provides data about "MRP Change Request Line" in SAP S/4HANA. It reads from 1 data source (mrp_req_line) and exposes 13 fields with key fields ChangeRequestUUID, ChangeRequestLineUUID. It has 1 association to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
mrp_req_line mrp_req_line from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MRPChangeRequest _ChangeRequest $projection.ChangeRequestUUID = _ChangeRequest.ChangeRequestUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMRPCHREQLINE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MRP Change Request Line view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey ChangeRequestLineUUID view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ChangeRequestUUID request_id
KEY ChangeRequestLineUUID request_line_id
ChangeRequestLineType linetype
ScheduleLine mrpelementscheduleline
AvailabilityDate availability_date
DeliveryDate delivery_date
OpenQuantity open_quant
TotalQuantity total_quant
CreationDateTime createdon
CreatedByUser crenam
ChangedDateTime updatedon
LastChangedByUser updnam
_ChangeRequest _ChangeRequest 
@AbapCatalog.sqlViewName: 'IMRPCHREQLINE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'MRP Change Request Line'

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.viewType: #BASIC
define view I_MRPChangeRequestLine
  as select from mrp_req_line

  association [1..1] to I_MRPChangeRequest as _ChangeRequest on $projection.ChangeRequestUUID = _ChangeRequest.ChangeRequestUUID

{
      @ObjectModel.foreignKey.association: '_ChangeRequest'
  key request_id             as ChangeRequestUUID,
  key request_line_id        as ChangeRequestLineUUID,
      linetype               as ChangeRequestLineType,
      mrpelementscheduleline as ScheduleLine,

      @Semantics.businessDate.at: true
      availability_date      as AvailabilityDate,
      @Semantics.businessDate.at: true
      delivery_date          as DeliveryDate,

      open_quant             as OpenQuantity,
      total_quant            as TotalQuantity,

      @Semantics.systemDateTime.createdAt: true
      createdon              as CreationDateTime,
      @Semantics.user.createdBy: true
      crenam                 as CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      updatedon              as ChangedDateTime,
      @Semantics.user.lastChangedBy: true
      updnam                 as LastChangedByUser,

      _ChangeRequest
}

Learn More