FPCV_AI_VAL_VAR_PLANT

DDL: FPCV_AI_VAL_VAR_PLANT Type: view_entity Package: FINS_PCP_CUST_AI
45 Fields 3 Data Sources

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.

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 Valuation Variant
KEY werks tck35 werks Receiving Plant
ValuationVariantName I_CostingValuationVarText ValuationVariantName
PlantName I_Plant PlantName Plant Name
bwsm1 tck35 bwsm1 Material Vltn
bwsm2 tck35 bwsm2 Material Vltn
bwsm3 tck35 bwsm3 Material Vltn
bwsm4 tck35 bwsm4 Material Vltn
bwsm5 tck35 bwsm5 Material Vltn
prkzg1 tck35 prkzg1 Valuation Alt.
prkzg2 tck35 prkzg2 Valuation Alt.
prkzg3 tck35 prkzg3 Valuation Alt.
prkzg4 tck35 prkzg4 Valuation Alt.
prkzg5 tck35 prkzg5 Valuation Alt.
bwse1 tck35 bwse1 Vltn Int.Act/Pr
bwse2 tck35 bwse2 Vltn Int.Act/Pr
bwse3 tck35 bwse3 Vltn Int.Act/Pr
matsubstrat1 tck35 matsubstrat1 Substr.InfoRec.
matsubstrat2 tck35 matsubstrat2 Substr.InfoRec.
matsubstrat3 tck35 matsubstrat3 Substr.InfoRec.
bwma1 tck35 bwma1 Additive Val.
bwma2 tck35 bwma2 Additive Val.
bwma3 tck35 bwma3 Additive Val.
bwma5 tck35 bwma5 Additive Val.
bwma4 tck35 bwma4 Additive Val.
bwsf1 tck35 bwsf1 Vltn Subcontrct
bwsf2 tck35 bwsf2 Vltn Subcontrct
bwsf3 tck35 bwsf3 Vltn Subcontrct
bwsv1 tck35 bwsv1 Valuation Ext. Proc.
bwsv2 tck35 bwsv2 Valuation Ext. Proc.
bwsv3 tck35 bwsv3 Valuation Ext. Proc.
bwsfh tck35 bwsfh Vltn PRT
kalsm tck35 kalsm Search Proced.
kalsm_raw tck35 kalsm_raw Costing Sheet
zuart tck35 zuart Overhead Type
plisqut tck35 plisqut PlanActQuotaArrgt
lobezus tck35 lobezus Overhead Subcon Mat.
pertarif tck35 pertarif SchedActivPricCal
versn tck35 versn Version
category tck35 category Violation Category
con_fin_mpl1 tck35 con_fin_mpl1 Price Type
con_fin_mpl2 tck35 con_fin_mpl2 Price Type
con_fin_mpl3 tck35 con_fin_mpl3 Price Type
con_fin_mpl4 tck35 con_fin_mpl4 Price Type
con_fin_mpl5 tck35 con_fin_mpl5 Price Type

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 FPCV_AI_VAL_VAR_PLANT.
-- 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 FPCV_AI_VAL_VAR_PLANT AS
SELECT
  tck35.bwvar AS bwvar,
  tck35.werks AS werks,
  _CostingValuationVarText.ValuationVariantName AS ValuationVariantName,
  _Plant.PlantName AS PlantName,
  tck35.bwsm1 AS bwsm1,
  tck35.bwsm2 AS bwsm2,
  tck35.bwsm3 AS bwsm3,
  tck35.bwsm4 AS bwsm4,
  tck35.bwsm5 AS bwsm5,
  tck35.prkzg1 AS prkzg1,
  tck35.prkzg2 AS prkzg2,
  tck35.prkzg3 AS prkzg3,
  tck35.prkzg4 AS prkzg4,
  tck35.prkzg5 AS prkzg5,
  tck35.bwse1 AS bwse1,
  tck35.bwse2 AS bwse2,
  tck35.bwse3 AS bwse3,
  tck35.matsubstrat1 AS matsubstrat1,
  tck35.matsubstrat2 AS matsubstrat2,
  tck35.matsubstrat3 AS matsubstrat3,
  tck35.bwma1 AS bwma1,
  tck35.bwma2 AS bwma2,
  tck35.bwma3 AS bwma3,
  tck35.bwma5 AS bwma5,
  tck35.bwma4 AS bwma4,
  tck35.bwsf1 AS bwsf1,
  tck35.bwsf2 AS bwsf2,
  tck35.bwsf3 AS bwsf3,
  tck35.bwsv1 AS bwsv1,
  tck35.bwsv2 AS bwsv2,
  tck35.bwsv3 AS bwsv3,
  tck35.bwsfh AS bwsfh,
  tck35.kalsm AS kalsm,
  tck35.kalsm_raw AS kalsm_raw,
  tck35.zuart AS zuart,
  tck35.plisqut AS plisqut,
  tck35.lobezus AS lobezus,
  tck35.pertarif AS pertarif,
  tck35.versn AS versn,
  tck35.category AS category,
  tck35.con_fin_mpl1 AS con_fin_mpl1,
  tck35.con_fin_mpl2 AS con_fin_mpl2,
  tck35.con_fin_mpl3 AS con_fin_mpl3,
  tck35.con_fin_mpl4 AS con_fin_mpl4,
  tck35.con_fin_mpl5 AS con_fin_mpl5
FROM tck35
LEFT OUTER JOIN I_CostingValuationVarText AS _CostingValuationVarText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS _Plant ON /* join condition not captured in parsed metadata */
;

Learn More