ESH_S_PURCHASE_ORDER

Search view -PURCHASE_ORDER | view: ESH_U_PURORDER | TRAN | Extraction: Not supported | Component: Basic Functions

Tables used: EKKO, EKPO, EKKN, PRTE, TGSB, TGSBT, T001, TKA02, TKA01, TINC, TINCT, T023, T023T, TVZBT, T001W, CEPC, CEPCT, PROJ, T161, T161T, T024, T024E, T000, LFA1, USR21, PRPS, T052

🔑 Keys
💰 Amounts (2)
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (1)
Other (30)
🔗 Relations (19)

Column Name	Description

Column Name	Description
💲 Currency Key (PURCHASEORDERCURRENCY):
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
COMPANYCODENAME	Name of Company Code or Company
CONTROLLINGAREANAME	Controlling Area Name
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
NETPRICEQUANTITY	Price Unit	DEC5
ORGANIZATIONBPNAME1	Name 1
PAYMENTTERMS	Terms of Payment Key	ZTERM
PAYMENTTERMSNAME	Description of terms of payment	TEXT30
PLANTNAME	Plant Name	TEXT30
PURORDERITEMPLANT	Plant Name
PROFITCENTER	Profit Center	PRCTR
PROFITCENTERNAME	Description of Profit Center
PURCHASEORDER	Purchase Order Number	EBELN
PURCHASEORDERDELETIONCODENAME	Short Text for Fixed Values
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
PURCHASINGGROUPNAME	Purchasing Group Name
PURCHASINGORGANIZATIONNAME	Purchasing Organization Name
USERDESCRIPTION	User Description
WBSDESCRIPTION	WBS Element Name
WBSELEMENTEXTERNALID	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT

Master Data Relations	Join Conditions
Business Area Client Business Area	`ESH_S_PURCHASE_ORDER.MANDT == TGSB.MANDT` `ESH_S_PURCHASE_ORDER.BUSINESSAREA == TGSB.GSBER`
Company Code Client Company Code	`ESH_S_PURCHASE_ORDER.MANDT == T001.MANDT` `ESH_S_PURCHASE_ORDER.COMPANYCODE == T001.BUKRS`
Controlling Area Client Controlling Area	`ESH_S_PURCHASE_ORDER.MANDT == TKA01.MANDT` `ESH_S_PURCHASE_ORDER.CONTROLLINGAREA == TKA01.KOKRS`
Currency Key Client Currency Key Currency Key	`ESH_S_PURCHASE_ORDER.MANDT == TCURC.MANDT` `ESH_S_PURCHASE_ORDER.DOCUMENTCURRENCY == TCURC.WAERS` `ESH_S_PURCHASE_ORDER.PURCHASEORDERCURRENCY == TCURC.WAERS`
Incoterms (Part 1) Client Incoterms (Part 1)	`ESH_S_PURCHASE_ORDER.MANDT == TINC.MANDT` `ESH_S_PURCHASE_ORDER.INCOTERMSCLASSIFICATION == TINC.INCO1`
Material number Client Material number	`ESH_S_PURCHASE_ORDER.MANDT == MARA.MANDT` `ESH_S_PURCHASE_ORDER.MANUFACTURERMATERIAL == MARA.MATNR`
Material Number Client Material Number	`ESH_S_PURCHASE_ORDER.MANDT == MARA.MANDT` `ESH_S_PURCHASE_ORDER.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`ESH_S_PURCHASE_ORDER.MANDT == T023.MANDT` `ESH_S_PURCHASE_ORDER.MATERIALGROUP == T023.MATKL`
Order Price Unit (Purchasing) Client Order Price Unit (Purchasing)	`ESH_S_PURCHASE_ORDER.MANDT == T006.MANDT` `ESH_S_PURCHASE_ORDER.ORDERPRICEUNIT == T006.MSEHI`
Plant Client Plant	`ESH_S_PURCHASE_ORDER.MANDT == T001W.MANDT` `ESH_S_PURCHASE_ORDER.PLANT == T001W.WERKS`
Currency Key Client Currency Key Currency Key	`ESH_S_PURCHASE_ORDER.MANDT == TCURC.MANDT` `ESH_S_PURCHASE_ORDER.DOCUMENTCURRENCY == TCURC.WAERS` `ESH_S_PURCHASE_ORDER.PURCHASEORDERCURRENCY == TCURC.WAERS`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`ESH_S_PURCHASE_ORDER.MANDT == T006.MANDT` `ESH_S_PURCHASE_ORDER.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchasing Document Type Client Purchasing Document Type ?	`ESH_S_PURCHASE_ORDER.MANDT == T161.MANDT` `ESH_S_PURCHASE_ORDER.PURCHASEORDERTYPE == T161.BSART` `ESH_S_PURCHASE_ORDER.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Purchasing Group Client	`ESH_S_PURCHASE_ORDER.PURCHASINGGROUP == T024.EKGRP` `ESH_S_PURCHASE_ORDER.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`ESH_S_PURCHASE_ORDER.PURCHASINGORGANIZATION == T024E.EKORG` `ESH_S_PURCHASE_ORDER.MANDT == T024E.MANDT`
Supplier Client Supplier	`ESH_S_PURCHASE_ORDER.MANDT == LFA1.MANDT` `ESH_S_PURCHASE_ORDER.SUPPLIER == LFA1.LIFNR`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`ESH_S_PURCHASE_ORDER.MANDT == T001W.MANDT` `ESH_S_PURCHASE_ORDER.SUPPLYINGPLANT == T001W.WERKS`