Get MD04 Data From a table

[anuradha_wijesinghe]

Hello Everyone ,

Im implementing a ABAP report for planning which is need to get WIP qty in the production orders for a relevant Sales Order/Line Item/Schedule Line . As Functional people saying they are getting this from MD04. That is like bellow.

So i need gr the sum of highlighted rows. So is there any table to get this wip stock.

I can get this same data from FM,  "BAPI_MATERIAL_STOCK_REQ_LIST" . but this is the same as MB04 and hard to fetch data.

Pls tel some table for get this data. 

[Former Member]

Hello,

From FM BAPI_MATERIAL_STOCK_REQ_LIST use the table MRP_IND_LINES

MRP_ELEMENT_IND = 'FE'  ---> Production Order.

Loop  at mrp_ind_lines where MRP_ELEMENT_IND = 'FE'

write the code for summation

endloop.

[anuradha_wijesinghe]

Dear madhu,

     Thanks for the quick response.... So how can i get that production order for a relevant Sales Order/ Line item /schedule line   >

[eduardo_hinojosa]

Hi

Research in views and tables in function module MD_STOCK_REQUIREMENTS_LIST_API. For instance, go to include LM61XTOP and look for in the

*----------------------------------------------------------------------*
*        SQL-Tabellen                                                  *
*----------------------------------------------------------------------*
tables:  mard,                         "Lagerort-Segment
          marc,                         "Werk-Segment
          mssa,                         "Kundeneinzelbestand
          mska,                         "Kundenauftragsbestand
          mssq,                         "Projekteinzelbestand
          mspr,                         "Projektbestand
          mssl,                         "Lohnbearbeiterbestand
*        mchb,                         "Chargenbestaende
*        msku,                         "Kundenkonsi
          mdbs,                         "View Bestelleinteilung
          mdla,                         "View LieferAVIS
          mdrela,                       "View für Lieferungen zur Retoure
          ekkn,                         "Kontierung Bestellposition
*        ekko,                         "Kopf der Bestellung
          equk,                         "Quotensatzkopf
          equp,                         "Quotensatzposition
          plaf,                         "Planauftrag
          afko,                         "Fertigungsauftragskopf
          mdfa,                         "Fertigungsauftrag
          vfapw,                        "Fertigungsauftrag zum P-WERK
          mdqm,                         "QM-Prüflos
          eban,                         "Bestellanforderung
          ebkn,                         "Kontierung Bestellanforderung
          mdrs,                         "View MRES/SBED
          mdri,                         "Bedarfssummensatz
          mdur,                         "View REUL/RESB
          mdsm,                         "Simulationsbedarf
          mapr,                         "Materialindex zu Prognosewerte
          dbpr,                       "Materialindex zu Prognosewerte DB
          prop,                         "Parameter Prognose
*        prow,                         "Werte     Prognose
          mdpb,                         "View Planprimaerbedarf Werk
          mdpbdb,                       "View Planprimaerbedarf DispoBer
          vbbe,                         "Kundenauftraege Einzelsaetze
          vbbs,                         "Kundenauftraege Summensaetze
          pbvpv,                        "Index VPMAT -> MATNR
          mdze,                         "View Zuordnungsbedarf VBBE
          mdua,                         "Abrufbedarf UL-Best.anforderung
          mdub,                         "Abrufbedarf UL-Bestellung
          mdup,                         "Abrufbedarf UL-SimAuftrag
          sums,                         "Seriennummerumschlüsselung
          snum,                         "Seriennummern
          pums,                         "Projektumschluesselung
          mdsa,                         "Serienauftrag TL 99A
          mdfd,                         "Fixierungsdaten der Bedarfsplan.
          mdfddb.                       "Fixierungsdaten Dispobereich

The trouble: comments are written in german, so, double click and see the table.

Regards

Eduardo