I_PERSONWORKAGRMTSTATUS

@AbapCatalog.sqlViewName: 'IPERWKAGRSTATUS'
@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
@AccessControl.privilegedAssociations: [ '_PersonWorkAgrmtStatusText' ]
@Analytics.dataExtraction.enabled: true
@Analytics.dataCategory: #DIMENSION
@EndUserText.label: 'Work Agreement Status'
@ObjectModel.representativeKey: 'PersonWorkAgreement'
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey:true
@Consumption.dbHints:['NO_JOIN_THRU_JOIN']
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #ANALYTICAL_DIMENSION,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]

define view I_PersonWorkAgrmtStatus
//  as select from P_PersonWorkAgrmtStatus

  as select from WFD_TF_PersonWorkAgrmtStatus(p_client:$session.client) as status
  association [0..*] to I_PersonWorkAgrmtStatusText as _PersonWorkAgrmtStatusText on _PersonWorkAgrmtStatusText.WorkAgreementStatus = $projection.WorkAgreementStatus
{
  key  PersonWorkAgreement,
       @Semantics.businessDate.from
  key  StartDate,
       @Semantics.businessDate.to
  key  EndDate,
       WorkAgreementStatus,
       PersonWorkAgrmtAuthznGrpg,
       _PersonWorkAgrmtStatusText
}

//define view I_PersonWorkAgrmtStatus

//  as select from P_PersonWorkAgrmtStatus

//{

//  key  PersonWorkAgreement,

//       @Semantics.businessDate.from

//  key  StartDate,

//       @Semantics.businessDate.to

//  key  EndDate,

//       WorkAgreementStatus,

//       PersonWorkAgrmtAuthznGrpg,

//       _PersonWorkAgrmtStatusText

//}

//


// as select

//   from pa0000 as PA0000

//    inner join pa0001 as PA0001 on pa0000.pernr = pa0001.pernr

//                                and pa0001.sprps <> 'X'

//                                and pa0000.endda between pa0001.begda and pa0001.endda

//    association [0..*] to I_PersonWorkAgrmtStatusText as _PersonWorkAgrmtStatusText on _PersonWorkAgrmtStatusText.WorkAgreementStatus = $projection.WorkAgreementStatus

//

//    {

//    key pa0000.pernr as PersonWorkAgreement,

//    @Semantics.businessDate.from

//    key pa0000.begda as StartDate,

//    @Semantics.businessDate.to

//    key pa0000.endda as EndDate,

//    case pa0000.stat2

//     when '3'

//     then

//         cast('1' as /shcm/employment_status )

//     else

//         cast('0' as /shcm/employment_status )

//    end as WorkAgreementStatus ,

//    pa0001.vdsk1 as PersonWorkAgrmtAuthznGrpg,

//    _PersonWorkAgrmtStatusText

//}

//where

// pa0000.sprps <> 'X'

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