ESH_N_PLANNEDORDER

Anchor view -PLANNEDORDER | view: ESH_L_PLANEDORDR | TRAN | Extraction: Not supported | Component: Production Orders
Tables used: RKPFRESBVBKDVEDAVBAKKBEDMARAT005TKNA1MDLVPLAFT001WTMABCTCRTXT024FMAKTT024T001LLFA1T006T006ACRHDT024DMARCMARD
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 DDTEXT
MRPAREATEXT MRP Area Text BERTX
MRPCONTROLLERNAME MRP Controller Name TEXT18
ORGANIZATIONBPNAME1 Name 1 NAME
SUPPLIERNAME Name 1 NAME
PLANNEDORDERTYPENAME Short Text for Fixed Values DDTEXT
PLANTNAME Plant Name TEXT30
PRODUCTIONPLANTNAME Plant Name TEXT30
PRODUCTIONSUPERVISORNAME Production Supervisor Name TEXT30
PRODUCTNAME Product Description TEXT40
MATERIALCOMPONENTNAME Product Description TEXT40
PURCHASINGGROUPNAME Purchasing Group Name TEXT18
QUOTAARRANGEMENT Quota Arrangement QUNUM
SALESORDER Sales Order VBELN
UNITOFMEASURE_E External Unit of Measurement in Commercial Format (3-Char.) MSEH3
WORKCENTER Work Center ARBPL
WORKCENTERTEXT Work Center Text TEXT40
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ESH_N_PLANNEDORDER.MANDT == T006.MANDT
  • ESH_N_PLANNEDORDER.BASEUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • Product Number
  • ESH_N_PLANNEDORDER.MANDT == MARA.MANDT
  • ESH_N_PLANNEDORDER.MATERIALCOMPONENT == MARA.MATNR
  • ESH_N_PLANNEDORDER.PRODUCT == MARA.MATNR
MRP Area
  • Client
  • MRP Area
  • ESH_N_PLANNEDORDER.MANDT == MDLV.MANDT
  • ESH_N_PLANNEDORDER.MRPAREA == MDLV.BERID
MRP Controller
  • Planning Plant
  • MRP Controller
  • Client
  • ESH_N_PLANNEDORDER.MRPPLANT == T024D.WERKS
  • ESH_N_PLANNEDORDER.MRPCONTROLLER == T024D.DISPO
  • ESH_N_PLANNEDORDER.MANDT == T024D.MANDT
Plant
  • Planning Plant
  • Client
  • ESH_N_PLANNEDORDER.MRPPLANT == T001W.WERKS
  • ESH_N_PLANNEDORDER.MANDT == T001W.MANDT
Material
  • Client
  • Material Number
  • Product Number
  • ESH_N_PLANNEDORDER.MANDT == MARA.MANDT
  • ESH_N_PLANNEDORDER.MATERIALCOMPONENT == MARA.MATNR
  • ESH_N_PLANNEDORDER.PRODUCT == MARA.MATNR
Plant
  • Client
  • Production Plant
  • ESH_N_PLANNEDORDER.MANDT == T001W.MANDT
  • ESH_N_PLANNEDORDER.PRODUCTIONPLANT == T001W.WERKS
Planner Group (Routing)
  • Production Supervisor
  • Client
  • Production Plant
  • ESH_N_PLANNEDORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • ESH_N_PLANNEDORDER.MANDT == T024F.MANDT
  • ESH_N_PLANNEDORDER.PRODUCTIONPLANT == T024F.WERKS
Production Version
  • Production Version
  • Client
  • Material Number
  • Product Number
  • Production Plant
  • ESH_N_PLANNEDORDER.PRODUCTIONVERSION == MKAL.VERID
  • ESH_N_PLANNEDORDER.MANDT == MKAL.MANDT
  • ESH_N_PLANNEDORDER.MATERIALCOMPONENT == MKAL.MATNR
  • ESH_N_PLANNEDORDER.PRODUCT == MKAL.MATNR
  • ESH_N_PLANNEDORDER.PRODUCTIONPLANT == MKAL.WERKS
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_N_PLANNEDORDER.PURCHASINGGROUP == T024.EKGRP
  • ESH_N_PLANNEDORDER.MANDT == T024.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • ESH_N_PLANNEDORDER.MANDT == KNA1.MANDT
  • ESH_N_PLANNEDORDER.SOLDTOPARTY == KNA1.KUNNR