C_SalesOrderWrkflwInbox

Sales Order Workflow Inbox | view: CSOWFIN | 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, TVBST
Column Name Description
SalesOrder Sales Order
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
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
TotalCreditCheckStatusDesc Status Description TEXT20
TotalCreditCheckStatus Overall Status of Credit Checks
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_SALESORDERWRKFLWINBOX.MANDT == T005.MANDT
  • C_SALESORDERWRKFLWINBOX.COUNTRY == T005.LAND1
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_SALESORDERWRKFLWINBOX.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESORDERWRKFLWINBOX.MANDT == TVKOV.MANDT
  • C_SALESORDERWRKFLWINBOX.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • Division
  • C_SALESORDERWRKFLWINBOX.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SALESORDERWRKFLWINBOX.MANDT == TVTA.MANDT
  • C_SALESORDERWRKFLWINBOX.SALESORGANIZATION == TVTA.VKORG
  • C_SALESORDERWRKFLWINBOX.ORGANIZATIONDIVISION == TVTA.SPART
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • C_SALESORDERWRKFLWINBOX.SALESORDERAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • C_SALESORDERWRKFLWINBOX.MANDT == SDAPMAPRR.CLIENT
Order type in order header
  • Sales Order Type
  • Client
  • C_SALESORDERWRKFLWINBOX.SALESORDERTYPE == TVAK.AUART
  • C_SALESORDERWRKFLWINBOX.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESORDERWRKFLWINBOX.MANDT == TVKO.MANDT
  • C_SALESORDERWRKFLWINBOX.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_SALESORDERWRKFLWINBOX.MANDT == TVAU.MANDT
  • C_SALESORDERWRKFLWINBOX.SDDOCUMENTREASON == TVAU.AUGRU
Customer - Document Customer
  • Client
  • Customer Number
  • Sold-to Party
  • C_SALESORDERWRKFLWINBOX.MANDT == KNA1.MANDT
  • C_SALESORDERWRKFLWINBOX.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERWRKFLWINBOX.SOLDTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Customer Number
  • Sold-to Party
  • C_SALESORDERWRKFLWINBOX.MANDT == KNA1.MANDT
  • C_SALESORDERWRKFLWINBOX.SHIPTOPARTY == KNA1.KUNNR
  • C_SALESORDERWRKFLWINBOX.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_SALESORDERWRKFLWINBOX.MANDT == TCURC.MANDT
  • C_SALESORDERWRKFLWINBOX.TRANSACTIONCURRENCY == TCURC.WAERS