FPCV_AI_VAL_VAR

DDL: FPCV_AI_VAL_VAR Type: view_entity Package: FINS_PCP_CUST_AI

Valuation Variant

FPCV_AI_VAL_VAR is a CDS View that provides data about "Valuation Variant" in SAP S/4HANA. It reads from 2 data sources (I_CostingValuationVarText, tck05) and exposes 43 fields with key field bwvar. Part of development package FINS_PCP_CUST_AI.

2 data source(s) 43 fields

Data Sources (2)

SourceAliasJoin Type
I_CostingValuationVarText _CostingValuationVarText left_outer
tck05 tck05 from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Valuation Variant view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY bwvar tck05 bwvar
ValuationVariantName I_CostingValuationVarText ValuationVariantName
bwsm1 tck05 bwsm1
bwsm2 tck05 bwsm2
bwsm3 tck05 bwsm3
bwsm4 tck05 bwsm4
bwsm5 tck05 bwsm5
prkzg1 tck05 prkzg1
prkzg2 tck05 prkzg2
prkzg3 tck05 prkzg3
prkzg4 tck05 prkzg4
prkzg5 tck05 prkzg5
bwse1 tck05 bwse1
bwse2 tck05 bwse2
bwse3 tck05 bwse3
matsubstrat1 tck05 matsubstrat1
matsubstrat2 tck05 matsubstrat2
matsubstrat3 tck05 matsubstrat3
bwma1 tck05 bwma1
bwma2 tck05 bwma2
bwma3 tck05 bwma3
bwma5 tck05 bwma5
bwma4 tck05 bwma4
bwsf1 tck05 bwsf1
bwsf2 tck05 bwsf2
bwsf3 tck05 bwsf3
bwsv1 tck05 bwsv1
bwsv2 tck05 bwsv2
bwsv3 tck05 bwsv3
bwsfh tck05 bwsfh
kalsm tck05 kalsm
kalsm_raw tck05 kalsm_raw
zuart tck05 zuart
plisqut tck05 plisqut
lobezus tck05 lobezus
pertarif tck05 pertarif
versn tck05 versn
category tck05 category
con_fin_mpl1 tck05 con_fin_mpl1
con_fin_mpl2 tck05 con_fin_mpl2
con_fin_mpl3 tck05 con_fin_mpl3
con_fin_mpl4 tck05 con_fin_mpl4
con_fin_mpl5 tck05 con_fin_mpl5 
@AbapCatalog.viewEnhancementCategory: [ #NONE ]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Valuation Variant'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
}
define view entity FPCV_AI_VAL_VAR
  as select from    tck05

    left outer join I_CostingValuationVarText as _CostingValuationVarText on  tck05.bwvar                       = _CostingValuationVarText.ValuationVariant
                                                                          and _CostingValuationVarText.Language = 'E'

{
  key tck05.bwvar,

      _CostingValuationVarText.ValuationVariantName,
      tck05.bwsm1,
      tck05.bwsm2,
      tck05.bwsm3,
      tck05.bwsm4,
      tck05.bwsm5,
      tck05.prkzg1,
      tck05.prkzg2,
      tck05.prkzg3,
      tck05.prkzg4,
      tck05.prkzg5,
      tck05.bwse1,
      tck05.bwse2,
      tck05.bwse3,
      tck05.matsubstrat1,
      tck05.matsubstrat2,
      tck05.matsubstrat3,
      tck05.bwma1,
      tck05.bwma2,
      tck05.bwma3,
      tck05.bwma5,
      tck05.bwma4,
      tck05.bwsf1,
      tck05.bwsf2,
      tck05.bwsf3,
      tck05.bwsv1,
      tck05.bwsv2,
      tck05.bwsv3,
      tck05.bwsfh,
      tck05.kalsm,
      tck05.kalsm_raw,
      tck05.zuart,
      tck05.plisqut,
      tck05.lobezus,
      tck05.pertarif,
      tck05.versn,
      tck05.category,
      tck05.con_fin_mpl1,
      tck05.con_fin_mpl2,
      tck05.con_fin_mpl3,
      tck05.con_fin_mpl4,
      tck05.con_fin_mpl5
}

Learn More