Sales order condition type description

[Former Member]

HI Gurus,

During Sales Order Processing, I created a material with variant configuration pricing. System pick up the correct pricing but on Condition Tab the in Name of Condition Type (Field VTEXT) is reflecting the variant description (from VK30) instead of condition type description.

I want the description of Condition Type and not the variant. Can any one guide how to extract the description of the Condition Type (user wants to ensure the correct pricing for the correct condition type).

Thanks.

Regards

PSK

[Former Member]

Bern

The whole idea of VK30 is to provide a Description for the variant condition which comes to play based on the Procedure ( e.g. $SELF.VARCOND = XXXX or table - CU60). It also gives an idea what is the feature or addition that is causing the surcharge/price to happen like that. It is definitely not possible via config to change its description, but with coding you can do anything. I wouldn't recommend it. Explain it to your user community and they will understand.

Also did you try maintaining same text for all variants? I don't know if it is feasible, but you can try.

Hope this helps.

[Former Member]

Chandra,

My scenario is:-

1. User key in the package e.g. item no A001 Package A , variant criteria; Training type=A, Course type=A & No of student=10

all the package items are stored in Pricing procedures condition types

e.g. ZA01 Classroom 100

ZA02 Whiteboard 20

ZA03 Projector 50

VK30 setup as A-A-10 Package A training (AA10)

A-A-20 Package A training (AA20)

A-A-30 Package A training (AA30)

when pricing are computed, description of the condition type become:

ZA01 Package A training (AA10) 100

ZA02 Package A training (AA10) 20

ZA03 Package A training (AA10) 50

User wanted to ensure the detail pricing are correct, but with the same description on every pricing condition type they are not able to check and distinguish. (my actual package is more than 10 pricing condition). So, you can see the confusion or rather user unsure how to check each of the correct pricing condition type.

You mentioned that with coding it is possible. May I ask, do you know which user exit, BADI etc?

I do not know what you meant by "Also did you try maintaining same text for all variants?"

Thanks.

Regards

Bern

[Former Member]

Dear Bern,

Why dont you maintain the same description as condition types at VK30.

So by default, same description will be appeared as you wish.

Regards,

Mullairaja

[Former Member]

Hello Bern

I have misunderstood your question, I thought you are bothered by several variant names appearing for one condition type. With your example things became clear. I did not get what are the figures 100, 20 50 at the end signify when you say, for example ZA01 Classroom 100, I am guessing it is the quantity or the price. but leave it aside. With regard to coding, I meant it generally and I am not aware of any user Exit/BAPI.

But I have a config solution proposal for you.

From your example all the 3 condition types - ZA01 to ZA03 - are leading to the same variant, i.e., A-A-10 whose description is Package A training (AA10). In stead of that, lead them to 3 different variants with the following descriptions (example for AA10)

Condition type Leads to Variant Whose descriptions is

ZA01 A-A01-10 Package A training - AA10 - Classroom

ZA02 A-A02-10 Package A training -AA10 - Whiteboard

ZA03 A-A03-10 Package A training -AA10 - Projector

Similarly for AA20

ZA01 A-A01-20 Package A training -AA20 - Classroom

ZA02 A-A02-20 Package A training -AA20 - Whiteboard

ZA03 A-A03-20 Package A training -AA20 - Projector

Agreed it would increase your config load- set of characteristics. variants and descriptions, but that is the best option for you.

So your characteristics would be increased by 1 and the new set includes:

Resource type : Values: C (Classroom),W ( Whiteboard) , P ( Projector) - This is a new characteristic you need to add.

Others, from your existing design remain as they are, i.e., Training type, Course type & No of students.

Assuming that you are using Variant table for variant determination, it would now read as follows:

Table name (assume): ZTRGPKG

Resource Trgtype Course Number Z _PRICE -

---

> Characteristics

Resource Type Training type Course Type No. Of Students Resource Price

Classroom A A 10 A-A01-10

Whiteboard A A 10 A-A02-10

Projector A A 10 A-A03-10

Classroom A A 20 A-A01-20

Whiteboard A A 20 A-A02-20

Projector A A 20 A-A03-20

Procedure would be coded like this

Table ZTRGPKG

(Z_PRICE = $SELF.PRICE,

Resource = Resource, Trgtype = Trgtype, Course = Course, Number = Number)

Hope I am clear. Revert with any questions.

[Former Member]

Hi Chandra,

First of all, I just got to test today (after a long break).

The rest was not as expected. I tried 2 ways:-

1. Resource - characteristics is single value

Not able to pick up the description. Price is however computed correctly.

2. Resource - characteristics is multi value

Characteristics - Resource

Values

01 Classroom

02 Whiteboard

03 Projector

All other characteristics is single value-

Training

Course Type

Student

During compiling the dependencies CU01 error occur, error message

"E28124 Current parameter ZRESOURCE2 in table/function ZTRAIN is multiple value

