I Have to do a Z Report. My question is about Currencies in ACDOCA

[liscanol]

I Have to do a Z Report. My question is about Currencies in ACDOCA

in ACDOCA table the following fields corresponding CURRENCIES.

RTCUR Balance Transaction Currency

RWCUR Transaction Currency

RHCUR Company Code Currency

RKCUR Global Currency

ROCUR Freely Defined Currency 1

RVCUR Freely Defined Currency 2

Question: which corresponding a which field of ACDOCA?

TSL- Amount in Balance Transaction Currency

HSL- Amount in Company Code Currency

KSL- Amount in Global Currency

OSL- Amount in Freely Defined Currency 1

VSL- Amount in Freely Defined Currency 2

Question 2:

I custom currencies in SPRO - Transaction FINSC_LEDGER, what is the logic to associate for corresponding report standar in Balance GL FAGLB03?

I know that in FINSC_LEDGER i can custom, but which dependences or correspond in ACDOCA table that is a best way for Z Report to use in Balance for get the same FAGLB03 - Standard SAP.

Thanks

[himansusroy · Accepted solution]

Hi Luis,

For first query go to table display (SE11) and check tab "Currency / Quantity Fields", here the amount fields like TSL, HSL are mapped to corresponding currency key field like RTCUR, RHCUR respectively - refer to fourth and fifth column "Reference Table" and "Reference field".

Not very clear on your second query but would suggest to debug program FAGL_ACCOUNT_BALANCE using one entity / account / fiscal year / ledger combination.

Kind regards,

Himansu Roy

[Paulo_Vitoriano]

Hi Luis,

Just a basic suggestion. Ask a functional consultant to make a posting that you can easily identify at the ACDOCA table, that way you will be able to confirm the technical field names for all amounts in all currencies.

Regards,

Paulo