ESH_S_CENTRL_PURCHASE_CONTRACT

Search view -CENTRL_PURCHASE_CONTRACT | view: ESH_U_CPCTR | TRAN | Extraction: Not supported | Component: Vendor Outline Agreements
Tables used: EKKOEKPOT001TKA02TVZBTT023TT023T161TT024T024ELFA1USR21T052
Column Name Description
CENTRALPURCHASECONTRACT Central Purchase Contract
Column Name Description
PURCHASECONTRACTTARGETAMOUNT Target Value for Header Area per Distribution
Column Name Description
Column Name Description
CREATIONDATE Creation Date of Purchasing Document
VALIDITYENDDATE End of Validity Period
VALIDITYSTARTDATE Start of Validity Period
Column Name Description
PURCHASINGDOCUMENTSTATUS Purchasing Document Status Show values
PURCHASINGDOCUMENTSUBTYPE Control indicator for purchasing document type Show values
Column Name Description Domain name
COMPANYCODENAME Name of Company Code or Company
CREATEDBYUSER User of person who created a purchasing document USNAM
DOCUMENTSTATUSNAME Short Text for Fixed Values DDTEXT
ORGANIZATIONBPNAME1 Name 1
PAYMENTTERMS Terms of Payment Key
PAYMENTTERMSNAME Description of terms of payment
PRODUCTGROUPNAME Product Group Description
PURCHASECONTRACTITEMTEXT Short Text
PURCHASINGCENTRALMATERIAL Material of External System
PURCHASINGDOCUMENTNAME Name of Purchasing Document
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type
PURCHASINGGROUPNAME Purchasing Group Name
PURCHASINGORGANIZATIONNAME Purchasing Organization Name
PURCHASINGPARENTDOCUMENT ID of the Parent Document EBELN
PURCHASINGPROCESSINGSTATUS Purchasing document processing state
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • ESH_S_CENTRL_PURCHASE_CONTRACT.COMPANYCODE == T001.BUKRS
  • ESH_S_CENTRL_PURCHASE_CONTRACT.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • ESH_S_CENTRL_PURCHASE_CONTRACT.MANDT == TCURC.MANDT
  • ESH_S_CENTRL_PURCHASE_CONTRACT.CURRENCY == TCURC.WAERS
Material Group
  • Material Group
  • Client
  • ESH_S_CENTRL_PURCHASE_CONTRACT.MATERIALGROUP == T023.MATKL
  • ESH_S_CENTRL_PURCHASE_CONTRACT.MANDT == T023.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • ESH_S_CENTRL_PURCHASE_CONTRACT.PURCHASECONTRACTTYPE == T161.BSART
  • ESH_S_CENTRL_PURCHASE_CONTRACT.[column in domain "BSTYP"] == T161.BSTYP
  • ESH_S_CENTRL_PURCHASE_CONTRACT.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • ESH_S_CENTRL_PURCHASE_CONTRACT.PURCHASINGGROUP == T024.EKGRP
  • ESH_S_CENTRL_PURCHASE_CONTRACT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • ESH_S_CENTRL_PURCHASE_CONTRACT.PURCHASINGORGANIZATION == T024E.EKORG
  • ESH_S_CENTRL_PURCHASE_CONTRACT.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • ESH_S_CENTRL_PURCHASE_CONTRACT.SUPPLIER == LFA1.LIFNR
  • ESH_S_CENTRL_PURCHASE_CONTRACT.MANDT == LFA1.MANDT