farvd_bs_it_01

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 farvd_bs_it_01.
-- 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 farvd_bs_it_01 AS
SELECT
  _TransactionType( language: $session.system_language ).text AS PaymentTransactionCategoryName,
  case when _AttachmentKey.reltype = 'ATTA' then 'X' else ' ' end as HasAttachment AS reltypeATTAthenXelseendasHasAttachment,
  case when _AttachmentKey.reltype = 'NOTE' then 'X' else ' ' end as HasNote AS reltypeNOTEthenXelseendasHasNote,
  case when farvd_bs_it_02.svavs = '' and farvd_bs_it_02.n2pch = '' then '' else case when ( farvd_bs_it_02.BankStatementTwoStepPostgRule is initial and ( farvd_bs_it_02.ReprocgRulePostgProcedureType <> '002' or farvd_bs_it_02.ReprocgRulePostgProcedureType is initial ) ) and farvd_bs_it_02.vb1ok = '' or ( farvd_bs_it_02.BankStatementTwoStepPostgRule is not initial or ( farvd_bs_it_02.ReprocgRulePostgProcedureType = '002' ) ) and farvd_bs_it_02.vb2ok = '' then 'X' else '' end end as IsInProcess AS vb2okthenXelseendendasIsInProcess,
  cast ( farvd_bs_it_02.curr_rate as fac_kursf_ext ) AS ExchangeRate,
  case farvd_bs_it_02.vgext when '' then farvd_bs_it_02.vorgc else farvd_bs_it_02.vgext end as PaymentExternalTransacType AS vgextendasPaymentExternalTransacType,
  case when farvd_bs_it_02.anwnd = '0003' then farvd_bs_it_02.chect else case when farvd_bs_it_02.chect_type = 'C' then farvd_bs_it_02.chect else '' end end as Cheque AS chectelseendendasCheque,
  case when farvd_bs_it_02.chect_type = 'D' then farvd_bs_it_02.chect else '' end as PaymentMediumReference AS chectelseendasPaymentMediumReference,
  case when farvd_bs_it_02.chect_orig = '' and farvd_bs_it_02.anwnd = '0001' then farvd_bs_it_02.chect else farvd_bs_it_02.chect_orig end as CustomerReferenceNumber AS chect_origendasCustomerReferenceNumber,
  '' AS BankStatementItemLifeCycSts,
  cast (farvd_bs_it_02.kursf as fac_kursf_ext ) AS AccountingExchangeRate,
  cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
  '' AS NumberPostingSteps,
  cast ( case when farvd_bs_it_02.avkoa = 'K' then farvd_bs_it_02.avkon else '' end as lifnr ) as Supplier AS avkonelseendaslifnrasSupplier,
  cast( _SupplierCompany._Supplier.SupplierName as md_supplier_name preserving type ) AS SupplierName,
  cast ( case when farvd_bs_it_02.avkoa = 'D' then farvd_bs_it_02.avkon else '' end as kunnr ) as Customer AS avkonelseendaskunnrasCustomer,
  cast( _CustomerCompany._Customer.CustomerName as md_customer_name preserving type ) AS CustomerName,
  cast ( case when farvd_bs_it_02.avkoa = 'S' then farvd_bs_it_02.avkon else '' end as farp_hkont ) as GLAccount AS avkonelseendasfarp_hkontasGLAccount,
  cast ( farvd_bs_it_02.LockboxBatch as batch_eb ) AS LockboxBatch,
  cast ( farvd_bs_it_02.Lockbox as far_lbnum ) AS Lockbox,
  substring(farvd_bs_it_02.absnd, 1, 10 ) AS LockboxBatchDestination,
  substring(farvd_bs_it_02.absnd, 12, 10 ) AS LockboxBatchOrigin,
  case when farvd_bs_it_02.LatestPartialPayment <> '' then farvd_bs_it_02.LatestPartialPayment else case when ( farvd_bs_it_02.sdoc2 <> '' and farvd_bs_it_02.sdoc2 <> '-' ) or ( farvd_bs_it_02.vb1ok = 'X' and farvd_bs_it_02.vb2ok = 'X' and farvd_bs_it_02.estat = '3' ) then farvd_bs_it_02.nbbln else '' end end as LatestPartialPayment AS nbblnelseendendasLatestPartialPayment,
  farvd_bs_it_02.kukey AS BankStatementShortID,
  farvd_bs_it_02.esnum AS BankStatementItem,
  farvd_bs_it_02.absnd AS SendingBank,
  farvd_bs_it_02.bukrs AS CompanyCode,
  farvd_bs_it_02.hbkid AS HouseBank,
  farvd_bs_it_02.hktid AS HouseBankAccount,
  farvd_bs_it_02.aznum AS BankStatement,
  farvd_bs_it_02.azdat AS BankStatementDate,
  farvd_bs_it_02.astat AS BankStatementStatus,
  farvd_bs_it_02.waers AS Currency,
  farvd_bs_it_02.kwaer AS TransactionCurrency,
  farvd_bs_it_02.vb1ok AS BankLedgerIsPosted,
  farvd_bs_it_02.vb2ok AS SubledgerIsPostedSuccessfully,
  farvd_bs_it_02.eperl AS IsCompleted,
  farvd_bs_it_02.kwbtr AS AbsoluteAmountInTransacCrcy,
  farvd_bs_it_02.grpnr AS BankStatementItemGroup,
  farvd_bs_it_02.vgint AS BankStatementPostingRule,
  farvd_bs_it_02.vgint_text AS BankStatementPostingRuleName,
  farvd_bs_it_02.tatyp AS PaymentTransactionCategory,
  farvd_bs_it_02.intag AS InterpretationAlgorithm,
  farvd_bs_it_02.valut AS ValueDate,
  farvd_bs_it_02.avkoa AS PaymentAdviceAccountType,
  farvd_bs_it_02.avkon AS PaymentAdviceAccount,
  farvd_bs_it_02.n2pch AS MemoLineIsChanged,
  farvd_bs_it_02.MemoLine1 AS MemoLine1,
  farvd_bs_it_02.fwaer AS OriginalCurrency,
  farvd_bs_it_02.epvoz AS DebitCreditCode,
  farvd_bs_it_02.partn AS BusinessPartnerName,
  farvd_bs_it_02.avsid AS PaymentAdvice,
  farvd_bs_it_02.bvdat AS BankPostingDate,
  farvd_bs_it_02.budat AS PostingDate,
  farvd_bs_it_02.butim AS ValueDateTime,
  farvd_bs_it_02.butxt AS PaymentTransactionDescription,
  farvd_bs_it_02.busab AS AccountingClerk,
  farvd_bs_it_02.processor AS UserID,
  farvd_bs_it_02.kostl AS CostCenter,
  farvd_bs_it_02.gsber AS BusinessArea,
  farvd_bs_it_02.prctr AS ProfitCenter,
  farvd_bs_it_02.vertn AS Contract,
  farvd_bs_it_02.vertt AS TreasuryContractType,
  farvd_bs_it_02.pnota AS DaybookEntry,
  farvd_bs_it_02.estat AS PostingErrorStatus,
  farvd_bs_it_02.belnr AS BankLedgerDocument,
  farvd_bs_it_02.belnr_gjahr AS BankLedgerDocFiscalYear,
  farvd_bs_it_02.gjahr AS FiscalYear,
  farvd_bs_it_02.spesk AS FeeAmountInTransactionCrcy,
  farvd_bs_it_02.spesf AS FeeAmountInOriginalCrcy,
  farvd_bs_it_02.texts AS BankPostingKey,
  farvd_bs_it_02.kfmod AS AcctDetnFreeDefinedAttribute,
  farvd_bs_it_02.vgsap AS BankTransactionCategory,
  farvd_bs_it_02.xblnr AS DocumentReferenceID,
  farvd_bs_it_02.zuonr AS AssignmentReference,
  farvd_bs_it_02.pabks AS PartnerBankCountry,
  farvd_bs_it_02.pablz AS PartnerBank,
  farvd_bs_it_02.paswi AS PartnerBankSWIFTCode,
  farvd_bs_it_02.pakto AS PartnerBankAccount,
  farvd_bs_it_02.info1 AS BankStatementItemDescription1,
  farvd_bs_it_02.info2 AS BankStatementItemDescription2,
  farvd_bs_it_02.nbbln AS SubledgerDocument,
  farvd_bs_it_02.nbbln_gjahr AS SubledgerDocFiscalYear,
  farvd_bs_it_02.ak1bl AS BankLedgerOnAccountDocument,
  farvd_bs_it_02.ak1bl_gjahr AS BankLedgerOnAccDocFiscalYear,
  farvd_bs_it_02.akbln AS SubledgerOnAccountDocument,
  farvd_bs_it_02.akbln_gjahr AS SubledgerOnAccDocFiscalYear,
  farvd_bs_it_02.IsPostedOnAccount AS IsPostedOnAccount,
  farvd_bs_it_02.knrza AS PayerParty,
  farvd_bs_it_02.processing_status AS ProcessingStatus,
  farvd_bs_it_02.sgtxt AS DocumentItemText,
  farvd_bs_it_02.jpdat AS BillOfExchangeFailureDate,
  farvd_bs_it_02.vgref AS BankReference,
  farvd_bs_it_02.xbenr AS ReferenceDocument,
  farvd_bs_it_02.xbtyp AS ReferenceDocumentType,
  farvd_bs_it_02.arrsk AS OverdueChargeAmtInTransacCrcy,
  farvd_bs_it_02.pform AS BankStmntItemProcessingType,
  farvd_bs_it_02.kidno AS PaymentReference,
  farvd_bs_it_02.kkref AS BankStatementItemReturnReason,
  farvd_bs_it_02.mansp AS DunningBlockingReasonCode,
  farvd_bs_it_02.b1app AS BankLedgerExternalApplication,
  farvd_bs_it_02.b1app_text AS BankLedgerExtApplicationText,
  farvd_bs_it_02.b1std AS BankLedgerPostingIsSuppressed,
  farvd_bs_it_02.b1err AS BankLedgerExtPostgErrorStatus,
  farvd_bs_it_02.b1doc AS BankLedgerExtPostingDocument,
  farvd_bs_it_02.b1typ AS BankLedgerExtPostingRefDocType,
  farvd_bs_it_02.b2app AS SubledgerExtPostingApplication,
  farvd_bs_it_02.b2app_text AS SubledgerExtPostingApplText,
  farvd_bs_it_02.b2std AS SubledgerPostingIsSuppressed,
  farvd_bs_it_02.b2err AS SubledgerExtPostingErrorStatus,
  farvd_bs_it_02.b2doc AS SubledgerExtPostingDocument,
  farvd_bs_it_02.b2typ AS SubledgerExtPostingRefDocType,
  farvd_bs_it_02.piban AS PartnerBankIBAN,
  farvd_bs_it_02.azidt AS BankStatementInternalID,
  farvd_bs_it_02.astat AS BankStatementProcessingStatus,
  farvd_bs_it_02.kipre AS BankStatementIsInterpreted,
  farvd_bs_it_02.hkont AS GLAccountHeader,
  farvd_bs_it_02.ktoih AS BankAccountHolderName,
  farvd_bs_it_02.ktosb AS BankAccountAdditionalName,
  farvd_bs_it_02.azpgno AS BankStatementPageNumber,
  farvd_bs_it_02.ktopl AS ChartOfAccounts,
  farvd_bs_it_02.ssbtr AS OpeningBalanceAmtInTransCrcy,
  farvd_bs_it_02.sumso AS TotalDebitAmountInTransCrcy,
  farvd_bs_it_02.sumha AS TotalCreditAmountInTransCrcy,
  farvd_bs_it_02.esbtr AS ClosingBalanceAmtInTransCrcy,
  farvd_bs_it_02.hzins AS InterestRateInPercent,
  farvd_bs_it_02.bktoa AS BankAccountType,
  farvd_bs_it_02.anzes AS BankStatementNumberOfItems,
  farvd_bs_it_02.vgtyp AS PaymentTransactionTypeGroup,
  farvd_bs_it_02.vgman AS PaymentManualTransacType,
  farvd_bs_it_02.vgman_t AS PaymentManualTransacTypeName,
  farvd_bs_it_02.euser AS CreatedByUser,
  farvd_bs_it_02.edate AS BankStatementImportDate,
  farvd_bs_it_02.etime AS BankStatementImportTime,
  farvd_bs_it_02.bkref AS BankAccountReferenceText,
  farvd_bs_it_02.input_format AS BankStatementFormat,
  farvd_bs_it_02.siban AS IBAN,
  farvd_bs_it_02.reprocreasoncode AS BankStmntItemReprocessReason,
  farvd_bs_it_02.reprocessed AS BankStmntItemIsReprocessed,
  farvd_bs_it_02.draft_uuid AS DraftUUID,
  farvd_bs_it_02.PostingType AS PostingType,
  farvd_bs_it_02.ml_status AS MachineLrngBankStmntItemStatus,
  farvd_bs_it_02.ml_status_accdet AS MachineLrngBkStmntItemAcctSts,
  farvd_bs_it_02.pr_status AS PostingRuleBankStmntItemStatus,
  farvd_bs_it_02.bs_item_id AS BSItemId,
  farvd_bs_it_02.PostingRule AS PostingRule,
  farvd_bs_it_02.PostingRuleDescription AS PostingRuleDescription,
  farvd_bs_it_02.postingruleuuid AS PostingRuleUUID,
  farvd_bs_it_02.BankStatementTwoStepPostgRule AS BankStatementTwoStepPostgRule,
  farvd_bs_it_02.ReprocgRulePostgProcedureType AS ReprocgRulePostgProcedureType,
  farvd_bs_it_02.anwnd AS OriginApplication,
  farvd_bs_it_02.sdoc2 AS LockboxSubledgerDocument,
  farvd_bs_it_02.part_appl_status AS PartialApplicationStatus,
  farvd_bs_it_02.advcassignmentrepetitionstatus AS AdvcAssignmentRepetitionStatus,
  farvd_bs_it_02.semobjbyprocessingapplication AS SemObjByProcessingApplication,
  farvd_bs_it_02.refbyprocessingapplication AS RefByProcessingApplication,
  farvd_bs_it_02.bankstmntprocessingapplication AS BankStmntProcessingApplication,
  farvd_bs_it_02.bank_status_code AS BankStatementItemStatusByBank,
  farvd_bs_it_02.processed_kukey AS ProcessedBankStatementShortID,
  farvd_bs_it_02.processed_esnum AS ProcessedBankStatementItem,
  farvd_bs_it_02.accountservicerreference AS AccountServicerReference,
  farvd_bs_it_02.bankstmntitmprocessingcategory AS BankStmntItmProcessingCategory,
  _Bank.BankName AS HouseBankName,
  _BkStmntItmProcgCatText.BankStmntItmProcgCategoryName AS BankStmntItmProcgCategoryName,
  _HouseBankAccount.BankInternalID AS BankInternalID,
  _HouseBankAccount.BankAccount AS BankAccount,
  _HouseBankAccount.BankAccountInternalID AS BankAccountInternalId,
  _HouseBankAccount.BankAccountDescription AS HouseBankAccountDescription,
  _IncomingPaymentFileLine.IncomingPaymentFile AS IncomingPaymentFile,
  _MchnLrngAcctDetnStsText.MchnLrngBkStmntItmAcctStsName AS MchnLrngBkStmntItmAcctStsName,
  _MchnLrngStatusText.MachineLrngBkStmntItemStatName AS MachineLrngBkStmntItemStatName,
  _MemoLine.OriginalMemoLine AS OriginalMemoLine,
  _MemoLine.MemoLine AS MemoLine,
  _PaytAdviceAcctTypeText.PaymentAdviceAccountTypeName AS PaymentAdviceAccountTypeName,
  _Processor.sname AS AccountingClerkName,
  _ProcessorName.UserDescription AS PersonFullName,
  _ReprReasonText.rrc_text AS BankStmntItmPostprocReasonName,
  _Username.UserDescription AS CreatedByUserName