E28024 Syntax error in simple action/procedure"

Any clue or what is the correct way/steps to rectify both in item 1. and 2. to make it work?

Regards

Bernard

[Former Member]

Bern

Not completely sure what you did.

The Resource characteristic should be single value for value assignment.

What do you mean when you say-" Not able to pick up the description. Price is however computed correctly".

What is showing up as description and before that what's showing up as variant for example when you pick the following values in order config

Resource -01

Training- A

Course type- A

Number -10

is it resulting in Variant condition A-A01-10 ?

You can see this in the config screen- results. Tell me what's happening there?

[Former Member]

Chandra,

"Not able to pick up the description. Price is however computed correctly"

What I meant was, it is still not picking the right description as per your method. Pricing is computed correctly.

To ensure I am in sync with you, below are all my setups:-

1. Characteristics

ztraining, value assignment is single value, values: A, B & C

zcourse_type, value assignment is single value, values: A, B & C

zstudent, value assignment is single value, values: 10, 20 & 30

and

zresource - value assignment is single value

Values: 01 Classroom

02 Whiteboard

03 Projector

2. table

key fields: ztraining, zcourse_type, zresource and zstudent

key values: A-A01-10, A-A01-20 and A-A01-30

3. Dependencies

000010 table ztrnpkg

000020 (ztraining = ztraining,

000030 zcourse_type = zcourse_type,

000040 zresource = zresource,

000050 Zstudent = Zstudent,

000060 zprice = $self.price)

4. VK30 Variant condition

A-A01-10 Package A training - AA10 Classroom

A-A02-10 Package A training - AA10 Whiteboard

A-A03-10 Package A training - AA10 Projector

A-A01-20 Package A training - AA20 Classroom

A-A02-20 Package A training - AA20 Whiteboard

A-A03-20 Package A training - AA20 Projector

4. Pricing

ZA01 A-A01-10 Price $10

A-A01-20 $50

ZA02 A-A02-10 Price $20

A-A02-20 $60

ZA03 A-A03-10 Price $30

A-A03-20 $70

5. Sales order computation

Enter material Pack-A

VC input:

Training type: A

Course type: A

Resource : 01 (Can input 1 resource only)

Student :10

Pricing computation:

ZA01 Package A training - AA10 Classroom $10

(Computed correctly; description and pricing)

The other 2 condition are not computed; nothing appear in the pricing condition

ZA02 Package A training - AA10 Whiteboard

ZA03 Package A training - AA10 Projector

However, when I change the input Resource : 02

only ZA02 Package A training - AA10 Whiteboard appear in the pricing condition. ZA01 is gone.

Question:

How does system pick up all the package pricing condition for ZA01, ZA02 & ZA03 based on the Resource that you mentioned?

Regards

PSK

[Former Member]

Got it, silly me. I made a mistake. I missed the point that we have only one config (screen). But we are on the right track. Drop the resource characteristic we don't need it , in stead create 3 characteristics for the 3 prices like this:

Zprice1- for Classroom

Zprice2- for Whiteboard

Zprice3- for Projector

create 3 Variant tables (CU60), I know workload is increasing

Table 1- Zcrprice

Characteristics in that:

ztraining, zcourse_type, zstudent and Zprice1

Sample contents:

A, A, 10, A-A01-10

A,A,20, A-A01-20

Table 2- Zwbprice

Characteristics in that:

ztraining, zcourse_type, zstudent and Zprice2

Sample contents:

A, A, 10, A-A02-10

A,A,20, A-A02-20

Table 3- Zprjprice

Characteristics in that:

ztraining, zcourse_type, zstudent and Zprice3

Sample contents:

A, A, 10, A-A03-10

A,A,20, A-A03-20

Set up 3 dependencies like this:

First one:

Table Zcrprice

(Z_PRICE1 = $SELF.PRICE,

ztraining = ztraining, zcourse_type = zcourse_type, Zstudent = Zstudent)

Next one:

Table Zwbprice

(Z_PRICE2 = $SELF.PRICE,

ztraining = ztraining, zcourse_type = zcourse_type, Zstudent = Zstudent)

Last one

Table Zprjprice

(Z_PRICE3 = $SELF.PRICE,

ztraining = ztraining, zcourse_type = zcourse_type, Zstudent = Zstudent)

Let me know if this works for you. I am suggesting this because tables don't work well with multiple value characteristics.

[Former Member]

Hi Chandra,

First of all, I can't input the values in the table of content CU60. Error occur "

Value "A-A02-10" of characteristic Whiteboard does not exist in line 1".

I believe it can't recognize the keys

Table 2- Zwbprice

Characteristics in that:

ztraining, zcourse_type, zstudent and Zprice2

Sample contents:

A, A, 10, A-A02-10

A,A,20, A-A02-20

where:

