I_MemoRecordWithFilter

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_MemoRecordWithFilter.
-- 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: IMEMOWITHFILTER

CREATE VIEW I_MemoRecordWithFilter AS
SELECT
  memo.CashFlowID AS CashFlowID,
  MemoRecord AS CashMemoRecordID,
  memo.CompanyCode AS CompanyCode,
  memo.PlanningLevel AS PlanningLevel,
  memo.TransactionDate AS TransactionDate,
  memo.ExpirationDate AS ExpirationDate,
  memo.CashPlanningGroup AS CashPlanningGroup,
  memo.BankAccountInternalID AS BankAccountInternalID,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  _Text.BankAccountDescription AS BankAccountDescription,
  memo.TransactionCurrency AS TransactionCurrency,
  memo.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  memo.LiquidityItem AS LiquidityItem,
  memo.CreatedByUser AS CreatedByUser,
  memo.CreationDateTime AS CreationTime,
  memo.LastChangedByUser AS LastChangedByUser,
  memo.LastChangeDateTime AS LastChangeDateTime,
  memo.BusinessArea AS BusinessArea,
  memo.ProfitCenter AS ProfitCenter,
  memo.Fund AS Fund,
  memo.GrantID AS GrantID,
  memo.Fund AS AssetFund,
  memo.GrantID AS AssetGrant,
  cast ( BankStatement as fqm_origin_trans_id) AS BankStatementShortID,
  memo.BankStatementDate AS BankStatementDate,
  memo.HouseBank AS HouseBank,
  memo.HouseBankAccount AS HouseBankAccount,
  memo.GLAccount AS GLAccount,
  cast ('CMR' as fqm_owner ) AS OwnerName,
  memo.CertaintyLevel AS CertaintyLevel,
  memo.OriginApplication AS OriginApplication,
  memo.CashFlowCategory AS CashFlowCategory,
  cast('' as fqm_flow_type) AS CashFlowType,
  cast ( '' as fqm_deleted ) AS IsDeleted,
  MemoRecordStatus,
  CashCalendarTypeForFinInvmt AS CustomerFactoryCalenderCode,
  MemoRecordInterestRate AS EffectiveInterestRate,
  memo.TermStartDate AS TermStartDate,
  DocumentItemText AS TextDescription,
  memo.Segment AS Segment,
  memo.CashReleaseStatus AS CashReleaseStatus,
  memo.OffsettingCompanyCode AS OffsettingCompanyCode,
  memo.OffsettingAccount AS OffsettingAccount,
  memo.OffsettingValueDate AS OffsettingValueDate,
  cast( '' as bankn ) AS OffsettingBankAccount,
  memo.OffsetBankAccountNumber AS OffsetBankAccountNumber,
  memo.OffsettingHouseBank AS OffsettingHouseBank,
  memo.OffsettingHouseBankAccount AS OffsettingHouseBankAccount,
  CashRequestStatus,
  CashReqInstrCategory,
  FollowingCurrency,
  AmountInFollowingCurrency,
  cast( 0 as fclm_cshrq_open_opps_amount ) AS OpenAmountInFollowingCurrency,
  TrsyTradedAmountBuySellCode,
  ReceivingBankAccountIntID,
  CashReqHasDocument,
  FinancialInstrumentAssignment,
  FinancialInstrumentReference,
  FinancialInstrCharacteristic,
  BankIdentification,
  BusinessPartner,
  AmountInLocalCurrency,
  LocalCurrency,
  MemoRecordStatisticItem AS IsStatisticalItem,
  cast( '0' as fqm_amount ) AS RequestedNetAmount,
  cast( 'EUR' as fqm_currency ) AS PurReqCurrency,
  CashRequestSubmittedByUser,
  TermEndDate,
  MemoRecordBorrowInvestCode AS TrsyCshFlowDebtInvmtCode,
  LoanTermStartDate,
  LoanTermEndDate,
  OffstgBankAccountInternalID,
  CashPaymentAdviceGroup,
  cast( TrsyTradedAmountBuySellCode as fclm_cshrq_fx_buy_sell ) AS CshTrdReqFXLeg1BuySellCode,
  CshTrdReqFXLeg1ValueDate,
  CshTrdReqFXLeg1ReqdAmtInTDC,
  CshTrdReqFXLeg1OpenAmtInTDC,
  CshTrdReqFXLeg1TradedCurrency,
  CshTrdReqFXLeg1ReqdAmtInOTDC,
  cast( 0 as fclm_cshrq_open_opps_amount ) AS CshTrdReqFXLeg1OpenAmtInOTDC,
  CshTrdReqFXLeg1OpstTrddCrcy,
  CshTrdReqFXLeg1SndgBkAcctIntID,
  CshTrdReqFXLeg1RcvgBkAcctIntID,
  CshTrdReqFXLeg2ValueDate,
  CshTrdReqFXLeg2ReqdAmtInTDC,
  CshTrdReqFXLeg2OpenAmtInTDC,
  CshTrdReqFXLeg2TradedCurrency,
  CshTrdReqFXLeg2ReqdAmtInOTDC,
  cast( 0 as fclm_cshrq_open_opps_amt_leg2 ) AS CshTrdReqFXLeg2OpenAmtInOTDC,
  CshTrdReqFXLeg2OpstTrddCrcy,
  CshTrdReqFXLeg2SndgBkAcctIntID,
  CshTrdReqFXLeg2RcvgBkAcctIntID
FROM I_LeadingMemoRecord AS memo
LEFT OUTER JOIN I_BankAccountBasicData AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountText AS _Text ON BankAccountInternalID = _Text.BankAccountInternalID AND _Text.Language = $session.system_language  -- association [0..1]
;