I_HCM_ESSInternalData

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_HCM_ESSInternalData.
-- 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_HCM_ESSInternalData AS
SELECT
  InternalData.HCMPersonnelNumber AS HCMPersonnelNumber,
  InternalData.HCMSubtype AS HCMSubtype,
  InternalData.HCMObjectIdentification AS HCMObjectIdentification,
  InternalData.HCMRecordIsLocked AS HCMRecordIsLocked,
  InternalData.EndDate AS EndDate,
  InternalData.StartDate AS StartDate,
  InternalData.HCMSequentialNumber AS HCMSequentialNumber,
  cast( '000' as hrfio_per_draft_seq_number preserving type ) AS HCMDraftSequentialNumber,
  cast( '0032' as infty ) AS HCMInfoType,
  InternalData.LastChangedDate AS LastChangedDate,
  InternalData.LastChangedByUser AS LastChangedByUser,
  InternalData.HCMInfoTypeRecordIsHistorical AS HCMInfoTypeRecordIsHistorical,
  InternalData.HCMInfoTypeRecordHasText AS HCMInfoTypeRecordHasText,
  InternalData.HCMInfoTypeRecordHasRefField AS HCMInfoTypeRecordHasRefField,
  InternalData.HCMInfoTypeRecordHasConfField AS HCMInfoTypeRecordHasConfField,
  InternalData.HCMInfoTypeRecordScreenCtrl AS HCMInfoTypeRecordScreenCtrl,
  InternalData.HCMMasterDataChangeReason AS HCMMasterDataChangeReason,
  InternalData.HCMInfoTypeRecordRsrvdFld1 AS HCMInfoTypeRecordRsrvdFld1,
  InternalData.HCMInfoTypeRecordRsrvdFld2 AS HCMInfoTypeRecordRsrvdFld2,
  InternalData.HCMInfoTypeRecordRsrvdFld3 AS HCMInfoTypeRecordRsrvdFld3,
  InternalData.HCMInfoTypeRecordRsrvdFld4 AS HCMInfoTypeRecordRsrvdFld4,
  InternalData.HCMInfoTypeRecordRsrvdFld1Len2 AS HCMInfoTypeRecordRsrvdFld1Len2,
  InternalData.HCMInfoTypeRecordRsrvdFld2Len2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  InternalData.HCMGrpgValForPersAssignments AS HCMGrpgValForPersAssignments,
  _Customizing.StartDate AS HCMDefaultDate,
  cast(InternalData.StartDate as hrfio_per_valid_from preserving type ) AS HCMValidityStartDate,
  InternalData.EndDate AS HCMValidityEndDate,
  cast( 'X' as abap_boolean preserving type ) AS HCMRecordIsStoredInDataBase,
  cast( '1' as abap.int1 ) AS HCMValidityStartDateFieldCtrl,
  InternalData.HCMPreviousPersonnelNumber AS HCMPreviousPersonnelNumber,
  InternalData.HCMEmployeeBadgeID AS HCMEmployeeBadgeID,
  InternalData.HCMCompanyCarRule AS HCMCompanyCarRule,
  InternalData.HCMCompanyCarAmount AS HCMCompanyCarAmount,
  InternalData.HCMCompanyCarLicensePlate AS HCMCompanyCarLicensePlate,
  InternalData.Currency AS Currency,
  InternalData.HCMCompanyCarAssetNumber AS HCMCompanyCarAssetNumber,
  InternalData.HCMEmplWorkplaceBuildingNumber AS HCMEmplWorkplaceBuildingNumber,
  InternalData.HCMEmplWorkplaceRoomNumber AS HCMEmplWorkplaceRoomNumber,
  InternalData.HCMCountryRegionGrouping AS HCMCountryRegionGrouping,
  InternalData._Currency AS _Currency,
  InternalData._HCMCompanyCarRule AS _HCMCompanyCarRule
FROM I_HCMInternalData AS InternalData
LEFT OUTER JOIN I_HCMPersonalInfoPersNumbers AS _Contract ON HCMPersonnelNumber = _Contract.HCMPersonnelNumber  -- association [1..1]
;