request for alv reporting

[sreelatha_gullapalli]

hi all,

i tried to develop a report for the table that i created.

but i am not getting the result.

it showing dump

can any body tell me whether we can generate reports for ztables or not?

if it possible to generate reports for ztable can u please tell me the procedure

with regards,

Sreelatha Gullapalli

[former_member386202]

Hi,

Yes u can develop the report for z table. What type of error ur getting????

Regards,

Prashant

[Former Member]

hI

WE CAN CREATE A REPORT FOR ANY TABLES

WE CAN RETRIVE THE DATA FROM ZTABLES ALSO

IF DON'T MIND CAN YOU TELL ME WHERE YOUR PROGRAM GENARATES SHORT DUMP

AND POST YOUR CODE IF POSSIBLE

[Former Member]

Hi Sreelatha,

reports can be written for ur ztable..but what exactly is ur requirement..do u want to put data into it..

this progrm puts value to my ztable ydp_training...

REPORT ZUPDATE .

TABLES:PA0001,

YDP_TRAINING.

***********************************************************************

• SELECTION-SCREEN DESIGN *

***********************************************************************

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001. "NO INTERVALS .

SELECT-OPTIONS :S_PERNR FOR PA0001-PERNR NO-EXTENSION OBLIGATORY,

NAME FOR YDP_TRAINING-NAME NO-EXTENSION OBLIGATORY,

SKILL FOR YDP_TRAINING-SKILL NO-EXTENSION NO INTERVALS OBLIGATORY,

PROJECT FOR YDP_TRAINING-PROJECT NO-EXTENSION NO INTERVALS OBLIGATORY,

DOB FOR YDP_TRAINING-DATE_OF_BIRTH NO-EXTENSION NO INTERVALS OBLIGATORY.

SELECTION-SCREEN END OF BLOCK B1.

************************************************************************

TYPES:BEGIN OF TP_PERNR,

PERNR TYPE PERSNO,

STAT2 TYPE STAT2,

END OF TP_PERNR.

DATA:T_PERNR TYPE STANDARD TABLE OF TP_PERNR WITH HEADER LINE,

WA_PERNR TYPE TP_PERNR.

SELECT PERNR STAT2 INTO TABLE T_PERNR FROM PA0000 WHERE PERNR IN S_PERNR.

IF SY-SUBRC EQ 0.

READ TABLE T_PERNR INTO WA_PERNR WITH KEY PERNR = S_PERNR-LOW.

YDP_TRAINING-EMP_ID = WA_PERNR-PERNR.

YDP_TRAINING-NAME = NAME-LOW.

YDP_TRAINING-SKILL = SKILL-LOW.

YDP_TRAINING-PROJECT = PROJECT-LOW.

YDP_TRAINING-DATE_OF_BIRTH = DOB-LOW.

MODIFY YDP_TRAINING ..

WRITE :'iNSERTED'.

ENDIF.

hope this helps..

Reagrds,

kaveri

[Former Member]

Hi Sreelatha,

Yes you can use Ztable in reports for getting the data in the table for that you have to fill the ztabe first with some sample values and fetch data from the table as usual like other defined table in sap.

THe procedure is first you create the ztable by the following steps.

1.goto se11-->give the ztable name in database table*(for e.g ZTEST)

2.press create button--> you will get new window there give short description and deliveery class as A

3.And click the field tab enter the field name you want in ztable.

4.Click the technical settings and gave the data class press (F4) to get values there and give sizw category.

5.then activate the table.

6.Then click utilities and create entries for the ztable.

After the start using the ztable in the report as like standard table.

Thanks,

Sakthi C

*Rewards if useful*