I_GhoNetObj_Db

DDL: I_GHONETOBJ_DB SQL: IGHONETOBJDB Type: view BASIC

Network Object Details and Description

I_GhoNetObj_Db is a Basic CDS View that provides data about "Network Object Details and Description" in SAP S/4HANA. It reads from 1 data source (gho_iflot_ext) and exposes 12 fields with key field OpPerfMgmtNtwkObj. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
gho_iflot_ext gho_iflot_ext from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_GhoNetObjText _Text $projection.OpPerfMgmtNtwkObj = _Text.NetworkObject

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IGHONETOBJDB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey OpPerfMgmtNtwkObj view
EndUserText.label Network Object Details and Description view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY OpPerfMgmtNtwkObj gho_iflot_ext tplnr
NetworkObjectDescription _Text NetworkObjectDescription
NetworkObjectType gho_iflot_ext gho_netobj_type
WellName gho_iflot_ext gho_well_name
WellType gho_iflot_ext well_type
WellCompletionType gho_iflot_ext gho_wc_type
Reservoir gho_iflot_ext gho_reservoir
WellConcession gho_iflot_ext gho_concession
UpstreamOilField gho_iflot_ext gho_field
PumpDescription gho_iflot_ext gho_pump_descr
StartOfBusinessDay gho_iflot_ext gho_pn_sbd
TankID gho_iflot_ext seqnr 
// Extracting Network Object details

// Also Associated with the View of its Description

@AbapCatalog.sqlViewName: 'IGHONETOBJDB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataExtraction.enabled: true

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'OpPerfMgmtNtwkObj'

@EndUserText.label: 'Network Object Details and Description'

define view I_GhoNetObj_Db
  as select from gho_iflot_ext
  association [0..*] to I_GhoNetObjText as _Text on $projection.OpPerfMgmtNtwkObj = _Text.NetworkObject

{

  key gho_iflot_ext.tplnr            as OpPerfMgmtNtwkObj,

      @Semantics.text: true
      _Text.NetworkObjectDescription,

      gho_iflot_ext.gho_netobj_type  as NetworkObjectType,

      gho_iflot_ext.gho_well_name    as WellName,

      gho_iflot_ext.well_type        as WellType,

      gho_iflot_ext.gho_wc_type      as WellCompletionType,

      gho_iflot_ext.gho_reservoir    as Reservoir,

      gho_iflot_ext.gho_concession   as WellConcession,

      gho_iflot_ext.gho_field        as UpstreamOilField,
  
      gho_iflot_ext.gho_pump_descr   as PumpDescription,

      gho_iflot_ext.gho_pn_sbd       as StartOfBusinessDay,

      gho_iflot_ext.seqnr            as TankID

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GHONETOBJTEXT",
"GHO_IFLOT_EXT"
],
"ASSOCIATED":
[
"I_GHONETOBJTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More