topic Re: Regarding Reports in Application Development and Automation Discussions

Regarding Reports

Former Member — Wed, 13 Aug 2008 04:32:18 GMT

Hi Gurus,

I have 4 tables VBRK,VBAK,VBRP & KNA1 and i need to display out put from them when i am taking the internal tables , with which one i need to loop the internal tables and read the data. i.e which is the main internal table & hw can i select that ?

waiting for ur reply

Regards

Srinath

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 04:33:42 GMT

HI ,

Loop on the internal table with VBAK

Edited by: A kumar on Aug 13, 2008 6:40 AM

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 04:37:16 GMT

hi,

VBAK contains Sales Order Header Data.

Loop that Table.

VBRK and VBRP provides Billing Header and Item Data which is based on SAles Document No.

KNA1 have Customer Information.

Regadrs

Sumit Agarwal

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 04:37:58 GMT

Hi,

Always loop on item table.

Here u have to loop on Billing Document: Item Data VBRP.

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 04:39:43 GMT

LOOP the table VBAK.


LOOP VBRP WHERE VGBEL = VBAK-VBELN.
READ TABLE VBRK with key VBELN.

READ KNA1.
append final table.
ENDLOOP.
ENDLOOP.

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 04:45:35 GMT

Hi ...

Some are saying one table & others saying other tables . How exactly i will come to know which is the main table and hw to select and loop on that table?

Regards

Srinath

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 04:46:35 GMT

hi,

wt ever our friends said is correct if u want only header data ...

& corresponding item data , partner data and customet info...

it will give u only one record...

it multiple line items contains per single sales order it wont give correct anss..

u may miss some records..

if u sales order have more than one line items & u want to display all items..

loop the VBRK internal table pass the rest info....

Regards..

Raju Mummidi.

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 04:50:52 GMT

Do like below code.

Loop at it_vbrk.

Loop at it_vbrp where vbeln eq it_vbrk-vbeln.

Read table it_kna1.

Read table it_vbak.

Endloop.

rgds

rajesh

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 05:14:40 GMT

Hi you can do like this :

There are two ways like if the billing data mandatory then do like this :

Loop at vbrk. " because for vbrk you need item details

Loop at vbrp where vbeln equals vbrk-vbeln. item details

Read table vbak.

if sy-subrc eq 0

Read table kna1 for kunnr .

endif.

Endloop.

Loop at vbak.

Read table kna1 for kunnr .

read table vbrk for vbeln

if sy-subrc = 0

Loop at vbrp where vbeln equals vbrk-vbeln. item details

Endloop.

endif.

Endloop.

Re: Regarding Reports

Former Member — Wed, 13 Aug 2008 05:23:56 GMT

Hi,

VBAK(Sales Document: Header Data) is the Main table.

LOOP the table VBAK.

LOOP The table VBRK .

Read the table VBRP.

Read the Table KNA!.

append final internal table.

ENDLOOP.

Regards,

Srinivasa Janardhan.