P_ONROR

DDL: P_ONROR SQL: PFIONROR Type: view BASIC

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

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
aufk aufk inner
onror onror from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIONROR 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 onror objnr
aufnr onror aufnr
kokrs aufk kokrs
bukrs aufk bukrs
autyp aufk autyp
OBART 
@AbapCatalog.sqlViewName: 'PFIONROR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
// @EndUserText.label: 'View for ONROR'

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

define view P_ONROR as select from onror 
//                inner join onr00 on  onror.objnr = onr00.objnr

//              left outer join aufk on  onror.aufnr = aufk.aufnr

                inner join aufk on  onror.aufnr = aufk.aufnr
{
key onror.objnr as objnr,
onror.aufnr     as aufnr,
aufk.kokrs      as kokrs,
aufk.bukrs      as bukrs,
aufk.autyp      as autyp,
cast ( SUBSTRING( onror.objnr, 1, 2) as j_obart) as OBART 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUFK",
"ONROR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More