P_PurOrdSingleScheduleLine

DDL: P_PURORDSINGLESCHEDULELINE SQL: PMMPURORDSS Type: view COMPOSITE Package: VDM_MM_PUR_PO

Get data of only one Schedule Line

P_PurOrdSingleScheduleLine is a Composite CDS View that provides data about "Get data of only one Schedule Line" in SAP S/4HANA. It reads from 2 data sources (I_PurgDocScheduleLine, P_PurOrdSingleScheduleLineHlp3) and exposes 8 fields with key fields PurchasingDocument, PurchasingDocumentItem. Part of development package VDM_MM_PUR_PO.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_PurgDocScheduleLine I_PurgDocScheduleLine inner
P_PurOrdSingleScheduleLineHlp3 P_PurOrdSingleScheduleLineHlp3 from

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.sqlViewName PMMPURORDSS view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurgDocScheduleLine PurchasingDocument
KEY PurchasingDocumentItem I_PurgDocScheduleLine PurchasingDocumentItem
ScheduleLine I_PurgDocScheduleLine ScheduleLine
ScheduleLineDeliveryDate I_PurgDocScheduleLine ScheduleLineDeliveryDate
ScheduleLineDeliveryTime I_PurgDocScheduleLine ScheduleLineDeliveryTime
PerformancePeriodStartDate I_PurgDocScheduleLine PerformancePeriodStartDate
PerformancePeriodEndDate I_PurgDocScheduleLine PerformancePeriodEndDate
DelivDateCategory I_PurgDocScheduleLine DelivDateCategory 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.sqlViewName: 'PMMPURORDSS'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

// the join with the helper view has the reason to make sure, that only one Schedule line (the latest) is returned


define view P_PurOrdSingleScheduleLine
  as select from P_PurOrdSingleScheduleLineHlp3 as P_PurOrdSingleScheduleLineHlp3
    inner join   I_PurgDocScheduleLine          as I_PurgDocScheduleLine on  P_PurOrdSingleScheduleLineHlp3.PurchasingDocument     = I_PurgDocScheduleLine.PurchasingDocument
                                                                         and P_PurOrdSingleScheduleLineHlp3.PurchasingDocumentItem = I_PurgDocScheduleLine.PurchasingDocumentItem
                                                                         and P_PurOrdSingleScheduleLineHlp3.minscheduleline        = I_PurgDocScheduleLine.ScheduleLine


{
  key I_PurgDocScheduleLine.PurchasingDocument    as PurchasingDocument,
  key I_PurgDocScheduleLine.PurchasingDocumentItem,
      I_PurgDocScheduleLine.ScheduleLine,
      I_PurgDocScheduleLine.ScheduleLineDeliveryDate,
      I_PurgDocScheduleLine.ScheduleLineDeliveryTime,
      I_PurgDocScheduleLine.PerformancePeriodStartDate,
      I_PurgDocScheduleLine.PerformancePeriodEndDate,
      I_PurgDocScheduleLine.DelivDateCategory
}
group by
  I_PurgDocScheduleLine.PurchasingDocument,
  I_PurgDocScheduleLine.PurchasingDocumentItem,
  I_PurgDocScheduleLine.ScheduleLine,
  I_PurgDocScheduleLine.ScheduleLineDeliveryDate,
  I_PurgDocScheduleLine.ScheduleLineDeliveryTime,
  I_PurgDocScheduleLine.PerformancePeriodStartDate,
  I_PurgDocScheduleLine.PerformancePeriodEndDate,
  I_PurgDocScheduleLine.DelivDateCategory

Learn More