C_IL_AnnTaxGainAstReportQ

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_IL_AnnTaxGainAstReportQ.
-- 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.
-- SQL view name: CILDRCTAXGAINQRY
-- 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, P_IL_PreviousKnownIndexIsSet : fiaail_prev_known_index_ind

CREATE VIEW C_IL_AnnTaxGainAstReportQ AS
SELECT
  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,
  IL_IdxInDactvtnDateValue,
  IL_IdxInAcquisitionDateValue,
  DisplayCurrency,
  RetirementCostsAmtInDspCrcy,
  IL_RtrmtCostsAdjAmtInDspCrcy,
  IL_OffsetGain96AmtInDspCrcy,
  IL_OffsetGain96AdjAmtInDspCrcy,
  IL_OrdnryDeprTotalAmtInDspCrcy,
  IL_OrdinaryDeprAdjAmtInDspCrcy,
  IL_AssetNetValueAmtInDspCrcy,
  IL_NetBookValueAdjAmtInDspCrcy,
  IL_RtrmtRevenueAmtInDspCrcy,
  IL_RtrmtRevenueAdjAmtInDspCrcy,
  IL_AssetGainOrLossAmtInDspCrcy,
  IL_AssetLossAmountInDspCrcy,
  IL_AssetGainAmountInDspCrcy,
  IL_AstInflationaryAmtInDspCrcy,
  IL_AssetRealisticAmtInDspCrcy,
  IL_AstInfltnTaxDueAmtInDspCrcy,
  IL_AssetRealLossAmtInDspCrcy,
  IL_RealBfrDateSetAmtInDspCrcy,
  IL_RealAftDateSetAmtInDspCrcy,
  IL_AssetDeprAfterAmtInDspCrcy
FROM I_IL_AnnAstTaxGainReportingC
;