C_CostingVariantValueHelp

DDL: C_COSTINGVARIANTVALUEHELP Type: view CONSUMPTION
13 Fields 1 Data Sources 1 Associations

Costing Variant Value Help

C_CostingVariantValueHelp is a Consumption CDS View that provides data about "Costing Variant Value Help" in SAP S/4HANA. It reads from 1 data source (I_CostingVariant) and exposes 13 fields with key field CostingVariant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CostingVariant CostingVariant from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ControllingValuationType _ControllingValuationType $projection.AccountingValuationView = _ControllingValuationType.ControllingValuationType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CFICOSTVARVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Costing Variant Value Help view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CostingVariant I_CostingVariant CostingVariant Costing Variant
CostingVariantName
ValuationVariant I_CostingVariant ValuationVariant Valuation Variant
CostEstimateReferenceVariant I_CostingVariant CostEstimateReferenceVariant Reference Var.
Ledger CostingType Ledger Ledger
LedgerName
OverheadCostingSheet
ExtProcuredMatlOvhdCostingSht
AccountingValuationView CostingType ControllingValuationType
AccountingValuationViewName
_CostingValuationVariant I_CostingVariant _CostingValuationVariant
CostEstimateTransferControl CostEstimateTransferControl Transfer Control
CostEstTransfCtrlIsChangeable CostEstTransfCtrlIsChangeable Changeable

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_CostingVariantValueHelp.
-- 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.

CREATE VIEW C_CostingVariantValueHelp AS
SELECT
  CostingVariant.CostingVariant AS CostingVariant,
  CostingVariant._Text[Language=$session.system_language].CostingVariantName AS CostingVariantName,
  CostingVariant.ValuationVariant AS ValuationVariant,
  CostingVariant.CostEstimateReferenceVariant AS CostEstimateReferenceVariant,
  CostingType.Ledger AS Ledger,
  CostingType._LedgerText[Language=$session.system_language].LedgerName AS LedgerName,
  CostingVariant._CostingValuationVariant.OverheadCostingSheet AS OverheadCostingSheet,
  CostingVariant._CostingValuationVariant.ExtProcuredMatlOvhdCostingSht AS ExtProcuredMatlOvhdCostingSht,
  CostingType.ControllingValuationType AS AccountingValuationView,
  cast(_ControllingValuationType._Text[Language=$session.system_language].ControllingValuationTypeName as fpc_vdm_valview_name preserving type ) AS AccountingValuationViewName,
  CostingVariant._CostingValuationVariant AS _CostingValuationVariant,
  CostEstimateTransferControl,
  CostEstTransfCtrlIsChangeable
FROM I_CostingVariant AS CostingVariant
LEFT OUTER JOIN I_ControllingValuationType AS _ControllingValuationType ON AccountingValuationView = _ControllingValuationType.ControllingValuationType  -- association [0..1]
;

Learn More