FAA_ASSETS4

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 FAA_ASSETS4.
-- 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: FAAVASSETS4

CREATE VIEW FAA_ASSETS4 AS
SELECT
  root.comp_code AS companycode,
  root.asset_subno AS fixedasset,
  main.asset_class AS assetclass,
  0 AS quantity,
  main.base_unit AS baseunit,
  main.inventory_number AS inventory,
  t001.waers AS currency,
  root.is_historical_managed AS hashistory,
  main.surface_area_unit AS areasizeunit,
  main.supplier_no AS supplier,
  cast( cast(substring( cast(main.creation_datetime as abap.char(30)) , 1 , 8) as abap.dats(8)) as erdat ) AS CreationDate,
  '' AS isgroupasset,
  root.is_main_asset AS ismainasset,
  main.land_municipality AS municipality,
  main.land_plot_number AS landplot,
  main.surface_area AS areasize,
  main.lease_type AS leasetype,
  main.legacy_asset_no AS legacyasset
FROM faat_md_root AS root
LEFT OUTER JOIN faat_md AS main ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
;