ESH_S_PRODUCTIONORDER

Search view -PRODUCTIONORDER | view: ESH_U_PRODNORDR | TRAN | Extraction: Not supported | Component: Production Orders
Tables used: AFKORESBAFPOAUFK_TEXTAFVC_TEXTAFFLAFFL_TEXTRKPFRESBVBKDVEDAVBAKJSTOJESTESH_SR_LTXTPRTEAFVCMARAKNA1AUFKMDLVAUFKRESB_TEXTT003OT003PT001WMARACRTXMAKTPROJTJ02TJ02TUSR21PRPSCRHD
Column Name Description
ORDERID Order Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASEUNIT):
ORDERPLANNEDTOTALQTY Total Order Quantity
Column Name Description
PLANNEDENDDATE Basic finish date
PLANNEDSTARTDATE Basic Start Date
SCHEDULEDBASICENDDATE Scheduled finish
SCHEDULEDBASICENDTIME Scheduled finish time
SCHEDULEDBASICSTARTDATE Scheduled start
SCHEDULEDBASICSTARTTIME Scheduled Start (Time)
Column Name Description
ISMARKEDFORDELETION Deletion Flag Show values
ORDERCATEGORY Order Category Show values
Column Name Description Domain name
MRPAREA MRP Area BERID
MRPAREATEXT MRP Area Text
ORDERCOMPONENTLONGTEXT Long Text
ORDERDESCRIPTION Order Description TEXT40
ORDERINTERNALBILLOFOPERATIONS Routing number of operations in the order AUFPL
ORDEROPERATIONLONGTEXT Long Text
ORDERSEQUENCELONGTEXT Long Text
ORDERTYPENAME Name of an Order Type
ORGANIZATIONBPNAME1 Name 1
ORDERLONGTEXT Long Text
PLANTNAME Plant Name
MPRPLANTNAME Plant Name
PRODUCTNAME Product Description
MATERIALCOMPONENTNAME Product Description
SALESORDER Sales Order Number VBELN
SYSTEMSTATUSNAME Object status
CREATEDBYUSERDESCRIPTION User Description
LASTCHANGEDBYUSERDESCRIPTION User Description
WBSDESCRIPTION WBS Element Name
WBSELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID
WORKCENTERTEXT Work Center Text
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ESH_S_PRODUCTIONORDER.MANDT == T006.MANDT
  • ESH_S_PRODUCTIONORDER.BASEUNIT == T006.MSEHI
Leading Order in Current Processing
  • Client
  • Leading Order in Current Processing
  • ESH_S_PRODUCTIONORDER.MANDT == AUFK.MANDT
  • ESH_S_PRODUCTIONORDER.LEADINGORDER == AUFK.AUFNR
Material Number for Order
  • Client
  • Material Number for Order
  • ESH_S_PRODUCTIONORDER.MANDT == MARA.MANDT
  • ESH_S_PRODUCTIONORDER.MATERIAL == MARA.MATNR
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • ESH_S_PRODUCTIONORDER.MANDT == T001W.MANDT
  • ESH_S_PRODUCTIONORDER.MRPPLANT == T001W.WERKS
Order Type
  • Client
  • Order Type
  • ESH_S_PRODUCTIONORDER.MANDT == T003O.CLIENT
  • ESH_S_PRODUCTIONORDER.ORDERTYPE == T003O.AUART
Production Plant
  • Client
  • Production Plant
  • ESH_S_PRODUCTIONORDER.MANDT == T001W.MANDT
  • ESH_S_PRODUCTIONORDER.PRODUCTIONPLANT == T001W.WERKS
Sold-to Party
  • Sold-to Party
  • Client
  • ESH_S_PRODUCTIONORDER.SOLDTOPARTY == KNA1.KUNNR
  • ESH_S_PRODUCTIONORDER.MANDT == KNA1.MANDT