I_EmployeeLineManager

DDL: I_EMPLOYEELINEMANAGER SQL: ILINEMANAGER Type: view BASIC
4 Fields 1 Data Sources

Employee Line Manager

I_EmployeeLineManager is a Basic CDS View that provides data about "Employee Line Manager" in SAP S/4HANA. It reads from 1 data source (pa0001) and exposes 4 fields with key fields EmploymentInternalID, ValidityStartDate.

Data Sources (1)

SourceAliasJoin Type
pa0001 Employee from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ILINEMANAGER view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Employee Line Manager view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID pa0001 pernr Personnel no.
KEY ValidityStartDate pa0001 begda Valid From
ValidityEndDate pa0001 endda Valid To
ManagerPersonWorkAgreement pa0001 mstbr Supervisor

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_EmployeeLineManager.
-- 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: ILINEMANAGER

CREATE VIEW I_EmployeeLineManager AS
SELECT
  Employee.pernr AS EmploymentInternalID,
  Employee.begda AS ValidityStartDate,
  Employee.endda AS ValidityEndDate,
  Employee.mstbr AS ManagerPersonWorkAgreement
FROM pa0001 AS Employee
;

Learn More