FARMLVD_BSITM

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 FARMLVD_BSITM.
-- 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: FMVBSITM

CREATE VIEW FARMLVD_BSITM AS
SELECT
  BankStmtHeader.BankStatementShortID AS BankStatementShortID,
  BankStmtHeader.CompanyCode AS CompanyCode,
  BankStmtItm.BankStatementItem AS BankStatementItem,
  CompanyCtryKey.CountryKey AS CountryKey,
  BankStmtHeader.HouseBank AS HouseBank,
  BankStmtHeader.HouseBankAccount AS HouseBankAccount,
  BankStmtHeader.BankStatement AS BankStatement,
  BankStmtItm.FiscalYear AS FiscalYear,
  BankStmtItm.PostingDate AS PostingDate,
  BankStmtItm.ValueDate AS ValueDate,
  BankStmtItm.Currency AS Currency,
  BankStmtItm.TransactionCurrency AS TransactionCurrency,
  BankStmtItm.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  BankStmtItm.DebitCreditCode AS DebitCreditCode,
  BankStmtItm.PartnerBankCountry AS PartnerBankCountry,
  BankStmtItm.PartnerBank AS PartnerBank,
  BankStmtItm.PartnerBankSWIFTCode AS PartnerBankSWIFTCode,
  BankStmtItm.PartnerBankAccount AS PartnerBankAccount,
  BankStmtItm.PartnerBankIBAN AS PartnerBankIBAN,
  BankStmtItm.BusinessPartnerName AS BusinessPartnerName,
  BankStmtItm.BankLedgerDocument AS BankLedgerDocument,
  BankStmtItm.SubledgerDocument AS SubledgerDocument,
  BankStmtItm.DocumentReferenceID AS DocumentReferenceID,
  BankStmtItm.PaymentAdviceAccountType AS PaymentAdviceAccountType,
  BankStmtItm.PaymentAdviceAccount AS PaymentAdviceAccount,
  BankStmtItm.AssignmentReference AS AssignmentReference,
  BankStmtItm.PaymentReference AS PaymentReference,
  BankStmtItm.BankStatementPostingRule AS BankStatementPostingRule,
  BankStmtItm.SubledgerOnAccountDocument AS SubledgerOnAccountDocument,
  BankStmtItm.PaymentAdvice AS PaymentAdvice,
  BankStmtItm.MemoLineIsChanged AS MemoLineIsChanged,
  cast('' as abap.sstring( 1333)) AS MemoLine,
  concat(BankStmtItm.BankStatementShortID, BankStmtItm.BankStatementItem) AS BankShortkeyMemo,
  BankStmtItm.PaymentTransactionDescription AS PaymentTransactionDescription,
  BankStmtItm.Cheque AS Cheque,
  BankStmtItm.BankPostingKey AS BankPostingKey,
  BankStmtItm.PaymentTransaction AS PaymentTransaction,
  BankStmtItm.PaymentExternalTransacType AS PaymentExternalTransacType,
  BankStmtHeader.BankDataStorageApplication AS BankDataStorageApplication,
  BankStmtItm.MachineLrngBankStmntItemStatus AS MachineLrngBankStmntItemStatus,
  BankStmtItm.BankStmntItemIsReprocessed AS BankStmntItemIsReprocessed,
  BankStmtItm.BankStatementItemDescription1 AS BankStatementItemDescription1,
  cast('' as dats ) AS BankStatementDate,
  cast('' as koart ) AS AccountType,
  cast('' as abap.sstring( 64)) AS BankStatementKey,
  cast('' as farp_belnr_d ) AS DocumentNo,
  cast('' as kunnr ) AS Customer,
  cast('' as fac_umskz ) AS SpecialGLInd
FROM I_Arbankstatement AS BankStmtHeader
LEFT OUTER JOIN I_Arbankstatementitem AS BankStmtItm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FARMLVD_COMPANY AS CompanyCtryKey ON /* join condition not captured in parsed metadata */
;