C_SalesContractWl_F1851

Sales Contracts | view: CSCONTRWLF1851 | TRAN | Extraction: Not supported | Component: Outline Agreements (Customer)
Tables used: VBKDVEDAVBAKADCPADRCADR6ADR2BUT000KNA1CVI_CUST_LINK
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)
SalesContractDate Document Date (Date Received/Sent)
LastChangeDate Last Changed On
CreationDate Date on which the record was created
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
Column Name Description Domain name
PurchaseOrderByCustomer Customer Reference BSTKD
ContractDownPaymentStatus Down Payment Status
LastChangeDateTime Last Changed Date Time TZNTSTMPL
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
SlsContrDueDateCriticality null
SlsContrApprovalStsCriticality null
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • C_SALESCONTRACTWL_F1851.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESCONTRACTWL_F1851.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESCONTRACTWL_F1851.MANDT == TVKOV.MANDT
Division in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • Division
  • C_SALESCONTRACTWL_F1851.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SALESCONTRACTWL_F1851.SALESORGANIZATION == TVTA.VKORG
  • C_SALESCONTRACTWL_F1851.MANDT == TVTA.MANDT
  • C_SALESCONTRACTWL_F1851.ORGANIZATIONDIVISION == TVTA.SPART
Order type in order header
  • Sales Contract Type
  • Client
  • C_SALESCONTRACTWL_F1851.SALESCONTRACTTYPE == TVAK.AUART
  • C_SALESCONTRACTWL_F1851.MANDT == TVAK.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • C_SALESCONTRACTWL_F1851.SALESOFFICE == TVBVK.VKBUR
  • C_SALESCONTRACTWL_F1851.SALESGROUP == TVBVK.VKGRP
  • C_SALESCONTRACTWL_F1851.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_SALESCONTRACTWL_F1851.SALESORGANIZATION == TVKO.VKORG
  • C_SALESCONTRACTWL_F1851.MANDT == TVKO.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • C_SALESCONTRACTWL_F1851.MANDT == KNA1.MANDT
  • C_SALESCONTRACTWL_F1851.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_SALESCONTRACTWL_F1851.MANDT == TCURC.MANDT
  • C_SALESCONTRACTWL_F1851.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Sales office
  • Sales Organization
  • Client
  • Division
  • C_SALESCONTRACTWL_F1851.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SALESCONTRACTWL_F1851.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESCONTRACTWL_F1851.SALESORGANIZATION == TVKBZ.VKORG
  • C_SALESCONTRACTWL_F1851.MANDT == TVKBZ.MANDT
  • C_SALESCONTRACTWL_F1851.ORGANIZATIONDIVISION == TVKBZ.SPART