topic Re: condition record access in Application Development and Automation Discussions

condition record access

Former Member — Tue, 13 Dec 2005 19:20:07 GMT

Hi! all..

what can be the reason for this?

we have an access sequence. in it we have 4 condition tables. condition records are maintained for all the four.

only the condition record for the 4th table is pulled into sales order pricing.

(( we infact have exclusion indiactor ON for the first 3 condition tables. ))

we have user exits to pull in the values of fields in the first three condition tables to KOMP. will that be a problem?

the userexit code is

select single ort01 into ZZORT01 from KNA1 where

kunnr = tkomk-kunwe. ort01 - ship-to party city field.

let me tell you the steps in SD pricing config. please let me know if i missed out any step.

1. create condition tables.

2. assign them to an acc. seq.

3. assign the condition type to the access seq.

4. put the cond. type in a pricing procdure.

5. assign this to the combo. of sales area/ cust.PP/order PP.

6. maintain condition records.

it shud work right.

i dont know where the mistake is. it's not working.please help me out. is it in the config. is it in the code?

what to modify and how?

tested my scenario both in DEV and TEST system. same result, same failure.

thank you all.

-sri.

Re: condition record access

Former Member — Tue, 13 Dec 2005 19:55:42 GMT

What do you see in the pricing analysis for the sales order ? Possiblity is it doesn't find records in the other 3 condition tables.

Which exit have you used to populate the komp field ? Debug the exit and check if the requried condition table fields are filled up with proper values .

Message was edited by: Kalpana Tyagi

Re: condition record access

Former Member — Tue, 13 Dec 2005 23:35:53 GMT

it does fill the values in the sales order.all it doesnt do is read the condition rec. and put the condition amt.

in pricing analysis under the VALUE IN DOC. column

it shows all the right values of the fields we added.

the user exit we used is USEREXIT_PRICING_PREPARE_TKOMP

let me add one thing here..

it rightly reads the cond. record for the table whose fields are just from the sap standard.

actually the system doesnt read the condition recs. for tables which have the zz fields we added to the pricing catalog.

so what cud be the reason?

where can i check it?

thanks a lot and please help me.

please give your inputs. i am really powerless here.

-neez.

Re: condition record access

christian_wohlfahrt — Wed, 14 Dec 2005 10:04:29 GMT

Hi!

Looks like you have done all necessary steps. So it's time for debugging.

Start with a SQL-trace during a order creation (or a re-pricing). Check in the trace, if there are selects for your tables.

If no - then select statement preparation is no OK -> check customizing or debug for error.

If yes - check with SE16, why nothing was found.

Regards,

Christian

Re: condition record access

Former Member — Wed, 14 Dec 2005 10:23:16 GMT

Hi,

Have a look if the conditions are active. There will be a flag KINAK on the XKOMV which determines whether the condition is active.

Also have a look at the pricing routines in (VOFM), if some routine is not rejecting that condition for some reason.

Hope it helps.

regards,

Satya

Re: condition record access

Former Member — Wed, 14 Dec 2005 15:10:54 GMT

If you see the values it finds in the pricing analysis , go and look for the condition record in AXXX, KONH, KONP tables for those exact values.

Check if the validity period is current and also check if u have correct entries in table T681F for the new fields u added.

One more point , make sure there is no requirement routine attached in the access seq .

- Kalpana

Message was edited by: Kalpana Tyagi