P_SLSQTANPRDTVDATA

Sales Quotation Predictive Data | view: PSDSLSQPD | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAPSCAL_TT_DATEVBKDVEDAVBAKVBAKVBAPVBKDVEDAVBAKVBAPVBKDVEDAVBEPBUT000BUT100KNA1MARATVAPTVKOUSR21
Column Name Description
SalesQuotation FK Sales Quotation
SalesQuotationItem Sales Quotation Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
OutlineAgreementTargetAmount Target Value for Outline Agreement in Document Currency
TotalNetAmount Net Value of the Sales Order in Document Currency
InquiryTotalAmount Net Value of the Sales Order in Document Currency
InquiryItemNetAmount Net Value of the Order Item in Document Currency
InquiryItemNetPriceAmount Net Price
InquiryItemTaxAmount Tax Amount in Document Currency
InquiryItemCostAmount Cost in Document Currency
InquiryItemSubtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
InquiryItemSubtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
InquiryItemSubtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
InquiryItemSubtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
InquiryItemSubtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
InquiryItemSubtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
NetAmount Net Value of Sales Order Item in Transaction Currency
NetPriceAmount Net Price
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
SalesQuotationNetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
InquiryItemOrderQuantity Cumulative order quantity in sales units
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
InquiryItemRequestedQuantity Requested Quantity
📏 Base Unit of Measure (BaseUnit):
InqItmReqQuantityInBaseUnit Requested Order Quantity in Base Unit
📏 Weight Unit (ItemWeightUnit):
InquiryItemGrossWeight Gross Weight of the Item
InquiryItemNetWeight Net Weight of the Item
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
InquiryItemVolume Volume of the item
ItemVolume Volume of the item
📏 Weight Unit (MaterialWeightUnit):
MaterialGrossWeight Gross weight
MaterialNetWeight Net weight
OriginalMaterialGrossWeight Gross weight
OriginalMaterialNetWeight Net weight
Column Name Description
ItemCreationDate Date on which the record was created
ItemCreationTime Time at Which Record Was Created
ItemLastChangeDate Last Changed On
QuotationCreationDate Date on which the record was created
QuotationCreationTime Time at Which Record Was Created
QuotationLastChangeDate Last Changed On
BindingPeriodValidityStartDate Quotation/Inquiry is Valid From
BindingPeriodValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
PricingDate Date for Pricing and Exchange Rate
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
ExchangeRateDate Translation date
InquiryCreationDate Date on which the record was created
InquiryCreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesInquiryDate Document Date (Date Received/Sent)
InquiryCustPurchaseOrderDate Customer Reference Date
InquiryValidityStartDate Quotation/Inquiry is Valid From
InquiryValidityEndDate Date Until Which Bid/Quotation is Binding (Valid-To Date)
InquiryPricingDate Date for Pricing and Exchange Rate
InquiryBillingDocumentDate Billing Date
InquiryFixedValueDate Fixed Value Date
InquiryExchangeRateDate Translation date
InquiryItemCreationDate Date on which the record was created
InquiryItemCreantionTime Time at Which Record Was Created
InquiryItemLastChangeDate Last Changed On
InquiryItemExchangeRateDate Translation date
InquiryItemBillingDocumentDate Billing Date
InquiryItemFixedValueDate Fixed Value Date
SoldToPartyCreationDate Date on which the Record Was Created
RespEmployeeValidityStartDate Start Date
RespEmployeeValidityEndDate End Date
RespEmployee Date on which the object was created
RespEmployeeCreationTime Time at which the object was created
RespEmployeeLastChangeDate Date when object was last changed
RespEmployeeLastChangeTime Time at which object was last changed
SalesEmployeeValidityStartDate Start Date
SalesEmployeeValidityEndDate End Date
SalesEmployee Date on which the object was created
SalesEmployeeCreationTime Time at which the object was created
SalesEmployeeLastChangeDate Date when object was last changed
SalesEmployeeLastChangeTime Time at which object was last changed
SalesQuotationDate Document Date (Date Received/Sent)
ServicesRenderedDate Date on which services are rendered
CustomerPurchaseOrderDate Customer Reference Date
Column Name Description
SalesQuotationItemType Item Type Show values
ScheduleLineIsAllowed Schedule lines allowed Show values
HdrOrderProbabilityInPercent Sales probability Show values
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
QuotationRefSDDocumentCategory Document Category of Preceding SD Document Show values
ItemRefSDDocumentCategory Document Category of Preceding SD Document Show values
InqHdrOrdProbabilityInPercent Sales probability Show values
InquiryRefSDDocumentCategory Document Category of Preceding SD Document Show values
InqOverallSDDocRejectionSts Rejection Status (All Items) Show values
InquiryTotalBlockStatus Overall Block Status (Header) Show values
InquiryOverallBillingBlockSts Billing Block Status (All Items) Show values
InquiryTotalCreditCheckStatus Overall Status of Credit Checks Show values
InqMaxDocValueCreditCheckSts Status of Credit Check Against Maximum Document Value Show values
InqPaymentTermCreditCheckSts Status of Credit Check Against Terms of Payment Show values
InquiryFinDocCreditCheckStatus Status of Credit Check Against Financial Document Show values
InqExprtInsurCreditCheckStatus Status of Credit Check Against Export Credit Insurance Show values
InquiryPayAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
InqCentralCreditCheckStatus Status of Credit Check SAP Credit Management Show values
InqCentralCreditChkTechErrSts Status of Technical Error SAP Credit Management Show values
InqHdrGeneralIncompletionSts Incompletion Status (Header) Show values
InqOvrlPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
InqHeaderBillgIncompletionSts Billing Incompletion Status (Header) Show values
InqOvrlItmGeneralIncpltSts Incompletion Status (All Items) Show values
InqOvrlItmBillingIncpltSts Billing Incompletion Status (All Items) Show values
SalesInquiryItemType Item Type Show values
IsReturnsItem Returns Item Show values
InqItemOrdProbabilityInPercent Order Probability of the Item Show values
InqItemStatisticalValueControl Statistical Values Show values
InqItmDeliDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
InqItmRefSDDocumentCategory Document Category of Preceding SD Document Show values
InquiryItemBillingBlockStatus Billing Block Status (Item) Show values
InqItmGeneralIncompletionSts Incompletion Status (Item) Show values
InqItmBillingIncompletionSts Billing Incompletion Status (Item) Show values
InqItmPricingIncompletionSts Pricing Incompletion Status (Item) Show values
InqItmSDDocumentRejectionSts Rejection Status (Item) Show values
PostingIsBlocked Central posting block Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
DataMediumExchangeIndicator Report key for data medium exchange Show values
VATLiability Liable for VAT Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
NFPartnerIsNaturalPerson Natural Person Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
IsBatchManagementRequired Batch Management Requirement Indicator Show values
OriIsBatchManagementRequired Batch Management Requirement Indicator Show values
StatisticalValueControl Statistical Values Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallTotalSDDocRefStatus Overall Reference Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
MaxDocValueCreditCheckStatus Status of Credit Check Against Maximum Document Value Show values
PaymentTermCreditCheckStatus Status of Credit Check Against Terms of Payment Show values
FinDocCreditCheckStatus Status of Credit Check Against Financial Document Show values
ExprtInsurCreditCheckStatus Status of Credit Check Against Export Credit Insurance Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization Show values
CentralCreditCheckStatus Status of Credit Check SAP Credit Management Show values
CentralCreditChkTechErrSts Status of Technical Error SAP Credit Management Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
DeliveryConfirmationStatus Delivery Confirmation Status (Item) Show values
PurchaseConfirmationStatus Purchasing Confirmation Status (Item) Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
DeliveryBlockStatus Delivery Block Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
BillingBlockStatus Billing Block Status (Item) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
Column Name Description Domain name
ItemCreatedByUser Name of Person Responsible for Creating the Object USNAM
ItemCreationUserDescription User Description SUIDTECHDESC
ItemCreationDateYear Year of Creation NUM4
ItemCreationDateYearQuarter Year/Quarter of Creation NUM5
ItemCreationDateYearMonth Year/Month of Creation NUM6
ItemCreationCalendarQuarter Calendar Quarter NUM1
ItemCreationCalendarMonth Calendar Month NUM2
ItemCreationCalendarWeek Calendar Week NUM2
ItemCreationCalendarDay Calendar Day NUM2
QuotationCreatedByUser Name of Person Responsible for Creating the Object USNAM
QuotationLastChangedByUser User Who Last Changed the Business Document USNAM
QuotationLastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
SalesQuotationLastChangeDays Sales Quotation Last Change Days INT4
SalesQuotationType Sales Document Type AUART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
BindingPerdValdtyStartYear Calendar Year NUM4
BindingPerdValdtyStartQuarter Calendar Quarter NUM1
BindingPerdValdtyStartMonth Calendar Month NUM2
BindingPerdValdtyStartWeek Calendar Week NUM2
BindingPerdValdtyStartDay Calendar Day NUM2
BindingPerdValdtyEndYear Calendar Year NUM4
BindingPerdValdtyEndQuarter Calendar Quarter NUM1
BindingPerdValdtyEndMonth Calendar Month NUM2
BindingPerdValdtyEndWeek Calendar Week NUM2
BindingPerdValdtyEndDay Calendar Day NUM2
SalesQuotationValidityDays Sales Quotation Validity Days INT4
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
SalesQuotationCondition Number of the Document Condition KNUMV
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AdditionalValueDays Additional Value Days TAGE2
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
SalesInquiry Document number of the reference document VBELN
SalesInquiryItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
InquiryCreatedByUser Name of Person Responsible for Creating the Object USNAM
InquiryLastChangedByUser User Who Last Changed the Business Document USNAM
SalesInquiryLastChangeDays Sales Inquiry Last Change Days INT4
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
InquiryPurchaseOrderByCustomer Customer Reference BSTKD
SalesInquiryValidityDays Sales Inquiry Validity Days INT4
InquiryPriceDethExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
SalesInquiryCondition Number of the Document Condition KNUMV
InquiryIncoTransferLocation Incoterms (Part 2) INCO2
InquiryIncotermsLocation1 Incoterms Location 1 INCO_L
InquiryIncotermsLocation2 Incoterms Location 2 INCO_L
InquiryCustomerPaymentTerms Terms of payment key ZTERM
InquiryAdditionalValueDays Additional Value Days TAGE2
InquiryFiscalYear Fiscal Year GJAHR
InquiryFiscalPeriod Posting period POPER
InquiryCostCenter Cost Center KOSTL
InquiryReferenceSDDocument Document number of the reference document VBELN
InquiryItemCreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesInquiryItemLastChangeDays Sales Inquiry Item Last Change Days INT4
InquiryItemMaterialByCustomer Material Number Used by Customer IDNEX
InqItemIntArticleNumber International Article Number (EAN/UPC) EAN11
InqItemProductConfiguration Configuration CUOBJ
SalesInquiryItemText Short text for sales order item TEXT40
InqItmPurchaseOrderByCustomer Customer Reference BSTKD
InqUnderlyingPurchaseOrderItem Item Number of the Underlying Purchase Order POSEX
InqItmOrdToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
InqItmOrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
InquiryItemAlternativeToItem Item for Which this Item is an Alternative GRPOS
InqItemPriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
InquiryItemNetPriceQuantity Condition Pricing Unit KPEIN
InqItmIncoTransferLocation Incoterms (Part 2) INCO2
InquiryItemIncotermsLocation1 Incoterms Location 1 INCO_L
InquiryItemIncotermsLocation2 Incoterms Location 2 INCO_L
InqItemCustomerPaymentTerms Terms of payment key ZTERM
InquiryItemAdditionalValueDays Additional Value Days TAGE2
InquiryItemFiscalYear Fiscal Year GJAHR
InquiryItemFiscalPeriod Posting period POPER
InquiryItemProfitCenter Profit Center PRCTR
InqItemProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
InquiryItemOriginSDDocument Originating Document VBELN
InqItemOriginSDDocumentItem Originating Item POSNR
InquiryItemReferenceSDDocument Document number of the reference document VBELN
InqItemReferenceSDDocumentItem Item number of the reference item POSNR
InquiryItemHigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
ShipToParty Ship-to Party KUNNR
SoldToParty Sold-to Party KUNNR
SoldtoPartyName Name of Customer TEXT80
CustomerFullName Customer Full Name TEXT220
SoldToPartyCreatedByUser Name of Person who Created the Object USNAM
AddressID Address ADRNR
VATRegistration VAT Registration Number STCEG
AuthorizationGroup Authorization Group BRGRU
InternationalLocationNumber1 International location number (part 1) NUM07
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
TaxNumber4 Tax Number 4 CHAR18
TaxNumber5 Tax Number 5 CHAR60
CustomerCorporateGroup Group key KONZS
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CityName City TEXT35
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
ResponsibleEmployeePersonnelID Employee Responsible PERNR
ResponsibleEmployeeInternalID Business Partner Number BU_PARTNER
ResponsibleEmployeeID Work Agreement External ID CHAR20
RespEmployeeValidityDays Resp Employee Validity Days INT4
ResponsibleEmployeeFamilyName Last name of business partner (person) BU_NAME
ResponsibleEmployeeFirstName First name of business partner (person) BU_NAME
ResponsibleEmployeeGivenName First name of business partner (person) BU_NAME
ResponsibleEmployeeMiddleName Middle name or second forename of a person BU_NAME
RespEmployeeAddFamilyName Other Last Name of a Person BU_NAME
ResponsibleEmployeeInitials "Middle Initial" or personal initials CHAR10
ResponsibleEmployeeFullName Full Name TEXT80
ResponsibleEmployeeGenderCode null
ResponsibleEmployeePerson Business Partner Number BU_PARTNER
RespEmployeeBusinessUser null
RespEmployeeImageURL null
RespEmployeeCreatedByUser User who created the object USNAM
RespEmployeeLastChangedByUser Last user to change object USNAM
RespEmployeeLastChangeDays Resp Employee Last Change Days INT4
SalesEmployeePersonnelID Sales Employee PERNR
SalesEmployeeInternalID Business Partner Number BU_PARTNER
SalesEmployeeID Work Agreement External ID CHAR20
SalesEmployeeValidityDays Sales Employee Validity Days INT4
SalesEmployeeFamilyName Last name of business partner (person) BU_NAME
SalesEmployeeFirstName First name of business partner (person) BU_NAME
SalesEmployeeGivenName First name of business partner (person) BU_NAME
SalesEmployeeMiddleName Middle name or second forename of a person BU_NAME
SalesEmployeeAddFamilyName Other Last Name of a Person BU_NAME
SalesEmployeeInitials "Middle Initial" or personal initials CHAR10
SalesEmployeeFullName Full Name TEXT80
SalesEmployeeGenderCode null
SalesEmployeePerson Business Partner Number BU_PARTNER
SalesEmployeeBusinessUser null
SalesEmployeeImageURL null
SalesEmployeeCreatedByUser User who created the object USNAM
SalesEmployeeLastChangedByUser Last user to change object USNAM
SalesEmployeeLastChangeDays Sales Employee Last Change Days INT4
MaterialManufacturerPartNumber Manufacturer Part Number CHAR40
MTRAuthorizationGroup Authorization Group BEGRU
OriMTRManuFacturerPartNumber Manufacturer Part Number CHAR40
OriMTRAuthorizationGroup Authorization Group BEGRU
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
SalesQuotationItemText Short text for sales order item TEXT40
NetPriceQuantity Condition Pricing Unit KPEIN
SlsQtanConversionRate Sales Quotation Conversion Rate SLSQTANCONVERSIONRATE
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • Customer Group 1
  • P_SLSQTANPRDTVDATA.MANDT == TVV1.MANDT
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Customer Group 2
  • Client
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP2 == TVV2.KVGR2
  • P_SLSQTANPRDTVDATA.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • Customer Group 3
  • P_SLSQTANPRDTVDATA.MANDT == TVV3.MANDT
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • Customer Group 4
  • P_SLSQTANPRDTVDATA.MANDT == TVV4.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP4 == TVV4.KVGR4
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • Customer Group 5
  • P_SLSQTANPRDTVDATA.MANDT == TVV5.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP5 == TVV5.KVGR5
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Account Number of an Alternative Payer
  • Account Number of an Alternative Payer
  • Client
  • P_SLSQTANPRDTVDATA.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
  • P_SLSQTANPRDTVDATA.MANDT == KNA1.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Measure
  • Base Unit of Measure
  • Base Unit of Measure
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMBASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MATERIALBASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.BASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ORIGINALMATERIALBASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • Company Code to Be Billed
  • P_SLSQTANPRDTVDATA.MANDT == T001.MANDT
  • P_SLSQTANPRDTVDATA.BILLINGCOMPANYCODE == T001.BUKRS
  • P_SLSQTANPRDTVDATA.INQUIRYBILLINGCOMPANYCODE == T001.BUKRS
