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.
-- SQL view name: IMMRD2

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.transaction_date AS TransactionDate,
  Memorecord.expiration_date AS ExpirationDate,
  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.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 FinancialInstrCharacteristic,
  Memorecord.channel AS MemoRecordChannel,
  CompanyCode.ControllingArea AS ControllingArea,
  CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  CompanyCode.CompanyCodeName AS CompanyCodeName,
  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.memorecordimportid AS MemoRecordImport,
  _ProfitCenter.ValidityEndDate AS ProfitCenterValidityEndDate,
  CompanyCode._ControllingArea AS _ControllingArea
FROM fclm_mmrd AS Memorecord
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
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_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_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea AND TransactionDate <= _ProfitCenter.ValidityEndDate AND TransactionDate >= _ProfitCenter.ValidityStartDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenterValidityEndDate = _ProfitCenterText.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_FundText AS _FundText ON Fund = _FundText.Fund AND FinancialManagementArea = _FundText.FinancialManagementArea  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _GrantText ON GrantID = _GrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_FinancialInstrCharcText AS _FinancialInstrCharcText ON FinancialInstrCharacteristic = _FinancialInstrCharcText.FinancialInstrCharacteristic  -- 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..*]
;