I_HCMOrganizationalAssignment

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_HCMOrganizationalAssignment.
-- 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.

CREATE VIEW I_HCMOrganizationalAssignment AS
SELECT
  pernr AS HCMPersonnelNumber,
  subty AS HCMSubtype,
  objps AS HCMObjectIdentification,
  sprps AS HCMRecordIsLocked,
  endda AS EndDate,
  begda AS StartDate,
  seqnr AS HCMSequentialNumber,
  aedtm AS LastChangedDate,
  uname AS LastChangedByUser,
  histo AS HCMInfoTypeRecordIsHistorical,
  itxex AS HCMInfoTypeRecordHasText,
  refex AS HCMInfoTypeRecordHasRefField,
  ordex AS HCMInfoTypeRecordHasConfField,
  itbld AS HCMInfoTypeRecordScreenCtrl,
  preas AS HCMMasterDataChangeReason,
  flag1 AS HCMInfoTypeRecordRsrvdFld1,
  flag2 AS HCMInfoTypeRecordRsrvdFld2,
  flag3 AS HCMInfoTypeRecordRsrvdFld3,
  flag4 AS HCMInfoTypeRecordRsrvdFld4,
  rese1 AS HCMInfoTypeRecordRsrvdFld1Len2,
  rese2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  grpvl AS HCMGrpgValForPersAssignments,
  cast ( bukrs as bukrs preserving type ) AS CompanyCode,
  werks AS HCMPersonnelArea,
  persg AS HCMEmployeeGroup,
  persk AS HCMEmployeeSubgroup,
  vdsk1 AS HCMOrganizationalKey,
  gsber AS BusinessArea,
  btrtl AS HCMPersonnelSubarea,
  juper AS HCMLegalPerson,
  abkrs AS HCMPayrollArea,
  ansvh AS HCMWorkContract,
  kostl AS CostCenter,
  orgeh AS HCMOrganizationalUnit,
  plans AS HCMPosition,
  stell AS HCMJob,
  mstbr AS HCMSupervisorArea,
  sacha AS HCMPayrollAdministrator,
  sachp AS HCMMasterDataAdministrator,
  sachz AS HCMTimeRecordingAdministrator,
  sname AS HCMEmplNameFrmtLastAnd1stName,
  ename AS HCMEmployeeName,
  otype AS HCMObjectType,
  sbmod AS HCMAdministratorGroup,
  kokrs AS ControllingArea,
  fistl AS FundsCenter,
  geber AS Fund,
  fkber AS FunctionalArea,
  grant_nbr AS GrantID,
  sgmnt AS Segment,
  budget_pd AS BudgetPeriod
FROM pa0001
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HCMPersonnelArea AS _HCMPersonnelArea ON HCMPersonnelArea = _HCMPersonnelArea.HCMPersonnelArea  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployeeGroup AS _HCMEmployeeGroup ON HCMEmployeeGroup = _HCMEmployeeGroup.HCMEmployeeGroup  -- association [0..1]
LEFT OUTER JOIN I_HCMEmployeeSubgroup AS _HCMEmployeeSubGroup ON HCMEmployeeSubgroup = _HCMEmployeeSubGroup.HCMEmployeeSubgroup  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_HCMPersonnelSubarea AS _HCMPersonnelSubarea ON HCMPersonnelArea = _HCMPersonnelSubarea.HCMPersonnelArea AND HCMPersonnelSubarea = _HCMPersonnelSubarea.HCMPersonnelSubarea  -- association [0..1]
LEFT OUTER JOIN I_HCMPayrollArea AS _HCMPayrollArea ON HCMPayrollArea = _HCMPayrollArea.HCMPayrollArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter AND StartDate <= _CostCenter.ValidityEndDate AND StartDate >= _CostCenter.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_HCMObjectType AS _HCMObjectType ON HCMObjectType = _HCMObjectType.HCMObjectType  -- association [0..1]
LEFT OUTER JOIN I_HCMOrganizationalUnit AS _HCMOrganizationalUnit ON HCMOrganizationalUnit = _HCMOrganizationalUnit.HCMOrganizationalUnit AND StartDate <= _HCMOrganizationalUnit.EndDate AND StartDate >= _HCMOrganizationalUnit.StartDate  -- association [0..1]
LEFT OUTER JOIN I_HCMPosition AS _HCMPosition ON HCMPosition = _HCMPosition.HCMPosition AND _HCMPosition.HCMObjectType = 'S' AND StartDate <= _HCMPosition.EndDate AND StartDate >= _HCMPosition.StartDate  -- association [0..1]
LEFT OUTER JOIN I_HCMJob AS _HCMJob ON HCMJob = _HCMJob.HCMJob AND StartDate <= _HCMJob.EndDate AND StartDate >= _HCMJob.StartDate  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON Fund = _Fund.Fund AND _Fund.FinancialManagementArea is not null  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FundsCenter = _FundsCenter.FundsCenter AND _FundsCenter.FinancialManagementArea is not null  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
;