I_EmployeePositionOP

DDL: I_EMPLOYEEPOSITIONOP SQL: IEMPPOSOP Type: view BASIC
10 Fields 4 Data Sources

Employee Position for OnPremise

I_EmployeePositionOP is a Basic CDS View that provides data about "Employee Position for OnPremise" in SAP S/4HANA. It reads from 4 data sources (I_Employee, hrp1001, hrp1001, P_PDRELATION) and exposes 10 fields with key field EmploymentInternalID.

Data Sources (4)

SourceAliasJoin Type
I_Employee Employee inner
hrp1001 EmployeeRelation from
hrp1001 PositionRelation left_outer
P_PDRELATION relat inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEMPPOSOP view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Employee Position for OnPremise view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID P_PDRELATION ObjectID Object Value
begdaasValidityStartDate
enddaasValidityEndDate
PersonnelNumber I_Employee PersonnelNumber Personnel No.
Employee I_Employee Employee Object ID
FullName I_Employee FullName Name
OrganizationalUnit hrp1001 objid Work Center
StartDate hrp1001 begda Valid From
EndDate hrp1001 endda Valid To
Appointment hrp1001 objid Work Center

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 I_EmployeePositionOP.
-- 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: IEMPPOSOP

CREATE VIEW I_EmployeePositionOP AS
SELECT
  relat.ObjectID AS EmploymentInternalID,
  /to EmployeeRelation.begda as ValidityStartDate AS begdaasValidityStartDate,
  /to EmployeeRelation.endda as ValidityEndDate AS enddaasValidityEndDate,
  Employee.PersonnelNumber AS PersonnelNumber,
  Employee.Employee AS Employee,
  Employee.FullName AS FullName,
  PositionRelation.objid AS OrganizationalUnit,
  PositionRelation.begda AS StartDate,
  PositionRelation.endda AS EndDate,
  EmployeeRelation.objid AS Appointment
FROM hrp1001 AS EmployeeRelation
INNER JOIN P_PDRELATION AS relat ON /* join condition not captured in parsed metadata */
INNER JOIN I_Employee AS Employee ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1001 AS PositionRelation ON /* join condition not captured in parsed metadata */
;

Learn More