I_SAPObjectNodeTypeRprstn

DDL: I_SAPOBJECTNODETYPERPRSTN SQL: IOBJNODEREPRSNTN Type: view BASIC

SAP Object Node Type Representation

I_SAPObjectNodeTypeRprstn is a Basic CDS View that provides data about "SAP Object Node Type Representation" in SAP S/4HANA. It reads from 3 data sources (sbo_i_node_cds, sbo_i_nodetype, sbo_i_node_cds) and exposes 7 fields with key field SAPObjectNodeType.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
sbo_i_node_cds RepresentativeView left_outer
sbo_i_nodetype sbo_i_nodetype from
sbo_i_node_cds ValueHelpView left_outer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IOBJNODEREPRSNTN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
EndUserText.label SAP Object Node Type Representation view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey SAPObjectNodeType view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY SAPObjectNodeType sbo_i_nodetype object_node_type
SAPObjectType bo_type
SONTWorkflowBORRprstn workflow_bor_rprst
SONTWorkflowClassRprstn workflow_class_rprst
SONTKeyStructure workflow_key_structure
SONTRepresentativeCDSView sbo_i_node_cds cds_view_name
SONTValueHelpCDSView sbo_i_node_cds cds_view_name 
@AbapCatalog.sqlViewName: 'IOBJNODEREPRSNTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #BASIC
@EndUserText.label: 'SAP Object Node Type Representation'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl:{
                 authorizationCheck: #NOT_REQUIRED,
                 personalData.blocking: #NOT_REQUIRED
               }
@ObjectModel: {
                usageType: {   dataClass:  #MASTER,
                               sizeCategory: #M,
                               serviceQuality: #A
                            },
                representativeKey: 'SAPObjectNodeType'
              }

define view I_SAPObjectNodeTypeRprstn
  as select from    sbo_i_nodetype
    left outer join sbo_i_node_cds as RepresentativeView on  RepresentativeView.node_cds_type = '1'
                                                         and sbo_i_nodetype.object_node_type  = RepresentativeView.object_node_type
    left outer join sbo_i_node_cds as ValueHelpView      on  ValueHelpView.node_cds_type     = '2'
                                                         and sbo_i_nodetype.object_node_type = ValueHelpView.object_node_type
{


      //sbo_i_nodetype

  key sbo_i_nodetype.object_node_type  as SAPObjectNodeType,
      bo_type                          as SAPObjectType,
      workflow_bor_rprst               as SONTWorkflowBORRprstn,
      workflow_class_rprst             as SONTWorkflowClassRprstn,
      workflow_key_structure           as SONTKeyStructure,
      //RepresentativeView


      RepresentativeView.cds_view_name as SONTRepresentativeCDSView,
      //ValueHelpView


      ValueHelpView.cds_view_name      as SONTValueHelpCDSView

}

Learn More