I_RawExposure

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_RawExposure.
-- 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_RawExposure AS
SELECT
  a.os_guid AS RawExposureUUID,
  b.RawExposureItemID AS RawExposureItemID,
  c.RawExposureSubItemID AS RawExposureSubItemID,
  a.exposure_id AS RawExposureID,
  a.relevance_date AS RawExposureValidFromDate,
  a.version AS RawExposureVersion,
  a.last_rel_version AS RawExpLastRelevantVersion,
  a.company_code AS CompanyCode,
  a.exp_flow_type AS RawExposureActivityType,
  a.attribute_dh01 AS ExpsrMgmtFreeDefinedHeaderDate,
  a.attribute_sh01 AS ExpsrMgmtFreeDfndHeaderAttrib1,
  a.attribute_sh02 AS ExpsrMgmtFreeDfndHeaderAttrib2,
  a.attribute_lh01 AS ExpsrMgmtFreeDfndHeaderAttrib3,
  a.country AS Country,
  a.exposure_origin AS RawExposureOrigin,
  a.log_system AS OriginSystem,
  a.ext_doc_no AS RawExposureExternalDocNumber,
  a.release_state AS RawExposureReleaseState,
  a.creation_date AS RawExposureCreationDate,
  a.creation_tcode AS CreationTransactionCode,
  a.creation_time AS RawExposureCreationTime,
  a.creation_user AS CreatedByUser,
  a.lastchange_date AS LastChangeDate,
  a.lastchange_tcode AS ChangeTransactionCode,
  a.lastchange_time AS RawExposureChangeTime,
  a.lastchange_user AS LastChangedByUser,
  a.origin_tstmp AS RawExposureOriginDateTime,
  b.RawExposureItemExtItemID AS RawExposureItemExtItemID,
  b.ExposureDueDate AS ExposureDueDate,
  c.ExpsrAmountInExposureCurrency AS ExpsrAmountInExposureCurrency,
  c.ExposureCurrency AS ExposureCurrency,
  c.TargetCurrency AS TargetCurrency,
  b.ExpsrMgmtPaymentDate AS ExpsrMgmtPaymentDate,
  b.ExpMgmtExposurePlanningPeriod AS ExpMgmtExposurePlanningPeriod,
  b.ExpsrMgmtExposurePlanningYear AS ExpsrMgmtExposurePlanningYear,
  b.ExpsrMgmtFreeDefinedItemDate AS ExpsrMgmtFreeDefinedItemDate,
  b.ExpsrMgmtFreeDfndItemAttrib1 AS ExpsrMgmtFreeDfndItemAttrib1,
  b.ExpsrMgmtFreeDfndItemAttrib2 AS ExpsrMgmtFreeDfndItemAttrib2,
  b.ExpsrMgmtFreeDfndItemAttrib3 AS ExpsrMgmtFreeDfndItemAttrib3,
  b.ExpsrMgmtFreeDfndItemAttrib4 AS ExpsrMgmtFreeDfndItemAttrib4,
  b.ExpsrMgmtFreeDfndItemAttrib5 AS ExpsrMgmtFreeDfndItemAttrib5,
  b.ExpsrMgmtFreeDfndItemAttrib6 AS ExpsrMgmtFreeDfndItemAttrib6,
  b.ExpsrMgmtFreeDfndItemAttrib7 AS ExpsrMgmtFreeDfndItemAttrib7,
  b.OnBehalfOfCompany AS OnBehalfOfCompany,
  b.Portfolio AS Portfolio,
  b.Segment AS Segment,
  b.BusinessArea AS BusinessArea,
  b.CostCenter AS CostCenter,
  b.ProfitCenter AS ProfitCenter,
  b.WBSElementInternalID AS WBSElementInternalID,
  b.RawExposureName AS RawExposureName,
  c.ExpsrMgmtRiskCategory AS ExpsrMgmtRiskCategory,
  c.ExpsrMgmtExposureCategory AS ExpsrMgmtExposureCategory,
  c.ExpsrMgmtExposureActivity AS ExpsrMgmtExposureActivity
FROM text_rawexpos AS a
INNER JOIN I_RawExposureItem AS b ON /* join condition not captured in parsed metadata */
INNER JOIN I_SubRawExposure AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _OnBehalfOfCompany ON _OnBehalfOfCompany.CompanyCode = OnBehalfOfCompany  -- association [1..1]
LEFT OUTER JOIN I_TreasuryPortfolio AS _TreasuryPortfolio ON _TreasuryPortfolio.Portfolio = Portfolio AND _TreasuryPortfolio.CompanyCode = CompanyCode  -- association [0..1]
;