/SAPAPO/I_MM_ORDER_PREQ

eSPP Purchase requisition | view: /SAPAPO/V_MMPREQ | TRAN | Extraction: Not supported | Component: Service Parts Planning
Tables used: /SAPAPO/MM_ORD_H, /SAPAPO/MM_ORD_I, EBAN
Column Name Description
order_id TDL: Order GUID
item_id TDL: Item GUID
Column Name Description
Column Name Description
Column Name Description
delivery_date Item delivery date
delivery_time Delivery Date Time-Spot
Column Name Description
Column Name Description Domain name
delivery_tmst eSPP - Delivery Timestamp /SAPAPO/MM_TZNTSTMPS
shipping_tmst eSPP - Shipping Timestamp /SAPAPO/MM_TZNTSTMPS
available_tmst eSPP - Available Timestamp /SAPAPO/MM_TZNTSTMPS
sos_id_int TDL: Shipment ID (TRPID) /SCMB/TDL_TRPID
sos_id_ext TDL: Source of Supply ID /SCMB/TDL_ID
Master Data Relations Join Conditions
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • /SAPAPO/I_MM_ORDER_PREQ.MANDT == T163.MANDT
  • /SAPAPO/I_MM_ORDER_PREQ.ITEM_TYPE == T163.PSTYP
Material Number
  • Client
  • Material Number
  • /SAPAPO/I_MM_ORDER_PREQ.MANDT == MARA.MANDT
  • /SAPAPO/I_MM_ORDER_PREQ.MATERIAL_NO == MARA.MATNR
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • /SAPAPO/I_MM_ORDER_PREQ.MANDT == T001W.MANDT
  • /SAPAPO/I_MM_ORDER_PREQ.PLANT_FROM == T001W.WERKS
Plant
  • Plant
  • Client
  • /SAPAPO/I_MM_ORDER_PREQ.PLANT_TO == T001W.WERKS
  • /SAPAPO/I_MM_ORDER_PREQ.MANDT == T001W.MANDT
Purchase requisition unit of measure
  • Purchase requisition unit of measure
  • Client
  • /SAPAPO/I_MM_ORDER_PREQ.PREQ_UOM == T006.MSEHI
  • /SAPAPO/I_MM_ORDER_PREQ.MANDT == T006.MANDT
Fixed Vendor
  • Fixed Vendor
  • Client
  • /SAPAPO/I_MM_ORDER_PREQ.VENDOR == LFA1.LIFNR
  • /SAPAPO/I_MM_ORDER_PREQ.MANDT == LFA1.MANDT