What is C_StstclKeyFigValueActiveItem in SAP S/4HANA?

C_StstclKeyFigValueActiveItem is a consumption CDS view in SAP S/4HANA. Statistical Key Figure Value Item It contains 71 fields.

Which tables does C_StstclKeyFigValueActiveItem read from?

C_StstclKeyFigValueActiveItem reads data from: P_StstclKeyFigValueActiveItem.

What VDM layer is C_StstclKeyFigValueActiveItem?

C_StstclKeyFigValueActiveItem is classified as a Consumption view optimized for specific business scenarios and reporting.

C_StstclKeyFigValueActiveItem

DDL: C_STSTCLKEYFIGVALUEACTIVEITEM SQL: CSKFVALACTIT Type: view CONSUMPTION

71 Fields 1 Data Sources 9 Associations

Statistical Key Figure Value Item

C_StstclKeyFigValueActiveItem is a Consumption CDS View that provides data about "Statistical Key Figure Value Item" in SAP S/4HANA. It reads from 1 data source (P_StstclKeyFigValueActiveItem) and exposes 71 fields with key fields ControllingAreaForEdit, AccountingDocumentForEdit, AccountingDocumentItem. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_StstclKeyFigValueActiveItem	_Item	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	I_UnitOfMeasureText	_UnitOfMeasureText	`$projection.StstcKeyFigQuantityUnit = _UnitOfMeasureText.UnitOfMeasure and _UnitOfMeasureText.Language = $session.system_language`
[0..1]	I_UserContactCard	_CreatedByContactCard	`$projection.AccountingDocCreatedByUser = _CreatedByContactCard.ContactCardID`
[1..1]	I_CostRevnReassgmtDocStatusTxt	_CostRevnReassgmtDocStatusTxt	`$projection.Status = _CostRevnReassgmtDocStatusTxt.Status and _CostRevnReassgmtDocStatusTxt.Language = $session.system_language`
[1..1]	I_CostRevnReassgmtPostgTypeTxt	_CostRevnReassgmtPostgTypeTxt	`$projection.AllocationPostingType = _CostRevnReassgmtPostgTypeTxt.AllocationPostingType and _CostRevnReassgmtPostgTypeTxt.Language = $session.system_language`
[0..*]	I_FundText	_PartnerFundText	`$projection.FinancialManagementArea = _PartnerFundText.FinancialManagementArea and $projection.PartnerFund = _PartnerFundText.Fund`
[0..1]	I_CostCenterActivityTypeText	_PartnerCostCtrActivityTypeTxt	`$projection.ControllingAreaForEdit = _PartnerCostCtrActivityTypeTxt.ControllingArea and $projection.CostCtrActivityType = _PartnerCostCtrActivityTypeTxt.CostCtrActivityType and $projection.PostingDate <= _PartnerCostCtrActivityTypeTxt.ValidityEndDate and $projection.PostingDate >= _PartnerCostCtrActivityTypeTxt.ValidityStartDate and _PartnerCostCtrActivityTypeTxt.Language = $session.system_language`
[0..1]	I_CostCenterText	_PartnerCostCenterText	`$projection.ControllingAreaForEdit = _PartnerCostCenterText.ControllingArea and $projection.CostCenter = _PartnerCostCenterText.CostCenter and $projection.PostingDate <= _PartnerCostCenterText.ValidityEndDate and $projection.PostingDate >= _PartnerCostCenterText.ValidityStartDate and _PartnerCostCenterText.Language = $session.system_language`
[1..1]	I_StatisticalKeyFigureCatText	_StatisticalKeyFigureCatText	`$projection.StstcKeyFigCategory = _StatisticalKeyFigureCatText.StstcKeyFigCategory and _StatisticalKeyFigureCatText.Language = $session.system_language`
[0..1]	I_StatisticalKeyFigureText	_StatisticalKeyFigureText	`$projection.ControllingAreaForEdit = _StatisticalKeyFigureText.ControllingArea and $projection.StatisticalKeyFigure = _StatisticalKeyFigureText.StatisticalKeyFigure and _StatisticalKeyFigureText.Language = $session.system_language`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CSKFVALACTIT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	Statistical Key Figure Value Item	view
UI.headerInfo.typeName	Item	view
UI.headerInfo.typeNamePlural	Items	view
UI.presentationVariant.text	Statistical Key Figure Values Items	view
UI.presentationVariant.qualifier	VAR_SKFVI	view

