ESH_N_PURCHASE_ORDER

Anchor view -PURCHASE_ORDER | view: ESH_L_PURORDER | TRAN | Extraction: Not supported | Component: Basic Functions
Tables used: EKKOEKPOEKKNPRTEEKKOEKPOTGSBTGSBTT001TKA02TKA01TINCTINCTT023T023TTVZBTT001WCEPCCEPCTPROJT161T161TT024T024ET000LFA1USR21PRPSPRPST052
Column Name Description
PURCHASEORDER Purchase Order Number
Column Name Description
💲 Currency Key (DOCUMENTCURRENCY):
NETAMOUNT Net Order Value in PO Currency
NETPRICEAMOUNT Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (PURCHASEORDERQUANTITYUNIT):
ORDERQUANTITY Purchase Order Quantity
Column Name Description
CREATIONDATE Creation Date of Purchasing Document
PURCHASEORDERDATE Purchase Order Date
Column Name Description
PURCHASEORDERDELETIONCODE Purchase Order Deletion Code Show values
Column Name Description Domain name
BUSINESSAREANAME Business Area Description TEXT30
COMPANYCODENAME Name of Company Code or Company TEXT25
CONTROLLINGAREANAME Controlling Area Name TEXT25
CREATEDBYUSER User of person who created a purchasing document USNAM
INCOTERMSCLASSIFICATIONNAME Description TEXT30
INCOTERMSLOCATION1 Incoterms Location 1 INCO_L
INCOTERMSLOCATION2 Incoterms Location 2 INCO_L
INCOTERMSTRANSFERLOCATION Incoterms (Part 2) INCO2
LASTCHANGEDATETIME Change Time Stamp TZNTSTMPL
MATERIALGROUPNAME Product Group Description TEXT20
NETPRICEQUANTITY Price Unit DEC5
ORGANIZATIONBPNAME1 Name 1 NAME
PAYMENTTERMS Terms of Payment Key ZTERM
PAYMENTTERMSNAME Description of terms of payment TEXT30
PLANTNAME Plant Name TEXT30
PURORDERITEMPLANT Plant Name TEXT30
PROFITCENTER Profit Center PRCTR
PROFITCENTERNAME Description of Profit Center TEXT20
PURCHASEORDERDELETIONCODENAME Short Text for Fixed Values DDTEXT
PURCHASEORDERITEM Item Number of Purchase Order EBELP
PURCHASEORDERITEMTEXT Short Text TEXT40
PURCHASEREQUISITION Purchase Requisition Number BANFN
ISDELETED Deletion Indicator in Purchasing Document ELOEK
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type TEXT20
PURCHASINGGROUPNAME Purchasing Group Name TEXT18
PURCHASINGORGANIZATIONNAME Purchasing Organization Name TEXT20
USERDESCRIPTION User Description SUIDTECHDESC
WBSDESCRIPTION WBS Element Name TEXT40
WBSELEMENTEXTERNALID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • ESH_N_PURCHASE_ORDER.BUSINESSAREA == TGSB.GSBER
  • ESH_N_PURCHASE_ORDER.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • ESH_N_PURCHASE_ORDER.COMPANYCODE == T001.BUKRS
  • ESH_N_PURCHASE_ORDER.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • ESH_N_PURCHASE_ORDER.MANDT == TKA01.MANDT
  • ESH_N_PURCHASE_ORDER.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • ESH_N_PURCHASE_ORDER.MANDT == TCURC.MANDT
  • ESH_N_PURCHASE_ORDER.DOCUMENTCURRENCY == TCURC.WAERS
  • ESH_N_PURCHASE_ORDER.PURCHASEORDERCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • ESH_N_PURCHASE_ORDER.INCOTERMSCLASSIFICATION == TINC.INCO1
  • ESH_N_PURCHASE_ORDER.MANDT == TINC.MANDT
Material number
  • Material number
  • Client
  • ESH_N_PURCHASE_ORDER.MANUFACTURERMATERIAL == MARA.MATNR
  • ESH_N_PURCHASE_ORDER.MANDT == MARA.MANDT
Material Number
  • Material Number
  • Client
  • ESH_N_PURCHASE_ORDER.MATERIAL == MARA.MATNR
  • ESH_N_PURCHASE_ORDER.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • ESH_N_PURCHASE_ORDER.MATERIALGROUP == T023.MATKL
  • ESH_N_PURCHASE_ORDER.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • ESH_N_PURCHASE_ORDER.ORDERPRICEUNIT == T006.MSEHI
  • ESH_N_PURCHASE_ORDER.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • ESH_N_PURCHASE_ORDER.PLANT == T001W.WERKS
  • ESH_N_PURCHASE_ORDER.MANDT == T001W.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • ESH_N_PURCHASE_ORDER.MANDT == TCURC.MANDT
  • ESH_N_PURCHASE_ORDER.DOCUMENTCURRENCY == TCURC.WAERS
  • ESH_N_PURCHASE_ORDER.PURCHASEORDERCURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • ESH_N_PURCHASE_ORDER.MANDT == T006.MANDT
  • ESH_N_PURCHASE_ORDER.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Document Type
  • ?
  • Client
  • Purchasing Document Type
  • ESH_N_PURCHASE_ORDER.[column in domain "BSTYP"] == T161.BSTYP
  • ESH_N_PURCHASE_ORDER.MANDT == T161.MANDT
  • ESH_N_PURCHASE_ORDER.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_N_PURCHASE_ORDER.PURCHASINGGROUP == T024.EKGRP
  • ESH_N_PURCHASE_ORDER.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ESH_N_PURCHASE_ORDER.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_N_PURCHASE_ORDER.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • ESH_N_PURCHASE_ORDER.SUPPLIER == LFA1.LIFNR
  • ESH_N_PURCHASE_ORDER.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • ESH_N_PURCHASE_ORDER.MANDT == T001W.MANDT
  • ESH_N_PURCHASE_ORDER.SUPPLYINGPLANT == T001W.WERKS