How to get the GL Account for Wage Type ?

[Former Member]

Hi Guys,

              I am developing a program to post an invoice in FI (FB60).

I need to find the GL Account from wage type.

Also need to find the Vendor No. from Employee No. !

How this can be done..? Any table or Function module I can refer to..? or some code snippet..?!

Thanks

Sam

[Former Member · Accepted solution]

Hi sam,

For getting G/L account numbers please check RPDKON00 report.

For vendor number you can fetch directly from the table LFA1 or use function module

HRCA_GET_VENDOR

Pls refer

http://sap.ittoolbox.com/groups/technical-functional/sap-hr/assignment-of-gl-account-to-wage-type-38...

Regards,

Ramya R

[Former Member · Accepted solution]

Hi sam,

If you get solution pls update

[Former Member · Accepted solution]

To Get GL Account from Wage Type

Select symbolic account aganist wage type in T52EL and get the GL account No using FM below.

SELECT SINGLE * FROM t52ek WHERE symko = t52el-symko.
IF sy-subrc EQ 0.
*             KOART
coll_tab_copy-koart = t52ek-koart.
*             read process
SELECT SINGLE * FROM t52ep WHERE koart = t52ek-koart.
IF sy-subrc EQ 0.
coll_tab_copy-process+0(2) = 'HR'.
coll_tab_copy-process+2(1) = t52ep-kttyp.

CALL FUNCTION 'HRPP_FI_ACCT_DET_HR'

        EXPORTING

companycode       = companycode   “ CC01

          process                 = process             “ HRC

symb_acct         = symb_acct

eg_acct_det       = eg_acct_det

          add_modif         = add_modif

        IMPORTING

gl_account_debit  = account_table-account_debit

gl_account_credit = account_table-account_credit

        TABLES

return_tab        = return_tab.