C_ESJISalesOrderItemQuery

Sales Order Item | view: CESJISLSODRITMQ | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, TVAG, TVAGT, TVBST, TVBST
Column Name Description
SalesOrder FK Sales Document
SalesOrderItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
TaxAmount Tax Amount in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
PricingDate Date for Pricing and Exchange Rate
BillingDocumentDate Billing Date
RequestedDeliveryDate null
Column Name Description
PartialDeliveryIsAllowed Partial Delivery at Item Level Show values
ItemIsBillingRelevant Relevant for Billing Show values
DeliveryStatus Delivery Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
Column Name Description Domain name
ObjectType null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
ProductionPlant Plant (Own or External) WERKS
SalesOrderItemText Short text for sales order item TEXT40
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
NetPriceQuantity Condition Pricing Unit KPEIN
IncotermsTransferLocation Incoterms (Part 2) INCO2
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
CustomerPaymentTerms Terms of payment key ZTERM
SalesDocumentRjcnReasonName Description TEXT40
DeliveryStatusDescription Status Description TEXT20
SDDocumentRejectionStatusDesc Status Description TEXT20
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_ESJISALESORDERITEMQUERY.BASEUNIT == T006.MSEHI
  • C_ESJISALESORDERITEMQUERY.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • C_ESJISALESORDERITEMQUERY.BUSINESSAREA == TGSB.GSBER
  • C_ESJISALESORDERITEMQUERY.MANDT == TGSB.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_ESJISALESORDERITEMQUERY.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_ESJISALESORDERITEMQUERY.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_ESJISALESORDERITEMQUERY.SALESORGANIZATION == TVKOV.VKORG
  • C_ESJISALESORDERITEMQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_ESJISALESORDERITEMQUERY.MANDT == TVKOV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_ESJISALESORDERITEMQUERY.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_ESJISALESORDERITEMQUERY.MANDT == TINC.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_ESJISALESORDERITEMQUERY.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_ESJISALESORDERITEMQUERY.MANDT == TVFS.MANDT
Material: order item
  • Material Number
  • Client
  • C_ESJISALESORDERITEMQUERY.MATERIAL == MARA.MATNR
  • C_ESJISALESORDERITEMQUERY.MANDT == MARA.MANDT
Condition Unit
  • Condition Unit
  • Client
  • C_ESJISALESORDERITEMQUERY.NETPRICEQUANTITYUNIT == T006.MSEHI
  • C_ESJISALESORDERITEMQUERY.MANDT == T006.MANDT
Sales unit
  • Sales unit
  • Client
  • C_ESJISALESORDERITEMQUERY.ORDERQUANTITYUNIT == T006.MSEHI
  • C_ESJISALESORDERITEMQUERY.MANDT == T006.MANDT
Division in order header
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • C_ESJISALESORDERITEMQUERY.ORGANIZATIONDIVISION == TVTA.SPART
  • C_ESJISALESORDERITEMQUERY.SALESORGANIZATION == TVTA.VKORG
  • C_ESJISALESORDERITEMQUERY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_ESJISALESORDERITEMQUERY.MANDT == TVTA.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_ESJISALESORDERITEMQUERY.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_ESJISALESORDERITEMQUERY.MANDT == TVAG.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_ESJISALESORDERITEMQUERY.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • C_ESJISALESORDERITEMQUERY.MANDT == TVPT.MANDT
Order type in order header
  • Sales Order Type
  • Client
  • C_ESJISALESORDERITEMQUERY.SALESORDERTYPE == TVAK.AUART
  • C_ESJISALESORDERITEMQUERY.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_ESJISALESORDERITEMQUERY.SALESORGANIZATION == TVKO.VKORG
  • C_ESJISALESORDERITEMQUERY.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_ESJISALESORDERITEMQUERY.SHIPPINGPOINT == TVST.VSTEL
  • C_ESJISALESORDERITEMQUERY.MANDT == TVST.MANDT
Shipping Type
  • Client
  • Shipping Type
  • C_ESJISALESORDERITEMQUERY.MANDT == T173.MANDT
  • C_ESJISALESORDERITEMQUERY.SHIPPINGTYPE == T173.VSART
SD Document Currency
  • SD Document Currency
  • Client
  • C_ESJISALESORDERITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_ESJISALESORDERITEMQUERY.MANDT == TCURC.MANDT