P_N_PERSWRKAGRMTMGRFORKEYDTE

CDS View

P_N_PERSWRKAGRMTMGRFORKEYDTE is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_U_PersWrkAgrmtMgrForKeyDte view union_all COMPOSITE 
@AbapCatalog.sqlViewName: 'PNPERWRKAGRMTMGR'
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AbapCatalog.preserveKey:true
//@Analytics.dataCategory: #DIMENSION

//@Metadata.allowExtensions: true

@ObjectModel.representativeKey: 'PersonWorkAgreement'
//@EndUserText.label: 'Retrieve manager for given date'

//@Metadata.ignorePropagatedAnnotations:true

define view P_N_PersWrkAgrmtMgrForKeyDte
  with parameters
    @Consumption.hidden     : true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : vdm_v_key_date
  as select from wfd_d_assgmtdets as dets

  association [1..1] to I_PersonWorkAgreement   as _ManagerPersonWorkAgreement   on _ManagerPersonWorkAgreement.PersonWorkAgreement = $projection.ManagerPersonWorkAgreement
  association [1..1] to I_PersonWorkAgreement_1 as _ManagerPersonWorkAgreement_1 on _ManagerPersonWorkAgreement_1.PersonWorkAgreement = $projection.ManagerPersonWorkAgreement

{
  key  dets.workforce_assgmt_id as PersonWorkAgreement,
  key  $parameters.P_KeyDate    as KeyDate,
  key  dets.manager_work_assgmt as ManagerPersonWorkAgreement,
       ''                       as PersonWorkAgrmtAuthznGrpg,
       @API.element.releaseState: #DEPRECATED
       @API.element.successor: '_ManagerPersonWorkAgreement_1'
       _ManagerPersonWorkAgreement,
       _ManagerPersonWorkAgreement_1
}
where
  (
        dets.start_date                 <= $parameters.P_KeyDate
    and dets.end_date                   >= $parameters.P_KeyDate
  )
  and(
        $projection.manager_work_assgmt is not null
  )
  and(
        $projection.manager_work_assgmt <> '00000000'
  )
  and   dets.block_ind                  =  ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WFD_D_ASSGMTDETS"
],
"ASSOCIATED":
[
"I_PERSONWORKAGREEMENT",
"I_PERSONWORKAGREEMENT_1"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More