I_STATUSCODETEXT

CDS View

Status Code Text

I_STATUSCODETEXT is a CDS View in S/4HANA. Status Code Text. It contains 3 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 3 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_ProcessOrderStatus view_entity left_outer COMPOSITE API Process Order Status
A_ProductionOrderStatus view_entity left_outer COMPOSITE API 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_ManufacturingOrderStatusText view_entity inner COMPOSITE Manufacturing Order Status - Text
I_MfgOrderObjPgStatus view_entity left_outer COMPOSITE Manufacturing Order Operations Status

Fields (3)

KeyField CDS FieldsUsed in Views
_Language _Language 1
StatusName StatusName 1
StatusShortName StatusShortName 1 
@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
  
  
}

Learn More