I_IL_SumzdAmtPerAssetTaxGainC

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_SumzdAmtPerAssetTaxGainC.
-- 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_SumzdAmtPerAssetTaxGainC AS
SELECT
  I_IL_AssetBalanceCube.CompanyCode AS CompanyCode,
  I_IL_AssetBalanceCube.MasterFixedAsset AS MasterFixedAsset,
  I_IL_AssetBalanceCube.FixedAsset AS FixedAsset,
  I_IL_AssetBalanceCube.IL_AcquisitionIndexYearMonth AS IL_AcquisitionIndexYearMonth,
  I_IL_AssetBalanceCube.IL_CurrentPeriodIndexYearMonth AS IL_CurrentPeriodIndexYearMonth,
  I_IL_AssetBalanceCube.IL_DeactivationIndexYearMonth AS IL_DeactivationIndexYearMonth,
  IndexValue123DactvtnDate.IL_IndexForPrevious1MonthValue AS IL_IndexDactvtnPrev1MonthValue,
  substring(I_IL_AssetBalanceCube.AssetDeactivationDate,7,2) AS IL_AssetDeactivationDay,
  substring(I_IL_AssetBalanceCube.AcquisitionValueDate,7,2) AS IL_AssetAcquisitionDay,
  IndexValue123DactvtnDate.IL_IndexForPrevious2MonthValue AS IL_IndexDactvtnPrev2MonthValue,
  IndexValue123DactvtnDate.IL_IndexForPrevious3MonthValue AS IL_IndexDactvtnPrev3MonthValue,
  cast(IndexValue123DactvtnDate.IL_IndexCurrentPeriodValue as fiaail_index_val_indeactdate) AS IL_IdxInDactvtnDateValue,
  cast(IndexValue123AcqnDate.IL_IndexCurrentPeriodValue as fiaail_index_val_acqndate) AS IL_IdxInAcquisitionDateValue,
  IndexValue123AcqnDate.IL_IndexForPrevious2MonthValue AS IL_IndexAcqnPrev2MonthValue,
  IndexValue123AcqnDate.IL_IndexForPrevious3MonthValue AS IL_IndexAcqnPrev3MonthValue,
  IndexValue123CaptlznDate.IL_IndexForPrevious1MonthValue AS IL_IndexCaptlznPrev1MonthValue,
  IndexValue123CaptlznDate.IL_IndexForPrevious2MonthValue AS IL_IndexCaptlznPrev2MonthValue,
  IndexValue123CaptlznDate.IL_IndexForPrevious3MonthValue AS IL_IndexCaptlznPrev3MonthValue,
  IndexValue123CaptlznDate.IL_IndexCurrentPeriodValue AS IL_IdxInCaptlznDateValue,
  I_IL_AssetBalanceCube.AssetClass AS AssetClass,
  I_IL_AssetBalanceCube.FixedAssetDescription AS FixedAssetDescription,
  I_IL_AssetBalanceCube.AssetCapitalizationDate AS AssetCapitalizationDate,
  I_IL_AssetBalanceCube.AcquisitionValueDate AS AcquisitionValueDate,
  I_IL_AssetBalanceCube.DepreciationStartDate AS DepreciationStartDate,
  I_IL_AssetBalanceCube.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  I_IL_AssetBalanceCube.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  I_IL_AssetBalanceCube.AssetCostCenter AS AssetCostCenter,
  I_IL_AssetBalanceCube.Group1AssetEvaluationKey AS Group1AssetEvaluationKey,
  I_IL_AssetBalanceCube.Group2AssetEvaluationKey AS Group2AssetEvaluationKey,
  I_IL_AssetBalanceCube.Group3AssetEvaluationKey AS Group3AssetEvaluationKey,
  I_IL_AssetBalanceCube.Group4AssetEvaluationKey AS Group4AssetEvaluationKey,
  I_IL_AssetBalanceCube.Group5AssetEvaluationKey AS Group5AssetEvaluationKey,
  I_IL_AssetBalanceCube.InvestmentSupportMeasure AS InvestmentSupportMeasure,
  I_IL_AssetBalanceCube.AssetBusinessArea AS AssetBusinessArea,
  I_IL_AssetBalanceCube.InvestmentReason AS InvestmentReason,
  I_IL_AssetBalanceCube.AssetAccountDetermination AS AssetAccountDetermination,
  I_IL_AssetBalanceCube.FixedAssetGroup AS FixedAssetGroup,
  I_IL_AssetBalanceCube.Inventory AS Inventory,
  I_IL_AssetBalanceCube.AssetDeactivationDate AS AssetDeactivationDate,
  I_IL_AssetBalanceCube.AssetManufacturerName AS AssetManufacturerName,
  I_IL_AssetBalanceCube.AssetAdditionalDescription AS AssetAdditionalDescription,
  I_IL_AssetBalanceCube.LastRetirementValueDate AS LastRetirementValueDate,
  I_IL_AssetBalanceCube.OriginalAcquisitionFiscalYear AS OriginalAcquisitionFiscalYear,
  I_IL_AssetBalanceCube.DisplayCurrency AS DisplayCurrency,
  sum(I_IL_AssetBalanceCube.RetirementCostsAmtInDspCrcy * (-1)) AS RetirementCostsAmtInDspCrcy,
  sum(I_IL_AssetBalanceCube.CumulativeReservesTransferAmt) AS CumulativeReservesTransferAmt,
  sum(I_IL_AssetBalanceCube.ManualTransferOfReservesAmt) AS ManualTransferOfReservesAmt,
  sum(I_IL_AssetBalanceCube.OrdnryDeprValAdjustmentAmount) AS OrdnryDeprValAdjustmentAmount,
  sum(I_IL_AssetBalanceCube.AccmltdOrdnryDeprValAdjmtAmt) AS AccmltdOrdnryDeprValAdjmtAmt,
  sum(I_IL_AssetBalanceCube.UnplndDeprValAdjustmentAmount) AS UnplndDeprValAdjustmentAmount,
  sum(I_IL_AssetBalanceCube.AccmltdUnplndDeprValAdjmtAmt) AS AccmltdUnplndDeprValAdjmtAmt,
  sum(I_IL_AssetBalanceCube.RetirementRevenue) AS RetirementRevenue,
  sum(I_IL_AssetBalanceCube.RetirementCost) AS RetirementCost,
  sum(I_IL_AssetBalanceCube.AccumulatedOrdinaryDeprAmount ) AS AccumulatedOrdinaryDeprAmount,
  sum(I_IL_AssetBalanceCube.PlannedOrdinaryDeprAmount) AS PlannedOrdinaryDeprAmount,
  15805361.66 AS IL_FactorYear93Month11Val
FROM I_IL_AssetBalanceCube
;