ABAP-Invoice Management System

There are generally commercial invoice requirements for foreign sales, which are mainly used for customer clearance and reconciliation and settlement with the customer later. The logic of getting the number is to produce the unit price of the customer's shipment order, and then attach the freight information to form the main content of the invoice. The following is a simple record of a previous development. (using custom table Storage, this data will be used in the development of financial reconciliation later)

1. the main interface has two functions: Create and query.

2. The queried invoice list

3. Edit the invoice details page.

New Function: You can create another invoice for the selected customer. The export function can export the saved invoice as an Excel file. you can delete or add a list. click Add function. For example, the find delivery order page is displayed. You can select the query result to add it to the current invoice.

The exported Excel format is as follows (some business data is removed ):

 

This developedCodeIt is not completely pasted, basically the combination of screen and ALV grid, which is not relevant to the source code previously entered.
Here, we only record a tip for Excel operations. You can select any cell in Excel and define a domain name for it. During Ole operations, you can

You can use this name to operate cells without the absolute cell name XX: XX. The advantage of this is that the Code only needs to fill in the data, instead of being

Where to fill in. As long as the domain name is saved, the Excel template can adjust the location at will. The code for filling in the domain name is as follows: