I_SalesOrderImportFieldList

Field list for Sales Order Import | view: ISLSORDFLDLIST | TRAN | Extraction: Not supported | Component: Sales Document Import from Spreadsheet
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA
Column Name Description
SalesOrder Temporary ID of Sales Order​
SalesOrderItem Temporary ID of Sales Order Item
Column Name Description
Column Name Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
Column Name Description
CustomerPurchaseOrderDate Customer Reference Date
RequestedDeliveryDate Requested Delivery Date
PricingDate Date for Pricing and Exchange Rate
SalesOrderDate Document Date (Date Received/Sent)
FixedValueDate Fixed Value Date
Column Name Description
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
Column Name Description Domain name
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
SalesEmployee Sales Employee PERNR
ResponsibleEmployee Employee Responsible PERNR
PurchaseOrderByCustomer Customer Reference BSTKD
PurchaseOrderByShipToParty Ship-to Party's Customer Reference BSTKD
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AssignmentReference Assignment Number ZUONR
MaterialByCustomer Material Number Used by Customer IDNEX
ProductStandardID Global Trade Item Number (EAN/UPC/GTIN) EAN11
SalesOrderItemText Short text for sales order item TEXT40
Plant Plant (Own or External) WERKS
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
ProfitCenter Profit Center PRCTR
ConditionRateValue Condition Amount VFPRC_DEC_VALUE
ConditionQuantity Condition Pricing Unit KPEIN
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVV1.MANDT
  • I_SALESORDERIMPORTFIELDLIST.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • I_SALESORDERIMPORTFIELDLIST.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_SALESORDERIMPORTFIELDLIST.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • I_SALESORDERIMPORTFIELDLIST.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVV5.MANDT
  • I_SALESORDERIMPORTFIELDLIST.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Batch Number
  • Batch Number
  • Client
  • Product Number
  • Plant (Own or External)
  • I_SALESORDERIMPORTFIELDLIST.BATCH == MCHA.CHARG
  • I_SALESORDERIMPORTFIELDLIST.MANDT == MCHA.MANDT
  • I_SALESORDERIMPORTFIELDLIST.MATERIAL == MCHA.MATNR
  • I_SALESORDERIMPORTFIELDLIST.PLANT == MCHA.WERKS
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_SALESORDERIMPORTFIELDLIST.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVKT.MANDT
Customer Group
  • Client
  • Customer Group
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T151.MANDT
  • I_SALESORDERIMPORTFIELDLIST.CUSTOMERGROUP == T151.KDGRP
Customer Price Group
  • Client
  • Customer Price Group
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T188.MANDT
  • I_SALESORDERIMPORTFIELDLIST.CUSTOMERPRICEGROUP == T188.KONDA
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • I_SALESORDERIMPORTFIELDLIST.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T176.MANDT
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVLS.MANDT
  • I_SALESORDERIMPORTFIELDLIST.DELIVERYBLOCKREASON == TVLS.LIFSP
Delivery Priority
  • Delivery Priority
  • Client
  • I_SALESORDERIMPORTFIELDLIST.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_SALESORDERIMPORTFIELDLIST.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVKOV.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • I_SALESORDERIMPORTFIELDLIST.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SALESORDERIMPORTFIELDLIST.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_SALESORDERIMPORTFIELDLIST.INCOTERMSVERSION == TINCV.INCOV
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TINCV.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • I_SALESORDERIMPORTFIELDLIST.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVFS.MANDT
Material: order item
  • Client
  • Product Number
  • I_SALESORDERIMPORTFIELDLIST.MANDT == MARA.MANDT
  • I_SALESORDERIMPORTFIELDLIST.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T023.MANDT
  • I_SALESORDERIMPORTFIELDLIST.MATERIALGROUP == T023.MATKL
Material Price Group
  • Client
  • Material Price Group
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T178.MANDT
  • I_SALESORDERIMPORTFIELDLIST.MATERIALPRICINGGROUP == T178.KONDM
Account Assignment Group for Material
  • Client
  • Account Assignment Group for Material
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVKM.MANDT
  • I_SALESORDERIMPORTFIELDLIST.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM
Division in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • Division
  • I_SALESORDERIMPORTFIELDLIST.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVTA.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SALESORGANIZATION == TVTA.VKORG
  • I_SALESORDERIMPORTFIELDLIST.ORGANIZATIONDIVISION == TVTA.SPART
Payment Method
  • Payment Method
  • Client
  • ?
  • I_SALESORDERIMPORTFIELDLIST.PAYMENTMETHOD == T042Z.ZLSCH
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T042Z.MANDT
  • I_SALESORDERIMPORTFIELDLIST.[column in domain "LAND1"] == T042Z.LAND1
Price List Type
  • Client
  • Price List Type
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T189.MANDT
  • I_SALESORDERIMPORTFIELDLIST.PRICELISTTYPE == T189.PLTYP
Sales District
  • Sales District
  • Client
  • I_SALESORDERIMPORTFIELDLIST.SALESDISTRICT == T171.BZIRK
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T171.MANDT
Sales group
  • Sales office
  • Client
  • Sales group
  • I_SALESORDERIMPORTFIELDLIST.SALESOFFICE == TVBVK.VKBUR
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVBVK.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SALESGROUP == TVBVK.VKGRP
Sales document item category
  • Client
  • Sales document item category
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVPT.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SALESORDERITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Client
  • Sales Order Type
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVAK.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVKO.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_SALESORDERIMPORTFIELDLIST.SDDOCUMENTREASON == TVAU.AUGRU
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVAU.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • I_SALESORDERIMPORTFIELDLIST.SHIPPINGCONDITION == TVSB.VSBED
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVST.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T173.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SHIPPINGTYPE == T173.VSART
Sold-to Party
  • Client
  • Sold-to Party
  • I_SALESORDERIMPORTFIELDLIST.MANDT == KNA1.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SOLDTOPARTY == KNA1.KUNNR
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T001L.MANDT
  • I_SALESORDERIMPORTFIELDLIST.STORAGELOCATION == T001L.LGORT
  • I_SALESORDERIMPORTFIELDLIST.PLANT == T001L.WERKS
Tax Departure Country/Region
  • Client
  • Tax Departure Country/Region
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T005.MANDT
  • I_SALESORDERIMPORTFIELDLIST.TAXDEPARTURECOUNTRY == T005.LAND1
Currency in order header
  • Client
  • SD Document Currency
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TCURC.MANDT
  • I_SALESORDERIMPORTFIELDLIST.TRANSACTIONCURRENCY == TCURC.WAERS
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • I_SALESORDERIMPORTFIELDLIST.MANDT == T005.MANDT
  • I_SALESORDERIMPORTFIELDLIST.VATREGISTRATIONCOUNTRY == T005.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Distribution Channel
  • Client
  • Sales Organization
  • Division
  • I_SALESORDERIMPORTFIELDLIST.SALESOFFICE == TVKBZ.VKBUR
  • I_SALESORDERIMPORTFIELDLIST.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESORDERIMPORTFIELDLIST.MANDT == TVKBZ.MANDT
  • I_SALESORDERIMPORTFIELDLIST.SALESORGANIZATION == TVKBZ.VKORG
  • I_SALESORDERIMPORTFIELDLIST.ORGANIZATIONDIVISION == TVKBZ.SPART