CAA3

[Former Member]

Hi all,

I have got the requirement from the Client ( Utility Company ). He wants to print the TOTAL INVOICE AMOUNT in smartform for this they have given following

Tex Number /Field Name.............Description...............Screen Field Value......From Transaction

_______________________________________________________________________________

Invoice Amount............................Total Amount Due....Invoice Amount............CAA3

Now when i gone to CAA3 Tcode i did not found total amount.

From where will i get it............should i ask for anything else from the client.

Regards,

Mohsin

[Former Member · Accepted solution]

Hello,

If you want to view the account balance of the Customer, use T-Code FPL9.

You can also use EA60 to view the Invoice amount.

Alternatively you can also use the FM 'BAPI_ACCOUNT_GETBALANCES' to view the account balance.

What I understand from your requirement is that you need to print a customized Inv. For that you need to overwrite the standard application form for Invoice and apply your code

Hope this helps

Rgds

Rajendra

[Former Member]

Hello,

The application form you need to use is ''IS_U_BILL''.

You need to copy this as 'Z' form and you need to put your code in it.

You can also have your client's logo in it for that you need to upload it using SE78.

Do remember that the form is attached in Contract Account <CAA1/CAA2>

Hope this helps

Rgds

Rajendra

[Former Member]

Hello,

Table :ERDK

Field name: BETRW

just try out this....

Regards,

Narendar Konakanchi

[Former Member]

Hello,

Table :ERDK

Field name: total_amnt

correction to previous post

Regards,

Narendar Konakanchi

[former_member303766]

Hello,

Please try FPL9 to see the account balance.

EA22 or EA60 for invoice amount.

ERDK Table for total amount - TOT_AMNT

or

DFKKOP - put main transaction and Subtransaction for invoice (e.g. 0100-0002) for invoice amount.

Regards

Mahavir

[former_member303766]

Hi,

There is a correction for ERDK table:

field is : TOTAL_AMNT for total amount.

Regards

Mahavir

[Former Member]

Hi,

T-code CAA3 is for Displaying Contract Account. Here, you cant get any information about Invoice. EA40 is the t-code to see the invoice document. Please contact if this is not clearing your question.

Thanks

Vijay