I_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 I_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.
-- Parameters: P_CurrencyRole : fins_curtp, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper, P_AssetAccountingKeyFigureSet : faa_key_figure_set

CREATE VIEW I_FixedAssetValueCube AS
SELECT
  CompanyCode,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  FiscalYear,
  FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetAcctTransClassfctn,
  AssetAccountingKeyFigure,
  AssetAccountingKeyFigureSet,
  AccountingDocument,
  TransactionSubitem,
  DebitCreditCode,
  LedgerFiscalYear,
  FiscalYearVariant,
  FiscalYearPeriod,
  DepreciationFiscalPeriod,
  AssetAccountingSortedKeyFigure,
  LedgerGroup,
  ChartOfAccounts,
  _BalanceSheetAccount.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  GLAccount,
  AlternativeGLAccount,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  FinancialAccountType,
  AccountingDocumentCreationDate,
  CreationTime,
  JointVentureCostRecoveryCode,
  ChartOfDepreciation,
  CostCenter,
  Plant,
  BusinessArea,
  PersonnelNumber,
  FinancialManagementArea,
  Fund,
  GrantID,
  FunctionalArea,
  BudgetPeriod,
  ProfitCenter,
  Segment,
  FundsCenter,
  AssetTransactionType,
  ControllingArea,
  CountryChartOfAccounts,
  FinancialStatementVariant,
  AccountingPrinciple,
  DisplayCurrency,
  AmountInDisplayCurrency,
  P_FixedAssetValueCube.AssetAccountDetermination AS AssetAccountDetermination,
  AssetClass,
  AssetCapitalizationDate,
  FirstAcquisitionFiscalYear,
  FirstAcquisitionFiscalPeriod,
  AssetDeactivationDate,
  FixedAssetGroup,
  AssetSupplierName,
  InvestmentOrder,
  BaseUnit,
  InventoryIsCounted,
  LastInventoryDate,
  Inventory,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  Group5AssetEvaluationKey,
  AssetSerialNumber,
  AssetIsRetiredOnFiscalPerdEnd,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).CostCenter as faa_kostl) AS AssetCostCenter,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).BusinessArea as faa_gsber) AS AssetBusinessArea,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).Fund as faa_bp_geber) AS AssetFund,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).ProfitCenter as faa_prctr) AS AssetProfitCenter,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).Segment as faa_fb_segment) AS AssetSegment,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).Plant as faa_werks) AS AssetPlant,
  cast(_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).BudgetPeriod as faa_budget_period) AS AssetBudgetPeriod,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).GrantID as faa_grant_nbr) AS AssetGrant,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).CostCtrActivityType as faa_lstar) AS AssetCostCtrActivityType,
  _AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).AssetLocation AS AssetLocation,
  _AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).RealEstateObject AS RealEstateObject,
  cast (_AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).FundsCenter as faa_fistl) AS AssetFundsCenter,
  _AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).Room AS Room,
  _AssignmentByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).InvestmentSupportMeasure AS InvestmentSupportMeasure,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).DepreciationStartDate AS DepreciationStartDate,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).SpecialDeprStartDate AS SpecialDeprStartDate,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).DepreciationKey AS DepreciationKey,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).OriglAstUsefulLifeInYears AS OriglAstUsefulLifeInYears,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).OriglAstUsefulLifeInPerds AS OriglAstUsefulLifeInPerds,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).DeprKeyChangeoverYear AS DeprKeyChangeoverYear,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).DeprKeyChangeoverPeriod AS DeprKeyChangeoverPeriod,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).VintageYear AS VintageYear,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).VintageMonth AS VintageMonth,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).ReplacementValueIndexSers AS ReplacementValueIndexSers,
  _DeprAreaByFiscalPeriodEnd(P_FiscalYear: :P_FiscalYear, P_FiscalPeriod: :P_FiscalPeriod).RplcmtValueAgingIndexSers AS RplcmtValueAgingIndexSers,
  Country,
  NationalClassification,
  TaxDepreciationGroup,
  WBSElementExternalID,
  P_FixedAssetValueCube._AssetAccountDetermination AS _AssetAccountDetermination
FROM P_FixedAssetValueCube
LEFT OUTER JOIN I_DepreciationArea AS _DepreciationArea ON Ledger = _DepreciationArea.Ledger AND CompanyCode = _DepreciationArea.CompanyCode AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_FxdAstAssgmtByFsclPerdEndDte AS _AssignmentByFiscalPeriodEnd ON CompanyCode = _AssignmentByFiscalPeriodEnd.CompanyCode AND Ledger = _AssignmentByFiscalPeriodEnd.Ledger AND AssetDepreciationArea = _AssignmentByFiscalPeriodEnd.AssetDepreciationArea AND MasterFixedAsset = _AssignmentByFiscalPeriodEnd.MasterFixedAsset AND FixedAsset = _AssignmentByFiscalPeriodEnd.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FxdAstDeprAreaByFsclPerdEnd AS _DeprAreaByFiscalPeriodEnd ON CompanyCode = _DeprAreaByFiscalPeriodEnd.CompanyCode AND Ledger = _DeprAreaByFiscalPeriodEnd.Ledger AND AssetDepreciationArea = _DeprAreaByFiscalPeriodEnd.AssetDepreciationArea AND MasterFixedAsset = _DeprAreaByFiscalPeriodEnd.MasterFixedAsset AND FixedAsset = _DeprAreaByFiscalPeriodEnd.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _AssetCostCenter ON ControllingArea = _AssetCostCenter.ControllingArea AND AssetCostCenter = _AssetCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterActivityType AS _AssetCostCenterActivityType ON AssetCostCtrActivityType = _AssetCostCenterActivityType.CostCtrActivityType AND ControllingArea = _AssetCostCenterActivityType.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _AssetBusinessArea ON AssetBusinessArea = _AssetBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _AssetProfitCenter ON AssetProfitCenter = _AssetProfitCenter.ProfitCenter AND ControllingArea = _AssetProfitCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_Segment AS _AssetSegment ON AssetSegment = _AssetSegment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Location AS _AssetLocation ON assetlocation = _AssetLocation.Location AND AssetPlant = _AssetLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _AssetPlant ON AssetPlant = _AssetPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_DepreciationKey AS _DepreciationKey ON ChartOfDepreciation = _DepreciationKey.ChartOfDepreciation AND depreciationkey = _DepreciationKey.DepreciationKey  -- association [0..1]
LEFT OUTER JOIN I_InvestmentSupportMeasure AS _InvestmentSupportMeasure ON ChartOfDepreciation = _InvestmentSupportMeasure.ChartOfDepreciation AND investmentsupportmeasure = _InvestmentSupportMeasure.InvestmentSupportMeasure  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AcqnProdnCostGLAccount ON ChartOfAccounts = _AcqnProdnCostGLAccount.ChartOfAccounts AND acqnprodncostglaccount = _AcqnProdnCostGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_AssetBalanceSheetAccount AS _BalanceSheetAccount ON CompanyCode = _BalanceSheetAccount.CompanyCode AND AssetAccountDetermination = _BalanceSheetAccount.AssetAccountDetermination AND AssetDepreciationArea = _BalanceSheetAccount.AssetRealDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = DisplayCurrency  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN E_FixedAsset AS _Extension ON MasterFixedAsset = _Extension.MasterFixedAsset AND FixedAsset = _Extension.FixedAsset AND CompanyCode = _Extension.CompanyCode  -- association [1..1]
;