C_SalesOrderItemProcessQ

SOFM Sales Order Item Process Query | view: CSLSORDITEMPROCQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAPVBRKVBRPLIKPLIPSVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBAPVBEP
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ShippedQuantityInOrderQtyUnit Shipped Quantity in Sales Unit
InvoicedQuantityInOrderQtyUnit Invoiced Quantity in Sales Unit
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
Column Name Description
RequestedDeliveryDate Requested Delivery Date
NextPlannedProdAvailDate Delivery Creation Date
BillingDocumentDate Billing Date
Column Name Description
SDDocumentRejectionStatus Rejection Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
Column Name Description Domain name
SalesOrderType Sales Document Type AUART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SalesOrderItemText Short text for sales order item TEXT40
ShippingStatus Sales order status of shipping fulfillment SHIPPING_STS
InvoicingStatus Sales order status of invoicing process INVOIC_STS
Master Data Relations Join Conditions
Material: order item
  • Material Number
  • Client
  • C_SALESORDERITEMPROCESSQ.MATERIAL == MARA.MATNR
  • C_SALESORDERITEMPROCESSQ.MANDT == MARA.MANDT
Sales unit
  • Sales unit
  • Client
  • C_SALESORDERITEMPROCESSQ.ORDERQUANTITYUNIT == T006.MSEHI
  • C_SALESORDERITEMPROCESSQ.MANDT == T006.MANDT
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • C_SALESORDERITEMPROCESSQ.TARGETQUANTITYUNIT == T006.MSEHI
  • C_SALESORDERITEMPROCESSQ.MANDT == T006.MANDT