P_ONRSC

DDL: P_ONRSC Type: view_entity BASIC Package: FINS_FIS_FICO

View for ONRSC

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

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
onrsc onrsc from
P_AcctgServiceDocument P_AcctgServiceDocument inner

Annotations (4)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY objnr onrsc objnr
kokrs P_AcctgServiceDocument ControllingArea
bukrs P_AcctgServiceDocument CompanyCode
OBART 
 @AbapCatalog.entityBuffer.definitionAllowed: false
 @VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
define view entity P_ONRSC as select from onrsc 
//                inner join onr00 on  onrsc.objnr = onr00.objnr

                inner join P_AcctgServiceDocument on  onrsc.objnr  =  P_AcctgServiceDocument.ControllingObject                                                     
{
key onrsc.objnr              as objnr,
onrsc.service_doc_id         as service_doc_id,      
onrsc.service_doc_item_id    as service_doc_item_id,
P_AcctgServiceDocument.ServiceDocumentType  as service_doc_type,
P_AcctgServiceDocument.ControllingArea  as kokrs,
P_AcctgServiceDocument.CompanyCode      as bukrs,
cast ( substring( onrsc.objnr, 1, 2) as j_obart preserving type ) as OBART 
}

Learn More