DB Table for Change request number against material

[Former Member]

Dear MDG gurus,

I need DB table that has change request number against material.

I checked USMD12* series of tables but no luck.

Please help!

Regards,

Tushar C.

[former_member831149]

Hai this is khaleel

i have a question

1 WHAT IS THE TABLE FOR CR

2 I have a CR Number I Want know what is CR type of that number . How do i know it

can you plz help me how to know this

[raghu3 · Accepted solution]

Hi,

As far as I know USMD1213 should have the necessary details.

Regards,

Raghu

[Former Member · Accepted solution]

Hi Raghu,

The table USMD1213 does not have field material number. It has

Entity Type

Sequence Number

Entity Type

Characteristic Value 

against CR no.

Thank you!

Any more suggestions...

[raghu3 · Accepted solution]

Hi ,

Table USMD1213 is a generic table which is used to store the details of all the entities. Hence it will not have field called "Material number". Use theentity type MATERIAL in field Entity type of table USMD1213 and material number in field Characteristic Value

Regards,

Raghu

[former_member831149 · Accepted solution]

Hai this is khaleel

i have a question

1 WHAT IS THE TABLE FOR CR

2 I have a CR Number I Want know what is CR type of that number . How do i know it

can you plz help me how to know this

[raghu3 · Accepted solution]

Hi,

Check USMD120C table

Regards,

Raghu

[Former Member]

Thank you all Kiran, Raghu, MDG user.

I have got the answer.

USMD1213-USMD_VALUE = /1MD/MD______001-USMDKMMMATERIAL

Cheers,

Tushar C.

[Former Member]

Hi Tushar,

This is not straight forward.

As Raghu told, you could find the details from table USMD1213. Or could be read from change document tables CDHDR and CDPOS passing object as USMD_ACT.

This table holds the CR number and the Technical Key of a Material.

From the Technical Key you can get the raw Material no from your generated table. Execute USMD_DATA_MODEL and find the generated table as told by Kiran.

[former_member831149]

Hai this is khaleel

i have a question

1 WHAT IS THE TABLE FOR CR

2 I have a CR Number I Want know what is CR type of that number . How do i know it

can you plz help me how to know this

[former_member206605]

Hi

Check the tables through USMD_DATA_MODEL program. Give the data model and check the tables...

Kiran

[Former Member]

Hi Kiran,

I checked it.

The list does not have the table that has CR no. against material number.

Thank you!

[former_member831149]

Hai this is khaleel

i have a question

1 WHAT IS THE TABLE FOR CR

2 I have a CR Number I Want know what is CR type of that number . How do i know it

can you plz help me how to know this