I_StstclKeyFigureValueItem

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_StstclKeyFigureValueItem.
-- 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: ISKFVALITEM

CREATE VIEW I_StstclKeyFigureValueItem AS
SELECT
  kokrs AS ControllingArea,
  belnr AS AccountingDocument,
  buzei AS AccountingDocumentItem,
  cast(perio as fins_fiscalperiod) AS FiscalPeriod,
  cast(smebtr as quan1_12) AS StatisticalKeyFigureQuantity,
  cast(meinh as fis_ui_seinh) AS StstcKeyFigQuantityUnit,
  cast(sgtxt as sgtxt) AS DocumentItemText,
  objnr AS ControllingObject,
  gjahr AS FiscalYear,
  cast(stagr as fis_stagr) AS StatisticalKeyFigure,
  vrgng AS ControllingBusTransacType,
  pernr AS PersonnelNumber,
  fkber AS PartnerFunctionalArea,
  geber AS PartnerFund,
  grant_nbr AS PartnerGrant,
  budget_pd AS PartnerBudgetPeriod,
  budat AS PostingDate,
  bldat AS DocumentDate,
  cpudt AS AccountingDocumentCreationDate,
  usnam AS AccountingDocCreatedByUser,
  bltxt AS ControllingDocumentHeaderText,
  stflg AS IsReversalDocument,
  stokz AS IsReversed,
  cast(refbn as reversedreferencedocument) AS ReversedReferenceDocument,
  cast(wsdat as fin_currconvdat) AS ExchangeRateDate,
  kurst AS ExchangeRateType,
  kwaer AS ControllingAreaCurrency,
  cast(awtyp as fis_awtyp) AS ReferenceDocumentType,
  dabrz AS SettlementReferenceDate
FROM covpr
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_GrantText AS _PartnerGrantText ON PartnerGrant = _PartnerGrantText.GrantID  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodText AS _PartnerBudgetPeriodText ON PartnerBudgetPeriod = _PartnerBudgetPeriodText.BudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _PartnerFunctionalAreaText ON PartnerFunctionalArea = _PartnerFunctionalAreaText.FunctionalArea  -- association [0..*]
;