A_SalesContract

Sales Contract Header | view: ASALESCONTRACT | TRAN | Extraction: Not supported | Component: Outline Agreements (Customer)
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
LastChangeDate Last Changed On
CustomerPurchaseOrderDate Customer Reference Date
SalesContractDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
SalesContractValidityStartDate Valid-From Date (Outline Agreements, Product Proposals)
SalesContractValidityEndDate Valid-To Date (Outline Agreements, Product Proposals)
SalesContractSignedDate Date on Which Contract Is Signed
SlsContractFollowUpActionDate Date for Action
Column Name Description
SalesContractValidityPerdUnit Unit of Validity Period of Contract Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SalesDocApprovalStatus Document Approval Status Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
PurchaseOrderByCustomer Customer Reference BSTKD
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
NmbrOfSalesContractValdtyPerd Validity Period of Contract NUM3
ContractManualCompletion Manual Completion of Contract MANEK
ReferenceSDDocument Document number of the reference document VBELN
Master Data Relations Join Conditions
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • A_SALESCONTRACT.MANDT == T176.MANDT
  • A_SALESCONTRACT.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • A_SALESCONTRACT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_SALESCONTRACT.MANDT == TVKOV.MANDT
  • A_SALESCONTRACT.SALESORGANIZATION == TVKOV.VKORG
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • A_SALESCONTRACT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • A_SALESCONTRACT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • A_SALESCONTRACT.INCOTERMSVERSION == TINCV.INCOV
  • A_SALESCONTRACT.MANDT == TINCV.MANDT
Division in order header
  • Division
  • Distribution Channel
  • Client
  • Sales Organization
  • A_SALESCONTRACT.ORGANIZATIONDIVISION == TVTA.SPART
  • A_SALESCONTRACT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_SALESCONTRACT.MANDT == TVTA.MANDT
  • A_SALESCONTRACT.SALESORGANIZATION == TVTA.VKORG
Payment Method
  • Client
  • Payment Method
  • ?
  • A_SALESCONTRACT.MANDT == T042Z.MANDT
  • A_SALESCONTRACT.PAYMENTMETHOD == T042Z.ZLSCH
  • A_SALESCONTRACT.[column in domain "LAND1"] == T042Z.LAND1
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • A_SALESCONTRACT.SALESCONTRACTAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • A_SALESCONTRACT.MANDT == SDAPMAPRR.CLIENT
Action at end of contract
  • Client
  • Action at end of contract
  • A_SALESCONTRACT.MANDT == TVAS.MANDT
  • A_SALESCONTRACT.SALESCONTRACTFOLLOWUPACTION == TVAS.AKTVT
Order type in order header
  • Client
  • Sales Contract Type
  • A_SALESCONTRACT.MANDT == TVAK.MANDT
  • A_SALESCONTRACT.SALESCONTRACTTYPE == TVAK.AUART
Validity Period Category of Contract
  • Validity Period Category of Contract
  • Client
  • A_SALESCONTRACT.SALESCONTRACTVALIDITYPERDCAT == TVLZ.VLAUFK
  • A_SALESCONTRACT.MANDT == TVLZ.MANDT
Sales District
  • Client
  • Sales District
  • A_SALESCONTRACT.MANDT == T171.MANDT
  • A_SALESCONTRACT.SALESDISTRICT == T171.BZIRK
Sales group
  • Sales group
  • Client
  • Sales office
  • A_SALESCONTRACT.SALESGROUP == TVBVK.VKGRP
  • A_SALESCONTRACT.MANDT == TVBVK.MANDT
  • A_SALESCONTRACT.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • A_SALESCONTRACT.MANDT == TVKO.MANDT
  • A_SALESCONTRACT.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • A_SALESCONTRACT.SDDOCUMENTREASON == TVAU.AUGRU
  • A_SALESCONTRACT.MANDT == TVAU.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • A_SALESCONTRACT.SOLDTOPARTY == KNA1.KUNNR
  • A_SALESCONTRACT.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • A_SALESCONTRACT.MANDT == TCURC.MANDT
  • A_SALESCONTRACT.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Distribution Channel
  • Client
  • Sales office
  • Sales Organization
  • A_SALESCONTRACT.ORGANIZATIONDIVISION == TVKBZ.SPART
  • A_SALESCONTRACT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • A_SALESCONTRACT.MANDT == TVKBZ.MANDT
  • A_SALESCONTRACT.SALESOFFICE == TVKBZ.VKBUR
  • A_SALESCONTRACT.SALESORGANIZATION == TVKBZ.VKORG