ESH_N_PURCHASECONTRACT

Anchor view -PURCHASECONTRACT | view: ESH_L_PURCTR | Extraction: Not supported | Component: Basic Functions
Column Name Description
PURCHASECONTRACT Purchasing Contract Header
Column Name Description
💲 Currency Key (DOCUMENTCURRENCY):
CONTRACTNETPRICEAMOUNT Net Price in Purchasing Document (in Document Currency)
PURCHASECONTRACTTARGETAMOUNT Target Value for Header Area per Distribution
TARGETAMOUNT Target Value for Outline Agreement in Document Currency
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 TEXT25
CREATEDBYUSER User of person who created a purchasing document USNAM
INCOTERMSCLASSIFICATIONNAME Description TEXT30
INCOTERMSTRANSFERLOCATION Incoterms (Part 2) INCO2
MATGRPAUTHGRP Authorization Group BEGRU
MATERIALGROUPNAME Product Group Description TEXT20
MATERIALNAME Material Description TEXT40
NETPRICEQUANTITY Price Unit DEC5
SUPPLIERNAME Name 1 NAME
PAYMENTTERMS Terms of Payment Key ZTERM
PAYMENTTERMSNAME Description of terms of payment TEXT30
PLANTNAME Plant Name TEXT30
PURCHASECONTRACTITEM Item Number of Purchasing Contract EBELP
PURCHASECONTRACTITEMTEXT Short Text TEXT40
DELETIONCODEHDR Deletion Indicator in Purchasing Document ELOEK
PURCHASINGDOCUMENTDELETIONCODE Deletion Indicator in Purchasing Document ELOEK
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type TEXT20
PURCHASINGGROUPNAME Purchasing Group Name TEXT18
PURCHASINGORGANIZATIONNAME Purchasing Organization Name TEXT20
SUPPLIERPHONENUMBER Supplier's Telephone Number TEXT16
USERNAME User Description SUIDTECHDESC
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • ESH_N_PURCHASECONTRACT.COMPANYCODE == T001.BUKRS
  • ESH_N_PURCHASECONTRACT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • ESH_N_PURCHASECONTRACT.DOCUMENTCURRENCY == TCURC.WAERS
  • ESH_N_PURCHASECONTRACT.CURRENCY == TCURC.WAERS
  • ESH_N_PURCHASECONTRACT.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • ESH_N_PURCHASECONTRACT.DOCUMENTCURRENCY == TCURC.WAERS
  • ESH_N_PURCHASECONTRACT.CURRENCY == TCURC.WAERS
  • ESH_N_PURCHASECONTRACT.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • ESH_N_PURCHASECONTRACT.MATERIAL == MARA.MATNR
  • ESH_N_PURCHASECONTRACT.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • ESH_N_PURCHASECONTRACT.MATERIALGROUP == T023.MATKL
  • ESH_N_PURCHASECONTRACT.MANDT == T023.MANDT
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • ESH_N_PURCHASECONTRACT.ORDERPRICEUNIT == T006.MSEHI
  • ESH_N_PURCHASECONTRACT.MANDT == T006.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • ESH_N_PURCHASECONTRACT.ORDERQUANTITYUNIT == T006.MSEHI
  • ESH_N_PURCHASECONTRACT.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • ESH_N_PURCHASECONTRACT.PLANT == T001W.WERKS
  • ESH_N_PURCHASECONTRACT.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • ESH_N_PURCHASECONTRACT.PURCHASECONTRACTTYPE == T161.BSART
  • ESH_N_PURCHASECONTRACT.[column in domain "BSTYP"] == T161.BSTYP
  • ESH_N_PURCHASECONTRACT.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_N_PURCHASECONTRACT.PURCHASINGGROUP == T024.EKGRP
  • ESH_N_PURCHASECONTRACT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ESH_N_PURCHASECONTRACT.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_N_PURCHASECONTRACT.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • ESH_N_PURCHASECONTRACT.SUPPLIER == LFA1.LIFNR
  • ESH_N_PURCHASECONTRACT.MANDT == LFA1.MANDT
Vendor account group
  • Vendor account group
  • Client
  • ESH_N_PURCHASECONTRACT.VENDACCTGRP == T077K.KTOKK
  • ESH_N_PURCHASECONTRACT.MANDT == T077K.MANDT