Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Link between MATNR and table PRPS

Former Member

‎2006 Mar 03 1:51 PM

0 Likes
1,306

Hello,

I need to get a field from the PRPS table, but I only have the material number, does anybody know how I can retrieve fields from PRPS?

Regards Baljinder

Hello,

I need to get a field from the PRPS table, but I only have the material number, does anybody know how I can retrieve fields from PRPS?

Regards Baljinder

Reply
4 REPLIES 4
Read only

Former Member

‎2006 Mar 03 1:55 PM

0 Likes
905

Hi,

There is MATNR field in PRPS table , you can select with the help of taht.

Theja

Read only

Former Member

‎2006 Mar 03 1:55 PM

0 Likes
905

U have MATNR in PRPS table.

Pass MATNR and get data

Read only

Former Member
In response to Former Member

‎2006 Mar 03 2:14 PM

0 Likes
905

No that didn't work, I have a material number, (from the MARA table) and I need the USR02 field in the PRPS table. I have retrieved the WBS by using the tables SRRELROLES and JPOBJLINK... but how do I get from here, I have the wbs now but I need the USR02 firld of PRPS...

Read only

Former Member

‎2006 Mar 03 2:14 PM

0 Likes
905

Hello Baljinder,

There is a field in PRPS table however if u try and access the table with this field you will

1. get duplicate records so not sure which to pick

2. Performance issue unless u do it with select single.

You will have to give more inputs surrounding ur query so that a solution can be provided.