I_TrltPosattrib

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_TrltPosattrib.
-- 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: ITRLTPOSATTRIB

CREATE VIEW I_TrltPosattrib AS
SELECT
  cast(posattrib.os_guid as ftr_gen_position_uuid preserving type) AS TreasuryPosition,
  cast(posattrib.pos_attrib_s1 as ftr_gen_free_dfnd_attribute1 preserving type) AS TrsyPosFreeDefinedAttribute1,
  cast(posattrib.pos_attrib_s2 as ftr_gen_free_dfnd_attribute2 preserving type) AS TrsyPosFreeDefinedAttribute2,
  cast(posattrib.pos_attrib_s3 as ftr_gen_free_dfnd_attribute3 preserving type) AS TrsyPosFreeDefinedAttribute3,
  cast(posattrib.pos_attrib_m1 as ftr_gen_free_dfnd_attribute4 preserving type) AS TrsyPosFreeDefinedAttribute4,
  cast(posattrib.pos_attrib_m2 as ftr_gen_free_dfnd_attribute5 preserving type) AS TrsyPosFreeDefinedAttribute5,
  cast(posattrib.pos_attrib_m3 as ftr_gen_free_dfnd_attribute6 preserving type) AS TrsyPosFreeDefinedAttribute6,
  cast(posattrib.pos_attrib_l1 as ftr_gen_free_dfnd_attribute7 preserving type) AS TrsyPosFreeDefinedAttribute7,
  cast(posattrib.pos_attrib_l2 as ftr_gen_free_dfnd_attribute8 preserving type) AS TrsyPosFreeDefinedAttribute8,
  cast(posattrib.pos_attrib_l3 as ftr_gen_free_dfnd_attribute9 preserving type) AS TrsyPosFreeDefinedAttribute9,
  cast(_TrsyPosFreeDefinedAttribute1.text as ftr_gen_free_dfnd_attr1_name preserving type) AS TrsyPosFreeDfndAttribute1Name,
  cast(_TrsyPosFreeDefinedAttribute2.text as ftr_gen_free_dfnd_attr2_name preserving type) AS TrsyPosFreeDfndAttribute2Name,
  cast(_TrsyPosFreeDefinedAttribute3.text as ftr_gen_free_dfnd_attr3_name preserving type) AS TrsyPosFreeDfndAttribute3Name,
  cast(_TrsyPosFreeDefinedAttribute4.text as ftr_gen_free_dfnd_attr4_name preserving type) AS TrsyPosFreeDfndAttribute4Name,
  cast(_TrsyPosFreeDefinedAttribute5.text as ftr_gen_free_dfnd_attr5_name preserving type) AS TrsyPosFreeDfndAttribute5Name,
  cast(_TrsyPosFreeDefinedAttribute6.text as ftr_gen_free_dfnd_attr6_name preserving type) AS TrsyPosFreeDfndAttribute6Name
FROM trlt_pos_attrib AS posattrib
;