Sales order configuration

[Former Member]

Hi everybody,

Sales order is created by va01. Since there is variant config. is implemented, the sales order is configured at the same time. Characteristic values are entered for the characteristics.

Can i know in which table these values & the characteristics are updated????

Regards,

Manish

[Former Member · Accepted solution]

Table CAWN.

Also check the table KSML.

If helps rewards points and close this thread.

Regards

TAJUDDIN

Message was edited by:

TAJUDDIN MOHAMMED

[Former Member · Accepted solution]

Hi,

Thanks for the reply.

Actually i am developing the customized z report where for a paticular sales order no i want to display the value entered for the characteristics.

For ex---

Sales order no--100

Char---Colour

Value--- RED

In the report i want to display above information.

Can i use the same tables mentioned by you i.e CAWN & KSML???

What will be the field name???

Regards,

Manish

[Former Member · Accepted solution]

Hi,

Thanks for the reply.

Actually i am making specification document for developing the customized z report where for a paticular sales order no i want to display the value entered for the characteristics.

For ex---

Sales order no--100

Char---Colour

Value--- RED

In the report i want to display above information.

Can i use the same tables mentioned by you i.e CAWN & KSML???

What will be the field name???

Regards,

Manish

[Former Member · Accepted solution]

FOR EVERY TRANSACTION , WE CAN FIND THE TABLES FROM THE FIELDS

GO TO >>>>>T.CODE: SE84

>>>>> ABAP DICTIONARY

>>>>>FILEDS

>>>>> TABLE FILED

HERE ENTER THE FILED NAME WHICH TAKEN BY

CLICK THE FIELD ON WHICH THE YOU HAVE TO VIEW

AND PRESS F1 KEY

TECH DATS IS AVAIL

SELECT THE FIELD NAME

ENTER THIS FIELD NAME TO THE ABOVE TABLE FIELD

YOU CAN VIEW THE TABLES RELATED TO THE SALES OF WANT

[Former Member · Accepted solution]

Hi MHP,

I dont think this information will be available in one table. You have to combine tables VBAP-VBAK with KSML and AUSP from Query SQ01 to get desired results.

Take help of ABAP if you are not aware about query cretaion.

If helps rewards points and close this thread.

Regards

TAJUDDIN

[Former Member · Accepted solution]

Thanks for the reply. I will try along with the abaper

Redards,

Manish

[Former Member]

Manish,

I think you have not read my previous message in detail. It gives the table names to be used. I have given the sequence of usage too. You can use them in query.

Regards

Ram

[Former Member]

Manish,

Getting the sales order configuration values is a long process. Do the following:

1) Get IBINOWN-INSTANCE passing OBJKEY as sales order item concatenated (ex OBJKEY= 0000001152000010 if sales order itm is 1152/10)

2) Pass the above instance number to IBIN-INSTANCE. (remember NOT to drop zeroes) and get the internal record number IN_RECNO.

3) Pass this internal record number to table IBINVAL_SEL-IN_RECNO. You would get the Inst characteristics and the charact values (ATWRT and ATVLV).

Regards

Ram

[Dsk]

1.If your requirement is to get the configuration values i can give another method of using a function module

2. Use teh function module VC_I_GET_CONFIGURATION

3. input parmater is cuobj - this willbe available in your sales order VBAP-CUOBJ

or vbap-CUOBJ_CH ( sorry i used long before)

4. This will actually meet your requirments ..

If you are so specific on the Tables let me know ..

Kindly check this and give us the feedback..

Thanks and Regards,