CDB_OBJ_INFO

DDL: CDB_OBJ_INFO Type: view_entity

CDB Object Information

CDB_OBJ_INFO is a CDS View that provides data about "CDB Object Information" in SAP S/4HANA. It reads from 7 data sources and exposes 19 fields with key field CDBOObjectName.

7 data source(s) 19 fields

Data Sources (7)

SourceAliasJoin Type
cdb_objd cdb_objd left_outer
cdb_objh cdb_objh from
cdb_objt cdb_objt left_outer
df14l df14l left_outer
df14t df14t left_outer
tadir tadir left_outer
tdevc tdevc left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDB Object Information view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CDBOObjectName cdb_objh obj_name
CDBOObjectText cdb_objt text
CDBORefObjType cdb_objh exp_obj_type
CDBORefObjName cdb_objh exp_obj_name
CDBOStatus cdb_objh status
CDBOCreatedBy cdb_objh created_by
CDBOCreatedOn cdb_objh created_on
CDBOChangedBy cdb_objh changed_by
CDBOChangedOn cdb_objh changed_on
CDBOPackage tadir devclass
CDBOSrcSystem tadir srcsystem
CDBOApplComp df14l ps_posid
CDBOApplCompName df14t name
CDBODeliveryUnit tdevc dlvunit
BusinessArea cdb_objd business_area
SubBusArea cdb_objd sub_bus_area
PsPosid cdb_objd ps_posid
CdsViewType cdb_objd cds_view_type
CdsViewStatus cdb_objd cds_view_status 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDB Object Information'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity CDB_OBJ_INFO 
  as select from cdb_objh 
    left outer join cdb_objt
                 on cdb_objt.obj_name = cdb_objh.obj_name and
                    cdb_objt.spras = $session.system_language
                    
    left outer join cdb_objd
               on   cdb_objd.obj_name = cdb_objh.obj_name
  
    left outer join tadir
            on tadir.object = 'CDBO' and 
               tadir.obj_name = cdb_objh.obj_name
               
    left outer join tdevc
            on tdevc.devclass = tadir.devclass
            
    left outer join df14l
            on df14l.fctr_id = tdevc.component and
               df14l.as4local = 'A'
               
    left outer join df14t
            on df14t.langu = $session.system_language and
               df14t.fctr_id = tdevc.component and
               df14t.as4local = 'A'                    
  {
    key cdb_objh.obj_name as CDBOObjectName,
        
        cdb_objt.text as CDBOObjectText,
        
        cdb_objh.exp_obj_type as CDBORefObjType,
        
        cdb_objh.exp_obj_name as CDBORefObjName,
        
        cdb_objh.status as CDBOStatus,
        
        cdb_objh.created_by as CDBOCreatedBy,
        
        cdb_objh.created_on as CDBOCreatedOn,
        
        cdb_objh.changed_by as CDBOChangedBy,
        
        cdb_objh.changed_on as CDBOChangedOn,
        
        tadir.devclass as CDBOPackage,
        
        tadir.srcsystem as CDBOSrcSystem,
        
        df14l.ps_posid as CDBOApplComp,  
      
        df14t.name as CDBOApplCompName,    
      
        tdevc.dlvunit as CDBODeliveryUnit,
        
        cdb_objd.business_area as BusinessArea,
        
        cdb_objd.sub_bus_area as SubBusArea,
        
        cdb_objd.ps_posid as PsPosid,
        
        cdb_objd.cds_view_type as CdsViewType,
        
        cdb_objd.cds_view_status as CdsViewStatus      
  }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CDB_OBJD",
"CDB_OBJH",
"CDB_OBJT",
"DF14L",
"DF14T",
"TADIR",
"TDEVC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More