P_MaintOrderCompForDrctProcmt

DDL: P_MAINTORDERCOMPFORDRCTPROCMT SQL: PMTORDCOMPDRCTP Type: view BASIC

P_MaintOrderCompForDrctProcmt is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (resb, rsdb) and exposes 7 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderComponent.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
resb resb from
rsdb rsdb left_outer

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PMTORDCOMPDRCTP view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder resb aufnr
KEY MaintenanceOrderOperation resb vornr
KEY MaintenanceOrderComponent resb posnr
Reservation resb rsnum
ReservationItem resb rspos
PurchaseRequisition
PurchaseRequisitionItem 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PMTORDCOMPDRCTP' //must start with "P"

define view P_MaintOrderCompForDrctProcmt //must start with "P_"; same as DDL source name in upper-camelcase notation

   as select from resb
   left outer join rsdb on rsdb.rsnum = resb.rsnum and rsdb.rspos = resb.rspos and rsdb.rsart = resb.rsart and rsdb.banfn <> '' 

{
  key resb.aufnr as MaintenanceOrder,
  key resb.vornr as MaintenanceOrderOperation,
  key resb.posnr as MaintenanceOrderComponent,

  resb.rsnum as Reservation,
  resb.rspos as ReservationItem,
  
  coalesce( rsdb.banfn, resb.banfn ) as PurchaseRequisition,
  coalesce( rsdb.bnfpo, resb.bnfpo ) as PurchaseRequisitionItem
  
} where resb.xloek = '' -- where rsdb.rsart = ' ' and rsdb.banfn <> '' -- and rsdb.rsinz = '00'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RESB",
"RSDB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More