A_BPEmployment

DDL: A_BPEMPLOYMENT SQL: ABPEMPLOYMENT Type: view BASIC
9 Fields 1 Data Sources 2 Associations

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.

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 Issuing Authority
KEY BPEmploymentStartDate BPEmploymentStartDate Start
BPEmploymentEndDate BPEmploymentEndDate End
BPEmploymentStatus BPEmploymentStatus Employment Status
BusPartEmplrIndstryCode BusPartEmplrIndstryCode Industry
BusinessPartnerEmployerName BusinessPartnerEmployerName Employer
BusinessPartnerOccupationGroup BusinessPartnerOccupationGroup Occupation
_BPFinancialServicesExtn _BPFinancialServicesExtn
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_BPEmployment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ABPEMPLOYMENT

CREATE VIEW A_BPEmployment AS
SELECT
  BusinessPartner,
  BPEmploymentStartDate,
  BPEmploymentEndDate,
  BPEmploymentStatus,
  BusPartEmplrIndstryCode,
  BusinessPartnerEmployerName,
  BusinessPartnerOccupationGroup
FROM I_BPEmployment
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN A_BPFinancialServicesExtn AS _BPFinancialServicesExtn ON BusinessPartner = _BPFinancialServicesExtn.BusinessPartner  -- association [0..1]
;

Learn More