P_MfgOrdSystemStatusShortNames

DDL: P_MFGORDSYSTEMSTATUSSHORTNAMES Type: view_entity COMPOSITE Package: VDM_PP_SFC

Manufacturing Order System Status Short Names

P_MfgOrdSystemStatusShortNames is a Composite CDS View that provides data about "Manufacturing Order System Status Short Names" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderStatus) and exposes 5 fields with key field ManufacturingOrder. Part of development package VDM_PP_SFC.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderStatus I_MfgOrderStatus from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
ProductionPlant ProductionPlant
ObjectInternalID ManufacturingObject 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// Determines the language-dependent short names of the order header status

// Will be concatenated later in P_MfgOrderStatusText


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

{    
          // Key

  key ManufacturingOrder,

      ManufacturingOrderCategory,
      ManufacturingOrderType,
      ProductionPlant,
      ManufacturingObject as ObjectInternalID,

      case OrderIsCreated
        when 'X'
        then  _OrderIsCreatedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsCreatedShortName,
      
      case OrderIsReleased
        when 'X'
        then  _OrderIsReleasedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsReleasedShortName,
      
      case OrderHasMaterialShortage
        when 'X'
        then  _OrderHasMatlShortageCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderHasMatlShortageShortName,
      
      case OrderIsPrinted
        when 'X'
        then  _OrderIsPrintedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsPrintedShortName,
 
      case OrderIsPartiallyPrinted
        when 'X'
        then  _OrderIsPrtlyPrintedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsPrtlyPrintedShortName,

      case OrderIsConfirmed
        when 'X'
        then  _OrderIsConfirmedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsConfirmedShortName,

      case OrderIsPartiallyConfirmed
        when 'X'
        then  _OrderIsPrtlyConfirmedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsPrtlyConfirmedShortName,

      case OrderIsDelivered
        when 'X'
        then  _OrderIsDeliveredCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsDeliveredShortName,  
      
      case OrderIsDeleted
        when 'X'
        then  _OrderIsDeletedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsDeletedShortName,

      case OrderIsProductCosted
        when 'X'
        then  _OrderIsProductCostedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsProductCostedShortName,

      case OrderIsPreCosted
        when 'X'
        then  _OrderIsPreCostedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsPreCostedShortName,

      case OrderIsPartiallyReleased
        when 'X'
        then  _OrderIsPrtlyReleasedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsPrtlyReleasedShortName,

      case OrderIsLocked
        when 'X'
        then  _OrderIsLockedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsLockedShortName,

      case OrderIsTechnicallyCompleted
        when 'X'
        then  _OrderIsTechlyCmpltdCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsTechlyCmpltdShortName,

      case OrderIsClosed
        when 'X'
        then  _OrderIsClosedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsClosedShortName,    
      
      case OrderIsPartiallyDelivered
        when 'X'
        then  _OrderIsPrtlyDeliveredCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsPrtlyDeliveredShortName,

      case OrderIsMarkedForDeletion
        when 'X'
        then  _OrderIsMrkdForDeletionCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderIsMarkedForDeltnShortName,

      case OrderHasCostCalculationError
        when 'X'
        then  _OrderHasCostCalcErrorCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
        else ''
      end as OrderHasCostCalcErrorShortName
};

Learn More