C_SalesQuotationWrkflwInbox

Sales Quotation Workflow Inbox | view: CQTWFIN | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBKD, VEDA, VBAK, VBPA, VBPA, ADRP, ADCP, ADRC, CVI_CUST_CT_LINK, BUT0ID, BUT000, ADRP, KNVK, T005, T005T, KNA1, CVI_CUST_LINK, TVTW, TVTWT, TSPA, TSPAT, TVAK, TVAKT, TVKO, TVKOT, SDAPMAPRR_T, TVAU, TVAUT, CVI_VEND_LINK, USR21, SDAPMAPRRCAT
Column Name Description
SalesQuotation Sales Quotation
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
CreationDate Date on which the record was created
Column Name Description
Column Name Description Domain name
DocumentTitle null
CustomerName Name of Customer TEXT80
ShipToPartyName Name of Customer TEXT80
CityName City
CountryName Country/Region Name TEXT50
PurchaseOrderByCustomer Customer Reference BSTKD
SDDocumentReasonText Description TEXT40
SDApprovalReasonName Approval Request Reason SD_APM_APPROVAL_REASON_DESCR
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
UserName User Description SUIDTECHDESC
CreatedByUser Name of Person Responsible for Creating the Object USNAM
UserDescription User Description SUIDTECHDESC
LastChangedByUser User Who Last Changed the Business Document USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == T005.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.COUNTRY == T005.LAND1
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == TVKOV.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.SALESORGANIZATION == TVKOV.VKORG
  • C_SALESQUOTATIONWRKFLWINBOX.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Client
  • Sales Organization
  • Division
  • Distribution Channel
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == TVTA.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.SALESORGANIZATION == TVTA.VKORG
  • C_SALESQUOTATIONWRKFLWINBOX.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESQUOTATIONWRKFLWINBOX.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == TVKO.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.SALESORGANIZATION == TVKO.VKORG
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == SDAPMAPRR.CLIENT
  • C_SALESQUOTATIONWRKFLWINBOX.SALESQUOTATIONAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Order type in order header
  • Client
  • Sales Document Type
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == TVAK.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.SALESQUOTATIONTYPE == TVAK.AUART
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == TVAU.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.SDDOCUMENTREASON == TVAU.AUGRU
Customer - Document Customer
  • Client
  • Sold-to Party
  • Customer Number
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == KNA1.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESQUOTATIONWRKFLWINBOX.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Customer Number
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == KNA1.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESQUOTATIONWRKFLWINBOX.SHIPTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_SALESQUOTATIONWRKFLWINBOX.MANDT == TCURC.MANDT
  • C_SALESQUOTATIONWRKFLWINBOX.TRANSACTIONCURRENCY == TCURC.WAERS