Central billing block for customer
  • Client
  • Central billing block for customer
  • P_SLSQTANPRDTVDATA.MANDT == TVFS.MANDT
  • P_SLSQTANPRDTVDATA.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Business Area
  • Client
  • Business Area
  • Business Area
  • Business Area
  • P_SLSQTANPRDTVDATA.MANDT == TGSB.MANDT
  • P_SLSQTANPRDTVDATA.BUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.INQUIRYBUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.INQUIRYITEMBUSINESSAREA == TGSB.GSBER
Company code of the sales organization
  • Client
  • Company code of the sales organization
  • P_SLSQTANPRDTVDATA.MANDT == T001.MANDT
  • P_SLSQTANPRDTVDATA.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Controlling Area
  • Client
  • P_SLSQTANPRDTVDATA.CONTROLLINGAREA == TKA01.KOKRS
  • P_SLSQTANPRDTVDATA.INQUIRYCONTROLLINGAREA == TKA01.KOKRS
  • P_SLSQTANPRDTVDATA.MANDT == TKA01.MANDT
Business Area from Cost Center
  • Business Area from Cost Center
  • Business Area from Cost Center
  • Client
  • P_SLSQTANPRDTVDATA.COSTCENTERBUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.INQUIRYCOSTCENTERBUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.MANDT == TGSB.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • P_SLSQTANPRDTVDATA.MANDT == T005.MANDT
  • P_SLSQTANPRDTVDATA.COUNTRY == T005.LAND1
