cancel
Showing results for 
Search instead for 
Did you mean: 

Sales order line item to configuration table

0 Kudos

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

former_member244309
Participant

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.

matsikun
Explorer
0 Kudos

Hi angela.scott,

This is helpful.

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.

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)

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member42743
Active Contributor
0 Kudos

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

0 Kudos
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
Active Contributor
0 Kudos

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.