I_MRPPurchaseOrderScheduleLine

DDL: I_MRPPURCHASEORDERSCHEDULELINE SQL: IMRPPURORDSCHL Type: view COMPOSITE

Purchase Order Schedule Line

I_MRPPurchaseOrderScheduleLine is a Composite CDS View that provides data about "Purchase Order Schedule Line" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderScheduleLine) and exposes 28 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, MRPElementItem. It has 1 association to related views.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderScheduleLine I_PurchaseOrderScheduleLine from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMRPPURORDSCHL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Order Schedule Line view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY ScheduleLine ScheduleLine
KEY MRPElementItem
OpenQuantity OpenPurchaseOrderQuantity
QuantityUnit PurchaseOrderQuantityUnit
PurchaseOrderType _PurchaseOrder PurchaseOrderType
PurchaseOrderDate _PurchaseOrder PurchaseOrderDate
Plant _PurchaseOrderItem Plant
BaseUnit _PurchaseOrderItem BaseUnit
DeliveryDate ScheduleLineDeliveryDate
DeliveryTime ScheduleLineDeliveryTime
Supplier _PurchaseOrder Supplier
MRPArea _PurchaseOrderItem MRPArea
StorageLocation _PurchaseOrderItem StorageLocation
CompanyCode _PurchaseOrderItem CompanyCode
GoodsReceiptDurationInDays _PurchaseOrderItem GoodsReceiptDurationInDays
PurchasingOrganization _PurchaseOrder PurchasingOrganization
PurchasingGroup _PurchaseOrder PurchasingGroup
IncotermsClassification _PurchaseOrder IncotermsClassification
Material _PurchaseOrderItem Material
MaterialName
SupplierName _PurchaseOrder SupplierRespSalesPersonName
PurchasingDocumentDeletionCode _PurchaseOrderItem PurchasingDocumentDeletionCode
_Supplier _Supplier
_PurchaseOrderQuantityUnit _PurchaseOrderQuantityUnit
_PurchaseOrderItem _PurchaseOrderItem
_CompanyCode _PurchaseOrderItem _CompanyCode 
@AbapCatalog.sqlViewName: 'IMRPPURORDSCHL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Order Schedule Line'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
define view I_MRPPurchaseOrderScheduleLine as select from I_PurchaseOrderScheduleLine
      association [0..1] to I_Supplier as _Supplier               
                         on $projection.Supplier = _Supplier.Supplier    
{
  key   PurchaseOrder,
  key   PurchaseOrderItem,    
  key   ScheduleLine,    
  key   cast( lpad(PurchaseOrderItem,6,'0')  as delps )                                          as MRPElementItem,           
        @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
        OpenPurchaseOrderQuantity                                                                as OpenQuantity,
        @Semantics.unitOfMeasure:true
        @ObjectModel.foreignKey.association: '_PurchaseOrderQuantityUnit'
        PurchaseOrderQuantityUnit                                                                as QuantityUnit,
        _PurchaseOrder.PurchaseOrderType                                                         as PurchaseOrderType,
        _PurchaseOrder.PurchaseOrderDate,
        _PurchaseOrderItem.Plant                                                                 as Plant,
        _PurchaseOrderItem.BaseUnit                                                              as BaseUnit,
        ScheduleLineDeliveryDate                                                                 as DeliveryDate,
        ScheduleLineDeliveryTime                                                                 as DeliveryTime,
        _PurchaseOrder.Supplier                                                                  as Supplier,
        _PurchaseOrderItem.MRPArea,
        _PurchaseOrderItem.StorageLocation,
        _PurchaseOrderItem.CompanyCode,
        _PurchaseOrderItem.GoodsReceiptDurationInDays                                           as GoodsReceiptDurationInDays,
        _PurchaseOrder.PurchasingOrganization,
        _PurchaseOrder.PurchasingGroup,
        _PurchaseOrder.IncotermsClassification,
        _PurchaseOrderItem.Material                                                              as Material,
        _PurchaseOrderItem._Material._Text[1: Language = $session.system_language ].MaterialName as MaterialName,
        _PurchaseOrder.SupplierRespSalesPersonName                                               as SupplierName,
        _PurchaseOrderItem.PurchasingDocumentDeletionCode,
        _Supplier,
        _PurchaseOrderQuantityUnit,
        _PurchaseOrderItem,
        _PurchaseOrderItem._CompanyCode
}

where  _PurchaseOrderItem.PurchasingDocumentDeletionCode = ' '  
or     _PurchaseOrderItem.PurchasingDocumentDeletionCode = 'S'  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIAL",
"I_MATERIALTEXT",
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM",
"I_PURCHASEORDERSCHEDULELINE"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_PURCHASEORDERITEM",
"I_SUPPLIER",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_PURCHASEORDERITEM",
"I_PURCHASEORDERSCHEDULELINE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More