I_SlsOrdFlfmtMfgOrder

DDL: I_SLSORDFLFMTMFGORDER SQL: ISOFMFGORDQ Type: view COMPOSITE Package: VDM_SD_SOF_OLD
28 Fields 1 Data Sources

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. Part of development package VDM_SD_SOF_OLD.

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 Order
ManufacturingOrderCategory I_MfgOrder ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrder ManufacturingOrderType
_MfgOrderType I_MfgOrder _MfgOrderType
Material MfgOrderItem Material Vehicle Model
_Material MfgOrderItem _Material
ProductionPlant I_MfgOrder ProductionPlant Prod plnt
_Plant I_MfgOrder _Plant
MfgOrderPlannedTotalQty I_MfgOrder MfgOrderPlannedTotalQty
ProductionUnit I_MfgOrder ProductionUnit
SalesOrder I_MfgOrder SalesOrder SD Document
SalesOrderItem I_MfgOrder SalesOrderItem Sales Order Item
OrderQuantity SalesOrderItem OrderQuantity Quantity
OrderQuantityUnit SalesOrderItem OrderQuantityUnit Sales Unit
NetAmount SalesOrderItem NetAmount Stated Amount
TransactionCurrency SalesOrderItem TransactionCurrency Transaction Currency
ProductionSupervisor I_MfgOrder ProductionSupervisor Prodn Supervisor
_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 Delivery Date
MfgOrderActualReleaseDate I_MfgOrder MfgOrderActualReleaseDate
MfgOrderConfirmedEndDate I_MfgOrder MfgOrderConfirmedEndDate
_ProductionUnit I_MfgOrder _ProductionUnit
_TransactionCurrency _TransactionCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SlsOrdFlfmtMfgOrder.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISOFMFGORDQ

CREATE VIEW I_SlsOrdFlfmtMfgOrder AS
SELECT
  MfgOrder.ManufacturingOrder AS ManufacturingOrder,
  MfgOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrder._MfgOrderType AS _MfgOrderType,
  MfgOrderItem.Material AS Material,
  MfgOrderItem._Material AS _Material,
  MfgOrder.ProductionPlant AS ProductionPlant,
  MfgOrder._Plant AS _Plant,
  MfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  MfgOrder.ProductionUnit AS ProductionUnit,
  MfgOrder.SalesOrder AS SalesOrder,
  MfgOrder.SalesOrderItem AS SalesOrderItem,
  SalesOrderItem.OrderQuantity AS OrderQuantity,
  SalesOrderItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesOrderItem.NetAmount AS NetAmount,
  SalesOrderItem.TransactionCurrency AS TransactionCurrency,
  MfgOrder.ProductionSupervisor AS ProductionSupervisor,
  MfgOrder._ProductionSupervisor AS _ProductionSupervisor,
  MfgOrder.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  MfgOrder.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  MfgOrder.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  MfgOrder.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  MfgOrder.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  MfgOrder.MfgOrderItemActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  MfgOrder.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  MfgOrder.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  MfgOrder._ProductionUnit AS _ProductionUnit
FROM I_MfgOrder AS MfgOrder
;

Learn More