P_ONRVB

DDL: P_ONRVB Type: view_entity BASIC Package: FINS_FIS_FICO

View for ONRVB

P_ONRVB is a Basic CDS View that provides data about "View for ONRVB" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentBasic, onrvb) and exposes 6 fields with key field objnr. Part of development package FINS_FIS_FICO.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic I_SalesDocumentBasic inner
onrvb onrvb from

Annotations (4)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY objnr onrvb objnr
vbeln onrvb vbeln
posnr onrvb posnr
kokrs I_SalesDocumentBasic ControllingArea
bukrs I_SalesDocumentBasic BillingCompanyCode
OBART 
 @AbapCatalog.entityBuffer.definitionAllowed: false
 @VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
define view entity 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 I_SalesDocumentBasic on onrvb.vbeln = I_SalesDocumentBasic.SalesDocument
{
key onrvb.objnr as objnr,
onrvb.vbeln     as vbeln,
onrvb.posnr     as posnr, 
I_SalesDocumentBasic.ControllingArea      as kokrs,
I_SalesDocumentBasic.BillingCompanyCode   as bukrs,
cast ( substring( onrvb.objnr, 1, 2) as j_obart preserving type ) as OBART 
}

Learn More