P_Projmatcomponent

DDL: P_PROJMATCOMPONENT SQL: PPROJMATCOMP Type: view BASIC

P_Projmatcomponent is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (resb, resb, rsdb, rsdbs) and exposes 15 fields with key fields Reservation, ReservationItem, RecordType, IndexCounter, ReservationItem.

4 data source(s) 15 fields

Data Sources (4)

SourceAliasJoin Type
resb resb inner
resb resb inner
rsdb rsdb from
rsdbs rsdbs union_all

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPROJMATCOMP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Reservation rsdb rsnum
KEY ReservationItem rsdb rspos
KEY RecordType rsdb rsart
KEY IndexCounter rsdb rsinz
PurchaseRequisition rsdb banfn
PurchaseRequisitionItem rsdb bnfpo
PurchaseOrder rsdb ebeln
rsnumasReservation
KEY ReservationItem rsdbs rspos
KEY RecordType rsdbs rsart
KEY IndexCounter rsdbs rsinz
PurchaseRequisition rsdbs banfn
PurchaseRequisitionItem rsdbs bnfpo
PurchaseOrder rsdbs ebeln
PurchaseOrderItem rsdbs ebelp 
@AbapCatalog.sqlViewName: 'PPROJMATCOMP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@VDM.private: true
define view P_Projmatcomponent

  as select from rsdb
    inner join   resb on  rsdb.rsnum   = resb.rsnum
                      and rsdb.rspos   = resb.rspos
                      and rsdb.rsart   = resb.rsart
                      and resb.no_disp = ''
                      and (
                         resb.dbskz != ''
                         or resb.flgex != ''
                       )
{
  key rsdb.rsnum as Reservation,
  key rsdb.rspos as ReservationItem,
  key rsdb.rsart as RecordType,
  key rsdb.rsinz as IndexCounter,

      rsdb.banfn as PurchaseRequisition,
      rsdb.bnfpo as PurchaseRequisitionItem,
      rsdb.ebeln as PurchaseOrder,
      rsdb.ebelp as PurchaseOrderItem

}

union all

select from  rsdbs
  inner join resb on  rsdbs.rsnum  = resb.rsnum
                  and rsdbs.rspos  = resb.rspos
                  and rsdbs.rsart  = resb.rsart
                  and resb.no_disp = ''
                  and resb.flgex != ''
{
  key rsdbs.rsnum as Reservation,
  key rsdbs.rspos as ReservationItem,
  key rsdbs.rsart as RecordType,
  key rsdbs.rsinz as IndexCounter,

      rsdbs.banfn as PurchaseRequisition,
      rsdbs.bnfpo as PurchaseRequisitionItem,
      rsdbs.ebeln as PurchaseOrder,
      rsdbs.ebelp as PurchaseOrderItem

} 
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"RESB",
"RSDB",
"RSDBS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More