account description not shown in cash journal

[vikram_katyal]

hi

when i am looking the cash journal report in S_P6B_12000118 than i am not able to see the respective GLs from which i have done entries. how can i see the GLs , so that i can do proper reporting or there is any other way to check it

[santosh_kavitkar]

Hi Vikram,

Please check posted tread for your requirement

Regards,

Santosh

[vikram_katyal]

i checked that thread but it did not work, the other t-code i tried to access but it is not opening , since i have done the changes and followed the instructions. Is there any other way because this information i have to give to my users so that they can also do it easily.

thanks

[former_member2342]

Dear

You can develop your own query(t.coide SQVI) by joining the following requisite tables based upon the requirement. The following cash book tables especially TCJ_DOCUMENTS and TCJ_POSITIONS and TCJ_TRANSACTIONS mostly have the data you need. Just check up and after you feel satisfied with the output of the query a t.code can be developed by your abaper.

TCJ_BALANCE FI Cash Journal: Totals Records

TCJ_C_JOURNALS Cash Journals

TCJ_CHECK_STACKS Check Lists in Cash Journal

TCJ_CJ_NAMES Cash Journal Names

TCJ_CPD FBCJ: One-Time Account Data of Cash Journa

TCJ_DOCUMENTS Cash Journal Documents (Header Data)

TCJ_MAX_AMOUNT Cash Journal: Amount Limit

TCJ_POSITIONS Cash Journal Document Items

TCJ_PRINT Cash Journal Print Parameters

TCJ_TRANS_NAMES Cash Journal Business Transaction Names

TCJ_TRANSACTIONS Cash Journal Business Transactions

Regards