A_SalesOrder

Sales Order Header | view: ASALESORDER | TRAN | Extraction: Not supported | Component: Sales Orders
Tables used: VBKD, VEDA, VBAK
Column Name Description
SalesOrder Sales Order
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CustomerPurchaseOrderDate Customer Reference Date
SalesOrderDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
RequestedDeliveryDate Requested Delivery Date
FixedValueDate Fixed Value Date
BillingDocumentDate Billing Date
ServicesRenderedDate Date on which services are rendered
Column Name Description
OverallDeliveryStatus Delivery Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
OverallSDDocReferenceStatus Reference Status (All Items) Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
DeliveryDateTypeRule Delivery Date Rule Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SlsDocIsRlvtForProofOfDeliv Relevant for POD processing Show values
SalesDocApprovalStatus Document Approval Status Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SenderBusinessSystemName External Business System ID SLD_BSKEY
ExternalDocumentID External Document ID CHAR40
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
ExternalDocLastChangeDateTime Timestamp for Revision of External Calls TZNTSTMPL
PurchaseOrderByCustomer Customer Reference BSTKD
PurchaseOrderByShipToParty Ship-to Party's Customer Reference BSTKD
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AssignmentReference Assignment Number ZUONR
ReferenceSDDocument Document number of the reference document VBELN
AccountingDocExternalReference Reference Document Number XBLNR1
AccountingExchangeRate Exchange Rate for Postings to Financial Accounting KURRF
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
ContractAccount Contract Account Number CORR_VKONT_KK
AdditionalValueDays Additional Value Days TAGE2
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • A_SALESORDER.MANDT == TVV1.MANDT
  • A_SALESORDER.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • A_SALESORDER.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • A_SALESORDER.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • A_SALESORDER.MANDT == TVV3.MANDT
  • A_SALESORDER.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • A_SALESORDER.MANDT == TVV4.MANDT
  • A_SALESORDER.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • A_SALESORDER.MANDT == TVV5.MANDT
  • A_SALESORDER.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • A_SALESORDER.MANDT == TVKT.MANDT
  • A_SALESORDER.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Customer Group
  • Customer Group
  • Client
  • A_SALESORDER.CUSTOMERGROUP == T151.KDGRP
  • A_SALESORDER.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • A_SALESORDER.CUSTOMERPRICEGROUP == T188.KONDA
  • A_SALESORDER.MANDT == T188.MANDT
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • A_SALESORDER.MANDT == T176.MANDT
  • A_SALESORDER.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • A_SALESORDER.MANDT == TVLS.MANDT
  • A_SALESORDER.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • A_SALESORDER.MANDT == TVKOV.MANDT
  • A_SALESORDER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_SALESORDER.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • A_SALESORDER.MANDT == TVFS.MANDT
  • A_SALESORDER.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • A_SALESORDER.MANDT == TINC.MANDT
  • A_SALESORDER.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • A_SALESORDER.MANDT == TINCV.MANDT
  • A_SALESORDER.INCOTERMSVERSION == TINCV.INCOV
Division in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • Division
  • A_SALESORDER.MANDT == TVTA.MANDT
  • A_SALESORDER.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_SALESORDER.SALESORGANIZATION == TVTA.VKORG
  • A_SALESORDER.ORGANIZATIONDIVISION == TVTA.SPART
Payment Method
  • Client
  • ?
  • Payment Method
  • A_SALESORDER.MANDT == T042Z.MANDT
  • A_SALESORDER.[column in domain "LAND1"] == T042Z.LAND1
  • A_SALESORDER.PAYMENTMETHOD == T042Z.ZLSCH
Price List Type
  • Client
  • Price List Type
  • A_SALESORDER.MANDT == T189.MANDT
  • A_SALESORDER.PRICELISTTYPE == T189.PLTYP
Sales District
  • Sales District
  • Client
  • A_SALESORDER.SALESDISTRICT == T171.BZIRK
  • A_SALESORDER.MANDT == T171.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • A_SALESORDER.MANDT == TVBVK.MANDT
  • A_SALESORDER.SALESOFFICE == TVBVK.VKBUR
  • A_SALESORDER.SALESGROUP == TVBVK.VKGRP
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • A_SALESORDER.MANDT == SDAPMAPRR.CLIENT
  • A_SALESORDER.SALESORDERAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Order type in order header
  • Client
  • Sales Order Type
  • A_SALESORDER.MANDT == TVAK.MANDT
  • A_SALESORDER.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • A_SALESORDER.MANDT == TVKO.MANDT
  • A_SALESORDER.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • A_SALESORDER.MANDT == TVAU.MANDT
  • A_SALESORDER.SDDOCUMENTREASON == TVAU.AUGRU
Shipping Conditions
  • Client
  • Shipping Conditions
  • A_SALESORDER.MANDT == TVSB.MANDT
  • A_SALESORDER.SHIPPINGCONDITION == TVSB.VSBED
Shipping Type
  • Client
  • Shipping Type
  • A_SALESORDER.MANDT == T173.MANDT
  • A_SALESORDER.SHIPPINGTYPE == T173.VSART
Sold-to Party
  • Client
  • Sold-to Party
  • A_SALESORDER.MANDT == KNA1.MANDT
  • A_SALESORDER.SOLDTOPARTY == KNA1.KUNNR
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • A_SALESORDER.TAXDEPARTURECOUNTRY == T005.LAND1
  • A_SALESORDER.MANDT == T005.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • A_SALESORDER.MANDT == TCURC.MANDT
  • A_SALESORDER.TRANSACTIONCURRENCY == TCURC.WAERS
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • A_SALESORDER.MANDT == T005.MANDT
  • A_SALESORDER.VATREGISTRATIONCOUNTRY == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Sales Organization
  • Division
  • Sales office
  • A_SALESORDER.MANDT == TVKBZ.MANDT
  • A_SALESORDER.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • A_SALESORDER.SALESORGANIZATION == TVKBZ.VKORG
  • A_SALESORDER.ORGANIZATIONDIVISION == TVKBZ.SPART
  • A_SALESORDER.SALESOFFICE == TVKBZ.VKBUR