Fields (71)

Key	Field	Source Table	Source Field	Description
KEY	ControllingAreaForEdit		ControllingAreaForEdit	Controlling Area
KEY	AccountingDocumentForEdit		AccountingDocumentForEdit	Journal Entry
KEY	AccountingDocumentItem		AccountingDocumentItem	Posting View Item
	StatisticalKeyFigureQuantity		StatisticalKeyFigureQuantity
	StstcKeyFigQuantityUnit		StstcKeyFigQuantityUnit	Quantity Unit
	UnitOfMeasureLongName	_UnitOfMeasureText	UnitOfMeasureLongName
	DocumentItemText		DocumentItemText	Text
	ControllingObject		ControllingObject	Object number
	StatisticalKeyFigure		StatisticalKeyFigure	Statistical Key Figure
	StatisticalKeyFigureName
	StstcKeyFigCategory		StstcKeyFigCategory	Category
	StstcKeyFigCategoryDesc
	ControllingBusTransacType		ControllingBusTransacType	CO Bus. Transaction
	PersonnelNumber		PersonnelNumber	Personnel No.
	FinancialManagementArea		FinancialManagementArea	FM Area
	PartnerFund		PartnerFund	Receiver Fund
	PartnerFunctionalArea		PartnerFunctionalArea	Rec. Fntcl Area
	PartnerGrant		PartnerGrant	Receiver Grant
	PartnerBudgetPeriod		PartnerBudgetPeriod	Receiver Budget Period
	ReceiverPostedFundName			Receiver Fund Name
	ReceiverPostedGrantName			Receiver Grant Name
	ReceiverPostedBudgetPeriodName			Receiver Budget Period Name
	PartnerFunctionalAreaName			Receiver Functional Area Name
	AccountAssignmentType		AccountAssignmentType	Receiver Object Type
	CostCenter		CostCenter	Receiver Cost Center
	PartnerCostCenterName	_PartnerCostCenterText	CostCenterName	Receiver Cost Center Name
	CostCtrActivityType		CostCtrActivityType	Activity Type
	PartnerCostCtrActivityTypeName	_PartnerCostCtrActivityTypeTxt	CostCtrActivityTypeName	Activity Type Name
	BusinessProcess		BusinessProcess	Receiver Business Process
	OrderID		OrderID	Receiver Order
	PartnerWBSElementExternalID		PartnerWBSElementExternalID	Receiver WBS Element
	WBSElement		WBSElement	Receiver WBS Element
	WBSDescription		WBSDescription	Receiver WBS Element Name
	SalesDocument		SalesDocument	Receiver Sales Document
	SalesDocumentItem		SalesDocumentItem	Receiver Sales Doc. Item
	ProjectNetwork		ProjectNetwork	Receiver Project Network
	NetworkActivity		NetworkActivity	Receiver Project Network Activity
	ServiceDocumentType		ServiceDocumentType	Receiver Service Doc. Type
	ServiceDocument		ServiceDocument	Receiver Service Document
	ServiceDocumentItem		ServiceDocumentItem	Receiver Service Doc. Item
	CostObject		CostObject	Receiver Cost Object
	ReceiverRECompanyCode		ReceiverRECompanyCode	Receiver Real Estate Company Code
	REPartnerBusinessEntity		REPartnerBusinessEntity	Receiver Real Estate Business Entity
	RealEstatePartnerBuilding		RealEstatePartnerBuilding	Receiver Real Estate Building
	RealEstatePartnerProperty		RealEstatePartnerProperty	Receiver Real Estate Property
	REPartnerRentalObject		REPartnerRentalObject	Receiver Real Estate Rental Object
	RealEstatePartnerContract		RealEstatePartnerContract	Receiver Real Estate Contract
	REPartnerServiceChargeKey		REPartnerServiceChargeKey	Receiver Real Estate Service Charge Key
	REPartnerSettlementUnitID		REPartnerSettlementUnitID	Receiver Real Estate Settlement Unit
	PartnerSettlementReferenceDate		PartnerSettlementReferenceDate	Receiver Real Estate Settlement Reference Date
	DocumentDate		DocumentDate	Journal Entry Date
	PostingDate		PostingDate	Posting Date for GR
	AccountingDocCreatedByUser		AccountingDocCreatedByUser	User which created overhead document
	FullName	_CreatedByContactCard	FullName	Name
	ControllingDocumentHeaderText		ControllingDocumentHeaderText
	Status		Status	Workflow Status
	StatusCriticality		StatusCriticality
	StatusName	_CostRevnReassgmtDocStatusTxt	StatusName
	AllocationPostingType		AllocationPostingType	Posting Type
	AllocationPostingTypeText	_CostRevnReassgmtPostgTypeTxt	AllocationPostingTypeText
	FiscalPeriod		FiscalPeriod	Tax period
	FiscalYear		FiscalYear	G/L Fiscal Year
	AccountingDocumentCreationDate		AccountingDocumentCreationDate	Journal Entry Date
	ReversedReferenceDocument		ReversedReferenceDocument	Reversed Reference Document
	ReversalReferenceDocument		ReversalReferenceDocument	Reversal Reference Document
	ExchangeRateDate		ExchangeRateDate	Translatn Date
	ExchangeRateType		ExchangeRateType	Exch. Rate Type
	ControllingAreaCurrency		ControllingAreaCurrency
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	ReferenceDocumentTypeName
	_CreatedByContactCard		_CreatedByContactCard

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_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: CSKFVALACTIT

