ESH_S_PLANNEDORDER

Search view -PLANNEDORDER | view: ESH_U_PLANEDORDR | TRAN | Extraction: Not supported | Component: Production Orders
Tables used: RKPFRESBVBKDVEDAVBAKKBEDMARAT005TKNA1MDLVPLAFT001WTMABCTMARACRTXT024FMAKTT024T001LLFA1T006T006ACRHDT024DMARCMARD
Column Name Description
PLANNEDORDER Planned Order
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASEUNIT):
PLANNEDTOTALQTYINBASEUNIT Planned Total Order Quantity
Column Name Description
PLANNEDORDEROPENINGDATE Planned Opening Date in Planned Order
PLNDORDERPLANNEDENDDATE Planned Order End Date
PLNDORDERPLANNEDSTARTDATE Planned Order Start Date
Column Name Description
MATERIALPROCUREMENTTYPE Material Procurement Type Show values
PLANNEDORDERTYPE Planned Order Type Show values
Column Name Description Domain name
CUSTOMERAUTHZNGRP Authorization Group BRGRU
SUPPLIERAUTHZNGRP Authorization Group BRGRU
CAPACITYREQUIREMENT ID of the Capacity Requirements Record BEDID
MATERIALPROCUREMENTTYPENAME Short Text for Fixed Values
MRPAREATEXT MRP Area Text BERTX
MRPCONTROLLERNAME MRP Controller Name
ORGANIZATIONBPNAME1 Name 1
SUPPLIERNAME Name 1
PLANNEDORDERTYPENAME Short Text for Fixed Values
PLANTNAME Plant Name
PRODUCTIONPLANTNAME Plant Name
PRODUCTIONSUPERVISORNAME Production Supervisor Name TEXT30
PRODUCTNAME Product Description
MATERIALCOMPONENTNAME Product Description TEXT40
PURCHASINGGROUPNAME Purchasing Group Name
QUOTAARRANGEMENT Quota Arrangement QUNUM
SALESORDER Sales Order VBELN
UNITOFMEASURE_E External Unit of Measurement in Commercial Format (3-Char.)
WORKCENTER Work Center ARBPL
WORKCENTERTEXT Work Center Text
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ESH_S_PLANNEDORDER.MANDT == T006.MANDT
  • ESH_S_PLANNEDORDER.BASEUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • Product Number
  • ESH_S_PLANNEDORDER.MANDT == MARA.MANDT
  • ESH_S_PLANNEDORDER.MATERIALCOMPONENT == MARA.MATNR
  • ESH_S_PLANNEDORDER.PRODUCT == MARA.MATNR
MRP Area
  • Client
  • MRP Area
  • ESH_S_PLANNEDORDER.MANDT == MDLV.MANDT
  • ESH_S_PLANNEDORDER.MRPAREA == MDLV.BERID
MRP Controller
  • MRP Controller
  • Client
  • Planning Plant
  • ESH_S_PLANNEDORDER.MRPCONTROLLER == T024D.DISPO
  • ESH_S_PLANNEDORDER.MANDT == T024D.MANDT
  • ESH_S_PLANNEDORDER.MRPPLANT == T024D.WERKS
Plant
  • Client
  • Planning Plant
  • ESH_S_PLANNEDORDER.MANDT == T001W.MANDT
  • ESH_S_PLANNEDORDER.MRPPLANT == T001W.WERKS
Material
  • Client
  • Material Number
  • Product Number
  • ESH_S_PLANNEDORDER.MANDT == MARA.MANDT
  • ESH_S_PLANNEDORDER.MATERIALCOMPONENT == MARA.MATNR
  • ESH_S_PLANNEDORDER.PRODUCT == MARA.MATNR
Plant
  • Client
  • Production Plant
  • ESH_S_PLANNEDORDER.MANDT == T001W.MANDT
  • ESH_S_PLANNEDORDER.PRODUCTIONPLANT == T001W.WERKS
Planner Group (Routing)
  • Client
  • Production Supervisor
  • Production Plant
  • ESH_S_PLANNEDORDER.MANDT == T024F.MANDT
  • ESH_S_PLANNEDORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • ESH_S_PLANNEDORDER.PRODUCTIONPLANT == T024F.WERKS
Production Version
  • Client
  • Material Number
  • Product Number
  • Production Plant
  • Production Version
  • ESH_S_PLANNEDORDER.MANDT == MKAL.MANDT
  • ESH_S_PLANNEDORDER.MATERIALCOMPONENT == MKAL.MATNR
  • ESH_S_PLANNEDORDER.PRODUCT == MKAL.MATNR
  • ESH_S_PLANNEDORDER.PRODUCTIONPLANT == MKAL.WERKS
  • ESH_S_PLANNEDORDER.PRODUCTIONVERSION == MKAL.VERID
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_S_PLANNEDORDER.MANDT == T024.MANDT
  • ESH_S_PLANNEDORDER.PURCHASINGGROUP == T024.EKGRP
Sold-to Party
  • Client
  • Sold-to Party
  • ESH_S_PLANNEDORDER.MANDT == KNA1.MANDT
  • ESH_S_PLANNEDORDER.SOLDTOPARTY == KNA1.KUNNR