C_ESJISalesOrderQuery

Incoming Sales Orders | view: CESJISLSORDERQ | Extraction: Not supported | Component: Integration of SAP SD with SAP Jam
Tables used: VBKD, VEDA, VBAK, VBEP, VBPA, VBPA, TVFS, TVFST, CVI_CUST_CT_LINK, BUT000, KNA1, TVZB, TVZBT, CVI_CUST_LINK, TVLS, TVLST, TVTW, TVTWT, TSPA, TSPAT, TINC, TINCT, TVAK, TVAKT, TVKO, TVKOT, CVI_VEND_LINK, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST, TVBST
Column Name Description
SalesOrder Sales Order
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
SalesOrderDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
PricingDate Date for Pricing and Exchange Rate
RequestedDeliveryDate Requested Delivery Date
DeliveryCreationDate null
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
SalesOrderTypeName 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
ShipToPartyName Name of Customer TEXT80
ResponsibleEmployee Employee Responsible PERNR
ResponsibleEmployeeName Full Name TEXT80
SalesEmployee Sales Employee PERNR
SalesEmployeeName Full Name TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
DeliveryBlockReasonText Description TEXT20
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
BillingBlockReasonDescription Billing Block Description TEXT20
CustomerPaymentTerms Terms of payment key ZTERM
CustomerPaymentTermsName Description of terms of payment TEXT30
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_ESJISALESORDERQUERY.MANDT == TGSB.MANDT
  • C_ESJISALESORDERQUERY.BUSINESSAREA == TGSB.GSBER
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_ESJISALESORDERQUERY.MANDT == TVLS.MANDT
  • C_ESJISALESORDERQUERY.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_ESJISALESORDERQUERY.MANDT == TVKOV.MANDT
  • C_ESJISALESORDERQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_ESJISALESORDERQUERY.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • Division
  • C_ESJISALESORDERQUERY.MANDT == TVTA.MANDT
  • C_ESJISALESORDERQUERY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_ESJISALESORDERQUERY.SALESORGANIZATION == TVTA.VKORG
  • C_ESJISALESORDERQUERY.DIVISION == TVTA.SPART
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_ESJISALESORDERQUERY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_ESJISALESORDERQUERY.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_ESJISALESORDERQUERY.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_ESJISALESORDERQUERY.MANDT == TINC.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • C_ESJISALESORDERQUERY.MANDT == TVBVK.MANDT
  • C_ESJISALESORDERQUERY.SALESOFFICE == TVBVK.VKBUR
  • C_ESJISALESORDERQUERY.SALESGROUP == TVBVK.VKGRP
Order type in order header
  • Client
  • Sales Order Type
  • C_ESJISALESORDERQUERY.MANDT == TVAK.MANDT
  • C_ESJISALESORDERQUERY.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • C_ESJISALESORDERQUERY.MANDT == TVKO.MANDT
  • C_ESJISALESORDERQUERY.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_ESJISALESORDERQUERY.SDDOCUMENTREASON == TVAU.AUGRU
  • C_ESJISALESORDERQUERY.MANDT == TVAU.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_ESJISALESORDERQUERY.MANDT == TVSB.MANDT
  • C_ESJISALESORDERQUERY.SHIPPINGCONDITION == TVSB.VSBED
Customer - Document Customer
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_ESJISALESORDERQUERY.MANDT == KNA1.MANDT
  • C_ESJISALESORDERQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_ESJISALESORDERQUERY.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_ESJISALESORDERQUERY.MANDT == KNA1.MANDT
  • C_ESJISALESORDERQUERY.SOLDTOPARTY == KNA1.KUNNR
  • C_ESJISALESORDERQUERY.SHIPTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_ESJISALESORDERQUERY.MANDT == TCURC.MANDT
  • C_ESJISALESORDERQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Sales office
  • Sales Organization
  • Division
  • C_ESJISALESORDERQUERY.MANDT == TVKBZ.MANDT
  • C_ESJISALESORDERQUERY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_ESJISALESORDERQUERY.SALESOFFICE == TVKBZ.VKBUR
  • C_ESJISALESORDERQUERY.SALESORGANIZATION == TVKBZ.VKORG
  • C_ESJISALESORDERQUERY.DIVISION == TVKBZ.SPART