C_SlsDocFlfmtSlsDocItem

Sales Doc Fulfillment: Sales Doc Item | view: CSOFSLSDOCITEM | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, VBAK, VBAP, VBKD, VEDA, VBEP, VBPA, VBPA, MARA, ADCP, ADRC, CVI_CUST_CT_LINK, BUT000, T005, T005T, KNA1, KNMT, CVI_CUST_LINK, MAKT, T001W, MARA, MVKE, TVST, TVSTT, CVI_VEND_LINK
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document 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
📏 Sales unit (OrderQuantityUnit):
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
DeliveredQtyInOrderQtyUnit Delivered Quantity
CommittedDelivQtyInOrdQtyUnit Committed Delivery Quantity in Order Quantity Unit
Column Name Description
CommittedDelivCreationDate Deliv. Creation Date in Order to Meet Committed Deliv. Date
CommittedDeliveryDate Delivery Date that the Supplier has Committed to
RequestedDeliveryDate Requested Delivery Date
Column Name Description
DeliveryStatus Delivery Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
PurchaseConfirmationStatus Purchasing Confirmation Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
ChmlCmplncStatus Product Marketability Status (Item) Show values
DangerousGoodsStatus Dangerous Goods Status (Item) Show values
SafetyDataSheetStatus Safety Data Sheet Status (Item) Show values
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status (All Schedule Lines) Show values
Column Name Description Domain name
MaterialName Material Description TEXT40
Plant Plant (Own or External) WERKS
MaterialByCustomer Material Number Used by Customer IDNEX
SalesDocumentItemText Short text for sales order item TEXT40
CustomerPaymentTerms Terms of payment key ZTERM
ShippingPointName Description TEXT30
ShippingPointCountry Shipping Point Country or Region LAND1
ShippingPointCountryName Shipping Point Country or Region TEXT50
ShipFromPartyCountryName Ship-to Party Country or Region TEXT50
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
ShipToPartyCountry Ship-to Party Country or Region LAND1
ShipToPartyCountryName Ship-to Party Country or Region TEXT50
Master Data Relations Join Conditions
Batch Number
  • Product Number
  • Plant (Own or External)
  • Client
  • Batch Number
  • C_SLSDOCFLFMTSLSDOCITEM.MATERIAL == MCHA.MATNR
  • C_SLSDOCFLFMTSLSDOCITEM.PLANT == MCHA.WERKS
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == MCHA.MANDT
  • C_SLSDOCFLFMTSLSDOCITEM.BATCH == MCHA.CHARG
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_SLSDOCFLFMTSLSDOCITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == TVFS.MANDT
Material: order item
  • Product Number
  • Client
  • C_SLSDOCFLFMTSLSDOCITEM.MATERIAL == MARA.MATNR
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == T023.MANDT
  • C_SLSDOCFLFMTSLSDOCITEM.MATERIALGROUP == T023.MATKL
Sales unit
  • Client
  • Sales unit
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == T006.MANDT
  • C_SLSDOCFLFMTSLSDOCITEM.ORDERQUANTITYUNIT == T006.MSEHI
Route
  • Client
  • Route
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == TVRO.MANDT
  • C_SLSDOCFLFMTSLSDOCITEM.ROUTE == TVRO.ROUTE
Sales document item category
  • Sales document item category
  • Client
  • C_SLSDOCFLFMTSLSDOCITEM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_SLSDOCFLFMTSLSDOCITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == TVAG.MANDT
Country key
  • Client
  • Ship-from Party Country or Region
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == T005.MANDT
  • C_SLSDOCFLFMTSLSDOCITEM.SHIPFROMPARTYCOUNTRY == T005.LAND1
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SLSDOCFLFMTSLSDOCITEM.SHIPPINGPOINT == TVST.VSTEL
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == TVST.MANDT
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • C_SLSDOCFLFMTSLSDOCITEM.PLANT == T001L.WERKS
  • C_SLSDOCFLFMTSLSDOCITEM.STORAGELOCATION == T001L.LGORT
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == T001L.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_SLSDOCFLFMTSLSDOCITEM.MANDT == TCURC.MANDT
  • C_SLSDOCFLFMTSLSDOCITEM.TRANSACTIONCURRENCY == TCURC.WAERS