P_ProdnOrdStatusAttrbTxt

DDL: P_PRODNORDSTATUSATTRBTXT Type: view CONSUMPTION Package: CRMS4_SOLUTION_ORDER_PROGRESS

Production Order status text

P_ProdnOrdStatusAttrbTxt is a Consumption CDS View that provides data about "Production Order status text" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderWithStatus) and exposes 4 fields with key field ManufacturingOrder. It has 1 association to related views. Part of development package CRMS4_SOLUTION_ORDER_PROGRESS.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderWithStatus ProductionOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SystemStatusText _SystemStatusText $projection.StatusCode = _SystemStatusText.SystemStatus and _SystemStatusText.Language = $session.system_language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRODORDSTSTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Production Order status text view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder
Material Material
ProductionPlant ProductionPlant
_SystemStatusText _SystemStatusText 
@AbapCatalog: {
   sqlViewName:            'PPRODORDSTSTXT',
   compiler.compareFilter: true,
   preserveKey:            true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
    dataClass:      #MIXED,
    serviceQuality: #C,
    sizeCategory:   #XL
}

@VDM: {
    viewType: #CONSUMPTION,
    private: true
}
@EndUserText.label: 'Production Order status text'

define view P_ProdnOrdStatusAttrbTxt
  as select from I_MfgOrderWithStatus as ProductionOrder

  association [0..1] to I_SystemStatusText        as _SystemStatusText on  $projection.StatusCode         = _SystemStatusText.SystemStatus
                                                                       and _SystemStatusText.Language = $session.system_language
{

  key ManufacturingOrder,
      Material,

      /*
      I0001 -> Created
      I0042 -> Partially Released
      I0002 -> Released
      I0076 -> Flagged for Deletion
      I0010 -> Partially Confirmed
      I0009 -> Confirmed
      I0074 -> Partially Confirmed
      I0012 -> Delivered
      I0043 -> Locked
      I0045 -> Technically Completed
      I0046 -> Closed
      I0013 -> Deleted
      */
      
      ProductionPlant,
      
      case
        when OrderIsDeleted              = 'X'
            then 'I0013'
        when OrderIsClosed               = 'X'
            then 'I0046'
        when OrderIsTechnicallyCompleted = 'X'
            then 'I0045'
        when OrderIsDelivered            = 'X'
            then 'I0012'
        when OrderIsConfirmed            = 'X'
            then 'I0009'
        when OrderIsPartiallyConfirmed   = 'X'
            then 'I0010'
        when OrderIsMarkedForDeletion    = 'X'
            then 'I0076'
        when OrderIsReleased             = 'X'
            then 'I0002'
        when OrderIsPartiallyReleased    = 'X'
            then 'I0042'
        when OrderIsCreated              = 'X'
            then 'I0001'

       else ''
      end                                                                                      as StatusCode,

      _SystemStatusText
}
where
  ManufacturingOrderCategory = '10'

Learn More