/APE/R_BusinessMessageIdDraft

DDL: /APE/R_BUSINESSMESSAGEIDDRAFT Type: view_entity BASIC

Business Message ID - Draft

/APE/R_BusinessMessageIdDraft is a Basic CDS View that provides data about "Business Message ID - Draft" in SAP S/4HANA. It reads from 1 data source (/ape/d_bmid_c) and exposes 17 fields with key field config_key.

Data Sources (1)

SourceAliasJoin Type
/ape/d_bmid_c /ape/d_bmid_c from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Message ID - Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY config_key config_key Char
bus_msg_id bus_msg_id
bo_type_uuid bo_type_uuid
bo_type bo_type SOT Name
msg_type msg_type Message Type
market_role market_role
config_layer config_layer
created_at created_at Uploaded On
created_by created_by Version Created By
changed_at changed_at Timestamp
changed_by changed_by User Name
Draftentitycreationdatetime draftentitycreationdatetime Draft Created On
Draftentitylastchangedatetime draftentitylastchangedatetime Draft Last Changed On
Draftadministrativedatauuid draftadministrativedatauuid UUID
Draftentityoperationcode draftentityoperationcode Draft - Operation Code
Hasactiveentity hasactiveentity TRUE
Draftfieldchanges draftfieldchanges Field Changes

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 /APE/R_BusinessMessageIdDraft.
-- 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 /APE/R_BusinessMessageIdDraft AS
SELECT
  config_key,
  bus_msg_id,
  bo_type_uuid,
  bo_type,
  msg_type,
  market_role,
  config_layer,
  created_at,
  created_by,
  changed_at,
  changed_by,
  Draftentitycreationdatetime,
  Draftentitylastchangedatetime,
  Draftadministrativedatauuid,
  Draftentityoperationcode,
  Hasactiveentity,
  Draftfieldchanges
FROM /ape/d_bmid_c
;