Complex Table Transmit

[Former Member]

Hi SCN,

We have a new requirement where we need to transmit only one complex table from a group of ten without data table and data object too. Any configuration on Agentry can do that? Or on every transmit wee need to synchronize all data table, complex table and data objects?

Regards,

Dagoberto

Tags edited by: Michael Appleby

[mark_pe]

Based on the comments above, it depends on what your definition of your requirements are. You can write your own mobile application from scratch if you want to build your own mobile application to communicate with your custom customer enterprise environment (popular integration is to a custom environment is either via Java, SQL, HTTPXML, File).

In SAP, we provided out of the box solution like Work Manager, Inventory Manager and others for SAP or IBM. Each product (or mobile solutions) were designed to do different things based on the back-ends and popular business needs. You could have a custom flavor of the out of the box or something unique to yours.

Let us assume you are customizing the out of the box Work Manager for SAP for Complex Tables:

If you are using SAP as your backend, the main communication between Agentry and SAP is using Java and it communicates with the built-in SAP Agentry config panel (that takes care of all the Bapi and Abap). So all the complex table is driven by Java + config panel. The example above for javaBE.ini by Mallina is based on the ini file configuration where you can state either to turn on or off the complex table download. You can see this setup under the javaBE.ini. 

The picture above can be set either ini or SAP. So Mallina's example is base on ini setup. Another way to do it is through (Source = SAP) which is  the Agentry Config Panel tied to your out of the box application where you can state to turn on or off the complex table download. You may check the Work Manager setup or documentation on how to turn on or how often to check the complex table.

If you are not using out of the box Java code (or extending the libraries) then you can write your own Java code to do the logic you require to either update or reload or do any download you wish base on your triggers. If you are at this level it may be harder because you have to do all the logic and you have to have a tie-in the back end enterprise to flag to download or not.

Let us assume your backend is SQL (Microsoft SQL or Oracle or SQLAnywhere or other SQL type).

When you create a Complex Table in the Agentry Editor you will be presented with something like this picture:

You will notice two major tabs: Reload State Query - if you return true on this query it will reload the complex table and the Data Query: The typical query when you sync from scratch or do a delta sync.

In the example above, you will see special characters "<< >>" called flunkies or SDML (SAP Data Markup language) where you can do a quick query against your backend to do some logical queries before you do your main query. Most of the SQL design is based on what you specify as your where clause or your where logic. So you can officially create your own custom table (CTReload) in your backend and setup  custom columns (TableName, Reload) and indicate if your table name = Parts then Reload = 1 or Y then reload it.  For DataTable you have the Sync Query and Data Query for control.

The link that Mallina gave above  is also a study on what occurs when you turn on or off certain features of Agentry and what the server does with it.

The Main transmit of the Agentry clients does all of them Objects (base on fetch), Data Table (base on data and sync query or java or chosen backend system connection) and Complex Table (base on reload state or data query or Java or chosen backend System Connection).  You can start adding the smartness or logic in the actual Complex Table and Data Table setup to not download or when to download it base on your conditions.

Regards,

Mark

[jason_latko]

Dagoberto,

Keep in mind that these solutions the others mentioned will only work if you are extending an existing Agentry product like Work Manager, Sevrice Manager, etc...  It is not possible in your own custom application to easily control complex table or data table checking/reloading on a table by table basis.  Agentry was designed to update them all at once, but the products have been engineered in such a way as to allow individual updates via the config panel or javabe.ini settings as described by the previous posts.

Jason Latko - Senior Product Developer at SAP

[i834235]

Change the parameter settings in /syclo/configpanel to  refresh complex  table depending on your requirement. Also you have option in /SYCLO/ADMIN to  refresh complex  table for any given user at the run time.

Thanks

Manju

[former_member197782]

HI Reyas,

Please change the JavaBE.ini configuration setting as below.

Edit the following section.

Hope this helps.

Thanks,

Swaroopa.

[former_member197782]

Hi Reyes,

Please see the link.

It will give some information you require.

Thanks,

Swaroopa.

[sravanthi_polu]

Hi,

Please check the options available in application settings and transmit configurations as shown

Regards,

Sravanthi