whent run tcode F.27 pdf format sent to cust thru mail

[Former Member]

Hi abap gurus,

I am new BTE implemetation And FI Module , I found BTE .

i have gone thru Fm SAMPLE_ PROCESS_00002310 in SE37 i.e function builder.. I understood the interface of FM.

when f.27  tcode is run it has created on spool request . in sp01 tode i can see that pdf data by spoor request number.

here requirement is need to send the PDF format through email maintained in customer master when i run f.27 mails should be send automatically.

can you tell explain how design code please .

[raymond_giuseppi]

First use search tool to find related documents as Email Sending Functionality for Different Business Process in Sap.

Regards,

Raymond

[Former Member]

HI Raymond,

i have writtend code below,its working fine. but spool is not created. please give some idea.

DATA : V_ADR6 TYPE ADR6.

SELECT SINGLE * FROM  ADR6  INTO V_ADR6 ."UP TO 1 ROWS.

  C_FINAA-INTAD = LS_ADR6-SMTP_ADDR.

  C_FINAA-NACHA  = 'I'.

[raymond_giuseppi]

No spool should be generated, only OTF data to be converted/appended to mail

Regards,

Raymond

[Former Member]

thank you for reply reymond.

so i need change any thing to convert  OTP data to appended mail.

[raymond_giuseppi]

If you don't want to add anything lire to the mail, just test with SOST for already sended mail.

(If you leave INTAD initial, FI will read clerk address)

Regards,

Raymond

[Former Member]

hi Raymond, 

This error is coming..in SOST tcode

Database error for <GET DATA FROM KPRO> <>File could not be exported

[raymond_giuseppi]

It's another subject/area of expertise : check with BC admin for KBA 1849203 - Error message Database error for <GET DATA FROM KPRO> (SO013) and/or File could not be exp....

Regards,

Raymond

[Former Member]

Raymond

            asking user name and password when i click on link ,, can you send  documents

[raymond_giuseppi]

This is SAP property, ask basis or customer to provide you a s-user or to use their own or, if allowed, use SNOTE to download the KBA/note to display it from SAP.

Regards,

Raymond

[Former Member]

hi Raymond,

The below code working fine in debugging but mail has not triggering ,can you pl suggest me

DATA : L_ADR6 TYPE ADR6.

      SELECT SINGLE * FROM  ADR6  INTO L_ADR6

              where ADDRNUMBER = i_kna1-adrnr .

       C_FINAA-NACHA  = 'I'.

       C_FINAA-INTAD = L_ADR6-SMTP_ADDR.

this fm raise error (internal error) sy-subrc = 20.

fm:SO_OBJECT_SEND

[raymond_giuseppi]

Are you able to send a mail to external address thru SBWP, as long as you are not successful, don't even dare to correct your program, it's an administrator problem not a developer’s one...

NB: C_FINAA-INTAD is sender of mail address (if initial take address of the clerk in your organization) and not receiver address, I suppose your actual mail server or SAP thru SCOT routes definition may reject the mail cause the sender address is not in your domain (is 20 associated to ORIGINATOR_NOT_EXIST or X_ERROR in your code?)

Regards,

Raymond

[Former Member]

yes Reymont

         this is internal error X_ERROR ...how to resolve it.

[raymond_giuseppi]

Were you able to send a mail in SBWP, what did your basis (SAP and Mail) answer you ?

[kabil_g]

Hi Balaji,

After Creating Business Transaction Event you need to create USER EXIT to acheive your requirement.

Assign your newly created function module to your BTE.

These will directly send a PDF Mail.

Check These link

1. https://www.scribd.com/doc/237274940/Email-Configuration-for-f-27-Customer-Accounts-Statement-Purpos...

2. Send Customer Statement By EmailSAP Training

Regards,

Kabil

[Former Member]

Hi Expert,

Email sent to customer – F.27 is maintained in notes then statement trigger to that email id as attached attached screen  shot.

Notification sent to Acct Clerk email maintain in the below screen shot of customer master in Company code data (KNB1) table. Any time if someone run the F.27 Notification should go to the below maintain id in master record,

Notification should be: like 100 customer received the statement

And 10 customer has not received the statement because email id or F.27 has not maintained in the adr6-stms-addr table( Customer master)

Customer no. should also appeared which do not have email id & F.27

[raymond_giuseppi]

Read 1360070 - E-mail function for correspondence. For other problems -> contact your BC admin or post in a netweaver admin space.

Regards,

Raymond

[Former Member]

Hi Raymond,

i have written code one mail to customer another one is notification to acct.cleark. so need to send 2 mails one for customer another for acc.clerk but here in sost tcode i can  see only acc.cleark mail , customer mail status is not coming . pl suggest me if m wrong.

_FINAA-NACHA  = 'I'.

    TYPES: BEGIN OF TP_ADRT,

           ADDRNUMBER TYPE ADRT-ADDRNUMBER,

           REMARK     TYPE ADRT-REMARK,

           END OF TP_ADRT.

    DATA: LWA_ADRT TYPE TP_ADRT.

    DATA : L_ADR6 TYPE ADR6,

           L_T002 TYPE T002,

*   DATA:L_TEXT TYPE RSSCE-TDNAME,

           L_FLAG TYPE CHAR1,

           L_TEXT1 TYPE CHAR100.

   SELECT SINGLE * FROM  ADR6  INTO L_ADR6

     WHERE ADDRNUMBER = I_KNA1-ADRNR .

     SELECT SINGLE

                SPRAS FROM T002 INTO L_T002

         WHERE  SPRAS = I_KNA1-SPRAS.

              IF SY-SUBRC = 0.

       IF L_ADR6-SMTP_ADDR IS NOT INITIAL.

      L_FLAG = 'X'.

    SELECT SINGLE  ADDRNUMBER

                    REMARK    FROM ADRT INTO LWA_ADRT

              WHERE ADDRNUMBER = L_ADR6-ADDRNUMBER

              AND   REMARK     = 'F.27'.

     IF LWA_ADRT-REMARK = 'F.27'.

       C_FINAA-INTAD = L_ADR6-SMTP_ADDR.

*      CONCATENATE I_KNA1-KUNNR 'CUSTOMER HAS RECIEVED STATEMENT' INTO L_TEXT SEPARATED BY SPACE.

       CASE L_T002-SPRAS.

           WHEN 'E'.

       C_FINAA-NAMEP   = 'ZTEXT_EN'.

         WHEN 'D'.

       C_FINAA-NAMEP   = 'ZTEXT_DE'.

       ENDCASE.

     ELSE.

       C_FINAA-INTAD = I_KNB1-INTAD.

       CONCATENATE I_KNA1-KUNNR 'HAS NOT RECEIVED THE STATEMENT BECAUSE EMAIL ID OR F.27 HAS NOT MAINTAINED'

                 INTO L_TEXT1 SEPARATED BY SPACE.

       C_FINAA-NAMEP   = L_TEXT1.

     ENDIF.

*  ENDIF.

     IF L_FLAG = 'X'.

       C_FINAA-INTAD = I_KNB1-INTAD.

       CONCATENATE I_KNA1-KUNNR 'CUSTOMER HAS RECIVED STATEMENT' INTO L_TEXT1 SEPARATED BY SPACE.

       C_FINAA-NAMEP   = L_TEXT1.

     ENDIF.

   ENDIF.

ENDIF.

ENDFUNCTION.