P_FixedAssetValueCube

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_FixedAssetValueCube.
-- 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: PFASSETVALUECUBE
-- Parameters: P_CurrencyRole : fis_curtp, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper, P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW P_FixedAssetValueCube 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,
  DebitCreditCode,
  LedgerFiscalYear,
  I_FixedAssetValue.FiscalYearVariant AS FiscalYearVariant,
  I_FixedAssetValue.FiscalYearPeriod AS FiscalYearPeriod,
  DepreciationFiscalPeriod,
  PlannedValueIsInclusive,
  AssetAccountingSortedKeyFigure,
  LedgerGroup,
  I_FixedAssetValue.Country AS Country,
  I_FixedAssetValue.ChartOfAccounts AS ChartOfAccounts,
  GLAccount,
  AlternativeGLAccount,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  FinancialAccountType,
  AccountingDocumentCreationDate,
  CreationTime,
  JointVentureCostRecoveryCode,
  ChartOfDepreciation,
  CostCenter,
  Plant,
  BusinessArea,
  PersonnelNumber,
  FinancialManagementArea,
  Fund,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  ProfitCenter,
  Segment,
  FundsCenter,
  AssetTransactionType,
  ControllingArea,
  CountryChartOfAccounts,
  I_FixedAssetValue.FinancialStatementVariant AS FinancialStatementVariant,
  I_FixedAssetValue.AccountingPrinciple AS AccountingPrinciple,
  GLBusinessTransactionType,
  AssetAccountDetermination,
  AssetClass,
  AssetCapitalizationDate,
  FirstAcquisitionFiscalYear,
  FirstAcquisitionFiscalPeriod,
  AssetDeactivationDate,
  FixedAssetGroup,
  AssetSupplierName,
  InvestmentOrder,
  BaseUnit,
  InventoryIsCounted,
  LastInventoryDate,
  Inventory,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  Group5AssetEvaluationKey,
  AssetSerialNumber,
  NationalClassification,
  TaxDepreciationGroup,
  cast('X' as boolean preserving type) AS AssetIsRetiredOnFiscalPerdEnd,
  I_FiscalYearPeriodForLedger.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  I_FixedAssetValue._CompanyCode AS _CompanyCode,
  I_FixedAssetValue._Country AS _Country,
  I_FixedAssetValue._Ledger AS _Ledger,
  I_FixedAssetValue._FiscalYear AS _FiscalYear,
  I_FixedAssetValue._FiscalPeriod AS _FiscalPeriod,
  I_FixedAssetValue._FiscalYearVariant AS _FiscalYearVariant
FROM I_FixedAssetValueForToFsclPerd
INNER JOIN I_FiscalYearPeriodForLedger ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_FixedAssetValueForToFsclPerd
;