I_EmployOrgDet

DDL: I_EMPLOYORGDET SQL: IEMPLOYORGDET Type: view BASIC
18 Fields 1 Data Sources

Employment organization details

I_EmployOrgDet is a Basic CDS View that provides data about "Employment organization details" in SAP S/4HANA. It reads from 1 data source (P_EmployOrgDet) and exposes 18 fields with key fields EmploymentInternalID, StartDate.

Data Sources (1)

SourceAliasJoin Type
P_EmployOrgDet P_EmployOrgDet from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IEMPLOYORGDET view
VDM.viewType #BASIC view
EndUserText.label Employment organization details view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID EmploymentInternalID WorkForce Assgmt ID
KEY StartDate StartDate Valid From
EndDate EndDate Term to
PersonnelNumber _Employment PersonnelNumber Personnel No.
IsMainEmployment _Employment IsMainEmployment
CompanyCode CompanyCode Receiver Company Code
CostCenter CostCenter Cost Center
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg Org.key
Job Job Undefined range (can be used for patch levels)
JobCode _JobCode Name Zone name
JobName JobName Name of Send Process
OrganizationalUnit OrganizationalUnit Org. Unit ID
OrganizationalUnitCode _OrgUnitCode Name Zone name
OrganizationalUnitName OrganizationalUnitName
_CompanyCode _CompanyCode
_CostCenter _CostCenter
_JobName _JobName
_OrganizationalUnitName _OrganizationalUnitName

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_EmployOrgDet.
-- 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: IEMPLOYORGDET

CREATE VIEW I_EmployOrgDet AS
SELECT
  EmploymentInternalID,
  StartDate,
  EndDate,
  _Employment.PersonnelNumber AS PersonnelNumber,
  _Employment.IsMainEmployment AS IsMainEmployment,
  CompanyCode,
  CostCenter,
  PersonWorkAgrmtAuthznGrpg,
  Job,
  _JobCode.Name AS JobCode,
  JobName,
  OrganizationalUnit,
  _OrgUnitCode.Name AS OrganizationalUnitCode,
  OrganizationalUnitName
FROM P_EmployOrgDet
;

Learn More