P_RO_StRpFixedAssetChartValue

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_RO_StRpFixedAssetChartValue.
-- 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: PROSRFACHTVATR
-- Parameters: P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_NationalClsfctnSourceField : fiaagen_natl_clfn_srce_fld

CREATE VIEW P_RO_StRpFixedAssetChartValue AS
SELECT
  I_FixedAssetValue.CompanyCode AS CompanyCode,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  I_FixedAssetValue.Ledger AS Ledger,
  I_FixedAssetValue.FiscalYear AS FiscalYear,
  I_FixedAssetValue.FiscalPeriod AS FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetAcctTransClassfctn,
  AssetAccountingKeyFigure,
  AssetAccountingKeyFigureSet,
  AccountingDocument,
  TransactionSubitem,
  ControllingArea,
  AssetClass,
  AssetCapitalizationDate,
  Inventory,
  AssetSerialNumber,
  Country,
  FixedAssetGroup,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  Group5AssetEvaluationKey,
  case when (AssetValueDate = '00000000' or AssetValueDate is null) then PostingDate else AssetValueDate end AS AssetValueDate,
  AccountingDocumentType,
  DebitCreditCode,
  AssetTransactionType,
  DocumentItemText,
  AssignmentReference,
  BaseUnit,
  Quantity,
  CompanyCodeCurrency,
  cast( AmountInCompanyCodeCurrency as fis_hsl ) AS AmountInCompanyCodeCurrency,
  ChartOfDepreciation,
  LedgerFiscalYear,
  I_FixedAssetValue.FiscalYearVariant AS FiscalYearVariant,
  I_FixedAssetValue.FiscalYearPeriod AS FiscalYearPeriod,
  I_FixedAssetValue.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  I_FixedAssetValue._CompanyCode AS _CompanyCode,
  I_FixedAssetValue._Ledger AS _Ledger,
  I_FixedAssetValue._FiscalYear AS _FiscalYear,
  I_FixedAssetValue._FiscalYearVariant AS _FiscalYearVariant,
  _FixedAsset.AssetManufacturerName AS AssetManufacturerName
FROM I_FixedAssetValue
INNER JOIN I_FiscalYearPeriodForLedger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Group1AssetEvaluationKey AS _EvaluationGroup1 ON Group1AssetEvaluationKey = _EvaluationGroup1.Group1AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group2AssetEvaluationKey AS _EvaluationGroup2 ON Group2AssetEvaluationKey = _EvaluationGroup2.Group2AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group3AssetEvaluationKey AS _EvaluationGroup3 ON Group3AssetEvaluationKey = _EvaluationGroup3.Group3AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group4AssetEvaluationKey AS _EvaluationGroup4 ON Group4AssetEvaluationKey = _EvaluationGroup4.Group4AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_Group5AssetEvaluationKey AS _EvaluationGroup5 ON Group5AssetEvaluationKey = _EvaluationGroup5.Group5AssetEvaluationKey  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetNatlClfn AS _FixedAssetNatlClfn ON Country = _FixedAssetNatlClfn.Country AND NationalClassification = _FixedAssetNatlClfn.NationalClassification  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
;