C_StatKeyFigValueAssignment

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 C_StatKeyFigValueAssignment.
-- 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: CWUSKFVA

CREATE VIEW C_StatKeyFigValueAssignment AS
SELECT
  cast ('6VA' as statkeyfigwhereusedobjtypevh) AS StatKeyFigWhereUsedObjType,
  Ledger,
  CompanyCode,
  StatisticalKeyFigure,
  FiscalYear,
  FiscalPeriod,
  StatisticalKeyFigureItem,
  AccountAssignmentType,
  _AccountAssignmentType._Text[1: Language = $session.system_language ].AccountAssignmentTypeDesc AS AccountAssignmentTypeDesc,
  GLRecordType,
  _GLRecordType._Text[1: Language = $session.system_language ].GLRecordTypeName AS GLRecordTypeName,
  cast( coalesce( PlanningCategory, '' ) as fcom_category ) AS PlanningCategory,
  StatisticalKeyFigureQuantity,
  StatisticalKeyFigQtyUnit,
  cast( coalesce( CostCenter, '' ) as fis_kostl ) AS CostCenter,
  _CostCenter._Text[1: Language = $session.system_language ].CostCenterName AS CostCenterName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _StatisticalKeyFigure._Text[1: Language = $session.system_language ].StatisticalKeyFigureName AS StatisticalKeyFigureName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  cast( coalesce( ProfitCenter, '' ) as fis_prctr ) AS ProfitCenter,
  _ProfitCenter._Text[1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  _FunctionalArea._Text[1: Language = $session.system_language ].FunctionalAreaName AS FunctionalAreaName,
  cast( coalesce( BusinessArea, '' ) as fis_rbusa ) AS BusinessArea,
  _BusinessArea._Text[1: Language = $session.system_language ].BusinessAreaName AS BusinessAreaName,
  cast( coalesce( Segment, '' ) as fb_segment ) AS Segment,
  _Segment._Text[1: Language = $session.system_language ].SegmentName AS SegmentName,
  OrderID,
  _Order.OrderDescription AS OrderDescription,
  SalesOrder,
  WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  CostCtrActivityType,
  _CostCenterActivityType._Text[1: Language = $session.system_language ].CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _CostCenterActivityType.ValidityStartDate AS CostCtrActyTypeValdtyStartDate,
  _CostCenterActivityType.ValidityEndDate AS CostCtrActyTypeValdtyEndDate,
  ValidityStartDate,
  ValidityEndDate,
  ControllingBusTransacType
FROM P_StatKeyFigValueAssignment
LEFT OUTER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType  -- association [0..1]
LEFT OUTER JOIN I_GLRecordType AS _GLRecordType ON GLRecordType = _GLRecordType.GLRecordType  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_PlanningCategoryText AS _PlanningCategoryText ON PlanningCategory = _PlanningCategoryText.PlanningCategory AND _PlanningCategoryText.Language = $session.system_language  -- association [0..1]
;