I_SlsOrdFlfmtMfgOrder

DDL: I_SLSORDFLFMTMFGORDER SQL: ISOFMFGORDQ Type: view COMPOSITE

SOFM Manufacturing Order

I_SlsOrdFlfmtMfgOrder is a Composite CDS View that provides data about "SOFM Manufacturing Order" in SAP S/4HANA. It reads from 1 data source (I_MfgOrder) and exposes 28 fields with key field ManufacturingOrder.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrder MfgOrder from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label SOFM Manufacturing Order view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ISOFMFGORDQ view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder I_MfgOrder ManufacturingOrder
ManufacturingOrderCategory I_MfgOrder ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrder ManufacturingOrderType
_MfgOrderType I_MfgOrder _MfgOrderType
Material MfgOrderItem Material
_Material MfgOrderItem _Material
ProductionPlant I_MfgOrder ProductionPlant
_Plant I_MfgOrder _Plant
MfgOrderPlannedTotalQty I_MfgOrder MfgOrderPlannedTotalQty
ProductionUnit I_MfgOrder ProductionUnit
SalesOrder I_MfgOrder SalesOrder
SalesOrderItem I_MfgOrder SalesOrderItem
OrderQuantity SalesOrderItem OrderQuantity
OrderQuantityUnit SalesOrderItem OrderQuantityUnit
NetAmount SalesOrderItem NetAmount
TransactionCurrency SalesOrderItem TransactionCurrency
ProductionSupervisor I_MfgOrder ProductionSupervisor
_ProductionSupervisor I_MfgOrder _ProductionSupervisor
MfgOrderScheduledStartDate I_MfgOrder MfgOrderScheduledStartDate
MfgOrderScheduledEndDate I_MfgOrder MfgOrderScheduledEndDate
MfgOrderScheduledReleaseDate I_MfgOrder MfgOrderScheduledReleaseDate
MfgOrderActualStartDate I_MfgOrder MfgOrderActualStartDate
MfgOrderActualEndDate I_MfgOrder MfgOrderActualEndDate
MfgOrderItemActualDeliveryDate I_MfgOrder MfgOrderItemActualDeliveryDate
MfgOrderActualReleaseDate I_MfgOrder MfgOrderActualReleaseDate
MfgOrderConfirmedEndDate I_MfgOrder MfgOrderConfirmedEndDate
_ProductionUnit I_MfgOrder _ProductionUnit
_TransactionCurrency _TransactionCurrency 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S

@EndUserText.label: 'SOFM Manufacturing Order'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_ProductionSupervisor'] 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ISOFMFGORDQ'

define view I_SlsOrdFlfmtMfgOrder
as
select from I_MfgOrder as MfgOrder
left outer to one join
I_MfgOrderItem as MfgOrderItem
on 
      MfgOrder.ManufacturingOrder = MfgOrderItem.ManufacturingOrder
  and MfgOrderItem.ManufacturingOrderItem = '0001'

left outer to one join
I_SalesDocumentItem as SalesOrderItem
on 
      MfgOrder.SalesOrder = SalesOrderItem.SalesDocument
  and MfgOrder.SalesOrderItem = SalesOrderItem.SalesDocumentItem  
                                                                                                                          
{
  //Key

  key MfgOrder.ManufacturingOrder,
  
  //Category

  MfgOrder.ManufacturingOrderCategory,
  @ObjectModel.foreignKey.association: '_MfgOrderType'
  MfgOrder.ManufacturingOrderType,
  MfgOrder._MfgOrderType,
 
  //Material

  @ObjectModel.foreignKey.association: '_Material'
  MfgOrderItem.Material,
  MfgOrderItem._Material,
  @ObjectModel.foreignKey.association: '_Plant'
  MfgOrder.ProductionPlant,
  MfgOrder._Plant,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
  MfgOrder.MfgOrderPlannedTotalQty, 
  @Semantics.unitOfMeasure: true
  @ObjectModel.foreignKey.association: '_ProductionUnit' 
  MfgOrder.ProductionUnit,
 
  //Sales Order

  MfgOrder.SalesOrder,
  MfgOrder.SalesOrderItem, 
  
  // Quantity Sales Order Item   

  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
  SalesOrderItem.OrderQuantity,
  @Semantics.unitOfMeasure: true
  SalesOrderItem.OrderQuantityUnit,
  
  //Pricing Sales Order Item   

  @DefaultAggregation: #SUM
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  SalesOrderItem.NetAmount,
  @Semantics.currencyCode: true
  @ObjectModel.foreignKey.association: '_TransactionCurrency' 
  SalesOrderItem.TransactionCurrency,
 
  //Partner

  @ObjectModel.foreignKey.association: '_ProductionSupervisor' 
  MfgOrder.ProductionSupervisor,
  MfgOrder._ProductionSupervisor,
  
  // Dates

  MfgOrder.MfgOrderScheduledStartDate,
  MfgOrder.MfgOrderScheduledEndDate,
  MfgOrder.MfgOrderScheduledReleaseDate,
  MfgOrder.MfgOrderActualStartDate,
  MfgOrder.MfgOrderActualEndDate,
  MfgOrder.MfgOrderItemActualDeliveryDate, 
  MfgOrder.MfgOrderActualReleaseDate,
  MfgOrder.MfgOrderConfirmedEndDate,
   
  MfgOrder._ProductionUnit,
  _TransactionCurrency
   
};

                                                                              
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDER",
"I_MFGORDERITEM",
"I_SALESDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_MATERIAL",
"I_MFGORDERTYPE",
"I_PLANT",
"I_PRODUCTIONSUPERVISOR",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MFGORDER",
"I_MFGORDERITEM",
"I_SALESDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More