C_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 C_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_LedgerFiscalYear : fis_ryear, P_FiscalPeriod : fis_period_to

CREATE VIEW C_FixedAssetDepreciationList AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  LedgerFiscalYear,
  AssetDepreciationArea,
  Ledger,
  CurrencyRole,
  AssetAccountingKeyFigureSet,
  AssetAccountingKeyFigure,
  AccountingDocument,
  LedgerGLLineItem,
  TransactionSubitem,
  DebitCreditCode,
  FiscalPeriod,
  SubLedgerAcctLineItemType,
  AssetAcctTransClassfctn,
  FiscalYear,
  FiscalYearVariant,
  FixedAssetExternalID,
  ChartOfDepreciation,
  PostingDate,
  AssetClass,
  AssetAuthorizationContext,
  SelectedCurrencyBranch,
  DisplayCurrency,
  PlannedAmountInDisplayCurrency,
  AmountInDisplayCurrency,
  DueAmountInDisplayCrcy,
  StartingBalAmtInDspCrcy,
  AcqnProdnAmtInDspCrcy,
  FinancialManagementArea,
  AssetFund,
  cast(_AssetFundText.FundName as faa_fund_name) AS AssetFundName,
  AssetGrantID,
  AssetFunctionalArea,
  cast(_AssetFunctionalAreaText.FunctionalAreaName as faa_fkbtx) AS AssetFunctionalAreaName,
  AssetBudgetPeriod,
  cast(_AssetBudgetPeriodText.BudgetPeriodName as faa_fm_budget_period_name) AS AssetBudgetPeriodName,
  cast(_FixedAsset.FixedAssetDescription as fis_txa50_anlt) AS FixedAssetDescription,
  cast(_FixedAsset.AssetAdditionalDescription as fis_txa50_more) AS AssetAdditionalDescription,
  ControllingArea,
  AssetCostCenter,
  cast(_AssetCostCenterText.CostCenterName as faa_kostl_name) AS AssetCostCenterName,
  AssetBusinessArea,
  cast(_AssetBusinessAreaText.BusinessAreaName as faa_gsber_name) AS AssetBusinessAreaName,
  AssetPlant,
  AssetProfitCenter,
  cast(_AssetProfitCenterText.ProfitCenterName as faa_prctr_name) AS AssetProfitCenterName,
  AssetSegment,
  cast(_AssetSegmentText.SegmentName as faa_segment_name) AS AssetSegmentName,
  DepreciationKey,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  OriglAstUsefulLifeInYears,
  OriglAstUsefulLifeInPerds,
  DepreciationStartDate,
  DeprKeyChangeoverYear,
  DeprKeyChangeoverPeriod,
  VintageYear,
  VintageMonth,
  ReplacementValueIndexSers,
  RplcmtValueAgingIndexSers,
  Country,
  NationalClassification,
  TaxDepreciationGroup,
  JP_PrptyTxRptCity,
  JP_PrptyTxRptClassfctnKey,
  RU_AssetOKOF,
  RU_AssetDepreciationGroup,
  _AssetClassText.AssetClassName AS AssetClassName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _DeprAreaForLedgerText.AssetDepreciationAreaName AS AssetDepreciationAreaName,
  _FinancialManagementAreaText.FinancialManagementAreaName AS FinancialManagementAreaName,
  _FixedAssetNatlClfnText.NationalClassificationDesc AS NationalClassificationDesc,
  _JP_PrptyTxRptCityText.JP_PrptyTxRptCityDesc AS JP_PrptyTxRptCityDesc,
  _JP_PrptyTxRptClassfctnKeyText.JP_PrptyTxRptClassfctnKeyDesc AS JP_PrptyTxRptClassfctnKeyDesc,
  _LedgerText.LedgerName AS LedgerName,
  _MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  _RU_AssetDepreciationGroupText.RU_AssetDepreciationGroupDesc AS RU_AssetDepreciationGroupDesc,
  _RU_AssetOKOFText.RU_AssetOKOFDesc AS RU_AssetOKOFDesc,
  _TaxDepreciationGroupText.TaxDepreciationGroupDesc AS TaxDepreciationGroupDesc