CREATE VIEW C_StstclKeyFigValueActiveItem AS
SELECT
  ControllingAreaForEdit,
  AccountingDocumentForEdit,
  AccountingDocumentItem,
  StatisticalKeyFigureQuantity,
  StstcKeyFigQuantityUnit,
  _UnitOfMeasureText.UnitOfMeasureLongName AS UnitOfMeasureLongName,
  DocumentItemText,
  ControllingObject,
  StatisticalKeyFigure,
  cast(_StatisticalKeyFigureText.StatisticalKeyFigureName as fis_ui_stagr_text) AS StatisticalKeyFigureName,
  StstcKeyFigCategory,
  cast(_StatisticalKeyFigureCatText.StstcKeyFigCategoryDesc as fis_ui_grtyp_text) AS StstcKeyFigCategoryDesc,
  ControllingBusTransacType,
  PersonnelNumber,
  FinancialManagementArea,
  PartnerFund,
  PartnerFunctionalArea,
  PartnerGrant,
  PartnerBudgetPeriod,
  _PartnerFundText[1:Language = $session.system_language].FundName AS ReceiverPostedFundName,
  _PartnerGrantText[1:Language = $session.system_language].GrantName AS ReceiverPostedGrantName,
  _PartnerBudgetPeriodText[1:Language = $session.system_language].BudgetPeriodName AS ReceiverPostedBudgetPeriodName,
  _PartnerFunctionalAreaText[1:Language = $session.system_language].FunctionalAreaName AS PartnerFunctionalAreaName,
  AccountAssignmentType,
  CostCenter,
  _PartnerCostCenterText.CostCenterName AS PartnerCostCenterName,
  CostCtrActivityType,
  _PartnerCostCtrActivityTypeTxt.CostCtrActivityTypeName AS PartnerCostCtrActivityTypeName,
  BusinessProcess,
  OrderID,
  PartnerWBSElementExternalID,
  WBSElement,
  WBSDescription,
  SalesDocument,
  SalesDocumentItem,
  ProjectNetwork,
  NetworkActivity,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  CostObject,
  ReceiverRECompanyCode,
  REPartnerBusinessEntity,
  RealEstatePartnerBuilding,
  RealEstatePartnerProperty,
  REPartnerRentalObject,
  RealEstatePartnerContract,
  REPartnerServiceChargeKey,
  REPartnerSettlementUnitID,
  PartnerSettlementReferenceDate,
  DocumentDate,
  PostingDate,
  AccountingDocCreatedByUser,
  _CreatedByContactCard.FullName AS FullName,
  ControllingDocumentHeaderText,
  Status,
  StatusCriticality,
  _CostRevnReassgmtDocStatusTxt.StatusName AS StatusName,
  AllocationPostingType,
  _CostRevnReassgmtPostgTypeTxt.AllocationPostingTypeText AS AllocationPostingTypeText,
  FiscalPeriod,
  FiscalYear,
  AccountingDocumentCreationDate,
  ReversedReferenceDocument,
  ReversalReferenceDocument,
  ExchangeRateDate,
  ExchangeRateType,
  ControllingAreaCurrency,
  ReferenceDocumentType,
  _ReferenceDocumentTypeText[1:Language = $session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName
FROM P_StstclKeyFigValueActiveItem AS _Item
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON StstcKeyFigQuantityUnit = _UnitOfMeasureText.UnitOfMeasure AND _UnitOfMeasureText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON AccountingDocCreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_CostRevnReassgmtDocStatusTxt AS _CostRevnReassgmtDocStatusTxt ON Status = _CostRevnReassgmtDocStatusTxt.Status AND _CostRevnReassgmtDocStatusTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CostRevnReassgmtPostgTypeTxt AS _CostRevnReassgmtPostgTypeTxt ON AllocationPostingType = _CostRevnReassgmtPostgTypeTxt.AllocationPostingType AND _CostRevnReassgmtPostgTypeTxt.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FundText AS _PartnerFundText ON FinancialManagementArea = _PartnerFundText.FinancialManagementArea AND PartnerFund = _PartnerFundText.Fund  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _PartnerCostCtrActivityTypeTxt ON ControllingAreaForEdit = _PartnerCostCtrActivityTypeTxt.ControllingArea AND CostCtrActivityType = _PartnerCostCtrActivityTypeTxt.CostCtrActivityType AND PostingDate <= _PartnerCostCtrActivityTypeTxt.ValidityEndDate AND PostingDate >= _PartnerCostCtrActivityTypeTxt.ValidityStartDate AND _PartnerCostCtrActivityTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _PartnerCostCenterText ON ControllingAreaForEdit = _PartnerCostCenterText.ControllingArea AND CostCenter = _PartnerCostCenterText.CostCenter AND PostingDate <= _PartnerCostCenterText.ValidityEndDate AND PostingDate >= _PartnerCostCenterText.ValidityStartDate AND _PartnerCostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StatisticalKeyFigureCatText AS _StatisticalKeyFigureCatText ON StstcKeyFigCategory = _StatisticalKeyFigureCatText.StstcKeyFigCategory AND _StatisticalKeyFigureCatText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_StatisticalKeyFigureText AS _StatisticalKeyFigureText ON ControllingAreaForEdit = _StatisticalKeyFigureText.ControllingArea AND StatisticalKeyFigure = _StatisticalKeyFigureText.StatisticalKeyFigure AND _StatisticalKeyFigureText.Language = $session.system_language  -- association [0..1]
;

Depth:

C_StstclKeyFigValueActiveItem view

P_StstclKeyFigValueActiveItem view