Content The Billing Due List report shows the order-related billing due list (SAP transaction VF04) for the selected customers.
|
||||||||
Data Collection In the SAP system, the billing due list is displayed in transaction VF04 as "ALV Grid":
One way to read the values of the grid is to use the "GridToTable" function of the SAP GUI Scripting interface in CIS mobile. This is analogous to step 4.01 in the description Add-on
Fertigungsauftrag. We start this report from VB.NET and get back the data of the ALV Grid as a text table in which the individual columns are separated by "|":
Vb.net
The text for the billing type, for example "Invoice (F2)", is not included as a column in the ALV Grid. Therefore, we still read the text for the display from table TVFKT via the RFC database interface. Since there are many individual accesses for this, it is important to buffer the TVFKT table in the S10 repository using the parameter dbcache="yes" (see next section). ' read billing type text via SAP Select Vtext = "" Saptvfkt.fkart = Fkart If Saptvfkt.ic.RfcDatabaseRead() Then Vtext = Saptvfkt.Vtext End If |
||||||||
Performance In the S10 repository, Runtime->Trace provides an often useful often useful trace function. It shows the selection parameters and the time spent on report calls:
Also all database accesses of the RFC Select interface. We measured them in the CIS mobile test system in various constellations:
If you want to read data that cannot be kept in the cache and many individual accesses are to be expected, you can first collect all keys and then bundle the accesses.
The Vb.net coding is a bit more sophisticated for this case, here are the parts relevant for it: In our example, only two accesses are bundled (see trace 4 above), since only "F2" and "BV" are billing types.
|
||||||||
Layout We build the output table in vb.net as html string, using css to specify fonts, dimensions, colors etc. be set. The coding is analogous to the Example Sales. |
||||||||
Additional Parameters No Additional Parameters. |