C_ProcessOrderObjPgItem
Process Order Items
C_ProcessOrderObjPgItem is a Consumption CDS View (Dimension) that provides data about "Process Order Items" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderItem) and exposes 23 fields with key fields ManufacturingOrder, ManufacturingOrderItem. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MfgOrderItem | I_MfgOrderItem | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_StorageLocation | _StorageLocation | $projection.ProductionPlant = _StorageLocation.Plant and $projection.StorageLocation = _StorageLocation.StorageLocation |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Process Order Items | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Metadata.allowExtensions | true | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| ObjectModel.representativeKey | ManufacturingOrderItem | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| UI.headerInfo.typeName | Item | view | |
| UI.headerInfo.typeNamePlural | Items | view |
Fields (23)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ManufacturingOrder | ManufacturingOrder | Process Order | |
| KEY | ManufacturingOrderItem | ManufacturingOrderItem | ||
| ProductionPlant | ProductionPlant | |||
| Material | Material | |||
| MaterialName | ||||
| MRPPlant | MRPPlant | |||
| MfgOrderItemActualDeliveryDate | MfgOrderItemActualDeliveryDate | |||
| MfgOrderItemPlannedTotalQty | MfgOrderItemPlannedTotalQty | |||
| MfgOrderItemPlannedScrapQty | MfgOrderItemPlannedScrapQty | |||
| MfgOrderItemGoodsReceiptQty | MfgOrderItemGoodsReceiptQty | Goods Receipt Quantity | ||
| MfgOrderItemActualDeviationQty | MfgOrderItemActualDeviationQty | |||
| ProductionUnit | ProductionUnit | |||
| MRPArea | MRPArea | |||
| StorageLocation | StorageLocation | |||
| ManufacturingOrderType | ManufacturingOrderType | |||
| ManufacturingOrderCategory | ManufacturingOrderCategory | |||
| MfgOrderItemPlndDeliveryDate | MfgOrderItemPlndDeliveryDate | |||
| _MRPArea | _MRPArea | |||
| _ProductionPlant | _ProductionPlant | |||
| _Material | _Material | |||
| _MfgOrder | _MfgOrder | |||
| _MRPPlant | _MRPPlant | |||
| _StorageLocation | _StorageLocation |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Process Order Items'
@VDM.viewType: #CONSUMPTION
@Metadata.allowExtensions: true
@Analytics: {dataCategory: #DIMENSION}
@ObjectModel.representativeKey: 'ManufacturingOrderItem'
@ObjectModel.semanticKey: ['ManufacturingOrder', 'ManufacturingOrderItem']
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@UI.headerInfo.typeName: 'Item'
@UI.headerInfo.typeNamePlural: 'Items'
define view entity C_ProcessOrderObjPgItem
as select from I_MfgOrderItem
association [0..1] to I_StorageLocation as _StorageLocation on $projection.ProductionPlant = _StorageLocation.Plant
and $projection.StorageLocation = _StorageLocation.StorageLocation
{
//ITEMS
@ObjectModel.foreignKey.association: '_MfgOrder'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderStdVH', element: 'ManufacturingOrder' } } ]
@EndUserText.label: 'Process Order'
key ManufacturingOrder,
@UI.lineItem: [{position:10}]
key ManufacturingOrderItem, // ProductionOrderItem,
@UI.hidden: true
ProductionPlant,
@Consumption.semanticObject: 'Material'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialStdVH', element: 'Material' } } ]
@UI.lineItem:[ {position: 20} ]
@UI.identification:[ {type: #WITH_INTENT_BASED_NAVIGATION,semanticObjectAction: 'display' } ]
Material, // Material,
@UI.lineItem: [{position:25}]
cast( _Material._Text[1:Language = $session.system_language ].MaterialName as maktx) as MaterialName, //MaterialDescription
@UI.lineItem: [{position:30}]
@Consumption.valueHelpDefinition: [{ entity: { name: 'I_PlantVH', element: 'Plant' } }]
MRPPlant, // PlanningPlant,
@UI.lineItem: [{position:80}]
MfgOrderItemActualDeliveryDate, // DeliveryDate,
@Consumption.semanticObject: ''
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@UI.lineItem:[ {position: 50} ]
MfgOrderItemPlannedTotalQty, // TotalQuantity,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@UI.lineItem: [{position:60}]
MfgOrderItemPlannedScrapQty, // ScrapQuantity,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@UI.lineItem: [{position:70}]
@EndUserText.label: 'Goods Receipt Quantity'
MfgOrderItemGoodsReceiptQty, // ReceiptQuantity,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
MfgOrderItemActualDeviationQty, // ExpectedVariance,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_UnitOfMeasureStdVH', element: 'UnitOfMeasure' } } ]
ProductionUnit,
@UI.hidden: true // Unit of Measure
@ObjectModel.foreignKey.association: '_MRPArea'
MRPArea,
@UI.hidden: true
StorageLocation,
@UI.hidden: true
ManufacturingOrderType,
@UI.hidden: true
ManufacturingOrderCategory,
@UI.lineItem: [{position:40}]
MfgOrderItemPlndDeliveryDate,
_MRPArea,
_ProductionPlant,
_Material,
_MfgOrder,
_MRPPlant,
_StorageLocation
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIAL",
"I_MATERIALTEXT",
"I_MFGORDERITEM"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MFGORDER",
"I_MRPAREA",
"I_PLANT",
"I_STORAGELOCATION"
],
"BASE":
[
"I_MFGORDERITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA