A_SalesOrderSimulation

Sales Order Simulation | view: ASOSIM | TRAN | Extraction: Not supported | Component: Sales Orders
Tables used: VBKD, VEDA, VBAK
Column Name Description
SalesOrder Sales Order
Column Name Description
Column Name Description
Column Name Description
CustomerPurchaseOrderDate Customer Reference Date
SalesOrderDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
RequestedDeliveryDate Requested Delivery Date
Column Name Description
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
Column Name Description Domain name
PurchaseOrderByCustomer Customer Reference BSTKD
AccountingDocExternalReference Reference Document Number XBLNR1
CustomerTaxClassification1 Alternative Tax Classification TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ReferenceSDDocument Document number of the reference document VBELN
CustomerPaymentTerms Terms of payment key ZTERM
Master Data Relations Join Conditions
Customer Price Group
  • Client
  • Customer Price Group
  • A_SALESORDERSIMULATION.MANDT == T188.MANDT
  • A_SALESORDERSIMULATION.CUSTOMERPRICEGROUP == T188.KONDA
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • A_SALESORDERSIMULATION.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • A_SALESORDERSIMULATION.MANDT == T176.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • A_SALESORDERSIMULATION.SALESORGANIZATION == TVKOV.VKORG
  • A_SALESORDERSIMULATION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_SALESORDERSIMULATION.MANDT == TVKOV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • A_SALESORDERSIMULATION.INCOTERMSCLASSIFICATION == TINC.INCO1
  • A_SALESORDERSIMULATION.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • A_SALESORDERSIMULATION.INCOTERMSVERSION == TINCV.INCOV
  • A_SALESORDERSIMULATION.MANDT == TINCV.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • A_SALESORDERSIMULATION.SALESORGANIZATION == TVTA.VKORG
  • A_SALESORDERSIMULATION.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_SALESORDERSIMULATION.MANDT == TVTA.MANDT
  • A_SALESORDERSIMULATION.ORGANIZATIONDIVISION == TVTA.SPART
Payment Method
  • ?
  • Payment Method
  • Client
  • A_SALESORDERSIMULATION.[column in domain "LAND1"] == T042Z.LAND1
  • A_SALESORDERSIMULATION.PAYMENTMETHOD == T042Z.ZLSCH
  • A_SALESORDERSIMULATION.MANDT == T042Z.MANDT
Price List Type
  • Price List Type
  • Client
  • A_SALESORDERSIMULATION.PRICELISTTYPE == T189.PLTYP
  • A_SALESORDERSIMULATION.MANDT == T189.MANDT
Sales District
  • Sales District
  • Client
  • A_SALESORDERSIMULATION.SALESDISTRICT == T171.BZIRK
  • A_SALESORDERSIMULATION.MANDT == T171.MANDT
Sales group
  • Sales group
  • Client
  • Sales office
  • A_SALESORDERSIMULATION.SALESGROUP == TVBVK.VKGRP
  • A_SALESORDERSIMULATION.MANDT == TVBVK.MANDT
  • A_SALESORDERSIMULATION.SALESOFFICE == TVBVK.VKBUR
Order type in order header
  • Client
  • Sales Order Type
  • A_SALESORDERSIMULATION.MANDT == TVAK.MANDT
  • A_SALESORDERSIMULATION.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Sales Organization
  • Client
  • A_SALESORDERSIMULATION.SALESORGANIZATION == TVKO.VKORG
  • A_SALESORDERSIMULATION.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • A_SALESORDERSIMULATION.SDDOCUMENTREASON == TVAU.AUGRU
  • A_SALESORDERSIMULATION.MANDT == TVAU.MANDT
Pricing Procedure in Pricing
  • Pricing Procedure in Pricing
  • ?
  • Client
  • ?
  • A_SALESORDERSIMULATION.SDPRICINGPROCEDURE == T683.KALSM
  • A_SALESORDERSIMULATION.[column in domain "KVEWE"] == T683.KVEWE
  • A_SALESORDERSIMULATION.MANDT == T683.MANDT
  • A_SALESORDERSIMULATION.[column in domain "KAPPL"] == T683.KAPPL
Shipping Conditions
  • Shipping Conditions
  • Client
  • A_SALESORDERSIMULATION.SHIPPINGCONDITION == TVSB.VSBED
  • A_SALESORDERSIMULATION.MANDT == TVSB.MANDT
Shipping Type
  • Client
  • Shipping Type
  • A_SALESORDERSIMULATION.MANDT == T173.MANDT
  • A_SALESORDERSIMULATION.SHIPPINGTYPE == T173.VSART
Sold-to Party
  • Sold-to Party
  • Client
  • A_SALESORDERSIMULATION.SOLDTOPARTY == KNA1.KUNNR
  • A_SALESORDERSIMULATION.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • A_SALESORDERSIMULATION.MANDT == TCURC.MANDT
  • A_SALESORDERSIMULATION.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Distribution Channel
  • Client
  • Division
  • Sales office
  • A_SALESORDERSIMULATION.SALESORGANIZATION == TVKBZ.VKORG
  • A_SALESORDERSIMULATION.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • A_SALESORDERSIMULATION.MANDT == TVKBZ.MANDT
  • A_SALESORDERSIMULATION.ORGANIZATIONDIVISION == TVKBZ.SPART
  • A_SALESORDERSIMULATION.SALESOFFICE == TVKBZ.VKBUR