I_FixedAssetDepreciationList

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_FixedAssetDepreciationList.
-- 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_KeyDate : fagl_keydate, P_FiscalYear : fis_ryear, P_FiscalPeriod : fis_period_to

CREATE VIEW I_FixedAssetDepreciationList AS
SELECT
  P_FixedAssetDepreciationList1.CompanyCode AS CompanyCode,
  P_FixedAssetDepreciationList1.AssetDepreciationArea AS AssetDepreciationArea,
  P_FixedAssetDepreciationList1.MasterFixedAsset AS MasterFixedAsset,
  P_FixedAssetDepreciationList1.FixedAsset AS FixedAsset,
  P_FixedAssetDepreciationList1.Ledger AS Ledger,
  P_FixedAssetDepreciationList1.FiscalYear AS FiscalYear,
  P_FixedAssetDepreciationList1.FiscalPeriod AS FiscalPeriod,
  P_FixedAssetDepreciationList1.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  P_FixedAssetDepreciationList1.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  P_FixedAssetDepreciationList1.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  P_FixedAssetDepreciationList1.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  P_FixedAssetDepreciationList1.AccountingDocument AS AccountingDocument,
  P_FixedAssetDepreciationList1.LedgerGLLineItem AS LedgerGLLineItem,
  P_FixedAssetDepreciationList1.TransactionSubitem AS TransactionSubitem,
  P_FixedAssetDepreciationList1.DebitCreditCode AS DebitCreditCode,
  P_FixedAssetDepreciationList1.CurrencyRole AS CurrencyRole,
  P_FixedAssetDepreciationList1.FiscalYearVariant AS FiscalYearVariant,
  P_FixedAssetDepreciationList1.LedgerFiscalYear AS LedgerFiscalYear,
  P_FixedAssetDepreciationList1.ChartOfDepreciation AS ChartOfDepreciation,
  P_FixedAssetDepreciationList1.ControllingArea AS ControllingArea,
  P_FixedAssetDepreciationList1.PostingDate AS PostingDate,
  P_FixedAssetDepreciationList1.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  P_FixedAssetDepreciationList1.DisplayCurrency AS DisplayCurrency,
  _FixedAsset.FixedAssetExternalID AS FixedAssetExternalID,
  _FixedAsset.AssetClass AS AssetClass,
  _FixedAssetForLedger.AssetCapitalizationDate AS AssetCapitalizationDate,
  _FixedAsset.AssetAuthorizationContext AS AssetAuthorizationContext,
  cast(_FixedAssetAssgmt.CostCenter as faa_kostl) AS AssetCostCenter,
  cast(_FixedAssetAssgmt.BusinessArea as faa_gsber) AS AssetBusinessArea,
  cast(_FixedAssetAssgmt.Plant as faa_werks) AS AssetPlant,
  cast(_FixedAssetAssgmt.ProfitCenter as faa_prctr) AS AssetProfitCenter,
  cast(_FixedAssetAssgmt.Segment as faa_fb_segment) AS AssetSegment,
  P_FixedAssetDepreciationList1.FinancialManagementArea AS FinancialManagementArea,
  cast(_FixedAssetAssgmt.Fund as faa_bp_geber) AS AssetFund,
  cast(_FixedAssetAssgmt.GrantID as faa_gm_grant_nbr) AS AssetGrantID,
  cast(_FixedAssetAssgmt.FunctionalArea as faa_fkber) AS AssetFunctionalArea,
  cast(_FixedAssetAssgmt.BudgetPeriod as faa_budget_period) AS AssetBudgetPeriod,
  _AssetValuationForLedger.DepreciationKey AS DepreciationKey,
  _AssetValuationForLedger.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  _AssetValuationForLedger.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  _AssetValuationForLedger.OriglAstUsefulLifeInYears AS OriglAstUsefulLifeInYears,
  _AssetValuationForLedger.OriglAstUsefulLifeInPerds AS OriglAstUsefulLifeInPerds,
  _AssetValuationForLedger.DepreciationStartDate AS DepreciationStartDate,
  _AssetValuationForLedger.DeprKeyChangeoverYear AS DeprKeyChangeoverYear,
  _AssetValuationForLedger.DeprKeyChangeoverPeriod AS DeprKeyChangeoverPeriod,
  _AssetValuationForLedger.VintageYear AS VintageYear,
  _AssetValuationForLedger.VintageMonth AS VintageMonth,
  _AssetValuationForLedger.ReplacementValueIndexSers AS ReplacementValueIndexSers,
  _AssetValuationForLedger.RplcmtValueAgingIndexSers AS RplcmtValueAgingIndexSers,
  P_FixedAssetDepreciationList1.Country AS Country,
  _FixedAssetCountryData.NationalClassification AS NationalClassification,
  _FixedAssetCountryData.TaxDepreciationGroup AS TaxDepreciationGroup,
  _FixedAssetCountryData.JP_PrptyTxRptCity AS JP_PrptyTxRptCity,
  _FixedAssetCountryData.JP_PrptyTxRptClassfctnKey AS JP_PrptyTxRptClassfctnKey,
  _GlobAssetAssignment.RU_AssetOKOF AS RU_AssetOKOF,
  _GlobAssetAssignment.RU_AssetDepreciationGroup AS RU_AssetDepreciationGroup
