Skip to Content
0
Former Member
Dec 15, 2006 at 02:55 PM

how to call database view in report

1132 Views

Hi i have a small problem in report

the problem is like this i had created a database view in which i got all the values displayed but can any one of you tell me how to declare this database view in report with example

i had created a database view named as znew1

and the fields are

LIFNR LIKE EKKO-LIFNR,

EBELN LIKE EKKO-EBELN,

LIFNR1 LIKE LFA1-LIFNR,

NAME1 LIKE LFA1-NAME1,

EKBE LIKE EKBE-EBELN,

VGABE LIKE EKBE-VGABE,

MATNR LIKE EKPO-MATNR,

WERKS LIKE EKPO-WERKS,

NETWR LIKE EKPO-NETWR,

MENGE LIKE EKPO-MENGE,

MWSKZ LIKE EKPO-MWSKZ,

TXZ01 LIKE EKPO-TXZ01,

KOSTL LIKE EKKN-KOSTL,

PS_PSP_PNR LIKE EKKN-PS_PSP_PNR,

EBELN1 LIKE EKKN-EBELN,