ESH_N_PRODUCTIONROUTINGS

Anchor view -PRODUCTIONROUTINGS | view: ESH_L_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
ISMARKEDFORDELETION Indicator: Delete completely in reorganization run Show values
Column Name Description Domain name
BILLOFMATERIALCOMPONENT BOM component MATNR
BILLOFOPERATIONSDESC Routing Description TEXT40
BILLOFOPERATIONSSTATUSDESC Description of the Status TEXT40
BILLOFOPERATIONSTYPENAME Description of the Task List Type TEXT30
DOCUMENTDESCRIPTION Document Description TEXT40
EQUIPMENTNAME Description of technical object TEXT40
MISCPRODUCTIONRESOURCETOOL Miscellaneous Production Resources and Tools SFHNR
OPERATIONTEXT Operation Short Text TEXT40
PLANT Plant WERKS
PLANTNAME Plant Name TEXT30
COMPONENTDESCRIPTION Product Description TEXT40
PRODUCTNAME Product Description TEXT40
MATERIALDESC Product Description TEXT40
RESPONSIBLEPLANNERGROUP Responsible Planner Group or Department VAGRP
RESPONSIBLEPLANNERGROUPNAME Responsible Planner Group Description TEXT30
SALESORDER Sales Document VBELN
UNITOFMEASURE_E External Unit of Measurement in Commercial Format (3-Char.) MSEH3
LASTCHANGEDBYUSERDESCRIPTION User Description SUIDTECHDESC
CREATEDBYUSERDESCRIPTION User Description SUIDTECHDESC
PLANNINGWORKCENTER Work Center ARBPL
WORKCENTER Work Center ARBPL
WORKCENTERTEXT Work Center Text TEXT40
Master Data Relations Join Conditions
Status
  • Status
  • Client
  • ESH_N_PRODUCTIONROUTINGS.BILLOFOPERATIONSSTATUS == T412.PLNST
  • ESH_N_PRODUCTIONROUTINGS.MANDT == T412.MANDT
Task List Type
  • Client
  • Task List Type
  • ESH_N_PRODUCTIONROUTINGS.MANDT == TCA01.MANDT
  • ESH_N_PRODUCTIONROUTINGS.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Task List Unit of Measure
  • Client
  • Task List Unit of Measure
  • ESH_N_PRODUCTIONROUTINGS.MANDT == T006.MANDT
  • ESH_N_PRODUCTIONROUTINGS.BILLOFOPERATIONSUNIT == T006.MSEHI
Task List Usage
  • Client
  • Task List Usage
  • ESH_N_PRODUCTIONROUTINGS.MANDT == T411.MANDT
  • ESH_N_PRODUCTIONROUTINGS.BILLOFOPERATIONSUSAGE == T411.VERWE
Change Number
  • Change Number
  • Client
  • ESH_N_PRODUCTIONROUTINGS.CHANGENUMBER == AENR.AENNR
  • ESH_N_PRODUCTIONROUTINGS.MANDT == AENR.MANDT
Address key assignment to users
  • Client
  • User ID
  • User ID
  • ESH_N_PRODUCTIONROUTINGS.MANDT == USR02.MANDT
  • ESH_N_PRODUCTIONROUTINGS.LASTCHANGEDBYUSER == USR02.BNAME
  • ESH_N_PRODUCTIONROUTINGS.CREATEDBYUSER == USR02.BNAME
Document number
  • ?
  • Document number
  • ?
  • ?
  • Client
  • ESH_N_PRODUCTIONROUTINGS.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_N_PRODUCTIONROUTINGS.DOCUMENTINFORECORD == DRAW.DOKNR
  • ESH_N_PRODUCTIONROUTINGS.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_N_PRODUCTIONROUTINGS.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_N_PRODUCTIONROUTINGS.MANDT == DRAW.MANDT
Equipment Number
  • Client
  • Equipment Number
  • ESH_N_PRODUCTIONROUTINGS.MANDT == EQUI.MANDT
  • ESH_N_PRODUCTIONROUTINGS.EQUIPMENT == EQUI.EQUNR
Address key assignment to users
  • Client
  • User ID
  • User ID
  • ESH_N_PRODUCTIONROUTINGS.MANDT == USR02.MANDT
  • ESH_N_PRODUCTIONROUTINGS.LASTCHANGEDBYUSER == USR02.BNAME
  • ESH_N_PRODUCTIONROUTINGS.CREATEDBYUSER == USR02.BNAME
Material Number
  • Client
  • Material Number
  • Material Number
  • ESH_N_PRODUCTIONROUTINGS.MANDT == MARA.MANDT
  • ESH_N_PRODUCTIONROUTINGS.PRODUCT == MARA.MATNR
  • ESH_N_PRODUCTIONROUTINGS.MATERIAL == MARA.MATNR
Material Number
  • Client
  • Material Number
  • Material Number
  • ESH_N_PRODUCTIONROUTINGS.MANDT == MARA.MANDT
  • ESH_N_PRODUCTIONROUTINGS.PRODUCT == MARA.MATNR
  • ESH_N_PRODUCTIONROUTINGS.MATERIAL == MARA.MATNR
WBS Element
  • Client
  • WBS Element
  • ESH_N_PRODUCTIONROUTINGS.MANDT == PRPSS.MANDT
  • ESH_N_PRODUCTIONROUTINGS.WBSELEMENTINTERNALID == PRPSS.PSPNR
Object ID of the resource
  • Client
  • Object ID of the resource
  • ?
  • ESH_N_PRODUCTIONROUTINGS.MANDT == CRID.MANDT
  • ESH_N_PRODUCTIONROUTINGS.WORKCENTERINTERNALID == CRID.OBJID
  • ESH_N_PRODUCTIONROUTINGS.[column in domain "CR_OBJTY"] == CRID.OBJTY