I_IL_SumzdAmountsPerAssetC

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_SumzdAmountsPerAssetC.
-- 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_SumzdAmountsPerAssetC 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,
  DisplayCurrency,
  sum(I_IL_AssetBalanceCube.AcquisitionProductionAmount) AS AcquisitionProductionAmount,
  sum(I_IL_AssetBalanceCube.AccmltdAcqnProductionAmount) AS AccmltdAcqnProductionAmount,
  sum(TransferAmtInDspCrcy ) AS TransferAmtInDspCrcy,
  sum(RetirementCostsAmtInDspCrcy) AS RetirementCostsAmtInDspCrcy,
  sum(CumulativeReservesTransferAmt) AS CumulativeReservesTransferAmt,
  sum(ManualTransferOfReservesAmt) AS ManualTransferOfReservesAmt,
  sum(OrdnryDeprValAdjustmentAmount) AS OrdnryDeprValAdjustmentAmount,
  sum(AccumulatedOrdinaryDeprAmount ) AS AccumulatedOrdinaryDeprAmount,
  sum(AccumulatedUnplannedDeprAmount) AS AccumulatedUnplannedDeprAmount,
  sum( AccmltdProportionTransfRsrvAmt) AS AccmltdProportionTransfRsrvAmt,
  sum( ProportionalTransfOfReserveAmt) AS ProportionalTransfOfReserveAmt,
  sum(PlannedOrdinaryDeprAmount) AS PlannedOrdinaryDeprAmount,
  sum(SpecialDepreciationAmount) AS SpecialDepreciationAmount,
  sum(UnplannedDepreciationAmount) AS UnplannedDepreciationAmount,
  sum(AccmltdOrdnryDeprValAdjmtAmt) AS AccmltdOrdnryDeprValAdjmtAmt,
  sum(UnplndDeprValAdjustmentAmount) AS UnplndDeprValAdjustmentAmount,
  sum(AccmltdUnplndDeprValAdjmtAmt) AS AccmltdUnplndDeprValAdjmtAmt
FROM I_IL_AssetBalanceCube
;