I_CtrlgSettlementDocument

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_CtrlgSettlementDocument.
-- 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: ICTRLGSETTLMTDOC

CREATE VIEW I_CtrlgSettlementDocument AS
SELECT
  belnr AS ControllingSettlementDocument,
  kokrs AS ControllingArea,
  budat AS PostingDate,
  bzdat AS AssetValueDate,
  cpudt AS CreationDate,
  wsdat AS ValueDate,
  kurst AS ExchangeRateType,
  gjahr AS FiscalYear,
  perio AS SettlementPeriod,
  cast( perbz as perbz3 ) AS SettlementType,
  objnr AS ControllingObject,
  stflg AS IsReversal,
  stbel AS CtrlgSettlmtReversedDocument,
  stokz AS IsReversed,
  absch AS AllocationStructure,
  abrnr AS SettlementSequentialNumber,
  co_vaart AS SettlementProcessingType,
  buperio AS PostingPeriod,
  timestmp AS CreationDateTime,
  bldat AS DocumentDate,
  addcurr AS SettlmtWithFreeDefinedCurrency,
  lednr AS Ledger,
  ldgrp AS LedgerGroup
FROM auak
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON _ControllingArea.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_SettlementTypeText AS _SettlementTypeText ON _SettlementTypeText.SettlementType = SettlementType AND _SettlementTypeText.Language = $session.system_language  -- association [0..1]
;