A_SalesInquiry

Sales Inquiry Header | view: ASALESINQUIRY | TRAN | Extraction: Not supported | Component: Sales Inquiries / Sales Quotations
Tables used: VBAP, VBKD, VEDA, VBAK
Column Name Description
SalesInquiry Sales Inquiry
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
ExpectedOrderNetAmount Expected Order Net Amount
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CustomerPurchaseOrderDate Customer Reference Date
SalesInquiryDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
Column Name Description
HdrOrderProbabilityInPercent Sales probability Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
PurchaseOrderByCustomer Customer Reference BSTKD
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
Master Data Relations Join Conditions
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • A_SALESINQUIRY.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • A_SALESINQUIRY.MANDT == T176.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • A_SALESINQUIRY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_SALESINQUIRY.SALESORGANIZATION == TVKOV.VKORG
  • A_SALESINQUIRY.MANDT == TVKOV.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • A_SALESINQUIRY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • A_SALESINQUIRY.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • A_SALESINQUIRY.INCOTERMSCLASSIFICATION == TINC.INCO1
  • A_SALESINQUIRY.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • A_SALESINQUIRY.INCOTERMSVERSION == TINCV.INCOV
  • A_SALESINQUIRY.MANDT == TINCV.MANDT
Division in order header
  • Distribution Channel
  • Division
  • Sales Organization
  • Client
  • A_SALESINQUIRY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_SALESINQUIRY.ORGANIZATIONDIVISION == TVTA.SPART
  • A_SALESINQUIRY.SALESORGANIZATION == TVTA.VKORG
  • A_SALESINQUIRY.MANDT == TVTA.MANDT
Payment Method
  • Payment Method
  • ?
  • Client
  • A_SALESINQUIRY.PAYMENTMETHOD == T042Z.ZLSCH
  • A_SALESINQUIRY.[column in domain "LAND1"] == T042Z.LAND1
  • A_SALESINQUIRY.MANDT == T042Z.MANDT
Sales District
  • Sales District
  • Client
  • A_SALESINQUIRY.SALESDISTRICT == T171.BZIRK
  • A_SALESINQUIRY.MANDT == T171.MANDT
Sales group
  • Sales office
  • Client
  • Sales group
  • A_SALESINQUIRY.SALESOFFICE == TVBVK.VKBUR
  • A_SALESINQUIRY.MANDT == TVBVK.MANDT
  • A_SALESINQUIRY.SALESGROUP == TVBVK.VKGRP
Order type in order header
  • Sales Document Type
  • Client
  • A_SALESINQUIRY.SALESINQUIRYTYPE == TVAK.AUART
  • A_SALESINQUIRY.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • A_SALESINQUIRY.SALESORGANIZATION == TVKO.VKORG
  • A_SALESINQUIRY.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • A_SALESINQUIRY.SDDOCUMENTREASON == TVAU.AUGRU
  • A_SALESINQUIRY.MANDT == TVAU.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • A_SALESINQUIRY.SOLDTOPARTY == KNA1.KUNNR
  • A_SALESINQUIRY.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • A_SALESINQUIRY.TRANSACTIONCURRENCY == TCURC.WAERS
  • A_SALESINQUIRY.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Distribution Channel
  • Division
  • Sales Organization
  • Client
  • A_SALESINQUIRY.SALESOFFICE == TVKBZ.VKBUR
  • A_SALESINQUIRY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • A_SALESINQUIRY.ORGANIZATIONDIVISION == TVKBZ.SPART
  • A_SALESINQUIRY.SALESORGANIZATION == TVKBZ.VKORG
  • A_SALESINQUIRY.MANDT == TVKBZ.MANDT