P_ONRSC

DDL: P_ONRSC SQL: PFIONRSC Type: view BASIC

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

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
fco_srvdoc fco_srvdoc inner
onrsc onrsc from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIONRSC 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 (4)

KeyFieldSource TableSource FieldDescription
KEY objnr onrsc objnr
kokrs fco_srvdoc controlling_area
bukrs fco_srvdoc company_code
OBART 
@AbapCatalog.sqlViewName: 'PFIONRSC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
// @EndUserText.label: 'View for ONRSC'

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

define view P_ONRSC as select from onrsc 
//                inner join onr00 on  onrsc.objnr = onr00.objnr

                inner join fco_srvdoc on  onrsc.objnr  =  fco_srvdoc.objnr                                                     
{
key onrsc.objnr              as objnr,
onrsc.service_doc_id         as service_doc_id,      
onrsc.service_doc_item_id    as service_doc_item_id,
fco_srvdoc.service_doc_type  as service_doc_type,
fco_srvdoc.controlling_area  as kokrs,
fco_srvdoc.company_code      as bukrs,
cast ( SUBSTRING( onrsc.objnr, 1, 2) as j_obart) as OBART 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCO_SRVDOC",
"ONRSC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More