P_POScheduleLineforReturnDel

DDL: P_POSCHEDULELINEFORRETURNDEL SQL: PPOSCHDLINE Type: view CONSUMPTION Package: VDM_MM_PUR_PR

PO Schedule Line for Ret. Delivery

P_POScheduleLineforReturnDel is a Consumption CDS View that provides data about "PO Schedule Line for Ret. Delivery" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderScheduleLine) and exposes 7 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. It has 2 associations to related views. Part of development package VDM_MM_PUR_PR.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderScheduleLine PurchOrdSch from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPOSCHDLINE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label PO Schedule Line for Ret. Delivery view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderScheduleLine PurchaseOrder
KEY PurchaseOrderItem I_PurchaseOrderScheduleLine PurchaseOrderItem
KEY ScheduleLine I_PurchaseOrderScheduleLine ScheduleLine
PurchaseOrderQuantityUnit I_PurchaseOrderScheduleLine PurchaseOrderQuantityUnit
RoughGoodsReceiptQty I_PurchaseOrderScheduleLine RoughGoodsReceiptQty
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem 
@AbapCatalog.sqlViewName: 'PPOSCHDLINE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private : true
@EndUserText.label: 'PO Schedule Line for Ret. Delivery'
define view P_POScheduleLineforReturnDel as select from I_PurchaseOrderScheduleLine as PurchOrdSch

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
 {
  key PurchOrdSch.PurchaseOrder,
  key PurchOrdSch.PurchaseOrderItem,
  key PurchOrdSch.ScheduleLine,  
  PurchOrdSch.PurchaseOrderQuantityUnit,
  PurchOrdSch.RoughGoodsReceiptQty,
  _PurchaseOrder,
  _PurchaseOrderItem
  
}
where PurchOrdSch.RoughGoodsReceiptQty > 0

Learn More