pp_mrp_read_sales_order

Read Sales Order | view: V_MRP_SALES_ORD | Extraction: Not supported | Component: Fiori UI for Production Planning and Control
Tables used: VBAK, VBAP, VBEP, VBPA, KNA1, KNMT, PROJ, PRPS, VBBE
Column Name Description
Column Name Description
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MinDeliveryQtyInBaseUnit Minimum Delivery Quantity in Delivery Note Processing
OpenQuantityInBaseUnit Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP
ConfirmedQuantityInBaseUnit Confirmed quantity for availability check in SKU
📏 Sales unit (SalesUnit):
OrderQuantity Order Quantity in Sales Units
ConfirmedQuantity Confirmed Quantity
OpenQuantity null
Column Name Description
DocumentDate Date on which the record was created
RequestedDeliveryDate Requested Delivery Date
RequestedLoadingDate Loading Date
RequestedGoodsIssueDate Goods Issue Date
ProductAvailabilityDate Material Staging/Availability Date
Column Name Description
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
CompleteDelivery Complete Delivery Defined for Each Sales Order? Show values
Column Name Description Domain name
SalesOrder Sales Document VBELN
SalesOrderItem Sales Document Item POSNR
SalesOrderScheduleLine Schedule Line Number ETENR
MRPPlant Plant (Own or External) WERKS
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription PS: Short description (1st text line) TEXT40
WBSResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
Project Project definition PS_PSPID
ProjectDescription PS: Short description (1st text line) TEXT40
Customer null
CustomerName null
CustomerMaterial Material Number Used by Customer IDNEX
DeliveryBlockReason Delivery Block (Document Header) LIFSP
DeliveryIsBlocked null
PartialDeliveryIsAllowed null
MaxNumberOfPartialDelivery Maximum Number of Partial Deliveries Allowed Per Item ANTLF
QuickviewCategory null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Measure
  • PP_MRP_READ_SALES_ORDER.MANDT == T006.MANDT
  • PP_MRP_READ_SALES_ORDER.BASEUNIT == T006.MSEHI
  • PP_MRP_READ_SALES_ORDER.MATERIALBASEUNIT == T006.MSEHI
Delivery Priority
  • Client
  • Delivery Priority
  • PP_MRP_READ_SALES_ORDER.MANDT == TPRIO.MANDT
  • PP_MRP_READ_SALES_ORDER.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • PP_MRP_READ_SALES_ORDER.MANDT == TVKOV.MANDT
  • PP_MRP_READ_SALES_ORDER.SALESORGANIZATION == TVKOV.VKORG
  • PP_MRP_READ_SALES_ORDER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • PP_MRP_READ_SALES_ORDER.MANDT == TVTA.MANDT
  • PP_MRP_READ_SALES_ORDER.DIVISION == TVTA.SPART
  • PP_MRP_READ_SALES_ORDER.SALESORGANIZATION == TVTA.VKORG
  • PP_MRP_READ_SALES_ORDER.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • PP_MRP_READ_SALES_ORDER.MANDT == T148.MANDT
  • PP_MRP_READ_SALES_ORDER.INVENTORYSPECIALSTOCK == T148.SOBKZ
Material: order item
  • Client
  • Material Number
  • PP_MRP_READ_SALES_ORDER.MANDT == MARA.MANDT
  • PP_MRP_READ_SALES_ORDER.MATERIAL == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Measure
  • PP_MRP_READ_SALES_ORDER.MANDT == T006.MANDT
  • PP_MRP_READ_SALES_ORDER.BASEUNIT == T006.MSEHI
  • PP_MRP_READ_SALES_ORDER.MATERIALBASEUNIT == T006.MSEHI
Project
  • Client
  • Current number of the appropriate project
  • PP_MRP_READ_SALES_ORDER.MANDT == PROJ.MANDT
  • PP_MRP_READ_SALES_ORDER.PROJECTINTERNALID == PROJ.PSPNR
Order type in order header
  • Client
  • Sales Document Type
  • PP_MRP_READ_SALES_ORDER.MANDT == TVAK.MANDT
  • PP_MRP_READ_SALES_ORDER.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • PP_MRP_READ_SALES_ORDER.MANDT == TVKO.MANDT
  • PP_MRP_READ_SALES_ORDER.SALESORGANIZATION == TVKO.VKORG
Sales unit
  • Client
  • Sales unit
  • PP_MRP_READ_SALES_ORDER.MANDT == T006.MANDT
  • PP_MRP_READ_SALES_ORDER.SALESUNIT == T006.MSEHI
Project manager personnel number
  • Client
  • Number of the Responsible Person (Project Manager)
  • PP_MRP_READ_SALES_ORDER.MANDT == TCJ04.MANDT
  • PP_MRP_READ_SALES_ORDER.WBSRESPONSIBLEPERSON == TCJ04.VERNR