C_Suppliercontracts

Purchase Contract | view: CSUPPCONTRACT | Extraction: Not supported | Component: Business Partners
Tables used: EKKO, ADR2, ADR6, ADRC, T001, TKA02, T161T, T024, T024E, ADR2, ADR6, LFA1, LFA1
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
ValidityEndDate End of Validity Period
ValidityStartDate Start of Validity Period
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
SupplierName Name 1 NAME
AddressID Contact Card Address (with output conversion) CONTACTCARDADDRESS
EmailAddress Contact Card E-Mail Address
InternationalPhoneNumber Contact Card Phone Number
InternationalMobilePhoneNumber Contact Card Mobile Phone Number
CompanyCodeName Name of Company Code or Company TEXT25
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
SupplierAddressID Address Number AD_ADDRNUM
CreatedByUser User of person who created a purchasing document USNAM
IncotermsTransferLocation Incoterms (Part 2) INCO2
PaymentTerms Terms of Payment Key ZTERM
PaymentTermsDescription Payment Terms Description
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
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_SUPPLIERCONTRACTS.COMPANYCODE == T001.BUKRS
  • C_SUPPLIERCONTRACTS.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_SUPPLIERCONTRACTS.MANDT == TCURC.MANDT
  • C_SUPPLIERCONTRACTS.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_SUPPLIERCONTRACTS.MANDT == TINC.MANDT
  • C_SUPPLIERCONTRACTS.INCOTERMSCLASSIFICATION == TINC.INCO1
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • C_SUPPLIERCONTRACTS.MANDT == LFA1.MANDT
  • C_SUPPLIERCONTRACTS.INVOICINGPARTY == LFA1.LIFNR
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • C_SUPPLIERCONTRACTS.MANDT == T161.MANDT
  • C_SUPPLIERCONTRACTS.PURCHASECONTRACTTYPE == T161.BSART
  • C_SUPPLIERCONTRACTS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_SUPPLIERCONTRACTS.MANDT == T024.MANDT
  • C_SUPPLIERCONTRACTS.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_SUPPLIERCONTRACTS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SUPPLIERCONTRACTS.MANDT == T024E.MANDT
Release Indicator: Purchasing Document
  • Client
  • Release Indicator: Purchasing Document
  • C_SUPPLIERCONTRACTS.MANDT == T16FB.MANDT
  • C_SUPPLIERCONTRACTS.RELEASECODE == T16FB.FRGKE
Supplier
  • Client
  • Supplier
  • C_SUPPLIERCONTRACTS.MANDT == LFA1.MANDT
  • C_SUPPLIERCONTRACTS.SUPPLIER == LFA1.LIFNR
Goods Supplier
  • Client
  • Goods Supplier
  • C_SUPPLIERCONTRACTS.MANDT == LFA1.MANDT
  • C_SUPPLIERCONTRACTS.SUPPLYINGSUPPLIER == LFA1.LIFNR