I_CostingValuationVariant

DDL: I_COSTINGVALUATIONVARIANT Type: view BASIC Package: FINS_PCP_CUST_VDM

Valuation Variant in Costing

I_CostingValuationVariant is a Basic CDS View (Dimension) that provides data about "Valuation Variant in Costing" in SAP S/4HANA. It reads from 1 data source (tck05) and exposes 6 fields with key field ValuationVariant. It has 3 associations to related views. Part of development package FINS_PCP_CUST_VDM.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
tck05 tck05 from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_CostingValuationVarText _Text $projection.ValuationVariant = _Text.ValuationVariant
[0..1] I_CostingSheetProcedure _CostingSheetText $projection.OverheadCostingSheet = _CostingSheetText.CostingSheetProcedure and _CostingSheetText.ConditionApplication = 'KA' and _CostingSheetText.ConditionUsage = 'A'
[0..1] I_CostingSheetProcedure _CostingSheetExtText $projection.ExtProcuredMatlOvhdCostingSht = _CostingSheetExtText.CostingSheetProcedure and _CostingSheetExtText.ConditionApplication = 'KA' and _CostingSheetExtText.ConditionUsage = 'A'

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IFICOSTVALNVAR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name CostingValuationVariant view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ValuationVariant view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
EndUserText.label Valuation Variant in Costing view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ValuationVariant bwvar
OverheadCostingSheet kalsm
ExtProcuredMatlOvhdCostingSht
_Text _Text
_CostingSheetText _CostingSheetText
_CostingSheetExtText _CostingSheetExtText 
@AbapCatalog: {
  sqlViewName: 'IFICOSTVALNVAR',
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API }
@Analytics: {
  dataCategory: #DIMENSION,
  dataExtraction.enabled: true
}
@ObjectModel: {
  sapObjectNodeType.name: 'CostingValuationVariant',
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory: #S
  },
  supportedCapabilities: [
    #ANALYTICAL_DIMENSION,
    #CDS_MODELING_ASSOCIATION_TARGET,
    #SQL_DATA_SOURCE,
    #CDS_MODELING_DATA_SOURCE,
    #EXTRACTION_DATA_SOURCE,
    #SEARCHABLE_ENTITY ],
  modelingPattern: #ANALYTICAL_DIMENSION,
  representativeKey: 'ValuationVariant'
}
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true
@EndUserText.label: 'Valuation Variant in Costing'

define view I_CostingValuationVariant
  as select from tck05
  association [0..*] to I_CostingValuationVarText as _Text                on  $projection.ValuationVariant = _Text.ValuationVariant
  association [0..1] to I_CostingSheetProcedure   as _CostingSheetText    on  $projection.OverheadCostingSheet       = _CostingSheetText.CostingSheetProcedure
                                                                          and _CostingSheetText.ConditionApplication = 'KA'
                                                                          and _CostingSheetText.ConditionUsage       = 'A'

  association [0..1] to I_CostingSheetProcedure   as _CostingSheetExtText on  $projection.ExtProcuredMatlOvhdCostingSht = _CostingSheetExtText.CostingSheetProcedure
                                                                          and _CostingSheetExtText.ConditionApplication = 'KA'
                                                                          and _CostingSheetExtText.ConditionUsage       = 'A'
{
      @Search: {
        defaultSearchElement: true,
        ranking: #HIGH
      }
      @ObjectModel.text.association: '_Text'
  key bwvar                                            as ValuationVariant,
  
      kalsm                                            as OverheadCostingSheet,
      
      cast(kalsm_raw as fml_kalsm_raw preserving type) as ExtProcuredMatlOvhdCostingSht,


      _Text,
      _CostingSheetText,
      _CostingSheetExtText
}

Learn More