I_IL_AnnDeprAssetReportingC

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_IL_AnnDeprAssetReportingC.
-- 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_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_period_to, P_KeyDate : fagl_keydate, P_CurrentDepreciationArea : glofaa_gb_depr_area_cur, P_Ledger : fins_ledger

CREATE VIEW I_IL_AnnDeprAssetReportingC AS
SELECT
  cast( 'TAX' as char4 ) AS IL_AstDepreciationReportType,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetClass,
  FixedAssetDescription,
  AssetCapitalizationDate,
  AcquisitionValueDate,
  DepreciationStartDate,
  PlannedUsefulLifeInYears,
  PlannedUsefulLifeInPeriods,
  AssetCostCenter,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  Group5AssetEvaluationKey,
  InvestmentSupportMeasure,
  AssetBusinessArea,
  InvestmentReason,
  AssetAccountDetermination,
  FixedAssetGroup,
  Inventory,
  AssetDeactivationDate,
  AssetManufacturerName,
  AssetAdditionalDescription,
  DisplayCurrency,
  cast(AcquisitionProductionAmount as answl) AS AcquisitionProductionAmount,
  cast(AccmltdAcqnProductionAmount as kansw) AS AccmltdAcqnProductionAmount,
  cast(CumulativeReservesTransferAmt as kmafa) AS CumulativeReservesTransferAmt,
  cast(ManualTransferOfReservesAmt as mafam) AS ManualTransferOfReservesAmt,
  cast(TransferAmtInDspCrcy as fis_aa_transfer_amount) AS TransferAmtInDspCrcy,
  cast(RetirementCostsAmtInDspCrcy as fis_retirementcostsamount) AS RetirementCostsAmtInDspCrcy,
  cast(OrdnryDeprValAdjustmentAmount as nafal) as OrdnryDeprValAdjustmentAmount AS P_AssetAccountingKeyFigureSet,
  P_FiscalYear: $parameters.P_FiscalYear AS P_FiscalYear,
  P_FiscalPeriod: $parameters.P_FiscalPeriod AS P_FiscalPeriod,
  P_KeyDate: $parameters.P_KeyDate AS P_KeyDate,
  P_CurrentDepreciationArea: $parameters.P_CurrentDepreciationArea AS P_CurrentDepreciationArea,
  I_IL_SumzdAmountsPerAssetC.OrdnryDeprValAdjustmentAmount AS OrdnryDeprValAdjustmentAmount
FROM I_IL_SumzdAmountsPerAssetC
-- UNION ALL with additional select branch(es): I_IL_SumzdAmountsPerAssetC
;