FARMLVD_BSITM_STAT_PREP

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_STAT_PREP.
-- 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: FMVBSITMSTATPRE
-- Parameters: p_start_date : abap.dats, p_end_date : abap.dats

CREATE VIEW FARMLVD_BSITM_STAT_PREP AS
SELECT
  BankStmtHeader.CompanyCode AS CompanyCode,
  CompanyCtryKey.CountryKey AS CountryKey,
  BankStmtItm.DebitCreditCode AS DebitCreditCode,
  BankStmtItm.MachineLrngBankStmntItemStatus AS MachineLearningStatus,
  BankStmtItm.BankStmntItemIsReprocessed AS IsReprocessed,
  BankStmtItm.PostingDate AS PostingDate
FROM I_Arbankstatement AS BankStmtHeader
LEFT OUTER JOIN I_Arbankstatementitem AS BankStmtItm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t033f AS BankLedgerPostingRule ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t033f AS SubLedgerPostingRule ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FARMLVD_COMPANY AS CompanyCtryKey ON /* join condition not captured in parsed metadata */
;