SELECT SINGLE MBLNR FROM MKPF WHERE XXXXXXXXXXXXXXX ?

[Former Member]

Hi Experts,

I wuld like to pull the Materail Doc. Number (MBLNR) from MKPF table of the Z_MYMOVEMNT_123 Goods Movement type. So, pls. let me know the Selction criteria? i.e.

SELECT SINGLE MBLNR FROM MKPF WHERE XXXXXX ?

So, pls. let me know that, What fileds (of MKPF) I can use for XXXXXXXXX ? place to pull MBLNR value?

ThanQ.

[Former Member · Accepted solution]

use MSEG table and using material get the MBLNR field value.

[Former Member]

there are no other fields unique for fetching the data...

so only u should have material number and using this u can get MBLNR from MSEG and revalidate whether it exists in MKPF table.

Reward if useful...

[Former Member]

Hi,

ThanQ.

I think its not appropriate, just for interest sake asking that, Can I use (CPUTM filed) ''Time of Entry'' of the MKPF table?

ThanQ.

[Former Member]

Hi,

You can use any condition whcih will give the uniqe number, make sure that you are using the MJAHR field in the where condition .

Regards

Sudheer

[Former Member]

Hi,

ThaQ.

But, Do u hv any idea that, What r other (other than MBLNR) fileds r unique in MKPF (to pull MBLNR)?

ThanQ.

[Former Member]

Hi,

In where condition you can mention that on which criteria basis you are selecting the material doc.no. That criteria you can mention on where class.

Regards,

Bhaskar

[Former Member]

u can input any value for XXXXXXXXXXXXXXXX as MBLNR is itself the primary key.