Suman Sardar

July 16, 2013 1 minute read

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;

VBAK
LIKP
VBRK
MKPF

And corresponding Item details from the below tables;

VBAP
LIPS
VBRP
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

Purchasing Table

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$

35 Comments

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

Former Member

July 17, 2013 at 4:54 am

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

Suman Sardar

Blog Post Author

July 17, 2013 at 5:07 am

Hi Arya,

Thanks for the reply.

Yes it is time saving.

Thanks,

Suman$

Former Member

August 1, 2013 at 3:29 am

Hi,

Very handy info suman. Thanks for sharing. Sukant

Amit Anasane

July 17, 2013 at 5:10 am

Thanks for sharing usefull info..

Suman Sardar

Blog Post Author

July 17, 2013 at 5:54 am

Thanks for the comment Amit 🙂

Suman Sardar

Blog Post Author

July 17, 2013 at 5:52 am

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$

Siva Prasad V

July 17, 2013 at 6:27 am

Hi Suman,

Thank you for sharing its working Fine

Iam Able to Execute the Tables- (without WBGT)

Former Member

July 17, 2013 at 6:21 am

Hi SumanS,

Thanks for sharing such valuable a valuable doc.

Regards

-AJC

Suman Sardar

Blog Post Author

July 17, 2013 at 6:43 am

Thank you Ashish..

' MoazzaM '

July 17, 2013 at 8:23 am

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$

Suman Sardar

Blog Post Author

July 17, 2013 at 9:34 am

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$

' MoazzaM '

July 17, 2013 at 10:13 am

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$

Suman Sardar

Blog Post Author

July 17, 2013 at 10:23 am

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

Former Member

July 22, 2013 at 7:37 am

Thanks for sharing this useful information.

Regards

Manjit Dhiman

Suman Sardar

Blog Post Author

July 22, 2013 at 8:04 am

Thanks Dhiman..

Govind Krishna Kumar Thiagarajan

July 25, 2013 at 8:03 am

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

Suman Sardar

Blog Post Author

July 25, 2013 at 10:42 am

Thanks Govind.

Former Member

July 25, 2013 at 11:08 am

Hi Suman$,

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

Regards,

Anirban Sukul

Suman Sardar

Blog Post Author

July 25, 2013 at 4:05 pm

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

Srinu S

August 1, 2013 at 8:33 am

Thanks Suman for sharing this useful information.

Regards,

srinu.

Suman Sardar

Blog Post Author

August 1, 2013 at 9:05 am

Thank You

Former Member

August 5, 2013 at 4:04 am

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

Suman Sardar

Blog Post Author

August 5, 2013 at 4:40 am

Thank you Venu

Siva Prasad V

February 3, 2014 at 12:43 pm

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

Former Member

September 29, 2014 at 7:17 am

Good it is.

Nilesh R Pawar

November 10, 2014 at 5:34 am

Thanks Suman!!!

Vignesh Veerasamy

December 30, 2014 at 9:41 am

Dear Suman,

Great document.

Vignesh.V

Gerald Brosch

February 20, 2015 at 9:35 am

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

joan mas

February 21, 2015 at 9:14 am

Hi,

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

Regards,

Gerald Brosch

February 23, 2015 at 2:03 pm

Thanks Joan! BR GB

Former Member

August 17, 2015 at 8:55 am

Thanks for sharing!

Thangam Perumal

August 17, 2015 at 9:57 am

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

Suman Sardar

Blog Post Author

August 17, 2015 at 10:14 am

Try this one.

WB2_V_EKKO_EKPO2

Pradeep Mani

August 24, 2015 at 7:23 am

Thanks for Sharing

Sai Konda

March 9, 2018 at 1:13 am

Wonderfull information Suman.

Regards

Sai

Some Useful Tables with Header and Item details

Assigned Tags