P_EmployOrgDetOp

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

@VDM.private: true
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view P_EmployOrgDetOp
  as select from    pa0001         as it0001

    inner join      P_EmploymentOp as Employment on it0001.pernr = Employment.EmploymentInternalID
    left outer join wfd_d_new_pers as switch     on switch.mandt = it0001.mandt

{
  key it0001.pernr as EmploymentInternalID,
      @Semantics.businessDate.from/to
  key it0001.begda as StartDate,
      @Semantics.businessDate.from/to
      it0001.endda as EndDate,
      Employment.PersonnelNumber,
      Employment.IsMainEmployment,
      it0001.bukrs as CompanyCode,
      it0001.kostl as CostCenter,
      it0001.stell as Job,
      it0001.orgeh as OrganizationalUnit,
      it0001.vdsk1 as PersonWorkAgrmtAuthznGrpg
}
where
  (
       switch.switch is null
    or switch.switch <> 'NEW'
  )

union all select from wfd_d_assgmtdets as assgmtdets
  inner join          P_EmploymentOp   as Employment on assgmtdets.workforce_assgmt_id = Employment.EmploymentInternalID
  inner join          wfd_d_new_pers   as switch     on switch.mandt = assgmtdets.client

{
  key assgmtdets.workforce_assgmt_id as EmploymentInternalId,
      @Semantics.businessDate.from/to
  key assgmtdets.start_date          as StartDate,
      @Semantics.businessDate.from/to
  key assgmtdets.end_date            as EndDate,
      Employment.PersonnelNumber,
      Employment.IsMainEmployment,
      assgmtdets.company_code        as CompanyCode,
      assgmtdets.cost_center         as CostCenter,
      assgmtdets.job_code            as Job,
      '00000000'                     as OrganizationalUnit,
      ''                             as PersonWorkAgrmtAuthznGrpg

}
where
  switch.switch = 'NEW'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_EMPLOYMENTOP",
"PA0001",
"WFD_D_ASSGMTDETS",
"WFD_D_NEW_PERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/