C_MRPSalesOrder

MRP Sales Order | view: CMRPSALESORDER | Extraction: Not supported | Component: Fiori UI for Production Planning and Control
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBEPPRTEADCPADRCADR6KNA1KNMTTVLSTVLSTTPRIOTPRITMARAMAKTPROJPROJCNLDST_SHORTTXPRPSCNLDST_SHORTTX
Column Name Description
SalesOrder Sales Document
SalesOrderItem Sales Document Item
SalesOrderScheduleLine Schedule Line Number
Column Name Description
Column Name Description
📏 Sales unit (SalesUnit):
DeliveredQtyInOrderQtyUnit Delivered Quantity
OpenConfdDelivQtyInOrdQtyUnit Open Confirmed Delivery Quantity
📏 Base Unit of Measure (BaseUnit):
DeliveredQuantityInBaseUnit Delivered Quantity
OpenConfdDelivQtyInBaseUnit Open Confirmed Delivery Quantity
ConfirmationTotalQuantity Confirmed Quantity
ConfirmedQuantity Confirmed Quantity
OrderQuantity Order Quantity in Sales Units
OpenQuantity null
Column Name Description
SalesOrderDate Document Date (Date Received/Sent)
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Requested Delivery Date
Column Name Description
Column Name Description Domain name
SDDocument Sales Document VBELN
MRPPlant Plant (Own or External) WERKS
MaterialName Material Description TEXT40
DeliveryIsBlocked null
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
ContactPersonName Customer Full Name TEXT220
ContactPersonPhoneNumber First telephone no.: dialling code+number CHAR30
ContactPersonEmailAddress E-Mail Address AD_SMTPADR
DeliveryPriorityDesc Description TEXT20
DeliveryBlockReasonText Description TEXT20
MaterialByCustomer Material Number Used by Customer IDNEX
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementDescription Language-Dependent Short Text TEXT40
WBSDescription WBS Element Name TEXT40
ResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
Project Project definition PS_PSPID
ProjectDescription Project Definition Name TEXT40
TopLevelOrder null
TopLevelOrderMaterial null
TopLevelOrderMaterialName null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_MRPSALESORDER.MANDT == T006.MANDT
  • C_MRPSALESORDER.BASEUNIT == T006.MSEHI
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_MRPSALESORDER.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_MRPSALESORDER.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_MRPSALESORDER.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_MRPSALESORDER.MANDT == TPRIO.MANDT
Material: order item
  • Material Number
  • Client
  • C_MRPSALESORDER.MATERIAL == MARA.MATNR
  • C_MRPSALESORDER.MANDT == MARA.MANDT
Project manager personnel number
  • Client
  • Responsible Person Number (Project Manager)
  • C_MRPSALESORDER.MANDT == TCJ04.MANDT
  • C_MRPSALESORDER.RESPONSIBLEPERSON == TCJ04.VERNR
Sales unit
  • Sales unit
  • Client
  • C_MRPSALESORDER.SALESUNIT == T006.MSEHI
  • C_MRPSALESORDER.MANDT == T006.MANDT