Shared Top Border

Enterprise Resource
Planning Portal

 

Advertise | Founder BLOG

ERPGenie.COM ABAP Tips and Tricks Database

THE ultimate
ERP website

 

Forums | Vote for us |

Google    Other Search Options

Login

Login to view more content!!!





Lost Password?
No account yet? Register

Registered Access

Poll

What area of ABAP are you interested in?
 
Home arrow Sample Code arrow ABAP Reports arrow ABAP Program to Extract the Units of Measure
ABAP Program to Extract the Units of Measure PDF Print E-mail
User Rating: / 0
PoorBest 
Written by Anon.   
Monday, 05 May 2008

* Extract the Unit of Conversion from Material Master
REPORT ZUNT MESSAGE-ID Z1
        LINE-SIZE 195 NO STANDARD PAGE HEADING LINE-COUNT 060(001).

TABLES: MARM,         " Units of Measure
        MARC,         " Material Master: C Segment
        MARA,         " Material Master: General Data
        EINE,         " Purchasing Info Record - Purchasing Organization
        EINA.         " Purchasing Info Record - General Data

SELECT-OPTIONS X_WERKS FOR MARC-WERKS.
SELECT-OPTIONS X_MTART FOR MARA-MTART.
SELECT-OPTIONS X_MEINS FOR MARA-MEINS.
SELECT-OPTIONS X_MATNR FOR MARM-MATNR.
SELECT-OPTIONS X_ESOKZ FOR EINE-ESOKZ.

DATA: BEGIN OF INT_MARC OCCURS 0,
      WERKS LIKE MARC-WERKS,
      MTART LIKE MARA-MTART,
      MATNR LIKE MARC-MATNR,
      MEINS LIKE MARA-MEINS,
      UMREN LIKE MARM-UMREN,
      UMREZ LIKE MARM-UMREZ,
      MEINH LIKE MARM-MEINH,
      ESOKZ LIKE EINE-ESOKZ,
      END OF INT_MARC.

SELECT * FROM MARC.
  CHECK X_WERKS.

  CLEAR MARM.
  SELECT SINGLE * FROM MARM WHERE MATNR = MARC-MATNR.
  CHECK SY-SUBRC = 0.

  CLEAR MARA.
  SELECT SINGLE * FROM MARA WHERE MATNR = MARC-MATNR.
  CHECK X_MTART.
  CHECK X_MEINS.
  CHECK MARA-LVORM = SPACE.

  CLEAR EINA.
  SELECT SINGLE * FROM EINA WHERE MATNR = MARC-MATNR
                              AND LOEKZ = SPACE.

  CLEAR EINE.
  SELECT SINGLE * FROM EINE WHERE INFNR = EINA-INFNR
                              AND LOEKZ = SPACE.
  CHECK X_ESOKZ.

  INT_MARC-WERKS = MARC-WERKS.
  INT_MARC-MTART = MARA-MTART.
  INT_MARC-MATNR = MARC-MATNR.
  INT_MARC-MEINS = MARA-MEINS.
  INT_MARC-UMREN = MARM-UMREN.
  INT_MARC-UMREZ = MARM-UMREZ.
  INT_MARC-MEINH = MARM-MEINH.
  INT_MARC-ESOKZ = EINE-ESOKZ.
  APPEND INT_MARC.
  CLEAR  INT_MARC.

ENDSELECT.

SORT INT_MARC BY WERKS ESOKZ MTART MATNR.
MESSAGE I086 WITH 'loop at int_marc'.
LOOP AT INT_MARC.
  FORMAT COLOR COL_GROUP.
  WRITE: / INT_MARC-WERKS UNDER 'Plt',
           INT_MARC-MTART UNDER 'M.Type',
           INT_MARC-MATNR UNDER 'Material',
           INT_MARC-MEINS UNDER 'Unit',
           INT_MARC-UMREN UNDER 'Denom',
           INT_MARC-UMREZ UNDER 'Numer',
           INT_MARC-MEINH UNDER 'Alt',
           INT_MARC-ESOKZ UNDER 'Cat'.
ENDLOOP.

TOP-OF-PAGE.
 FORMAT COLOR COL_TOTAL.
 WRITE: / SY-DATUM, SY-UZEIT, SY-REPID, SY-UNAME,
         'Material Unit Conversion',
         SY-PAGNO.
  SKIP.
  WRITE: /1 'Plt',
          5 'M.Type',
         12 'Material',
         32 'Unit',
         37 'Denom',
         47 'Numer',
         57 'Alt',
         61 'Cat'.
  SKIP.


 
< Prev   Next >

Google Seach

Statistics

Contribution Activity
Utilities: 38
Tips and Tricks: 315
Sample Code: 160
Total Contributions: 527

Member Activity
Members: 5903 since 2/1/2007!
New: 2 since yesterday!
Visitors: 875630
We have 3 guests online

Newest Members

Welcome our newest members:

Google Ads

Shared Bottom Border

Contact Us | Polls | Add URL | Contribute | Privacy | Terms | Feedback

Discussion Forum | BLOG | Consultants: Post your resume | Companies: Advertise on ERPGenie.COM | Post Job
Financials Consultant | Consultant Review | Gallia Consulting | Supply Chain Project | SAP Financials Forum
GenieHoldings.COM, Inc. | Genie Press | WorkflowGenie | ESAGenie | ERPTopSites | ABAP Tips and Tricks | SAP Solutions Database

EDIGenie | Searching Survivor