I_LglCntntMNotesObjTypes

DDL: I_LGLCNTNTMNOTESOBJTYPES SQL: ILCMNTOBJTYPES Type: view BASIC

Object Types and Desc. related to Notes

I_LglCntntMNotesObjTypes is a Basic CDS View that provides data about "Object Types and Desc. related to Notes" in SAP S/4HANA. It reads from 2 data sources (dd07l, dd07t) and exposes 2 fields with key field LglCntntMObjType.

Data Sources (2)

SourceAliasJoin Type
dd07l dd07l from
dd07t dd07t inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ILCMNTOBJTYPES view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Object Types and Desc. related to Notes view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMObjType
LglCntntMObjTypeDesc dd07t ddtext
@AbapCatalog.sqlViewName: 'ILCMNTOBJTYPES'
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S

@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Object Types and Desc. related to Notes'
define view I_LglCntntMNotesObjTypes
  as select from dd07l
    inner join   dd07t on  dd07t.domname    = dd07l.domname
                       and dd07t.ddlanguage = $session.system_language
                       and dd07t.as4local   = dd07l.as4local
                       and dd07t.valpos     = dd07l.valpos
{
      //dd07l

  key cast( dd07t.domvalue_l as lcm_note_object_type) as LglCntntMObjType,
      dd07t.ddtext                                    as LglCntntMObjTypeDesc
}
where
      dd07t.domname  = 'LCM_NOTE_OBJECT_TYPE'
  and dd07t.as4local = 'A'