ESH_N_CENTRL_PURCHASE_CONTRACT

Anchor view -CENTRL_PURCHASE_CONTRACT | view: ESH_L_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
PURCHASINGPROCESSINGSTATUS Purchasing document processing state Show values
Column Name Description Domain name
COMPANYCODENAME Name of Company Code or Company TEXT25
CREATEDBYUSER User of person who created a purchasing document USNAM
DOCUMENTSTATUSNAME Short Text for Fixed Values DDTEXT
ORGANIZATIONBPNAME1 Name 1 NAME
PAYMENTTERMS Terms of Payment Key ZTERM
PAYMENTTERMSNAME Description of terms of payment TEXT30
PRODUCTGROUPNAME Product Group Description TEXT20
PURCHASECONTRACTITEMTEXT Short Text TEXT40
PURCHASINGCENTRALMATERIAL Material of External System MATNR
PURCHASINGDOCUMENTNAME Name of Purchasing Document TEXT40
PURCHASINGDOCUMENTTYPENAME Short Description of Purchasing Document Type TEXT20
PURCHASINGGROUPNAME Purchasing Group Name TEXT18
PURCHASINGORGANIZATIONNAME Purchasing Organization Name TEXT20
PURCHASINGPARENTDOCUMENT ID of the Parent Document EBELN
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • ESH_N_CENTRL_PURCHASE_CONTRACT.MANDT == T001.MANDT
  • ESH_N_CENTRL_PURCHASE_CONTRACT.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • ESH_N_CENTRL_PURCHASE_CONTRACT.MANDT == TCURC.MANDT
  • ESH_N_CENTRL_PURCHASE_CONTRACT.CURRENCY == TCURC.WAERS
Material Group
  • Client
  • Material Group
  • ESH_N_CENTRL_PURCHASE_CONTRACT.MANDT == T023.MANDT
  • ESH_N_CENTRL_PURCHASE_CONTRACT.MATERIALGROUP == T023.MATKL
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • ?
  • ESH_N_CENTRL_PURCHASE_CONTRACT.MANDT == T161.MANDT
  • ESH_N_CENTRL_PURCHASE_CONTRACT.PURCHASECONTRACTTYPE == T161.BSART
  • ESH_N_CENTRL_PURCHASE_CONTRACT.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_N_CENTRL_PURCHASE_CONTRACT.MANDT == T024.MANDT
  • ESH_N_CENTRL_PURCHASE_CONTRACT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • ESH_N_CENTRL_PURCHASE_CONTRACT.MANDT == T024E.MANDT
  • ESH_N_CENTRL_PURCHASE_CONTRACT.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • ESH_N_CENTRL_PURCHASE_CONTRACT.SUPPLIER == LFA1.LIFNR
  • ESH_N_CENTRL_PURCHASE_CONTRACT.MANDT == LFA1.MANDT