P_StstclKeyFigValueActiveItem

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 P_StstclKeyFigValueActiveItem.
-- 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: PSKFVALACTIT

CREATE VIEW P_StstclKeyFigValueActiveItem AS
SELECT
  ControllingArea AS ControllingAreaForEdit,
  AccountingDocument AS AccountingDocumentForEdit,
  AccountingDocumentItem,
  StatisticalKeyFigureQuantity,
  StstcKeyFigQuantityUnit,
  DocumentItemText,
  ControllingObject,
  StatisticalKeyFigure,
  cast(_StatisticalKeyFigure.StstcKeyFigCategory as fis_ui_grtyp preserving type) AS StstcKeyFigCategory,
  ControllingBusTransacType,
  PersonnelNumber,
  PartnerFund,
  PartnerFunctionalArea,
  PartnerGrant,
  PartnerBudgetPeriod,
  _Object.AccountAssignmentType AS AccountAssignmentType,
  _Object.CostCenter AS CostCenter,
  _Object.CostCtrActivityType AS CostCtrActivityType,
  _Object.BusinessProcess AS BusinessProcess,
  _Object.OrderID AS OrderID,
  cast(_Object._WBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type) AS PartnerWBSElementExternalID,
  cast(_Object._WBSElementBasicData.WBSElementExternalID as fis_par_psp_pnr_ext) AS WBSElement,
  _Object._WBSElementBasicData.WBSDescription AS WBSDescription,
  _Object.SalesDocument AS SalesDocument,
  _Object.SalesDocumentItem AS SalesDocumentItem,
  _Object.ProjectNetwork AS ProjectNetwork,
  _Object.NetworkActivity AS NetworkActivity,
  _Object.ServiceDocumentType AS ServiceDocumentType,
  _Object.ServiceDocument AS ServiceDocument,
  _Object.ServiceDocumentItem AS ServiceDocumentItem,
  _Object.CostObject AS CostObject,
  _Object._CompanyCode.FinancialManagementArea AS FinancialManagementArea,
  _RE.CompanyCode AS ReceiverRECompanyCode,
  _RE.REBusinessEntity AS REPartnerBusinessEntity,
  _RE.RealEstateBuilding AS RealEstatePartnerBuilding,
  _RE.RealEstateProperty AS RealEstatePartnerProperty,
  _RE.RERentalObject AS REPartnerRentalObject,
  _RE.RealEstateContract AS RealEstatePartnerContract,
  _RE.REServiceChargeKey AS REPartnerServiceChargeKey,
  _RE.RESettlementUnitID AS REPartnerSettlementUnitID,
  _Item.SettlementReferenceDate AS PartnerSettlementReferenceDate,
  DocumentDate,
  PostingDate,
  AccountingDocCreatedByUser,
  ControllingDocumentHeaderText,
  cast( case IsReversed when '' then 3 else 1 end as abap.int1) as StatusCriticality AS int1asStatusCriticality,
  FiscalPeriod,
  FiscalYear,
  AccountingDocumentCreationDate,
  IsReversalDocument,
  IsReversed,
  ReversedReferenceDocument,
  cast(_ReversalStstclKeyFigureValue.AccountingDocument as reversalreferencedocument) AS ReversalReferenceDocument,
  ExchangeRateDate,
  ExchangeRateType,
  ControllingAreaCurrency,
  ReferenceDocumentType
FROM I_StstclKeyFigureValueItem AS _Item
LEFT OUTER JOIN I_ControllingObjectEnhanced AS _Object ON ControllingObject = _Object.ControllingObject AND ControllingAreaForEdit = _Object.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_StatisticalKeyFigure AS _StatisticalKeyFigure ON StatisticalKeyFigure = _StatisticalKeyFigure.StatisticalKeyFigure AND ControllingAreaForEdit = _StatisticalKeyFigure.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_StatisticalKeyFigureValue AS _ReversalStstclKeyFigureValue ON ControllingAreaForEdit = _ReversalStstclKeyFigureValue.ControllingArea AND AccountingDocumentForEdit = _ReversalStstclKeyFigureValue.ReversedReferenceDocument  -- association [1..1]
LEFT OUTER JOIN I_REObjectByStatusObject AS _RE ON _Item.ControllingObject = _RE.REStatusObject  -- association [0..1]
;