C_Salescontractfs

Sales Contract | view: CSCONTRFS | TRAN | Extraction: Not supported | Component: Outline Agreements (Customer)
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
SalesContractValidityStartDate Valid-From Date (Outline Agreements, Product Proposals)
SalesContractValidityEndDate Valid-To Date (Outline Agreements, Product Proposals)
CustomerPurchaseOrderDate Customer Reference Date
SalesContractDate Document Date (Date Received/Sent)
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
ContractDownPaymentStatus Down Payment Status Show values
SalesDocApprovalStatus Document Approval Status Show values
Column Name Description Domain name
SalesDocumentTypeName null
SlsContrApprovalStsCriticality null
SalesAreaDesc Sales Area TXT_VTRBER
EmployeeName Character field, 8 characters long
ResponsibleEmployeeName null
PurchaseOrderByCustomer Customer Reference BSTKD
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_SALESCONTRACTFS.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESCONTRACTFS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESCONTRACTFS.MANDT == TVKOV.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • C_SALESCONTRACTFS.SALESORGANIZATION == TVTA.VKORG
  • C_SALESCONTRACTFS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SALESCONTRACTFS.MANDT == TVTA.MANDT
  • C_SALESCONTRACTFS.ORGANIZATIONDIVISION == TVTA.SPART
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • C_SALESCONTRACTFS.SALESCONTRACTAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • C_SALESCONTRACTFS.MANDT == SDAPMAPRR.CLIENT
Order type in order header
  • Sales Contract Type
  • Client
  • C_SALESCONTRACTFS.SALESCONTRACTTYPE == TVAK.AUART
  • C_SALESCONTRACTFS.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESCONTRACTFS.SALESORGANIZATION == TVKO.VKORG
  • C_SALESCONTRACTFS.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_SALESCONTRACTFS.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESCONTRACTFS.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • C_SALESCONTRACTFS.MANDT == TCURC.MANDT
  • C_SALESCONTRACTFS.TRANSACTIONCURRENCY == TCURC.WAERS