I_BusEvtSubscrpnStateMappg

DDL: I_BUSEVTSUBSCRPNSTATEMAPPG SQL: IBUSEVTSUBSTMAP Type: view COMPOSITE
9 Fields 2 Data Sources

Business Event Handling Subscription State Mapping

I_BusEvtSubscrpnStateMappg is a Composite CDS View that provides data about "Business Event Handling Subscription State Mapping" in SAP S/4HANA. It reads from 2 data sources (I_BusEvtSubBusObj, I_BusEvtSubText) and exposes 9 fields with key fields BusEventSubscriberCode, SAPObjectType, SAPObjectTaskCode.

Data Sources (2)

SourceAliasJoin Type
I_BusEvtSubBusObj I_BusEvtSubBusObj from
I_BusEvtSubText I_BusEvtSubText left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBUSEVTSUBSTMAP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Business Event Handling Subscription State Mapping view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusEventSubscriberCode I_BusEvtSubBusObj BusEventSubscriberCode
KEY SAPObjectType I_BusEvtSubBusObj SAPObjectType SOT Name
KEY SAPObjectTaskCode I_BusEvtSubBusObj SAPObjectTaskCode
SAPObjectTaskTypeName I_BusEvtSubBusObj SAPObjectTaskTypeName
SAPObjectTypeName I_BusEvtSubBusObj SAPObjectTypeName
BusinessEventSubscriberName I_BusEvtSubBusObj BusinessEventSubscriberName
BusEventPriority I_BusEvtSubText BusEventPriority
CreatedByUser I_BusEvtSubText CreatedByUser User Name
CreationUTCDateTime I_BusEvtSubText CreationUTCDateTime Time Stamp

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_BusEvtSubscrpnStateMappg.
-- 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: IBUSEVTSUBSTMAP

CREATE VIEW I_BusEvtSubscrpnStateMappg AS
SELECT
  I_BusEvtSubBusObj.BusEventSubscriberCode AS BusEventSubscriberCode,
  I_BusEvtSubBusObj.SAPObjectType AS SAPObjectType,
  I_BusEvtSubBusObj.SAPObjectTaskCode AS SAPObjectTaskCode,
  I_BusEvtSubBusObj.SAPObjectTaskTypeName AS SAPObjectTaskTypeName,
  I_BusEvtSubBusObj.SAPObjectTypeName AS SAPObjectTypeName,
  I_BusEvtSubBusObj.BusinessEventSubscriberName AS BusinessEventSubscriberName,
  I_BusEvtSubText.BusEventPriority AS BusEventPriority,
  I_BusEvtSubText.CreatedByUser AS CreatedByUser,
  I_BusEvtSubText.CreationUTCDateTime AS CreationUTCDateTime
FROM I_BusEvtSubBusObj
LEFT OUTER JOIN I_BusEvtSubText ON /* join condition not captured in parsed metadata */
;

Learn More