I_GB_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_GB_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_GB_HCM_ESSBankDataTP AS
SELECT
  HCMPersonnelNumber,
  HCMSubtype,
  HCMObjectIdentification,
  HCMRecordIsLocked,
  EndDate,
  StartDate,
  HCMSequentialNumber,
  HCMDraftSequentialNumber,
  LastChangedDate,
  LastChangedByUser,
  HCMInfoTypeRecordHasText,
  HCMInfoTypeRecordScreenCtrl,
  HCMSubtypeText,
  HCMETag,
  HCMValidityStartDate,
  HCMValidityEndDate,
  HCMDefaultDate,
  HCMRecordIsStoredInDataBase,
  HCMValidityStartDateFieldCtrl,
  _BankDataRoot.HCMInfoTypeVersion AS HCMInfoTypeVersion,
  _BankDataRoot.HCMCountryRegionGrouping AS HCMCountryRegionGrouping,
  HCMBankDetailsType,
  HCMPayeeName,
  HCMPayeePostalCode,
  HCMPayeeCityName,
  HCMPayeeStreet,
  ReferenceBankDetails,
  BankCountry,
  BankNumber,
  cast (BankAccount as BT_HCMBankAccountNumber ) AS BankAccount,
  BankControlKey,
  PostOfficeBankAccount,
  PaymentMethod,
  cast ( _PaymentMethod.PaymentMethodName as text1 ) AS PaymentMethodName,
  HCMBankTransferPurposeText,
  Currency,
  cast (HCMBankDetailsSalaryPortionAmt as BT_HCMBkDetsSalaryPortionAmt ) AS HCMBankDetailsSalaryPortionAmt,
  HCMBankDetailsSalaryPortnPct,
  HCMPayrollType,
  HCMPayrollOffCycleID,
  HCMPayrollOffCyclePaymentDate,
  HCMPayrollOffCycleReason,
  SWIFTCode,
  HCMInternationalBankAcctNumber,
  _SubtypeVisibility.HCMBankDataSubtype0IsHidden AS HCMBankDataSubtype0IsHidden,
  _SubtypeVisibility.HCMBankDataSubtype1IsHidden AS HCMBankDataSubtype1IsHidden,
  _SubtypeVisibility.HCMBankDataSubtype2IsHidden AS HCMBankDataSubtype2IsHidden
FROM I_HCM_ESSBankData
LEFT OUTER JOIN I_HCM_ESSBankDataSubtypeVsblty AS _SubtypeVisibility ON HCMSubtype = _SubtypeVisibility.HCMSubtype  -- association [1]
LEFT OUTER JOIN I_CountryText AS _BankCountryText ON BankCountry = _BankCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_Bank_2 AS _BankText ON BankCountry = _BankText.BankCountry AND BankNumber = _BankText.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_HCM_ESSBankControlKeyVH AS _BankControlKeyText ON BankCountry = _BankControlKeyText.BankCountry AND BankControlKey = _BankControlKeyText.BankControlKey  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON BankCountry = _PaymentMethod.Country AND PaymentMethod = _PaymentMethod.PaymentMethod  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyText ON Currency = _CurrencyText.Currency  -- association [0..*]
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]
;