I_MRPSalesOrder

MRP Sales Order | view: IMRPSALESORDER | Extraction: Not supported | Component: Fiori UI for Production Planning and Control
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBEPADCPADRCADR6KNA1TVLSTVLSTMARAMAKT
Column Name Description
SalesOrder Sales Document
SalesOrderItem Sales Document Item
ScheduleLine Schedule Line Number
Column Name Description
Column Name Description
📏 Sales unit (SalesUnit):
OrderQuantity Order Quantity in Sales Units
ConfirmedQuantity Confirmed Quantity
ConfirmationTotalQuantity Confirmed Quantity
DeliveredQtyInOrderQtyUnit Delivered Quantity
OpenConfdDelivQtyInOrdQtyUnit Open Confirmed Delivery Quantity
OpenQuantity null
📏 Base Unit of Measure (BaseUnit):
DeliveredQuantityInBaseUnit Delivered Quantity
OpenConfdDelivQtyInBaseUnit Open Confirmed Delivery Quantity
Column Name Description
SalesOrderDate Document Date (Date Received/Sent)
RequestedDeliveryDate Requested Delivery Date
ProductAvailabilityDate Material Staging/Availability Date
LoadingDate Loading Date
Column Name Description
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
Column Name Description Domain name
MRPPlant Plant (Own or External) WERKS
MaterialName Material Description TEXT40
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
CustomerFullName Customer Full Name TEXT220
PhoneNumber First telephone no.: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
MaterialByCustomer Material Number Used by Customer IDNEX
DeliveryBlockReasonText Description TEXT20
DeliveryIsBlocked null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MRPSALESORDER.MANDT == T006.MANDT
  • I_MRPSALESORDER.BASEUNIT == T006.MSEHI
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • I_MRPSALESORDER.MANDT == TVLS.MANDT
  • I_MRPSALESORDER.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • I_MRPSALESORDER.SALESORGANIZATION == TVKOV.VKORG
  • I_MRPSALESORDER.MANDT == TVKOV.MANDT
  • I_MRPSALESORDER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • I_MRPSALESORDER.MANDT == TSPA.MANDT
  • I_MRPSALESORDER.DIVISION == TSPA.SPART
Material: order item
  • Client
  • Material Number
  • I_MRPSALESORDER.MANDT == MARA.MANDT
  • I_MRPSALESORDER.MATERIAL == MARA.MATNR
Order type in order header
  • Sales Order Type
  • Client
  • I_MRPSALESORDER.SALESORDERTYPE == TVAK.AUART
  • I_MRPSALESORDER.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_MRPSALESORDER.SALESORGANIZATION == TVKO.VKORG
  • I_MRPSALESORDER.MANDT == TVKO.MANDT
Sales unit
  • Client
  • Sales unit
  • I_MRPSALESORDER.MANDT == T006.MANDT
  • I_MRPSALESORDER.SALESUNIT == T006.MSEHI