A_SalesOrderItem

Sales Order Item | view: ASOITEM | TRAN | Extraction: Not supported | Component: Sales Orders
Tables used: VBAP, VBAK, VBAK, VBAP, VBKD, VEDA, T006, T006A
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order 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
📏 Sales unit (OrderQuantityUnit):
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
📏 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
PricingDate Date for Pricing and Exchange Rate
BillingDocumentDate Billing Date
ServicesRenderedDate Date on which services are rendered
FixedValueDate Fixed Value Date
Column Name Description
HigherLevelItemUsage ID for higher-level item usage Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
SDDocReferenceStatus Reference Status (Item) Show values
DeliveryDateTypeRule Delivery Date Rule Show values
SlsDocIsRlvtForProofOfDeliv Relevant for POD processing Show values
SDProcessStatus Overall Processing Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
Column Name Description Domain name
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SalesOrderItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
PurchaseOrderByShipToParty Ship-to Party's Customer Reference BSTKD
ExternalItemID External Item ID CHAR40
MaterialByCustomer Material Number Used by Customer IDNEX
RequestedQuantitySAPUnit SAP Unit Code for Requested Quantity MEINSINT
OrderQuantitySAPUnit SAP Unit Code for Order Quantity MEINSINT
ItemWeightSAPUnit SAP Unit Code for Item Weight MEINSINT
ItemVolumeSAPUnit SAP Unit Code for Item Volume MEINSINT
ContractAccount Contract Account Number CORR_VKONT_KK
AdditionalValueDays Additional Value Days TAGE2
ProductionPlant Plant (Own or External) WERKS
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
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
CustomerPaymentTerms Terms of payment key ZTERM
ProfitCenter Profit Center PRCTR
AccountingExchangeRate Exchange Rate for Postings to Financial Accounting KURRF
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
Material Group 1
  • Material Group 1
  • Client
  • A_SALESORDERITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • A_SALESORDERITEM.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • A_SALESORDERITEM.MANDT == TVM2.MANDT
  • A_SALESORDERITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • A_SALESORDERITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • A_SALESORDERITEM.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • A_SALESORDERITEM.MANDT == TVM4.MANDT
  • A_SALESORDERITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • A_SALESORDERITEM.MANDT == TVM5.MANDT
  • A_SALESORDERITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Batch Number
  • Batch Number
  • Plant (Own or External)
  • Client
  • Material Number
  • A_SALESORDERITEM.BATCH == MCHA.CHARG
  • A_SALESORDERITEM.PRODUCTIONPLANT == MCHA.WERKS
  • A_SALESORDERITEM.MANDT == MCHA.MANDT
  • A_SALESORDERITEM.MATERIAL == MCHA.MATNR
Customer Group
  • Client
  • Customer Group
  • A_SALESORDERITEM.MANDT == T151.MANDT
  • A_SALESORDERITEM.CUSTOMERGROUP == T151.KDGRP
Delivery Priority
  • Delivery Priority
  • Client
  • A_SALESORDERITEM.DELIVERYPRIORITY == TPRIO.LPRIO
  • A_SALESORDERITEM.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • A_SALESORDERITEM.SALESORGANIZATION == TVKOV.VKORG
  • A_SALESORDERITEM.MANDT == TVKOV.MANDT
  • A_SALESORDERITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • A_SALESORDERITEM.MANDT == TINC.MANDT
  • A_SALESORDERITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
Billing Block for Item
  • Billing Block for Item
  • Client
  • A_SALESORDERITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • A_SALESORDERITEM.MANDT == TVFS.MANDT
ISO Unit Code for Item Volume
  • ISO Unit Code for Item Volume
  • ISO Unit Code for Order Quantity
  • ISO Unit Code for Requested Quantity
  • ISO Unit Code for Item Weight
  • Client
  • A_SALESORDERITEM.ITEMVOLUMEISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.ORDERQUANTITYISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.ITEMWEIGHTISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.MANDT == T006I.CLIENT
Volume unit
  • Client
  • Volume unit
  • A_SALESORDERITEM.MANDT == T006.MANDT
  • A_SALESORDERITEM.ITEMVOLUMEUNIT == T006.MSEHI
