C_Salesorderitemfs

Sales Order Item | view: CSALESORDERITFS | TRAN | Extraction: Not supported | Component: Sales Orders

Tables used: VBAP, VBKD, VEDA, VBAK, VBEP, SIT_INST, SIT_INST_QUEUE, VBPA, ADR6, ADR3, ADRP, ADR2, ADCP, ADRC, CVI_CUST_CT_LINK, BUT0ID, BUT000, KNVK, CVI_CUST_LINK, MAKT, TVSTT, SIT_DEF, SIT_T_DEF, CVI_VEND_LINK, MOM052

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (6)
Other (15)
🔗 Relations (11)

Column Name	Description
SalesOrder FK	Sales Order
SalesOrderItem	Sales Order Item

Column Name	Description
💲 SD Document Currency (TransactionCurrency):
NetAmount	Net Value of the Order Item in Document Currency

Column Name	Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity	Requested Quantity

Column Name	Description
RequestedDeliveryDate	Requested Delivery Date
BOMExplosionDate	Key date of the bill of material

Column Name	Description
SDProcessStatus	Overall Processing Status (Item)	Show values
DeliveryStatus	Delivery Status (Item)	Show values
SDDocumentRejectionStatus	Rejection Status (Item)	Show values
SlsOrderItemDownPaymentStatus	Down Payment Status	Show values
OrderRelatedBillingStatus	Order-Related Billing Status (Item)	Show values
SalesOrderProcessingType	SD document indicator	Show values

Column Name	Description	Domain name
SalesOrderItemUUID	GUID in 'CHAR' Format in Uppercase	SYSUUID_C
SalesOrderItemText	Short text for sales order item	TEXT40
CustomerName	Full Name of Person	TEXT80
MaterialByCustomer	Material Number Used by Customer	IDNEX
MaterialName	Material Description	TEXT40
ShipToParty	Ship-to Party	KUNNR
FullName	null
ProductionPlant	Plant (Own or External)	WERKS
ShippingPointName	Description	TEXT30
BillingBlockCriticality	null
OmniChannelSalesPromotion	ID of Omnichannel Sales Promotion	CHAR20
HigherLevelItem	Higher-Level Item in Bill of Material Structures	POSNR
SitnNumberOfInstances	Number of Situations	INT4
OrderItemHasConfiguration	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
RequirementSegment	Requirement Segment	SGT_SRCA

Master Data Relations	Join Conditions
Batch Number Plant (Own or External) Batch Number Product Number Client	`C_SALESORDERITEMFS.PRODUCTIONPLANT == MCHA.WERKS` `C_SALESORDERITEMFS.BATCH == MCHA.CHARG` `C_SALESORDERITEMFS.MATERIAL == MCHA.MATNR` `C_SALESORDERITEMFS.MANDT == MCHA.MANDT`
Billing Block for Item Billing Block for Item Client	`C_SALESORDERITEMFS.ITEMBILLINGBLOCKREASON == TVFS.FAKSP` `C_SALESORDERITEMFS.MANDT == TVFS.MANDT`
Material: order item Product Number Client	`C_SALESORDERITEMFS.MATERIAL == MARA.MATNR` `C_SALESORDERITEMFS.MANDT == MARA.MANDT`
Product Group Client Product Group	`C_SALESORDERITEMFS.MANDT == T023.MANDT` `C_SALESORDERITEMFS.MATERIALGROUP == T023.MATKL`
Reason for Rejection of Sales Documents Reason for Rejection of Sales Documents Client	`C_SALESORDERITEMFS.SALESDOCUMENTRJCNREASON == TVAG.ABGRU` `C_SALESORDERITEMFS.MANDT == TVAG.MANDT`
Sales document item category Sales document item category Client	`C_SALESORDERITEMFS.SALESORDERITEMCATEGORY == TVPT.PSTYV` `C_SALESORDERITEMFS.MANDT == TVPT.MANDT`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`C_SALESORDERITEMFS.MANDT == TVST.MANDT` `C_SALESORDERITEMFS.SHIPPINGPOINT == TVST.VSTEL`
Sold-to Party Sold-to Party Client	`C_SALESORDERITEMFS.SOLDTOPARTY == KNA1.KUNNR` `C_SALESORDERITEMFS.MANDT == KNA1.MANDT`
Storage location Plant (Own or External) Client Storage location	`C_SALESORDERITEMFS.PRODUCTIONPLANT == T001L.WERKS` `C_SALESORDERITEMFS.MANDT == T001L.MANDT` `C_SALESORDERITEMFS.STORAGELOCATION == T001L.LGORT`
SD Document Currency SD Document Currency Client	`C_SALESORDERITEMFS.TRANSACTIONCURRENCY == TCURC.WAERS` `C_SALESORDERITEMFS.MANDT == TCURC.MANDT`