How to determine a Division from a Particuar G/L Account used in Accounting

[Former Member]

Dear Team,

My Requirement is I want to determine A Division for a Particular G/L Account that has been used in Accounting in Billing Doucument. Please can you let me know a possible Solution.

Thanks,

Prashant

[Former Member · Accepted solution]

hi

try to create substitution by using t.codeGGB1

Thanks & Regards

Phaneendra

[Former Member · Accepted solution]

Hi Reddy,

Thanks for your reply. I think you are not clear with my Requirement. I need a report if I give Inputs is G/L Account and Posting Date I should get a Value for that G/L the Particular Billing Document, Billing Document Number and Division. Can you give what i need to do in T Code GBB1?. I am not clear with your ans.

Thanks,

Prashant.

[Former Member · Accepted solution]

Hi Prashant,

Is FBL3N is your requirement? You can populate your required values by selecting it in the Layout in this Transaction.

Try & revert back if ur not solved.

Regards

Andrew

[Former Member · Accepted solution]

Hi Andrew,

Thanks for your reply. I have already checked FBL3N Report. But it is a standard report and it does not contain VBRK Table. I need to make a customise report same like FBL3N where if i give inputs as G/L Account it should call the VBRK Details in the Output. Can you give me the link where G/L Table has connection with VBRK Table.

Regards,

Prashant.

[Former Member · Accepted solution]

thanx issue has been resolved

[Former Member]

Billing line items post to VBRP. You'll need to look up there for the division using abap program or gl substitutions.

pts appreciated.