RICEFW ID MM-I101

Description Material/Model Master Interface from SAP to 3rd Party System

From System SAP
To System 3rd Party System
Business Scope To access and use Material Master in 3rd Party System system which is created in SAP
Data Volume
Update Method IDOC
SAP Format (IDOC # MATMAS05 )
SAP Material/Model Master Field Mapping

S.No SAP Field Mandatory/Optional IDOC Type

1 Material type M MATMAS05
2 Plant M MATMAS05
3 Material Number M MATMAS05
4 Material Description M MATMAS05
5 Plant-Specific Material Status O MATMAS05
6 Product Hierarchy O MATMAS05
7 Base unit of measurement M MATMAS05
8 Moving Average Price M MATMAS05
9 Price Unit M MATMAS05
10 Material Group M MATMAS05
11 Gross Weight O MATMAS05
12 Net Weight O MATMAS05
13 Weight Unit O MATMAS05
14 Volume O MATMAS05
15 Volume Unit O MATMAS05
16 EAN O MATMAS05
17 Old Material Number O MATMAS05
18 Profit Center M MATMAS05
19 Purchase Group O MATMAS05
20 Sales Organization M MATMAS05
21 Distribution channel M MATMAS05
22 Division M MATMAS05
23 Storage Location M MATMAS05
24 MRP Type M MATMAS05
25 MRP Controller (Materials Planner) M MATMAS05
26 Special procurement type M MATMAS05
27 Reorder Point M MATMAS05
28 Sales Order Unit M MATMAS05
29 Pur.Ord.Unit M MATMAS05
Alternative Unit of Measure for Stockkeeping M MATMAS05
30 Unit
Numerator for Conversion to Base Units of M MATMAS05
31 Measure
Denominator for conversion to base units of M MATMAS05
32 measure
Alternative Unit of Measure for Stockkeeping M MATMAS05
33 Unit
Numerator for Conversion to Base Units of M MATMAS05
34
Measure
Denominator for conversion to base units of M MATMAS05
35
measure
reated in SAP

IDOC Structure
Field Value
Segment Field Name Length Condition/Logic Confirmed Field Value
E1MARAM MTART 4 Yes Material Types
E1MARCM WERKS 4 Yes GKP1
E1MARAM MATNR 18 NA
E1MARAM MAKTX 40 NA
E1MARCM MMSTA 2 NA
E1MARAM PRDHA 18 NA
E1MARAM MEINS 3 NA
E1MBEWM VERPR 12 NA
E1MBEWM PEINH 3 NA
E1MARAM MATKL 9 NA
E1MARAM BRGEW 13 NA
E1MARAM NTGEW 13 NA
E1MARAM GEWEI 3 NA
E1MARAM VOLUM 13 NA
E1MARAM VOLEH 3 NA
E1MARAM BSTKD 13 NA
E1MARAM BISMT 18 NA
E1MARCM PRCTR 10 NA
E1MARCM EKGRP 3 NA
E1MVKEM VKORG 4 Yes 7991
E1MVKEM VTWEG 2 NA
E1MARAM SPART 2 NA
E1MARDM LGORT 4 NA
E1MARCM DISMM 2 NA
E1MARCM DISPO 3 NA
E1MARCM SOBSL 2 NA
E1MARCM MINBE 13 NA
E1MVKEM VRKME 3 NA
E1MARAM BSTME 3 NA
E1MARMM-Z1Y0NMM_UOM MSEHI 3 NA

E1MARMM UMREZ 5 NA

E1MARMM UMREN 5 NA

E1MARMM-Z1Y0NMM_UOM MSEHI 3 NA

E1MARMM UMREZ 5 NA

E1MARMM UMREN 5 NA
 3rd Party System

Remarks Sample Data 3rd Party System

ZROH Product Type
GKP1 Site
Material Number 30003543 Product Name/Product Code
GEN MACHANICALProduct Description
Z1 Plant-Specific Material Status
020321066135311 Product Hierarchy
PC Unit of Measurement
3000 Moving Average Price
1 Price Unit
DISO Product Group
100 Gross Weight
99 Net Weight
KG Weight Unit
100 Volume
L Volume Unit
12345 EAN
M32421 Old Material Number
799100021A Profit Center
N01 Purchase Group
7991 Sales Organization
10 Distribution channel
07 Division
0003 Storage Location
VB MRP Type
N01 MRP Controller (Materials Planner)
40 Special procurement type
300 Reorder Point
PAC Sales Order Unit
BOX Pur.Ord.Unit
PAC Alternative UoM (SO or PO Unit)

1 PAC=10 PC 10 Numerator

1 Denominator

BOX Alternative UoM (SO or PO Unit)

1 BOX=5 PC 5 Numerator

1 Denominator
 3rd Party System

Table/File Name Field Size Conversion Logic

RICEFW ID
Description Purchase Order Status
From System SAP
To System 3rd Party System
Business Scope To send PO number etc. information to 3rd Party System after successful PO creation
Data Volume
Update Method IDOC
SAP Format (IDOC # ORDERS05 )
SAP Source List Field Mapping IDOC Structure
S.No SAP Field Mandatory/Optional IDOC Type Segment

1 PO Document Type M ORDERS05 E1EDK01

2 PO Document Number M ORDERS05 E1EDK01
3 Vendor M ORDERS05 E1EDK01
4 Purch. Org. M ORDERS05 E1EDK14
5 Purch. Group M ORDERS05 E1EDK14
6 Company Code M ORDERS05 E1EDK14
7 Creation Date M ORDERS05 E1EDK03
8 Creation Time M ORDERS05 E1EDK03

1 Item number of purchasin M ORDERS05 E1EDP01

2 Action M ORDERS05 E1EDP01

3 Item catagery O ORDERS05 E1EDP01
4 Purchase order quantity M ORDERS05 E1EDP01
5 Purchase order unit of MeaM ORDERS05 E1EDP01
6 Quantity in price unit M ORDERS05 E1EDP01
7 Price Unit of Measure M ORDERS05 E1EDP01
8 Net Price M ORDERS05 E1EDP01
9 Price unit M ORDERS05 E1EDP01
10 Net Order Value M ORDERS05 E1EDP01
11 Unit of Weight M ORDERS05 E1EDP01
12 Material group M ORDERS05 E1EDP01
13 Denominator for Conv. of OrM ORDERS05 E1EDP01
14 Numerator for Conversion ofM ORDERS05 E1EDP01
15 Plant M ORDERS05 E1EDP01
16 Storage location M ORDERS05 E1EDP01
17 IDOC object identification M ORDERS05 E1EDP19
18 Material number M ORDERS05 E1EDP19
19 Short text M ORDERS05 E1EDP19
20 Scheduled quantity O ORDERS05 E1EDP20
21 Previous scheduled quantityO ORDERS05 E1EDP20
22 Scheduling Date O ORDERS05 E1EDP20
IDOC Structure
Field Name Length Field Value confirmed Field Value
Header Data
BSART 10 Yes List
BELNR 10 NA NA
RECIPNT_NO 10 NA NA
ORGID 4 Yes List
ORGID 3 NA NA
ORGID 4 NA List
DATUM 8 NA NA
UZEIT 6 NA NA
Item Data
POSEX 6 NA 00010

ACTION 3 NA 002
PSTYP 1 NA
MENGE 15 NA 2
MENEE 3 NA PC
BMNG2 15 NA 2
PMENE 3 NA PC
VPREI 13 NA 100
PEINH 5 NA 1
NETWR 18 NA 200
GEWEI 3 NA KG
MATKL 9 NA 1000321
BPUMN 5 NA
BPUMZ 5 NA
WERKS 4 NA GKP1
LGORT 4 NA 0003
QUALF 3 NA
IDTNR 18 NA 30000342
KTEXT 70 NA Bearing
WMENG 15 NA
AMENG 15 NA
EDATU 8 NA
 3rd Party System
Remarks Sample Data Salesforce Table/FileName
ta
ZNB PO Document Type
SAP PO Number
Vendor Account
GKP1 Purch. Org.
001 Purch. Group
GKP1 Company Code
29042020 Creation Date
17:34:23 Creation Time

001- PO Item is created

002- PO Item is changed
003- PO Item is deleted

This field will be used to find out whether the

Item is deleted or changed or newly created

Net price of the item

Per 1 PC, cost is 100
Total Item value. It means item qty*net price
3rd Party System
Field Size Conversion Logic
Material Types
ZROH Raw materials
ZFG Finished Goods

Plants
Plant Description
GKP1 GK PVP
GKP2 GK Vizag