P_MfgOrdSystemStatusShortNames

DDL: P_MFGORDSYSTEMSTATUSSHORTNAMES SQL: PMFGORDSYSTSSNAM Type: view COMPOSITE

P_MfgOrdSystemStatusShortNames is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MfgOrderStatus) and exposes 5 fields with key field ManufacturingOrder.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderStatus I_MfgOrderStatus from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMFGORDSYSTSSNAM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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
@AbapCatalog.sqlViewName: 'PMFGORDSYSTSSNAM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@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 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
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERSTATUS",
"I_STATUSCODE",
"I_STATUSCODETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/