ESH_S_PRODUCTIONROUTINGS

Search view -PRODUCTIONROUTINGS | view: ESH_U_PRODNRTG | Extraction: Not supported | Component: Routing
Tables used: DRAT, MARA, STPO, T412T, TCA02, CRVD_A, DRAW, EQUI, CRVE_A, EQKT, EQUZ, CRVM_A, CRVS_A, T001W, CRFH, MARA, CRTX, MAKT, PLMZ, PLKO, MAPL, PLPO, PLAS, CRFH, PLFH, PLFL, T006, T006A, USR21, CRHD, DOST, DRAW, DRAW_LAST_CHANGE, T024A
Column Name Description
BILLOFOPERATIONSGROUP Key for Task List Group
BILLOFOPERATIONSTYPE FK Task List Type
BILLOFOPERATIONSVARIANT Group Counter
BOOINTERNALVERSIONCOUNTER Internal counter
Column Name Description
Column Name Description
📏 Task List Unit of Measure (BILLOFOPERATIONSUNIT):
MAXIMUMLOTSIZEQUANTITY Maximum Lot Size
MINIMUMLOTSIZEQUANTITY Minimum Lot Size
Column Name Description
VALIDITYENDDATE Valid-To Date
VALIDITYSTARTDATE Valid-From Date
Column Name Description
Column Name Description Domain name
BILLOFMATERIALCOMPONENT BOM component
BILLOFOPERATIONSDESC Routing Description TEXT40
BILLOFOPERATIONSSTATUSDESC Description of the Status
BILLOFOPERATIONSTYPENAME Description of the Task List Type
DOCUMENTDESCRIPTION Document Description
EQUIPMENTNAME Description of technical object
ISMARKEDFORDELETION Indicator: Delete completely in reorganization run
MISCPRODUCTIONRESOURCETOOL Miscellaneous Production Resources and Tools
OPERATIONTEXT Operation Short Text
PLANT Plant WERKS
PLANTNAME Plant Name
COMPONENTDESCRIPTION Product Description
PRODUCTNAME Product Description TEXT40
MATERIALDESC Product Description
RESPONSIBLEPLANNERGROUP Responsible Planner Group or Department VAGRP
RESPONSIBLEPLANNERGROUPNAME Responsible Planner Group Description
SALESORDER Sales Document VBELN
UNITOFMEASURE_E External Unit of Measurement in Commercial Format (3-Char.)
LASTCHANGEDBYUSERDESCRIPTION User Description
CREATEDBYUSERDESCRIPTION User Description
PLANNINGWORKCENTER Work Center
WORKCENTER Work Center ARBPL
WORKCENTERTEXT Work Center Text
Master Data Relations Join Conditions
Status
  • Status
  • Client
  • ESH_S_PRODUCTIONROUTINGS.BILLOFOPERATIONSSTATUS == T412.PLNST
  • ESH_S_PRODUCTIONROUTINGS.MANDT == T412.MANDT
Task List Type
  • Task List Type
  • Client
  • ESH_S_PRODUCTIONROUTINGS.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • ESH_S_PRODUCTIONROUTINGS.MANDT == TCA01.MANDT
Task List Unit of Measure
  • Client
  • Task List Unit of Measure
  • ESH_S_PRODUCTIONROUTINGS.MANDT == T006.MANDT
  • ESH_S_PRODUCTIONROUTINGS.BILLOFOPERATIONSUNIT == T006.MSEHI
Task List Usage
  • Task List Usage
  • Client
  • ESH_S_PRODUCTIONROUTINGS.BILLOFOPERATIONSUSAGE == T411.VERWE
  • ESH_S_PRODUCTIONROUTINGS.MANDT == T411.MANDT
Change Number
  • Change Number
  • Client
  • ESH_S_PRODUCTIONROUTINGS.CHANGENUMBER == AENR.AENNR
  • ESH_S_PRODUCTIONROUTINGS.MANDT == AENR.MANDT
Address key assignment to users
  • User ID
  • User ID
  • Client
  • ESH_S_PRODUCTIONROUTINGS.CREATEDBYUSER == USR02.BNAME
  • ESH_S_PRODUCTIONROUTINGS.LASTCHANGEDBYUSER == USR02.BNAME
  • ESH_S_PRODUCTIONROUTINGS.MANDT == USR02.MANDT
Document number
  • ?
  • ?
  • ?
  • Document number
  • Client
  • ESH_S_PRODUCTIONROUTINGS.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_S_PRODUCTIONROUTINGS.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_S_PRODUCTIONROUTINGS.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_S_PRODUCTIONROUTINGS.DOCUMENTINFORECORD == DRAW.DOKNR
  • ESH_S_PRODUCTIONROUTINGS.MANDT == DRAW.MANDT
Equipment Number
  • Equipment Number
  • Client
  • ESH_S_PRODUCTIONROUTINGS.EQUIPMENT == EQUI.EQUNR
  • ESH_S_PRODUCTIONROUTINGS.MANDT == EQUI.MANDT
Address key assignment to users
  • User ID
  • User ID
  • Client
  • ESH_S_PRODUCTIONROUTINGS.CREATEDBYUSER == USR02.BNAME
  • ESH_S_PRODUCTIONROUTINGS.LASTCHANGEDBYUSER == USR02.BNAME
  • ESH_S_PRODUCTIONROUTINGS.MANDT == USR02.MANDT
Material Number
  • Material Number
  • Material Number
  • Client
  • ESH_S_PRODUCTIONROUTINGS.PRODUCT == MARA.MATNR
  • ESH_S_PRODUCTIONROUTINGS.MATERIAL == MARA.MATNR
  • ESH_S_PRODUCTIONROUTINGS.MANDT == MARA.MANDT
Material Number
  • Material Number
  • Material Number
  • Client
  • ESH_S_PRODUCTIONROUTINGS.PRODUCT == MARA.MATNR
  • ESH_S_PRODUCTIONROUTINGS.MATERIAL == MARA.MATNR
  • ESH_S_PRODUCTIONROUTINGS.MANDT == MARA.MANDT
WBS Element
  • WBS Element
  • Client
  • ESH_S_PRODUCTIONROUTINGS.WBSELEMENTINTERNALID == PRPSS.PSPNR
  • ESH_S_PRODUCTIONROUTINGS.MANDT == PRPSS.MANDT
Object ID of the resource
  • Object ID of the resource
  • ?
  • Client
  • ESH_S_PRODUCTIONROUTINGS.WORKCENTERINTERNALID == CRID.OBJID
  • ESH_S_PRODUCTIONROUTINGS.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • ESH_S_PRODUCTIONROUTINGS.MANDT == CRID.MANDT