C_FxdAstDeprValInCurPeriod

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_FxdAstDeprValInCurPeriod.
-- 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: CFASSETDPVLCP
-- Parameters: P_TodayDate : fagl_keydate, P_CurrencyRole : fis_curtp, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper, P_AssetAccountingValueType : fis_ast_acctg_value_type

CREATE VIEW C_FxdAstDeprValInCurPeriod AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetDepreciationArea,
  Ledger,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  AssetDeactivationDate,
  AssetCapitalizationDate,
  FixedAssetDescription,
  Group1AssetEvaluationKey,
  Group2AssetEvaluationKey,
  Group3AssetEvaluationKey,
  Group4AssetEvaluationKey,
  Group5AssetEvaluationKey,
  AssetCountryOfOrigin,
  AssetSupplier,
  SupplierAccountGroup,
  SupplierBasicAuthorizationGrp,
  AssetAuthorizationContext,
  _DepreciationArea.AccountingPrinciple AS AccountingPrinciple,
  BusinessArea,
  AssetClass,
  AssetCostCenter,
  AssetPlant,
  AssetProfitCenter,
  Segment,
  AssetLocation,
  AssetAccountDetermination,
  _AssetClass._Text[1: Language = $session.system_language ].AssetClassName AS AssetClassName,
  AssetAccountingValueType,
  DisplayCurrency,
  cast((abs(OrdinaryDeprAmtInDspCrcy)) as faa_asset_ordinary_depr_amt) AS OrdinaryDeprAmtInDspCrcy,
  cast((abs(SpecialDeprAmtInDspCrcy)) as faa_asset_special_depr_amt) AS SpecialDeprAmtInDspCrcy,
  cast((abs(UnplannedDeprAmtInDspCrcy)) as faa_asset_unplanned_depr_amt) AS UnplannedDeprAmtInDspCrcy,
  abs(TotalPlannedDepreciationAmount) AS TotalPlannedDepreciationAmount
FROM I_FxdAstDeprValInCurPeriod
;