I_MatlSrlNmbrSystemStatusName

DDL: I_MATLSRLNMBRSYSTEMSTATUSNAME Type: view_entity COMPOSITE Package: ODATA_LO_SN_HISTORY

Serial Number System Status Name

I_MatlSrlNmbrSystemStatusName is a Composite CDS View that provides data about "Serial Number System Status Name" in SAP S/4HANA. It reads from 2 data sources (I_StatusObjectActiveStatus, I_StatusCode) and exposes 7 fields with key fields StatusObject, StatusCode. Part of development package ODATA_LO_SN_HISTORY.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_StatusObjectActiveStatus _StatusObjectActiveStatus from
I_StatusCode _SystStatusCode inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Serial Number System Status Name view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY StatusObject I_StatusObjectActiveStatus StatusObject
KEY StatusCode I_StatusObjectActiveStatus StatusCode
IsUserStatus I_StatusObjectActiveStatus IsUserStatus
StatusProfile I_StatusObjectActiveStatus StatusProfile
StatusSequenceNumber I_StatusCode StatusSequenceNumber
StatusName
StatusShortName 
@AccessControl: { authorizationCheck: #NOT_REQUIRED,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #COMPOSITE

@ObjectModel.usageType: {
        dataClass:      #TRANSACTIONAL,
        serviceQuality: #C,
        sizeCategory:   #XL }
@ObjectModel.supportedCapabilities: [
  #SQL_DATA_SOURCE,
  #CDS_MODELING_DATA_SOURCE,
  #CDS_MODELING_ASSOCIATION_TARGET
]

@EndUserText.label: 'Serial Number System Status Name'


define view entity I_MatlSrlNmbrSystemStatusName
  as select from I_StatusObjectActiveStatus as _StatusObjectActiveStatus
    inner join   I_StatusCode               as _SystStatusCode on  _SystStatusCode.StatusCode    = _StatusObjectActiveStatus.StatusCode
                                                           and _SystStatusCode.StatusProfile = _StatusObjectActiveStatus.StatusProfile
{
  key _StatusObjectActiveStatus.StatusObject,
  key _StatusObjectActiveStatus.StatusCode,

      _StatusObjectActiveStatus.IsUserStatus,
      _StatusObjectActiveStatus.StatusProfile,

      _SystStatusCode.StatusSequenceNumber,
      
      _SystStatusCode._StatusCodeText[ 1:Language = $session.system_language ].StatusName,
      _SystStatusCode._StatusCodeText[ 1:Language = $session.system_language ].StatusShortName
}
where
      _SystStatusCode.StatusIsHidden             = ''
  and _StatusObjectActiveStatus.IsUserStatus = ''

Learn More