A_BPEmployment

DDL: A_BPEMPLOYMENT SQL: ABPEMPLOYMENT Type: view BASIC

Employment Overview

A_BPEmployment is a Basic CDS View that provides data about "Employment Overview" in SAP S/4HANA. It reads from 1 data source (I_BPEmployment) and exposes 9 fields with key fields BusinessPartner, BPEmploymentStartDate. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_BPEmployment I_BPEmployment from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] A_BPFinancialServicesExtn _BPFinancialServicesExtn $projection.BusinessPartner = _BPFinancialServicesExtn.BusinessPartner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ABPEMPLOYMENT view
EndUserText.label Employment Overview view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY BPEmploymentStartDate BPEmploymentStartDate
BPEmploymentEndDate BPEmploymentEndDate
BPEmploymentStatus BPEmploymentStatus
BusPartEmplrIndstryCode BusPartEmplrIndstryCode
BusinessPartnerEmployerName BusinessPartnerEmployerName
BusinessPartnerOccupationGroup BusinessPartnerOccupationGroup
_BPFinancialServicesExtn _BPFinancialServicesExtn
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'ABPEMPLOYMENT'
@EndUserText.label: 'Employment Overview'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #BASIC
@ObjectModel.usageType: {
   serviceQuality: #B,
   sizeCategory: #XL ,
   dataClass: #MASTER }
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_BPEmployment
  as select from I_BPEmployment
  association [1..1] to A_BusinessPartner  as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to A_BPFinancialServicesExtn  as _BPFinancialServicesExtn on $projection.BusinessPartner = _BPFinancialServicesExtn.BusinessPartner // <--- to inherit authorizations in DCL

{
  key BusinessPartner,
  key BPEmploymentStartDate,
      BPEmploymentEndDate,
      BPEmploymentStatus,
      BusPartEmplrIndstryCode,
      BusinessPartnerEmployerName,
      BusinessPartnerOccupationGroup,
      /* Associations */
      @Consumption.hidden:true
      _BPFinancialServicesExtn,
      @Consumption.hidden:true
      _BusinessPartner

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

Learn More