P_ONRPD

DDL: P_ONRPD Type: view_entity BASIC Package: FINS_FIS_FICO

View for ONRPD

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

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_ProjectBasicData I_ProjectBasicData inner
onrpd onrpd from

Annotations (4)

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

Fields (5)

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

//     left outer join proj on  onrpd.pspnr = proj.pspnr

       inner join I_ProjectBasicData on  onrpd.pspnr = I_ProjectBasicData.ProjectInternalID
{
key onrpd.objnr as objnr,
onrpd.pspnr     as pspnr,
I_ProjectBasicData.ControllingArea  as kokrs,
I_ProjectBasicData.CompanyCode      as bukrs,
cast ( substring( onrpd.objnr, 1, 2) as j_obart preserving type ) as OBART 
}

Learn More