MMBE - background table

[petrovkt]

Hi,

Could you inform which table contain the material document nr & charge nr & material nr?

I tied the MSEG and MCHB and MKPF. Mseg and Mchb don't contain every information and the MKPF has Access issue in myside. Any another idea?

Best wishes.

Viktor

[VeselinaPeykova]

What do you mean by "MKPF has Access issue in my side"?

What are you trying to do - create a query, build a custom ABAP report, something else?

What information are you trying to retrieve? Combining batch stocks (MCHB) with material documents (MSEG) seems a bit strange, are you trying to build something like stock on posting date?

You mentioned that in MSEG you do not have all the information that you need, but in MSEG there is MATNR (material), CHARG (batch) and MBLNR (material document), which are the fields for which you asked community members to suggest more tables. What other fields are you looking for (which are not in MSEG)?

[petrovkt]

Hello, It is needed for a bar code check point. We would like to solve it. But we need these fields for the identification (charge, material document number, material numbers). I hevan't got acces for the MSEG table, and the IT didn't gave it. 2 or 3 table also good for me but I need a common field that I could make the join between the tables. Best wishes. Viktor

[raymond_giuseppi]

• MMBE (in your title) or MB52 transactions can display stock current quantities with some level of detail.
• MB51 or MIGO transactions can display stock movements (if you require movement nr)

What exactly are you trying to do, which which tool, what was the original requirement ?

Hint: For a full list of tables updated by stock movements, look at FM MB_UPDATE_TASKS.

[petrovkt]

Helllo,

thank you for your support. The organization structure is more than complicated if you are wirking in a company where the number of employee is >50K.

But I approciate your support.

Best wishes.

Viktor

[VeselinaPeykova]

I do not understand - are you a developer, a business user, a consultant?

If you are a business user - how exactly are you expected to create a custom report if you have no authorization even for displaying table entries? Anyways, if you are a business user and the IT does not agree to grant you authorization to create a specific report that you require for your daily tasks - then it is them who should provide you a suitable report with authorization checks that are acceptable according to the policy.

By the way, if you are a business user, you are not supposed to have authorization to view tables like MCHB, MKPF, etc. in SE16 and similar transactions. I find it strange that your IT refuses to grant you access for MKPF, but does not mind to do this for MSEG (or vice versa).

If you are a developer - you should already have sufficient authorizations, at least in a development environment, for creating reports and viewing data. If you lack authorizations - it is again the authorizations team who should grant you sufficient rights so that you can do your job.

If you are building a custom report just to view the fields that you mentioned: material number, material document and batch - can't you simply use MB51?

You already have material number and batch in the selection and in the output screen. Material document number is, of course, available in MB51 output. You can also create variants and layouts if you want to. If you know the material document - you can use MIGO. With a simple configuration change one could enable document number in MB51 as selection criterion as well (although it does not make a lot of sense to do so).

[petrovkt]

Hello, Thx! I also need the material document number. In these table I don't see it.
I need the number which is determine the moving details. It is needed for a bar code identification.

What we see also in the MIGO. Details of the booking.

Migo figures:

[paulo_zaccaro]

Hi Viktor, the table of documents of materials and stocks are different things. I understood that your request was as follows: MKPF> MSEG> Tables_Stock. It all depends on the starting point you want, that is, you can use both ways:

• Material document for stock;
• Stock for material documents (consider that this takes time, as MSEG usually contains a lot of data).

Please advise me if your need is a different thing, and please don't forget to evaluate and close the request if my answer was helpful.

Regards,

Paulo Zaccaro

[petrovkt]

Hello, It is an autorization issue with the MSEG. I don't know why but I havn't got autorization for this and the company don't give it. Thx.

[paulo_zaccaro]

Hello Viktor,

The problem here is, you have many others tables for stocks in SAP.

Look these others:

• MKOL - Special stock K/M - Special Stocks from Vendor
• MSKA - Special stock E - Sales Order Stock
• MSKU - Special stock V/W - Special Stocks with Customer
• MSLB - Special stock O - Special Stocks with Vendor
• MSPR - Special stock Q - Project Stock

You have others tables too, please tell us if necessary.

The technical name of special stock is SOBKZ.

Regards,

Paulo Zaccaro