A_SalesQuotationItem

Sales Quotation Item | view: ASQITEM | TRAN | Extraction: Not supported | Component: Sales Inquiries / Sales Quotations

Tables used: VBAP, VBAK, VBKD, VEDA, T006, T006A

🔑 Keys (2)
💰 Amounts (1)
∑ Quantities (4)
📅 Dates
☰ Categorical (2)
Other (26)
🔗 Relations (20)

Column Name	Description
SalesQuotation FK	Sales Quotation
SalesQuotationItem	Sales Quotation 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
SalesQuotationItemText	Short text for sales order item	TEXT40
PurchaseOrderByCustomer	Customer Reference	BSTKD
MaterialByCustomer	Material Number Used by Customer	IDNEX
RequestedQuantitySAPUnit	SAP Unit Code for Requested Quantity	MEINSINT
AlternativeToItem	Item for Which this Item is an Alternative	GRPOS
ItemWeightSAPUnit	SAP Unit Code for Item Weight	MEINSINT
ItemVolumeSAPUnit	SAP Unit Code for Item Volume	MEINSINT
Plant	Plant (Own or External)	WERKS
IncotermsTransferLocation	Incoterms (Part 2)	INCO2
IncotermsLocation1	Incoterms Location 1	INCO_L
IncotermsLocation2	Incoterms Location 2	INCO_L
CustomerPaymentTerms	Terms of payment key	ZTERM
ProductTaxClassification1	Tax Classification for Material	TAXKD
ProductTaxClassification2	Tax Classification for Material	TAXKD
ProductTaxClassification3	Tax Classification for Material	TAXKD
ProductTaxClassification4	Tax Classification for Material	TAXKD
ProductTaxClassification5	Tax Classification for Material	TAXKD
ProductTaxClassification6	Tax Classification for Material	TAXKD
ProductTaxClassification7	Tax Classification for Material	TAXKD
ProductTaxClassification8	Tax Classification for Material	TAXKD
ProductTaxClassification9	Tax Classification for Material	TAXKD
ProfitCenter	Profit Center	PRCTR
ReferenceSDDocument	Document number of the reference document	VBELN
ReferenceSDDocumentItem	Item number of the reference item	POSNR
RequirementSegment	Requirement Segment	SGT_SRCA

Master Data Relations	Join Conditions
Batch Number Batch Number Client Material Number Plant (Own or External)	`A_SALESQUOTATIONITEM.BATCH == MCHA.CHARG` `A_SALESQUOTATIONITEM.MANDT == MCHA.MANDT` `A_SALESQUOTATIONITEM.MATERIAL == MCHA.MATNR` `A_SALESQUOTATIONITEM.PLANT == MCHA.WERKS`
Distribution channel in order header Client Distribution Channel Sales Organization	`A_SALESQUOTATIONITEM.MANDT == TVKOV.MANDT` `A_SALESQUOTATIONITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `A_SALESQUOTATIONITEM.SALESORGANIZATION == TVKOV.VKORG`
Incoterms (Part 1) Client Incoterms (Part 1)	`A_SALESQUOTATIONITEM.MANDT == TINC.MANDT` `A_SALESQUOTATIONITEM.INCOTERMSCLASSIFICATION == TINC.INCO1`
ISO Unit Code for Item Volume ISO Unit Code for Item Volume ISO Unit Code for Requested Quantity ISO Unit Code for Item Weight Client	`A_SALESQUOTATIONITEM.ITEMVOLUMEISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.ITEMWEIGHTISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.MANDT == T006I.CLIENT`
Volume unit Client Volume unit	`A_SALESQUOTATIONITEM.MANDT == T006.MANDT` `A_SALESQUOTATIONITEM.ITEMVOLUMEUNIT == T006.MSEHI`
ISO Unit Code for Item Weight ISO Unit Code for Item Volume ISO Unit Code for Requested Quantity ISO Unit Code for Item Weight Client	`A_SALESQUOTATIONITEM.ITEMVOLUMEISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.ITEMWEIGHTISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.MANDT == T006I.CLIENT`
Weight Unit Weight Unit Client	`A_SALESQUOTATIONITEM.ITEMWEIGHTUNIT == T006.MSEHI` `A_SALESQUOTATIONITEM.MANDT == T006.MANDT`
Material: order item Client Material Number	`A_SALESQUOTATIONITEM.MANDT == MARA.MANDT` `A_SALESQUOTATIONITEM.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`A_SALESQUOTATIONITEM.MATERIALGROUP == T023.MATKL` `A_SALESQUOTATIONITEM.MANDT == T023.MANDT`
Material Price Group Client Material Price Group	`A_SALESQUOTATIONITEM.MANDT == T178.MANDT` `A_SALESQUOTATIONITEM.MATERIALPRICINGGROUP == T178.KONDM`
Division in order header Client Division Distribution Channel Sales Organization	`A_SALESQUOTATIONITEM.MANDT == TVTA.MANDT` `A_SALESQUOTATIONITEM.ORGANIZATIONDIVISION == TVTA.SPART` `A_SALESQUOTATIONITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `A_SALESQUOTATIONITEM.SALESORGANIZATION == TVTA.VKORG`
Pricing Reference Material Client Pricing Reference Material	`A_SALESQUOTATIONITEM.MANDT == MARA.MANDT` `A_SALESQUOTATIONITEM.PRICINGREFERENCEMATERIAL == MARA.MATNR`
ISO Unit Code for Requested Quantity ISO Unit Code for Item Volume ISO Unit Code for Requested Quantity ISO Unit Code for Item Weight Client	`A_SALESQUOTATIONITEM.ITEMVOLUMEISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.ITEMWEIGHTISOUNIT == T006I.ISOCODE` `A_SALESQUOTATIONITEM.MANDT == T006I.CLIENT`
Reason for Rejection of Sales Documents Client Reason for Rejection of Sales Documents	`A_SALESQUOTATIONITEM.MANDT == TVAG.MANDT` `A_SALESQUOTATIONITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU`
Sales organization in order header Client Sales Organization	`A_SALESQUOTATIONITEM.MANDT == TVKO.MANDT` `A_SALESQUOTATIONITEM.SALESORGANIZATION == TVKO.VKORG`
Sales document item category Sales document item category Client	`A_SALESQUOTATIONITEM.SALESQUOTATIONITEMCATEGORY == TVPT.PSTYV` `A_SALESQUOTATIONITEM.MANDT == TVPT.MANDT`
Order type in order header Sales Document Type Client	`A_SALESQUOTATIONITEM.SALESQUOTATIONTYPE == TVAK.AUART` `A_SALESQUOTATIONITEM.MANDT == TVAK.MANDT`
SD Document Currency SD Document Currency Client	`A_SALESQUOTATIONITEM.TRANSACTIONCURRENCY == TCURC.WAERS` `A_SALESQUOTATIONITEM.MANDT == TCURC.MANDT`