I_EmployOrgDetOp

DDL: I_EMPLOYORGDETOP SQL: IEMPLOYORGDETOP Type: view BASIC
10 Fields 1 Data Sources

Employment org details for onPremise

I_EmployOrgDetOp is a Basic CDS View that provides data about "Employment org details for onPremise" in SAP S/4HANA. It reads from 1 data source (wfd_tf_EmployOrgDetOp) and exposes 10 fields with key fields EmploymentInternalID, StartDate.

Data Sources (1)

SourceAliasJoin Type
wfd_tf_EmployOrgDetOp wfd_tf_EmployOrgDetOp from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IEMPLOYORGDETOP view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Employment org details for onPremise view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID EmploymentInternalID WorkForce Assgmt ID
KEY StartDate StartDate Valid From
EndDate EndDate Term to
PersonnelNumber PersonnelNumber Personnel No.
IsMainEmployment IsMainEmployment
CompanyCode CompanyCode Receiver Company Code
CostCenter CostCenter Cost Center
Job Job Undefined range (can be used for patch levels)
OrganizationalUnit OrganizationalUnit Org. Unit ID
PersonWorkAgrmtAuthznGrpg 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 I_EmployOrgDetOp.
-- 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: IEMPLOYORGDETOP

CREATE VIEW I_EmployOrgDetOp AS
SELECT
  EmploymentInternalID,
  StartDate,
  EndDate,
  PersonnelNumber,
  IsMainEmployment,
  CompanyCode,
  CostCenter,
  Job,
  OrganizationalUnit,
  PersonWorkAgrmtAuthznGrpg
FROM wfd_tf_EmployOrgDetOp
;

Learn More