FPCV_AI_VAL_VAR_PLANT

DDL: FPCV_AI_VAL_VAR_PLANT Type: view_entity Package: FINS_PCP_CUST_AI

Valuation Variant per Plant

FPCV_AI_VAL_VAR_PLANT is a CDS View that provides data about "Valuation Variant per Plant" in SAP S/4HANA. It reads from 3 data sources (I_CostingValuationVarText, I_Plant, tck35) and exposes 45 fields with key fields bwvar, werks. Part of development package FINS_PCP_CUST_AI.

3 data source(s) 45 fields

Data Sources (3)

SourceAliasJoin Type
I_CostingValuationVarText _CostingValuationVarText left_outer
I_Plant _Plant left_outer
tck35 tck35 from

Annotations (6)

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

Fields (45)

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

    left outer join I_CostingValuationVarText as _CostingValuationVarText on  tck35.bwvar                       = _CostingValuationVarText.ValuationVariant
                                                                          and _CostingValuationVarText.Language = 'E'
    left outer join I_Plant                   as _Plant                   on tck35.werks = _Plant.Plant

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

Learn More