topic Re: Function module that returns material GL account number in Application Development and Automation Discussions

Function module that returns material GL account number

Former Member — Wed, 04 Nov 2009 19:29:38 GMT

Hi All,

As a valuation class is assign to a material, I want a function module that allows me through material number, plant and a transaction from t_code OBYC (e.g. GBB u201COffsetting entry for inventory postingu201D), returns me GL account number of that material.

Can anyone help me?

Best regards,

Re: Function module that returns material GL account number

Former Member — Thu, 05 Nov 2009 05:38:13 GMT

Hello

Try this snippet:


SELECT SINGLE * FROM MBEW WHERE MATNR EQ P_MATNR. " <= material
SELECT SINGLE * FROM T001K WHERE BWKEY EQ BWKEY.  " <= plant
IF SY-SUBRC = 0.
  SELECT SINGLE * FROM T001 WHERE BUKRS EQ T001K-BUKRS.
  IF SY-SUBRC = 0.
    SELECT SINGLE * FROM T030 WHERE KTOPL EQ T001-KTOPL
                                AND KTOSL EQ 'GBB'  " <= transaction
                                AND BWMOD EQ T001K-BWMOD
                                AND BKLAS EQ MBEW-BKLAS.
    IF SY-SUBRC = 0.
      WRITE: 'DEBIT ACCOUNT', T030-KONTS,
             'CREDIT ACCOUNT', T030-KONTH.
    ENDIF.
  ENDIF.  
ENDIF.

Re: Function module that returns material GL account number

Former Member — Thu, 05 Nov 2009 07:45:15 GMT

FM KPPB_MAT_ACCOUNT_ASSIGNMENT

Not exactly what you need. Just for information.