In which reports can I get both GL and movement type.

[Former Member]

FBL3N (BS Account) line items for doc types WE & RE which form MT101 & 102, then add to it MT561.

[ajaycwa1981 · Accepted solution]

Hi

Try using tables ACCTIT and ACCTHD

Br, Ajay M

[Former Member]

Hi..

I use t-code MB51 to report line items for the movement.

But MB51’s report don’t have GL account.

I think that you can assign the BS account to MB51’s report using excel file.

[Former Member]

Dear Big Choi,

Do you have any sample excel sheet?

Regards,

[Former Member]

Any update sir/madam.

[suma_mani]

Hello ,

You can get all movement type details with GL accounts in MB51 report.

If it is not displaying ,you can follow mentioned note

1720669 - G/L Account is not displayed in table MSEG

[Former Member]

Hi..

The note 1720669 which you mentioned  above is relevant to goods movement, not goods receipt.

Most of MM document for goods movement have gl account. But MM document  for goods receipt don’t have gl account.

So gl account can be extracted from BSIS table using MSEG-GJAHR,MSEG-BUKRS,MSEG-LFBNR and MSEG-LFPOS.

[Former Member]

Hi,

Please go through the below link. It might resolve your query.

http://www.erpgreat.com/materials/movement-type-and-gl-account-determination.htm

Regards,

Gaurav