R_PurchaseContract

Purchase Contract Base View | view: RPURCHASECTR | TRAN | Extraction: Not supported | Component: Contract
Tables used: EKKO
Column Name Description
PurchaseContract Purchasing Contract Header
Column Name Description
💲 Currency Key (DocumentCurrency):
PurchaseContractTargetAmount Target Value for Header Area per Distribution
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
QuotationSubmissionDate Quotation Submission Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingProcessingStatus Purchasing document processing state Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
LastChangeDateTime Change Time Stamp TZNTSTMPL
IncotermsTransferLocation Incoterms (Part 2) INCO2
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
CreatedByUser User of person who created a purchasing document USNAM
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
ExchangeRate Exchange Rate KURSP
SupplierQuotation Quotation Number ANGNR
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
PurchasingDocumentName Name of Purchasing Document TEXT40
ManualSupplierAddressID Address Number AD_ADDRNUM
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • R_PURCHASECONTRACT.COMPANYCODE == T001.BUKRS
  • R_PURCHASECONTRACT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • R_PURCHASECONTRACT.DOCUMENTCURRENCY == TCURC.WAERS
  • R_PURCHASECONTRACT.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • R_PURCHASECONTRACT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • R_PURCHASECONTRACT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • R_PURCHASECONTRACT.INCOTERMSVERSION == TINCV.INCOV
  • R_PURCHASECONTRACT.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • R_PURCHASECONTRACT.INVOICINGPARTY == LFA1.LIFNR
  • R_PURCHASECONTRACT.MANDT == LFA1.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • R_PURCHASECONTRACT.PURCHASECONTRACTTYPE == T161.BSART
  • R_PURCHASECONTRACT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • R_PURCHASECONTRACT.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • R_PURCHASECONTRACT.PURCHASINGGROUP == T024.EKGRP
  • R_PURCHASECONTRACT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • R_PURCHASECONTRACT.PURCHASINGORGANIZATION == T024E.EKORG
  • R_PURCHASECONTRACT.MANDT == T024E.MANDT
Release Indicator: Purchasing Document
  • Release Indicator: Purchasing Document
  • Client
  • R_PURCHASECONTRACT.RELEASECODE == T16FB.FRGKE
  • R_PURCHASECONTRACT.MANDT == T16FB.MANDT
Supplier
  • Supplier
  • Client
  • R_PURCHASECONTRACT.SUPPLIER == LFA1.LIFNR
  • R_PURCHASECONTRACT.MANDT == LFA1.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • R_PURCHASECONTRACT.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • R_PURCHASECONTRACT.MANDT == LFA1.MANDT