I_SalesContract

Sales Contract | view: ISDSALESCONTRACT | ATTR | Extraction: Not supported | Component: Customer Contract
Tables used: VBKD, VEDA, VBAK
Column Name Description
SalesContract Sales Contract
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesContractDate Document Date (Date Received/Sent)
ServicesRenderedDate Date on which services are rendered
CustomerPurchaseOrderDate Customer Reference Date
SalesContractSignedDate Date on Which Contract Is Signed
ContractPartnerCanclnDocDate Date of Cancellation Document from Contract Partner
SalesContractValidityStartDate Valid-From Date (Outline Agreements, Product Proposals)
SalesContractValidityEndDate Valid-To Date (Outline Agreements, Product Proposals)
SlsContractCanclnReqRcptDate Date on Which Cancellation Request Was Received
RequestedCancellationDate Requested Cancellation Date
EquipmentInstallationDate Installation Date
EquipmentDeliveryAccptcDate Agreement Acceptance Date
EquipmentDismantlingDate Dismantling Date
SlsContractFollowUpActionDate Date for Action
PricingDate Date for Pricing and Exchange Rate
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
ExchangeRateDate Translation date
Column Name Description
SalesContractValidityPerdUnit Unit of Validity Period of Contract Show values
SalesContractCanclnParty Cancellation Party Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
MaxDocValueCreditCheckStatus Status of Credit Check Against Maximum Document Value Show values
PaymentTermCreditCheckStatus Status of Credit Check Against Terms of Payment Show values
FinDocCreditCheckStatus Status of Credit Check Against Financial Document Show values
ExprtInsurCreditCheckStatus Status of Credit Check Against Export Credit Insurance Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
CentralCreditCheckStatus Status of Credit Check SAP Credit Management Show values
CentralCreditChkTechErrSts Status of Technical Error SAP Credit Management Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
ContractDownPaymentStatus Down Payment Status Show values
SalesDocApprovalStatus Document Approval Status Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
NmbrOfSalesContractValdtyPerd Validity Period of Contract NUM3
CanclnDocByContrPartner Cancellation Document Number of Contract Partner CHAR20
MasterSalesContract Master Contract Number VBELN
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
SalesContractCondition Number of the Document Condition KNUMV
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AdditionalValueDays Additional Value Days TAGE2
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
CostCenter Cost Center KOSTL
ReferenceSDDocument Document number of the reference document VBELN
ContractManualCompletion Manual Completion of Contract MANEK
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_SALESCONTRACT.MANDT == TVV1.MANDT
  • I_SALESCONTRACT.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • I_SALESCONTRACT.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_SALESCONTRACT.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_SALESCONTRACT.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_SALESCONTRACT.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • I_SALESCONTRACT.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_SALESCONTRACT.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • I_SALESCONTRACT.MANDT == TVV5.MANDT
  • I_SALESCONTRACT.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_SALESCONTRACT.BILLINGCOMPANYCODE == T001.BUKRS
  • I_SALESCONTRACT.MANDT == T001.MANDT
Business Area
  • Client
  • Business Area
  • I_SALESCONTRACT.MANDT == TGSB.MANDT
  • I_SALESCONTRACT.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • I_SALESCONTRACT.MANDT == TKA01.MANDT
  • I_SALESCONTRACT.CONTROLLINGAREA == TKA01.KOKRS
Business Area from Cost Center
  • Business Area from Cost Center
  • Client
  • I_SALESCONTRACT.COSTCENTERBUSINESSAREA == TGSB.GSBER
  • I_SALESCONTRACT.MANDT == TGSB.MANDT
Credit control area
  • Client
  • Credit control area
  • I_SALESCONTRACT.MANDT == T014.MANDT
  • I_SALESCONTRACT.CREDITCONTROLAREA == T014.KKBER
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_SALESCONTRACT.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_SALESCONTRACT.MANDT == TVKT.MANDT
Customer Group
  • Client
  • Customer Group
  • I_SALESCONTRACT.MANDT == T151.MANDT
  • I_SALESCONTRACT.CUSTOMERGROUP == T151.KDGRP
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • I_SALESCONTRACT.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • I_SALESCONTRACT.MANDT == T176.MANDT
Agreement (various conditions grouped together)
  • Client
  • Agreement (various conditions grouped together)
  • I_SALESCONTRACT.MANDT == KONA.MANDT
  • I_SALESCONTRACT.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_SALESCONTRACT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESCONTRACT.MANDT == TVKOV.MANDT
  • I_SALESCONTRACT.SALESORGANIZATION == TVKOV.VKORG
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_SALESCONTRACT.EXCHANGERATETYPE == TCURV.KURST
  • I_SALESCONTRACT.MANDT == TCURV.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_SALESCONTRACT.MANDT == TINC.MANDT
  • I_SALESCONTRACT.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • I_SALESCONTRACT.INCOTERMSVERSION == TINCV.INCOV
  • I_SALESCONTRACT.MANDT == TINCV.MANDT
