Pricing issue

[Former Member]

Hi Friends,

I have a requirment that i have to find sales orders using a specific condition record .

e.g PR00 condition type has suppose 3 access sequnce z001,z002,z003.

And z001 access sequnce has 2 tables e.g 002,003

My requirment is to find an sales orders with this condition tables.

As we have millons of sales orders wht is the work around here.

With high priority

Please suugest me a work around here.

[safeer_rahman2]

Hi Jayesh...

I don't think one condition type can have 3 access sequence... Kindly check weather its a copy of PR00 ...

Thanks,

Safeer Rahman

[safeer_rahman2]

Hi friend..

You can check the table KONV via SE16 and check the field KONV-KNUMH.

Revert in case you need step by step process..Hope this helps...

Thanks,

Safeer Rahman

[former_member183879]

Hi,

A condition type can have only one access sequence. YOu cannot have morethan 1 as to one conditition type.

Second

If you want to find out all the condition records for a condition type, do the following.

1. Find out the condition tables in ur access seq belonging to that condition type, say the tables are 911 and 823

2. Now go to table A911( just add A before the condition table) in SE16 and give the condition table as input. Now you will get all the condition records updated for the condition type in this condition table.

3. Now do this for A823

You can extract these details in excel sheet and then analyse.

If you want to know all the sales orders which have values from these condition records.

The tables A823, A911 will have a field called KNUMH. Take these values

Go to KONV in SE16 and in the input give the KNUMH as the input for the field KONV-KNUMH and execute.

Now you will get the output . From the output get the fields KONV-KSCHL, KONV-KNUMV, KONV-KBETR etc

Come to VBAK, give KONV-KNUMV as the input for VBAK-KNUMV

Now you will get all the sales orders which have the condiiton records for ur condition type

Hope this helps you

Pls reward if this helps you

[former_member720197]

Hi,

Are you sure that condition type you are looking has access sequences. I dont think condition type will have more than one access sequence.

Please ellobrate your requirement.

Anand.