R_CentralPurchaseContract

Central Purchase Contract Base View | view: RCNTRLPCON | TRAN | Extraction: Not supported | Component: Contract
Tables used: EKKO
Column Name Description
CentralPurchaseContract Central Purchase Contract
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
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingProcessingStatus Purchasing document processing state Show values
PurgDocumentDistributionType Distribution Type for Purchasing Document Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
PurgDocChangeRequestStatus Change Request Status Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
PurgDocIsChgVers Checkbox Show values
IsExtPurgScenario Boolean Variable (X = True, - = False, Space = Unknown) 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
PurchasingParentDocument ID of the Parent Document EBELN
ProcmtHubCompanyCodeGroupingID Grouping ID for Company Codes MMPUR_D_CC_GROUPING_ID
ActivePurchasingDocument Active Purchasing Document EBELN
PurchasingDocumentVersion Version number in Purchasing REVNO
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • R_CENTRALPURCHASECONTRACT.MANDT == T001.MANDT
  • R_CENTRALPURCHASECONTRACT.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • R_CENTRALPURCHASECONTRACT.MANDT == TCURC.MANDT
  • R_CENTRALPURCHASECONTRACT.DOCUMENTCURRENCY == TCURC.WAERS
  • R_CENTRALPURCHASECONTRACT.CURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • R_CENTRALPURCHASECONTRACT.MANDT == TCURC.MANDT
  • R_CENTRALPURCHASECONTRACT.DOCUMENTCURRENCY == TCURC.WAERS
  • R_CENTRALPURCHASECONTRACT.CURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • R_CENTRALPURCHASECONTRACT.MANDT == TINC.MANDT
  • R_CENTRALPURCHASECONTRACT.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • R_CENTRALPURCHASECONTRACT.INCOTERMSVERSION == TINCV.INCOV
  • R_CENTRALPURCHASECONTRACT.MANDT == TINCV.MANDT
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • R_CENTRALPURCHASECONTRACT.MANDT == LFA1.MANDT
  • R_CENTRALPURCHASECONTRACT.INVOICINGPARTY == LFA1.LIFNR
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • R_CENTRALPURCHASECONTRACT.MANDT == T161.MANDT
  • R_CENTRALPURCHASECONTRACT.PURCHASECONTRACTTYPE == T161.BSART
  • R_CENTRALPURCHASECONTRACT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • R_CENTRALPURCHASECONTRACT.MANDT == T024.MANDT
  • R_CENTRALPURCHASECONTRACT.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • R_CENTRALPURCHASECONTRACT.PURCHASINGORGANIZATION == T024E.EKORG
  • R_CENTRALPURCHASECONTRACT.MANDT == T024E.MANDT
Release Indicator: Purchasing Document
  • Release Indicator: Purchasing Document
  • Client
  • R_CENTRALPURCHASECONTRACT.RELEASECODE == T16FB.FRGKE
  • R_CENTRALPURCHASECONTRACT.MANDT == T16FB.MANDT
Supplier
  • Client
  • Supplier
  • R_CENTRALPURCHASECONTRACT.MANDT == LFA1.MANDT
  • R_CENTRALPURCHASECONTRACT.SUPPLIER == LFA1.LIFNR
Goods Supplier
  • Goods Supplier
  • Client
  • R_CENTRALPURCHASECONTRACT.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • R_CENTRALPURCHASECONTRACT.MANDT == LFA1.MANDT