P_RawExposure

DDL: P_RAWEXPOSURE Type: view COMPOSITE

P_RawExposure is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_RawExposure) and exposes 46 fields with key fields RawExposureUUID, RawExposureItemID, RawExposureSubItemID.

Data Sources (1)

SourceAliasJoin Type
I_RawExposure I_RawExposure from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PRAWEXP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY RawExposureUUID RawExposureUUID Lot
KEY RawExposureItemID RawExposureItemID
KEY RawExposureSubItemID RawExposureSubItemID
CompanyCode CompanyCode Receiver Company Code
RawExposureActivityType RawExposureActivityType Exp. Activity Type
ExpsrMgmtFreeDefinedHeaderDate ExpsrMgmtFreeDefinedHeaderDate Free Attr. (Date)
ExpsrMgmtFreeDfndHeaderAttrib1 ExpsrMgmtFreeDfndHeaderAttrib1 Value of Free Attr.
ExpsrMgmtFreeDfndHeaderAttrib2 ExpsrMgmtFreeDfndHeaderAttrib2 Value of Free Attr.
ExpsrMgmtFreeDfndHeaderAttrib3 ExpsrMgmtFreeDfndHeaderAttrib3 Free Attr. (Char20)
Country Country Venue: Ctry/Reg
RawExposureOrigin RawExposureOrigin Exposure Origin
OriginSystem OriginSystem LogSys: Formula
RawExposureCreationDate RawExposureCreationDate Time Stamp
CreationTransactionCode CreationTransactionCode Creation TCode
RawExposureCreationTime RawExposureCreationTime Time Stamp
LastChangeDate LastChangeDate Time Stamp
ChangeTransactionCode ChangeTransactionCode Change Tcode
RawExposureChangeTime RawExposureChangeTime Last Edited At
RawExposureOriginDateTime RawExposureOriginDateTime Origin Timestamp
RawExposureItemExtItemID RawExposureItemExtItemID
ExposureDueDate ExposureDueDate
ExpsrAmountInExposureCurrency ExpsrAmountInExposureCurrency
ExposureCurrency ExposureCurrency
TargetCurrency TargetCurrency
ExpsrMgmtPaymentDate ExpsrMgmtPaymentDate
ExpMgmtExposurePlanningPeriod ExpMgmtExposurePlanningPeriod
ExpsrMgmtExposurePlanningYear ExpsrMgmtExposurePlanningYear
ExpsrMgmtFreeDefinedItemDate ExpsrMgmtFreeDefinedItemDate
ExpsrMgmtFreeDfndItemAttrib1 ExpsrMgmtFreeDfndItemAttrib1
ExpsrMgmtFreeDfndItemAttrib2 ExpsrMgmtFreeDfndItemAttrib2
ExpsrMgmtFreeDfndItemAttrib3 ExpsrMgmtFreeDfndItemAttrib3
ExpsrMgmtFreeDfndItemAttrib4 ExpsrMgmtFreeDfndItemAttrib4
ExpsrMgmtFreeDfndItemAttrib5 ExpsrMgmtFreeDfndItemAttrib5
ExpsrMgmtFreeDfndItemAttrib6 ExpsrMgmtFreeDfndItemAttrib6
ExpsrMgmtFreeDfndItemAttrib7 ExpsrMgmtFreeDfndItemAttrib7
OnBehalfOfCompany OnBehalfOfCompany
Portfolio Portfolio Portfolio
Segment Segment Segment number
BusinessArea BusinessArea Business Area
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
WBSElementInternalID WBSElementInternalID WBS Internal ID
RawExposureName RawExposureName
ExpsrMgmtRiskCategory ExpsrMgmtRiskCategory
ExpsrMgmtExposureCategory ExpsrMgmtExposureCategory
ExpsrMgmtExposureActivity ExpsrMgmtExposureActivity

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 P_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 P_RawExposure AS
SELECT
  RawExposureUUID,
  RawExposureItemID,
  RawExposureSubItemID,
  CompanyCode,
  RawExposureActivityType,
  ExpsrMgmtFreeDefinedHeaderDate,
  ExpsrMgmtFreeDfndHeaderAttrib1,
  ExpsrMgmtFreeDfndHeaderAttrib2,
  ExpsrMgmtFreeDfndHeaderAttrib3,
  Country,
  RawExposureOrigin,
  OriginSystem,
  RawExposureCreationDate,
  CreationTransactionCode,
  RawExposureCreationTime,
  LastChangeDate,
  ChangeTransactionCode,
  RawExposureChangeTime,
  RawExposureOriginDateTime,
  RawExposureItemExtItemID,
  ExposureDueDate,
  ExpsrAmountInExposureCurrency,
  ExposureCurrency,
  TargetCurrency,
  ExpsrMgmtPaymentDate,
  ExpMgmtExposurePlanningPeriod,
  ExpsrMgmtExposurePlanningYear,
  ExpsrMgmtFreeDefinedItemDate,
  ExpsrMgmtFreeDfndItemAttrib1,
  ExpsrMgmtFreeDfndItemAttrib2,
  ExpsrMgmtFreeDfndItemAttrib3,
  ExpsrMgmtFreeDfndItemAttrib4,
  ExpsrMgmtFreeDfndItemAttrib5,
  ExpsrMgmtFreeDfndItemAttrib6,
  ExpsrMgmtFreeDfndItemAttrib7,
  OnBehalfOfCompany,
  Portfolio,
  Segment,
  BusinessArea,
  CostCenter,
  ProfitCenter,
  WBSElementInternalID,
  RawExposureName,
  ExpsrMgmtRiskCategory,
  ExpsrMgmtExposureCategory,
  ExpsrMgmtExposureActivity
FROM I_RawExposure
;