Credit control area
  • Client
  • Credit control area
  • P_SLSQTANPRDTVDATA.MANDT == T014.MANDT
  • P_SLSQTANPRDTVDATA.CREDITCONTROLAREA == T014.KKBER
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • P_SLSQTANPRDTVDATA.MANDT == TVKT.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • P_SLSQTANPRDTVDATA.INQCUSTACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • P_SLSQTANPRDTVDATA.INQITMCUSTACCTASSIGNMENTGROUP == TVKT.KTGRD
Customer Account Group
  • Client
  • Customer Account Group
  • P_SLSQTANPRDTVDATA.MANDT == T077D.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • P_SLSQTANPRDTVDATA.MANDT == TKUKL.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Customer Group
  • Client
  • Customer Group
  • Customer Group
  • P_SLSQTANPRDTVDATA.MANDT == T151.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERGROUP == T151.KDGRP
  • P_SLSQTANPRDTVDATA.INQUIRYCUSTOMERGROUP == T151.KDGRP
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • Customer Purchase Order Type
  • P_SLSQTANPRDTVDATA.MANDT == T176.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • P_SLSQTANPRDTVDATA.INQUIRYCUSTPURCHASEORDERTYPE == T176.BSARK
Agreement (various conditions grouped together)
  • Client
  • Agreement (various conditions grouped together)
  • P_SLSQTANPRDTVDATA.MANDT == KONA.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • P_SLSQTANPRDTVDATA.MANDT == TVLS.MANDT
  • P_SLSQTANPRDTVDATA.DELIVERYISBLOCKED == TVLS.LIFSP