FROM farvd_bs_it_02
LEFT OUTER JOIN I_IncomingPaymentFileLine AS _IncomingPaymentFileLine ON _IncomingPaymentFileLine.BankStatementShortID = BankStatementShortID AND _IncomingPaymentFileLine.IncomingPaymentFileType <> 'A'  -- association [0..1]
LEFT OUTER JOIN I_Arbsitmemolinewithorig AS _MemoLine ON BankStatementShortID = _MemoLine.BankStatementShortID AND BankStatementItem = _MemoLine.BankStatementItem  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccountLinkage AS _HouseBankAccount ON _HouseBankAccount.CompanyCode = CompanyCode AND _HouseBankAccount.HouseBank = HouseBank AND _HouseBankAccount.HouseBankAccount = HouseBankAccount AND _HouseBankAccount.HouseBank <> '' AND _HouseBankAccount.HouseBankAccount <> ''  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _CustomerCompany ON _CustomerCompany.CompanyCode = CompanyCode AND _CustomerCompany.Customer = PaymentAdviceAccount  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON _SupplierCompany.CompanyCode = CompanyCode AND _SupplierCompany.Supplier = PaymentAdviceAccount  -- association [0..1]
LEFT OUTER JOIN I_PaytAdviceAccountTypeText AS _PaytAdviceAcctTypeText ON _PaytAdviceAcctTypeText.PaymentAdviceAccountType = PaymentAdviceAccountType AND _PaytAdviceAcctTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BkStmntItmProcgCatText AS _BkStmntItmProcgCatText ON _BkStmntItmProcgCatText.BankStmntItmProcessingCategory = BankStmntItmProcessingCategory AND _BkStmntItmProcgCatText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MachineLearningStatusText AS _MchnLrngStatusText ON _MchnLrngStatusText.MachineLrngBankStmntItemStatus = MachineLrngBankStmntItemStatus AND _MchnLrngStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MchnLrngAcctDetnStatusTxt AS _MchnLrngAcctDetnStsText ON _MchnLrngAcctDetnStsText.MachineLrngBkStmntItemAcctSts = MachineLrngBkStmntItemAcctSts AND _MchnLrngAcctDetnStsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Bank AS _Bank ON _Bank.BankCountry = farvd_bs_it_02.bank_country AND _Bank.BankInternalID = farvd_bs_it_02.bank_key  -- association [0..1]
LEFT OUTER JOIN I_User AS _Username ON _Username.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _ProcessorName ON _ProcessorName.UserID = UserID  -- association [0..1]
LEFT OUTER JOIN t001s AS _Processor ON _Processor.busab = AccountingClerk AND _Processor.bukrs = CompanyCode  -- association [0..1]
LEFT OUTER JOIN Farvd_Bs_It_06 AS _AttachmentKey ON _AttachmentKey.instid_a = farvd_bs_it_02.AttachmentKey  -- association [0..1]
LEFT OUTER JOIN feb_repro_rrct AS _ReprReasonText ON _ReprReasonText.reprocreasoncode = BankStmntItemReprocessReason AND _ReprReasonText.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN Farvd_Bs_It_04 AS _TransactionType ON _TransactionType.tatyp = PaymentTransactionCategory  -- association [0..1]
;