P_EmpDetailsCurrent

DDL: P_EMPDETAILSCURRENT SQL: PEMPDETCUR Type: view CONSUMPTION
12 Fields 1 Data Sources

P_EmpDetailsCurrent is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_EmploymentDetailsCurrent) and exposes 12 fields with key fields EmploymentInternalID, StartDate.

Data Sources (1)

SourceAliasJoin Type
I_EmploymentDetailsCurrent EDC from

Annotations (4)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PEMPDETCUR view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID I_EmploymentDetailsCurrent EmploymentInternalID WorkForce Assgmt ID
KEY StartDate I_EmploymentDetailsCurrent StartDate Valid From
PersonnelNumber
IsMainEmployment
BusinessPartnerRole
EmploymentStatus
Job I_EmploymentDetailsCurrent Job Undefined range (can be used for patch levels)
JobName I_EmploymentDetailsCurrent JobName Name of Send Process
ServiceCostLevelName
ServiceCostLevelendasServiceCostLevel
CostLevel_fc
PersonWorkAgrmtAuthznGrpg I_EmploymentDetailsCurrent PersonWorkAgrmtAuthznGrpg Org.key

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 P_EmpDetailsCurrent.
-- 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: PEMPDETCUR

CREATE VIEW P_EmpDetailsCurrent AS
SELECT
  EDC.EmploymentInternalID AS EmploymentInternalID,
  EDC.StartDate AS StartDate,
  EDC._Employment.PersonnelNumber AS PersonnelNumber,
  EDC._Employment.IsMainEmployment AS IsMainEmployment,
  EDC._Employment._Employee.BusinessPartnerRole AS BusinessPartnerRole,
  EDC._EmploymentStatusText[1: Language = $session.system_language ].Name AS EmploymentStatus,
  EDC.Job AS Job,
  EDC.JobName AS JobName,
  EDC._ServiceCostLevel._CostLevelText[1: Language = $session.system_language ].ServiceCostLevelName AS ServiceCostLevelName,
  case EDC._ServiceCostLevel.ServiceCostLevel when '0000' then '' else EDC._ServiceCostLevel.ServiceCostLevel end as ServiceCostLevel AS ServiceCostLevelendasServiceCostLevel,
  cast( 0 as abap.int1) AS CostLevel_fc,
  EDC.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg
FROM I_EmploymentDetailsCurrent AS EDC
;

Learn More