C_ESJIQuotationItemQuery

Quotation Item | view: CESJIQUOTITEMQ | 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
SalesQuotation FK Sales Document
SalesQuotationItem 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
SalesQuotationItemText 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
SalesDocumentRjcnReasonName Description TEXT40
NetPriceQuantity Condition Pricing Unit KPEIN
IncotermsTransferLocation Incoterms (Part 2) INCO2
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
CustomerPaymentTerms Terms of payment key ZTERM
DeliveryStatusDescription Status Description TEXT20
SDDocumentRejectionStatusDesc Status Description TEXT20
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_ESJIQUOTATIONITEMQUERY.MANDT == T006.MANDT
  • C_ESJIQUOTATIONITEMQUERY.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TGSB.MANDT
  • C_ESJIQUOTATIONITEMQUERY.BUSINESSAREA == TGSB.GSBER
Delivery Priority
  • Delivery Priority
  • Client
  • C_ESJIQUOTATIONITEMQUERY.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TPRIO.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TINC.MANDT
  • C_ESJIQUOTATIONITEMQUERY.INCOTERMSCLASSIFICATION == TINC.INCO1
Billing Block for Item
  • Billing Block for Item
  • Client
  • C_ESJIQUOTATIONITEMQUERY.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TVFS.MANDT
Material: order item
  • Client
  • Material Number
  • C_ESJIQUOTATIONITEMQUERY.MANDT == MARA.MANDT
  • C_ESJIQUOTATIONITEMQUERY.MATERIAL == MARA.MATNR
Condition Unit
  • Condition Unit
  • Client
  • C_ESJIQUOTATIONITEMQUERY.NETPRICEQUANTITYUNIT == T006.MSEHI
  • C_ESJIQUOTATIONITEMQUERY.MANDT == T006.MANDT
Sales unit
  • Client
  • Sales unit
  • C_ESJIQUOTATIONITEMQUERY.MANDT == T006.MANDT
  • C_ESJIQUOTATIONITEMQUERY.ORDERQUANTITYUNIT == T006.MSEHI
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TVAG.MANDT
  • C_ESJIQUOTATIONITEMQUERY.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales document item category
  • Client
  • Sales document item category
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TVPT.MANDT
  • C_ESJIQUOTATIONITEMQUERY.SALESQUOTATIONITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Client
  • Sales Document Type
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TVAK.MANDT
  • C_ESJIQUOTATIONITEMQUERY.SALESQUOTATIONTYPE == TVAK.AUART
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TVST.MANDT
  • C_ESJIQUOTATIONITEMQUERY.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • C_ESJIQUOTATIONITEMQUERY.MANDT == T173.MANDT
  • C_ESJIQUOTATIONITEMQUERY.SHIPPINGTYPE == T173.VSART
SD Document Currency
  • Client
  • SD Document Currency
  • C_ESJIQUOTATIONITEMQUERY.MANDT == TCURC.MANDT
  • C_ESJIQUOTATIONITEMQUERY.TRANSACTIONCURRENCY == TCURC.WAERS