topic Re: Serial No Table in Application Development and Automation Discussions

Serial No Table

Former Member — Tue, 24 Mar 2009 07:04:48 GMT

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

Re: Serial No Table

Former Member — Tue, 24 Mar 2009 07:12:26 GMT

the question is not clear.

explain about it.

Re: Serial No Table

Former Member — Tue, 24 Mar 2009 09:42:36 GMT

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

Re: Serial No Table

Former Member — Tue, 24 Mar 2009 09:45:16 GMT

take the table MARA - General Material Data

here the field ERSDA is Created On

according to this date sort your output..

Re: Serial No Table

Former Member — Tue, 24 Mar 2009 10:04:42 GMT

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......

Re: Serial No Table

Former Member — Tue, 24 Mar 2009 10:06:58 GMT

hi for getting the serial nos

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.

Re: Serial No Table

Former Member — Tue, 24 Mar 2009 10:53:44 GMT

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".

Re: Serial No Table

Former Member — Tue, 24 Mar 2009 11:07:24 GMT

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 ?