I_PersonWorkAgrmtToExternalID

@AbapCatalog.sqlViewName: 'IPERWKAGREXT'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataCategory: #DIMENSION
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.representativeKey: 'PersonWorkAgreement'
@EndUserText.label: 'Mapping between Work agrrement internal and External IDs'
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #ANALYTICAL_DIMENSION,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]

define view I_PersonWorkAgrmtToExternalID
//  as select from P_PersonWorkAgrmtToExternalID

    as select from WFD_TF_PersonWorkToExternalID( p_client : $session.client ) as external
    association [1] to I_CompanyCode as _CompanyCode on external.CompanyCode = _CompanyCode.CompanyCode
    
{
  key PersonWorkAgreement,
  @ObjectModel.foreignKey.association : '_CompanyCode'
  key CompanyCode,
      PersonWorkAgreementExternalID,
      //for DCL

      PersonWorkAgrmtAuthznGrpg,
      _CompanyCode

}

//define view I_PersonWorkAgrmtToExternalID

//  as select from P_PersonWorkAgrmtToExternalID

//{

//  key PersonWorkAgreement,

//  @ObjectModel.foreignKey.association : '_CompanyCode'

//  key CompanyCode,

//      PersonWorkAgreementExternalID,

//      //for DCL

//      PersonWorkAgrmtAuthznGrpg,

//      _CompanyCode

//

//}


  
//    as select distinct from pa0001                  as PA0001

//    inner join            pa0001                  as PA0001_ForAuthorization on  pa0001.pernr                  =  PA0001_ForAuthorization.pernr

//                                                                             and PA0001_ForAuthorization.endda =  '99991231'

//                                                                             and PA0001_ForAuthorization.sprps <> 'X'

//    left outer join       I_PersonWorkAgrmtToECId as PA0105                  on pa0001.pernr = PA0105.PersonWorkAgreement

//    association [1]    to I_CompanyCode            as _CompanyCode            on  pa0001.bukrs = _CompanyCode.CompanyCode

//

//{

//  key pa0001.pernr                      as PersonWorkAgreement,

//  @ObjectModel.foreignKey.association : '_CompanyCode'

//  key pa0001.bukrs                      as CompanyCode,

//      case when PA0105.PersonWorkAgreementExternalID is not null

//      then cast ( PA0105.PersonWorkAgreementExternalID as /shcm/workagreement_externalid )

//      else

//         cast( pa0001.pernr as /shcm/workagreement_externalid )

//      end                               as PersonWorkAgreementExternalID,

//      //for DCL

//      PA0001_ForAuthorization.vdsk1     as PersonWorkAgrmtAuthznGrpg,

//      _CompanyCode

//

//}

//where

//  pa0001.sprps <> 'X'

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[],
"ASSOCIATED":
[
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/