Order Number
  • Client
  • Order Number
  • I_SALESCONTRACT.MANDT == AUFK.MANDT
  • I_SALESCONTRACT.ORDERID == AUFK.AUFNR
Division in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • Division
  • I_SALESCONTRACT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESCONTRACT.MANDT == TVTA.MANDT
  • I_SALESCONTRACT.SALESORGANIZATION == TVTA.VKORG
  • I_SALESCONTRACT.ORGANIZATIONDIVISION == TVTA.SPART
Payment Method
  • Client
  • ?
  • Payment Method
  • I_SALESCONTRACT.MANDT == T042Z.MANDT
  • I_SALESCONTRACT.[column in domain "LAND1"] == T042Z.LAND1
  • I_SALESCONTRACT.PAYMENTMETHOD == T042Z.ZLSCH
Product Catalog
  • Client
  • Product catalog number
  • I_SALESCONTRACT.MANDT == WWMI.MANDT
  • I_SALESCONTRACT.PRODUCTCATALOG == WWMI.WMINR
Retail promotion
  • Client
  • Promotion
  • I_SALESCONTRACT.MANDT == WAKH.MANDT
  • I_SALESCONTRACT.RETAILPROMOTION == WAKH.AKTNR
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • I_SALESCONTRACT.MANDT == SDAPMAPRR.CLIENT
  • I_SALESCONTRACT.SALESCONTRACTAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Assignment Cancellation Procedure/Cancellation Rule
  • Client
  • Assignment Cancellation Procedure/Cancellation Rule
  • I_SALESCONTRACT.MANDT == TVKS.MANDT
  • I_SALESCONTRACT.SALESCONTRACTCANCLNPROCEDURE == TVKS.VKUESCH
Reason for Cancellation of Contract
  • Reason for Cancellation of Contract
  • Client
  • I_SALESCONTRACT.SALESCONTRACTCANCLNREASON == TVKG.KUEGRU
  • I_SALESCONTRACT.MANDT == TVKG.MANDT
Action at end of contract
  • Client
  • Action at end of contract
  • I_SALESCONTRACT.MANDT == TVAS.MANDT
  • I_SALESCONTRACT.SALESCONTRACTFOLLOWUPACTION == TVAS.AKTVT
Order type in order header
  • Sales Contract Type
  • Client
  • I_SALESCONTRACT.SALESCONTRACTTYPE == TVAK.AUART
  • I_SALESCONTRACT.MANDT == TVAK.MANDT
Validity Period Category of Contract
  • Client
  • Validity Period Category of Contract
  • I_SALESCONTRACT.MANDT == TVLZ.MANDT
  • I_SALESCONTRACT.SALESCONTRACTVALIDITYPERDCAT == TVLZ.VLAUFK
Sales District
  • Sales District
  • Client
  • I_SALESCONTRACT.SALESDISTRICT == T171.BZIRK
  • I_SALESCONTRACT.MANDT == T171.MANDT
Sales group
  • Sales group
  • Client
  • Sales office
  • I_SALESCONTRACT.SALESGROUP == TVBVK.VKGRP
  • I_SALESCONTRACT.MANDT == TVBVK.MANDT
  • I_SALESCONTRACT.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESCONTRACT.MANDT == TVKO.MANDT
  • I_SALESCONTRACT.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • I_SALESCONTRACT.MANDT == TVAU.MANDT
  • I_SALESCONTRACT.SDDOCUMENTREASON == TVAU.AUGRU
Sold-to Party
  • Sold-to Party
  • Client
  • I_SALESCONTRACT.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESCONTRACT.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • I_SALESCONTRACT.MANDT == TCURC.MANDT
  • I_SALESCONTRACT.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Client
  • Sales Organization
  • Division
  • Sales office
  • I_SALESCONTRACT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESCONTRACT.MANDT == TVKBZ.MANDT
  • I_SALESCONTRACT.SALESORGANIZATION == TVKBZ.VKORG
  • I_SALESCONTRACT.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SALESCONTRACT.SALESOFFICE == TVKBZ.VKBUR