Division
  • Client
  • Division
  • Division
  • Division
  • P_SLSQTANPRDTVDATA.MANDT == TSPA.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYORAGANIZATIONDIVISION == TSPA.SPART
  • P_SLSQTANPRDTVDATA.DIVISION == TSPA.SPART
  • P_SLSQTANPRDTVDATA.INQUIRYITEMDIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • Exchange Rate Type
  • P_SLSQTANPRDTVDATA.MANDT == TCURV.MANDT
  • P_SLSQTANPRDTVDATA.EXCHANGERATETYPE == TCURV.KURST
  • P_SLSQTANPRDTVDATA.INQUIRYEXCHANGERATETYPE == TCURV.KURST
Account number of the master record with the fiscal address
  • Client
  • Account number of the master record with the fiscal address
  • P_SLSQTANPRDTVDATA.MANDT == KNA1.MANDT
  • P_SLSQTANPRDTVDATA.FISCALADDRESS == KNA1.KUNNR
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • Billing Block in SD Document
  • P_SLSQTANPRDTVDATA.MANDT == TVFS.MANDT
  • P_SLSQTANPRDTVDATA.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • P_SLSQTANPRDTVDATA.INQHEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • P_SLSQTANPRDTVDATA.MANDT == TINC.MANDT
  • P_SLSQTANPRDTVDATA.INCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SLSQTANPRDTVDATA.INQITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SLSQTANPRDTVDATA.INQUIRYINCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • Incoterms Version
  • Incoterms Version
  • P_SLSQTANPRDTVDATA.MANDT == TINCV.MANDT
  • P_SLSQTANPRDTVDATA.INCOTERMSVERSION == TINCV.INCOV
  • P_SLSQTANPRDTVDATA.INQUIRYITEMINCOTERMSVERSION == TINCV.INCOV
  • P_SLSQTANPRDTVDATA.INQUIRYINCOTERMSVERSION == TINCV.INCOV
Industry key
  • Client
  • Industry key
  • P_SLSQTANPRDTVDATA.MANDT == T016.MANDT
  • P_SLSQTANPRDTVDATA.INDUSTRY == T016.BRSCH
Industry code 1
  • Client
  • Industry code 1
  • P_SLSQTANPRDTVDATA.MANDT == TBRC.MANDT
  • P_SLSQTANPRDTVDATA.INDUSTRYCODE1 == TBRC.BRACO
Industry code 2
  • Client
  • Industry code 2
  • P_SLSQTANPRDTVDATA.MANDT == TBRC.MANDT
  • P_SLSQTANPRDTVDATA.INDUSTRYCODE2 == TBRC.BRACO
Industry code 3
  • Client
  • Industry code 3
  • P_SLSQTANPRDTVDATA.MANDT == TBRC.MANDT
  • P_SLSQTANPRDTVDATA.INDUSTRYCODE3 == TBRC.BRACO
Industry code 4
  • Client
  • Industry code 4
  • P_SLSQTANPRDTVDATA.MANDT == TBRC.MANDT
  • P_SLSQTANPRDTVDATA.INDUSTRYCODE4 == TBRC.BRACO
Industry code 5
  • Client
  • Industry code 5
  • P_SLSQTANPRDTVDATA.MANDT == TBRC.MANDT
  • P_SLSQTANPRDTVDATA.INDUSTRYCODE5 == TBRC.BRACO
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • P_SLSQTANPRDTVDATA.MANDT == TVKT.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • P_SLSQTANPRDTVDATA.INQCUSTACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • P_SLSQTANPRDTVDATA.INQITMCUSTACCTASSIGNMENTGROUP == TVKT.KTGRD
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • Billing Block in SD Document
  • P_SLSQTANPRDTVDATA.MANDT == TVFS.MANDT
  • P_SLSQTANPRDTVDATA.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • P_SLSQTANPRDTVDATA.INQHEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • P_SLSQTANPRDTVDATA.MANDT == TINC.MANDT
  • P_SLSQTANPRDTVDATA.INCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SLSQTANPRDTVDATA.INQITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SLSQTANPRDTVDATA.INQUIRYINCOTERMSCLASSIFICATION == TINC.INCO1
Reason for material substitution
  • Client
  • Reason for material substitution
  • P_SLSQTANPRDTVDATA.MANDT == TVSU.MANDT
  • P_SLSQTANPRDTVDATA.INQITEMMTRSUBSTITUTIONREASON == TVSU.SUGRD
Condition Unit
  • Condition Unit
  • Condition Unit
  • Client
  • P_SLSQTANPRDTVDATA.INQITEMNETPRICEQUANTITYUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.NETPRICEQUANTITYUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
Material Entered
  • Client
  • Material Entered
  • Material Entered
  • P_SLSQTANPRDTVDATA.MANDT == MARA.MANDT
  • P_SLSQTANPRDTVDATA.INQITEMORIGINALLYREQUESTEDMTR == MARA.MATNR
  • P_SLSQTANPRDTVDATA.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Product hierarchy: order item
  • Client
  • Product hierarchy
  • P_SLSQTANPRDTVDATA.MANDT == T179.MANDT
  • P_SLSQTANPRDTVDATA.INQITEMPRODUCTHIERARCHYNODE == T179.PRODH
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • P_SLSQTANPRDTVDATA.MANDT == TVAG.MANDT
  • P_SLSQTANPRDTVDATA.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • P_SLSQTANPRDTVDATA.INQITEMSALESDOCUMENTRJCNREASON == TVAG.ABGRU
Material Group 1
  • Client
  • Material Group 1
  • P_SLSQTANPRDTVDATA.MANDT == TVM1.MANDT
  • P_SLSQTANPRDTVDATA.INQITMADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • P_SLSQTANPRDTVDATA.MANDT == TVM2.MANDT
  • P_SLSQTANPRDTVDATA.INQITMADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • P_SLSQTANPRDTVDATA.MANDT == TVM3.MANDT
  • P_SLSQTANPRDTVDATA.INQITMADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • P_SLSQTANPRDTVDATA.MANDT == TVM4.MANDT
  • P_SLSQTANPRDTVDATA.INQITMADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • P_SLSQTANPRDTVDATA.MANDT == TVM5.MANDT
  • P_SLSQTANPRDTVDATA.INQITMADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • P_SLSQTANPRDTVDATA.MANDT == TVKT.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • P_SLSQTANPRDTVDATA.INQCUSTACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • P_SLSQTANPRDTVDATA.INQITMCUSTACCTASSIGNMENTGROUP == TVKT.KTGRD
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • Special Stock Indicator
  • P_SLSQTANPRDTVDATA.MANDT == T148.MANDT
  • P_SLSQTANPRDTVDATA.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • P_SLSQTANPRDTVDATA.INQITMINVTORYSPECIALSTOCKTYPE == T148.SOBKZ
Customer Group 1
  • Client
  • Customer Group 1
  • Customer Group 1
  • P_SLSQTANPRDTVDATA.MANDT == TVV1.MANDT
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Customer Group 2
  • Client
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP2 == TVV2.KVGR2
  • P_SLSQTANPRDTVDATA.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • Customer Group 3
  • P_SLSQTANPRDTVDATA.MANDT == TVV3.MANDT
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • Customer Group 4
  • P_SLSQTANPRDTVDATA.MANDT == TVV4.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP4 == TVV4.KVGR4
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • Customer Group 5
  • P_SLSQTANPRDTVDATA.MANDT == TVV5.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYADDCUSTOMERGROUP5 == TVV5.KVGR5
  • P_SLSQTANPRDTVDATA.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • Company Code to Be Billed
  • P_SLSQTANPRDTVDATA.MANDT == T001.MANDT
  • P_SLSQTANPRDTVDATA.BILLINGCOMPANYCODE == T001.BUKRS
  • P_SLSQTANPRDTVDATA.INQUIRYBILLINGCOMPANYCODE == T001.BUKRS
Business Area
  • Client
  • Business Area
  • Business Area
  • Business Area
  • P_SLSQTANPRDTVDATA.MANDT == TGSB.MANDT
  • P_SLSQTANPRDTVDATA.BUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.INQUIRYBUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.INQUIRYITEMBUSINESSAREA == TGSB.GSBER
Controlling Area
  • Controlling Area
  • Controlling Area
  • Client
  • P_SLSQTANPRDTVDATA.CONTROLLINGAREA == TKA01.KOKRS
  • P_SLSQTANPRDTVDATA.INQUIRYCONTROLLINGAREA == TKA01.KOKRS
  • P_SLSQTANPRDTVDATA.MANDT == TKA01.MANDT
Business Area from Cost Center
  • Business Area from Cost Center
  • Business Area from Cost Center
  • Client
  • P_SLSQTANPRDTVDATA.COSTCENTERBUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.INQUIRYCOSTCENTERBUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.MANDT == TGSB.MANDT
Customer Group
  • Client
  • Customer Group
  • Customer Group
  • P_SLSQTANPRDTVDATA.MANDT == T151.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERGROUP == T151.KDGRP
  • P_SLSQTANPRDTVDATA.INQUIRYCUSTOMERGROUP == T151.KDGRP
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • Customer Purchase Order Type
  • P_SLSQTANPRDTVDATA.MANDT == T176.MANDT
  • P_SLSQTANPRDTVDATA.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • P_SLSQTANPRDTVDATA.INQUIRYCUSTPURCHASEORDERTYPE == T176.BSARK
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • P_SLSQTANPRDTVDATA.MANDT == TVKOV.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYDSITRIBUTIONCHANNEL == TVKOV.VTWEG
  • P_SLSQTANPRDTVDATA.INQUIRYSALESORGANIZATION == TVKOV.VKORG
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • Exchange Rate Type
  • P_SLSQTANPRDTVDATA.MANDT == TCURV.MANDT
  • P_SLSQTANPRDTVDATA.EXCHANGERATETYPE == TCURV.KURST
  • P_SLSQTANPRDTVDATA.INQUIRYEXCHANGERATETYPE == TCURV.KURST
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • P_SLSQTANPRDTVDATA.MANDT == TINC.MANDT
  • P_SLSQTANPRDTVDATA.INCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SLSQTANPRDTVDATA.INQITEMINCOTERMSCLASSIFICATION == TINC.INCO1
  • P_SLSQTANPRDTVDATA.INQUIRYINCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • Incoterms Version
  • Incoterms Version
  • P_SLSQTANPRDTVDATA.MANDT == TINCV.MANDT
  • P_SLSQTANPRDTVDATA.INCOTERMSVERSION == TINCV.INCOV
  • P_SLSQTANPRDTVDATA.INQUIRYITEMINCOTERMSVERSION == TINCV.INCOV
  • P_SLSQTANPRDTVDATA.INQUIRYINCOTERMSVERSION == TINCV.INCOV
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Measure
  • Base Unit of Measure
  • Base Unit of Measure
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMBASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MATERIALBASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.BASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ORIGINALMATERIALBASEUNIT == T006.MSEHI
Batch Number
  • Client
  • ?
  • Batch Number
  • Material Number
  • Material Number
  • P_SLSQTANPRDTVDATA.MANDT == MCHA.MANDT
  • P_SLSQTANPRDTVDATA.[column in domain "WERKS_D"] == MCHA.WERKS
  • P_SLSQTANPRDTVDATA.INQUIRYITEMBATCH == MCHA.CHARG
  • P_SLSQTANPRDTVDATA.INQUIRYITEMMATERIAL == MCHA.MATNR
  • P_SLSQTANPRDTVDATA.MATERIAL == MCHA.MATNR
Business Area
  • Client
  • Business Area
  • Business Area
  • Business Area
  • P_SLSQTANPRDTVDATA.MANDT == TGSB.MANDT
  • P_SLSQTANPRDTVDATA.BUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.INQUIRYBUSINESSAREA == TGSB.GSBER
  • P_SLSQTANPRDTVDATA.INQUIRYITEMBUSINESSAREA == TGSB.GSBER
Customer Group
  • Client
  • Customer Group
  • P_SLSQTANPRDTVDATA.MANDT == T151.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMCUSTOMERGROUP == T151.KDGRP
Division
  • Client
  • Division
  • Division
  • Division
  • P_SLSQTANPRDTVDATA.MANDT == TSPA.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYORAGANIZATIONDIVISION == TSPA.SPART
  • P_SLSQTANPRDTVDATA.DIVISION == TSPA.SPART
  • P_SLSQTANPRDTVDATA.INQUIRYITEMDIVISION == TSPA.SPART
Incoterms Version
  • Client
  • Incoterms Version
  • Incoterms Version
  • Incoterms Version
  • P_SLSQTANPRDTVDATA.MANDT == TINCV.MANDT
  • P_SLSQTANPRDTVDATA.INCOTERMSVERSION == TINCV.INCOV
  • P_SLSQTANPRDTVDATA.INQUIRYITEMINCOTERMSVERSION == TINCV.INCOV
  • P_SLSQTANPRDTVDATA.INQUIRYINCOTERMSVERSION == TINCV.INCOV
Material: order item
  • Client
  • Material Number
  • Material Number
  • P_SLSQTANPRDTVDATA.MANDT == MARA.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMMATERIAL == MARA.MATNR
  • P_SLSQTANPRDTVDATA.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • Material Group
  • P_SLSQTANPRDTVDATA.MANDT == T023.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMMATERIALGROUP == T023.MATKL
  • P_SLSQTANPRDTVDATA.MATERIALGROUP == T023.MATKL
