I_EmplParentOrgManagerOP

DDL: I_EMPLPARENTORGMANAGEROP SQL: IEMPLPARORGMGROP Type: view BASIC
7 Fields 2 Data Sources

Employment Parent OrgUnit Manager for OnPremise

I_EmplParentOrgManagerOP is a Basic CDS View that provides data about "Employment Parent OrgUnit Manager for OnPremise" in SAP S/4HANA. It reads from 2 data sources (I_EmploymentManagerOP, hrp1001) and exposes 7 fields with key field ParentOrganizationalUnit.

Data Sources (2)

SourceAliasJoin Type
I_EmploymentManagerOP Manager left_outer
hrp1001 OrgUnit from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IEMPLPARORGMGROP view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Employment Parent OrgUnit Manager for OnPremise view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ParentOrganizationalUnit hrp1001 sobid ID rel.object
begdaasValidityStartDate
enddaasValidityEndDate
OrganizationalUnit hrp1001 objid Work Center
ManagerPersonWorkAgreement I_EmploymentManagerOP ManagerPersonWorkAgreement ID rel.object
StartDate I_EmploymentManagerOP StartDate Valid From
EndDate I_EmploymentManagerOP EndDate Term to

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_EmplParentOrgManagerOP.
-- 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: IEMPLPARORGMGROP

CREATE VIEW I_EmplParentOrgManagerOP AS
SELECT
  OrgUnit.sobid AS ParentOrganizationalUnit,
  /to key OrgUnit.begda as ValidityStartDate AS begdaasValidityStartDate,
  /to OrgUnit.endda as ValidityEndDate AS enddaasValidityEndDate,
  OrgUnit.objid AS OrganizationalUnit,
  Manager.ManagerPersonWorkAgreement AS ManagerPersonWorkAgreement,
  Manager.StartDate AS StartDate,
  Manager.EndDate AS EndDate
FROM hrp1001 AS OrgUnit
LEFT OUTER JOIN I_EmploymentManagerOP AS Manager ON /* join condition not captured in parsed metadata */
;

Learn More