How to Find the Table Navigation Logic for Sales Document Variant Configuration (CUOBJ) Values
Many times we are using BAPIs / Function modules to fetch the characteristics values for the Sales Order, Deliveries and Invoices. But it may cause the performance issue in the program. Also as a functional consultant we have to remember the FM names for the required characteristics values and sometimes we do not have such authorization to execute the FM. This can be easier to us if we know the table navigation just like other sales tables joining logic to fetch the characteristics values based on SO/DO/Bill. The below table join logic will help to fetch the values for the Variant Characteristic’s values.
Remarks: You need to go to these tables IBIN and V_IBIN_SYVAL.
IBIN has VBAP object number and use that to get the IB: unique record number and then go to V_IBIN_SYVAL using that record number as the key.
Use Configuration Object number (VBAP-CUOBJ) to read the instance value in table IBIN and then get corresponding characteristics values selected from view V_IBIN_SYVAL
Similarly we can find it for LIPS-CUOBJ,VBRP-CUOBJ & etc.
Table join diagram;
VBAP IBIN V_IBIN_SYVAL
Figure 1: A sample Table join logic view through SQVI
Order Number: 400035129 (Line Item: 10)
- VBAP: Enter order no, get Configuration (CUOBJ): 4264666 leading zeroes not needed.
2. IBIN: Enter Component (INSTANCE): 4264666.
Get Record Number (IN_RECNO): KPNzEgcN483X08002XC4FG
3. V_IBIN_SYVAL: Enter Record Number (IN_RECNO).
Get Internal Char no. (ATINN) and Characteristic Value (ATWRT) (Multiple values for these two fields).
Step by Step Screen Shot
Figure2: Sales order item configuration (CUOBJ) data
Figure3: VBAP-CUOBJ in table IBIN-INSTANCE
Figure4: Record number from table IBIN with the help of Component (VBAP-CUOBJ)
Figure5: IBIN-IN_RECNO in table V_IBIN_SYVAL
Figure5: Sales Order item Variant Configuration Values
I hope this document will help to test the sales vc values required in various reports as output.
End of Document
Very helpful document.
Thanks for the comment, Srinu
Its really very useful doc.
Thanks for sharing...
Thanks for the comment, Khushi
Its really a very helpful docs.
Thanks for sharing and keep it on. 🙂
Thanks a lot Suman...very useful.
Thank you, Govind
Thanks keep on sharing
Thank you Sourav.
Thank you sir
thanks a lot for sharing nice document
Thank you Venu
Nice doc..... Thanks for sharing.
Useful method..thank you.
Thanks for the appreciation.
but all process its not working , your process also not working when run the report system takes dump because some of the characteristic value enter numeric ( like 11250 , 1.5 )
characteristics: THIKNESS , WIDTH , LENGTH etc ,
without numeric values its working
@suman: check once again and also run your report
Thanks for the comment but in my case it is working fine for the VC numeric values.
I am not an ABAPer so I do not know that is there any technical coding you have to take care or not.Can you share what exactly you are getting error.
Thank you Neeraj
You can also use txn CUTABLEINFO to get the characteristic values for sales order or CUOBJ.
This is extremely good document especially because you have shown how to create a query , so that we can use this report for multiple sales orders.This is not possible in either CUTABLEINFO or in the Function Module VC_I_GET_CONFIGURATION which I normally use for single order only.
However these is a limitation here that I could see the characteristic values, but not the descriptions of the values, which is possible in the earlier two ways.
Having said, that I appreciate your effort on this. Though simple, not many people know how the joins work in IBIN (atleast I am not aware of this)
Thanks for this.
Thanks for the appreciation.
And yes there are other ways to achieve which is also useful for various requirement.
Its very much usefull..
Its very much usefull.
It is very useful and we are not getting character description in the table V_IBIN_SYVAL.
This is a good information, but by this solution we are getting entire list of Variant which are Not selected in SO. The Variants which are Not Selected during Sales Item Configuration are also seen in this list.
I have requirement only to show the list of Variants which are selected in SO.
Can you provide suggestion on the same.
VBAP inner join IBIN
on IBIN~INSTANCE = VBAP~CUOBJ
inner join V_IBIN_SYVAL
on V_IBIN_SYVAL~IN_RECNO = IBIN~IN_RECNO