Follow us on LinkedIn for your next SAP project
← Back to Search

SAP Table MSR1_ORDER_ITEM

MSR: Sales Order Item

MSR1_ORDER_ITEM (MSR: Sales Order Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MSR1_ORDER_ITEM to other SAP tables.

MSR1_ORDER_ITEM table fields

Field Data element Checktable Datatype Length Decimals Possible values
PARENT
CHAR
 10 0
ITM_NUMBER
CHAR
 6 0
HG_LV_ITEM
Higher-level item in bill of material structures
 UEPOS VBUP
NUMC
 6 0
PO_ITM_NO
Item Number of the Underlying Purchase Order
 POSEX
CHAR
 6 0
MATERIAL
Material Number
 MATNR MARA
CHAR
 18 0
ALT_TO_ITM
Item for which this item is an alternative
 GRPOS
NUMC
 6 0
CUST_MAT22
Customer's material number (obsolete)
 MATNR_KU1
CHAR
 22 0
BATCH
Batch Number
 CHARG_D MCH1
CHAR
 10 0
DLV_GROUP
Delivery group (items are delivered together)
 GRKOR
NUMC
 3 0
PART_DLV
Partial delivery at item level
 KZTLF
CHAR
 1 0
REASON_REJ
Reason for rejection of quotations and sales orders
 ABGRU
CHAR
 2 0
BILL_BLOCK
Block
 FAKSP TVFS
CHAR
 2 0
BILL_DATE
Billing date for billing index and printout
 FKDAT
DATS
 8 0
PLANT
Plant
 WERKS_D T001W
CHAR
 4 0
STORE_LOC
Storage Location
 LGORT_D T001L
CHAR
 4 0
TARGET_QTY
Target quantity in sales units
 DZMENG
QUAN
 13 3
TARGET_QU
Target quantity UoM
 DZIEME T006
UNIT
 3 0
T_UNIT_ISO
Target quantity unit of measure in ISO code
 ISO_ZIEME T006I
CHAR
 3 0
ITEM_CATEG
Sales document item category
 PSTYV TVPT
CHAR
 4 0
SHORT_TEXT
Short text for sales order item
 ARKTX
CHAR
 40 0
PRC_GROUP1
Material group 1
 MVGR1 TVM1
CHAR
 3 0
PRC_GROUP2
Material group 2
 MVGR2 TVM2
CHAR
 3 0
PRC_GROUP3
Material group 3
 MVGR3 TVM3
CHAR
 3 0
PRC_GROUP4
Material group 4
 MVGR4 TVM4
CHAR
 3 0
PRC_GROUP5
Material group 5
 MVGR5 TVM5
CHAR
 3 0
PROD_HIERA
Product hierarchy
 PRODH_D T179
CHAR
 18 0
MATL_GROUP
Material Group
 MATKL
CHAR
 9 0
PURCH_NO_C
Customer purchase order number
 BSTKD
CHAR
 35 0
PURCH_DATE
Customer purchase order date
 BSTDK
DATS
 8 0
PO_METHOD
Customer purchase order type
 BSARK
CHAR
 4 0
REF_1
Your Reference
 IHREZ
CHAR
 12 0
PURCH_NO_S
Ship-to Party's Purchase Order Number
 BSTKD_E
CHAR
 35 0
PO_DAT_S
Ship-to party's PO date
 BSTDK_E
DATS
 8 0
PO_METH_S
Ship-to party purchase order type
 BSARK_E
CHAR
 4 0
REF_1_S
Ship-to party character
 IHREZ_E
CHAR
 12 0
POITM_NO_S
Item Number of the Underlying Purchase Order
 POSEX_E
CHAR
 6 0
PRICE_GRP
Price group (customer)
 KONDA T188
CHAR
 2 0
CUST_GROUP
Customer group
 KDGRP T151
CHAR
 2 0
SALES_DIST
Sales district
 BZIRK
CHAR
 6 0
PRICE_LIST
Price list type
 PLTYP T189
CHAR
 2 0
INCOTERMS1
Incoterms (Part 1)
 INCO1
CHAR
 3 0
INCOTERMS2
Incoterms (Part 2)
 INCO2
CHAR
 28 0
ORDCOMP_IN
Order Combination Indicator
 KZAZU_D
CHAR
 1 0
BILL_SCHED
Invoice dates (calendar identification)
 PERFK TFACD
CHAR
 2 0
INVO_SCHED
Invoice list schedule (calendar identification)
 PERRL TFACD
CHAR
 2 0
MN_INVOICE
Manual invoice maintenance
 MRNKZ
CHAR
 1 0
EX_RATE_FI
Directly quoted exchange rate for FI postings
 KURRF_P
DEC
 9 5
ADD_VAL_DY
Additional value days
 VALTG
NUMC
 2 0
FIX_VAL_DY
Fixed value date
 VALDT
DATS
 8 0
PMNTTRMS
Terms of Payment Key
 DZTERM
CHAR
 4 0
PYMT_METH
Payment Method
 DZLSCH T042Z
CHAR
 1 0
ACCNT_ASGN
Account assignment group for this customer
 KTGRD TVKT
CHAR
 2 0
EXCHG_RATE
Directly quoted exchange rate for pricing and statistics
 KURSK_P
DEC
 9 5
PRICE_DATE
Date for pricing and exchange rate
 PRSDT
DATS
 8 0
SERV_DATE
Date on which services rendered
 FBUDA
DATS
 8 0
DUNN_KEY
Dunning key
 MSCHL T040
CHAR
 1 0
DUNN_BLOCK
Dunning block
 MANSP T040S
CHAR
 1 0
PROMOTION
Promotion
 WAKTION WAKH
CHAR
 10 0
PMTGAR_PRO
Payment guarantee procedure
 ABSSCHE_CM
CHAR
 6 0
DOC_NUM_FI
Financial doc. processing: Internal financial doc. number
 LCNUM
CHAR
 10 0
DEPARTM_NO
Department number
 ABTNR TSAB
CHAR
 4 0
REC_POINT
Receiving point
 EMPST
CHAR
 25 0
CSTCNDGRP1
Customer condition group 1
 KDKG1
CHAR
 2 0
CSTCNDGRP2
Customer condition group 2
 KDKG2
CHAR
 2 0
CSTCNDGRP3
Customer condition group 3
 KDKG3
CHAR
 2 0
CSTCNDGRP4
Customer condition group 4
 KDKG4
CHAR
 2 0
CSTCNDGRP5
Customer condition group 5
 KDKG5
CHAR
 2 0
DLV_TIME
Agreed delivery time
 DELCO
CHAR
 3 0
SALES_UNIT
Sales unit
 VRKME T006
UNIT
 3 0
S_UNIT_ISO
ISO code for unit of measurement
 ISOCD_UNIT T006I
CHAR
 3 0
TRG_QTY_NO
Factor for converting sales units to base units (target qty)
 UMZIZ
DEC
 5 0
TRGQTY_DEN
Factor for converting sales units to base units (target qty)
 UMZIN
DEC
 5 0
RNDDLV_QTY
Rounding quantity for delivery
 ABLFZ
QUAN
 13 3
MAXDEVAMNT
Allowed deviation in quantity (absolute)
 ABSFZ
QUAN
 13 3
MAXDEVPER
Allowed deviation in quantity (in percent)
 KBVER
DEC
 3 0
MAXDEV_DAY
Days by which the quantity can be shifted
 KEVER
DEC
 3 0
USAGE_IND
Unused - Reserve Length 3
 VKAUS
CHAR
 3 0
FIXED_QUAN
Quantity is Fixed
 FMENG
CHAR
 1 0
UNLMT_DLV
Indicator: Unlimited Overdelivery Allowed
 UEBTK
CHAR
 1 0
OVERDLVTOL
Overdelivery Tolerance Limit
 UEBTO
DEC
 3 1
UNDDLV_TOL
Underdelivery Tolerance Limit
 UNTTO
DEC
 3 1
DIVISION
Division
 SPART TSPA
CHAR
 2 0
SALQTYNUM
Numerator (factor) for conversion of sales quantity into SKU
 UMVKZ
DEC
 5 0
SALQTYDEN
Denominator (Divisor) for Conversion of Sales Qty into SKU
 UMVKN
DEC
 5 0
GROSS_WGHT
Gross Weight of the Item
 BRGEW_AP
QUAN
 15 3
NET_WEIGHT
Net Weight of the Item
 NTGEW_AP
QUAN
 15 3
UNTOF_WGHT
Weight Unit
 GEWEI T006
UNIT
 3 0
UNOF_WTISO
Unit of weight in ISO code
 GEWEI_ISO T006I
CHAR
 3 0
VOLUME
Volume of the item
 VOLUM_AP
QUAN
 15 3
VOLUNIT
Volume unit
 VOLEH T006
UNIT
 3 0
VOLUNITISO
Volume unit in ISO code
 VOLEH_ISO T006I
CHAR
 3 0
DLV_PRIO
Delivery Priority
 LPRIO TPRIO
NUMC
 2 0
SHIP_POINT
Shipping Point/Receiving Point
 VSTEL TVST
CHAR
 4 0
ROUTE
Route
 ROUTE TVRO
CHAR
 6 0
CREATED_BY
Name of Person who Created the Object
 ERNAM
CHAR
 12 0
TAX_CLASS1
Tax classification material
 TAXMT TSKD
CHAR
 1 0
TAX_CLASS2
Tax classification material
 TAXMT TSKD
CHAR
 1 0
TAX_CLASS3
Tax classification material
 TAXMT TSKD
CHAR
 1 0
TAX_CLASS4
Tax classification material
 TAXMT TSKD
CHAR
 1 0
TAX_CLASS5
Tax classification material
 TAXMT TSKD
CHAR
 1 0
TAX_CLASS6
Tax classification material
 TAXMT TSKD
CHAR
 1 0
TAX_CLASS7
Tax classification material
 TAXMT TSKD
CHAR
 1 0
TAX_CLASS8
Tax classification material
 TAXMT TSKD
CHAR
 1 0
TAX_CLASS9
Tax classification material
 TAXMT TSKD
CHAR
 1 0
MAT_PR_GRP
Material Pricing Group
 KONDM T178
CHAR
 2 0
VAL_TYPE
Valuation Type
 BWTAR_D T149D
CHAR
 10 0
FIXDAT_QTY
Delivery date and quantity fixed
 FIXMG
CHAR
 1 0
BOMEXPL_NO
BOM explosion number
 SERNR SNUM
CHAR
 8 0
RESANALKEY
Results Analysis Key
 ABGR_SCHL TKKAA
CHAR
 6 0
REQMTS_TYP
Requirements type
 BEDAE T459A
CHAR
 4 0
NO_GR_POST
Customer has not posted goods receipt
 NACHL
CHAR
 1 0
BUS_TRANST
Business Transaction Type for Foreign Trade
 EXART T605
CHAR
 2 0
OVERHD_KEY
Overhead key
 AUFZSCHL
CHAR
 6 0
CSTG_SHEET
Costing Sheet
 AUFKALSM T683
CHAR
 6 0
MATFRGTGRP
Material freight group
 MFRGR TMFG
CHAR
 8 0
PLDLVSHDIN
Planning delivery schedule instruction
 PLAVO
CHAR
 4 0
SEQ_NO
KANBAN/sequence number
 KANNR
CHAR
 35 0
BIL_FORM
Billing form
 FAKTF
CHAR
 2 0
DLI_PROFIL
Dynamic Item Processor Profile
 AD01PROFNR
CHAR
 8 0
REV_TYPE
Revenue recognition category
 RR_RELTYP
CHAR
 1 0
BEGDEM_PER
Proposed start date for accrual period
 RR_ACDATV
CHAR
 1 0
PR_REF_MAT
Pricing Reference Material
 PMATN MARA
CHAR
 18 0
REFOBJTYPE
Object Type
 SWO_OBJTYP TOJTB
CHAR
 10 0
REFOBJKEY
Object key
 SWO_TYPEID
CHAR
 70 0
REFLOGSYS
Logical system
 LOGSYS TBDLS
CHAR
 10 0
ORDER_PROB
Order probability of the item
 AWAHR
NUMC
 3 0
MAX_PL_DLV
Maximum Number of Partial Deliveries Allowed Per Item
 ANTLF
DEC
 1 0
CFOP_CODE
CFOP Code and Extension
 J_1BCFOP
CHAR
 10 0
TAXLAWICMS
Tax law: ICMS
 J_1BTAXLW1
CHAR
 3 0
TAXLAWIPI
Tax law: IPI
 J_1BTAXLW2
CHAR
 3 0
SD_TAXCODE
SD tax code
 J_1BTXSDC_
CHAR
 2 0
ASSORT_MOD
Assortment module
 W_SORTK WSOH
CHAR
 18 0
COMP_QUANT
Component quantity
 KMPMG
QUAN
 13 3
TARGET_VAL
Currency amount for BAPIS (with 9 decimal places)
 BAPICUREXT
DEC
 28 9
CURRENCY
SD Document Currency
 WAERK
CUKY
 5 0
CURR_ISO
ISO code currency
 WAERS_ISO
CHAR
 3 0
PROFIT_CTR
Profit Center
 PRCTR CEPC
CHAR
 10 0
ORDERID
Order Number
 AUFNR AUFK
CHAR
 12 0
WBS_ELEM
Work Breakdown Structure Element (WBS Element)
 PS_POSID
CHAR
 24 0
DEPREC_PER
Depreciation percentage for financial document processing
 AKPRZ
DEC
 5 2
REF_DOC
Document number of the reference document
 VGBEL VBUK
CHAR
 10 0
REF_DOC_IT
Item number of the reference item
 VGPOS VBUP
NUMC
 6 0
REF_DOC_CA
Document category of preceding SD document
 VBTYP_V
CHAR
 1 0
CUST_MAT35
Material belonging to the customer
 KDMAT
CHAR
 35 0
EXCH_RATE_FI_V
Indirectly quoted exchange rate for FI postings
 KURRF_V
DEC
 9 5
EXCHG_RATE_V
Indirectly quoted exchange rate for pricing and statistics
 KURSK_V
DEC
 9 5
ITEMGUID_ATP
ATP: Encryption of DELNR and DELPS
 POSGUID
CHAR
 22 0
VAL_CONTR
Value contract no.
 WKTNR
CHAR
 10 0
VAL_CON_I
Value contract item
 WKTPS
NUMC
 6 0
CONFIG_ID
External Configuration ID (Temporary)
 CUXCFG_ID
CHAR
 6 0
INST_ID
Instance Number in Configuration
 CU_INST_ID
CHAR
 8 0
MAT_EXT
Long Material Number for MATERIAL Field
 MGV_MATERIAL_EXTERNAL
CHAR
 40 0
MAT_GUID
External GUID for MATERIAL Field
 MGV_MATERIAL_GUID
CHAR
 32 0
MAT_VERS
Version Number for MATERIAL Field
 MGV_MATERIAL_VERSION
CHAR
 10 0
P_MAT_EXT
Long Material Number for PR_REF_MAT Field
 MGV_PR_REF_MAT_EXTERNAL
CHAR
 40 0
P_MAT_GUID
External GUID for PR_REF_MAT Field
 MGV_PR_REF_MAT_GUID
CHAR
 32 0
P_MAT_VERS
Version Number for PR_REF_MAT Field
 MGV_PR_REF_MAT_VERSION
CHAR
 10 0
FUNC_AREA
Functional Area
 FKBER
CHAR
 16 0
ALTERN_BOM
Alternative BOM
 STLAL
CHAR
 2 0
FKK_CONACCT
Character Field of Length 12
 CHAR12
CHAR
 12 0
EAN_UPC
International Article Number (EAN/UPC)
 EAN11
CHAR
 18 0
PRODCAT
Product catalog number
 WMINR
CHAR
 10 0
SHIP_TYPE
Shipping type
 VSARTTR T173
CHAR
 2 0
S_PROC_IND
Special processing indicator
 SDABW TVSAK
CHAR
 4 0
FUNC_AREA_LONG
Field of length 16
 CHAR16
CHAR
 16 0
VW_UEPOS
ID for higher-level item usage
 UEPVW
CHAR
 1 0
DLVSCHDUSE
Usage Indicator
 ABRVW TVLV
CHAR
 3 0
REQ_QTY
Order quantity in sales units
 WMENG
QUAN
 13 3
COND_TYPE_1
Condition type
 KSCHA
CHAR
 4 0
COND_VALUE_1
Currency amount in BAPI interfaces
 BAPICURR_D
DEC
 23 4
CURRENCY_1
Currency Key
 WAERS
CUKY
 5 0
COND_UNIT_1
Condition unit
 KMEIN
UNIT
 3 0
COND_P_UNT_1
Condition pricing unit
 KPEIN
DEC
 5 0
CURR_ISO_1
ISO code currency
 WAERS_ISO
CHAR
 3 0
CD_UNT_ISO_1
Condition unit of measure in UoM
 KVMEI_ISO
CHAR
 3 0
COND_TYPE_2
Condition type
 KSCHA
CHAR
 4 0
COND_VALUE_2
Currency amount in BAPI interfaces
 BAPICURR_D
DEC
 23 4
CURRENCY_2
Currency Key
 WAERS
CUKY
 5 0
COND_UNIT_2
Condition unit
 KMEIN
UNIT
 3 0
COND_P_UNT_2
Condition pricing unit
 KPEIN
DEC
 5 0
CURR_ISO_2
ISO code currency
 WAERS_ISO
CHAR
 3 0
CD_UNT_ISO_2
Condition unit of measure in UoM
 KVMEI_ISO
CHAR
 3 0
COND_TYPE_3
Condition type
 KSCHA
CHAR
 4 0
COND_VALUE_3
Currency amount in BAPI interfaces
 BAPICURR_D
DEC
 23 4
CURRENCY_3
Currency Key
 WAERS
CUKY
 5 0
COND_UNIT_3
Condition unit
 KMEIN
UNIT
 3 0
COND_P_UNT_3
Condition pricing unit
 KPEIN
DEC
 5 0
CURR_ISO_3
ISO code currency
 WAERS_ISO
CHAR
 3 0
CD_UNT_ISO_3
Condition unit of measure in UoM
 KVMEI_ISO
CHAR
 3 0
NET_VALUE
Currency amount in BAPI interfaces
 BAPICURR_D
DEC
 23 4

MSR1_ORDER_ITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MSR1_ORDER_ITEM ACCNT_ASGN SYST MANDT TVKT
Customers: Account Assignment Groups
 MANDT
MSR1_ORDER_ITEM ACCNT_ASGN MSR1_ORDER_ITEM ACCNT_ASGN TVKT
Customers: Account Assignment Groups
 KTGRD
MSR1_ORDER_ITEM ASSORT_MOD SYST MANDT WSOH
Assortment Modules SAP Retail
 MANDT
MSR1_ORDER_ITEM ASSORT_MOD MSR1_ORDER_ITEM ASSORT_MOD WSOH
Assortment Modules SAP Retail
 SKOPF
MSR1_ORDER_ITEM BATCH MSR1_ORDER_ITEM MATERIAL MCH1
Batches (if Batch Management Cross-Plant)
 MATNR
MSR1_ORDER_ITEM BATCH MSR1_ORDER_ITEM BATCH MCH1
Batches (if Batch Management Cross-Plant)
 CHARG
MSR1_ORDER_ITEM BATCH SYST MANDT MCH1
Batches (if Batch Management Cross-Plant)
 MANDT
MSR1_ORDER_ITEM BILL_BLOCK SYST MANDT TVFS
Billing: Reasons for Blocking
 MANDT
MSR1_ORDER_ITEM BILL_BLOCK MSR1_ORDER_ITEM BILL_BLOCK TVFS
Billing: Reasons for Blocking
 FAKSP
MSR1_ORDER_ITEM BILL_SCHED MSR1_ORDER_ITEM BILL_SCHED TFACD
Factory calendar definition
 IDENT
MSR1_ORDER_ITEM BOMEXPL_NO SYST MANDT SNUM
BOM explosion number
 MANDT
MSR1_ORDER_ITEM BOMEXPL_NO MSR1_ORDER_ITEM BOMEXPL_NO SNUM
BOM explosion number
 SERNR
MSR1_ORDER_ITEM BUS_TRANST SYST MANDT T605
Foreign Trade: Business Transaction Type
 MANDT
MSR1_ORDER_ITEM BUS_TRANST * T605
Foreign Trade: Business Transaction Type
 LAND1
MSR1_ORDER_ITEM BUS_TRANST MSR1_ORDER_ITEM BUS_TRANST T605
Foreign Trade: Business Transaction Type
 EXART
MSR1_ORDER_ITEM CSTG_SHEET * T683
Pricing procedures
 KAPPL
MSR1_ORDER_ITEM CSTG_SHEET MSR1_ORDER_ITEM CSTG_SHEET T683
Pricing procedures
 KALSM
MSR1_ORDER_ITEM CSTG_SHEET SYST MANDT T683
Pricing procedures
 MANDT
MSR1_ORDER_ITEM CSTG_SHEET * T683
Pricing procedures
 KVEWE
MSR1_ORDER_ITEM CUST_GROUP SYST MANDT T151
Customers: Customer Groups
 MANDT
MSR1_ORDER_ITEM CUST_GROUP MSR1_ORDER_ITEM CUST_GROUP T151
Customers: Customer Groups
 KDGRP
MSR1_ORDER_ITEM DEPARTM_NO SYST MANDT TSAB
Contact persons: standard departments
 MANDT
MSR1_ORDER_ITEM DEPARTM_NO MSR1_ORDER_ITEM DEPARTM_NO TSAB
Contact persons: standard departments
 ABTNR
MSR1_ORDER_ITEM DIVISION SYST MANDT TSPA
Organizational Unit: Sales Divisions
 MANDT
MSR1_ORDER_ITEM DIVISION MSR1_ORDER_ITEM DIVISION TSPA
Organizational Unit: Sales Divisions
 SPART
MSR1_ORDER_ITEM DLVSCHDUSE MSR1_ORDER_ITEM DLVSCHDUSE TVLV
Check table for release orders: Usage ID
 ABRVW
MSR1_ORDER_ITEM DLVSCHDUSE SYST MANDT TVLV
Check table for release orders: Usage ID
 MANDT
MSR1_ORDER_ITEM DLV_PRIO MSR1_ORDER_ITEM DLV_PRIO TPRIO
Customers: Delivery Priorities
 LPRIO
MSR1_ORDER_ITEM DLV_PRIO SYST MANDT TPRIO
Customers: Delivery Priorities
 MANDT
MSR1_ORDER_ITEM DUNN_BLOCK SYST MANDT T040S
Blocking reasons for dunning notices
 MANDT
MSR1_ORDER_ITEM DUNN_BLOCK MSR1_ORDER_ITEM DUNN_BLOCK T040S
Blocking reasons for dunning notices
 MANSP
MSR1_ORDER_ITEM DUNN_KEY SYST MANDT T040
Dunning keys
 MANDT
MSR1_ORDER_ITEM DUNN_KEY MSR1_ORDER_ITEM DUNN_KEY T040
Dunning keys
 MSCHL
MSR1_ORDER_ITEM HG_LV_ITEM MSR1_ORDER_ITEM REF_DOC VBUP
Sales Document: Item Status
 VBELN
MSR1_ORDER_ITEM HG_LV_ITEM MSR1_ORDER_ITEM HG_LV_ITEM VBUP
Sales Document: Item Status
 POSNR
MSR1_ORDER_ITEM HG_LV_ITEM SYST MANDT VBUP
Sales Document: Item Status
 MANDT
MSR1_ORDER_ITEM INVO_SCHED MSR1_ORDER_ITEM INVO_SCHED TFACD
Factory calendar definition
 IDENT
MSR1_ORDER_ITEM ITEM_CATEG SYST MANDT TVPT
Sales documents: Item categories
 MANDT
MSR1_ORDER_ITEM ITEM_CATEG MSR1_ORDER_ITEM ITEM_CATEG TVPT
Sales documents: Item categories
 PSTYV
MSR1_ORDER_ITEM MATERIAL SYST MANDT MARA
General Material Data
 MANDT
MSR1_ORDER_ITEM MATERIAL MSR1_ORDER_ITEM MATERIAL MARA
General Material Data
 MATNR
MSR1_ORDER_ITEM MATFRGTGRP SYST MANDT TMFG
Material freight groups
 MANDT
MSR1_ORDER_ITEM MATFRGTGRP MSR1_ORDER_ITEM MATFRGTGRP TMFG
Material freight groups
 MFRGR
MSR1_ORDER_ITEM MAT_PR_GRP SYST MANDT T178
Conditions: Groups for Materials
 MANDT
MSR1_ORDER_ITEM MAT_PR_GRP MSR1_ORDER_ITEM MAT_PR_GRP T178
Conditions: Groups for Materials
 KONDM
MSR1_ORDER_ITEM ORDERID SYST MANDT AUFK
Order master data
 MANDT
MSR1_ORDER_ITEM ORDERID MSR1_ORDER_ITEM ORDERID AUFK
Order master data
 AUFNR
MSR1_ORDER_ITEM PLANT SYST MANDT T001W
Plants/Branches
 MANDT
MSR1_ORDER_ITEM PLANT MSR1_ORDER_ITEM PLANT T001W
Plants/Branches
 WERKS
MSR1_ORDER_ITEM PRC_GROUP1 SYST MANDT TVM1
Material Pricing Group 1
 MANDT
MSR1_ORDER_ITEM PRC_GROUP1 MSR1_ORDER_ITEM PRC_GROUP1 TVM1
Material Pricing Group 1
 MVGR1
MSR1_ORDER_ITEM PRC_GROUP2 SYST MANDR TVM2
Material Pricing Group 2
 MANDT
MSR1_ORDER_ITEM PRC_GROUP2 MSR1_ORDER_ITEM PRC_GROUP2 TVM2
Material Pricing Group 2
 MVGR2
MSR1_ORDER_ITEM PRC_GROUP3 MSR1_ORDER_ITEM PRC_GROUP3 TVM3
Material Pricing Group 3
 MVGR3
MSR1_ORDER_ITEM PRC_GROUP3 SYST MANDT TVM3
Material Pricing Group 3
 MANDT
MSR1_ORDER_ITEM PRC_GROUP4 SYST MANDT TVM4
Material Pricing Group 4
 MANDT
MSR1_ORDER_ITEM PRC_GROUP4 MSR1_ORDER_ITEM PRC_GROUP4 TVM4
Material Pricing Group 4
 MVGR4
MSR1_ORDER_ITEM PRC_GROUP5 SYST MANDT TVM5
Material Pricing Group 5
 MANDT
MSR1_ORDER_ITEM PRC_GROUP5 MSR1_ORDER_ITEM PRC_GROUP5 TVM5
Material Pricing Group 5
 MVGR5
MSR1_ORDER_ITEM PRICE_GRP MSR1_ORDER_ITEM PRICE_GRP T188
Conditions: Groups for Customer Classifications
 KONDA
MSR1_ORDER_ITEM PRICE_GRP SYST MANDT T188
Conditions: Groups for Customer Classifications
 MANDT
MSR1_ORDER_ITEM PRICE_LIST SYST MANDT T189
Conditions: Price List Categories
 MANDT
MSR1_ORDER_ITEM PRICE_LIST MSR1_ORDER_ITEM PRICE_LIST T189
Conditions: Price List Categories
 PLTYP
MSR1_ORDER_ITEM PROD_HIERA SYST MANDT T179
Materials: Product Hierarchies
 MANDT
MSR1_ORDER_ITEM PROD_HIERA MSR1_ORDER_ITEM PROD_HIERA T179
Materials: Product Hierarchies
 PRODH
MSR1_ORDER_ITEM PROFIT_CTR SYST MANDT CEPC
Profit Center Master Data Table
 MANDT
MSR1_ORDER_ITEM PROFIT_CTR MSR1_ORDER_ITEM PROFIT_CTR CEPC
Profit Center Master Data Table
 PRCTR
MSR1_ORDER_ITEM PROFIT_CTR MSR1_ORDER_ITEM BILL_DATE CEPC
Profit Center Master Data Table
 DATBI
MSR1_ORDER_ITEM PROFIT_CTR * CEPC
Profit Center Master Data Table
 KOKRS
MSR1_ORDER_ITEM PROMOTION SYST MANDT WAKH
Promotion Header Data, IS-R
 MANDT
MSR1_ORDER_ITEM PROMOTION MSR1_ORDER_ITEM PROMOTION WAKH
Promotion Header Data, IS-R
 AKTNR
MSR1_ORDER_ITEM PR_REF_MAT SYST MANDT MARA
General Material Data
 MANDT
MSR1_ORDER_ITEM PR_REF_MAT MSR1_ORDER_ITEM PR_REF_MAT MARA
General Material Data
 MATNR
MSR1_ORDER_ITEM PYMT_METH SYST MANDT T042Z
Payment Methods for Automatic Payment
 MANDT
MSR1_ORDER_ITEM PYMT_METH * T042Z
Payment Methods for Automatic Payment
 LAND1
MSR1_ORDER_ITEM PYMT_METH MSR1_ORDER_ITEM PYMT_METH T042Z
Payment Methods for Automatic Payment
 ZLSCH
MSR1_ORDER_ITEM REFLOGSYS MSR1_ORDER_ITEM REFLOGSYS TBDLS
Logical system
 LOGSYS
MSR1_ORDER_ITEM REFOBJTYPE MSR1_ORDER_ITEM REFOBJTYPE TOJTB
Business object repository: Basic data
 NAME
MSR1_ORDER_ITEM REF_DOC SYST MANDT VBUK
Sales Document: Header Status and Administrative Data
 MANDT
MSR1_ORDER_ITEM REF_DOC MSR1_ORDER_ITEM REF_DOC VBUK
Sales Document: Header Status and Administrative Data
 VBELN
MSR1_ORDER_ITEM REF_DOC_IT SYST MANDT VBUP
Sales Document: Item Status
 MANDT
MSR1_ORDER_ITEM REF_DOC_IT MSR1_ORDER_ITEM REF_DOC VBUP
Sales Document: Item Status
 VBELN
MSR1_ORDER_ITEM REF_DOC_IT MSR1_ORDER_ITEM REF_DOC_IT VBUP
Sales Document: Item Status
 POSNR
MSR1_ORDER_ITEM REQMTS_TYP SYST MANDT T459A
External requirements types
 MANDT
MSR1_ORDER_ITEM REQMTS_TYP MSR1_ORDER_ITEM REQMTS_TYP T459A
External requirements types
 BEDAE
MSR1_ORDER_ITEM RESANALKEY MSR1_ORDER_ITEM RESANALKEY TKKAA
Check Table for Results Analysis Key of RA for Orders
 ABGSL
MSR1_ORDER_ITEM RESANALKEY SYST MANDT TKKAA
Check Table for Results Analysis Key of RA for Orders
 MANDT
MSR1_ORDER_ITEM ROUTE SYST MANDT TVRO
Routes
 MANDT
MSR1_ORDER_ITEM ROUTE MSR1_ORDER_ITEM ROUTE TVRO
Routes
 ROUTE
MSR1_ORDER_ITEM SALES_UNIT SYST MANDT T006
Units of Measurement
 MANDT
MSR1_ORDER_ITEM SALES_UNIT MSR1_ORDER_ITEM SALES_UNIT T006
Units of Measurement
 MSEHI
MSR1_ORDER_ITEM SHIP_POINT SYST MANDT TVST
Organizational Unit: Shipping Points
 MANDT
MSR1_ORDER_ITEM SHIP_POINT MSR1_ORDER_ITEM SHIP_POINT TVST
Organizational Unit: Shipping Points
 VSTEL
MSR1_ORDER_ITEM SHIP_TYPE MSR1_ORDER_ITEM SHIP_TYPE T173
Routes: Mode of Transport for Each Shipping Type
 VSART
MSR1_ORDER_ITEM SHIP_TYPE SYST MANDT T173
Routes: Mode of Transport for Each Shipping Type
 MANDT
MSR1_ORDER_ITEM STORE_LOC MSR1_ORDER_ITEM PLANT T001L
Storage Locations
 WERKS
MSR1_ORDER_ITEM STORE_LOC MSR1_ORDER_ITEM STORE_LOC T001L
Storage Locations
 LGORT
MSR1_ORDER_ITEM STORE_LOC SYST MANDT T001L
Storage Locations
 MANDT
MSR1_ORDER_ITEM S_PROC_IND MSR1_ORDER_ITEM S_PROC_IND TVSAK
Special Processing Indicator
 SDABW
MSR1_ORDER_ITEM S_PROC_IND SYST MANDT TVSAK
Special Processing Indicator
 MANDT
MSR1_ORDER_ITEM S_UNIT_ISO SYST MANDT T006I
ISO codes for units of measurement
 CLIENT
MSR1_ORDER_ITEM S_UNIT_ISO MSR1_ORDER_ITEM S_UNIT_ISO T006I
ISO codes for units of measurement
 ISOCODE
MSR1_ORDER_ITEM TARGET_QU SYST MANDT T006
Units of Measurement
 MANDT
MSR1_ORDER_ITEM TARGET_QU MSR1_ORDER_ITEM TARGET_QU T006
Units of Measurement
 MSEHI
MSR1_ORDER_ITEM TAX_CLASS1 MSR1_ORDER_ITEM TAX_CLASS1 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM TAX_CLASS1 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS1 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS2 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS2 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS2 MSR1_ORDER_ITEM TAX_CLASS2 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM TAX_CLASS3 MSR1_ORDER_ITEM TAX_CLASS3 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM TAX_CLASS3 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS3 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS4 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS4 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS4 MSR1_ORDER_ITEM TAX_CLASS4 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM TAX_CLASS5 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS5 MSR1_ORDER_ITEM TAX_CLASS5 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM TAX_CLASS5 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS6 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS6 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS6 MSR1_ORDER_ITEM TAX_CLASS6 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM TAX_CLASS7 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS7 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS7 MSR1_ORDER_ITEM TAX_CLASS7 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM TAX_CLASS8 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS8 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS8 MSR1_ORDER_ITEM TAX_CLASS8 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM TAX_CLASS9 SYST MANDT TSKD
Customer Taxes
 MANDT
MSR1_ORDER_ITEM TAX_CLASS9 * TSKD
Customer Taxes
 TATYP
MSR1_ORDER_ITEM TAX_CLASS9 MSR1_ORDER_ITEM TAX_CLASS9 TSKD
Customer Taxes
 TAXKD
MSR1_ORDER_ITEM T_UNIT_ISO SYST MANDT T006I
ISO codes for units of measurement
 CLIENT
MSR1_ORDER_ITEM T_UNIT_ISO MSR1_ORDER_ITEM T_UNIT_ISO T006I
ISO codes for units of measurement
 ISOCODE
MSR1_ORDER_ITEM UNOF_WTISO SYST MANDT T006I
ISO codes for units of measurement
 CLIENT
MSR1_ORDER_ITEM UNOF_WTISO MSR1_ORDER_ITEM UNOF_WTISO T006I
ISO codes for units of measurement
 ISOCODE
MSR1_ORDER_ITEM UNTOF_WGHT SYST MANDT T006
Units of Measurement
 MANDT
MSR1_ORDER_ITEM UNTOF_WGHT MSR1_ORDER_ITEM UNTOF_WGHT T006
Units of Measurement
 MSEHI
MSR1_ORDER_ITEM VAL_TYPE SYST MANDT T149D
Global Valuation Types
 MANDT
MSR1_ORDER_ITEM VAL_TYPE MSR1_ORDER_ITEM VAL_TYPE T149D
Global Valuation Types
 BWTAR
MSR1_ORDER_ITEM VOLUNIT MSR1_ORDER_ITEM VOLUNIT T006
Units of Measurement
 MSEHI
MSR1_ORDER_ITEM VOLUNIT SYST MANDT T006
Units of Measurement
 MANDT
MSR1_ORDER_ITEM VOLUNITISO SYST MANDT T006I
ISO codes for units of measurement
 CLIENT
MSR1_ORDER_ITEM VOLUNITISO MSR1_ORDER_ITEM VOLUNITISO T006I
ISO codes for units of measurement
 ISOCODE