Skip to Content
0

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

Dec 14, 2016 at 10:11 AM

420

avatar image

Hii All

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

-Sales Document Type

-Customer

-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


Thanks

Romzi

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
2

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

Thanks

Romzi

0

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

0

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

-Partner

Please help

Thanks

Romzi

0
G Lakshmipathi
Dec 14, 2016 at 11:27 AM
0

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?

Thanks

Romzi

0
Romzi Bukkar Dec 15, 2016 at 09:08 AM
0

Hii Mr. G Lakshmipathi

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

Because my access to the current https://support.sap.com/notes are problem.

Thanks

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

Hi Ramzl ,

Did you resolved your issue ?

Share
10 |10000 characters needed characters left characters exceeded