0FI_GL_4 Datasource Debit / Credit posting Issue

[Former Member]

hello Guys,

I am extracting 0FI_GL_4 for our report requirement.

My report requirement is I want to display the field "BSEG-DMBE2 : Amount in Second Local Currency" with /- sign based on the field "BSEG-SHKZG : Debit/Credit Indicator", which has S & H values, which turn represents H --> Credit "BSEG-DMBE2 and S --> Debit "-BSEG-DMBE2" in the BEx.

could you please let me know your solutions.

Thanks and Kind Regards,

Shekar.

[Former Member · Accepted solution]

Why are you using BSEG-DMBE2 : Amount in Second Local Currency" with +/- sign ?

you should use DMSHB - Amount in Local Currency with +/- Signs.

there is no need to use the Debit/Credit Indicator.

The field DMSHB - Amount in Local Currency with +/- Signs itself has the sign + for debit and - for credit.

Regards

Venkata Devaraj

[Former Member · Accepted solution]

Hello Venkata Devaraj,

But report requirement is such that i need to used BSEG-DMBE2 field in the report for our secondary office who want to look at that field in the report.

plz provide some solution to get the issue solved.

thanks and Kind Regards,

Shekar.

[Former Member · Accepted solution]

Hi,

If that is the requirement then you can use it, there also there is not need to use the debit/credit indicator, Since the field BSEG-DMSH2 itself has the + /- sign.

however if you use the filed DMBE2, this will not display wther the balance in debit or credit.

the filed SHKZG - Debit/Credit Indicator only indicates whether each of the record / transaction was a debit or credit posting.and it would not inticate if the balance in a particular account is debit or credit.

Assign points if useful

Regards

Venkata Devaraj

[Former Member]

Hello Venkata Devaraj,

Got you point.

my issue is solved with your answer. Awarded full points.

Thanks my friend!!!.

Shekar.

[Former Member]

Hi Shekar,

Thanks for the points

Regards