Skip to Content

Foreign Key Cannot be created fo the selected field A999(Table name) - WTY_V_PARVW

Dec 14, 2016 at 10:11 AM


avatar image

Hii All

Why when the create condition table with field catalog :
-Sales Organization

-Sales Document Type


-Partner Role (PartnerFunction)

Displays a Warning Message : 859 Foreign Key Cannot be created for the selected field A999 (Tablename) - WTY_V_PARVW.

And when do the transaction key combination I've made can not be used.
Please explanation



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

G Lakshmipathi
Jan 04, 2017 at 01:47 PM

Sorry copy pasting the content from other source is against SCN RoE. If you have any issue in accessing Service Marketplace, you can take the help of your colleagues to download the said note.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Dear Mr. G Lakshmipathi

Okay no problem I already have such Note, But the problem still can not be solved.

Do you have other solutions ?

It's likein sapnote




Hi Romzi,

Can you check the partner type/partner that you are maintaining in the condition record, whether that is getting determined in your sales order?

In my opinion, you choose a wrong to field to cater your requirement.

If the field in question is WTY_V_PARVW? This field is relevant for append Structure WTYKOMKWTY - KOMKWTY Data for Warranty Processing. Although this field available in KOMK structure. But, that doesn't mean you have this field will be available in SD pricing field catalog without enhancement. Thus, this is not available in SD pricing by default. By the way, this field is relevant to table B360, B361, PNWTYH, PNWTYV, WTY_PARTNER_TAB. At least not for VBAk/VBAP/VBPA. And if you want to see where you can find this field by default. Then check warranty pricing field catalog. To do that use check Tcode OWTYP11 and go into one of the access sequence fields.

Now, if you want the partner function in SD pricing field catalog. Then refer following SAP Help link as a reference.

- SAP Help Portal: New Fields into Field Catalog

PS: Although the link is related to output, but you can very much apply the same logic in SD pricing.

Thanks, JP


Hii Jyoti Prakash

Thanks for your help Okay I understand if a field with WTY not the field of sales.

I am confused by the explanation of the link you provided:

SAP Help Portal: New Fields into Field Catalog

basically I just want, add a discount based on the partner function.

I've tried with the key combination as follows:

- Sales Organization

- Doc Type

- Customer / Sold to party

- Partner function (PARVW) additional field a catalog

The result is a failure to assign access sequences.

If I add a catalog field:

- Partner (WTY_V_PARNR)

As your explanation of the field instead of field sales.

Do you ever make dicount based partner function?

I need this combination:

-Sales Org

-Order Type

-Sold to party

-Partner Function


Please help



G Lakshmipathi
Dec 14, 2016 at 11:27 AM

Take the inputs as suggested in OSS note 1935754 though it is related to MM and try in SE11.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hii G Lakshmipathi

I had been following the instructions in the note but could not Fixed

Maybe you have another way?



Romzi Bukkar Dec 15, 2016 at 09:08 AM

Hii Mr. G Lakshmipathi

I ask for your help, could you paste the note here?

Because my access to the current are problem.


10 |10000 characters needed characters left characters exceeded
Capgemini Capgemini Apr 06, 2017 at 10:09 AM

Hi Ramzl ,

Did you resolved your issue ?

10 |10000 characters needed characters left characters exceeded