C_Salesorderfs

Sales Order | view: CSALESORDERFS | TRAN | Extraction: Not supported | Component: Sales Orders

Tables used: VBKD, VEDA, VBAK, VBPA, VBPA, ADR6, ADR3, ADRP, ADR2, ADCP, ADRC, CVI_CUST_CT_LINK, BUT0ID, BUT000, ADRP, KNVK, CVI_CUST_LINK, TVTW, TVTWT, TSPA, TSPAT, TVAK, TVAKT, TVKO, TVKOT, CVI_VEND_LINK, ADCP, ADR2, ADR3, ADR6, BUT000, MOM052

🔑 Keys (1)
💰 Amounts (1)
∑ Quantities
📅 Dates (3)
☰ Categorical (7)
Other (10)
🔗 Relations (10)

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
CustomerPurchaseOrderDate	Customer Reference Date
SalesOrderDate	Document Date (Date Received/Sent)
AlternativePricingDate	Cross-Item Pricing Date

Column Name	Description
OverallSDProcessStatus	Overall Processing Status (Header/All Items)	Show values
TotalCreditCheckStatus	Overall Status of Credit Checks	Show values
OverallTotalDeliveryStatus	Overall Delivery Status (All Items)	Show values
OverallSDDocumentRejectionSts	Rejection Status (All Items)	Show values
SalesOrderDownPaymentStatus	Down Payment Status	Show values
SalesDocApprovalStatus	Document Approval Status	Show values
OmniChnlSalesPromotionStatus	Omnichannel Sales Promotion Status (Header)	Show values

Column Name	Description	Domain name
SalesDocumentTypeName	null
CustomerName	Full Name of Person	TEXT80
SlsOrdApprovalStsCriticality	null
SalesAreaDesc	Sales Area	TXT_VTRBER
EmployeeName	null
ResponsibleEmployeeName	null
PurchaseOrder	Customer Reference	BSTKD
BusinessSolutionOrder	Solution Order	CRM_OBJECT_ID
BillingBlockCriticality	null
DeliveryBlockCriticality	null

Master Data Relations	Join Conditions
Customer Purchase Order Type Customer Purchase Order Type Client	`C_SALESORDERFS.CUSTOMERPURCHASEORDERTYPE == T176.BSARK` `C_SALESORDERFS.MANDT == T176.MANDT`
Delivery Block (Document Header) Delivery Block (Document Header) Client	`C_SALESORDERFS.DELIVERYBLOCKREASON == TVLS.LIFSP` `C_SALESORDERFS.MANDT == TVLS.MANDT`
Distribution channel in order header Sales Organization Distribution Channel Client	`C_SALESORDERFS.SALESORGANIZATION == TVKOV.VKORG` `C_SALESORDERFS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `C_SALESORDERFS.MANDT == TVKOV.MANDT`
Billing Block in SD Document Billing Block in SD Document Client	`C_SALESORDERFS.HEADERBILLINGBLOCKREASON == TVFS.FAKSP` `C_SALESORDERFS.MANDT == TVFS.MANDT`
Division in order header Division Sales Organization Distribution Channel Client	`C_SALESORDERFS.ORGANIZATIONDIVISION == TVTA.SPART` `C_SALESORDERFS.SALESORGANIZATION == TVTA.VKORG` `C_SALESORDERFS.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_SALESORDERFS.MANDT == TVTA.MANDT`
Approval Request Reason ID Approval Request Reason ID Client	`C_SALESORDERFS.SALESORDERAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON` `C_SALESORDERFS.MANDT == SDAPMAPRR.CLIENT`
Order type in order header Sales Order Type Client	`C_SALESORDERFS.SALESORDERTYPE == TVAK.AUART` `C_SALESORDERFS.MANDT == TVAK.MANDT`
Sales organization in order header Sales Organization Client	`C_SALESORDERFS.SALESORGANIZATION == TVKO.VKORG` `C_SALESORDERFS.MANDT == TVKO.MANDT`
Sold-to Party Sold-to Party Client	`C_SALESORDERFS.SOLDTOPARTY == KNA1.KUNNR` `C_SALESORDERFS.MANDT == KNA1.MANDT`
Currency in order header SD Document Currency Client	`C_SALESORDERFS.TRANSACTIONCURRENCY == TCURC.WAERS` `C_SALESORDERFS.MANDT == TCURC.MANDT`