@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":""
}
}*/