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.
@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
defineview P_MfgOrdSystemStatusShortNames
withparameters@Consumption.hidden : true@Environment.systemField : #SYSTEM_LANGUAGE
P_Language : sylangu
asselectfrom I_MfgOrderStatus
{
// Keykey ManufacturingOrder,
ManufacturingOrderCategory,
ManufacturingOrderType,
ProductionPlant,
ManufacturingObject as ObjectInternalID,
case OrderIsCreated
when 'X'
then _OrderIsCreatedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsCreatedShortName,
case OrderIsReleased
when 'X'
then _OrderIsReleasedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsReleasedShortName,
case OrderHasMaterialShortage
when 'X'
then _OrderHasMatlShortageCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderHasMatlShortageShortName,
case OrderIsPrinted
when 'X'
then _OrderIsPrintedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsPrintedShortName,
case OrderIsPartiallyPrinted
when 'X'
then _OrderIsPrtlyPrintedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsPrtlyPrintedShortName,
case OrderIsConfirmed
when 'X'
then _OrderIsConfirmedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsConfirmedShortName,
case OrderIsPartiallyConfirmed
when 'X'
then _OrderIsPrtlyConfirmedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsPrtlyConfirmedShortName,
case OrderIsDelivered
when 'X'
then _OrderIsDeliveredCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsDeliveredShortName,
case OrderIsDeleted
when 'X'
then _OrderIsDeletedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsDeletedShortName,
case OrderIsProductCosted
when 'X'
then _OrderIsProductCostedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsProductCostedShortName,
case OrderIsPreCosted
when 'X'
then _OrderIsPreCostedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsPreCostedShortName,
case OrderIsPartiallyReleased
when 'X'
then _OrderIsPrtlyReleasedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsPrtlyReleasedShortName,
case OrderIsLocked
when 'X'
then _OrderIsLockedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsLockedShortName,
case OrderIsTechnicallyCompleted
when 'X'
then _OrderIsTechlyCmpltdCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsTechlyCmpltdShortName,
case OrderIsClosed
when 'X'
then _OrderIsClosedCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsClosedShortName,
case OrderIsPartiallyDelivered
when 'X'
then _OrderIsPrtlyDeliveredCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsPrtlyDeliveredShortName,
case OrderIsMarkedForDeletion
when 'X'
then _OrderIsMrkdForDeletionCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderIsMarkedForDeltnShortName,
case OrderHasCostCalculationError
when 'X'
then _OrderHasCostCalcErrorCode._StatusCodeText[1: Language=$parameters.P_Language].StatusShortName
else ''
endas OrderHasCostCalcErrorShortName
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERSTATUS",
"I_STATUSCODE",
"I_STATUSCODETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/