C_ContractMaintain

Purchase Contract Maintain | view: CCTRMAINTAIN | Extraction: Not supported | Component: Contract
Tables used: SCAL_TT_DATE, EKAB, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, QTY_CON_PAI, EKKO, EKPO, T001, TKA02, TCURT, TINCT, TVZBT, T001W, T161, T161T, T024, T024E, T161, T162, A019, KONP, A016, KONP, TINCVT, USREFUS, LFA1, USR21, KONM, KONW, KONP
Column Name Description
PurchaseContract Purchasing Contract Header
Column Name Description
💲 Currency Key (Currency):
PurchaseContractTargetAmount Target Value for Header Area per Distribution
PurContrConsumedVal null
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
ContractExpiryPredictedDate null
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
PurchasingItemHasHierarchy Boolean Variable (X = True, - = False, Space = Unknown) Show values
IsExpired Contract is Expired Show values
IsPurContrTemplate Contract Draft is a Template Show values
IsLglTransIntegEnabled Boolean Variable (X = True, - = False, Space = Unknown) Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
PurchaseContractForEdit Purchasing Contract Header EBELN
PurgContractIsInPreparation Boolean Variable (X = True, - = False, Space = Unknown)
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
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
SupplierAddressID Address Number AD_ADDRNUM
ExchangeRate Exchange Rate FIS_UKURS
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
PurContrStatusCriticality Purchase Contract Validity Status Criticality INT1
PurContrValidityStatusName Purchase Contract Validity Status
PurchaseContractValidityStatus null
PurContrHasAdvncdUsrInterface Boolean Variable (X = True, - = False, Space = Unknown)
NumberOfDays Number of Days in Year or Month INT4
PurContrOutputCtrlType Purchase Contract Output Control Type CHAR1
PurContrOutputCtrlStatus Purchase Contract Output Control Status
PurContrOutputCtrlStatusTxt Purchase Contract Output Control Status Text
PurContrOutputCtrlTime Purchase Contract Output Control Timestamp TZNTSTMPS
AccWorkflowApprover User Name in User Master Record XUBNAME
AccWorkflowApproverFirstName Full Name of Approver TEXT80
ApprovalStatusName Short Text for Fixed Values
ApproverUser Actual Agent of Work Item SYCHAR12
PurchasingDocumentStatus Short Text for Fixed Values
WeightedRelevance null
PurContrCnsmpnCriticality Purchase Contract Validity Status Criticality
CreatedByUserName User alias CHAR130
ContractConsumptionInPct null
ChangeRecordReferenceUUID UUID in X form (binary)
PaymentTermsName Description of terms of payment TEXT30
SupplierOperationalScore Supplier Operational Score
CompanyCodeName Name of Company Code or Company TEXT25
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
CurrencyName Description TEXT40
IncotermsVersionName Description TEXT30
IncotermsClassificationName Description TEXT30
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_CONTRACTMAINTAIN.COMPANYCODE == T001.BUKRS
  • C_CONTRACTMAINTAIN.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • C_CONTRACTMAINTAIN.CURRENCY == TCURC.WAERS
  • C_CONTRACTMAINTAIN.DOCUMENTCURRENCY == TCURC.WAERS
  • C_CONTRACTMAINTAIN.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • C_CONTRACTMAINTAIN.CURRENCY == TCURC.WAERS
  • C_CONTRACTMAINTAIN.DOCUMENTCURRENCY == TCURC.WAERS
  • C_CONTRACTMAINTAIN.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_CONTRACTMAINTAIN.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_CONTRACTMAINTAIN.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_CONTRACTMAINTAIN.INCOTERMSVERSION == TINCV.INCOV
  • C_CONTRACTMAINTAIN.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • C_CONTRACTMAINTAIN.INVOICINGPARTY == LFA1.LIFNR
  • C_CONTRACTMAINTAIN.MANDT == LFA1.MANDT
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • C_CONTRACTMAINTAIN.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_CONTRACTMAINTAIN.PURCHASECONTRACTTYPE == T161.BSART
  • C_CONTRACTMAINTAIN.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_CONTRACTMAINTAIN.PURCHASINGGROUP == T024.EKGRP
  • C_CONTRACTMAINTAIN.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_CONTRACTMAINTAIN.PURCHASINGORGANIZATION == T024E.EKORG
  • C_CONTRACTMAINTAIN.MANDT == T024E.MANDT
Release Indicator: Purchasing Document
  • Release Indicator: Purchasing Document
  • Client
  • C_CONTRACTMAINTAIN.RELEASECODE == T16FB.FRGKE
  • C_CONTRACTMAINTAIN.MANDT == T16FB.MANDT
Supplier
  • Supplier
  • Client
  • C_CONTRACTMAINTAIN.SUPPLIER == LFA1.LIFNR
  • C_CONTRACTMAINTAIN.MANDT == LFA1.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • C_CONTRACTMAINTAIN.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • C_CONTRACTMAINTAIN.MANDT == LFA1.MANDT