C_SalesOrderWl_F1873

Sales Orders | view: CSORDWLF1873 | TRAN | Extraction: Not supported | Component: Sales Orders

Tables used: VBKD, VEDA, VBAK, VBPA, VBPA, ADCP, ADRC, ADR6, ADR6, ADR3, ADRP, ADR2, ADR2, ADCP, ADRC, CVI_CUST_CT_LINK, BUT0ID, BUT000, ADRP, KNVK, KNA1, CVI_CUST_LINK, CVI_VEND_LINK, ADCP, ADR2, ADR3, ADR6, BUT000, MOM052

🔑 Keys (1)
💰 Amounts (1)
∑ Quantities
📅 Dates (4)
☰ Categorical (10)
Other (15)
🔗 Relations (14)

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
RequestedDeliveryDate	Requested Delivery Date
SalesOrderDate	Document Date (Date Received/Sent)
CreationDate	Date on which the record was created
LastChangeDate	Last Changed On

Column Name	Description
OverallSDProcessStatus	Overall Processing Status (Header/All Items)	Show values
OverallSDDocumentRejectionSts	Rejection Status (All Items)	Show values
SalesDocApprovalStatus	Document Approval Status	Show values
OverallChmlCmplncStatus	Product Marketability Status (All Items)	Show values
OverallDangerousGoodsStatus	Dangerous Goods Status (All Items)	Show values
OverallSafetyDataSheetStatus	Safety Data Sheet Status (All Items)	Show values
OverallTrdCmplncEmbargoSts	Embargo Status (All Items)	Show values
OvrlTrdCmplncSnctndListChkSts	Screening Status (All Items)	Show values
OvrlTrdCmplncLegalCtrlChkSts	Legal Control Status (All Items)	Show values
OmniChnlSalesPromotionStatus	Omnichannel Sales Promotion Status (Header)	Show values

Column Name	Description	Domain name
CustomerName	Full Name of Person	TEXT80
SalesEmployee	Sales Employee	PERNR
ResponsibleEmployee	Employee Responsible	PERNR
PurchaseOrderByCustomer	Customer Reference	BSTKD
SalesOrderDownPaymentStatus	Down Payment Status
OverallBillingBlockStatus	Billing Block Status (All Items)
BusinessSolutionOrder	Solution Order	CRM_OBJECT_ID
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
ReferenceSDDocument	Document number of the reference document	VBELN
SalesDocumentRjcnReason	Reason for Rejection of Sales Documents	ABGRU_VA
SlsOrdApprovalStsCriticality	null
OrganizationBPName1	Name 1	NAME
OrganizationBPName2	Name 2	NAME

Master Data Relations	Join Conditions
Customer - Document Customer Bill-to Party Sold-to Party Payer Ship-to Party Client	`C_SALESORDERWL_F1873.BILLTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.SOLDTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.PAYERPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.SHIPTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.MANDT == KNA1.MANDT`
Delivery Block (Document Header) Client Delivery Block (Document Header)	`C_SALESORDERWL_F1873.MANDT == TVLS.MANDT` `C_SALESORDERWL_F1873.DELIVERYBLOCKREASON == TVLS.LIFSP`
Distribution channel in order header Client Sales Organization Distribution Channel	`C_SALESORDERWL_F1873.MANDT == TVKOV.MANDT` `C_SALESORDERWL_F1873.SALESORGANIZATION == TVKOV.VKORG` `C_SALESORDERWL_F1873.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Billing Block in SD Document Billing Block in SD Document Client	`C_SALESORDERWL_F1873.HEADERBILLINGBLOCKREASON == TVFS.FAKSP` `C_SALESORDERWL_F1873.MANDT == TVFS.MANDT`
Division in order header Client Sales Organization Distribution Channel Division	`C_SALESORDERWL_F1873.MANDT == TVTA.MANDT` `C_SALESORDERWL_F1873.SALESORGANIZATION == TVTA.VKORG` `C_SALESORDERWL_F1873.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_SALESORDERWL_F1873.ORGANIZATIONDIVISION == TVTA.SPART`
Customer - Document Customer Bill-to Party Sold-to Party Payer Ship-to Party Client	`C_SALESORDERWL_F1873.BILLTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.SOLDTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.PAYERPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.SHIPTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.MANDT == KNA1.MANDT`
Sales group Client Sales office Sales group	`C_SALESORDERWL_F1873.MANDT == TVBVK.MANDT` `C_SALESORDERWL_F1873.SALESOFFICE == TVBVK.VKBUR` `C_SALESORDERWL_F1873.SALESGROUP == TVBVK.VKGRP`
Order type in order header Sales Order Type Client	`C_SALESORDERWL_F1873.SALESORDERTYPE == TVAK.AUART` `C_SALESORDERWL_F1873.MANDT == TVAK.MANDT`
Sales organization in order header Client Sales Organization	`C_SALESORDERWL_F1873.MANDT == TVKO.MANDT` `C_SALESORDERWL_F1873.SALESORGANIZATION == TVKO.VKORG`
Order Reason (Reason for the Business Transaction) Client Order Reason (Reason for the Business Transaction)	`C_SALESORDERWL_F1873.MANDT == TVAU.MANDT` `C_SALESORDERWL_F1873.SDDOCUMENTREASON == TVAU.AUGRU`
Customer - Document Customer Bill-to Party Sold-to Party Payer Ship-to Party Client	`C_SALESORDERWL_F1873.BILLTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.SOLDTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.PAYERPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.SHIPTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.MANDT == KNA1.MANDT`
Sold-to Party Bill-to Party Sold-to Party Payer Ship-to Party Client	`C_SALESORDERWL_F1873.BILLTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.SOLDTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.PAYERPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.SHIPTOPARTY == KNA1.KUNNR` `C_SALESORDERWL_F1873.MANDT == KNA1.MANDT`
Currency in order header Client SD Document Currency	`C_SALESORDERWL_F1873.MANDT == TCURC.MANDT` `C_SALESORDERWL_F1873.TRANSACTIONCURRENCY == TCURC.WAERS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Client Sales Organization Sales office Distribution Channel Division	`C_SALESORDERWL_F1873.MANDT == TVKBZ.MANDT` `C_SALESORDERWL_F1873.SALESORGANIZATION == TVKBZ.VKORG` `C_SALESORDERWL_F1873.SALESOFFICE == TVKBZ.VKBUR` `C_SALESORDERWL_F1873.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG` `C_SALESORDERWL_F1873.ORGANIZATIONDIVISION == TVKBZ.SPART`