P_Empfactsheet_Contrinfo

DDL: P_EMPFACTSHEET_CONTRINFO SQL: PEMPFSCI Type: view CONSUMPTION Package: VDM_SHCM_EMPLOYEE
15 Fields

Employee Factsheet CDS - Controlling Information

P_Empfactsheet_Contrinfo is a Consumption CDS View that provides data about "Employee Factsheet CDS - Controlling Information" in SAP S/4HANA. Part of development package VDM_SHCM_EMPLOYEE.

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName PEMPFSCI view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Employee Factsheet CDS - Controlling Information view
Search.searchable false view
UI.headerInfo.typeName Controlling Information view
UI.headerInfo.typeName_AsOTR 005056AC156F1ED5A4FFE86A407743ED view
UI.headerInfo.typeNamePlural Controlling Information view
UI.headerInfo.typeNamePlural_AsOTR 005056AC156F1ED5A4FFE86A407743ED view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value ServiceCostLevelName view
UI.headerInfo.description.value ServiceCostLevel view
UI.badge.headLine.type #STANDARD view
UI.badge.headLine.value ServiceCostLevelName view
UI.badge.title.type #STANDARD view
UI.badge.title.value ServiceCostLevelName view
UI.badge.mainInfo.type #STANDARD view
UI.badge.mainInfo.value ServiceCostLevel view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID EDC EmploymentInternalID WorkForce Assgmt ID
KEY StartDate EDC StartDate Valid From
KEY ValidityStartDate
KEY ValidityEndDate
PersonnelNumber
IsMainEmployment
BusinessPartnerRole
EmploymentStatus
JobCode EDC JobCode Job Code
JobName EDC JobName Name of Send Process
ServiceCostLevelName
ServiceCostLevelendasServiceCostLevel Service Cost Level
CostLevel_fc
LastChangedByUserFullName User Name
LastChangeDate Last Changed Date

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_Empfactsheet_Contrinfo.
-- 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: PEMPFSCI

CREATE VIEW P_Empfactsheet_Contrinfo AS
SELECT
  EDC.EmploymentInternalID AS EmploymentInternalID,
  EDC.StartDate AS StartDate,
  EDC._ServiceCostLevel.StartDate AS ValidityStartDate,
  EDC._ServiceCostLevel.EndDate AS ValidityEndDate,
  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.JobCode AS JobCode,
  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,
  LPAD('',80,'x') AS LastChangedByUserFullName,
  cast ( LPAD('',8,'x') as abap.dats ) AS LastChangeDate
;

Learn More