FAA_ASSETASSIGNMENTS4

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_ASSETASSIGNMENTS4.
-- 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: FAAVASSETASMTS4

CREATE VIEW FAA_ASSETASSIGNMENTS4 AS
SELECT
  faat_md_tdd.comp_code AS companycode,
  faat_md_tdd.asset_subno AS fixedasset,
  faat_md_tdd.cost_center AS costcenter,
  faat_md_tdd.plant AS plant,
  faat_md_tdd.business_area AS businessarea,
  faat_md_tdd.room AS room,
  cast('' as xstil ) AS isshutdown,
  faat_md_tdd.fund AS fund,
  faat_md_tdd.profit_center AS profitcenter,
  faat_md_tdd.segment AS segment,
  faat_md_tdd.grant_id AS grantid,
  faat_md_tdd.budget_period AS budgetperiod,
  faat_md_tdd.funds_center AS fundscenter,
  faat_md_tdd.awtyp AS ReferenceDocumentType,
  faat_md_tdd.awsys AS LogicalSystem,
  faat_md_tdd.aworg AS ReferenceDocumentContext,
  faat_md_tdd.awref AS ReferenceDocument
FROM faat_md_tdd
LEFT OUTER JOIN tka02 ON /* join condition not captured in parsed metadata */
;