FROM I_FixedAssetDepreciationList
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYearVH ON _FiscalYearVH.CompanyCode = CompanyCode AND _FiscalYearVH.FiscalYear = FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalYearPeriodVH ON _FiscalYearPeriodVH.CompanyCode = CompanyCode AND _FiscalYearPeriodVH.FiscalYear = FiscalYear AND _FiscalYearPeriodVH.FiscalPeriod = FiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_DepreciationKey AS _DepreciationKeyVH ON ChartOfDepreciation = _DepreciationKeyVH.ChartOfDepreciation AND DepreciationKey = _DepreciationKeyVH.DepreciationKey  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _LedgerVH ON Ledger = _LedgerVH.Ledger  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AssetClassText AS _AssetClassText ON AssetClass = _AssetClassText.AssetClass AND _AssetClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _AssetCostCenterText ON ControllingArea = _AssetCostCenterText.ControllingArea AND AssetCostCenter = _AssetCostCenterText.CostCenter AND _AssetCostCenterText.ValidityStartDate <= $parameters.P_KeyDate AND _AssetCostCenterText.ValidityEndDate >= $parameters.P_KeyDate AND _AssetCostCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _AssetProfitCenterText ON ControllingArea = _AssetProfitCenterText.ControllingArea AND AssetProfitCenter = _AssetProfitCenterText.ProfitCenter AND _AssetProfitCenterText.ValidityStartDate <= $parameters.P_KeyDate AND _AssetProfitCenterText.ValidityEndDate >= $parameters.P_KeyDate AND _AssetProfitCenterText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _AssetBusinessAreaText ON AssetBusinessArea = _AssetBusinessAreaText.BusinessArea AND _AssetBusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _AssetSegmentText ON AssetSegment = _AssetSegmentText.Segment AND _AssetSegmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialManagementAreaText AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea AND _FinancialManagementAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriodText AS _AssetBudgetPeriodText ON AssetBudgetPeriod = _AssetBudgetPeriodText.BudgetPeriod AND _AssetBudgetPeriodText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FundText AS _AssetFundText ON FinancialManagementArea = _AssetFundText.FinancialManagementArea AND AssetFund = _AssetFundText.Fund AND _AssetFundText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _AssetFunctionalAreaText ON AssetFunctionalArea = _AssetFunctionalAreaText.FunctionalArea AND _AssetFunctionalAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DeprAreaForLedgerText AS _DeprAreaForLedgerText ON CompanyCode = _DeprAreaForLedgerText.CompanyCode AND Ledger = _DeprAreaForLedgerText.Ledger AND AssetDepreciationArea = _DeprAreaForLedgerText.AssetDepreciationArea AND _DeprAreaForLedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FixedAssetNatlClfnText AS _FixedAssetNatlClfnText ON Country = _FixedAssetNatlClfnText.Country AND NationalClassification = _FixedAssetNatlClfnText.NationalClassification AND _FixedAssetNatlClfnText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TaxDepreciationGroupText AS _TaxDepreciationGroupText ON Country = _TaxDepreciationGroupText.Country AND TaxDepreciationGroup = _TaxDepreciationGroupText.TaxDepreciationGroup AND _TaxDepreciationGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JP_PrptyTxRptCityT AS _JP_PrptyTxRptCityText ON JP_PrptyTxRptCity = _JP_PrptyTxRptCityText.JP_PrptyTxRptCity AND _JP_PrptyTxRptCityText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JP_PrptyTxRptClassfctnKeyT AS _JP_PrptyTxRptClassfctnKeyText ON JP_PrptyTxRptClassfctnKey = _JP_PrptyTxRptClassfctnKeyText.JP_PrptyTxRptClassfctnKey AND _JP_PrptyTxRptClassfctnKeyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RU_AssetOKOFText AS _RU_AssetOKOFText ON RU_AssetOKOF = _RU_AssetOKOFText.RU_AssetOKOF AND Country = _RU_AssetOKOFText.Country AND _RU_AssetOKOFText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RU_AssetDepreciationGroupT AS _RU_AssetDepreciationGroupText ON RU_AssetDepreciationGroup = _RU_AssetDepreciationGroupText.RU_AssetDepreciationGroup AND Country = _RU_AssetDepreciationGroupText.Country AND RU_AssetOKOF = _RU_AssetDepreciationGroupText.RU_AssetOKOF AND _RU_AssetDepreciationGroupText.Language = $session.system_language  -- association [0..1]
;