P_FBV_RESULT_CONSID_ALT

DDL: P_FBV_RESULT_CONSID_ALT SQL: PFBV_RESCONSALT Type: view BASIC Package: ODATA_INV_BAL_SHEET_VAL_MNG
67 Fields 6 Data Sources

Alternatives of Balance Sheet Valuation Results

P_FBV_RESULT_CONSID_ALT is a Basic CDS View that provides data about "Alternatives of Balance Sheet Valuation Results" in SAP S/4HANA. It reads from 6 data sources and exposes 67 fields with key fields ValuationPriceCategory, FiscalYear, FiscalPeriod, CurrencyRole, CostEstimate. Part of development package ODATA_INV_BAL_SHEET_VAL_MNG.

Data Sources (6)

SourceAliasJoin Type
fbv_result fbv_result from
fbv_result fbv_result union_all
fbv_result fbv_result union_all
fbv_result fbv_result union_all
fbv_result fbv_result union_all
fbv_result fbv_result union_all

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PFBV_RESCONSALT view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
Search.searchable false view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey AlternativeValnPriceCategory view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY ValuationPriceCategory Valuation Alt.
KEY FiscalYear bdatj Year
KEY FiscalPeriod poper Posting periods
KEY CurrencyRole fbv_result curtype Currency Type
KEY CostEstimate kalnr ProdCostEst.No.
KEY AlternativeValnPriceCategory considered_valuation_alt_1 5. Consid. Val. Alt.
AlternativeValnPriceCatAmount considered_val_alt_value_1 Total Value
MinimumValueValuationPriceCat minimum_valuation_alt Minimum Val. Alt.
MinimumValueValuationPrCatAmt minimum_value Minimum Value
DevaluationAmount
Currency waers Transaction Currency
InventoryAmountIsConsidered is_consid_inventory_value Consider Inv. Value
KEY FiscalYear bdatj Year
KEY FiscalPeriod poper Posting periods
KEY CurrencyRole fbv_result curtype Currency Type
KEY CostEstimate kalnr ProdCostEst.No.
KEY AlternativeValnPriceCategory considered_valuation_alt_2 5. Consid. Val. Alt.
AlternativeValnPriceCatAmount considered_val_alt_value_2 Total Value
MinimumValueValuationPriceCat minimum_valuation_alt Minimum Val. Alt.
MinimumValueValuationPrCatAmt minimum_value Minimum Value
DevaluationAmount
Currency waers Transaction Currency
InventoryAmountIsConsidered is_consid_inventory_value Consider Inv. Value
KEY FiscalYear bdatj Year
KEY FiscalPeriod poper Posting periods
KEY CurrencyRole fbv_result curtype Currency Type
KEY CostEstimate kalnr ProdCostEst.No.
KEY AlternativeValnPriceCategory considered_valuation_alt_3 5. Consid. Val. Alt.
AlternativeValnPriceCatAmount considered_val_alt_value_3 Total Value
MinimumValueValuationPriceCat minimum_valuation_alt Minimum Val. Alt.
MinimumValueValuationPrCatAmt minimum_value Minimum Value
DevaluationAmount
Currency waers Transaction Currency
InventoryAmountIsConsidered is_consid_inventory_value Consider Inv. Value
KEY FiscalYear bdatj Year
KEY FiscalPeriod poper Posting periods
KEY CurrencyRole fbv_result curtype Currency Type
KEY CostEstimate kalnr ProdCostEst.No.
KEY AlternativeValnPriceCategory considered_valuation_alt_4 5. Consid. Val. Alt.
AlternativeValnPriceCatAmount considered_val_alt_value_4 Total Value
MinimumValueValuationPriceCat minimum_valuation_alt Minimum Val. Alt.
MinimumValueValuationPrCatAmt minimum_value Minimum Value
DevaluationAmount
Currency waers Transaction Currency
InventoryAmountIsConsidered is_consid_inventory_value Consider Inv. Value
KEY FiscalYear bdatj Year
KEY FiscalPeriod poper Posting periods
KEY CurrencyRole fbv_result curtype Currency Type
KEY CostEstimate kalnr ProdCostEst.No.
KEY AlternativeValnPriceCategory considered_valuation_alt_5 5. Consid. Val. Alt.
AlternativeValnPriceCatAmount considered_val_alt_value_5 Total Value
MinimumValueValuationPriceCat minimum_valuation_alt Minimum Val. Alt.
MinimumValueValuationPrCatAmt minimum_value Minimum Value
DevaluationAmount
Currency waers Transaction Currency
InventoryAmountIsConsidered is_consid_inventory_value Consider Inv. Value
KEY FiscalYear bdatj Year
KEY FiscalPeriod poper Posting periods
KEY CurrencyRole fbv_result curtype Currency Type
KEY CostEstimate kalnr ProdCostEst.No.
KEY AlternativeValnPriceCategory 5. Consid. Val. Alt.
AlternativeValnPriceCatAmount salk3 Total Value
MinimumValueValuationPriceCat minimum_valuation_alt Minimum Val. Alt.
MinimumValueValuationPrCatAmt minimum_value Minimum Value
DevaluationAmount 0
Currency waers Transaction Currency
InventoryAmountIsConsidered is_consid_inventory_value Consider Inv. Value

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 P_FBV_RESULT_CONSID_ALT.
-- 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.
-- SQL view name: PFBV_RESCONSALT

CREATE VIEW P_FBV_RESULT_CONSID_ALT AS
SELECT
  cast( prkzg as fbv_valuation_alternative ) AS ValuationPriceCategory,
  bdatj AS FiscalYear,
  poper AS FiscalPeriod,
  fbv_result.curtype AS CurrencyRole,
  kalnr AS CostEstimate,
  considered_valuation_alt_1 AS AlternativeValnPriceCategory,
  considered_val_alt_value_1 AS AlternativeValnPriceCatAmount,
  minimum_valuation_alt AS MinimumValueValuationPriceCat,
  minimum_value AS MinimumValueValuationPrCatAmt,
  salk3 - considered_val_alt_value_1 AS DevaluationAmount,
  waers AS Currency,
  is_consid_inventory_value AS InventoryAmountIsConsidered
FROM fbv_result
-- UNION ALL with additional select branch(es): fbv_result
;

Learn More