Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Foreign Key addition

I have three tables

Header

Doc No. --key field

Doc Yr --key field

Line Item

Doc No. --key field

Doc Yr --key field

Line Item --key field

Sub line item table

Doc No. --key field

Doc Yr --key field

Line Item --key field

Sub line item --key field

These tables do not have foreign key.

Now these tables have been transfered to production & they contain huge data.

I want to create maintenance view. For this i need to create Foreign key for:

Line item

Doc No. --key field --Foreign Key --Doc No. Of header

Doc Yr --key field --Foreign Key --Doc year. Of header

Line Item --key field

Sub line item table

Doc No. --key field --Foreign Key --Doc No. Of header

Doc Yr --key field --Foreign Key --Doc year. Of header

Line Item --key field --Foreign Key --Line Item Of line item

Sub line item --key field

My question is will this affect my data in the tables in production. Will it ask for conversion of table.

PLZ help!

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question