Payment Method
  • ?
  • Client
  • Payment Method
  • Payment Method
  • Payment Method
  • P_SLSQTANPRDTVDATA.[column in domain "LAND1"] == T042Z.LAND1
  • P_SLSQTANPRDTVDATA.MANDT == T042Z.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMPAYMENTMETHOD == T042Z.ZLSCH
  • P_SLSQTANPRDTVDATA.INQUIRYPAYMENTMETHOD == T042Z.ZLSCH
  • P_SLSQTANPRDTVDATA.PAYMENTMETHOD == T042Z.ZLSCH
Product Catalog
  • Client
  • Product catalog number
  • Product catalog number
  • Product catalog number
  • P_SLSQTANPRDTVDATA.MANDT == WWMI.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMPRODUCTCATALOG == WWMI.WMINR
  • P_SLSQTANPRDTVDATA.INQUIRYPRODUCTCATALOG == WWMI.WMINR
  • P_SLSQTANPRDTVDATA.PRODUCTCATALOG == WWMI.WMINR
Retail promotion
  • Client
  • Promotion
  • Promotion
  • Promotion
  • P_SLSQTANPRDTVDATA.MANDT == WAKH.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYRETAILPROMOTION == WAKH.AKTNR
  • P_SLSQTANPRDTVDATA.INQUIRYITEMRETAILPROMOTION == WAKH.AKTNR
  • P_SLSQTANPRDTVDATA.RETAILPROMOTION == WAKH.AKTNR
Sales Deal
  • Client
  • Sales Deal
  • P_SLSQTANPRDTVDATA.MANDT == KONA.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMSALESDEAL == KONA.KNUMA
Sales District
  • Sales District
  • Client
  • P_SLSQTANPRDTVDATA.INQUIRYITEMSALESDISTRICT == T171.BZIRK
  • P_SLSQTANPRDTVDATA.MANDT == T171.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • P_SLSQTANPRDTVDATA.INQUIRYITEMSALESPROMOTION == KONA.KNUMA
  • P_SLSQTANPRDTVDATA.MANDT == KONA.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • SD Document Currency
  • SD Document Currency
  • P_SLSQTANPRDTVDATA.MANDT == TCURC.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYTRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.ITEMTRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.INQUIRYITEMTRANSACTIONCURRENCY == TCURC.WAERS
Volume unit
  • Client
  • Volume unit
  • Volume unit
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMVOLUMEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Weight Unit
  • Weight Unit
  • Weight Unit
  • Client
  • P_SLSQTANPRDTVDATA.ORIGINALMATERIALWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ITEMWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.INQUIRYITEMWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MATERIALWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Division
  • Division
  • Sales Organization
  • P_SLSQTANPRDTVDATA.MANDT == TVTA.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYDSITRIBUTIONCHANNEL == TVTA.VTWEG
  • P_SLSQTANPRDTVDATA.INQUIRYORAGANIZATIONDIVISION == TVTA.SPART
  • P_SLSQTANPRDTVDATA.DIVISION == TVTA.SPART
  • P_SLSQTANPRDTVDATA.INQUIRYITEMDIVISION == TVTA.SPART
  • P_SLSQTANPRDTVDATA.INQUIRYSALESORGANIZATION == TVTA.VKORG
Payment Method
  • ?
  • Client
  • Payment Method
  • Payment Method
  • Payment Method
  • P_SLSQTANPRDTVDATA.[column in domain "LAND1"] == T042Z.LAND1
  • P_SLSQTANPRDTVDATA.MANDT == T042Z.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMPAYMENTMETHOD == T042Z.ZLSCH
  • P_SLSQTANPRDTVDATA.INQUIRYPAYMENTMETHOD == T042Z.ZLSCH
  • P_SLSQTANPRDTVDATA.PAYMENTMETHOD == T042Z.ZLSCH
Product Catalog
  • Client
  • Product catalog number
  • Product catalog number
  • Product catalog number
  • P_SLSQTANPRDTVDATA.MANDT == WWMI.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMPRODUCTCATALOG == WWMI.WMINR
  • P_SLSQTANPRDTVDATA.INQUIRYPRODUCTCATALOG == WWMI.WMINR
  • P_SLSQTANPRDTVDATA.PRODUCTCATALOG == WWMI.WMINR
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • P_SLSQTANPRDTVDATA.MANDT == TVAU.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYREASON == TVAU.AUGRU
Retail promotion
  • Client
  • Promotion
  • Promotion
  • Promotion
  • P_SLSQTANPRDTVDATA.MANDT == WAKH.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYRETAILPROMOTION == WAKH.AKTNR
  • P_SLSQTANPRDTVDATA.INQUIRYITEMRETAILPROMOTION == WAKH.AKTNR
  • P_SLSQTANPRDTVDATA.RETAILPROMOTION == WAKH.AKTNR
Sales District
  • Client
  • Sales District
  • Sales District
  • P_SLSQTANPRDTVDATA.MANDT == T171.MANDT
  • P_SLSQTANPRDTVDATA.SALESDISTRICT == T171.BZIRK
  • P_SLSQTANPRDTVDATA.INQUIRYSALESDISTRICT == T171.BZIRK
Sales group
  • Client
  • Sales office
  • Sales group
  • P_SLSQTANPRDTVDATA.MANDT == TVBVK.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYSALESOFFICE == TVBVK.VKBUR
  • P_SLSQTANPRDTVDATA.INQUIRYSALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • P_SLSQTANPRDTVDATA.MANDT == TVKO.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYSALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • Customer number for intercompany billing
  • P_SLSQTANPRDTVDATA.MANDT == KNA1.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYSOLDTOPARTY == KNA1.KUNNR
  • P_SLSQTANPRDTVDATA.INTERCOMPANYBILLINGCUSTOMER == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • SD Document Currency
  • SD Document Currency
  • SD Document Currency
  • P_SLSQTANPRDTVDATA.MANDT == TCURC.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYTRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.ITEMTRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.INQUIRYITEMTRANSACTIONCURRENCY == TCURC.WAERS
Customer number for intercompany billing
  • Client
  • Sold-to Party
  • Customer number for intercompany billing
  • P_SLSQTANPRDTVDATA.MANDT == KNA1.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYSOLDTOPARTY == KNA1.KUNNR
  • P_SLSQTANPRDTVDATA.INTERCOMPANYBILLINGCUSTOMER == KNA1.KUNNR
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • Special Stock Indicator
  • P_SLSQTANPRDTVDATA.MANDT == T148.MANDT
  • P_SLSQTANPRDTVDATA.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • P_SLSQTANPRDTVDATA.INQITMINVTORYSPECIALSTOCKTYPE == T148.SOBKZ
