Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

MMBE transaction fields for BATCH and ITS Quantity

Former Member
0 Likes
821

Hi Gurus,

I am developing a report to get the details of material like Material code, Material type, Material Group, Material Group1, Special stock indicator, Special stock Numb, Batch and its quantity.

Can any one suggest the table from where i cud fetch Special stock numb and its indicator , batch and relevant quantity of the material.

My client is referring to standard transaction MMBE and wants me to get the details from there.

I would like to take this opportunity to thank you in advance for your valuable suggestions.

Thanking You,

ZIa

Hi Gurus,

I am developing a report to get the details of material like Material code, Material type, Material Group, Material Group1, Special stock indicator, Special stock Numb, Batch and its quantity.

Can any one suggest the table from where i cud fetch Special stock numb and its indicator , batch and relevant quantity of the material.

My client is referring to standard transaction MMBE and wants me to get the details from there.

I would like to take this opportunity to thank you in advance for your valuable suggestions.

Thanking You,

ZIa

3 REPLIES 3
Read only

Former Member
0 Likes
633

Hi

Use the same transaction to get the values check whats the program name of the transaction and then use submit statment and also use get/set parameter id and also pick the particular table where its getting fired pick the values into an internal table and push the value to your internal table.

Read only

GauthamV
Active Contributor
0 Likes
633

hi,

check these tables.

MARD,

MARM,

MCHB,

MCHA,

MCH1,

MKOL,

MSCA,

MSKA,

MSKU,

MSLB,

MSPR.

Read only

jaheer_hussain
Active Contributor
0 Likes
633

Hi,

The following tables used for MMBE...Just identify your table & fields....

TABLES: kna1, "Kundendaten auf MandEbene

lfa1, "Lieferantendaten auf MandEb.

lfm1, "Lief.daten auf EkOrgEb.

tcurm, "Customizing (Bew.kreisebene)

makt, "Material-Kurztexte

mara, "Materialdaten auf MandEbene

marav, "Materialdaten mit Kurztext

marc, "Materialdaten auf Werksebene

marcv, "Materialdaten auf Werksebene

mard, "Materialdaten auf Lagerort

marm, "Mengeneinheiten zum Material

mchb, "Chargenbestaende

mcha, "Chargen

mch1, "Chargen

mkol, "Lieferanten-Konsignation

"Mehrwegtransportverpackungen

msca, "K.Auftragsbest. beim Lief.

mska, "Kundenauftragsbestand

msku, "K.Lergut und K.Konsignation

mslb, "Lieferantenbeistellung

mspr, "Projektbestände

*<<< hier später weitere Bestandstabellen ergänzen

ekbe, "enth. WE-Sperrbestand

ekpo, "Bestellposition

resb, "Reservierungsposition

vbbe, "Bestände des Vertriebs

t001, "Buchungskreistabelle

t001l, "Lagertabelle

t001w, "Werke

t006a, "Zuo. externe - interne ME

t134t, "Texte zur Materialart

t148, "Sonderbestände

t148k, "Sonderbestände Sicht MM_BD

t136, "Bestandsfelder je Anz.Version

t136a, "Bestandsfelder je Anz.Versio

t136e, "max. Felder Einzelliste

t136f, "max. Felder Grund/Aufrißliste

t136v, "Anz.Version zur Einzelliste

t157b, "Texte Bestandsfelder

t320, "Lagernummer zu Werk/LgOrt

t340d, "JH/13.05.98/4.0C

rmmmb, "Hilfsfelder

rmmme1, "Hilfsfelder für alt. MEs

sscrfields. "Hilfsfeld Sel.bild SW/8.10.98