Serial No Table

[Former Member]

I want a report which sholud contain the Serial no, Material code on Date wise.

Means If i want to see what was my Material & serial no in month or Jan or feb.

In the initial screen it should be based on date .

Can abnybody pl. guide me Which are the Table to be consider ??

Biswajit

[Former Member]

the question is not clear.

explain about it.

[Former Member]

Means it sholud able to see the List of Serial no against the material code on Posting Date wise.

I hope niw it is clear.

Biswajit

[Former Member]

take the table MARA - General Material Data

here the field ERSDA is Created On

according to this date sort your output..

[Former Member]

Your explanation is still not completely clear. Anyways, you can use EQUI table for getting the Material and Serial numbers. Then you can take the ERDAT field to get the "creation date".

[Former Member]

hi,

you dint mention in which table u want the data...

according to my view...go to table VBAP...get the posnr , matnr and abdat......

[Former Member]

hi for getting the serial nos

1

2

3

4....

do like this

DATA: LINUM(6) TYPE C,

LV_POSNR TYPE POSNR,

LV_LEN TYPE I.

READ TABLE IN_PAR WITH KEY 'VBDPA-POSNR'.

LV_POSNR = IN_PAR-VALUE.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = LV_POSNR

IMPORTING

OUTPUT = LV_POSNR.

LV_LEN = STRLEN( LV_POSNR ).

LV_LEN = LV_LEN - 1.

MOVE LV_POSNR(LV_LEN) TO LINUM.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = LINUM

IMPORTING

OUTPUT = LINUM.

CONDENSE LINUM NO-GAPS.

READ TABLE OUT_PAR WITH KEY 'LINUM'.

CLEAR OUT_PAR-VALUE.

MOVE LINUM TO OUT_PAR-VALUE.

MODIFY OUT_PAR INDEX SY-TABIX.

[Former Member]

the table equi itself give u all details

equnr erdat matnr

or else u want?

which posting date u r talking about.

u want salesorderwise or anything else ?