C_Salesorderitemfs

Sales Order Item | view: CSALESORDERITFS | TRAN | Extraction: Not supported | Component: Sales Orders
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