A_SalesInquiryItem

Sales Inquiry Item | view: ASIITEM | TRAN | Extraction: Not supported | Component: Sales Inquiries / Sales Quotations
Tables used: VBAP, VBAK, VBKD, VEDA
Column Name Description
SalesInquiry FK Sales Inquiry
SalesInquiryItem Sales Inquiry Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
Column Name Description
Column Name Description
ItemOrderProbabilityInPercent Order Probability of the Item Show values
SDProcessStatus Overall Processing Status (Item) Show values
Column Name Description Domain name
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SalesInquiryItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
MaterialByCustomer Material Number Used by Customer IDNEX
AlternativeToItem Item for Which this Item is an Alternative GRPOS
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Batch Number
  • Client
  • Batch Number
  • Material Number
  • ?
  • A_SALESINQUIRYITEM.MANDT == MCHA.MANDT
  • A_SALESINQUIRYITEM.BATCH == MCHA.CHARG
  • A_SALESINQUIRYITEM.MATERIAL == MCHA.MATNR
  • A_SALESINQUIRYITEM.[column in domain "WERKS_D"] == MCHA.WERKS
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • A_SALESINQUIRYITEM.MANDT == TVKOV.MANDT
  • A_SALESINQUIRYITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_SALESINQUIRYITEM.SALESORGANIZATION == TVKOV.VKORG
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • A_SALESINQUIRYITEM.MANDT == TINC.MANDT
  • A_SALESINQUIRYITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
Volume unit
  • Client
  • Volume unit
  • A_SALESINQUIRYITEM.MANDT == T006.MANDT
  • A_SALESINQUIRYITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • A_SALESINQUIRYITEM.MANDT == T006.MANDT
  • A_SALESINQUIRYITEM.ITEMWEIGHTUNIT == T006.MSEHI
Material: order item
  • Client
  • Material Number
  • A_SALESINQUIRYITEM.MANDT == MARA.MANDT
  • A_SALESINQUIRYITEM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • A_SALESINQUIRYITEM.MANDT == T023.MANDT
  • A_SALESINQUIRYITEM.MATERIALGROUP == T023.MATKL
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • A_SALESINQUIRYITEM.MANDT == TVTA.MANDT
  • A_SALESINQUIRYITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_SALESINQUIRYITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • A_SALESINQUIRYITEM.SALESORGANIZATION == TVTA.VKORG
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • A_SALESINQUIRYITEM.MANDT == TVAG.MANDT
  • A_SALESINQUIRYITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales document item category
  • Client
  • Sales document item category
  • A_SALESINQUIRYITEM.MANDT == TVPT.MANDT
  • A_SALESINQUIRYITEM.SALESINQUIRYITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Client
  • Sales Document Type
  • A_SALESINQUIRYITEM.MANDT == TVAK.MANDT
  • A_SALESINQUIRYITEM.SALESINQUIRYTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • A_SALESINQUIRYITEM.MANDT == TVKO.MANDT
  • A_SALESINQUIRYITEM.SALESORGANIZATION == TVKO.VKORG
SD Document Currency
  • Client
  • SD Document Currency
  • A_SALESINQUIRYITEM.MANDT == TCURC.MANDT
  • A_SALESINQUIRYITEM.TRANSACTIONCURRENCY == TCURC.WAERS