A=training A=course type, 10=student; and when you create the key combination of the 3 A-A02-10 system cannot find or combination the 3 fields.

Need your further advise. Thanks.

Regards

Bernard

[Former Member]

Well Bernard

Essentially you need to copy the concept that you did before with one characteristic (zprice) and one table (ztrnpkg).

Did you set up characteristics Zprice1-Zprice3 as reference characteristics with reference to table "SDCOM" and field "VKOND"?

Did you see the help for the error message- may be it will give you some clues about what is wrong? Can you include the details of that error message in the next post?

Let me know.

[Former Member]

Chandra,

My answer:

Essentially you need to copy the concept that you did before with one characteristic (zprice) and one table (ztrnpkg).

<PSK> Ok, done.

Did you set up characteristics Zprice1-Zprice3 as reference characteristics with reference to table "SDCOM" and field "VKOND"?

<PSK> Ok, done

Did you see the help for the error message- may be it will give you some clues about what is wrong? Can you include the details of that error message in the next post?

<PSK> Message below during execution:

When dependency ZTRAIN was being processed, a runtime error occurred in an external table access (table ZTRAIN). The attempt to infer one or more values failed. This is because several entries were found in this table for a key declared as single-value.

Computation:

None of the pricing condition came out.

I did a trace and the log are below:-

000001 584 Dynamic database (DDB) loaded to no. 999999999999990001S

000002 300 Table ZTRNPKG - Entry is not unique

000003 > ZTRAINING A

000004 > ZCOURSE_TYPE A

000005 > ZSTUDENT 10

000006 598 Procedure ZTRAIN terminated

000007 > $ROOT .ZTRAINING A

000008 $ROOT .ZCOURSE_TYPE A

000009 $ROOT .ZSTUDENT 10

Hope you have a solution with all these testing results.

Regards

PSK

[Former Member]

So let me recap.

1) You set up 3 new pricing characteristics- Zprice 1-3 and they have been set up with ref to table SDCOM and Field VKOND.

2) You set up 3 tables and 3 procedures. What are their names?

3) Have you commented out the old procedure ( which you did for Zprice and took it out of the config profile and circulation?Tto play safe remove the contents of old table ( ZTRNPKG).

Do all these, test and come back with errors (details) if any.

[Former Member]

Chandra,

2) You set up 3 tables and 3 procedures. What are their names?

<PSK> The tables and procedures are the same name Zcrprice, Zwbprice and Zprjprice.

3) Have you commented out the old procedure ( which you did for Zprice and took it out of the config profile and circulation?Tto play safe remove the contents of old table ( ZTRNPKG).

<PSK> Yes, all done.

This time no error messages but still pricing not computed. My tracing log:-

000001 584 Dynamic database (DDB) loaded to no. 999999999999990001S

Any further clue?

Regards

PSK

[Former Member]

No, I am clueless now!!!

1) Did you maintain the condition records for Zprice1, Zprice2 and Zprice3 for various variants?

2) Variant keys are case sensitive. In object dependencies, you must enter the variant key in exactly the same form as in the condition table. Check that.

3) How did you code the procedure? Check that: It should be

zprice1 = self. zprice1 in procedure 1 for class room ( and not zprice1 = self. price)

zprice2 = self. zprice2 in procedure 2 for white board

and

zprice3 = self. zprice3 in procedure 3 for projector

4) What is Pricing analysis saying in the order pricing screen?

First work with the above and see what happens.

If it did not work, one last try.

Create 3 more characteristics exclusively for the tables, say Zprice1_cr, zprice2_wb and zprice3_prj. All are single value and are not reference characteristics.

So table Zcrprice will now consist of:

ztraining, zcourse_type, zstudent and Zprice1_cr

and table Zwbprice will now consist of:

ztraining, zcourse_type, zstudent and Zprice1_wb

and table Zprjprice will now consist of:

ztraining, zcourse_type, zstudent and Zprice1_prj

All 3 procedures will change as follows - sample for class room

Table Zcrprice

(Zprice1_cr = $SELF.zprice1, ztraining = ztraining, zcourse_type = zcourse_type, Zstudent = Zstudent)

other procedures will be coded similarly.

Lets see what happens now.

[Former Member]

Chandra,

I will leave this for the time being cos user wants to see the posting to FI.

I tried to post but hit error with message " 000010 The item is not relevant for billing".

Any steps that is missing in the account assignment?

For account determination, in SE11 I already extend structures KOMCV and KOMPCV for VARCOND field. Access seq for account assignment is by customer by account key

What else?

Regards

PSK

[Former Member]

Bern

You are almost there. Did you try anything from my last post at all or not? If yes, let me know what happened.

As regards to error mesage, check the item cat config- Field ' Billing relevance'.

If that is OK, may be copy control is missing from Sales do/Delivery to Billing for that item cat.

I don't think the issue is because of account determination config.