I_MfgOrderWithStatus
Manufacturing Order Header with Status
I_MfgOrderWithStatus is a Composite CDS View that provides data about "Manufacturing Order Header with Status" in SAP S/4HANA. It reads from 2 data sources (I_ManufacturingOrder, P_OrderStatusBasicAggrgn) and exposes 309 fields with key field ManufacturingOrder. It has 3 associations to related views. Part of development package VDM_PP_SFC.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_ManufacturingOrder | ord | from |
| P_OrderStatusBasicAggrgn | stat | inner |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ProductionVersion | _ProductionVersion | $projection.Material = _ProductionVersion.Material and $projection.ProductionPlant = _ProductionVersion.Plant and $projection.ProductionVersion = _ProductionVersion.ProductionVersion |
| [1..1] | E_LogisticsOrder | _Extension | $projection.ManufacturingOrder = _Extension.OrderID |
| [1..1] | I_MfgOrderSystemStatusText | _SystemStatusText | _SystemStatusText.Language = $session.system_language and _SystemStatusText.ManufacturingOrder = ord.ManufacturingOrder |
Annotations (19)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IMFGORDERWSTTS | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Analytics.dataExtraction.enabled | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ClientHandling.type | #CLIENT_DEPENDENT | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| ObjectModel.representativeKey | ManufacturingOrder | view | |
| ObjectModel.sapObjectNodeType.name | ProductionOrder | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Search.searchable | true | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| VDM.viewType | #COMPOSITE | view | |
| EndUserText.label | Manufacturing Order Header with Status | view |
Fields (309)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ManufacturingOrder | I_ManufacturingOrder | ManufacturingOrder | |
| ManufacturingOrderCategory | I_ManufacturingOrder | ManufacturingOrderCategory | ||
| ManufacturingOrderType | I_ManufacturingOrder | ManufacturingOrderType | ||
| ManufacturingOrderText | I_ManufacturingOrder | ManufacturingOrderText | ||
| ManufacturingOrderHasLongText | I_ManufacturingOrder | ManufacturingOrderHasLongText | ||
| LongTextLanguageCode | I_ManufacturingOrder | LongTextLanguageCode | ||
| ManufacturingOrderImportance | I_ManufacturingOrder | ManufacturingOrderImportance | ||
| MfgOrderHasMultipleItems | I_ManufacturingOrder | MfgOrderHasMultipleItems | ||
| MfgOrderIsPartOfCollvOrder | I_ManufacturingOrder | MfgOrderIsPartOfCollvOrder | ||
| MfgOrderHierarchyLevel | I_ManufacturingOrder | MfgOrderHierarchyLevel | ||
| MfgOrderHierarchyLevelValue | I_ManufacturingOrder | MfgOrderHierarchyLevelValue | ||
| MfgOrderHierarchyPathValue | I_ManufacturingOrder | MfgOrderHierarchyPathValue | ||
| ProdnProcgIsFlexible | I_ManufacturingOrder | ProdnProcgIsFlexible | ||
| OrderIsCreated | P_OrderStatusBasicAggrgn | OrderIsCreated | ||
| OrderIsReleased | P_OrderStatusBasicAggrgn | OrderIsReleased | ||
| OrderIsPrinted | P_OrderStatusBasicAggrgn | OrderIsPrinted | ||
| OrderIsPartiallyPrinted | ||||
| OrderIsConfirmed | P_OrderStatusBasicAggrgn | OrderIsConfirmed | ||
| OrderIsPartiallyConfirmed | P_OrderStatusBasicAggrgn | OrderIsPartiallyConfirmed | ||
| OrderIsDelivered | P_OrderStatusBasicAggrgn | OrderIsDelivered | ||
| OrderIsDeleted | P_OrderStatusBasicAggrgn | OrderIsDeleted | ||
| OrderIsProductCosted | ||||
| OrderIsPreCosted | P_OrderStatusBasicAggrgn | OrderIsPreCosted | ||
| SettlementRuleIsCreated | P_OrderStatusBasicAggrgn | SettlementRuleIsCreated | ||
| OrderIsPartiallyReleased | P_OrderStatusBasicAggrgn | OrderIsPartiallyReleased | ||
| OrderIsLocked | P_OrderStatusBasicAggrgn | OrderIsLocked | ||
| OrderIsTechnicallyCompleted | P_OrderStatusBasicAggrgn | OrderIsTechnicallyCompleted | ||
| OrderIsClosed | P_OrderStatusBasicAggrgn | OrderIsClosed | ||
| OrderIsDistributionRelevant | ||||
| OrderIsDistributedToMES | ||||
| OrderReleaseIsRejected | ||||
| OrderIsPartiallyDelivered | P_OrderStatusBasicAggrgn | OrderIsPartiallyDelivered | ||
| OrderIsMarkedForDeletion | P_OrderStatusBasicAggrgn | OrderIsMarkedForDeletion | ||
| OrderHasCostCalculationError | ||||
| SettlementRuleIsCrtedManually | P_OrderStatusBasicAggrgn | SettlementRuleIsCrtedManually | ||
| OrderIsScheduled | P_OrderStatusBasicAggrgn | OrderIsScheduled | ||
| DistributionToMESIsCompleted | ||||
| OrderIsDiscardedByMES | ||||
| OrderIsReleasedByMES | ||||
| OrderHasGeneratedOperations | P_OrderStatusBasicAggrgn | OrderHasGeneratedOperations | ||
| OrderIsToBeHandledInBatches | P_OrderStatusBasicAggrgn | OrderIsToBeHandledInBatches | ||
| MaterialAvailyIsNotChecked | P_OrderStatusBasicAggrgn | MaterialAvailyIsNotChecked | ||
| OrderIsShopFloorOrder | P_OrderStatusBasicAggrgn | OrderIsShopFloorOrder | ||
| OrderHasMaterialShortage | ||||
| CreationDate | I_ManufacturingOrder | CreationDate | ||
| CreationTime | I_ManufacturingOrder | CreationTime | ||
| CreatedByUser | I_ManufacturingOrder | CreatedByUser | ||
| LastChangeDate | I_ManufacturingOrder | LastChangeDate | ||
| LastChangeTime | I_ManufacturingOrder | LastChangeTime | ||
| LastChangedByUser | I_ManufacturingOrder | LastChangedByUser | ||
| Material | I_ManufacturingOrder | Material | ||
| Product | I_ManufacturingOrder | Product | ||
| StorageLocation | I_ManufacturingOrder | StorageLocation | ||
| Batch | I_ManufacturingOrder | Batch | ||
| GoodsRecipientName | I_ManufacturingOrder | GoodsRecipientName | ||
| UnloadingPointName | I_ManufacturingOrder | UnloadingPointName | ||
| InventoryUsabilityCode | I_ManufacturingOrder | InventoryUsabilityCode | ||
| MaterialGoodsReceiptDuration | I_ManufacturingOrder | MaterialGoodsReceiptDuration | ||
| QuantityDistributionKey | I_ManufacturingOrder | QuantityDistributionKey | ||
| StockSegment | I_ManufacturingOrder | StockSegment | ||
| MfgOrderInternalID | I_ManufacturingOrder | MfgOrderInternalID | ||
| SuperiorOrder | I_ManufacturingOrder | SuperiorOrder | ||
| ReferenceOrder | I_ManufacturingOrder | ReferenceOrder | ||
| LeadingOrder | I_ManufacturingOrder | LeadingOrder | ||
| Currency | I_ManufacturingOrder | Currency | ||
| ProductionPlant | I_ManufacturingOrder | ProductionPlant | ||
| PlanningPlant | I_ManufacturingOrder | PlanningPlant | ||
| MRPArea | I_ManufacturingOrder | MRPArea | ||
| MRPController | I_ManufacturingOrder | MRPController | ||
| ProductionSupervisor | I_ManufacturingOrder | ProductionSupervisor | ||
| ResponsiblePlannerGroup | I_ManufacturingOrder | ResponsiblePlannerGroup | ||
| ProductionSchedulingProfile | I_ManufacturingOrder | ProductionSchedulingProfile | ||
| ProductionVersion | I_ManufacturingOrder | ProductionVersion | ||
| PlannedOrder | I_ManufacturingOrder | PlannedOrder | ||
| SalesOrder | I_ManufacturingOrder | SalesOrder | ||
| SalesOrderItem | I_ManufacturingOrder | SalesOrderItem | ||
| WBSElementInternalID | I_ManufacturingOrder | WBSElementInternalID | ||
| WBSElementInternalID_2 | I_ManufacturingOrder | WBSElementInternalID_2 | ||
| Reservation | I_ManufacturingOrder | Reservation | ||
| SettlementReservation | I_ManufacturingOrder | SettlementReservation | ||
| MfgOrderConfirmation | I_ManufacturingOrder | MfgOrderConfirmation | ||
| NumberOfMfgOrderConfirmations | I_ManufacturingOrder | NumberOfMfgOrderConfirmations | ||
| CapacityRequirement | I_ManufacturingOrder | CapacityRequirement | ||
| InspectionLot | I_ManufacturingOrder | InspectionLot | ||
| ChangeNumber | I_ManufacturingOrder | ChangeNumber | ||
| MaterialRevisionLevel | I_ManufacturingOrder | MaterialRevisionLevel | ||
| MaterialRevisionLevel_2 | I_ManufacturingOrder | MaterialRevisionLevel_2 | ||
| BasicSchedulingType | I_ManufacturingOrder | BasicSchedulingType | ||
| SchedulingIsAllowingForBreaks | I_ManufacturingOrder | SchedulingIsAllowingForBreaks | ||
| ObjectInternalID | I_ManufacturingOrder | ObjectInternalID | ||
| ManufacturingObject | I_ManufacturingOrder | ObjectInternalID | ||
| ProductConfiguration | I_ManufacturingOrder | ProductConfiguration | ||
| EffectivityParameterVariant | I_ManufacturingOrder | EffectivityParameterVariant | ||
| ConditionApplication | I_ManufacturingOrder | ConditionApplication | ||
| CapacityActiveVersion | I_ManufacturingOrder | CapacityActiveVersion | ||
| CapacityRqmtHasNotToBeCreated | I_ManufacturingOrder | CapacityRqmtHasNotToBeCreated | ||
| OrderSequenceNumber | I_ManufacturingOrder | OrderSequenceNumber | ||
| MfgOrderSplitStatus | I_ManufacturingOrder | MfgOrderSplitStatus | ||
| RequestOrderType | I_ManufacturingOrder | RequestOrderType | ||
| BillOfOperationsMaterial | I_ManufacturingOrder | BillOfOperationsMaterial | ||
| BillOfOperationsType | I_ManufacturingOrder | BillOfOperationsType | ||
| BillOfOperations | I_ManufacturingOrder | BillOfOperations | ||
| BillOfOperationsGroup | I_ManufacturingOrder | BillOfOperationsGroup | ||
| BillOfOperationsVariant | I_ManufacturingOrder | BillOfOperationsVariant | ||
| BOOInternalVersionCounter | I_ManufacturingOrder | BOOInternalVersionCounter | ||
| BillOfOperationsApplication | I_ManufacturingOrder | BillOfOperationsApplication | ||
| BillOfOperationsUsage | I_ManufacturingOrder | BillOfOperationsUsage | ||
| BillOfOperationsVersion | I_ManufacturingOrder | BillOfOperationsVersion | ||
| BOOExplosionDate | I_ManufacturingOrder | BOOExplosionDate | ||
| BOOValidityStartDate | I_ManufacturingOrder | BOOValidityStartDate | ||
| BillOfMaterialCategory | I_ManufacturingOrder | BillOfMaterialCategory | ||
| BillOfMaterial | I_ManufacturingOrder | BillOfMaterial | ||
| BillOfMaterialInternalID | I_ManufacturingOrder | BillOfMaterialInternalID | ||
| BillOfMaterialVariant | I_ManufacturingOrder | BillOfMaterialVariant | ||
| BillOfMaterialVariantUsage | I_ManufacturingOrder | BillOfMaterialVariantUsage | ||
| BillOfMaterialVersion | I_ManufacturingOrder | BillOfMaterialVersion | ||
| BOMExplosionDate | I_ManufacturingOrder | BOMExplosionDate | ||
| BOMValidityStartDate | I_ManufacturingOrder | BOMValidityStartDate | ||
| BusinessArea | I_ManufacturingOrder | BusinessArea | ||
| CompanyCode | I_ManufacturingOrder | CompanyCode | ||
| ControllingArea | I_ManufacturingOrder | ControllingArea | ||
| ProfitCenter | I_ManufacturingOrder | ProfitCenter | ||
| CostCenter | I_ManufacturingOrder | CostCenter | ||
| ResponsibleCostCenter | I_ManufacturingOrder | ResponsibleCostCenter | ||
| CostElement | I_ManufacturingOrder | CostElement | ||
| CostingSheet | I_ManufacturingOrder | CostingSheet | ||
| GLAccount | I_ManufacturingOrder | GLAccount | ||
| ProductCostCollector | I_ManufacturingOrder | ProductCostCollector | ||
| ActualCostsCostingVariant | I_ManufacturingOrder | ActualCostsCostingVariant | ||
| PlannedCostsCostingVariant | I_ManufacturingOrder | PlannedCostsCostingVariant | ||
| ControllingObjectClass | I_ManufacturingOrder | ControllingObjectClass | ||
| FunctionalArea | I_ManufacturingOrder | FunctionalArea | ||
| OverheadCode | I_ManufacturingOrder | OverheadCode | ||
| ResultAnalysisInternalID | I_ManufacturingOrder | ResultAnalysisInternalID | ||
| VarianceKey | I_ManufacturingOrder | VarianceKey | ||
| OrderIsEventBasedPosting | I_ManufacturingOrder | OrderIsEventBasedPosting | ||
| EventBasedPostingMethod | I_ManufacturingOrder | EventBasedPostingMethod | ||
| EventBasedProcessingKey | I_ManufacturingOrder | EventBasedProcessingKey | ||
| OrderSettlementTriggerType | I_ManufacturingOrder | OrderSettlementTriggerType | ||
| SchedulingFloatProfile | I_ManufacturingOrder | SchedulingFloatProfile | ||
| FloatBeforeProductionInWrkDays | I_ManufacturingOrder | FloatBeforeProductionInWrkDays | ||
| FloatAfterProductionInWorkDays | I_ManufacturingOrder | FloatAfterProductionInWorkDays | ||
| ReleasePeriodInWorkDays | I_ManufacturingOrder | ReleasePeriodInWorkDays | ||
| ChangeToScheduledDatesIsMade | I_ManufacturingOrder | ChangeToScheduledDatesIsMade | ||
| MfgOrderPlannedStartDate | I_ManufacturingOrder | MfgOrderPlannedStartDate | ||
| MfgOrderPlannedStartTime | I_ManufacturingOrder | MfgOrderPlannedStartTime | ||
| MfgOrderPlannedEndDate | I_ManufacturingOrder | MfgOrderPlannedEndDate | ||
| MfgOrderPlannedEndTime | I_ManufacturingOrder | MfgOrderPlannedEndTime | ||
| MfgOrderPlannedReleaseDate | I_ManufacturingOrder | MfgOrderPlannedReleaseDate | ||
| MfgOrderScheduledStartDate | I_ManufacturingOrder | MfgOrderScheduledStartDate | ||
| MfgOrderScheduledStartTime | I_ManufacturingOrder | MfgOrderScheduledStartTime | ||
| MfgOrderScheduledEndDate | I_ManufacturingOrder | MfgOrderScheduledEndDate | ||
| MfgOrderScheduledEndTime | I_ManufacturingOrder | MfgOrderScheduledEndTime | ||
| MfgOrderScheduledReleaseDate | I_ManufacturingOrder | MfgOrderScheduledReleaseDate | ||
| MfgOrderActualStartDate | I_ManufacturingOrder | MfgOrderActualStartDate | ||
| MfgOrderActualStartTime | I_ManufacturingOrder | MfgOrderActualStartTime | ||
| MfgOrderConfirmedEndDate | I_ManufacturingOrder | MfgOrderConfirmedEndDate | ||
| MfgOrderConfirmedEndTime | I_ManufacturingOrder | MfgOrderConfirmedEndTime | ||
| MfgOrderActualEndDate | I_ManufacturingOrder | MfgOrderActualEndDate | ||
| MfgOrderActualReleaseDate | I_ManufacturingOrder | MfgOrderActualReleaseDate | ||
| MfgOrderTotalCommitmentDate | I_ManufacturingOrder | MfgOrderTotalCommitmentDate | ||
| MfgOrderActualCompletionDate | I_ManufacturingOrder | MfgOrderActualCompletionDate | ||
| MfgOrderItemActualDeliveryDate | I_ManufacturingOrder | MfgOrderItemActualDeliveryDate | ||
| ProductionUnit | I_ManufacturingOrder | ProductionUnit | ||
| MfgOrderPlannedTotalQty | I_ManufacturingOrder | MfgOrderPlannedTotalQty | ||
| MfgOrderPlannedScrapQty | I_ManufacturingOrder | MfgOrderPlannedScrapQty | ||
| MfgOrderConfirmedYieldQty | I_ManufacturingOrder | MfgOrderConfirmedYieldQty | ||
| MfgOrderConfirmedScrapQty | I_ManufacturingOrder | MfgOrderConfirmedScrapQty | ||
| MfgOrderConfirmedReworkQty | I_ManufacturingOrder | MfgOrderConfirmedReworkQty | ||
| ExpectedDeviationQuantity | I_ManufacturingOrder | ExpectedDeviationQuantity | ||
| ActualDeliveredQuantity | I_ManufacturingOrder | ActualDeliveredQuantity | ||
| MasterProductionOrder | I_ManufacturingOrder | MasterProductionOrder | ||
| _MfgOrderCategory | I_ManufacturingOrder | _MfgOrderCategory | ||
| _MfgOrderType | I_ManufacturingOrder | _MfgOrderType | ||
| _OrderTypeDetails | I_ManufacturingOrder | _OrderTypeDetails | ||
| _MfgOrderItem | I_ManufacturingOrder | _MfgOrderItem | ||
| _MfgOrderSequence | I_ManufacturingOrder | _MfgOrderSequence | ||
| _MfgOrderOperation | I_ManufacturingOrder | _MfgOrderOperation | ||
| _MfgOrderMaterialDocItem | I_ManufacturingOrder | _MfgOrderMaterialDocItem | ||
| _MfgOrderDocInfoRecord | I_ManufacturingOrder | _MfgOrderDocInfoRecord | ||
| _MfgOrderLongText | I_ManufacturingOrder | _MfgOrderLongText | ||
| _MfgOrderImportance | I_ManufacturingOrder | _MfgOrderImportance | ||
| _SuperiorOrder | I_ManufacturingOrder | _SuperiorOrder | ||
| _ReferenceOrder | I_ManufacturingOrder | _ReferenceOrder | ||
| _LeadingOrder | I_ManufacturingOrder | _LeadingOrder | ||
| _CreatedByUser | I_ManufacturingOrder | _CreatedByUser | ||
| _LastChangedByUser | I_ManufacturingOrder | _LastChangedByUser | ||
| _LongTextLanguage | I_ManufacturingOrder | _LongTextLanguage | ||
| _ProductionUnit | I_ManufacturingOrder | _ProductionUnit | ||
| _Currency | I_ManufacturingOrder | _Currency | ||
| _OrderInternalID | I_ManufacturingOrder | _OrderInternalID | ||
| _BillOfOperationsMaterial | I_ManufacturingOrder | _BillOfOperationsMaterial | ||
| _BillOfOperationsType | I_ManufacturingOrder | _BillOfOperationsType | ||
| _BillOfOperationsGroup | I_ManufacturingOrder | _BillOfOperationsGroup | ||
| _BillOfOperationsGroup2 | I_ManufacturingOrder | _BillOfOperationsGroup2 | ||
| _BillOfOperations | I_ManufacturingOrder | _BillOfOperations | ||
| _BillOfOperations2 | I_ManufacturingOrder | _BillOfOperations2 | ||
| _BillOfOperationsChangeState | I_ManufacturingOrder | _BillOfOperationsChangeState | ||
| _BillOfOperationsChangeState2 | I_ManufacturingOrder | _BillOfOperationsChangeState2 | ||
| _BillOfOperationsApplication | I_ManufacturingOrder | _BillOfOperationsApplication | ||
| _BillOfOperationsUsage | I_ManufacturingOrder | _BillOfOperationsUsage | ||
| _ConfirmationGroup | I_ManufacturingOrder | _ConfirmationGroup | ||
| _Reservation | I_ManufacturingOrder | _Reservation | ||
| _SettlementReservation | I_ManufacturingOrder | _SettlementReservation | ||
| _ProductionPlant | I_ManufacturingOrder | _ProductionPlant | ||
| _PlanningPlant | I_ManufacturingOrder | _PlanningPlant | ||
| _Material | I_ManufacturingOrder | _Material | ||
| _Product | I_ManufacturingOrder | _Product | ||
| _ProductPlant | I_ManufacturingOrder | _ProductPlant | ||
| _ProductPlant2 | I_ManufacturingOrder | _ProductPlant2 | ||
| _ProductStorageLocation | I_ManufacturingOrder | _ProductStorageLocation | ||
| _ProductStorageLocation2 | I_ManufacturingOrder | _ProductStorageLocation2 | ||
| _StorageLocation | I_ManufacturingOrder | _StorageLocation | ||
| _Batch | I_ManufacturingOrder | _Batch | ||
| _Batch_2 | I_ManufacturingOrder | _Batch_2 | ||
| _InventoryUsabilityCode | I_ManufacturingOrder | _InventoryUsabilityCode | ||
| _MRPArea | I_ManufacturingOrder | _MRPArea | ||
| _MRPController | I_ManufacturingOrder | _MRPController | ||
| _ProductionSupervisor | I_ManufacturingOrder | _ProductionSupervisor | ||
| _ProductionSchedulingProfile | I_ManufacturingOrder | _ProductionSchedulingProfile | ||
| _ResponsiblePlannerGroup | I_ManufacturingOrder | _ResponsiblePlannerGroup | ||
| _ProductionVersion | _ProductionVersion | |||
| _CapacityRequirement | I_ManufacturingOrder | _CapacityRequirement | ||
| _ChangeNumber | I_ManufacturingOrder | _ChangeNumber | ||
| _StatusObject | I_ManufacturingOrder | _StatusObject | ||
| _MaterialRevisionLevel | I_ManufacturingOrder | _MaterialRevisionLevel | ||
| _MaterialRevisionLevel2 | I_ManufacturingOrder | _MaterialRevisionLevel2 | ||
| _InspectionLot | I_ManufacturingOrder | _InspectionLot | ||
| _SalesOrder | I_ManufacturingOrder | _SalesOrder | ||
| _SalesOrderItem | I_ManufacturingOrder | _SalesOrderItem | ||
| _SalesDocument | I_ManufacturingOrder | _SalesDocument | ||
| _SalesDocumentItem | I_ManufacturingOrder | _SalesDocumentItem | ||
| _WBSElement | I_ManufacturingOrder | _WBSElement | ||
| _WBSElementBasicData | I_ManufacturingOrder | _WBSElementBasicData | ||
| _WBSElementBasicData2 | I_ManufacturingOrder | _WBSElementBasicData2 | ||
| _EnterpriseProjectElement | I_ManufacturingOrder | _EnterpriseProjectElement | ||
| _PlannedOrder | I_ManufacturingOrder | _PlannedOrder | ||
| _BasicSchedulingType | I_ManufacturingOrder | _BasicSchedulingType | ||
| _SchedulingFloatProfile | I_ManufacturingOrder | _SchedulingFloatProfile | ||
| _RequestOrderType | I_ManufacturingOrder | _RequestOrderType | ||
| _BusinessArea | I_ManufacturingOrder | _BusinessArea | ||
| _ProfitCenter | I_ManufacturingOrder | _ProfitCenter | ||
| _CostCenter | I_ManufacturingOrder | _CostCenter | ||
| _ResponsibleCostCenter | I_ManufacturingOrder | _ResponsibleCostCenter | ||
| _CompanyCode | I_ManufacturingOrder | _CompanyCode | ||
| _ControllingArea | I_ManufacturingOrder | _ControllingArea | ||
| _GLAccount | I_ManufacturingOrder | _GLAccount | ||
| _ProductCostCollector | I_ManufacturingOrder | _ProductCostCollector | ||
| _ControllingObjectClass | I_ManufacturingOrder | _ControllingObjectClass | ||
| _CostElement | I_ManufacturingOrder | _CostElement | ||
| _ActualCostsCostingVariant | I_ManufacturingOrder | _ActualCostsCostingVariant | ||
| _PlannedCostsCostingVariant | I_ManufacturingOrder | _PlannedCostsCostingVariant | ||
| _FunctionalArea | I_ManufacturingOrder | _FunctionalArea | ||
| _LongText | I_ManufacturingOrder | _LongText | ||
| Status_SystemStatusText | ||||
| _OrderIsCreatedCode | P_OrderStatusBasicAggrgn | _OrderIsCreatedCode | ||
| _OrderIsReleasedCode | P_OrderStatusBasicAggrgn | _OrderIsReleasedCode | ||
| _OrderHasMatlShortageCode | P_OrderStatusBasicAggrgn | _OrderHasMatlShortageCode | ||
| _OrderIsPrintedCode | P_OrderStatusBasicAggrgn | _OrderIsPrintedCode | ||
| _OrderIsPrtlyPrintedCode | P_OrderStatusBasicAggrgn | _OrderIsPrtlyPrintedCode | ||
| _OrderIsConfirmedCode | P_OrderStatusBasicAggrgn | _OrderIsConfirmedCode | ||
| _OrderIsPrtlyConfirmedCode | P_OrderStatusBasicAggrgn | _OrderIsPrtlyConfirmedCode | ||
| _OrderIsDeliveredCode | P_OrderStatusBasicAggrgn | _OrderIsDeliveredCode | ||
| _OrderIsDeletedCode | P_OrderStatusBasicAggrgn | _OrderIsDeletedCode | ||
| _OrderIsProductCostedCode | P_OrderStatusBasicAggrgn | _OrderIsProductCostedCode | ||
| _OrderIsPreCostedCode | P_OrderStatusBasicAggrgn | _OrderIsPreCostedCode | ||
| _SettlmtRuleIsCreatedCode | P_OrderStatusBasicAggrgn | _SettlmtRuleIsCreatedCode | ||
| _OrderIsPrtlyReleasedCode | P_OrderStatusBasicAggrgn | _OrderIsPrtlyReleasedCode | ||
| _OrderIsLockedCode | P_OrderStatusBasicAggrgn | _OrderIsLockedCode | ||
| _OrderIsTechlyCmpltdCode | P_OrderStatusBasicAggrgn | _OrderIsTechlyCmpltdCode | ||
| _OrderIsClosedCode | P_OrderStatusBasicAggrgn | _OrderIsClosedCode | ||
| _OrderIsDistributionRlvtCode | P_OrderStatusBasicAggrgn | _OrderIsDistributionRlvtCode | ||
| _OrderIsDistrdToMESCode | P_OrderStatusBasicAggrgn | _OrderIsDistrdToMESCode | ||
| _OrderReleaseIsRejectedCode | P_OrderStatusBasicAggrgn | _OrderReleaseIsRejectedCode | ||
| _OrderIsPrtlyDeliveredCode | P_OrderStatusBasicAggrgn | _OrderIsPrtlyDeliveredCode | ||
| _OrderIsMrkdForDeletionCode | P_OrderStatusBasicAggrgn | _OrderIsMrkdForDeletionCode | ||
| _SettlmtRuleIsCrtedMnllyCode | P_OrderStatusBasicAggrgn | _SettlmtRuleIsCrtedMnllyCode | ||
| _OrderHasCostCalcErrorCode | P_OrderStatusBasicAggrgn | _OrderHasCostCalcErrorCode | ||
| _OrderIsScheduledCode | P_OrderStatusBasicAggrgn | _OrderIsScheduledCode | ||
| _DistributionToMESCmpltdCode | P_OrderStatusBasicAggrgn | _DistributionToMESCmpltdCode | ||
| _OrderIsDiscardedByMESCode | P_OrderStatusBasicAggrgn | _OrderIsDiscardedByMESCode | ||
| _OrderIsReleasedByMESCode | P_OrderStatusBasicAggrgn | _OrderIsReleasedByMESCode | ||
| _OrderHasPostdGoodsMvtCode | P_OrderStatusBasicAggrgn | _OrderHasPostdGoodsMvtCode | ||
| _OrderHasGeneratedOpsCode | P_OrderStatusBasicAggrgn | _OrderHasGeneratedOpsCode | ||
| _OrderIsHandledInBatchesCode | P_OrderStatusBasicAggrgn | _OrderIsHandledInBatchesCode | ||
| _MatlAvailyIsNotCheckedCode | P_OrderStatusBasicAggrgn | _MatlAvailyIsNotCheckedCode | ||
| _OrderHasNoComponentsCode | P_OrderStatusBasicAggrgn | _OrderHasNoComponentsCode | ||
| _OrderIsShopFloorOrderCode | P_OrderStatusBasicAggrgn | _OrderIsShopFloorOrderCode | ||
| _OrderIsHandedOvrToProdnCode | P_OrderStatusBasicAggrgn | _OrderIsHandedOvrToProdnCode | ||
| _OrderChangeIsRestrictedCode | P_OrderStatusBasicAggrgn | _OrderChangeIsRestrictedCode | ||
| _MaterialText | I_ManufacturingOrder | _MaterialText | ||
| _ProductText | I_ManufacturingOrder | _ProductText | ||
| _ProductionPlantText | I_ManufacturingOrder | _ProductionPlantText | ||
| _PlanningPlantText | I_ManufacturingOrder | _PlanningPlantText | ||
| _ReferenceOrderText | I_ManufacturingOrder | _ReferenceOrderText | ||
| _LeadingOrderText | I_ManufacturingOrder | _LeadingOrderText | ||
| _SuperiorOrderText | I_ManufacturingOrder | _SuperiorOrderText | ||
| _InspectionLotText | I_ManufacturingOrder | _InspectionLotText | ||
| _ProductionVersionText | I_ManufacturingOrder | _ProductionVersionText | ||
| _MRPAreaText | I_ManufacturingOrder | _MRPAreaText | ||
| _WBSElementText | I_ManufacturingOrder | _WBSElementText | ||
| _StorageLocationText | I_ManufacturingOrder | _StorageLocationText | ||
| _BillOfOperationsMaterialText | I_ManufacturingOrder | _BillOfOperationsMaterialText | ||
| _StatusObjectText | I_ManufacturingOrder | _StatusObjectText | ||
| _BusinessAreaText | I_ManufacturingOrder | _BusinessAreaText | ||
| _CompanyCodeText | I_ManufacturingOrder | _CompanyCodeText | ||
| _ControllingAreaText | I_ManufacturingOrder | _ControllingAreaText | ||
| _FunctionalAreaText | I_ManufacturingOrder | _FunctionalAreaText | ||
| _ProductCostCollectorText | I_ManufacturingOrder | _ProductCostCollectorText |
@AbapCatalog.sqlViewName: 'IMFGORDERWSTTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_MRPController', '_ProductionSupervisor', '_CreatedByUser', '_LastChangedByUser',
'_LongText', '_StatusObject', '_StatusObjectText']
@Analytics.dataExtraction.enabled: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
@ObjectModel.representativeKey: 'ManufacturingOrder'
@ObjectModel.sapObjectNodeType.name: 'ProductionOrder'
@ObjectModel.semanticKey: ['ManufacturingOrder']
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Manufacturing Order Header with Status'
define view I_MfgOrderWithStatus
as select from I_ManufacturingOrder as ord
inner join P_OrderStatusBasicAggrgn as stat on stat.ObjectInternalID = ord.ObjectInternalID // Status
association [0..1] to I_ProductionVersion as _ProductionVersion on $projection.Material = _ProductionVersion.Material
and $projection.ProductionPlant = _ProductionVersion.Plant
and $projection.ProductionVersion = _ProductionVersion.ProductionVersion
association [1..1] to E_LogisticsOrder as _Extension on $projection.ManufacturingOrder = _Extension.OrderID
association [1..1] to I_MfgOrderSystemStatusText as _SystemStatusText on _SystemStatusText.Language = $session.system_language
and _SystemStatusText.ManufacturingOrder = ord.ManufacturingOrder
{
// Key
@ObjectModel.text.element: ['ManufacturingOrderText']
@Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.9}
key ord.ManufacturingOrder,
// Category and Type
@ObjectModel.foreignKey.association: '_MfgOrderCategory'
ord.ManufacturingOrderCategory,
@ObjectModel.foreignKey.association: '_MfgOrderType'
ord.ManufacturingOrderType,
// Text
@Semantics.text: true
ord.ManufacturingOrderText,
ord.ManufacturingOrderHasLongText,
@ObjectModel.foreignKey.association: '_LongTextLanguage'
ord.LongTextLanguageCode,
// Attributes
@ObjectModel.foreignKey.association: '_MfgOrderImportance'
ord.ManufacturingOrderImportance,
ord.MfgOrderHasMultipleItems,
ord.MfgOrderIsPartOfCollvOrder,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'MfgOrderHierarchyLevelValue'
ord.MfgOrderHierarchyLevel,
ord.MfgOrderHierarchyLevelValue,
ord.MfgOrderHierarchyPathValue,
ord.ProdnProcgIsFlexible,
// System Status
stat.OrderIsCreated,
stat.OrderIsReleased,
stat.OrderIsPrinted,
cast(stat.OrderIsPartiallyPrinted as orderispartiallyprinted preserving type) as OrderIsPartiallyPrinted,
stat.OrderIsConfirmed,
stat.OrderIsPartiallyConfirmed,
stat.OrderIsDelivered,
stat.OrderIsDeleted,
cast(stat.OrderIsProductCosted as orderisproductcosted preserving type) as OrderIsProductCosted,
stat.OrderIsPreCosted,
stat.SettlementRuleIsCreated,
stat.OrderIsPartiallyReleased,
stat.OrderIsLocked,
stat.OrderIsTechnicallyCompleted,
stat.OrderIsClosed,
cast(stat.OrderIsDistributionRelevant as orderisdistrrelevant preserving type) as OrderIsDistributionRelevant,
cast(stat.OrderIsDistributedToMES as orderisdistributedtomes preserving type) as OrderIsDistributedToMES,
cast(stat.OrderReleaseIsRejected as releaseisrejected preserving type) as OrderReleaseIsRejected,
stat.OrderIsPartiallyDelivered,
stat.OrderIsMarkedForDeletion,
cast(stat.OrderHasCostCalculationError as orderhascostingerror preserving type) as OrderHasCostCalculationError,
stat.SettlementRuleIsCrtedManually,
stat.OrderIsScheduled,
cast(stat.DistributionToMESIsCompleted as distrtomesiscompleted preserving type) as DistributionToMESIsCompleted,
cast(stat.OrderIsDiscardedByMES as orderisdiscardedbymes preserving type) as OrderIsDiscardedByMES,
cast(stat.OrderIsReleasedByMES as orderisreleasedbymes preserving type) as OrderIsReleasedByMES,
stat.OrderHasGeneratedOperations,
stat.OrderIsToBeHandledInBatches,
stat.MaterialAvailyIsNotChecked,
stat.OrderIsShopFloorOrder,
cast(stat.OrderHasMaterialShortage as orderhasmaterialshortage preserving type) as OrderHasMaterialShortage,
// Admin
@Semantics.systemDate.createdAt: true
ord.CreationDate,
@Semantics.systemTime.createdAt: true
ord.CreationTime,
@Semantics.user.createdBy: true
ord.CreatedByUser,
@Semantics.systemDate.lastChangedAt: true
ord.LastChangeDate,
@Semantics.systemTime.lastChangedAt: true
ord.LastChangeTime,
@Semantics.user.lastChangedBy: true
ord.LastChangedByUser,
// Header Material data
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialStdVH', element: 'Material' } } ]
@ObjectModel.foreignKey.association: '_Material'
@ObjectModel.text.association: '_MaterialText'
ord.Material,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProductStdVH', element: 'Product' } } ]
@ObjectModel.foreignKey.association: '_Product'
@ObjectModel.text.association: '_ProductText'
ord.Product,
@ObjectModel.foreignKey.association: '_StorageLocation'
ord.StorageLocation,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_BatchStdVH', element: 'Batch' } } ]
ord.Batch,
@Semantics.text: true
ord.GoodsRecipientName,
@Semantics.text: true
ord.UnloadingPointName,
@ObjectModel.foreignKey.association: '_InventoryUsabilityCode'
ord.InventoryUsabilityCode,
ord.MaterialGoodsReceiptDuration,
ord.QuantityDistributionKey,
ord.StockSegment,
// Assignments
@ObjectModel.foreignKey.association: '_OrderInternalID'
ord.MfgOrderInternalID,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderStdVH', element: 'ManufacturingOrder' } } ]
@ObjectModel.foreignKey.association: '_SuperiorOrder'
ord.SuperiorOrder,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderStdVH', element: 'ManufacturingOrder' } } ]
@ObjectModel.foreignKey.association: '_ReferenceOrder'
ord.ReferenceOrder,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderStdVH', element: 'ManufacturingOrder' } } ]
@ObjectModel.foreignKey.association: '_LeadingOrder'
ord.LeadingOrder,
@ObjectModel.foreignKey.association: '_Currency'
ord.Currency,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PlantStdVH', element: 'Plant' } } ]
@ObjectModel.foreignKey.association: '_Productionplant'
ord.ProductionPlant,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PlantStdVH', element: 'Plant' } } ]
@ObjectModel.foreignKey.association: '_PlanningPlant'
ord.PlanningPlant,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MRPAreaVH', element: 'MRPArea' } } ]
@ObjectModel.foreignKey.association: '_MRPArea'
ord.MRPArea,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MRPControllerVH', element: 'MRPController' } } ]
@ObjectModel.foreignKey.association: '_MRPController'
ord.MRPController,
@ObjectModel.foreignKey.association: '_ProductionSupervisor'
ord.ProductionSupervisor,
@ObjectModel.foreignKey.association: '_ResponsiblePlannerGroup'
ord.ResponsiblePlannerGroup,
@ObjectModel.foreignKey.association: '_ProductionSchedulingProfile'
ord.ProductionSchedulingProfile,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProductionVersionStdVH', element: 'ProductionVersion' } } ]
@ObjectModel.foreignKey.association: '_ProductionVersion'
ord.ProductionVersion,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_PlannedOrderStdVH', element: 'PlannedOrder' } } ]
@ObjectModel.foreignKey.association: '_PlannedOrder'
ord.PlannedOrder,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_SalesOrderStdVH', element: 'SalesOrder' } } ]
@ObjectModel.foreignKey.association: '_SalesOrder'
ord.SalesOrder,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_SalesOrderItemStdVH', element: 'SalesOrderItem' } } ]
@ObjectModel.foreignKey.association: '_SalesOrderItem'
ord.SalesOrderItem,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'WBSElementInternalID_2'
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_WBSElmntByIntKeyStdVH', element: 'WBSElementInternalID' } } ]
@ObjectModel.foreignKey.association: '_WBSElement'
ord.WBSElementInternalID,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_WBSElementBasicDataStdVH', element: 'WBSElementInternalID' } } ]
@ObjectModel.foreignKey.association: '_WBSElementBasicData2'
ord.WBSElementInternalID_2,
ord.Reservation,
@ObjectModel.foreignKey.association: '_SettlementReservation'
ord.SettlementReservation,
@ObjectModel.foreignKey.association: '_ConfirmationGroup'
ord.MfgOrderConfirmation,
ord.NumberOfMfgOrderConfirmations,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CapacityRequirementStdVH', element: 'CapacityRequirement' } } ]
@ObjectModel.foreignKey.association: '_CapacityRequirement'
ord.CapacityRequirement,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_InspectionLotStdVH', element: 'InspectionLot' } } ]
@ObjectModel.foreignKey.association: '_InspectionLot'
ord.InspectionLot,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ChangeMasterStdVH', element: 'ChangeNumber' } } ]
@ObjectModel.foreignKey.association: '_ChangeNumber'
ord.ChangeNumber,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'MaterialRevisionLevel_2'
ord.MaterialRevisionLevel, // with conv. exit
ord.MaterialRevisionLevel_2, // w/o conv. exit
@ObjectModel.foreignKey.association: '_BasicSchedulingType'
ord.BasicSchedulingType,
@ObjectModel.foreignKey.association: '_ForecastSchedulingType'
ord.ForecastSchedulingType,
ord.SchedulingIsAllowingForBreaks,
@ObjectModel.foreignKey.association: '_StatusObject'
ord.ObjectInternalID,
ord.ObjectInternalID as ManufacturingObject,
ord.ProductConfiguration,
ord.EffectivityParameterVariant,
ord.ConditionApplication,
ord.CapacityActiveVersion,
ord.CapacityRqmtHasNotToBeCreated,
ord.OrderSequenceNumber,
ord.MfgOrderSplitStatus,
@ObjectModel.foreignKey.association: '_RequestOrderType'
ord.RequestOrderType,
// Assignments BOO
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialStdVH', element: 'Material' } } ]
@ObjectModel.foreignKey.association: '_BillOfOperationsMaterial'
@ObjectModel.text.association: '_BillOfOperationsMaterialText'
ord.BillOfOperationsMaterial,
@ObjectModel.foreignKey.association: '_BillOfOperationsType'
ord.BillOfOperationsType,
@API.element.releaseState: #DEPRECATED // default data element change -> deprecated to avoid RTT2 error in ATC
@API.element.successor: 'BillOfOperationsGroup'
@ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
ord.BillOfOperations,
@ObjectModel.foreignKey.association: '_BillOfOperationsGroup2'
ord.BillOfOperationsGroup,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_BillOfOperationsStdVH', element: 'BillOfOperationsVariant' } } ]
@ObjectModel.foreignKey.association: '_BillOfOperations2'
ord.BillOfOperationsVariant,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_BOOChgStateStdVH', element: 'BOOInternalVersionCounter' } } ]
@ObjectModel.foreignKey.association: '_BillOfOperationsChangeState2'
ord.BOOInternalVersionCounter,
@ObjectModel.foreignKey.association: '_BillOfOperationsApplication'
ord.BillOfOperationsApplication,
@ObjectModel.foreignKey.association: '_BillOfOperationsUsage'
ord.BillOfOperationsUsage,
ord.BillOfOperationsVersion,
ord.BOOExplosionDate,
ord.BOOValidityStartDate,
// Assignments BOM
ord.BillOfMaterialCategory,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'BillOfMaterialInternalID'
ord.BillOfMaterial, // with conv. exit NUMCV
ord.BillOfMaterialInternalID, // with conv. exit ALPHA
ord.BillOfMaterialVariant,
ord.BillOfMaterialVariantUsage,
ord.BillOfMaterialVersion,
ord.BOMExplosionDate,
ord.BOMValidityStartDate,
// Assignments FI/CO
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_BusinessAreaStdVH', element: 'BusinessArea' } } ]
@ObjectModel.foreignKey.association: '_BusinessArea'
@ObjectModel.text.association: '_BusinessAreaText'
ord.BusinessArea,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CompanyCodeStdVH', element: 'CompanyCode' } } ]
@ObjectModel.foreignKey.association: '_CompanyCode'
ord.CompanyCode,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ControllingAreaStdVH', element: 'ControllingArea' } } ]
@ObjectModel.foreignKey.association: '_ControllingArea'
ord.ControllingArea,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProfitCenterStdVH', element: 'ProfitCenter' } } ]
ord.ProfitCenter,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CostCenterStdVH', element: 'CostCenter' } } ]
ord.CostCenter,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_CostCenterStdVH', element: 'CostCenter' } } ]
ord.ResponsibleCostCenter,
@ObjectModel.foreignKey.association: '_CostElement'
ord.CostElement,
ord.CostingSheet,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_GLAccountStdVH', element: 'GLAccount' } } ]
@ObjectModel.foreignKey.association: '_GLAccount'
ord.GLAccount,
@Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProductCostCtrlgOrderStdVH', element: 'OrderID' } } ]
@ObjectModel.foreignKey.association: '_ProductCostCollector'
ord.ProductCostCollector,
@ObjectModel.foreignKey.association: '_ActualCostsCostingVariant'
ord.ActualCostsCostingVariant,
@ObjectModel.foreignKey.association: '_PlannedCostsCostingVariant'
ord.PlannedCostsCostingVariant,
@ObjectModel.foreignKey.association: '_ControllingObjectClass'
ord.ControllingObjectClass,
@ObjectModel.foreignKey.association: '_FunctionalArea'
@ObjectModel.text.association: '_FunctionalAreaText'
ord.FunctionalArea,
ord.OverheadCode,
ord.ResultAnalysisInternalID,
ord.VarianceKey,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'EventBasedPostingMethod'
ord.OrderIsEventBasedPosting,
ord.EventBasedPostingMethod,
ord.EventBasedProcessingKey,
ord.OrderSettlementTriggerType,
// Floats
@ObjectModel.foreignKey.association: '_SchedulingFloatProfile'
ord.SchedulingFloatProfile,
ord.FloatBeforeProductionInWrkDays,
ord.FloatAfterProductionInWorkDays,
ord.ReleasePeriodInWorkDays,
// Dates and Times
ord.ChangeToScheduledDatesIsMade,
ord.MfgOrderPlannedStartDate,
ord.MfgOrderPlannedStartTime,
ord.MfgOrderPlannedEndDate,
ord.MfgOrderPlannedEndTime,
ord.MfgOrderPlannedReleaseDate,
ord.MfgOrderScheduledStartDate,
ord.MfgOrderScheduledStartTime,
ord.MfgOrderScheduledEndDate,
ord.MfgOrderScheduledEndTime,
ord.MfgOrderScheduledReleaseDate,
ord.MfgOrderActualStartDate,
ord.MfgOrderActualStartTime,
ord.MfgOrderConfirmedEndDate,
ord.MfgOrderConfirmedEndTime,
@API.element.releaseState: #DEPRECATED // wrong GFN, GLTRI is the delivery date = LTRMI
@API.element.successor: 'MfgOrderItemActualDeliveryDate'
ord.MfgOrderActualEndDate,
ord.MfgOrderActualReleaseDate,
ord.MfgOrderTotalCommitmentDate,
ord.MfgOrderActualCompletionDate,
ord.MfgOrderItemActualDeliveryDate,
// Quantities and UoM
@ObjectModel.foreignKey.association: '_ProductionUnit'
@Semantics.unitOfMeasure: true
ord.ProductionUnit,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@Aggregation.default: #SUM
ord.MfgOrderPlannedTotalQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@Aggregation.default: #SUM
ord.MfgOrderPlannedScrapQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@Aggregation.default: #SUM
ord.MfgOrderConfirmedYieldQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@Aggregation.default: #SUM
ord.MfgOrderConfirmedScrapQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@Aggregation.default: #SUM
ord.MfgOrderConfirmedReworkQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@Aggregation.default: #SUM
ord.ExpectedDeviationQuantity,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
@Aggregation.default: #SUM
ord.ActualDeliveredQuantity,
// Fashion Manufacturing Fields
ord.MasterProductionOrder,
// Associations
ord._MfgOrderCategory,
ord._MfgOrderType,
ord._OrderTypeDetails,
ord._MfgOrderItem,
ord._MfgOrderSequence,
ord._MfgOrderOperation,
ord._MfgOrderMaterialDocItem,
ord._MfgOrderDocInfoRecord,
ord._MfgOrderLongText,
ord._MfgOrderImportance,
ord._SuperiorOrder,
ord._ReferenceOrder,
ord._LeadingOrder,
ord._CreatedByUser,
ord._LastChangedByUser,
ord._LongTextLanguage,
ord._ProductionUnit,
ord._Currency,
@Consumption.hidden: true
ord._OrderInternalID,
ord._BillOfOperationsMaterial,
ord._BillOfOperationsType,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_BillOfOperationsGroup2'
ord._BillOfOperationsGroup,
ord._BillOfOperationsGroup2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_BillOfOperations2'
ord._BillOfOperations,
ord._BillOfOperations2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_BillOfOperationsChangeState2'
ord._BillOfOperationsChangeState,
ord._BillOfOperationsChangeState2,
ord._BillOfOperationsApplication,
ord._BillOfOperationsUsage,
ord._ConfirmationGroup,
ord._Reservation,
ord._SettlementReservation,
ord._ProductionPlant,
ord._PlanningPlant,
ord._Material,
ord._Product,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ProductPlant2'
ord._ProductPlant,
ord._ProductPlant2,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ProductStorageLocation2'
ord._ProductStorageLocation,
ord._ProductStorageLocation2,
ord._StorageLocation,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_Batch_2' // 0..1 cardinality
ord._Batch,
ord._Batch_2,
ord._InventoryUsabilityCode,
ord._MRPArea,
ord._MRPController,
ord._ProductionSupervisor,
ord._ProductionSchedulingProfile,
ord._ResponsiblePlannerGroup,
_ProductionVersion,
ord._CapacityRequirement,
ord._ChangeNumber,
ord._StatusObject,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_MaterialRevisionLevel2'
ord._MaterialRevisionLevel,
ord._MaterialRevisionLevel2,
ord._InspectionLot,
ord._SalesOrder,
ord._SalesOrderItem,
ord._SalesDocument,
ord._SalesDocumentItem,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_WBSElementBasicData2'
ord._WBSElement,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_WBSElementBasicData2'
ord._WBSElementBasicData,
ord._WBSElementBasicData2,
ord._EnterpriseProjectElement,
ord._PlannedOrder,
ord._BasicSchedulingType,
ord._ForecastSchedulingType,
ord._SchedulingFloatProfile,
ord._RequestOrderType,
ord._BusinessArea,
ord._ProfitCenter,
ord._CostCenter,
ord._ResponsibleCostCenter,
ord._CompanyCode,
ord._ControllingArea,
ord._GLAccount,
ord._ProductCostCollector,
ord._ControllingObjectClass,
ord._CostElement,
ord._ActualCostsCostingVariant,
ord._PlannedCostsCostingVariant,
ord._FunctionalArea,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_MfgOrderLongText'
ord._LongText,
-- Status
_SystemStatusText,
stat._OrderIsCreatedCode,
stat._OrderIsReleasedCode,
stat._OrderHasMatlShortageCode,
stat._OrderIsPrintedCode,
stat._OrderIsPrtlyPrintedCode,
stat._OrderIsConfirmedCode,
stat._OrderIsPrtlyConfirmedCode,
stat._OrderIsDeliveredCode,
stat._OrderIsDeletedCode,
stat._OrderIsProductCostedCode,
stat._OrderIsPreCostedCode,
stat._SettlmtRuleIsCreatedCode,
stat._OrderIsPrtlyReleasedCode,
stat._OrderIsLockedCode,
stat._OrderIsTechlyCmpltdCode,
stat._OrderIsClosedCode,
stat._OrderIsDistributionRlvtCode,
stat._OrderIsDistrdToMESCode,
stat._OrderReleaseIsRejectedCode,
stat._OrderIsPrtlyDeliveredCode,
stat._OrderIsMrkdForDeletionCode,
stat._SettlmtRuleIsCrtedMnllyCode,
stat._OrderHasCostCalcErrorCode,
stat._OrderIsScheduledCode,
stat._DistributionToMESCmpltdCode,
stat._OrderIsDiscardedByMESCode,
stat._OrderIsReleasedByMESCode,
stat._OrderHasPostdGoodsMvtCode,
stat._OrderHasGeneratedOpsCode,
stat._OrderIsHandledInBatchesCode,
stat._MatlAvailyIsNotCheckedCode,
stat._OrderHasNoComponentsCode,
stat._OrderIsShopFloorOrderCode,
stat._OrderIsHandedOvrToProdnCode,
stat._OrderChangeIsRestrictedCode,
// Text relations
ord._MaterialText,
ord._ProductText,
ord._ProductionPlantText,
ord._PlanningPlantText,
ord._ReferenceOrderText,
ord._LeadingOrderText,
ord._SuperiorOrderText,
ord._InspectionLotText,
ord._ProductionVersionText,
ord._MRPAreaText,
ord._WBSElementText,
ord._StorageLocationText,
ord._BillOfOperationsMaterialText,
ord._StatusObjectText,
ord._BusinessAreaText,
ord._CompanyCodeText,
ord._ControllingAreaText,
ord._FunctionalAreaText,
ord._ProductCostCollectorText
};
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