I_MemoRecord_2

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_2.
-- 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_MemoRecord_2 AS
SELECT
  Memorecord.document_id AS MemoRecord,
  Memorecord.description AS MemoRecordDescription,
  Memorecord.company_code AS CompanyCode,
  Memorecord.category AS MemoRecordCategory,
  Memorecord.planning_type AS MemoRecordType,
  Memorecord.planning_level AS PlanningLevel,
  Memorecord.date_dimension AS MemoRecordBalanceDateDimension,
  Memorecord.transaction_date AS TransactionDate,
  Memorecord.expiration_datetime AS MemoRecordExpirationDateTime,
  Memorecord.status AS MemoRecordStatus_2,
  Memorecord.status AS MemoRecordStatus,
  Memorecord.acc_id AS BankAccountInternalID,
  Memorecord.amount_in_transaction_currency AS AmountInTransactionCurrency,
  Memorecord.transaction_currency AS TransactionCurrency,
  Memorecord.amount_in_company_code_curr AS AmountInCompanyCodeCurrency,
  Memorecord.company_code_currency AS CompanyCodeCurrency,
  Memorecord.source_rcn_bndl AS CashFlowReconciliationBundle,
  Memorecord.planning_group AS CashPlanningGroup,
  Memorecord.liquidity_item AS LiquidityItem,
  Memorecord.kukey AS BankStatementShortID,
  Memorecord.esnum AS BankStatementItem,
  Memorecord.profit_center AS ProfitCenter,
  Memorecord.fund AS Fund,
  Memorecord.grant_nbr AS GrantID,
  Memorecord.business_area AS BusinessArea,
  Memorecord.statistics_indicator AS MemoRecordStatisticsIndicator,
  Memorecord.characteristics AS MemoRecordCharacteristic,
  Memorecord.refer AS MemoRecordInternalReference,
  Memorecord.azdat AS BankStatementDate,
  Memorecord.channel AS MemoRecordChannel,
  Memorecord.created_on AS CreationDate,
  Memorecord.changed_on AS LastChangeDate,
  Memorecord.created_by AS CreatedByUser,
  Memorecord.changed_by AS LastChangeByUser,
  Memorecord.created_at AS CreationDateTime,
  Memorecord.changed_at AS LastChangeDateTime,
  Memorecord.local_changed_at AS LocalLastChangeDateTime,
  Memorecord.hbkid AS HouseBank,
  Memorecord.hktid AS HouseBankAccount,
  Memorecord.posting_date AS PostingDate,
  Memorecord.gl_account AS GLAccount,
  Memorecord.memorecordimportid AS MemoRecordImport,
  Memorecord.is_leading_doc AS MemoRecordIsLeadingDocument,
  Memorecord.offset_company_code AS MemoRecdOffsettingCompanyCode,
  Memorecord.offset_hbkid AS MemoRecordOffsettingHouseBank,
  Memorecord.offset_hktid AS MemoRecdOffstgHouseBankAccount,
  Memorecord.pairing_reason AS MemoRecordPairingReason,
  Memorecord.offset_acc_id AS MemoRecdOffstgBkAcctInternalID,
  Memorecord.offset_doc_id AS OffsettingMemoRecord,
  Memorecord.offset_transaction_date AS MemoRecdOffstgTransactionDate
FROM fclm_mmrd AS Memorecord
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = Memorecord.company_code  -- association [0..1]
LEFT OUTER JOIN I_MemoRecordCategoryText AS _MemoRecordCategoryText ON MemoRecordCategory = _MemoRecordCategoryText.MemoRecordCategory  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccount AS _OffsetBankAccount ON MemoRecdOffstgBkAcctInternalID = _OffsetBankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _OffsetCompanyCode ON MemoRecdOffsettingCompanyCode = _OffsetCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MemoRecordStatusText_2 AS _MemoRecordStatusText ON MemoRecordStatus_2 = _MemoRecordStatusText.MemoRecordStatus_2  -- association [0..*]
LEFT OUTER JOIN I_MemoRecordTypeText AS _MemoRecordTypeText ON MemoRecordType = _MemoRecordTypeText.MemoRecordType  -- association [0..*]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON PlanningLevel = _PlanningLevelText.PlanningLevel  -- association [0..*]
LEFT OUTER JOIN I_CashPlanningGroupText AS _CashPlanningGroupText ON CashPlanningGroup = _CashPlanningGroupText.CashPlanningGroup  -- association [0..*]
LEFT OUTER JOIN I_LiquidityItemText AS _LiquidityItemText ON LiquidityItem = _LiquidityItemText.LiquidityItem  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_MemoRecordBalDteDimnText AS _BalDteDimnText ON MemoRecordBalanceDateDimension = _BalDteDimnText.MemoRecordBalanceDateDimension  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_StatisticalItemText AS _StatisticalItemText ON MemoRecordStatisticsIndicator = _StatisticalItemText.MemoRecordStatisticItem  -- association [0..*]
LEFT OUTER JOIN I_BankAccountText AS _BankAccountText ON BankAccountInternalID = _BankAccountText.BankAccountInternalID  -- association [0..*]
LEFT OUTER JOIN I_BankAccountText AS _OffstgBankAccountText ON MemoRecdOffstgBkAcctInternalID = _OffstgBankAccountText.BankAccountInternalID  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountTextInCompanyCode ON CompanyCode = _GLAccountTextInCompanyCode.CompanyCode AND GLAccount = _GLAccountTextInCompanyCode.GLAccount  -- association [0..*]
LEFT OUTER JOIN E_MemoRecord AS _Extension ON MemoRecord = _Extension.MemoRecord  -- association [1..1]
;