/APE/A_TransBORelation

DDL: /APE/A_TRANSBORELATION Type: view CONSUMPTION
5 Fields 1 Data Sources 2 Associations

Business Object Relationship

/APE/A_TransBORelation is a Consumption CDS View that provides data about "Business Object Relationship" in SAP S/4HANA. It reads from 1 data source (/APE/I_TransBORelation_TP) and exposes 5 fields with key field bo_rel_uuid. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_TransBORelation_TP /APE/I_TransBORelation_TP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] /APE/A_TransactionService _trans_header $projection.trans_uuid = _trans_header.trans_uuid
[1..1] /APE/A_TransBOHeader _bo_header $projection.bo_uuid = _bo_header.bo_uuid

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName /APE/A_TRBORL view
AbapCatalog.compiler.compareFilter true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Object Relationship view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY bo_rel_uuid db_key UUID
bo_uuid parent_key UUID
trans_uuid root_key UUID
bo_rel bo_rel
_bo_header _bo_header

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/A_TransBORelation.
-- 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/A_TransBORelation AS
SELECT
  db_key AS bo_rel_uuid,
  parent_key AS bo_uuid,
  root_key AS trans_uuid,
  bo_rel
FROM /APE/I_TransBORelation_TP
LEFT OUTER JOIN /APE/A_TransactionService AS _trans_header ON trans_uuid = _trans_header.trans_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/A_TransBOHeader AS _bo_header ON bo_uuid = _bo_header.bo_uuid  -- association [1..1]
;

Learn More