P_FxdAstUndrConstructionsAging

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 P_FxdAstUndrConstructionsAging.
-- 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: PFASTUCONSAGING
-- Parameters: P_KeyDate : fagl_keydate, P_TodayDate : fagl_keydate

CREATE VIEW P_FxdAstUndrConstructionsAging AS
SELECT
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  AssetDepreciationArea,
  Ledger,
  CurrencyRole,
  CompanyCodeName,
  ChartOfDepreciation,
  BusinessArea,
  AssetClass,
  AssetCostCenter,
  AssetPlant,
  AssetProfitCenter,
  Segment,
  PostingDate,
  cast('FAD' as fc_setid) AS SetIdentificationItemFAD,
  cast('LAD' as fc_setid) AS SetIdentificationItemLAD,
  SelectedCurrencyBranch
FROM P_FixedAssetTransactionAging
LEFT OUTER JOIN I_FixedAssetAssgmt AS _FixedAssetAssgmt ON _FixedAssetAssgmt.CompanyCode = CompanyCode AND _FixedAssetAssgmt.MasterFixedAsset = MasterFixedAsset AND _FixedAssetAssgmt.FixedAsset = FixedAsset  -- association [0..*]
;