topic MMBE transaction fields for BATCH and ITS Quantity in Application Development and Automation Discussions

MMBE transaction fields for BATCH and ITS Quantity

Former Member — Tue, 16 Dec 2008 10:14:31 GMT

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

Re: MMBE transaction fields for BATCH and ITS Quantity

Former Member — Tue, 16 Dec 2008 10:16:54 GMT

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.

Re: MMBE transaction fields for BATCH and ITS Quantity

GauthamV — Tue, 16 Dec 2008 10:17:46 GMT

hi,

check these tables.

MARD,

MARM,

MCHB,

MCHA,

MCH1,

MKOL,

MSCA,

MSKA,

MSKU,

MSLB,

MSPR.

Re: MMBE transaction fields for BATCH and ITS Quantity

jaheer_hussain — Tue, 16 Dec 2008 10:18:54 GMT

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