C_BalanceSheetValuation

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 C_BalanceSheetValuation.
-- 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: CBALSHTVAL

CREATE VIEW C_BalanceSheetValuation AS
SELECT
  ValuationPriceCategory,
  FiscalYear,
  FiscalPeriod,
  CurrencyRole,
  CostEstimate,
  Material,
  ValuationArea,
  InventoryValuationType,
  cast(cast(concat(FiscalYear,FiscalPeriod) as char07 preserving type) as fins_fyearperiod) AS FiscalYearPeriod,
  Ledger,
  CompanyCode,
  Plant,
  ProfitCenter,
  Segment,
  _Plant.PlantName AS PlantName,
  BalanceSheetValuationLevel,
  DevaluationDeterminationLevel,
  BalanceSheetValuationProcedure,
  cast( AccountingValuationViewName as fml_umip_valuviewname preserving type ) AS AccountingValuationViewName,
  MaterialType,
  cast( _MaterialType._Text[1:Language = $session.system_language ].MaterialTypeName as mtbez preserving type ) AS MaterialTypeName,
  MatlAccountingDataAgeInPeriods,
  ChartOfAccounts,
  GLAccount,
  ReferenceDocument,
  OriginalReferenceDocument,
  OriginalReferenceDocumentType,
  AccountingDocument,
  AccountingDocumentPostgStatus,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  ValuationQuantityUnit,
  Currency,
  MaterialPriceUnitQty,
  cast( _Material._Text[1:Language = $session.system_language ].ProductName as maktx preserving type ) AS MaterialName,
  _ProductValuation.ValuationClass AS MaterialValuationClass,
  cast( _ProductValuation._ValuationClassText[1:Language = $session.system_language ].ValuationClassDescription as fml_valuation_class_txt preserving type ) AS ValuationClassDescription,
  _ProductValuation.InventoryValuationProcedure AS MaterialPriceControl,
  InventoryPrice,
  ValuationPriceNumeratorAmount,
  ValuationPriceDenominatorQty,
  cast (TotalValuatedStockAmount as fml_salk3) AS TotalValuatedStockAmount,
  TotalVltdStockQuantity,
  BalanceSheetValuationPrice,
  BalSheetValuationTotalAmount,
  WgtdConsumptionAverageQuantity,
  WgtdConsumptionTotalQuantity,
  WeightedStockAverageQuantity,
  WeightedReceiptTotalQuantity,
  CoverageRangePeriods,
  DevaluationPercent,
  DevaluationAmount,
  ValnPriceCategoryDetermination,
  BaseValuationPriceCategory,
  BalanceSheetValuationBasePrice,
  CnsmpnQtyThresholdPercent,
  ReceiptQtyThresholdPercent,
  DevaluationYearCount,
  FutureNumberOfDevaluationYears,
  InventoryMovementRateInPercent,
  DevaluationExclusionReason,
  CnsmpnMovementRateInPercent,
  ReceiptMovementRateInPercent,
  MatlAcctgDataProcgCutoffDate,
  DevaluationKeyFigureFiscalYear,
  DevaluationKeyFigFiscalPeriod,
  MovementRateKeyFigIsReleased,
  InventoryAmountIsConsidered,
  AlternativeValnPriceCategory1,
  AlternativeValnPriceCat1Amount,
  AlternativeValnPriceCategory2,
  AlternativeValnPriceCat2Amount,
  AlternativeValnPriceCategory3,
  AlternativeValnPriceCat3Amount,
  AlternativeValnPriceCategory4,
  AlternativeValnPriceCat4Amount,
  AlternativeValnPriceCategory5,
  AlternativeValnPriceCat5Amount,
  MinimumValueValuationPriceCat,
  MinimumValueValuationPrCatAmt,
  'MMMY' AS ApplicationLogObject,
  LogHandle,
  cast( 0 as fbv_created_date_time ) AS ExecutionRunDateTime,
  cast( ' ' as fbv_created_by preserving type) AS CreatedByUser,
  cast( ' ' as balognr preserving type) AS ApplicationLog,
  InventoryGLAccount,
  RevaluationGLAccount,
  cast( 0 as fbv_posting_created_date_time ) AS PostingExecutionRunDateTime,
  cast( ' ' as fbv_posting_created_by preserving type) AS PostingCreatedByUser,
  cast( ' ' as fbv_posting_log_number preserving type) AS PostingApplicationLog,
  PostingApplicationLogHandle
FROM I_BalanceSheetValuation
LEFT OUTER JOIN I_ProductValuation AS _ProductValuation ON Material = _ProductValuation.Product AND ValuationArea = _ProductValuation.ValuationArea AND InventoryValuationType = _ProductValuation.ValuationType  -- association [0..1]
LEFT OUTER JOIN I_Matlvaluationclasstext AS _Matlvaluationclasstext ON MaterialValuationClass = _Matlvaluationclasstext.MaterialValuationClass  -- association [0..*]
LEFT OUTER JOIN I_MaterialPriceControlName AS _MaterialPriceControlName ON MaterialPriceControl = _MaterialPriceControlName.MaterialPriceControl  -- association [0..*]
LEFT OUTER JOIN C_BalShtValuationObjPgHistory AS _BalShtValuationObjPgHistory ON ValuationPriceCategory = _BalShtValuationObjPgHistory.ValuationPriceCategory AND CurrencyRole = _BalShtValuationObjPgHistory.CurrencyRole AND CostEstimate = _BalShtValuationObjPgHistory.CostEstimate  -- association [0..*]
LEFT OUTER JOIN C_BalShtValuationObjPgHistory AS _BalShtValuationObjPgCategory ON FiscalYear = _BalShtValuationObjPgCategory.FiscalYear AND FiscalPeriod = _BalShtValuationObjPgCategory.FiscalPeriod AND CurrencyRole = _BalShtValuationObjPgCategory.CurrencyRole AND CostEstimate = _BalShtValuationObjPgCategory.CostEstimate  -- association [0..*]
LEFT OUTER JOIN C_BalShtValnObjPgAlternative AS _BalShtValnObjPgAlternative ON ValuationPriceCategory = _BalShtValnObjPgAlternative.ValuationPriceCategory AND FiscalYear = _BalShtValnObjPgAlternative.FiscalYear AND FiscalPeriod = _BalShtValnObjPgAlternative.FiscalPeriod AND CurrencyRole = _BalShtValnObjPgAlternative.CurrencyRole AND CostEstimate = _BalShtValnObjPgAlternative.CostEstimate  -- association [0..*]
LEFT OUTER JOIN C_BalShtValnObjPgAlternative AS _BalShtValnObjPgAltChart ON ValuationPriceCategory = _BalShtValnObjPgAltChart.ValuationPriceCategory AND FiscalYear = _BalShtValnObjPgAltChart.FiscalYear AND FiscalPeriod = _BalShtValnObjPgAltChart.FiscalPeriod AND CurrencyRole = _BalShtValnObjPgAltChart.CurrencyRole AND CostEstimate = _BalShtValnObjPgAltChart.CostEstimate AND _BalShtValnObjPgAltChart.BalSheetValuationIsCalculated = 'X'  -- association [0..*]
;