P_PROJMATCOMPONENT01

CDS View

Purchase Requisition & Purchase Order uniquely & merging

P_PROJMATCOMPONENT01 is a CDS View in S/4HANA. Purchase Requisition & Purchase Order uniquely & merging. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProjectMaterialComponent view left_outer BASIC Project Material Component Details

Fields (3)

KeyField CDS FieldsUsed in Views
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
PurchaseRequisitionItem PurchaseRequisitionItem 1 
@AbapCatalog.sqlViewName: 'PPROJMATCOMP01'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@VDM.private: true
define view P_Projmatcomponent01

  as select distinct from P_Projmatcomponent
  association [1..1] to P_Projmatcomponent as _Self on  $projection.Reservation     = _Self.Reservation
                                                    and $projection.ReservationItem = _Self.ReservationItem
                                                    and $projection.RecordType      = _Self.RecordType
                                                    and _Self.PurchaseOrder != ''

{
  key   Reservation,
  key   ReservationItem,
  key   RecordType,

        PurchaseRequisition,
        PurchaseRequisitionItem,
        _Self.PurchaseOrder     as PurchaseOrder,
        _Self.PurchaseOrderItem as PurchaseOrderItem
}
where
  PurchaseRequisition != ''

Learn More