P_ONRBP

DDL: P_ONRBP SQL: PFIONRBP Type: view BASIC

P_ONRBP is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (cbpr, onrbp) and exposes 5 fields with key field objnr.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
cbpr cbpr left_outer
onrbp onrbp from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIONRBP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY objnr onrbp objnr
kokrs onrbp kokrs
prznr onrbp prznr
bukrs cbpr bukrs
OBART 
@AbapCatalog.sqlViewName: 'PFIONRBP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
//@EndUserText.label: 'View for ONRBP'

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED

define view P_ONRBP as select from onrbp 
//          inner join onr00 on  onrbp.objnr = onr00.objnr

          left outer join cbpr on  onrbp.prznr = cbpr.prznr           //  ONRBP

                               and onrbp.kokrs = cbpr.kokrs   
                               and cbpr.datab <= $session.system_date
                               and cbpr.datbi >= $session.system_date    
{
key onrbp.objnr as objnr,
onrbp.kokrs     as kokrs,
onrbp.prznr     as prznr,
cbpr.bukrs      as bukrs,
cast ( SUBSTRING( onrbp.objnr, 1, 2) as j_obart) as OBART
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CBPR",
"ONRBP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More