P_N_EmployOrgDetOp

@AbapCatalog.sqlViewName: 'PNEMPLOYORGDETOP'
@VDM.viewType:  #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
//@EndUserText.label: 'Employment org details for onPremise'

@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
define view P_N_EmployOrgDetOp
  as select from wfd_d_assgmtdets       as assgmtdets
    inner join   wfd_d_keymap           as keymap         on keymap.workforce_assgmt_id = assgmtdets.workforce_assgmt_id
    inner join   P_N_EmploymentMinPernr as mainEmployment on mainEmployment.PersonnelNumber = keymap.business_partner_id


{
  key assgmtdets.workforce_assgmt_id as EmploymentInternalId,
      @Semantics.businessDate.from/to
  key assgmtdets.start_date          as StartDate,
      @Semantics.businessDate.from/to
      assgmtdets.end_date            as EndDate,
      keymap.central_person          as PersonnelNumber,
      case when assgmtdets.workforce_assgmt_id = mainEmployment.EmploymentInternalID
      then 'X'
      else ''
      end                            as IsMainEmployment,
      assgmtdets.company_code        as CompanyCode,
      assgmtdets.cost_center         as CostCenter,
      cast( assgmtdets.job_code    as abap.numc(8)   )      as Job,
      '00000000'                     as OrganizationalUnit,
      ''                             as PersonWorkAgrmtAuthznGrpg

}
where
      keymap.block_ind     = ''
  and assgmtdets.block_ind = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_N_EMPLOYMENTMINPERNR",
"WFD_D_ASSGMTDETS",
"WFD_D_KEYMAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/