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

Figure1.png

Figure 1: A sample Table join logic view through SQVI

Example:

Order Number: 400035129 (Line Item: 10)

  1. 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.png

Figure2: Sales order item configuration (CUOBJ) data

Figure3.png

Figure3: VBAP-CUOBJ in table IBIN-INSTANCE

Figure4.png

Figure4: Record number from table IBIN with the help of Component (VBAP-CUOBJ)

Figure5.png

Figure5: IBIN-IN_RECNO in table V_IBIN_SYVAL

Figure6.png

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.

Thanks,

Suman$

End of Document

To report this post you need to login first.

28 Comments

You must be Logged on to comment or reply to a post.

  1. Anirban Sukul

    Dear Suman,

                       Its really a very helpful docs.

                       Thanks for sharing and keep it on. 🙂

    Regards

    Anirban

    (0) 
  2. BOJJA SIVASANKAR REDDY

    hi suman

    nice document

    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

    (0) 
    1. Suman Sardar Post author

      Hi,

      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.

      (0) 
  3. Navaneetha Krishnan

    Hi Suman,

    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.

    (0) 
    1. Suman Sardar Post author

      Hi Krishnan,

      Thanks for the appreciation.

      And yes there are other ways to achieve which is also useful for various requirement.

      Thanks,

      Suman

      (0) 

Leave a Reply