SAP ABAP Table /SAPNEA/MR3_ORDER_ITEM ([Mobile DB] Sales order item)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   CA (Application Component) Cross-Application Components
     /SAPNEA/MR3/HANDHELD_SALES (Package) Mobile Sales for Handhelds
Basic Data
Table Category INTTAB    Structure 
Structure /SAPNEA/MR3_ORDER_ITEM   Table Relationship Diagram
Short Description [Mobile DB] Sales order item    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   Communication Fields: Sales Document Item  
2 ITM_NUMBER POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
3 HG_LV_ITEM UEPOS POSNR NUMC 6   0   Higher-level item in bill of material structures VBUP
4 PO_ITM_NO POSEX POSEX CHAR 6   0   Item Number of the Underlying Purchase Order  
5 MATERIAL MATNR MATNR CHAR 18   0   Material Number MARA
6 ALT_TO_ITM GRPOS GRPOS NUMC 6   0   Item for which this item is an alternative  
7 CUST_MAT22 MATNR_KU1 IDNEX_OLD CHAR 22   0   Customer's material number (obsolete)  
8 BATCH CHARG_D CHARG CHAR 10   0   Batch Number MCH1
9 DLV_GROUP GRKOR GRKOR NUMC 3   0   Delivery group (items are delivered together)  
10 PART_DLV KZTLF KZTLF CHAR 1   0   Partial delivery at item level  
11 REASON_REJ ABGRU ABGRU CHAR 2   0   Reason for rejection of quotations and sales orders  
12 BILL_BLOCK FAKSP FAKSP CHAR 2   0   Lock TVFS
13 BILL_DATE FKDAT DATUM DATS 8   0   Billing date for billing index and printout  
14 PLANT WERKS_D WERKS CHAR 4   0   Plant T001W
15 STORE_LOC LGORT_D LGORT CHAR 4   0   Storage location T001L
16 TARGET_QTY DZMENG MENG13 QUAN 13   3   Target quantity in sales units  
17 TARGET_QU DZIEME MEINS UNIT 3   0   Target quantity UoM T006
18 T_UNIT_ISO ISO_ZIEME ISOCD_UNIT CHAR 3   0   Target quantity unit of measure in ISO code T006I
19 ITEM_CATEG PSTYV PSTYV CHAR 4   0   Sales document item category TVPT
20 SHORT_TEXT ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
21 PRC_GROUP1 MVGR1 MVGR1 CHAR 3   0   Material group 1 TVM1
22 PRC_GROUP2 MVGR2 MVGR2 CHAR 3   0   Material group 2 TVM2
23 PRC_GROUP3 MVGR3 MVGR3 CHAR 3   0   Material group 3 TVM3
24 PRC_GROUP4 MVGR4 MVGR4 CHAR 3   0   Material group 4 TVM4
25 PRC_GROUP5 MVGR5 MVGR5 CHAR 3   0   Material group 5 TVM5
26 PROD_HIERA PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
27 MATL_GROUP MATKL MATKL CHAR 9   0   Material Group *
28 PURCH_NO_C BSTKD BSTKD CHAR 35   0   Customer purchase order number  
29 PURCH_DATE BSTDK DATUM DATS 8   0   Customer purchase order date  
30 PO_METHOD BSARK BSARK CHAR 4   0   Customer Order Type *
31 REF_1 IHREZ TEXT12 CHAR 12   0   Your Reference  
32 PURCH_NO_S BSTKD_E BSTKD CHAR 35   0   Ship-to Party's Purchase Order Number  
33 PO_DAT_S BSTDK_E DATUM DATS 8   0   Ship-to party's PO date  
34 PO_METH_S BSARK_E BSARK CHAR 4   0   Ship-to party purchase order type *
35 REF_1_S IHREZ_E TEXT12 CHAR 12   0   Ship-to party character  
36 POITM_NO_S POSEX_E POSEX CHAR 6   0   Item Number of the Underlying Purchase Order  
37 PRICE_GRP KONDA KONDA CHAR 2   0   Price Group (Customer) T188
38 CUST_GROUP KDGRP KDGRP CHAR 2   0   Customer group T151
39 SALES_DIST BZIRK BZIRK CHAR 6   0   Sales district *
40 PRICE_LIST PLTYP PLTYP CHAR 2   0   Price list type T189
41 INCOTERMS1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) *
42 INCOTERMS2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
43 ORDCOMP_IN KZAZU_D XFELD CHAR 1   0   Order combination indicator  
44 BILL_SCHED PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TFACD
45 INVO_SCHED PERRL WFCID CHAR 2   0   Invoice list schedule (calendar identification) TFACD
46 MN_INVOICE MRNKZ XFELD CHAR 1   0   Manual invoice maintenance  
47 EX_RATE_FI KURRF_P KURSP DEC 9   5   Directly quoted exchange rate for FI postings  
48 ADD_VAL_DY VALTG TAGE2 NUMC 2   0   Additional value days  
49 FIX_VAL_DY VALDT DATUM DATS 8   0   Fixed value date  
50 PMNTTRMS DZTERM ZTERM CHAR 4   0   Terms of payment key  
51 PYMT_METH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
52 ACCNT_ASGN KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
53 EXCHG_RATE KURSK_P PKURS DEC 9   5   Directly Quoted Exchange Rate for Pricing and Statistics  
54 PRICE_DATE PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
55 SERV_DATE FBUDA DATUM DATS 8   0   Date When Services Rendered  
56 DUNN_KEY MSCHL MSCHL CHAR 1   0   Dunning key T040
57 DUNN_BLOCK MANSP MANSP CHAR 1   0   Dunning block T040S
58 PROMOTION WAKTION WAKTION CHAR 10   0   Promotion WAKH
59 PMTGAR_PRO ABSSCHE_CM ABSSCHE_CM CHAR 6   0   Payment Guarantee Procedure  
60 DOC_NUM_FI LCNUM LCNUM CHAR 10   0   Financial doc. processing: Internal financial doc. number *
61 DEPARTM_NO ABTNR ABTNR CHAR 4   0   Department number TSAB
62 REC_POINT EMPST TEXT25 CHAR 25   0   Receiving point  
63 CSTCNDGRP1 KDKG1 KDKGR CHAR 2   0   Customer condition group 1 *
64 CSTCNDGRP2 KDKG2 KDKGR CHAR 2   0   Customer condition group 2 *
65 CSTCNDGRP3 KDKG3 KDKGR CHAR 2   0   Customer condition group 3 *
66 CSTCNDGRP4 KDKG4 KDKGR CHAR 2   0   Customer condition group 4 *
67 CSTCNDGRP5 KDKG5 KDKGR CHAR 2   0   Customer condition group 5 *
68 DLV_TIME DELCO DELCO CHAR 3   0   Agreed delivery time  
69 SALES_UNIT VRKME MEINS UNIT 3   0   Sales unit T006
70 S_UNIT_ISO ISOCD_UNIT ISOCD_UNIT CHAR 3   0   ISO code for unit of measurement T006I
71 TRG_QTY_NO UMZIZ UMBSZ DEC 5   0   Factor for converting sales units to base units (target qty)  
72 TRGQTY_DEN UMZIN UMBSN DEC 5   0   Factor for converting sales units to base units (target qty)  
73 RNDDLV_QTY ABLFZ ABLFZ QUAN 13   3   Rounding quantity for delivery  
74 MAXDEVAMNT ABSFZ MENG13 QUAN 13   3   Allowed deviation in quantity (absolute)  
75 MAXDEVPER KBVER PACK2 DEC 3   0   Allowed deviation in quantity (in percent)  
76 MAXDEV_DAY KEVER PACK2 DEC 3   0   Days by which the quantity can be shifted  
77 USAGE_IND VKAUS VKAUS CHAR 3   0   Unused - Reserve Length 3  
78 FIXED_QUAN FMENG XFELD CHAR 1   0   Quantity is fixed  
79 UNLMT_DLV UEBTK XFELD CHAR 1   0   Indicator: Unlimited Overdelivery Allowed  
80 OVERDLVTOL UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
81 UNDDLV_TOL UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
82 DIVISION SPART SPART CHAR 2   0   Division TSPA
83 SALQTYNUM UMVKZ UMBSZ DEC 5   0   Numerator (factor) for conversion of sales quantity into SKU  
84 SALQTYDEN UMVKN UMBSN DEC 5   0   Denominator (divisor) for conversion of sales qty. into SKU  
85 GROSS_WGHT BRGEW_AP MENG15 QUAN 15   3   Gross weight of item  
86 NET_WEIGHT NTGEW_AP MENG15 QUAN 15   3   Net weight of item  
87 UNTOF_WGHT GEWEI MEINS UNIT 3   0   Weight Unit T006
88 UNOF_WTISO GEWEI_ISO ISOCD_UNIT CHAR 3   0   Unit of weight in ISO code T006I
89 VOLUME VOLUM_AP MENG15 QUAN 15   3   Volume of the item  
90 VOLUNIT VOLEH MEINS UNIT 3   0   Volume unit T006
91 VOLUNITISO VOLEH_ISO ISOCD_UNIT CHAR 3   0   Volume unit in ISO code T006I
92 DLV_PRIO LPRIO LPRIO NUMC 2   0   Delivery priority TPRIO
93 SHIP_POINT VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point TVST
94 ROUTE ROUTE ROUTE CHAR 6   0   Route TVRO
95 CREATED_BY ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
96 TAX_CLASS1 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
97 TAX_CLASS2 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
98 TAX_CLASS3 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
99 TAX_CLASS4 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
100 TAX_CLASS5 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
101 TAX_CLASS6 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
102 TAX_CLASS7 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
103 TAX_CLASS8 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
104 TAX_CLASS9 TAXMT TAXKD CHAR 1   0   Tax classification material TSKD
105 MAT_PR_GRP KONDM KONDM CHAR 2   0   Material Pricing Group T178
106 VAL_TYPE BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
107 FIXDAT_QTY FIXMG XFELD CHAR 1   0   Delivery date and quantity fixed  
108 BOMEXPL_NO SERNR SERNR CHAR 8   0   BOM explosion number SNUM
109 RESANALKEY ABGR_SCHL ABGR_SCHL CHAR 6   0   Results Analysis Key TKKAA
110 REQMTS_TYP BEDAE BEDAE CHAR 4   0   Requirements type T459A
111 NO_GR_POST NACHL XFELD CHAR 1   0   Customer has not posted goods receipt  
112 BUS_TRANST EXART EXART CHAR 2   0   Business Transaction Type for Foreign Trade T605
113 OVERHD_KEY AUFZSCHL CHAR6 CHAR 6   0   Overhead key  
114 CSTG_SHEET AUFKALSM KALSM CHAR 6   0   Costing Sheet T683
115 MATFRGTGRP MFRGR MFRGR CHAR 8   0   Material freight group TMFG
116 PLDLVSHDIN PLAVO PLAVO CHAR 4   0   Planning Release Regulation *
117 SEQ_NO KANNR CHAR35 CHAR 35   0   KANBAN/sequence number  
118 BIL_FORM FAKTF FAKTF CHAR 2   0   Billing Form  
119 DLI_PROFIL AD01PROFNR AD01PROFNR CHAR 8   0   Dynamic Item Processor Profile *
120 REV_TYPE RR_RELTYP RR_RELTYP CHAR 1   0   Revenue recognition category  
121 BEGDEM_PER RR_ACDATV RR_ACDATV CHAR 1   0   Proposed start date for accrual period  
122 PR_REF_MAT PMATN MATNR CHAR 18   0   Pricing Reference Material MARA
123 REFOBJTYPE SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type TOJTB
124 REFOBJKEY SWO_TYPEID SWO_TYPEID CHAR 70   0   Object key  
125 REFLOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
126 ORDER_PROB AWAHR AWAHR NUMC 3   0   Order probability of the item  
127 MAX_PL_DLV ANTLF ANTLF DEC 1   0   Maximum number of partial deliveries allowed per item  
128 CFOP_CODE J_1BCFOP_OLD J_1BCFOP_OLD CHAR 5   0   CFOP code and extension (old 5 char version) *
129 TAXLAWICMS J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS *
130 TAXLAWIPI J_1BTAXLW2 J_1BTAXLW2 CHAR 3   0   Tax law: IPI *
131 SD_TAXCODE J_1BTXSDC_ J_1BTXSDC CHAR 2   0   SD tax code *
132 ASSORT_MOD W_SORTK WSORTK CHAR 18   0   Assortment Module WSOH
133 COMP_QUANT KMPMG MENGV13 QUAN 13   3   Component Quantity  
134 TARGET_VAL BAPICUREXT BAPICUREXT DEC 28   9   Currency amount for BAPIS (with 9 decimal places)  
135 CURRENCY WAERK WAERS CUKY 5   0   SD document currency *
136 CURR_ISO WAERS_ISO ISOCD CHAR 3   0   ISO code currency  
137 PROFIT_CTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
138 ORDERID AUFNR AUFNR CHAR 12   0   Order Number AUFK
139 WBS_ELEM PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
140 DEPREC_PER AKPRZ PRZ32 DEC 5   2   Depreciation percentage for financial document processing  
141 REF_DOC VGBEL VBELN CHAR 10   0   Document number of the reference document VBUK
142 REF_DOC_IT VGPOS POSNR NUMC 6   0   Item number of the reference item VBUP
143 REF_DOC_CA VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
144 CUST_MAT35 KDMAT IDNEX CHAR 35   0   Material belonging to the customer  
145 EXCH_RATE_FI_V KURRF_V KURSP DEC 9   5   Indirectly quoted exchange rate for FI postings  
146 EXCHG_RATE_V KURSK_V PKURS DEC 9   5   Indirectly Quoted Exchange Rate for Pricing and Statistics  
147 ITEMGUID_ATP POSGUID SYSUUID_22 CHAR 22   0   ATP: Encryption of DELNR and DELPS  
148 VAL_CONTR WKTNR VBELN CHAR 10   0   Value contract no. *
149 VAL_CON_I WKTPS POSNR NUMC 6   0   Value contract item *
150 CONFIG_ID CUXCFG_ID CHAR6 CHAR 6   0   External Configuration ID (Temporary)  
151 INST_ID CU_INST_ID CHAR8 CHAR 8   0   Instance Number in Configuration  
152 MAT_EXT MGV_MATERIAL_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for MATERIAL Field  
153 MAT_GUID MGV_MATERIAL_GUID MATNR_EGUID CHAR 32   0   External GUID for MATERIAL Field  
154 MAT_VERS MGV_MATERIAL_VERSION MATNR_VERS CHAR 10   0   Version Number for MATERIAL Field  
155 P_MAT_EXT MGV_PR_REF_MAT_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for PR_REF_MAT Field  
156 P_MAT_GUID MGV_PR_REF_MAT_GUID MATNR_EGUID CHAR 32   0   External GUID for PR_REF_MAT Field  
157 P_MAT_VERS MGV_PR_REF_MAT_VERSION MATNR_VERS CHAR 10   0   Version Number for PR_REF_MAT Field  
158 FUNC_AREA FKBER_SHORT FKBER_SHORT CHAR 4   0   Functional Area  
159 ALTERN_BOM STLAL ALTNR CHAR 2   0   Alternative BOM  
160 FKK_CONACCT CHAR12 CHAR12 CHAR 12   0   Character Field of Length 12  
161 EAN_UPC EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
162 PRODCAT WMINR WMINR CHAR 10   0   Product catalog number *
163 SHIP_TYPE VSARTTR VERSART CHAR 2   0   Shipping type T173
164 S_PROC_IND SDABW SDABW CHAR 4   0   Special Processing Indicator TVSAK
165 FUNC_AREA_LONG FKBER FKBER CHAR 16   0   Functional Area *
166 BILL_REL CRM_FKREL CRM_FKREL CHAR 1   0   Billing Relevance (CRM)  
167 VW_UEPOS UEPVW UEPVW CHAR 1   0   ID for higher-level item usage  
168 CAMPAIGN CGPL_GUID16_R3 SYSUUID RAW 16   0   Generic project planning: GUID from external R/3 system  
169 DLVSCHDUSE ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
170 CFOP_LONG J_1BCFOP_LONG J_1BCFOP_LONG CHAR 10   0   CFOP code and extension *
171 SELECTION VBX_SEL_ID CHAR32 CHAR 32   0   Selection ID (Persistent)  
172 MAT_ENTRD MATWA MATNR CHAR 18   0   Material entered *
173 LOG_SYSTEM_OWN LOGSYS LOGSYS CHAR 10   0   Logical system *
174 ITM_TYPE_USAGE VWPOS VWPOS CHAR 4   0   Item usage *
175 TAXLAWISS J_1BTAXLW3 J_1BTAXLW3 CHAR 3   0   Tax law: ISS *
176 MAT_ENTRD_EXTERNAL MGV_MAT_ENTRD_EXTERNAL MATNR_EXT CHAR 40   0   Long Material Number for MAT_ENTRD Field  
177 MAT_ENTRD_GUID MGV_MAT_ENTRD_GUID MATNR_EGUID CHAR 32   0   External GUID for MAT_ENTRD Field  
178 MAT_ENTRD_VERSION MGV_MAT_ENTRD_VERSION MATNR_VERS CHAR 10   0   Version Number for MAT_ENTRD Field  
179 LOC_TAXCAT J_1AFITP_D J_1AFITP CHAR 2   0   Tax type *
180 LOC_ZEROVAT J_1ARFZVAT J_1ARFZVAT CHAR 1   0   Reason for zero VAT *
181 LOC_ACTCODE J_1AGICD_D J_1AGICD2 CHAR 2   0   Activity Code for Gross Income Tax *
182 LOC_DISTTYPE J_1ADTYP_D J_1ADTYP CHAR 2   0   Distribution Type for Employment Tax *
183 LOC_TXRELCLAS J_1ATXREL_ J_1ATXREL CHAR 10   0   Tax relevant classification *
184 CALC_MOTIVE BEMOT BEMOT CHAR 2   0   Accounting Indicator TBMOT
185 COMPREAS CMP_COMPREAS_COPY CMP_COMPREAS_COPY CHAR 4   0   Abbreviation for Complaints Reason  
186 FUND BP_GEBER BP_GEBER CHAR 10   0   Fund *
187 FUNDS_CTR FISTL FISTL CHAR 16   0   Funds Center *
188 CMMT_ITEM FM_FIPEX FM_FIPEX CHAR 24   0   Commitment item *
189 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
190 BUDGET_PERIOD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
191 TAXLAWCOFINS J_1BTAXLW4 J_1BTAXLW4 CHAR 3   0   COFINS Tax Law *
192 TAXLAWPIS J_1BTAXLW5 J_1BTAXLW5 CHAR 3   0   PIS Tax Law *
193 TREASURY_ACC_SYMBOL PSM_TAS CHAR30 CHAR 30   0   Treasury Account Symbol  
194 BUSINESS_EVENT_TCODE PSM_BETC CHAR10 CHAR 10   0   Business Event Transaction Code  
195 MODIFICATION_ALLOWED PSM_MOD_ALLOW CHAR1 CHAR 1   0   Modification Allowed  
196 CANCELLATION_ALLOWED PSM_CANC_ALLOW CHAR1 CHAR 1   0   Cancellation Allowed  
197 PAYMENT_METHODS DZWELS ZWELS CHAR 10   0   List of the Payment Methods to be Considered  
198 BUSINESS_PARTNER_NO PSM_BPN RCOMP CHAR 6   0   Business Partner Number *
199 REPORTING_FREQ PSM_REP_FREQ CHAR3 CHAR 3   0   Reporting Frequency  
200 SEPA_MANDATE_ID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
201 REQ_SEGMENT     CHAR 16   0    
202 TP_SUBLEVL FMFG_CORE_TP_SUBLEVL   CHAR 2   0   Sublevel Prefix (SP) for Trading Partner  
203 TP_AGENCID FMFG_CORE_TP_AGENCID   CHAR 3   0   Agency Identifier (AID) for Trading Partner  
204 TP_ALTRAID FMFG_CORE_TP_ALTRAID   CHAR 3   0   Allocation Transfer Agency Identifier (ATA) Trading Partner  
205 TP_BEGPER FMFG_CORE_TP_BEGPER   NUMC 4   0   Beginning Period of Availability (BPOA) for Trading Partner  
206 TP_ENDPER FMFG_CORE_TP_ENDPER   NUMC 4   0   Ending Period of Availability (EPOA) for Trading Partner  
207 TP_AVTYPE FMFG_CORE_TP_AVTYPE   CHAR 1   0   Availability Type Code (A) for Trading Partner  
208 TP_MAIN_ACCT FMFG_CORE_TP_MAIN_ACCT   CHAR 4   0   Main Account for Trading Partner  
209 TP_SUB_ACCT FMFG_CORE_TP_SUB_ACCT   CHAR 3   0   Subaccount for Trading Partner  
210 TP_BETC FMFG_CORE_TP_BETC   CHAR 10   0   Business Event Type Code for Trading Partner  
211 REQ_QTY WMENG MENG13 QUAN 13   3   Order quantity in sales units  
212 COND_TYPE_1 KSCHA KSCHL CHAR 4   0   Condition Type *
213 COND_VALUE_1 BAPICURR_D BAPICURR DEC 23   4   Currency amount in BAPI interfaces  
214 CURRENCY_1 WAERS WAERS CUKY 5   0   Currency Key *
215 COND_UNIT_1 KMEIN MEINS UNIT 3   0   Condition Unit *
216 COND_P_UNT_1 KPEIN KPEIN DEC 5   0   Condition pricing unit  
217 CURR_ISO_1 WAERS_ISO ISOCD CHAR 3   0   ISO code currency  
218 CD_UNT_ISO_1 KVMEI_ISO ISOCD_UNIT CHAR 3   0   Condition Unit in ISO Code *
219 COND_TYPE_2 KSCHA KSCHL CHAR 4   0   Condition Type *
220 COND_VALUE_2 BAPICURR_D BAPICURR DEC 23   4   Currency amount in BAPI interfaces  
221 CURRENCY_2 WAERS WAERS CUKY 5   0   Currency Key *
222 COND_UNIT_2 KMEIN MEINS UNIT 3   0   Condition Unit *
223 COND_P_UNT_2 KPEIN KPEIN DEC 5   0   Condition pricing unit  
224 CURR_ISO_2 WAERS_ISO ISOCD CHAR 3   0   ISO code currency  
225 CD_UNT_ISO_2 KVMEI_ISO ISOCD_UNIT CHAR 3   0   Condition Unit in ISO Code *
226 COND_TYPE_3 KSCHA KSCHL CHAR 4   0   Condition Type *
227 COND_VALUE_3 BAPICURR_D BAPICURR DEC 23   4   Currency amount in BAPI interfaces  
228 CURRENCY_3 WAERS WAERS CUKY 5   0   Currency Key *
229 COND_UNIT_3 KMEIN MEINS UNIT 3   0   Condition Unit *
230 COND_P_UNT_3 KPEIN KPEIN DEC 5   0   Condition pricing unit  
231 CURR_ISO_3 WAERS_ISO ISOCD CHAR 3   0   ISO code currency  
232 CD_UNT_ISO_3 KVMEI_ISO ISOCD_UNIT CHAR 3   0   Condition Unit in ISO Code *
233 NET_VALUE BAPICURR_D BAPICURR DEC 23   4   Currency amount in BAPI interfaces  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPNEA/MR3_ORDER_ITEM ACCNT_ASGN TVKT KTGRD    
2 /SAPNEA/MR3_ORDER_ITEM ASSORT_MOD WSOH SKOPF    
3 /SAPNEA/MR3_ORDER_ITEM BATCH MCH1 CHARG    
4 /SAPNEA/MR3_ORDER_ITEM BILL_BLOCK TVFS FAKSP    
5 /SAPNEA/MR3_ORDER_ITEM BILL_SCHED TFACD IDENT    
6 /SAPNEA/MR3_ORDER_ITEM BOMEXPL_NO SNUM SERNR    
7 /SAPNEA/MR3_ORDER_ITEM BUS_TRANST T605 EXART    
8 /SAPNEA/MR3_ORDER_ITEM CALC_MOTIVE TBMOT BEMOT    
9 /SAPNEA/MR3_ORDER_ITEM CSTG_SHEET T683 KALSM    
10 /SAPNEA/MR3_ORDER_ITEM CUST_GROUP T151 KDGRP    
11 /SAPNEA/MR3_ORDER_ITEM DEPARTM_NO TSAB ABTNR    
12 /SAPNEA/MR3_ORDER_ITEM DIVISION TSPA SPART    
13 /SAPNEA/MR3_ORDER_ITEM DLVSCHDUSE TVLV ABRVW    
14 /SAPNEA/MR3_ORDER_ITEM DLV_PRIO TPRIO LPRIO    
15 /SAPNEA/MR3_ORDER_ITEM DUNN_BLOCK T040S MANSP    
16 /SAPNEA/MR3_ORDER_ITEM DUNN_KEY T040 MSCHL    
17 /SAPNEA/MR3_ORDER_ITEM HG_LV_ITEM VBUP POSNR    
18 /SAPNEA/MR3_ORDER_ITEM INVO_SCHED TFACD IDENT    
19 /SAPNEA/MR3_ORDER_ITEM ITEM_CATEG TVPT PSTYV    
20 /SAPNEA/MR3_ORDER_ITEM ITM_NUMBER VBUP POSNR    
21 /SAPNEA/MR3_ORDER_ITEM MATERIAL MARA MATNR    
22 /SAPNEA/MR3_ORDER_ITEM MATFRGTGRP TMFG MFRGR    
23 /SAPNEA/MR3_ORDER_ITEM MAT_PR_GRP T178 KONDM    
24 /SAPNEA/MR3_ORDER_ITEM ORDERID AUFK AUFNR    
25 /SAPNEA/MR3_ORDER_ITEM PLANT T001W WERKS    
26 /SAPNEA/MR3_ORDER_ITEM PRC_GROUP1 TVM1 MVGR1    
27 /SAPNEA/MR3_ORDER_ITEM PRC_GROUP2 TVM2 MVGR2    
28 /SAPNEA/MR3_ORDER_ITEM PRC_GROUP3 TVM3 MVGR3    
29 /SAPNEA/MR3_ORDER_ITEM PRC_GROUP4 TVM4 MVGR4    
30 /SAPNEA/MR3_ORDER_ITEM PRC_GROUP5 TVM5 MVGR5    
31 /SAPNEA/MR3_ORDER_ITEM PRICE_GRP T188 KONDA    
32 /SAPNEA/MR3_ORDER_ITEM PRICE_LIST T189 PLTYP    
33 /SAPNEA/MR3_ORDER_ITEM PROD_HIERA T179 PRODH    
34 /SAPNEA/MR3_ORDER_ITEM PROFIT_CTR CEPC PRCTR    
35 /SAPNEA/MR3_ORDER_ITEM PROMOTION WAKH AKTNR    
36 /SAPNEA/MR3_ORDER_ITEM PR_REF_MAT MARA MATNR    
37 /SAPNEA/MR3_ORDER_ITEM PYMT_METH T042Z ZLSCH    
38 /SAPNEA/MR3_ORDER_ITEM REFLOGSYS TBDLS LOGSYS    
39 /SAPNEA/MR3_ORDER_ITEM REFOBJTYPE TOJTB NAME    
40 /SAPNEA/MR3_ORDER_ITEM REF_DOC VBUK VBELN    
41 /SAPNEA/MR3_ORDER_ITEM REF_DOC_IT VBUP POSNR    
42 /SAPNEA/MR3_ORDER_ITEM REQMTS_TYP T459A BEDAE    
43 /SAPNEA/MR3_ORDER_ITEM RESANALKEY TKKAA ABGSL    
44 /SAPNEA/MR3_ORDER_ITEM ROUTE TVRO ROUTE    
45 /SAPNEA/MR3_ORDER_ITEM SALES_UNIT T006 MSEHI    
46 /SAPNEA/MR3_ORDER_ITEM SHIP_POINT TVST VSTEL    
47 /SAPNEA/MR3_ORDER_ITEM SHIP_TYPE T173 VSART    
48 /SAPNEA/MR3_ORDER_ITEM STORE_LOC T001L LGORT    
49 /SAPNEA/MR3_ORDER_ITEM S_PROC_IND TVSAK SDABW    
50 /SAPNEA/MR3_ORDER_ITEM S_UNIT_ISO T006I ISOCODE    
51 /SAPNEA/MR3_ORDER_ITEM TARGET_QU T006 MSEHI    
52 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS1 TSKD TAXKD    
53 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS2 TSKD TAXKD    
54 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS3 TSKD TAXKD    
55 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS4 TSKD TAXKD    
56 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS5 TSKD TAXKD    
57 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS6 TSKD TAXKD    
58 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS7 TSKD TAXKD    
59 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS8 TSKD TAXKD    
60 /SAPNEA/MR3_ORDER_ITEM TAX_CLASS9 TSKD TAXKD    
61 /SAPNEA/MR3_ORDER_ITEM T_UNIT_ISO T006I ISOCODE    
62 /SAPNEA/MR3_ORDER_ITEM UNOF_WTISO T006I ISOCODE    
63 /SAPNEA/MR3_ORDER_ITEM UNTOF_WGHT T006 MSEHI    
64 /SAPNEA/MR3_ORDER_ITEM VAL_TYPE T149D BWTAR    
65 /SAPNEA/MR3_ORDER_ITEM VOLUNIT T006 MSEHI    
66 /SAPNEA/MR3_ORDER_ITEM VOLUNITISO T006I ISOCODE    
History
Last changed by/on SAP  20140121 
SAP Release Created in