P_MFGORDERSYSTEMSTATUSTEXT
P_MFGORDERSYSTEMSTATUSTEXT is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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
};