I_IntradayRecnclnDetailObjPg

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_IntradayRecnclnDetailObjPg.
-- 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: INTRRSLTDTLOBJ

CREATE VIEW I_IntradayRecnclnDetailObjPg AS
SELECT
  CshRecnclnID,
  CashFlowID,
  ValidFrom,
  BankAccountInternalID,
  OriginDocument,
  MemoRecord,
  CompanyCode,
  ValueDate,
  DocumentItemText,
  ReconciledCashFlowIsChanged,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  AmountInTransactionCurrency,
  TransactionCurrency,
  CertaintyLevel,
  PlanningLevel,
  LiquidityItem
FROM P_IntradayRecnclnResult AS reconcile
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON reconcile.BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_LiquidityItemText AS _LiquidityItemText ON reconcile.LiquidityItem = _LiquidityItemText.LiquidityItem  -- association [1..*]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON reconcile.PlanningLevel = _PlanningLevelText.PlanningLevel  -- association [1..*]
LEFT OUTER JOIN I_CertaintyLevelText AS _CertaintyLevelText ON reconcile.CertaintyLevel = _CertaintyLevelText.CertaintyLevel  -- association [1..*]
;