I_Bodefinition

DDL: I_BODEFINITION SQL: IBODEFINITION Type: view

Business Object Defnition

I_Bodefinition is a CDS View that provides data about "Business Object Defnition" in SAP S/4HANA. It reads from 3 data sources (sbo_i_bodef, sbo_i_botype, sbo_i_cdsmap) and exposes 6 fields with key fields BusinessObject, BusinessObjectType, BusinessObjectTypeName. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
sbo_i_bodef sbo_i_bodef from
sbo_i_botype sbo_i_botype inner
sbo_i_cdsmap sbo_i_cdsmap inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] sbo_i_botypet _text $projection.BusinessObject = _text.bo_type and _text.bo_text = $projection.bo_text and _text.bo_textlan = $session.system_language

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName IBODEFINITION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Object Defnition view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BusinessObject sbo_i_bodef bo_type SOT Name
KEY BusinessObjectType sbo_i_bodef object_type_category SAP Rep Type
KEY BusinessObjectTypeName sbo_i_bodef object_name Technical Name
ReferenceStructureForKeyField sbo_i_cdsmap key_struct Key Str for SOT
CDSView sbo_i_cdsmap cds_view CDS View for SOT
bo_text _text bo_text SAP Object Type Name

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_Bodefinition.
-- 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: IBODEFINITION

CREATE VIEW I_Bodefinition AS
SELECT
  sbo_i_bodef.bo_type AS BusinessObject,
  sbo_i_bodef.object_type_category AS BusinessObjectType,
  sbo_i_bodef.object_name AS BusinessObjectTypeName,
  sbo_i_cdsmap.key_struct AS ReferenceStructureForKeyField,
  sbo_i_cdsmap.cds_view AS CDSView,
  _text.bo_text AS bo_text
FROM sbo_i_bodef
INNER JOIN sbo_i_cdsmap ON /* join condition not captured in parsed metadata */
INNER JOIN sbo_i_botype ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN sbo_i_botypet AS _text ON BusinessObject = _text.bo_type AND _text.bo_text = bo_text AND _text.bo_textlan = $session.system_language  -- association [1..1]
;