P_FBV_RESULT

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.
-- 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_RESULT

CREATE VIEW P_FBV_RESULT AS
SELECT
  cast( prkzg as fbv_valuation_alternative ) AS ValuationPriceCategory,
  bdatj AS FiscalYear,
  poper AS FiscalPeriod,
  fbv_result.curtype AS CurrencyRole,
  kalnr AS CostEstimate,
  fbv_result.rldnr AS Ledger,
  matnr AS Material,
  fbv_result.bwkey AS ValuationArea,
  bwtar AS InventoryValuationType,
  bukrs AS CompanyCode,
  cast (fbv_result.bwkey as werks_d) AS Plant,
  prctr AS ProfitCenter,
  Segment,
  valuation_level AS BalanceSheetValuationLevel,
  deval_level AS DevaluationDeterminationLevel,
  prcid AS BalanceSheetValuationProcedure,
  ct.valutyp AS AccountingValuationView,
  material_acc_age AS MatlAccountingDataAgeInPeriods,
  mtart AS MaterialType,
  racct AS GLAccount,
  cast( concat(awref, aworg) as fis_awkey) AS OriginalReferenceDocument,
  cast (awref as fis_awref) AS ReferenceDocument,
  cast (awtyp as fis_awtyp) AS OriginalReferenceDocumentType,
  cast (accounting_document as fis_belnr) AS AccountingDocument,
  delta_run_id AS BalShtValuationDeltaPostingRun,
  cast (reverse_accounting_document as fis_stblg) AS ReverseDocument,
  cast (reverse_fiscal_year as fis_stjah) AS ReverseDocumentFiscalYear,
  meins AS ValuationQuantityUnit,
  waers AS Currency,
  peinh AS MaterialPriceUnitQty,
  inventory_price AS InventoryPrice,
  price_numerator AS ValuationPriceNumeratorAmount,
  price_denominator AS ValuationPriceDenominatorQty,
  salk3 AS TotalValuatedStockAmount,
  lbkum AS TotalVltdStockQuantity,
  cons_qty_wght AS WgtdConsumptionTotalQuantity,
  cons_qty_wght_avg AS WgtdConsumptionAverageQuantity,
  stock_qty_wght_avg AS WeightedStockAverageQuantity,
  receipt_qty_wght AS WeightedReceiptTotalQuantity,
  rnge_of_cvrg AS CoverageRangePeriods,
  deval_prc AS DevaluationPercent,
  pri_sel_id AS ValnPriceCategoryDetermination,
  pri_sel_va AS BaseValuationPriceCategory,
  base_price AS BalanceSheetValuationBasePrice,
  cons_threshold AS CnsmpnQtyThresholdPercent,
  receipt_threshold AS ReceiptQtyThresholdPercent,
  mr_deval_keyf_old AS DevaluationYearCount,
  mr_deval_keyf_new AS FutureNumberOfDevaluationYears,
  mov_rate_prc AS InventoryMovementRateInPercent,
  cons_mov_rate_prc AS CnsmpnMovementRateInPercent,
  receipt_mov_rate_prc AS ReceiptMovementRateInPercent,
  material_acc_exclusion_date AS MatlAcctgDataProcgCutoffDate,
  deval_keyf_ref_fiscyear AS DevaluationKeyFigureFiscalYear,
  deval_keyf_ref_fiscper AS DevaluationKeyFigFiscalPeriod,
  is_release_mr_keyf AS MovementRateKeyFigIsReleased,
  is_consid_inventory_value AS InventoryAmountIsConsidered,
  considered_valuation_alt_1 AS AlternativeValnPriceCategory1,
  considered_val_alt_value_1 AS AlternativeValnPriceCat1Amount,
  considered_valuation_alt_2 AS AlternativeValnPriceCategory2,
  considered_val_alt_value_2 AS AlternativeValnPriceCat2Amount,
  considered_valuation_alt_3 AS AlternativeValnPriceCategory3,
  considered_val_alt_value_3 AS AlternativeValnPriceCat3Amount,
  considered_valuation_alt_4 AS AlternativeValnPriceCategory4,
  considered_val_alt_value_4 AS AlternativeValnPriceCat4Amount,
  considered_valuation_alt_5 AS AlternativeValnPriceCategory5,
  considered_val_alt_value_5 AS AlternativeValnPriceCat5Amount,
  minimum_valuation_alt AS MinimumValueValuationPriceCat,
  minimum_value AS MinimumValueValuationPrCatAmt,
  deval_exclude_reason AS DevaluationExclusionReason,
  cast( balloghndl as abap.sstring(22) ) AS LogHandle,
  cast( posting_log_handle as abap.sstring(22) ) AS PostingApplicationLogHandle,
  posting_state AS AccountingDocumentPostgStatus,
  is_convert_other_curtypes AS DevaluationAmtIsCrcyConverted,
  CONCAT(bdatj, SUBSTRING(poper, 2, 2)) AS BalanceSheetValuationPeriod
FROM fbv_result
;