I_TR_HCM_ESSBankDataTP

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_TR_HCM_ESSBankDataTP.
-- 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_TR_HCM_ESSBankDataTP AS
SELECT
  I_HCM_ESSBANKDATA.HCMPersonnelNumber AS HCMPersonnelNumber,
  I_HCM_ESSBANKDATA.HCMSubtype AS HCMSubtype,
  I_HCM_ESSBANKDATA.HCMObjectIdentification AS HCMObjectIdentification,
  I_HCM_ESSBANKDATA.HCMRecordIsLocked AS HCMRecordIsLocked,
  I_HCM_ESSBANKDATA.EndDate AS EndDate,
  I_HCM_ESSBANKDATA.StartDate AS StartDate,
  I_HCM_ESSBANKDATA.HCMSequentialNumber AS HCMSequentialNumber,
  I_HCM_ESSBANKDATA.HCMDraftSequentialNumber AS HCMDraftSequentialNumber,
  I_HCM_ESSBANKDATA.LastChangedDate AS LastChangedDate,
  I_HCM_ESSBANKDATA.LastChangedByUser AS LastChangedByUser,
  I_HCM_ESSBANKDATA.HCMInfoTypeRecordHasText AS HCMInfoTypeRecordHasText,
  I_HCM_ESSBANKDATA.HCMInfoTypeRecordScreenCtrl AS HCMInfoTypeRecordScreenCtrl,
  I_HCM_ESSBANKDATA.HCMSubtypeText AS HCMSubtypeText,
  I_HCM_ESSBANKDATA.HCMETag AS HCMETag,
  I_HCM_ESSBANKDATA.HCMValidityStartDate AS HCMValidityStartDate,
  I_HCM_ESSBANKDATA.HCMValidityEndDate AS HCMValidityEndDate,
  I_HCM_ESSBANKDATA.HCMDefaultDate AS HCMDefaultDate,
  I_HCM_ESSBANKDATA.HCMRecordIsStoredInDataBase AS HCMRecordIsStoredInDataBase,
  I_HCM_ESSBANKDATA.HCMValidityStartDateFieldCtrl AS HCMValidityStartDateFieldCtrl,
  _BankDataRoot.HCMInfoTypeVersion AS HCMInfoTypeVersion,
  _BankDataRoot.HCMCountryRegionGrouping AS HCMCountryRegionGrouping,
  I_HCM_ESSBANKDATA._Contract AS _Contract
FROM I_HCM_ESSBANKDATA
LEFT OUTER JOIN I_HCM_ESSBankDataSubtypeVsblty AS _SubtypeVisibility ON HCMSubtype = _SubtypeVisibility.HCMSubtype  -- association [1]
LEFT OUTER JOIN E_HCMBankData AS _Extension ON HCMPersonnelNumber = _Extension.HCMPersonnelNumber AND HCMSubtype = _Extension.HCMSubtype AND HCMObjectIdentification = _Extension.HCMObjectIdentification AND HCMRecordIsLocked = _Extension.HCMRecordIsLocked AND EndDate = _Extension.EndDate AND StartDate = _Extension.StartDate AND HCMSequentialNumber = _Extension.HCMSequentialNumber  -- association [1]
;