I_RawExposureItem

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_RawExposureItem.
-- 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.

CREATE VIEW I_RawExposureItem AS
SELECT
  head_os_guid AS RawExposureUUID,
  item_id AS RawExposureItemID,
  ext_item_id AS RawExposureItemExtItemID,
  planning_period AS ExpMgmtExposurePlanningPeriod,
  planning_year AS ExpsrMgmtExposurePlanningYear,
  due_date AS ExposureDueDate,
  foreign_amt AS ExpsrAmountInExposureCurrency,
  foreign_curr AS ExposureCurrency,
  target_curr AS TargetCurrency,
  profit_center AS ProfitCenter,
  attribute_di01 AS ExpsrMgmtFreeDefinedItemDate,
  attribute_li01 AS ExpsrMgmtFreeDfndItemAttrib1,
  attribute_li02 AS ExpsrMgmtFreeDfndItemAttrib2,
  attribute_li03 AS ExpsrMgmtFreeDfndItemAttrib3,
  attribute_li04 AS ExpsrMgmtFreeDfndItemAttrib4,
  attribute_mi01 AS ExpsrMgmtFreeDfndItemAttrib5,
  attribute_mi02 AS ExpsrMgmtFreeDfndItemAttrib6,
  attribute_si01 AS ExpsrMgmtFreeDfndItemAttrib7,
  rportb AS Portfolio,
  gsber AS BusinessArea,
  kostl AS CostCenter,
  cast (ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  fb_segment AS Segment,
  behalf_of_company AS OnBehalfOfCompany,
  payment_date AS ExpsrMgmtPaymentDate,
  raw_exp_descr AS RawExposureName
FROM text_rexp_item
;