ESH_S_PURCHASECONTRACT

Search view -PURCHASECONTRACT | view: ESH_U_PURCTR | Extraction: Not supported | Component: Basic Functions
Column Name Description
Column Name Description
💲 Currency Key (CURRENCY):
CONTRACTNETPRICEAMOUNT Net Price in Purchasing Document (in Document Currency)
TARGETAMOUNT Target Value for Outline Agreement in Document Currency
💲 Currency Key (DOCUMENTCURRENCY):
PURCHASECONTRACTTARGETAMOUNT Target Value for Header Area per Distribution
Column Name Description
📏 Purchase Order Unit of Measure (ORDERQUANTITYUNIT):
TARGETQUANTITY Target Quantity
Column Name Description
CREATIONDATE Creation Date of Purchasing Document
VALIDITYENDDATE End of Validity Period
VALIDITYSTARTDATE Start of Validity Period
Column Name Description
Column Name Description Domain name
MATAUTHGRP Authorization Group BEGRU
MATLTYPAUTHGRP Authorization group in the material master BEGRM
VENDAUTHGRP Authorization Group BRGRU
COMPANYCODENAME Name of Company Code or Company
CREATEDBYUSER User of person who created a purchasing document USNAM
INCOTERMSCLASSIFICATIONNAME Description
INCOTERMSTRANSFERLOCATION Incoterms (Part 2) INCO2
MATGRPAUTHGRP Authorization Group BEGRU
MATERIALGROUPNAME Product Group Description
MATERIALNAME Material Description TEXT40
NETPRICEQUANTITY Price Unit DEC5
SUPPLIERNAME Name 1
PAYMENTTERMS Terms of Payment Key ZTERM
PAYMENTTERMSNAME Description of terms of payment
PLANTNAME Plant Name
PURCHASECONTRACT Purchasing Contract Header EBELN
PURCHASECONTRACTITEM Item Number of Purchasing Contract EBELP
PURCHASECONTRACTITEMTEXT Short Text TEXT40
DELETIONCODEHDR Deletion Indicator in Purchasing Document ELOEK
PURCHASINGDOCUMENTDELETIONCODE Deletion Indicator in Purchasing Document
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type
PURCHASINGGROUPNAME Purchasing Group Name
PURCHASINGORGANIZATIONNAME Purchasing Organization Name
SUPPLIERPHONENUMBER Supplier's Telephone Number TEXT16
USERNAME User Description
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • ESH_S_PURCHASECONTRACT.COMPANYCODE == T001.BUKRS
  • ESH_S_PURCHASECONTRACT.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • ESH_S_PURCHASECONTRACT.MANDT == TCURC.MANDT
  • ESH_S_PURCHASECONTRACT.DOCUMENTCURRENCY == TCURC.WAERS
  • ESH_S_PURCHASECONTRACT.CURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • ESH_S_PURCHASECONTRACT.MANDT == TCURC.MANDT
  • ESH_S_PURCHASECONTRACT.DOCUMENTCURRENCY == TCURC.WAERS
  • ESH_S_PURCHASECONTRACT.CURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • ESH_S_PURCHASECONTRACT.MANDT == MARA.MANDT
  • ESH_S_PURCHASECONTRACT.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • ESH_S_PURCHASECONTRACT.MANDT == T023.MANDT
  • ESH_S_PURCHASECONTRACT.MATERIALGROUP == T023.MATKL
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • ESH_S_PURCHASECONTRACT.MANDT == T006.MANDT
  • ESH_S_PURCHASECONTRACT.ORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • ESH_S_PURCHASECONTRACT.MANDT == T006.MANDT
  • ESH_S_PURCHASECONTRACT.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • ESH_S_PURCHASECONTRACT.MANDT == T001W.MANDT
  • ESH_S_PURCHASECONTRACT.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • ?
  • ESH_S_PURCHASECONTRACT.PURCHASECONTRACTTYPE == T161.BSART
  • ESH_S_PURCHASECONTRACT.MANDT == T161.MANDT
  • ESH_S_PURCHASECONTRACT.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_S_PURCHASECONTRACT.MANDT == T024.MANDT
  • ESH_S_PURCHASECONTRACT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • ESH_S_PURCHASECONTRACT.MANDT == T024E.MANDT
  • ESH_S_PURCHASECONTRACT.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • ESH_S_PURCHASECONTRACT.MANDT == LFA1.MANDT
  • ESH_S_PURCHASECONTRACT.SUPPLIER == LFA1.LIFNR
Vendor account group
  • Client
  • Vendor account group
  • ESH_S_PURCHASECONTRACT.MANDT == T077K.MANDT
  • ESH_S_PURCHASECONTRACT.VENDACCTGRP == T077K.KTOKK