I_US_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_US_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_US_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.HCMBankDetailsType AS HCMBankDetailsType,
  I_HCM_ESSBankData.HCMPayeeName AS HCMPayeeName,
  I_HCM_ESSBankData.HCMPayeeStreet AS HCMPayeeStreet,
  I_HCM_ESSBankData.HCMPayeePostalCode AS HCMPayeePostalCode,
  I_HCM_ESSBankData.HCMPayeeCityName AS HCMPayeeCityName,
  I_HCM_ESSBankData.HCMPayeeRegion AS HCMPayeeRegion,
  I_HCM_ESSBankData.BankCountry AS BankCountry,
  I_HCM_ESSBankData.BankNumber AS BankNumber,
  I_HCM_ESSBankData.BankAccount AS BankAccount,
  I_HCM_ESSBankData.BankControlKey AS BankControlKey,
  I_HCM_ESSBankData.ReferenceBankDetails AS ReferenceBankDetails,
  I_HCM_ESSBankData.PaymentMethod AS PaymentMethod,
  cast ( _PaymentMethod.PaymentMethodName as text1 ) AS PaymentMethodName,
  I_HCM_ESSBankData.HCMBankTransferPurposeText AS HCMBankTransferPurposeText,
  I_HCM_ESSBankData.Currency AS Currency,
  cast (HCMBankDetailsSalaryPortionAmt as BT_HCMBkDetsSalaryPortionAmt ) AS HCMBankDetailsSalaryPortionAmt,
  I_HCM_ESSBankData.HCMBankDetailsSalaryPortnPct AS HCMBankDetailsSalaryPortnPct,
  I_HCM_ESSBankData.HCMPayrollOffCycleReason AS HCMPayrollOffCycleReason,
  I_HCM_ESSBankData.HCMPayrollType AS HCMPayrollType,
  I_HCM_ESSBankData.HCMPayrollOffCycleID AS HCMPayrollOffCycleID,
  I_HCM_ESSBankData.HCMPayrollOffCyclePaymentDate AS HCMPayrollOffCyclePaymentDate,
  I_HCM_ESSBankData.SWIFTCode AS SWIFTCode,
  I_HCM_ESSBankData.HCMInternationalBankAcctNumber AS HCMInternationalBankAcctNumber,
  I_HCM_ESSBankData.HCMPayeeCountryCode AS HCMPayeeCountryCode,
  _SubtypeVisibility.HCMBankDataSubtype0IsHidden AS HCMBankDataSubtype0IsHidden,
  _SubtypeVisibility.HCMBankDataSubtype1IsHidden AS HCMBankDataSubtype1IsHidden,
  _SubtypeVisibility.HCMBankDataSubtype2IsHidden AS HCMBankDataSubtype2IsHidden,
  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 I_RegionText AS _RegionText ON HCMPayeeCountryCode = _RegionText.Country AND HCMPayeeRegion = _RegionText.Region  -- association [0..*]
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_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 I_CountryText AS _PayeeCountryText ON HCMPayeeCountryCode = _PayeeCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_US_HCMBankControlKeyText AS _BankControlKeyText ON BankControlKey = _BankControlKeyText.DomainValueLow  -- 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]
;