ISO Unit Code for Item Weight
  • ISO Unit Code for Item Volume
  • ISO Unit Code for Order Quantity
  • ISO Unit Code for Requested Quantity
  • ISO Unit Code for Item Weight
  • Client
  • A_SALESORDERITEM.ITEMVOLUMEISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.ORDERQUANTITYISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.ITEMWEIGHTISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.MANDT == T006I.CLIENT
Weight Unit
  • Client
  • Weight Unit
  • A_SALESORDERITEM.MANDT == T006.MANDT
  • A_SALESORDERITEM.ITEMWEIGHTUNIT == T006.MSEHI
Material: order item
  • Client
  • Material Number
  • A_SALESORDERITEM.MANDT == MARA.MANDT
  • A_SALESORDERITEM.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • A_SALESORDERITEM.MATERIALGROUP == T023.MATKL
  • A_SALESORDERITEM.MANDT == T023.MANDT
Material Price Group
  • Material Price Group
  • Client
  • A_SALESORDERITEM.MATERIALPRICINGGROUP == T178.KONDM
  • A_SALESORDERITEM.MANDT == T178.MANDT
Reason for material substitution
  • Client
  • Reason for material substitution
  • A_SALESORDERITEM.MANDT == TVSU.MANDT
  • A_SALESORDERITEM.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
Account Assignment Group for Material
  • Account Assignment Group for Material
  • Client
  • A_SALESORDERITEM.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM
  • A_SALESORDERITEM.MANDT == TVKM.MANDT
ISO Unit Code for Order Quantity
  • ISO Unit Code for Item Volume
  • ISO Unit Code for Order Quantity
  • ISO Unit Code for Requested Quantity
  • ISO Unit Code for Item Weight
  • Client
  • A_SALESORDERITEM.ITEMVOLUMEISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.ORDERQUANTITYISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.ITEMWEIGHTISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.MANDT == T006I.CLIENT
Sales unit
  • Sales unit
  • Client
  • A_SALESORDERITEM.ORDERQUANTITYUNIT == T006.MSEHI
  • A_SALESORDERITEM.MANDT == T006.MANDT
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • A_SALESORDERITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • A_SALESORDERITEM.SALESORGANIZATION == TVTA.VKORG
  • A_SALESORDERITEM.MANDT == TVTA.MANDT
  • A_SALESORDERITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • A_SALESORDERITEM.MANDT == MARA.MANDT
  • A_SALESORDERITEM.PRICINGREFERENCEMATERIAL == MARA.MATNR
ISO Unit Code for Requested Quantity
  • ISO Unit Code for Item Volume
  • ISO Unit Code for Order Quantity
  • ISO Unit Code for Requested Quantity
  • ISO Unit Code for Item Weight
  • Client
  • A_SALESORDERITEM.ITEMVOLUMEISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.ORDERQUANTITYISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.ITEMWEIGHTISOUNIT == T006I.ISOCODE
  • A_SALESORDERITEM.MANDT == T006I.CLIENT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • A_SALESORDERITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • A_SALESORDERITEM.MANDT == TVAG.MANDT
Sales document item category
  • Client
  • Sales document item category
  • A_SALESORDERITEM.MANDT == TVPT.MANDT
  • A_SALESORDERITEM.SALESORDERITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Sales Document Type
  • Client
  • A_SALESORDERITEM.SALESORDERTYPE == TVAK.AUART
  • A_SALESORDERITEM.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • A_SALESORDERITEM.SALESORGANIZATION == TVKO.VKORG
  • A_SALESORDERITEM.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • A_SALESORDERITEM.SHIPPINGPOINT == TVST.VSTEL
  • A_SALESORDERITEM.MANDT == TVST.MANDT
Shipping Type
  • Client
  • Shipping Type
  • A_SALESORDERITEM.MANDT == T173.MANDT
  • A_SALESORDERITEM.SHIPPINGTYPE == T173.VSART
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • A_SALESORDERITEM.STORAGELOCATION == T001L.LGORT
  • A_SALESORDERITEM.PRODUCTIONPLANT == T001L.WERKS
  • A_SALESORDERITEM.MANDT == T001L.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • A_SALESORDERITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • A_SALESORDERITEM.MANDT == TCURC.MANDT