I_EAMUserDefaultValues

DDL: I_EAMUSERDEFAULTVALUES SQL: IEAMUSRDFVALUES Type: view BASIC

User Default Values

I_EAMUserDefaultValues is a Basic CDS View that provides data about "User Default Values" in SAP S/4HANA. It reads from 1 data source (tpmus) and exposes 15 fields with key field UserID. It has 2 associations to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
tpmus tpmus from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PMNotificationType _NotificationType _NotificationType.NotificationType = $projection.NotificationType
[0..1] I_OrderType _OrderType _OrderType.OrderType = $projection.OrderType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEAMUSRDFVALUES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label User Default Values view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY UserID tpmus uname
WorkCenterInternalID tpmus gewrk
WorkCenterTypeCode tpmus pm_objty
NotificationType tpmus qmart
OrderType tpmus auart
StorageLocation tpmus eam_default_storage_location
IssuingPlant tpmus qmawerk
SetDeletionFlagAndNotifStatus tpmus eams_dlfl
ResetDeltnFlagAndSetNotifSts tpmus eams_reset_dlfl
CompleteTechlyAndSetNotifSts tpmus eams_teco
ResetTechCompltnAndSetNotifSts tpmus eams_reset_teco
DoNotExectOrderAndSetNotifSts tpmus eams_do_not_exec
CompleteBusinessAndSetNotifSts tpmus eams_close
_NotificationType _NotificationType
_OrderType _OrderType 
@AbapCatalog.sqlViewName: 'IEAMUSRDFVALUES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'User Default Values'

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

define view I_EAMUserDefaultValues
  as select from tpmus
  association [0..1] to I_PMNotificationType as _NotificationType on _NotificationType.NotificationType = $projection.NotificationType
  association [0..1] to I_OrderType          as _OrderType        on _OrderType.OrderType = $projection.OrderType
{
  key tpmus.uname                        as UserID,

      tpmus.gewrk                        as WorkCenterInternalID,
      tpmus.pm_objty                     as WorkCenterTypeCode,
      @ObjectModel.foreignKey.association: '_NotificationType'
      tpmus.qmart                        as NotificationType,
      @ObjectModel.foreignKey.association: '_OrderType'
      tpmus.auart                        as OrderType,

      tpmus.eam_default_storage_location as StorageLocation,
      tpmus.qmawerk                      as IssuingPlant,
      tpmus.eams_dlfl                    as SetDeletionFlagAndNotifStatus,
      tpmus.eams_reset_dlfl              as ResetDeltnFlagAndSetNotifSts,
      tpmus.eams_teco                    as CompleteTechlyAndSetNotifSts,
      tpmus.eams_reset_teco              as ResetTechCompltnAndSetNotifSts,
      tpmus.eams_do_not_exec             as DoNotExectOrderAndSetNotifSts,
      tpmus.eams_close                   as CompleteBusinessAndSetNotifSts,




      //tpmus.prwin    as IndivSelWhenPrintingFrmList,


      _NotificationType,
      _OrderType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TPMUS"
],
"ASSOCIATED":
[
"I_ORDERTYPE",
"I_PMNOTIFICATIONTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More