C_Materialsamplestatus

DDL: C_MATERIALSAMPLESTATUS SQL: CSAMPLESTATUS Type: view CONSUMPTION

CDS View for Material Sample Statuses

C_Materialsamplestatus is a Consumption CDS View that provides data about "CDS View for Material Sample Statuses" in SAP S/4HANA. It reads from 3 data sources (I_StatusCodeText, I_StatusObjectStatus, I_UserStatusText) and exposes 4 fields with key fields StatusObject, StatusCode.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_StatusCodeText _StatusCodeText left_outer
I_StatusObjectStatus _STATUSOBJECTSTATUS inner
I_UserStatusText _UserStatusText left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CSAMPLESTATUS view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label CDS View for Material Sample Statuses view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY StatusObject _StatusObject StatusObject
KEY StatusCode _StatusObject StatusCode
IsUserStatus
StatusNameendasj_txt30asStatusName Status Text 
@AbapCatalog.sqlViewName: 'CSAMPLESTATUS'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #M, dataClass: #CUSTOMIZING }
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'CDS View for Material Sample Statuses'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE


define view C_Materialsamplestatus

  as select distinct from I_StatusObjectActiveStatus as _StatusObject

    inner join            I_StatusObjectStatus       as _STATUSOBJECTSTATUS on _StatusObject.StatusObject = _STATUSOBJECTSTATUS.StatusObject
  //Get system status short name and description

    left outer join       I_StatusCodeText           as _StatusCodeText     on  _StatusObject.StatusCode = _StatusCodeText.StatusCode
                                                                            and _StatusCodeText.Language = $session.system_language
  //Get user status short name and description

    left outer join       I_UserStatusText           as _UserStatusText     on  _StatusObject.StatusProfile = _UserStatusText.StatusProfile
                                                                            and _StatusObject.StatusCode    = _UserStatusText.UserStatus
                                                                            and _UserStatusText.Language    = $session.system_language

{

      @UI.hidden: true
  key _StatusObject.StatusObject,
      @UI.hidden: true
  key _StatusObject.StatusCode,
      _StatusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus,
      @UI.lineItem: [{position:10, importance: #HIGH}]
      @EndUserText.label: 'Status'
      @EndUserText.quickInfo: 'Status'
      cast( case _StatusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus
         when 'X' then _UserStatusText.UserStatusShortName
         else  _StatusCodeText.StatusShortName
      end as j_txt04 )  as StatusShortName,
      @UI.lineItem: [{position:20, importance: #HIGH}]
      @EndUserText.label: 'Status Text'
      @EndUserText.quickInfo: 'Status Text'
      cast(case _StatusObject._StatusCode._StatusCodeText[1:Language=$session.system_language].IsUserStatus
        when 'X' then _UserStatusText.UserStatusName
        else _StatusCodeText.StatusName
      end as j_txt30 )  as StatusName
}
where _StatusObject.StatusObject like 'QP%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STATUSCODE",
"I_STATUSCODETEXT",
"I_STATUSOBJECTACTIVESTATUS",
"I_STATUSOBJECTSTATUS",
"I_USERSTATUSTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More