P_PurchaseOrderScheduleLine1

DDL: P_PURCHASEORDERSCHEDULELINE1 SQL: PMMPOSCHELINE1 Type: view CONSUMPTION

P_PurchaseOrderScheduleLine1 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_PurgDocScheduleLine) and exposes 21 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. It has 4 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_PurgDocScheduleLine I_PurgDocScheduleLine from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
[0..1] I_UnitOfMeasure _PurchaseOrderQuantityUnit $projection.PurchaseOrderQuantityUnit = _PurchaseOrderQuantityUnit.UnitOfMeasure
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMPOSCHELINE1 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchasingDocument
KEY PurchaseOrderItem PurchasingDocumentItem
KEY ScheduleLine ScheduleLine
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
SchedLineStscDeliveryDate SchedLineStscDeliveryDate
PerformancePeriodStartDate PerformancePeriodStartDate
PerformancePeriodEndDate PerformancePeriodEndDate
ScheduleLineDeliveryTime ScheduleLineDeliveryTime
PurchasingDocument PurchasingDocument
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
RoughGoodsReceiptQty RoughGoodsReceiptQty
OpenPurchaseOrderQuantity
PurchaseOrderQuantityUnit _PurchaseOrderItem PurchaseOrderQuantityUnit
Currency _PurchaseOrderItem DocumentCurrency
curr213asOpenPurchaseOrderNetAmount
PurchaseRequisition I_PurgDocScheduleLine PurchaseRequisition
PurchaseRequisitionItem I_PurgDocScheduleLine PurchaseRequisitionItem
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem
_PurchaseOrderQuantityUnit _PurchaseOrderQuantityUnit
_Currency _Currency 
@AbapCatalog.sqlViewName: 'PMMPOSCHELINE1'
//@ClientDependent: true

@AbapCatalog.compiler.compareFilter: true
@VDM.viewType : #CONSUMPTION
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.private : true
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_PurchaseOrderScheduleLine1 as select from I_PurgDocScheduleLine 

  association [1..1] to I_PurchaseOrder           as _PurchaseOrder             on  $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
  association [1..1] to I_PurchaseOrderItem       as _PurchaseOrderItem         on  $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder
                                                                                and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
  association [0..1] to I_UnitOfMeasure           as _PurchaseOrderQuantityUnit on  $projection.PurchaseOrderQuantityUnit = _PurchaseOrderQuantityUnit.UnitOfMeasure
  association [0..1] to I_Currency                as _Currency                  on  $projection.Currency = _Currency.Currency

  
{
    
      @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key PurchasingDocument                                 as PurchaseOrder,
      @ObjectModel.foreignKey.association: '_PurchaseOrderItem'
  key PurchasingDocumentItem                             as PurchaseOrderItem,

  key ScheduleLine                                       as ScheduleLine,

     ScheduleLineDeliveryDate ,

      SchedLineStscDeliveryDate,

      PerformancePeriodStartDate,

      PerformancePeriodEndDate,

      ScheduleLineDeliveryTime,
      PurchasingDocument,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      @DefaultAggregation: #SUM
      ScheduleLineOrderQuantity,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      @DefaultAggregation: #SUM
      RoughGoodsReceiptQty,

      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      @DefaultAggregation: #SUM
      (ScheduleLineOrderQuantity - RoughGoodsReceiptQty) as OpenPurchaseOrderQuantity,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_PurchaseOrderQuantityUnit'
      _PurchaseOrderItem.PurchaseOrderQuantityUnit       as PurchaseOrderQuantityUnit,

      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_Currency'
      _PurchaseOrderItem.DocumentCurrency                as Currency,

      @DefaultAggregation: #SUM
      cast(
      case when _PurchaseOrderItem.OrderQuantity != 0  
             then (  ScheduleLineOrderQuantity - RoughGoodsReceiptQty) *
              DIVISION( _PurchaseOrderItem.NetAmount , _PurchaseOrderItem.OrderQuantity, 3 )
           else   0 end
      as abap.curr( 21, 3 ))                             as OpenPurchaseOrderNetAmount,

      I_PurgDocScheduleLine.PurchaseRequisition,

      I_PurgDocScheduleLine.PurchaseRequisitionItem,

      _PurchaseOrder,
      _PurchaseOrderItem,
      _PurchaseOrderQuantityUnit,
      _Currency

      
      
}
where _PurchaseOrder.PurchasingDocumentDeletionCode != 'X'

Learn More