P_MFGORDERSYSTEMSTATUSTEXT

CDS View

P_MFGORDERSYSTEMSTATUSTEXT is a CDS View in S/4HANA. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MfgOrderSystemStatusText view_entity from COMPOSITE Manufacturing Order System Status - Text
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// Builds the single texts later to be concatenated in I_MfgOrderSystemStatusText.

// Sequence is in accordance to TJ04-LINEP and -STATP of SAP's standard delivery (client 100). 


define view entity P_MfgOrderSystemStatusText
      with parameters 
      @Consumption.hidden : true
      @Environment.systemField : #SYSTEM_LANGUAGE
      P_Language : sylangu
      as select from  P_MfgOrdSystemStatusShortNames(P_Language : $parameters.P_Language) 

{    
      // Key

  key ManufacturingOrder,
  
      ManufacturingOrderCategory,
      ManufacturingOrderType,
      ProductionPlant,
      ObjectInternalID,
  
      // LINEP 1 -- release/close status 

      case OrderIsCreatedShortName
        when ''
        then case OrderIsReleasedShortName
          when ''
          then case OrderIsPrtlyReleasedShortName
            when''
            then case OrderIsTechlyCmpltdShortName
              when '' 
              then case OrderIsClosedShortName
                when '' then '' 
                else OrderIsClosedShortName
                end
              else OrderIsTechlyCmpltdShortName
              end
            else OrderIsPrtlyReleasedShortName
            end
          else OrderIsReleasedShortName
          end
        else OrderIsCreatedShortName
      end as Text1,
      
      // LINEP 2 -- shortage status

      case OrderHasMatlShortageShortName
        when '' then ''
        else OrderHasMatlShortageShortName
      end as Text2,
      
      // LINEP 3 -- print status

      case OrderIsPrintedShortName
        when ''
        then case OrderIsPrtlyPrintedShortName
          when '' then '' 
          else OrderIsPrtlyPrintedShortName
          end
        else OrderIsPrintedShortName  
      end as Text3,
      
      // LINEP 4 -- confirmation status

      case OrderIsConfirmedShortName
        when ''
        then case OrderIsPrtlyConfirmedShortName
          when '' then '' 
          else OrderIsPrtlyConfirmedShortName
          end
        else OrderIsConfirmedShortName  
      end as Text4,
      
      // LINEP 5 -- delivery status

      case OrderIsDeliveredShortName
        when ''
        then case OrderIsPrtlyDeliveredShortName
          when '' then '' 
          else OrderIsPrtlyDeliveredShortName
          end
        else OrderIsDeliveredShortName  
      end as Text5,    

      // LINEP 6 -- deletion status

      case OrderIsDeletedShortName
        when '' then ''
        else OrderIsDeletedShortName
      end as Text6, 

      // LINEP 7 -- costing status

      case OrderIsProductCostedShortName
        when ''
        then case OrderIsPreCostedShortName
          when '' then '' 
          else OrderIsPreCostedShortName
          end
        else OrderIsProductCostedShortName  
      end as Text7, 

      // LINEP 8 -- lock status

      case OrderIsLockedShortName
        when '' then ''
        else OrderIsLockedShortName
      end as Text8,      

      // LINEP 9 -- marked for deletion

      case OrderIsMarkedForDeltnShortName
        when '' then ''
        else OrderIsMarkedForDeltnShortName
      end as Text9, 

      // LINEP 10 -- costing error status

      case OrderHasCostCalcErrorShortName
        when '' then ''
        else OrderHasCostCalcErrorShortName
      end as Text10 
  
      // LINEP11 -- distribution status

      -- coming soon on this channel      
  
};