SD Document Currency
  • Client
  • SD Document Currency
  • SD Document Currency
  • SD Document Currency
  • SD Document Currency
  • P_SLSQTANPRDTVDATA.MANDT == TCURC.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYTRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.ITEMTRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.INQUIRYITEMTRANSACTIONCURRENCY == TCURC.WAERS
Volume unit
  • Client
  • Volume unit
  • Volume unit
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMVOLUMEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Weight Unit
  • Weight Unit
  • Weight Unit
  • Client
  • P_SLSQTANPRDTVDATA.ORIGINALMATERIALWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ITEMWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.INQUIRYITEMWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MATERIALWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
Language Key P_SLSQTANPRDTVDATA.LANGUAGE == T002.SPRAS
Material: order item
  • Client
  • Material Number
  • Material Number
  • P_SLSQTANPRDTVDATA.MANDT == MARA.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMMATERIAL == MARA.MATNR
  • P_SLSQTANPRDTVDATA.MATERIAL == MARA.MATNR
Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Measure
  • Base Unit of Measure
  • Base Unit of Measure
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMBASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MATERIALBASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.BASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ORIGINALMATERIALBASEUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • Material Group
  • P_SLSQTANPRDTVDATA.MANDT == T023.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMMATERIALGROUP == T023.MATKL
  • P_SLSQTANPRDTVDATA.MATERIALGROUP == T023.MATKL
Manufacturer Number
  • Client
  • Manufacturer number
  • Manufacturer number
  • P_SLSQTANPRDTVDATA.MANDT == LFA1.MANDT
  • P_SLSQTANPRDTVDATA.ORIMATERIALMANUFACTURERNUMBER == LFA1.LIFNR
  • P_SLSQTANPRDTVDATA.MATERIALMANUFACTURERNUMBER == LFA1.LIFNR
Unit of Weight
  • Weight Unit
  • Weight Unit
  • Weight Unit
  • Weight Unit
  • Client
  • P_SLSQTANPRDTVDATA.ORIGINALMATERIALWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ITEMWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.INQUIRYITEMWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MATERIALWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
Condition Unit
  • Condition Unit
  • Condition Unit
  • Client
  • P_SLSQTANPRDTVDATA.INQITEMNETPRICEQUANTITYUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.NETPRICEQUANTITYUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
Nielsen ID
  • Client
  • Nielsen ID
  • P_SLSQTANPRDTVDATA.MANDT == TNLS.MANDT
  • P_SLSQTANPRDTVDATA.NIELSENREGION == TNLS.NIELS
Central order block for customer
  • ?
  • Client
  • Central order block for customer
  • P_SLSQTANPRDTVDATA.[column in domain "SPRAS"] == TVAST.SPRAS
  • P_SLSQTANPRDTVDATA.MANDT == TVAST.MANDT
  • P_SLSQTANPRDTVDATA.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
Sales unit
  • Client
  • Sales unit
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVDATA.ORDERQUANTITYUNIT == T006.MSEHI
Material Entered
  • Client
  • Material Entered
  • Material Entered
  • P_SLSQTANPRDTVDATA.MANDT == MARA.MANDT
  • P_SLSQTANPRDTVDATA.INQITEMORIGINALLYREQUESTEDMTR == MARA.MATNR
  • P_SLSQTANPRDTVDATA.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Measure
  • Base Unit of Measure
  • Base Unit of Measure
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMBASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MATERIALBASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.BASEUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ORIGINALMATERIALBASEUNIT == T006.MSEHI
Unit of Weight
  • Weight Unit
  • Weight Unit
  • Weight Unit
  • Weight Unit
  • Client
  • P_SLSQTANPRDTVDATA.ORIGINALMATERIALWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.ITEMWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.INQUIRYITEMWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MATERIALWEIGHTUNIT == T006.MSEHI
  • P_SLSQTANPRDTVDATA.MANDT == T006.MANDT
Manufacturer Number
  • Client
  • Manufacturer number
  • Manufacturer number
  • P_SLSQTANPRDTVDATA.MANDT == LFA1.MANDT
  • P_SLSQTANPRDTVDATA.ORIMATERIALMANUFACTURERNUMBER == LFA1.LIFNR
  • P_SLSQTANPRDTVDATA.MATERIALMANUFACTURERNUMBER == LFA1.LIFNR
Payment Method
  • ?
  • Client
  • Payment Method
  • Payment Method
  • Payment Method
  • P_SLSQTANPRDTVDATA.[column in domain "LAND1"] == T042Z.LAND1
  • P_SLSQTANPRDTVDATA.MANDT == T042Z.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMPAYMENTMETHOD == T042Z.ZLSCH
  • P_SLSQTANPRDTVDATA.INQUIRYPAYMENTMETHOD == T042Z.ZLSCH
  • P_SLSQTANPRDTVDATA.PAYMENTMETHOD == T042Z.ZLSCH
Product Catalog
  • Client
  • Product catalog number
  • Product catalog number
  • Product catalog number
  • P_SLSQTANPRDTVDATA.MANDT == WWMI.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYITEMPRODUCTCATALOG == WWMI.WMINR
  • P_SLSQTANPRDTVDATA.INQUIRYPRODUCTCATALOG == WWMI.WMINR
  • P_SLSQTANPRDTVDATA.PRODUCTCATALOG == WWMI.WMINR
BP Role
  • Client
  • BP Role
  • BP Role
  • P_SLSQTANPRDTVDATA.MANDT == TB003.CLIENT
  • P_SLSQTANPRDTVDATA.RESPEMPLBUSINESSPARTNERROLE == TB003.ROLE
  • P_SLSQTANPRDTVDATA.SALESEMPLBUSINESSPARTNERROLE == TB003.ROLE
Academic Title: Key
  • Client
  • Academic Title: Key
  • Academic Title: Key
  • P_SLSQTANPRDTVDATA.MANDT == TSAD2.CLIENT
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEACADEMICTITLE == TSAD2.TITLE_KEY
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEEACADEMICTITLE == TSAD2.TITLE_KEY
Authorization Group
  • ?
  • Authorization Group
  • Authorization Group
  • Client
  • P_SLSQTANPRDTVDATA.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • P_SLSQTANPRDTVDATA.SALESEMPLAUTHORIZATIONGROUP == TB037.AUGRP
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEAUTHORIZATIONGROUP == TB037.AUGRP
  • P_SLSQTANPRDTVDATA.MANDT == TB037.CLIENT
