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
Showing results for 
Search instead for 
Did you mean: 
Read only

Foreighn key issue

Dsk
Active Contributor
0 Likes
657

guru,

1. I have created a selfdefined info structure(sis) using Mc21.

2. I am trying to generate a planning hierarcy ..using the tcode mc61 for my SIS

3. I am getting the following error.

Reg the Screen "SAPMMCP6" 7492 contains a syntax error

4. when i go to the mentioned screen in se51 and do a syntax check i get the follwoing errror

Foreign key generation error for field "S895-ZMATNRR" .

5. I also checked the table s895 and did a syntax check - found consistent.

6. This is the foreighn key characteristics..

Check tabl ChkTablFld For.key ta Foreign key

MARA MANDT ZCPGLTP MANDT

MARA MATNR ZCPGLTP ZMATNRR

MARA MATKL

7. In the mara table i have the matkl also selected as a Primary key -fyi.

With above details do any one have of fixing this issue.

Reg

DsK.

1 ACCEPTED SOLUTION
Read only

JozsefSzikszai
Active Contributor
0 Likes
567

"7. In the mara table i have the matkl also selected as a Primary key -fyi."

in MARA only MATNR is key field. Or did you change the standard?

ec

guru,

1. I have created a selfdefined info structure(sis) using Mc21.

2. I am trying to generate a planning hierarcy ..using the tcode mc61 for my SIS

3. I am getting the following error.

Reg the Screen "SAPMMCP6" 7492 contains a syntax error

4. when i go to the mentioned screen in se51 and do a syntax check i get the follwoing errror

Foreign key generation error for field "S895-ZMATNRR" .

5. I also checked the table s895 and did a syntax check - found consistent.

6. This is the foreighn key characteristics..

Check tabl ChkTablFld For.key ta Foreign key

MARA MANDT ZCPGLTP MANDT

MARA MATNR ZCPGLTP ZMATNRR

MARA MATKL

7. In the mara table i have the matkl also selected as a Primary key -fyi.

With above details do any one have of fixing this issue.

Reg

DsK.

2 REPLIES 2
Read only

JozsefSzikszai
Active Contributor
0 Likes
568

"7. In the mara table i have the matkl also selected as a Primary key -fyi."

in MARA only MATNR is key field. Or did you change the standard?

ec

Read only

Dsk
Active Contributor
0 Likes
567

we havent changed the key - it is because of the service stack applied recently it has changed in the VBRP table and more other tables.