P_MaintOrdCompScheduleLine

DDL: P_MAINTORDCOMPSCHEDULELINE SQL: PMTORDCMPSCHDL Type: view COMPOSITE

P_MaintOrdCompScheduleLine is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_MaintenanceOrderComponent, I_PurchasingDocument, I_PurchaseOrderScheduleLine) and exposes 3 fields. It has 1 association to related views.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
I_MaintenanceOrderComponent _Component inner
I_PurchasingDocument _PurchasingDocument inner
I_PurchaseOrderScheduleLine I_PurchaseOrderScheduleLine from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductUnitsOfMeasure _AlternativeUnitOfMeasure _Component.Material = _AlternativeUnitOfMeasure.Product -- and I_PurchaseOrderScheduleLine.PurchaseOrderQuantityUnit = _AlternativeUnitOfMeasure.AlternativeUnit

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PMTORDCMPSCHDL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
RoughGoodsReceiptQty RoughGoodsReceiptQty 
@AbapCatalog.sqlViewName: 'PMTORDCMPSCHDL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.private: true
@VDM.viewType: #COMPOSITE

-- unused?

define view P_MaintOrdCompScheduleLine
  as select from I_PurchaseOrderScheduleLine
  inner join I_PurchasingDocument as _PurchasingDocument on _PurchasingDocument.PurchasingDocument = I_PurchaseOrderScheduleLine.PurchaseOrder
--  inner join I_MaintenanceOrderComponent as _Component on  _Component.PurchaseRequisition     = I_PurchaseOrderScheduleLine.PurchaseRequisition
--                                                       and _Component.PurchaseRequisitionItem = I_PurchaseOrderScheduleLine.PurchaseRequisitionItem
--  association [0..1] to I_ProductUnitsOfMeasure as _AlternativeUnitOfMeasure on _Component.Material = _AlternativeUnitOfMeasure.Product
--                                                                             and I_PurchaseOrderScheduleLine.PurchaseOrderQuantityUnit = _AlternativeUnitOfMeasure.AlternativeUnit
{
//  key _Component.MaintenanceOrder,

//  key _Component.MaintenanceOrderOperation,

//  key _Component.MaintenanceOrderComponent,

//  

//      _Component.PurchaseRequisition,

//      _Component.PurchaseRequisitionItem,


      ScheduleLineDeliveryDate,
      ScheduleLineOrderQuantity,
      RoughGoodsReceiptQty
      
      
//      coalesce( ScheduleLineOrderQuantity * DIVISION( _AlternativeUnitOfMeasure.QuantityNumerator , _AlternativeUnitOfMeasure.QuantityDenominator, 0 ), unit_conversion( quantity =>  ScheduleLineOrderQuantity,

//                            source_unit => I_PurchaseOrderScheduleLine.PurchaseOrderQuantityUnit,

//                            target_unit => _Component.BaseUnit,

//                            error_handling => 'KEEP_UNCONVERTED' ) ) as ScheduleLineOrderQuantity,

//      unit_conversion( quantity =>  RoughGoodsReceiptQty,

//                            source_unit => I_PurchaseOrderScheduleLine.PurchaseOrderQuantityUnit,

//                            target_unit => _Component.BaseUnit,

//                            error_handling => 'KEEP_UNCONVERTED' ) as RoughGoodsReceiptQty

                            
//      _Component._PurchaseRequisitionItem

} where _PurchasingDocument.PurchasingDocumentCategory = 'F' -- I_PurchaseOrderScheduleLine.PurchaseRequisition <> '' and _Component.IsDeleted = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERSCHEDULELINE",
"I_PURCHASINGDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More