I_ProductionOrderQuickView
Quick view data for Production Order
I_ProductionOrderQuickView is a Composite CDS View that provides data about "Quick view data for Production Order" in SAP S/4HANA. It reads from 1 data source (P_ProductionOrderQuickView) and exposes 63 fields with key fields OrderID, ManufacturingOrderItem. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_ProductionOrderQuickView | ProductionOrderItem | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_WorkCenterTextBySemanticKey | _ProductionLineText | $projection.MRPPlant = _ProductionLineText.Plant and _ProductionLineText.Language = $session.system_language and $projection.ProductionLine = _ProductionLineText.WorkCenter |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IPRODNORDQV | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Quick view data for Production Order | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.viewType | #COMPOSITE | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view |
Fields (63)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | OrderID | OrderID | ||
| KEY | ManufacturingOrderItem | ManufacturingOrderItem | ||
| Material | P_ProductionOrderQuickView | Material | ||
| MRPPlant | MRPPlant | |||
| ManufacturingOrderCategory | ManufacturingOrderCategory | |||
| ManufacturingOrderType | ManufacturingOrderType | |||
| ManufacturingOrderTypeName | ||||
| MfgOrderReleasedCode | MfgOrderReleasedCode | |||
| MfgOrderPlannedStartDate | MfgOrderPlannedStartDate | |||
| MfgOrderScheduledReleaseDate | MfgOrderScheduledReleaseDate | |||
| MfgOrderScheduledStartDate | MfgOrderScheduledStartDate | |||
| MfgOrderScheduledEndDate | MfgOrderScheduledEndDate | |||
| MfgOrderPlannedEndDate | MfgOrderPlannedEndDate | |||
| MaterialGoodsReceiptDuration | MaterialGoodsReceiptDuration | |||
| MfgOrderPlannedTotalQty | MfgOrderPlannedTotalQty | |||
| ExpectedDeviationQuantity | _MfgOrder | ExpectedDeviationQuantity | ||
| MfgOrderPlannedScrapQty | MfgOrderPlannedScrapQty | |||
| MfgOrderItemGoodsReceiptQty | MfgOrderItemGoodsReceiptQty | |||
| MRPElementOpenQuantity | MRPElementOpenQuantity | |||
| BaseUnit | P_ProductionOrderQuickView | BaseUnit | ||
| ProductionPlant | ProductionPlant | |||
| ProductionPlantName | ProductionPlantName | |||
| ProductionVersion | ProductionVersion | |||
| ProductionVersionText | _ProductionVersion | ProductionVersionText | ||
| ProductionLine | ProductionLine | |||
| ProductionLineText | _ProductionLineText | WorkCenterText | ||
| ManufacturingOrderImportance | _MfgOrder | ManufacturingOrderImportance | ||
| ProductionSupervisor | ProductionSupervisor | |||
| ProductionSupervisorName | _ProductionSupervisor | ProductionSupervisorName | ||
| MRPController | MRPController | |||
| MRPControllerName | MRPControllerName | |||
| InternalContactPersonName | InternalContactPersonName | |||
| InternalContactPhoneNumber | InternalContactPhoneNumber | |||
| InternalContactEmailAddress | InternalContactEmailAddress | |||
| Reservation | Reservation | |||
| RequirementDate | RequirementDate | |||
| OrderedQuantity | OrderedQuantity | |||
| WithdrawnQuantity | WithdrawnQuantity | |||
| OpenQuantity | OpenQuantity | |||
| MaterialPlannedProductionDurn | MaterialPlannedProductionDurn | |||
| TotalReplenishmentLeadDuration | TotalReplenishmentLeadDuration | |||
| FixedLotSizeQuantity | FixedLotSizeQuantity | |||
| MinimumLotSizeQuantity | MinimumLotSizeQuantity | |||
| MaximumLotSizeQuantity | MaximumLotSizeQuantity | |||
| LotSizeRoundingQuantity | LotSizeRoundingQuantity | |||
| RoundingProfile | RoundingProfile | |||
| MaterialRoundingProfileName | MaterialRoundingProfileName | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| WBSElementInternalID | WBSElementInternalID | |||
| WBSElement | WBSElement | |||
| _MfgOrder | _MfgOrder | |||
| _MfgOrderCategory | _MfgOrderCategory | |||
| _MfgOrderType | _MfgOrderType | |||
| _ProductionPlant | _ProductionPlant | |||
| _ProductionSupervisor | _ProductionSupervisor | |||
| _MRPController | _MRPController | |||
| _MRPPlant | _MRPPlant | |||
| _Material | P_ProductionOrderQuickView | _Material | ||
| _ProductionVersion | _ProductionVersion | |||
| _WBSElement | _WBSElement | |||
| _Order | _Order | |||
| _ProductionLineText | _ProductionLineText |
@AbapCatalog.sqlViewName: 'IPRODNORDQV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Quick view data for Production Order'
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XXL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view I_ProductionOrderQuickView
as select from P_ProductionOrderQuickView as ProductionOrderItem
association [0..1] to I_WorkCenterTextBySemanticKey as _ProductionLineText on $projection.MRPPlant = _ProductionLineText.Plant
and _ProductionLineText.Language = $session.system_language
and $projection.ProductionLine = _ProductionLineText.WorkCenter
{
key OrderID,
key ManufacturingOrderItem,
ProductionOrderItem.Material,
MRPPlant,
ManufacturingOrderCategory,
// // Distinguishing between different quick view categories
// case $parameters.P_MRPElementCategory
// when 'FE' then '031'
// when 'BR' then '033'
// when 'AR' then case ManufacturingOrderCategory
// when '10' then '032'
// when '40' then '034'
// else '000'
// end
// else '000'
// end as QuickViewCategory,
ManufacturingOrderType,
_MfgOrderType._Text[1: Language = $session.system_language].ManufacturingOrderTypeName,
MfgOrderReleasedCode,
MfgOrderPlannedStartDate,
MfgOrderScheduledReleaseDate,
MfgOrderScheduledStartDate,
MfgOrderScheduledEndDate,
MfgOrderPlannedEndDate,
MaterialGoodsReceiptDuration,
MfgOrderPlannedTotalQty,
_MfgOrder.ExpectedDeviationQuantity,
MfgOrderPlannedScrapQty,
MfgOrderItemGoodsReceiptQty,
MRPElementOpenQuantity,
ProductionOrderItem.BaseUnit,
ProductionPlant,
ProductionPlantName,
ProductionVersion,
_ProductionVersion.ProductionVersionText,
ProductionLine,
_ProductionLineText.WorkCenterText as ProductionLineText,
_MfgOrder.ManufacturingOrderImportance,
// Internal Contact Data
ProductionSupervisor,
_ProductionSupervisor.ProductionSupervisorName,
MRPController,
MRPControllerName,
InternalContactPersonName,
InternalContactPhoneNumber,
InternalContactEmailAddress,
// Requirement Data
Reservation,
RequirementDate,
OrderedQuantity,
WithdrawnQuantity,
OpenQuantity,
// Procurement Data
MaterialPlannedProductionDurn,
TotalReplenishmentLeadDuration,
FixedLotSizeQuantity,
MinimumLotSizeQuantity,
MaximumLotSizeQuantity,
LotSizeRoundingQuantity,
RoundingProfile,
MaterialRoundingProfileName,
// Related Objects
SalesOrder,
SalesOrderItem,
WBSElementInternalID,
WBSElement,
// Associations
_MfgOrder,
_MfgOrderCategory,
_MfgOrderType,
_ProductionPlant,
_ProductionSupervisor,
_MRPController,
_MRPPlant,
ProductionOrderItem._Material,
_ProductionVersion,
_WBSElement,
_Order,
_ProductionLineText
}
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