Correspondence Language
  • Business Partner: Correspondence Language
  • Business Partner: Correspondence Language
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEECORRLANGUAGE == T002.SPRAS
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEECORLANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEFAMILYNAMEPREFIX == TSAD4.PREFIX_KEY
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEEFAMILYNAMEPREFIX == TSAD4.PREFIX_KEY
  • P_SLSQTANPRDTVDATA.MANDT == TSAD4.CLIENT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • Form-of-Address Key
  • P_SLSQTANPRDTVDATA.MANDT == TSAD3.CLIENT
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEFORMOFADDRESS == TSAD3.TITLE
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEEFORMOFADDRESS == TSAD3.TITLE
Address key assignment to users
  • Client
  • User ID
  • User ID
  • P_SLSQTANPRDTVDATA.MANDT == USR02.MANDT
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEUSERID == USR02.BNAME
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEEUSERID == USR02.BNAME
Tax Type
  • Client
  • ?
  • Tax type
  • P_SLSQTANPRDTVDATA.MANDT == J_1AFITP.MANDT
  • P_SLSQTANPRDTVDATA.[column in domain "KOART"] == J_1AFITP.KOART
  • P_SLSQTANPRDTVDATA.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
Retail promotion
  • Client
  • Promotion
  • Promotion
  • Promotion
  • P_SLSQTANPRDTVDATA.MANDT == WAKH.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYRETAILPROMOTION == WAKH.AKTNR
  • P_SLSQTANPRDTVDATA.INQUIRYITEMRETAILPROMOTION == WAKH.AKTNR
  • P_SLSQTANPRDTVDATA.RETAILPROMOTION == WAKH.AKTNR
Sales District
  • Client
  • Sales District
  • Sales District
  • P_SLSQTANPRDTVDATA.MANDT == T171.MANDT
  • P_SLSQTANPRDTVDATA.SALESDISTRICT == T171.BZIRK
  • P_SLSQTANPRDTVDATA.INQUIRYSALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • P_SLSQTANPRDTVDATA.MANDT == TVAG.MANDT
  • P_SLSQTANPRDTVDATA.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • P_SLSQTANPRDTVDATA.INQITEMSALESDOCUMENTRJCNREASON == TVAG.ABGRU
Authorization Group
  • ?
  • Authorization Group
  • Authorization Group
  • Client
  • P_SLSQTANPRDTVDATA.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • P_SLSQTANPRDTVDATA.SALESEMPLAUTHORIZATIONGROUP == TB037.AUGRP
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEAUTHORIZATIONGROUP == TB037.AUGRP
  • P_SLSQTANPRDTVDATA.MANDT == TB037.CLIENT
BP Role
  • Client
  • BP Role
  • BP Role
  • P_SLSQTANPRDTVDATA.MANDT == TB003.CLIENT
  • P_SLSQTANPRDTVDATA.RESPEMPLBUSINESSPARTNERROLE == TB003.ROLE
  • P_SLSQTANPRDTVDATA.SALESEMPLBUSINESSPARTNERROLE == TB003.ROLE
Academic Title: Key
  • Client
  • Academic Title: Key
  • Academic Title: Key
  • P_SLSQTANPRDTVDATA.MANDT == TSAD2.CLIENT
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEACADEMICTITLE == TSAD2.TITLE_KEY
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEEACADEMICTITLE == TSAD2.TITLE_KEY
Correspondence Language
  • Business Partner: Correspondence Language
  • Business Partner: Correspondence Language
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEECORRLANGUAGE == T002.SPRAS
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEECORLANGUAGE == T002.SPRAS
Name Prefix (Key)
  • Name Prefix (Key)
  • Name Prefix (Key)
  • Client
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEFAMILYNAMEPREFIX == TSAD4.PREFIX_KEY
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEEFAMILYNAMEPREFIX == TSAD4.PREFIX_KEY
  • P_SLSQTANPRDTVDATA.MANDT == TSAD4.CLIENT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • Form-of-Address Key
  • P_SLSQTANPRDTVDATA.MANDT == TSAD3.CLIENT
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEFORMOFADDRESS == TSAD3.TITLE
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEEFORMOFADDRESS == TSAD3.TITLE
Address key assignment to users
  • Client
  • User ID
  • User ID
  • P_SLSQTANPRDTVDATA.MANDT == USR02.MANDT
  • P_SLSQTANPRDTVDATA.RESPEMPLOYEEUSERID == USR02.BNAME
  • P_SLSQTANPRDTVDATA.SALESEMPLOYEEUSERID == USR02.BNAME
Order type in order header
  • Client
  • Sales Document Type
  • P_SLSQTANPRDTVDATA.MANDT == TVAK.MANDT
  • P_SLSQTANPRDTVDATA.SALESINQUIRYTYPE == TVAK.AUART
Statistics currency
  • Client
  • Statistics currency
  • P_SLSQTANPRDTVDATA.MANDT == TCURC.MANDT
  • P_SLSQTANPRDTVDATA.SALESORGANIZATIONCURRENCY == TCURC.WAERS
Sales document item category
  • Client
  • Sales document item category
  • P_SLSQTANPRDTVDATA.MANDT == TVPT.MANDT
  • P_SLSQTANPRDTVDATA.SALESQUOTATIONITEMCATEGORY == TVPT.PSTYV
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_SLSQTANPRDTVDATA.SUPPLIER == LFA1.LIFNR
  • P_SLSQTANPRDTVDATA.MANDT == LFA1.MANDT
Tax Jurisdiction
  • Client
  • ?
  • Tax Jurisdiction
  • P_SLSQTANPRDTVDATA.MANDT == TTXJ.MANDT
  • P_SLSQTANPRDTVDATA.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • P_SLSQTANPRDTVDATA.TAXJURISDICTION == TTXJ.TXJCD
J_1ATODC
  • Client
  • Tax Number Type
  • P_SLSQTANPRDTVDATA.MANDT == J_1ATODC.MANDT
  • P_SLSQTANPRDTVDATA.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
Currency in order header
  • Client
  • SD Document Currency
  • SD Document Currency
  • SD Document Currency
  • SD Document Currency
  • P_SLSQTANPRDTVDATA.MANDT == TCURC.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYTRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.ITEMTRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_SLSQTANPRDTVDATA.INQUIRYITEMTRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Division
  • Division
  • Division
  • Sales office
  • Sales Organization
  • P_SLSQTANPRDTVDATA.MANDT == TVKBZ.MANDT
  • P_SLSQTANPRDTVDATA.INQUIRYDSITRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_SLSQTANPRDTVDATA.INQUIRYORAGANIZATIONDIVISION == TVKBZ.SPART
  • P_SLSQTANPRDTVDATA.DIVISION == TVKBZ.SPART
  • P_SLSQTANPRDTVDATA.INQUIRYITEMDIVISION == TVKBZ.SPART
  • P_SLSQTANPRDTVDATA.INQUIRYSALESOFFICE == TVKBZ.VKBUR
  • P_SLSQTANPRDTVDATA.INQUIRYSALESORGANIZATION == TVKBZ.VKORG