topic Re: Invoice Text in Application Development and Automation Discussions

Invoice Text

Former Member — Fri, 17 May 2013 12:40:03 GMT

In FB03

if you go to menu : Extras--> Text --> Invoice Description, you can enter text that will appear on the invoice template. Is this field in the database or is it a free form text?

Please advise where can i find more info about this text field in the manual. Is it true that is a free form and therefore it cannot be uploaded via an interface?

Re: Invoice Text

Former Member — Fri, 17 May 2013 13:20:57 GMT

When you use the menu : Extras -> Text -> Invoice Description it takes you into an editor screen.

If you then use menu : Goto -> Header, a screen will show with Text name, Language, Text ID, Text Object.

These values can be used in function modules READ_TEXT, EDIT_TEXT and a number of other functions in function group STXD to manipulate the text content. The actual text is held in table STXH and STXL, so the functions allow a more friendly interface to the data.

Re: Invoice Text

manukapur — Fri, 17 May 2013 15:39:32 GMT

In addition to Paul post, use FM SAVE_TEXT to save the text.

Paul has mentioned the right details for Object IDs.

Regards,

Manu

Re: Invoice Text

Former Member — Fri, 17 May 2013 17:37:02 GMT

Thanks for your reply.

We currently use an interface to upload 10,000 of invoices in SAP. It is all good. It upload the invoice with all the fields needed to create an invoice such as date, header txt, cost centre, cost element, reference number, amount etc....

We wanted the field "Invoice Description" to be part of the text file but they said it is not possible to upload that field to the database. They said that text field is a free form and not a field in the database that can be populated as part of an interface. is there any link to SAP manual I can refer to?

Re: Invoice Text

manukapur — Fri, 17 May 2013 21:39:03 GMT

Hi Eric,

So your interface must be reading this particular file in which you can add in the field for description. The interface program can be modified to read the new file and by using FM SAVE_TEXT you can save this description into the Invoice Header.

Alternatively, you can create a new file with the Invoice numbers and description. You can then create a new interface program passing the Obj ID etc into the FM SAVE_TEXT to upload the text.

I hope this helps.

Regards,

Manu

Re: Invoice Text

Former Member — Sat, 18 May 2013 00:50:03 GMT

Thanks

If the file is a text file, how would you be able to use FM SAVE_TEXT to insert for example <bold font>, <italic> <next line> syntax in the STXH and STXL table? Are there special syntax that can be used in the text file?

Re: Invoice Text

manukapur — Sat, 18 May 2013 08:44:35 GMT

Hi Eric,

As far as I know, Bold and Italics can't be done. Probably you can explore options for creating standard text using T Code.SO10. Specify your own font types in the paragraph format.

FM SAVE_TEXT

The function module writes a text module to the text file or text memory, depending on the specific text object.

The module can be used to change existing texts and to create new texts. If it is clear that it is a new text, this can be specified via the parameter INSERT. The result is better performance as a test read is not performed.

Regards,

Manu