ESH_N_PRODUCTIONORDER

Anchor view -PRODUCTIONORDER | view: ESH_L_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 BERTX
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 TEXT40
ORGANIZATIONBPNAME1 Name 1 NAME
ORDERLONGTEXT Long Text
PLANTNAME Plant Name TEXT30
MPRPLANTNAME Plant Name TEXT30
PRODUCTNAME Product Description TEXT40
MATERIALCOMPONENTNAME Product Description TEXT40
SALESORDER Sales Order Number VBELN
SYSTEMSTATUSNAME Object status TEXT30
CREATEDBYUSERDESCRIPTION User Description SUIDTECHDESC
LASTCHANGEDBYUSERDESCRIPTION User Description SUIDTECHDESC
WBSDESCRIPTION WBS Element Name TEXT40
WBSELEMENT Work Breakdown Structure Element (WBS Element) PS_POSID
WORKCENTERTEXT Work Center Text TEXT40
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • ESH_N_PRODUCTIONORDER.BASEUNIT == T006.MSEHI
  • ESH_N_PRODUCTIONORDER.MANDT == T006.MANDT
Leading Order in Current Processing
  • Leading Order in Current Processing
  • Client
  • ESH_N_PRODUCTIONORDER.LEADINGORDER == AUFK.AUFNR
  • ESH_N_PRODUCTIONORDER.MANDT == AUFK.MANDT
Material Number for Order
  • Material Number for Order
  • Client
  • ESH_N_PRODUCTIONORDER.MATERIAL == MARA.MATNR
  • ESH_N_PRODUCTIONORDER.MANDT == MARA.MANDT
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • ESH_N_PRODUCTIONORDER.MANDT == T001W.MANDT
  • ESH_N_PRODUCTIONORDER.MRPPLANT == T001W.WERKS
Order Type
  • Order Type
  • Client
  • ESH_N_PRODUCTIONORDER.ORDERTYPE == T003O.AUART
  • ESH_N_PRODUCTIONORDER.MANDT == T003O.CLIENT
Production Plant
  • Production Plant
  • Client
  • ESH_N_PRODUCTIONORDER.PRODUCTIONPLANT == T001W.WERKS
  • ESH_N_PRODUCTIONORDER.MANDT == T001W.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • ESH_N_PRODUCTIONORDER.SOLDTOPARTY == KNA1.KUNNR
  • ESH_N_PRODUCTIONORDER.MANDT == KNA1.MANDT