I_ARBankTransactionDocumentItm

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_ARBankTransactionDocumentItm.
-- 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_ARBankTransactionDocumentItm AS
SELECT
  kukey AS BankStatementShortID,
  esnum AS BankStatementItem,
  vb1ok AS BankLedgerIsPosted,
  vb2ok AS SubledgerIsPostedSuccessfully,
  epvoz AS DebitCreditCode,
  kwbtr AS AmountInAccountCurrency,
  grpnr AS BankStatementItemGroup,
  vgint AS BankStatementPostingRule,
  vorgc AS PaymentTransaction,
  intag AS InterpretationAlgorithm,
  valut AS ValueDate,
  avkoa AS PaymentAdviceAccountType,
  avkon AS PaymentAdviceAccount,
  case when svavs = '' then '' else 'X' end as IsInProcess AS casewhensvavsthenelseXendasIsInProcess,
  n2pch AS MemoLineIsChanged,
  kwaer AS TransactionCurrency,
  fwaer AS OriginalCurrency,
  cast(curr_rate as fac_kursf_ext ) AS ExchangeRate,
  partn AS BusinessPartnerName,
  vgman AS PaymentManualTransacType,
  avsid AS PaymentAdvice,
  bvdat AS BankPostingDate,
  budat AS PostingDate,
  butim AS ValueDateTime,
  butxt AS PaymentTransactionDescription,
  busab AS AccountingClerk,
  kostl AS CostCenter,
  gsber AS BusinessArea,
  prctr AS ProfitCenter,
  vertn AS TreasuryContract,
  vertt AS TreasuryContractType,
  pnota AS DaybookEntry,
  pipre AS BankStatementItemIsInterpreted,
  estat AS PostingErrorStatus,
  belnr AS BankLedgerDocument,
  cast( gjahr as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  spesk AS FeeAmountInTransactionCrcy,
  spesf AS FeeAmountInOriginalCrcy,
  texts AS BankPostingKey,
  kfmod AS AcctDetnFreeDefinedAttribute,
  xblnr AS DocumentReferenceID,
  zuonr AS AssignmentReference,
  pabks AS PartnerBankCountry,
  pablz AS PartnerBank,
  paswi AS PartnerBankSWIFTCode,
  pakto AS PartnerBankAccount,
  stavv AS AssetManagementStatus,
  txtvv AS AssetManagementText,
  info1 AS BankStatementItemDescription1,
  info2 AS BankStatementItemDescription2,
  nbbln AS SubledgerDocument,
  ak1bl AS BankLedgerOnAccountDocument,
  akbln AS SubledgerOnAccountDocument,
  knrza AS PayerParty,
  batch AS LockboxBatch,
  abs(kursf) AS AccountingExchangeRate,
  sgtxt AS DocumentItemText,
  jpdat AS BillOfExchangeFailureDate,
  posag AS LockboxPostingAlgorithm,
  sdoc2 AS LockboxSubledgerDocument,
  vgref AS BankReference,
  xbenr AS OriginalReferenceDocument,
  xbtyp AS ReferenceDocumentType,
  arrsk AS OverdueChargeAmtInTransacCrcy,
  pform AS BankStmntItemProcessingType,
  kidno AS PaymentReference,
  kkref AS BankStatementItemReturnReason,
  mansp AS DunningBlockingReason,
  idenr AS BankStatementByCashManagement,
  b1app AS BankLedgerExternalApplication,
  b1std AS BankLedgerPostingIsSuppressed,
  b1err AS BankLedgerExtPostgErrorStatus,
  b1doc AS BankLedgerExtPostingDocument,
  b1typ AS BankLedgerExtPostingRefDocType,
  b2app AS SubledgerExtPostingApplication,
  b2std AS SubledgerPostingIsSuppressed,
  b2err AS SubledgerExtPostingErrorStatus,
  b2doc AS SubledgerExtPostingDocument,
  b2typ AS SubledgerExtPostingRefDocType,
  piban AS PartnerBankIBAN,
  reprocreasoncode AS BankStmntItemReprocessReason,
  tatyp AS PaymentTransactionCategory,
  eperl AS IsCompleted,
  ml_status AS MachineLrngBankStmntItemStatus,
  belnr_gjahr AS BankLedgerAcctgDocFiscalYear,
  nbbln_gjahr AS SubledgerAcctgDocFiscalYear,
  accdoc_tmp_doc_id AS TemporaryAccountingDocument,
  bp_id_category AS BPIdentificationCategory,
  bp_id_number AS BPIdentificationNumber,
  additional_info AS LockboxBatchItmAdditionalInfo,
  BankStmntProcessingApplication,
  AccountServicerReference,
  bank_status_code AS BankStatementItemStatusByBank,
  BankStmntItmProcessingCategory
FROM febep
;