Skip to Content
Author's profile photo Suman Sardar

Some Useful Tables with Header and Item details

Many times we are fetching data from the various tables where we have to take the Header details and also the Item details and to do that we have to incorporate the logic to the ABAPers with the proper Primary and Foreign key logic to fetch the correct data to build any Logistics report like Sales report.

As we all know that for any sales report we have take the following tables data as Header tables;

  1. VBAK
  2. LIKP
  3. VBRK
  4. MKPF

And corresponding Item details from the below tables;

  1. VBAP
  2. LIPS
  3. VBRP
  4. MSEG

And same is applicable for the Purchase report also.

Here are some tables which is as VIEW category where SAP has taken care the joining and the both Header and Item details can be seen in the SE16 or SE16N at a glance.

Table Name Short text
WB2_V_EKKO_EKPO Data Selection from PO
WB2_V_EKKO_EKPO2 Data Selection from PO (without WBGT)
WB2_V_LIKP_LIPS Data Selection from Deliveries
WB2_V_LIKP_LIPS2 Data Selection from Deliveries (without WBGT)
WB2_V_MKPF_MSEG Data Selection from Material Documents
WB2_V_MKPF_MSEG2 Data Selection from Material Documents (without WBGT)
WB2_V_RBKP_RSEG Select Invoice Verification Documents
WB2_V_RBKP_RSEG2 Select Invoice Verification Documents (without WBGT)
WB2_V_VBAK_VBAP Data Selection from SO
WB2_V_VBAK_VBAP2 Data Selection from SO (without WBGT)
WB2_V_VBRK_VBRL Data Selection from Customer Billing Document Lists
WB2_V_VBRK_VBRL2 Data Selection from Cust. Billing Doc. Lists (without WBGT)
WB2_V_VBRK_VBRP Data Selection from Customer Billing Document
WB2_V_VBRK_VBRP2 Data Selection from Customer Billing Documents (w/o WBGT)

Here are sample screen shot attached as reference;

Sales Billing Table

WB2-VBRK.jpg

Purchasing Table

WB2-EKKO.jpg

The above tables are very useful to check the Itemized details at a glance like Material Movement details,Billing details,Purchase details and etc.

Hope this is helpful.

Thanks,

Suman$

Assigned tags

      35 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Suman$,

      thanks for the great information shared by you.It always becomes easier when we can get details of header and item table data in a single table.

      Regards

      Arya Nath

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Hi Arya,

      Thanks for the reply.

      Yes it is time saving.

      Thanks,

      Suman$

      Author's profile photo Former Member
      Former Member

      Hi,

      Very handy info suman. Thanks for sharing. Sukant

      Author's profile photo Amit Anasane
      Amit Anasane

      Thanks for sharing usefull info..

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Thanks for the comment Amit 🙂

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Hi Siva,

      For example go to SE16N and and put the table name WB2_V_MKPF_MSEG2 and execute it should display records.

      Thanks,

      Suman$

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      Hi Suman,

      Thank you for sharing its working Fine

      Iam Able to Execute the Tables- (without WBGT)

      Author's profile photo Former Member
      Former Member

      Hi SumanS,

      Thanks for sharing such valuable a valuable doc.

      Regards

      -AJC

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Thank you Ashish..

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hi Suman

      Can you please share where and why we will use these tables instead of VBAK VBAP VBRK and VBRP etc?? What is the difference between VBRP and WB2_V_VBRK_VBRP2?

      Thank$

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Hi Moazzam,

      Every time we have to check some test case like canceled invoice when we have to take the data from the Header table VBRK and usually copying all the VBRP-VBELN to paste it in the VBRP to take the item data.

      So we can take both the datas from the single table "WB2_V_VBRK_VBRP2".

      I think this is useful to save some time.

      Thanks,

      Suman$

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      I didnt notice this. Yes you are right. It'll save time and its new thing for me to learn. Thanks for sharing Suman 🙂

      Thank$

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Thank you MoazzaM.... It feels great to hear such comment from you. 🙂

      Author's profile photo Former Member
      Former Member

      Thanks for sharing this useful information.

      Regards

      Manjit Dhiman

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Thanks Dhiman..

      Author's profile photo Govind Krishna Kumar Thiagarajan
      Govind Krishna Kumar Thiagarajan

      Very useful tables...appreciate you sharing this with all:)

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Thanks Govind.

      Author's profile photo Former Member
      Former Member

      Hi Suman$,

                      This is very much helpful and time saving. Thanks for sharing. 🙂

      Regards,

      Anirban Sukul

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Thank you for the comment.Hope you are enjoying using it. 😉

      Author's profile photo Srinu S
      Srinu S

      Thanks Suman for sharing this useful information.

      Regards,

      srinu.

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Thank You

      Author's profile photo Former Member
      Former Member

      Hai suman .. thank you so much for your information ...nice posting keep it up it will help a lot

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Thank you Venu

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      Hi Suman,

      Please can we get the Tables in the same way for PP(production) Module

      i have serached but not able to Locate

      Regards

      Siva

      Author's profile photo Former Member
      Former Member

      Good it is.

      Author's profile photo Nilesh Pawar
      Nilesh Pawar

      Thanks Suman!!!

      Author's profile photo Vignesh Veerasamy
      Vignesh Veerasamy

      Dear Suman,

      Great document.

      Vignesh.V

      Author's profile photo Gerald Brosch
      Gerald Brosch

      Can you please explain the difference of the 2 views for example WB2_V_EKKO_EKPO and WB2_V_EKKO_EKPO2 (w/o WBGT)?
      Why does view WB2_EKKO_EKPO does not contain any data in our System but the other view?

      Thanks,

      Gerald

      Author's profile photo joan mas
      joan mas

      Hi,

      WBGT stands for Global Trade. If you don´t  use GTM, take those views ending with 2 in the document.

      Regards,

      JM

      Author's profile photo Gerald Brosch
      Gerald Brosch

      Thanks Joan! BR GB

      Author's profile photo Former Member
      Former Member

      Thanks for sharing!

      Author's profile photo Thangam Perumal
      Thangam Perumal

      Thanks for sharing. If i select in SE16N, it is coming "No Values found" but we have values in EKKO & EKPO.

      Author's profile photo Suman Sardar
      Suman Sardar
      Blog Post Author

      Try this one.

      WB2_V_EKKO_EKPO2

      Author's profile photo Pradeep Mani
      Pradeep Mani

      Thanks for Sharing

      Author's profile photo Sai Konda
      Sai Konda

      Wonderfull information Suman.

      Regards

      Sai