finding the fields from the table.

[Former Member]

in which table i will find

brand ( ex : raymonds, park avenue like)

color ( ex : red,green, yellow;.........etc)

style...( ex : long,short, medium)

these fields are required for generating the sales order report daily........

what r the tables req for this report......

thanks & regards,

kartik p.

[Former Member]

Hello,

I think this is relared to varian configuration. So check the tables related to class and characteristics

KLAH Class Detail

CABN Characteristic Detail

AUSP Characteristic Values

CAWN Characteristic Values

CAWNT Characteristic Value Texts

KSML Characteristic Allocation to Class

KSSK Material Allocation to Class.

Prase

[Former Member]

Hi,

Some SAP standard fields may have been used to save this information. Since they are product related, I am suspecting any of the following fields may have been used.

1. Material group (VBRP-MATKL)

2. External material group (not found in invoice directly; to be retrieved from MARA based on material code - MATNR. Field EXTWG)

3. Any of the 5 material groups - Material groups 1 - 5 (VBRP-MVGR1, VBRP-MVGR2, VBRP-MVGR3, VBRP-MVGR4, VBRP-MVGR5).

If this data is required for 'order report', then VBRP given above can be replaced with VBAP.

Cheers,

KC

SAP SD

Edited by: Krishna Chandika on May 9, 2008 7:16 PM

[alpesh_saparia3]

Hi Kartik,

Fields you mentioned are customized fields, no one else will find these fields.

Press F1 and F9 to get the fieldname then you can trace the table from there.

-Alpesh