FROM P_FixedAssetDepreciationList1
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND FixedAsset = _FixedAsset.FixedAsset AND MasterFixedAsset = _FixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_DepreciationAreaForLedger AS _DepreciationArea ON CompanyCode = _DepreciationArea.CompanyCode AND Ledger = _DepreciationArea.Ledger AND AssetDepreciationArea = _DepreciationArea.AssetDepreciationArea  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ChartOfDepreciation AS _ChartOfDepreciation ON ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DisplayCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _CurrencyRole ON CurrencyRole = _CurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_AssetKeyFigure AS _AssetKeyFigure ON AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure  -- association [0..1]
LEFT OUTER JOIN I_AssetKeyFigureSet AS _AssetKeyFigureSet ON _AssetKeyFigureSet.AssetAccountingKeyFigureSet = AssetAccountingKeyFigureSet  -- 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 _AssetCostCenter.ControllingArea = ControllingArea AND _AssetCostCenter.CostCenter = AssetCostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _AssetProfitCenter ON _AssetProfitCenter.ControllingArea = ControllingArea AND _AssetProfitCenter.ProfitCenter = AssetProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _AssetBusinessArea ON _AssetBusinessArea.BusinessArea = AssetBusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _AssetPlant ON _AssetPlant.Plant = AssetPlant  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _AssetSegment ON _AssetSegment.Segment = AssetSegment  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_AssetClass AS _AssetClass ON assetclass = _AssetClass.AssetClass  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetForLedger AS _FixedAssetForLedger ON _FixedAssetForLedger.CompanyCode = CompanyCode AND _FixedAssetForLedger.MasterFixedAsset = MasterFixedAsset AND _FixedAssetForLedger.FixedAsset = FixedAsset AND _FixedAssetForLedger.Ledger = Ledger  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetCountryData AS _FixedAssetCountryData ON CompanyCode = _FixedAssetCountryData.CompanyCode AND MasterFixedAsset = _FixedAssetCountryData.MasterFixedAsset AND FixedAsset = _FixedAssetCountryData.FixedAsset  -- 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_TaxDepreciationGroup AS _TaxDepreciationGroup ON Country = _TaxDepreciationGroup.Country AND taxdepreciationgroup = _TaxDepreciationGroup.TaxDepreciationGroup  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _AssetFunctionalArea ON AssetFunctionalArea = _AssetFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinancialManagementArea ON FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _AssetFund ON FinancialManagementArea = _AssetFund.FinancialManagementArea AND AssetFund = _AssetFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _AssetBudgetPeriod ON AssetBudgetPeriod = _AssetBudgetPeriod.BudgetPeriod  -- 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_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_MovementCategory AS _AssetAcctTransClassfctn ON AssetAcctTransClassfctn = _AssetAcctTransClassfctn.AssetAcctTransClassfctn  -- 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_JP_PrptyTxRptCity AS _JP_PrptyTxRptCity ON jp_prptytxrptcity = _JP_PrptyTxRptCity.JP_PrptyTxRptCity  -- association [0..1]
LEFT OUTER JOIN I_JP_PrptyTxRptClassfctnKey AS _JP_PrptyTxRptClassfctnKey ON jp_prptytxrptclassfctnkey = _JP_PrptyTxRptClassfctnKey.JP_PrptyTxRptClassfctnKey  -- association [0..1]
LEFT OUTER JOIN I_RU_AssetDepreciationGroup AS _RU_AssetDepreciationGroup ON ru_assetdepreciationgroup = _RU_AssetDepreciationGroup.RU_AssetDepreciationGroup AND Country = _RU_AssetDepreciationGroup.Country AND ru_assetokof = _RU_AssetDepreciationGroup.RU_AssetOKOF  -- association [0..1]
LEFT OUTER JOIN I_RU_AssetOKOF AS _RU_AssetOKOF ON ru_assetokof = _RU_AssetOKOF.RU_AssetOKOF AND Country = _RU_AssetOKOF.Country  -- association [0..1]
LEFT OUTER JOIN I_AssetRedesignSwitchStatus AS _AssetRedesignSwitchStatus ON _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = '' OR _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = 'X'  -- association [1]
LEFT OUTER JOIN I_FixedAssetAssgmt AS _FixedAssetAssgmt ON _FixedAssetAssgmt.CompanyCode = CompanyCode AND _FixedAssetAssgmt.MasterFixedAsset = MasterFixedAsset AND _FixedAssetAssgmt.FixedAsset = FixedAsset AND _FixedAssetAssgmt.ValidityStartDate <= $parameters.P_KeyDate AND _FixedAssetAssgmt.ValidityEndDate >= $parameters.P_KeyDate  -- association [0..1]
LEFT OUTER JOIN I_AssetValuationForLedger AS _AssetValuationForLedger ON _AssetValuationForLedger.CompanyCode = CompanyCode AND _AssetValuationForLedger.MasterFixedAsset = MasterFixedAsset AND _AssetValuationForLedger.FixedAsset = FixedAsset AND _AssetValuationForLedger.Ledger = Ledger AND _AssetValuationForLedger.AssetRealDepreciationArea = AssetDepreciationArea AND _AssetValuationForLedger.ValidityStartDate <= $parameters.P_KeyDate AND _AssetValuationForLedger.ValidityEndDate >= $parameters.P_KeyDate  -- association [0..1]
LEFT OUTER JOIN I_GlobAssetAssignment AS _GlobAssetAssignment ON _GlobAssetAssignment.CompanyCode = CompanyCode AND _GlobAssetAssignment.MasterFixedAsset = MasterFixedAsset AND _GlobAssetAssignment.FixedAsset = FixedAsset AND _GlobAssetAssignment.ValidityStartDate <= $parameters.P_KeyDate AND _GlobAssetAssignment.ValidityEndDate >= $parameters.P_KeyDate  -- 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]
;