Sales order line item to configuration table

[former_member629897]

Hello, does anyone know a table name that links the sales order- line item combinations to their configuration and characteristic value assignments?

[Former Member]

If you don't need to know all of the links, there is a function module that you can use to get a list of an order's characteristics and values. It is VC_I_GET_CONFIGURATION. Input INSTANCE = VBAP-CUOBJ value and execute. Check the output of the CONFIGURATION table.

[Samaun]

Hi angela.scott,

This is helpful.

[former_member629897]

Hi angela.scott fire.fighter ,

Thanks for your help. I did find the way to get to this data. It was via a link between INOB-->AUSP. You can use the object number in INOB (in this case a batch object (MATNR+PLANT+BATCH) then the field CUOBJ links to OBJEK in AUSP to provide the characteristic values (ATINN). This is also possible for material objects, & sales order objects. the INOB and AUSP tables can be queried for multiple classes, so I've used it now in the batch class 022, material class 001, and the variant class 300.

[former_member629897]

The sales order lint was a bit harder to do. It required a link between IBINOWN (using sales order object (ORDER+ITEM) to V_IBINR to V_IBIN_SYVAL. Once in V_IBIN_SYVAL you can search for ATINN (characteristic) and ATWRT (characteristic value)

[former_member42743]

This is not an easy straight forward linking.

Almost anything related to classification links thorough either the INOB table to KSSK_INOB, (INOB_KSSK?).

You might want to start there.

Craig

[former_member629897]

Hi Craig, Thanks for your reply. How do you recommend I link the tables? I found the "configuration" in sales order table VBAP-CUOBJ, as the internal object number in INOB, but I don't get any data. Do you know what I'm doing wrong?

[former_member42743]

Have you tried using the FM Angela suggested above to see if there are values there? (SE37), You can use the test functionality to enter in your object number and see if SAP returns any values.