I_CostingVariant

DDL: I_COSTINGVARIANT Type: view BASIC

Costing Variant

I_CostingVariant is a Basic CDS View (Dimension) that provides data about "Costing Variant" in SAP S/4HANA. It reads from 1 data source (tck03) and exposes 10 fields with key field CostingVariant. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
tck03 tck03 from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_CostingVariantText _Text $projection.CostingVariant = _Text.CostingVariant
[0..1] I_CostingValuationVariant _CostingValuationVariant $projection.ValuationVariant = _CostingValuationVariant.ValuationVariant
[0..1] I_CostingType _CostingType $projection.CostingType = _CostingType.CostingType

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IFICOSTGVARIANT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey CostingVariant view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Costing Variant view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CostingVariant klvar
ValuationVariant bwvar
CostEstimateReferenceVariant refid
CostingType kalka
CostEstimateTransferControl uebid
CostEstTransfCtrlIsChangeable voraend
CostingReferenceObject bzobj
_Text _Text
_CostingValuationVariant _CostingValuationVariant
_CostingType _CostingType
@AbapCatalog: {
  sqlViewName: 'IFICOSTGVARIANT',
  compiler.compareFilter: true,
  preserveKey: true }
@ClientHandling: {
  type: #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE }
@Analytics: {
  dataCategory: #DIMENSION,
   internalName: #LOCAL }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API }
@ObjectModel: {
  representativeKey: 'CostingVariant',
  usageType: {
    serviceQuality: #A,
    sizeCategory: #S,
    dataClass: #CUSTOMIZING },
    supportedCapabilities: [
      #ANALYTICAL_DIMENSION,
      #CDS_MODELING_ASSOCIATION_TARGET,
      #SQL_DATA_SOURCE,
      #CDS_MODELING_DATA_SOURCE ],
  modelingPattern: #ANALYTICAL_DIMENSION }
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Costing Variant'

define view I_CostingVariant
  as select from tck03
  association [0..*] to I_CostingVariantText as _Text on $projection.CostingVariant = _Text.CostingVariant
  association [0..1] to I_CostingValuationVariant as _CostingValuationVariant on $projection.ValuationVariant = _CostingValuationVariant.ValuationVariant
  association [0..1] to I_CostingType as _CostingType on $projection.CostingType = _CostingType.CostingType

{
      @ObjectModel.text.association: '_Text'
  key klvar as CostingVariant,
      @ObjectModel.foreignKey.association: '_CostingValuationVariant'
      bwvar as ValuationVariant,
      refid as CostEstimateReferenceVariant,
      @ObjectModel.foreignKey.association: '_CostingType'
      kalka as CostingType,
      uebid as CostEstimateTransferControl,
      voraend as CostEstTransfCtrlIsChangeable,
      bzobj   as CostingReferenceObject,

      _Text,
      _CostingValuationVariant,
      _CostingType
}