P_ONRVB

DDL: P_ONRVB SQL: PFIONRVB Type: view BASIC

P_ONRVB is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (onrvb, vbak) and exposes 6 fields with key field objnr.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
onrvb onrvb from
vbak vbak inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIONRVB 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 (6)

KeyFieldSource TableSource FieldDescription
KEY objnr onrvb objnr
vbeln onrvb vbeln
posnr onrvb posnr
kokrs vbak kokrs
bukrs vbak bukrs_vf
OBART 
@AbapCatalog.sqlViewName: 'PFIONRVB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
// @EndUserText.label: 'View for ONRVB'

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

define view P_ONRVB as select from onrvb 
//  inner join onr00 on  onrvb.objnr = onr00.objnr

//  left outer join vbak on onrvb.vbeln = vbak.vbeln

    inner join vbak on onrvb.vbeln = vbak.vbeln
{
key onrvb.objnr as objnr,
onrvb.vbeln     as vbeln,
onrvb.posnr     as posnr, 
vbak.kokrs      as kokrs,
vbak.bukrs_vf   as bukrs,
cast ( SUBSTRING( onrvb.objnr, 1, 2) as j_obart) as OBART 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ONRVB",
"VBAK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More