topic Re: report in Application Development and Automation Discussions

report

Former Member — Sat, 27 Oct 2007 10:36:56 GMT

sir

sir we want to display the field name in zreport credit,debit, balance but all the field have same tecinal field name . strucrure name fdbl_balance_line

i find table name t001 and field name wears this field same for all debit , credit and balance i m display all three field in our zreport

sir plz solve my problem

ritu

Re: report

Former Member — Sat, 27 Oct 2007 10:54:39 GMT

For credit and debit you need to see for posting key.

If posting key is 40,then credit and 50 it is debit.

You should have some functional knowledge r functional consultant .

based on credit or debit,the display.

check for tables bseg,bkpf,bsid,bsad tables.

Thanks

Re: report

Former Member — Sat, 27 Oct 2007 11:13:47 GMT

WAERS is the Currency Field

When you fecth data from the FI related tables based on the DEBIT/CEDIT indicator (SHKZG) field the value of debit and credit is distinguished

if it is H it is Credit and S means Debit

So accordingly we consider that Amount field DMBTR or WRBTR as Plus or Minus

so have to fetch the field SHKZG along with WRBTR/DMBTR from the tables and to seggregate the credit and debit amounts

Take all this fields with data element WRBTR and with Domian WERT7 then use in your program

Regards

Anji