C_ESJIQuotationQuery

Quotation | view: CESJIQUOTATION | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: VBKD, VEDA, VBAK, VBEP, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, TVZB, TVZBT, CVI_CUST_LINK, TVTW, TVTWT, TSPA, TSPAT, TINC, TINCT, TVAK, TVAKT, TVKO, TVKOT, CVI_VEND_LINK, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST
Column Name Description
SalesQuotation Sales Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
NetAmountInDisplayCurrency Net Value in Display Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesQuotationDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
PricingDate Date for Pricing and Exchange Rate
RequestedDeliveryDate Requested Delivery Date
DeliveryCreationDate null
ValidityStartDate Quotation/Inquiry is Valid From
ValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
Column Name Description
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
Column Name Description Domain name
ObjectType null
SalesQuotationTypeName Sales Document Type Description TEXT20
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
SoldToPartyName Name of Customer TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
CustomerPaymentTerms Terms of payment key ZTERM
CustomerPaymentTermsName Description of terms of payment TEXT30
ShipToPartyName Name of Customer TEXT80
ResponsibleEmployee Employee Responsible PERNR
ResponsibleEmployeeName Full Name TEXT80
SalesEmployee Sales Employee PERNR
SalesEmployeeName Full Name TEXT80
OverallSDProcessStatusDesc Status Description TEXT20
OvrlSDDocumentRejectionStsDesc Status Description TEXT20
TotalBlockStatusDesc Status Description TEXT20
OverallTotalDeliveryStatusDesc Status Description TEXT20
OverallDeliveryStatusDesc Status Description TEXT20
OverallDelivBlockStatusDesc Status Description TEXT20
OverallBillingBlockStatusDesc Status Description TEXT20
TotalCreditCheckStatusDesc Status Description TEXT20
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • C_ESJIQUOTATIONQUERY.MANDT == TGSB.MANDT
  • C_ESJIQUOTATIONQUERY.BUSINESSAREA == TGSB.GSBER
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_ESJIQUOTATIONQUERY.MANDT == TVLS.MANDT
  • C_ESJIQUOTATIONQUERY.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_ESJIQUOTATIONQUERY.MANDT == TVKOV.MANDT
  • C_ESJIQUOTATIONQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_ESJIQUOTATIONQUERY.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • C_ESJIQUOTATIONQUERY.MANDT == TVFS.MANDT
  • C_ESJIQUOTATIONQUERY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_ESJIQUOTATIONQUERY.MANDT == TINC.MANDT
  • C_ESJIQUOTATIONQUERY.INCOTERMSCLASSIFICATION == TINC.INCO1
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • C_ESJIQUOTATIONQUERY.MANDT == TVTA.MANDT
  • C_ESJIQUOTATIONQUERY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_ESJIQUOTATIONQUERY.ORGANIZATIONDIVISION == TVTA.SPART
  • C_ESJIQUOTATIONQUERY.SALESORGANIZATION == TVTA.VKORG
Sales group
  • Client
  • Sales group
  • Sales office
  • C_ESJIQUOTATIONQUERY.MANDT == TVBVK.MANDT
  • C_ESJIQUOTATIONQUERY.SALESGROUP == TVBVK.VKGRP
  • C_ESJIQUOTATIONQUERY.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • C_ESJIQUOTATIONQUERY.MANDT == TVKO.MANDT
  • C_ESJIQUOTATIONQUERY.SALESORGANIZATION == TVKO.VKORG
Order type in order header
  • Client
  • Sales Document Type
  • C_ESJIQUOTATIONQUERY.MANDT == TVAK.MANDT
  • C_ESJIQUOTATIONQUERY.SALESQUOTATIONTYPE == TVAK.AUART
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_ESJIQUOTATIONQUERY.MANDT == TVAU.MANDT
  • C_ESJIQUOTATIONQUERY.SDDOCUMENTREASON == TVAU.AUGRU
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_ESJIQUOTATIONQUERY.MANDT == TVSB.MANDT
  • C_ESJIQUOTATIONQUERY.SHIPPINGCONDITION == TVSB.VSBED
Shipping Type
  • Client
  • Shipping Type
  • C_ESJIQUOTATIONQUERY.MANDT == T173.MANDT
  • C_ESJIQUOTATIONQUERY.SHIPPINGTYPE == T173.VSART
Customer - Document Customer
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_ESJIQUOTATIONQUERY.MANDT == KNA1.MANDT
  • C_ESJIQUOTATIONQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_ESJIQUOTATIONQUERY.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_ESJIQUOTATIONQUERY.MANDT == KNA1.MANDT
  • C_ESJIQUOTATIONQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_ESJIQUOTATIONQUERY.SHIPTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_ESJIQUOTATIONQUERY.MANDT == TCURC.MANDT
  • C_ESJIQUOTATIONQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • Sales office
  • C_ESJIQUOTATIONQUERY.MANDT == TVKBZ.MANDT
  • C_ESJIQUOTATIONQUERY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_ESJIQUOTATIONQUERY.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_ESJIQUOTATIONQUERY.SALESORGANIZATION == TVKBZ.VKORG
  • C_ESJIQUOTATIONQUERY.SALESOFFICE == TVKBZ.VKBUR