cancel
Showing results for 
Search instead for 
Did you mean: 

serial number

Former Member
0 Kudos

can anyone plz tell me the transparent table name for serial numbers through that i can fetch serial numbers of my realted products.i found sernr field but i didn't found mblnr in the same table.

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

> can anyone plz tell me the transparent table name for serial numbers through that i can fetch serial numbers of my realted products.i found sernr field but i didn't found mblnr in the same table.

This depends on the object.

Transaction SNRO is the transaction to configure them.

Number ranges are "allocated" by the application server in its memory in parts so the number in the table does not necessarily reflect the next number.

Use function modules if you need to do this by hand.

Markus

Former Member
0 Kudos

but i want to show serial numbers in my alv report.

Former Member
0 Kudos

how i can show all serial numbers in my sap alv report.

is there any way to show it actually it fecthes first serial no.and leaving the remaning ones.

Former Member
0 Kudos

thnks,

but i need to show all serial numbers on my alv report.

is there any way to showthrough functionality we can check.

but i want to see on my alv report

markus_doehr2
Active Contributor
0 Kudos

Can you please specify what "serial numbers" of which objects you are asking about?

Markus

Former Member
0 Kudos

suppose i have manufacured 10 products and i had given specific serial numbers for that such as 01,02 during functionality(data entry).so those specific serial numbers realted with products.i want to show in my alv report.

code is

SELECT single objk~sernr into it_so-sernr

from objk inner join ser03

on ser03obknr = objkobknr

where mblnr = it_so-mblnr.

but it fetches only first serial number of that material document...

so is it possible to fetch remaining ones.

markus_doehr2
Active Contributor
0 Kudos

If you use "select single" you get only one line...

This is more a question suitable for the ABAP forum than in basis forum.

Markus

Former Member
0 Kudos

but i had use loop for that.but we usually use single to fetch data.if i ll not use single it will give me an error.as i am working on ecc.6.0.

can u plz write that query with ur concept.which will run on ecc 6.0 release.

Former Member
0 Kudos

thnx,

for ur answers.

markus_doehr2
Active Contributor
0 Kudos

I suggest you ask that question in the ABAP forum - there may already be someone having had that business case.

Markus

Former Member
0 Kudos

This message was moderated.

former_member204746
Active Contributor
0 Kudos

ABAP forum is located at

good luck.

Answers (0)