P_RSHResourceAuthData

DDL: P_RSHRESOURCEAUTHDATA SQL: PRSHRESAUTHDATA Type: view COMPOSITE Package: RSH_CDS_RES

Resource Data like Cost Center assignnt

P_RSHResourceAuthData is a Composite CDS View that provides data about "Resource Data like Cost Center assignnt" in SAP S/4HANA. It reads from 4 data sources (I_BusinessPartner, I_PersonWorkAgrmtOrglDetails, P_RSHResourceWorkAgreement, I_PersonWorkAgreement_1) and exposes 8 fields with key field EmploymentInternalID. Part of development package RSH_CDS_RES.

4 data source(s) 8 fields

Data Sources (4)

SourceAliasJoin Type
I_BusinessPartner _BusinessPartner inner
I_PersonWorkAgrmtOrglDetails HCMDetails inner
P_RSHResourceWorkAgreement P_RSHResourceWorkAgreement from
I_PersonWorkAgreement_1 PersonWorkAgreement inner

Parameters (2)

NameTypeDefault
P_StartDate syst_datum
P_EndDate syst_datum

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PRSHRESAUTHDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID I_PersonWorkAgrmtOrglDetails PersonWorkAgreement
Person I_PersonWorkAgreement_1 Person
StartDate I_PersonWorkAgrmtOrglDetails StartDate
EndDate I_PersonWorkAgrmtOrglDetails EndDate
CompanyCode I_PersonWorkAgrmtOrglDetails CompanyCode
CostCenter I_PersonWorkAgrmtOrglDetails CostCenter
AuthorizationGroup I_PersonWorkAgreement_1 AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 
@AbapCatalog.sqlViewName: 'PRSHRESAUTHDATA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.private: true
@VDM.viewType:  #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
/*
CONTRACT**********************************************************************************************************************

Name:                       ResourceData aka the new EmploymentDetailsCurrent
Specification:              This view returns the First WorkAgreement / Employment for a given Time Period.
Requires:                   Parameters Start and EndDate
Ensures:                    First WorkAgreement TimeSlice overlapping with Parameters Start & End is returned
Owners:                     SY
Contributors:               SY
Unit Test required Y/N:     Yes
Additional comments         None

END OF CONTRACT***************************************************************************************************************
*/

define view P_RSHResourceAuthData  
  with parameters
    P_StartDate : syst_datum,
    P_EndDate   : syst_datum
        
    as select from P_RSHResourceWorkAgreement ( P_StartDate: $parameters.P_StartDate, P_EndDate: $parameters.P_EndDate) 
    inner join I_PersonWorkAgrmtOrglDetails as HCMDetails on HCMDetails.PersonWorkAgreement = P_RSHResourceWorkAgreement.PersonWorkAgreement and
                                                            HCMDetails.StartDate = P_RSHResourceWorkAgreement.StartDate
    inner join I_PersonWorkAgreement_1 as PersonWorkAgreement on PersonWorkAgreement.PersonWorkAgreement = P_RSHResourceWorkAgreement.PersonWorkAgreement
   
    inner join I_BusinessPartner         as _BusinessPartner            on PersonWorkAgreement.Person = _BusinessPartner.BusinessPartner
{
    
    //I_PersonWorkAgrmtOrglDetails 

    key HCMDetails.PersonWorkAgreement as EmploymentInternalID, 
    PersonWorkAgreement.Person,
    HCMDetails.StartDate, 
    HCMDetails.EndDate, 
    HCMDetails.CompanyCode, 
    HCMDetails.CostCenter,
    PersonWorkAgreement.AuthorizationGroup,
    IsBusinessPurposeCompleted   
}

Learn More