I_MakeBkTransfWithFilter

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_MakeBkTransfWithFilter.
-- 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.
-- SQL view name: IMBKTWITHFILTER

CREATE VIEW I_MakeBkTransfWithFilter AS
SELECT
  cast(payrq.keyno as farp_prq_keyno) AS PaymentRequest,
  payrq.zbukr AS PayingCompanyCode,
  cast(payrq.bukrs as fis_bukrs) AS CompanyCode,
  cast(payrq.belnr as farp_belnr_d) AS AccountingDocument,
  cast(payrq.gjahr as fis_gjahr) AS FiscalYear,
  cast(payrq.buzei as fis_buzei) AS AccountingDocumentItem,
  cast(payrq.znme1 as farp_dznme1) AS PayeeName,
  cast(payrq.zbnks as farp_dzbnks) AS PayeeBankCountry,
  cast(payrq.zbkon as farp_bnk_com_dzbkon) AS PayeeBankControlKey,
  cast(payrq.zbnkl as farp_bnk_com_dzbnkl) AS PayeeBank,
  cast(payrq.zbnky as farp_bnk_com_dzbnky) AS PayeeBankInternalID,
  cast(payrq.zbnkn as fclm_bam_acc_num) AS PayeeBankAccount,
  cast( coalesce(_RepetitiveCode.PayeeHouseBank,substring( rfttrn, 11, 5 )) as fclm_bam_aclink_hktid ) AS PayeeHouseBank,
  cast( coalesce(_RepetitiveCode.PayeeHouseBankAccount,substring( rfttrn, 16, 5 )) as farp_hktid ) AS PayeeHouseBankAccount,
  coalesce(_RepetitiveCode.PayeeCompanyCode,coalesce(payrqp.bukrs,payrq.bukrs)) AS PayeeCompanyCode,
  cast(payrq.bkref as farp_prq_bkref) AS BankDetailReference,
  cast(payrq.crval as farp_prq_crval) AS PayeeBankValueDate,
  cast(payrq.valut as farp_prq_valdt) AS ValueDate,
  cast(payrq.koinh as bu_koinh) AS BankAccountHolderName,
  payrq.gsber AS BusinessArea,
  cast(payrq.sgtxt as farp_reftxt) AS ReferenceTypeText,
  payrq.hbkid AS HouseBank,
  payrq.hktid AS HouseBankAccount,
  cast(payrq.pacur as fqm_currency) AS PaymentRequestCurrency,
  cast(payrq.pamtf as farp_prq_amtfc) AS PaymentRequestAmountInPaytCrcy,
  payrq.pamtl AS PaymentRequestAmountInCCCrcy,
  payrq.hwaer AS CompanyCodeCurrency,
  payrq.uzawe AS PaymentMethodSupplement,
  payrq.zwels AS PaymentMethod,
  cast(payrq.xpore as farp_prq_xpore) AS IsSinglePayment,
  payrq.kidno AS PaymentReference,
  cast(payrq.koart as farp_koart) AS FinancialAccountType,
  payrq.hkont AS GLAccount,
  cast(payrq.usnam as vdm_createdbyuserid) AS CreatedByUser,
  cast(payrq.xreld as farp_prq_xreld) AS PaytReqIsReleasedForPosting,
  cast(payrq.xreli as farp_prq_xreli) AS PaytReqIsCompleted,
  cast(payrq.xrelp as farp_prq_xrelp) AS PaytReqIsReleasedForPayment,
  cast(payrq.xreve as farp_prq_xreve) AS IsReversed,
  payrq.stgrd AS ReversalReason,
  cast(payrq.dtaws as farp_bnk_com_dtaws) AS DataExchangeInstructionKey,
  cast(payrq.dtws1 as num2) AS DataExchangeInstruction1,
  cast(payrq.dtws2 as num2) AS DataExchangeInstruction2,
  cast(payrq.dtws3 as num2) AS DataExchangeInstruction3,
  cast(payrq.dtws4 as num2) AS DataExchangeInstruction4,
  cast(payrq.post_date as farp_prq_postdate) AS PaymentRequestPostingDate,
  payrq.ubnks AS BankCountry,
  payrq.ubnky AS BankInternalID,
  payrq.land1 AS SupplierCountry,
  payrq.landl AS SupplyingCountry,
  cast(payrq.origin as farp_fibl_origin) AS PaymentRequestOrigin,
  cast(payrq.lzbkz as farp_prq_lzbkz) AS StateCentralBankPaymentReason,
  cast(payrq.cpudt as farp_cpudt) AS AccountingDocumentCreationDate,
  cast('000000' as ttet_dt_cr_time) AS CreationTime,
  stcd1 AS TaxID1,
  cast(payrq.bvtyp as farp_bnk_com_bvtyp) AS BPBankAccountInternalID,
  payrq.zanre AS PayeeTitle,
  payrq.zpstl AS PayeePostalCode,
  payrq.zpfac AS PayeePOBox,
  payrq.pstl2 AS POBoxPostalCode,
  cast(payrq.znme2 as farp_dznme2) AS PayeeAdditionalName2,
  cast(payrq.znme3 as farp_dznme3) AS PayeeAdditionalName3,
  cast(payrq.znme4 as farp_dznme4) AS PayeeAdditionalName4,
  cast(payrq.zort1 as farp_dzort1) AS PayeeCityName,
  cast(payrq.zstra as farp_dzstra) AS PayeeStreet,
  cast(payrq.zland as farp_dzland) AS PayeeCountry,
  cast(payrq.zregi as farp_prq_dzregi) AS PayeeRegion,
  cast(payrq.zspra as farp_prq_dzspra) AS PayeeLanguage,
  cast(payrq.ztlfx as farp_telfx) AS PayeeFaxNumber,
  cast(payrq.ztelf as farp_telf1) AS PayeeTelephoneNumber,
  payrq.ziban AS PayeeIBAN,
  payrq.augdt AS ClearingDate,
  payrq.rfttrn AS RepetitiveCode,
  cast( payrq.sname4 as apl_log_handle ) AS LogHandle,
  _PaymentMethod.PaymentMethodName AS PaymentMethodName
FROM payrq
LEFT OUTER JOIN payrqp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RepetitiveCode AS _RepetitiveCode ON RepetitiveCode = _RepetitiveCode.RepetitiveCode AND PayingCompanyCode = _RepetitiveCode.PayingCompanyCode AND HouseBank = _RepetitiveCode.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PayingCompanyCode ON PayingCompanyCode = _PayingCompanyCode.CompanyCode  -- 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_AccountingDocument AS _PaymentDocument ON AccountingDocument = _PaymentDocument.AccountingDocument AND CompanyCode = _PaymentDocument.CompanyCode AND FiscalYear = _PaymentDocument.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _PaymentRequestCurrency ON PaymentRequestCurrency = _PaymentRequestCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PaytReqChgAndPostingData AS _PaytReqChangeAndPost ON PaymentRequest = _PaytReqChangeAndPost.PaymentRequest  -- association [1..1]
LEFT OUTER JOIN I_ReversalReason AS _ReversalReason ON ReversalReason = _ReversalReason.ReversalReason  -- association [1..1]
LEFT OUTER JOIN I_SystemStatusText AS _SystemStatusText ON StatusCode = _SystemStatusText.SystemStatus  -- association [1..*]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _AccountingDocItem ON CompanyCode = _AccountingDocItem.CompanyCode AND AccountingDocument = _AccountingDocItem.AccountingDocument AND FiscalYear = _AccountingDocItem.FiscalYear  -- association [1..*]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [0..1]
;