I_MemoRecord

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_MemoRecord.
-- 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: IMEMORECORD

CREATE VIEW I_MemoRecord AS
SELECT
  flow_id AS CashFlowID,
  valid_from AS ValidFrom,
  valid_to AS ValidTo,
  origin_application AS OriginApplication,
  flow_category AS CashFlowCategory,
  cast ( lpad(substring(origin_document_id,1,10),10,'0') as idenr) AS MemoRecord,
  origin_document_id AS OriginDocument,
  origin_flow_id AS OriginFlowID,
  company_code AS CompanyCode,
  planning_level AS PlanningLevel,
  transaction_date AS TransactionDate,
  fi_due_date AS ExpirationDate,
  planning_group AS CashPlanningGroup,
  liquidity_item AS LiquidityItem,
  create_user AS CreatedByUser,
  create_timestamp AS CreationDateTime,
  last_update_user AS LastChangedByUser,
  last_update_timestamp AS LastChangeDateTime,
  business_area AS BusinessArea,
  profit_center AS ProfitCenter,
  Fund,
  grant_nbr AS GrantID,
  cast ( substring(origin_transaction_id_rl,1,18) as aznum_lg_eb ) AS BankStatement,
  cast ( lp_planed_payment_date2 as azdat_eb ) AS BankStatementDate,
  cast ( lpad(substring(internal_reference,1,8),8,'0') as kukey_eb) AS BankStatementShortID,
  cmm_bs_num_eb AS BankStatementItem,
  fi_account AS GLAccount,
  fi_item_text AS DocumentItemText,
  Segment,
  rel_status AS CashReleaseStatus,
  cast( certainty_level as fclm_mm_certainty_level ) AS CertaintyLevel,
  internal_reference AS MemoRecordInternalReference,
  cmm_statistics_indicator AS MemoRecordStatisticItem,
  partner AS BusinessPartner,
  characteristics AS FinancialInstrCharacteristic,
  currency AS TransactionCurrency,
  base_currency AS LocalCurrency,
  cmm_offset_account AS OffsettingAccount,
  assigned_company_code AS OffsettingCompanyCode,
  fi_value_date AS OffsettingValueDate,
  cmm_offset_accid AS OffstgBankAccountInternalID,
  cmm_offset_bank_account_number AS OffsetBankAccountNumber,
  cmm_offset_housebank AS OffsettingHouseBank,
  cmm_offset_housebankaccount AS OffsettingHouseBankAccount,
  cmm_calendar_type AS CashCalendarTypeForFinInvmt,
  cmm_interest_rate AS MemoRecordInterestRate,
  cmm_exchange_rate_type AS MemoRecordExchangeRateType,
  cmm_payment_group AS CashPaymentAdviceGroup,
  cmm_reason AS CashPaymentAdvicePairingReason,
  cmm_assignment_number AS MemoRecordAssignment,
  cmm_planning_type AS MemoRecordPlanningType,
  cashrequest_status AS CashRequestStatus,
  instrument_category AS CashReqInstrCategory,
  following_currency AS FollowingCurrency,
  amount_in_folcur AS AmountInFollowingCurrency,
  buy_sell_indicator AS TrsyTradedAmountBuySellCode,
  flag_document AS CashReqHasDocument,
  assignment AS FinancialInstrumentAssignment,
  internal_reference AS FinancialInstrumentReference,
  following_bankdetail AS BankIdentification,
  cashrequest_subimitted_by AS CashRequestSubmittedByUser,
  mmk_term_from_date AS TermStartDate,
  mmk_term_to_date AS TermEndDate,
  mmk_max_term_from_date AS LoanTermStartDate,
  mmk_max_term_to_date AS LoanTermEndDate,
  mmk_invest_borrow AS MemoRecordBorrowInvestCode,
  mmk_offset_flag AS MemoRecordIsOffsettingFlow,
  fxsw_value_date_leg_1 AS CshTrdReqFXLeg1ValueDate,
  fxsw_requested_amount_leg_1 AS CshTrdReqFXLeg1ReqdAmtInTDC,
  fxsw_open_traded_amount_leg_1 AS CshTrdReqFXLeg1OpenAmtInTDC,
  fxsw_traded_currency_leg_1 AS CshTrdReqFXLeg1TradedCurrency,
  fxsw_opposite_amount_leg_1 AS CshTrdReqFXLeg1ReqdAmtInOTDC,
  fxsw_opposite_currency_leg_1 AS CshTrdReqFXLeg1OpstTrddCrcy,
  fxsw_sending_acc_id_leg_1 AS CshTrdReqFXLeg1SndgBkAcctIntID,
  fxsw_receiving_acc_id_leg_1 AS CshTrdReqFXLeg1RcvgBkAcctIntID,
  fxsw_value_date_leg_2 AS CshTrdReqFXLeg2ValueDate,
  fxsw_requested_amount_leg_2 AS CshTrdReqFXLeg2ReqdAmtInTDC,
  fxsw_open_traded_amount_leg_2 AS CshTrdReqFXLeg2OpenAmtInTDC,
  fxsw_traded_currency_leg_2 AS CshTrdReqFXLeg2TradedCurrency,
  fxsw_opposite_amount_leg_2 AS CshTrdReqFXLeg2ReqdAmtInOTDC,
  fxsw_opposite_currency_leg_2 AS CshTrdReqFXLeg2OpstTrddCrcy,
  fxsw_sending_acc_id_leg_2 AS CshTrdReqFXLeg2SndgBkAcctIntID,
  fxsw_receiving_acc_id_leg_2 AS CshTrdReqFXLeg2RcvgBkAcctIntID
FROM fqm_flow
;