I_STATUSCODETEXT

CDS View

Status Code Text

I_STATUSCODETEXT is a CDS View in S/4HANA. Status Code Text. 8 CDS views read from this table.

Used by 8 CDS view(s)

CDS Views using this table (8)

ViewTypeJoinVDMDescription
A_ProcessOrderStatus view_entity left_outer COMPOSITE API Process Order Status
A_ProcessOrderStatus_2 view_entity left_outer COMPOSITE Process Order Status
A_ProductionOrderStatus view_entity left_outer COMPOSITE API Production Order Status
A_ProductionOrderStatus_2 view_entity left_outer COMPOSITE Production Order Status
C_InspLotStatus view left_outer CONSUMPTION Status of Inspection Lot Object Page
C_Materialsamplestatus view left_outer CONSUMPTION CDS View for Material Sample Statuses
C_MfgOrderObjPgStatus view left_outer CONSUMPTION Manufacturing Order Operations Status
I_MfgOrderObjPgStatus view_entity left_outer COMPOSITE Manufacturing Order Operations Status 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@AbapCatalog.sqlViewName: 'ISTATUSCODETEXT'
@EndUserText.label: 'Status Code Text'
@Analytics.dataExtraction.enabled: true
@AbapCatalog.preserveKey:true 
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@ObjectModel.usageType.dataClass: #CUSTOMIZING 
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'StatusCode'
define view I_StatusCodeText as select from P_StatusCodeText 
association [0..1] to I_StatusCode as _StatusCode on
    $projection.StatusCode = _StatusCode.StatusCode and
    $projection.StatusProfile = _StatusCode.StatusProfile
association [0..1] to    I_StatusProfile as _StatusProfile on
    $projection.StatusProfile = _StatusProfile.StatusProfile
       
association [0..1] to I_Language as _Language on 
    $projection.Language = _Language.Language 
{
  @ObjectModel.foreignKey.association: '_StatusCode'
  key StatusCode,  
  @ObjectModel.foreignKey.association: '_StatusProfile'
  key StatusProfile,
  @Semantics.language: true
  @ObjectModel.foreignKey.association: '_Language'
  key Language, 
  @Semantics.text: true
  StatusName,
  @Semantics.text: true
  StatusShortName,
  P_StatusCodeText.IsUserStatus,
  _StatusProfile,
  _Language,
  _StatusCode
  
  
}            
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_STATUSCODETEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_STATUSCODE",
"I_STATUSPROFILE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More