A_SalesOrderItemSimulation

Sales Order Item Simulation (API) | view: ASOITMSIM | TRAN | Extraction: Not supported | Component: Sales Orders

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

🔑 Keys (2)
💰 Amounts (9)
∑ Quantities (5)
📅 Dates (1)
☰ Categorical (1)
Other (25)
🔗 Relations (26)

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
TaxAmount	Tax Amount in Document Currency
CostAmount	Cost in Document Currency
Subtotal1Amount	Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount	Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount	Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount	Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount	Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount	Subtotal 6 from Pricing Procedure for Price Element

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

Column Name	Description
HigherLevelItemUsage	ID for higher-level item usage	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
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
Plant	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
ReferenceSDDocument	Document number of the reference document	VBELN
ReferenceSDDocumentItem	Item number of the reference item	POSNR
CustomerPaymentTerms	Terms of payment key	ZTERM

Master Data Relations	Join Conditions
Batch Number Batch Number Plant (Own or External) Material Number Client	`A_SALESORDERITEMSIMULATION.BATCH == MCHA.CHARG` `A_SALESORDERITEMSIMULATION.PLANT == MCHA.WERKS` `A_SALESORDERITEMSIMULATION.MATERIAL == MCHA.MATNR` `A_SALESORDERITEMSIMULATION.MANDT == MCHA.MANDT`
Delivery Priority Delivery Priority Client	`A_SALESORDERITEMSIMULATION.DELIVERYPRIORITY == TPRIO.LPRIO` `A_SALESORDERITEMSIMULATION.MANDT == TPRIO.MANDT`
Distribution channel in order header Distribution Channel Client Sales Organization	`A_SALESORDERITEMSIMULATION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `A_SALESORDERITEMSIMULATION.MANDT == TVKOV.MANDT` `A_SALESORDERITEMSIMULATION.SALESORGANIZATION == TVKOV.VKORG`
Incoterms (Part 1) Client Incoterms (Part 1)	`A_SALESORDERITEMSIMULATION.MANDT == TINC.MANDT` `A_SALESORDERITEMSIMULATION.INCOTERMSCLASSIFICATION == TINC.INCO1`
ISO Unit Code for Item Volume ISO Unit Code for Item Volume ISO Unit Code for Item Weight ISO Unit Code for Order Quantity ISO Unit Code for Requested Quantity Client	`A_SALESORDERITEMSIMULATION.ITEMVOLUMEISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.ITEMWEIGHTISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.ORDERQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.MANDT == T006I.CLIENT`
Volume unit Volume unit Client	`A_SALESORDERITEMSIMULATION.ITEMVOLUMEUNIT == T006.MSEHI` `A_SALESORDERITEMSIMULATION.MANDT == T006.MANDT`
ISO Unit Code for Item Weight ISO Unit Code for Item Volume ISO Unit Code for Item Weight ISO Unit Code for Order Quantity ISO Unit Code for Requested Quantity Client	`A_SALESORDERITEMSIMULATION.ITEMVOLUMEISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.ITEMWEIGHTISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.ORDERQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.MANDT == T006I.CLIENT`
Weight Unit Weight Unit Client	`A_SALESORDERITEMSIMULATION.ITEMWEIGHTUNIT == T006.MSEHI` `A_SALESORDERITEMSIMULATION.MANDT == T006.MANDT`
Material: order item Material Number Client	`A_SALESORDERITEMSIMULATION.MATERIAL == MARA.MATNR` `A_SALESORDERITEMSIMULATION.MANDT == MARA.MANDT`
Material Group Material Group Client	`A_SALESORDERITEMSIMULATION.MATERIALGROUP == T023.MATKL` `A_SALESORDERITEMSIMULATION.MANDT == T023.MANDT`
Material Price Group Material Price Group Client	`A_SALESORDERITEMSIMULATION.MATERIALPRICINGGROUP == T178.KONDM` `A_SALESORDERITEMSIMULATION.MANDT == T178.MANDT`
Reason for material substitution Reason for material substitution Client	`A_SALESORDERITEMSIMULATION.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD` `A_SALESORDERITEMSIMULATION.MANDT == TVSU.MANDT`
ISO Unit Code for Order Quantity ISO Unit Code for Item Volume ISO Unit Code for Item Weight ISO Unit Code for Order Quantity ISO Unit Code for Requested Quantity Client	`A_SALESORDERITEMSIMULATION.ITEMVOLUMEISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.ITEMWEIGHTISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.ORDERQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.MANDT == T006I.CLIENT`
Sales unit Sales unit Client	`A_SALESORDERITEMSIMULATION.ORDERQUANTITYUNIT == T006.MSEHI` `A_SALESORDERITEMSIMULATION.MANDT == T006.MANDT`
Division in order header Division Distribution Channel Client Sales Organization	`A_SALESORDERITEMSIMULATION.ORGANIZATIONDIVISION == TVTA.SPART` `A_SALESORDERITEMSIMULATION.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `A_SALESORDERITEMSIMULATION.MANDT == TVTA.MANDT` `A_SALESORDERITEMSIMULATION.SALESORGANIZATION == TVTA.VKORG`
Pricing Reference Material Client Pricing Reference Material	`A_SALESORDERITEMSIMULATION.MANDT == MARA.MANDT` `A_SALESORDERITEMSIMULATION.PRICINGREFERENCEMATERIAL == MARA.MATNR`
ISO Unit Code for Requested Quantity ISO Unit Code for Item Volume ISO Unit Code for Item Weight ISO Unit Code for Order Quantity ISO Unit Code for Requested Quantity Client	`A_SALESORDERITEMSIMULATION.ITEMVOLUMEISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.ITEMWEIGHTISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.ORDERQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.REQUESTEDQUANTITYISOUNIT == T006I.ISOCODE` `A_SALESORDERITEMSIMULATION.MANDT == T006I.CLIENT`
Reason for Rejection of Sales Documents Reason for Rejection of Sales Documents Client	`A_SALESORDERITEMSIMULATION.SALESDOCUMENTRJCNREASON == TVAG.ABGRU` `A_SALESORDERITEMSIMULATION.MANDT == TVAG.MANDT`
Sales document item category Client Sales document item category	`A_SALESORDERITEMSIMULATION.MANDT == TVPT.MANDT` `A_SALESORDERITEMSIMULATION.SALESORDERITEMCATEGORY == TVPT.PSTYV`
Order type in order header Sales Document Type Client	`A_SALESORDERITEMSIMULATION.SALESORDERTYPE == TVAK.AUART` `A_SALESORDERITEMSIMULATION.MANDT == TVAK.MANDT`
Sales organization in order header Client Sales Organization	`A_SALESORDERITEMSIMULATION.MANDT == TVKO.MANDT` `A_SALESORDERITEMSIMULATION.SALESORGANIZATION == TVKO.VKORG`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`A_SALESORDERITEMSIMULATION.MANDT == TVST.MANDT` `A_SALESORDERITEMSIMULATION.SHIPPINGPOINT == TVST.VSTEL`
Shipping Type Client Shipping Type	`A_SALESORDERITEMSIMULATION.MANDT == T173.MANDT` `A_SALESORDERITEMSIMULATION.SHIPPINGTYPE == T173.VSART`
Storage location Storage location Plant (Own or External) Client	`A_SALESORDERITEMSIMULATION.STORAGELOCATION == T001L.LGORT` `A_SALESORDERITEMSIMULATION.PLANT == T001L.WERKS` `A_SALESORDERITEMSIMULATION.MANDT == T001L.MANDT`
SD Document Currency SD Document Currency Client	`A_SALESORDERITEMSIMULATION.TRANSACTIONCURRENCY == TCURC.WAERS` `A_SALESORDERITEMSIMULATION.MANDT == TCURC.MANDT`