In sales order Char & Value

[Former Member]

Dear fnds,

Iam from SD forum, In sales order for Variant(__Variant configuration__) material user needs to selects the Charecters and values for material i need print to sales order confirmation form...i tried a lot with my knowledge...and i serched in forum finally i got the Diff Table called AUSP i tried with that ..but iam not getting link with sales....

Can you please give some mapping to this Requirment.

Thanks in Advance

Regards

raj.

Edited by: venky raj on Mar 24, 2009 6:01 AM

[Subhankar]

HI ...

First get the vbap-cuobj. Using this value call the FM CUCB_GET_SINGLE_INSTANCE.

call function 'CUCB_GET_SINGLE_INSTANCE'

exporting

instance = wa_matnr-cuobj

importing

instance_rec = l_instance

exceptions

invalid_instance = 1

instance_is_a_classification = 2

others = 3.

Thanks

Subhankar

[Former Member]

Dear all,

i need to Fetech the Data w.r.to Sales Order...

Thanks in Advance

Regards

raj.

[Former Member]

You can use FM VC_I_GET_CONFIGURATION_IBASE in the CEI0 function group. Just send in the VBAP-CUOBJ into the INSTANCE parameter.

[ChadRichardson]

If your question is how to pull values out of the material's classifications tab, below is an example.

SELECT ausp_{objek cawnt}atwtb

FROM cabn

INNER JOIN ausp ON ( cabn_{atinn = ausp}atinn AND

cabn_{adzhl = ausp}adzhl )

INNER JOIN cawn ON ( cabn_{atinn = cawn}atinn AND

cawn_{atwrt = ausp}atwrt )

INNER JOIN cawnt ON ( cabn_{atinn = cawnt}atinn AND

cawn_{atzhl = cawnt}atzhl )

INTO TABLE t_internal_table

WHERE cabn~atnam = 'ClassificationName'.

The SELECT above returns a table of objek (material number) and atwtb (classification value) for all materials that have a "ClassificationName" assigned.

Hope this helps...

Chad

[Former Member]

Hi Venky,

Use FM CLAF_CLASSIFICATION_OF_OBJECTS.

You get all the characteristic values w.r.t material

regards,

Rishikesh

[Former Member]

Dear all,

I tried with all ,But i didnt get any link with Sales table.

Thanks in Advance

regards

raj.

[Former Member]

tables: KDST ,CABN