P_PurReqnProcFlowASN

DDL: P_PURREQNPROCFLOWASN Type: view_entity COMPOSITE Package: ODATA_MM_PUR_REQ_MAINTAIN

Fetch ASN in Pur Reqn Process flow

P_PurReqnProcFlowASN is a Composite CDS View that provides data about "Fetch ASN in Pur Reqn Process flow" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderItem) and exposes 8 fields with key fields PrecedingDocument, PrecedingDocumentItem, SubsequentDocument, SubsequentDocumentItem. It has 1 association to related views. Part of development package ODATA_MM_PUR_REQ_MAINTAIN.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderItem _PurchaseOrderItem inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Purchaserequisitionitem _PurReqItem _PurchaseOrderItem.PurchaseRequisition = _PurReqItem.PurchaseRequisition and _PurchaseOrderItem.PurchaseRequisitionItem = _PurReqItem.PurchaseRequisitionItem

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
EndUserText.label Fetch ASN in Pur Reqn Process flow view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument _POSupConf PurchaseOrder
KEY PrecedingDocumentItem _POSupConf PurchaseOrderItem
KEY SubsequentDocument _POSupConf PurchaseOrder
KEY SubsequentDocumentItem _POSupConf PurchaseOrderItem
PrecedingDocumentCategory
SubsequentDocumentCategory
PurchaseRequisition _PurReqItem PurchaseRequisition
PurchaseRequisitionItem _PurReqItem PurchaseRequisitionItem 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'Fetch ASN in Pur Reqn Process flow'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity P_PurReqnProcFlowASN as  
select distinct from I_POSupplierConfirmationAPI01 as _POSupConf
           inner join R_PurchaseOrderItem as _PurchaseOrderItem
                   on _POSupConf.PurchaseOrder      = _PurchaseOrderItem.PurchaseOrder
                   and _POSupConf.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem
           association [1..1] to I_Purchaserequisitionitem as _PurReqItem
                on _PurchaseOrderItem.PurchaseRequisition      = _PurReqItem.PurchaseRequisition
                and _PurchaseOrderItem.PurchaseRequisitionItem = _PurReqItem.PurchaseRequisitionItem {

  key _POSupConf.PurchaseOrder                    as    PrecedingDocument,
  key _POSupConf.PurchaseOrderItem                as    PrecedingDocumentItem,
  
  key _POSupConf.PurchaseOrder                    as    SubsequentDocument,
  key _POSupConf.PurchaseOrderItem                as    SubsequentDocumentItem,
         
      cast( 'F'  as ebstyp)                       as    PrecedingDocumentCategory,
      cast( '4'  as ebstyp)                       as    SubsequentDocumentCategory,
      
      //For Filtering

     _PurReqItem.PurchaseRequisition,
     _PurReqItem.PurchaseRequisitionItem
      
}
where _POSupConf.SupplierConfirmationCategory = 'LA' and
      _PurReqItem.PurchasingDocumentItemCategory = '0' and
      _PurReqItem.ProductType = '1'
group by _POSupConf.PurchaseOrder,
         _POSupConf.PurchaseOrderItem,
         _PurReqItem.PurchaseRequisition,
         _PurReqItem.PurchaseRequisitionItem

Learn More