If you want to check the relation between different tables, you need to have a minimum read-only access to SAP system.Below is the link to refer information about dictionary structure −https://help.sap.com/saphelp_46c/helpdata/en/ea/e9a3bb4c7211d189520000e829fbbd/frameset.htm

Try replacing below statement with other mentioned −IRfcStructure articol = repo.GetStructureMetadata("Z_ITEMS") as IRfcStructure;You need to replace this by −

To connect a .NET application with SAP system, there are different approaches that you can follow:Use of SAP PI middleware that offers different protocols and communication framework for integration of two systems. SAP PI/XI enables you to set up cross system communication and integration and allows you to connect SAP and non-SAP systems based on different programming language like Java and SAP ABAP. It provides an open source environment that is necessary in complex system landscape for the integration of systems and for communication.SAP Process Integration is a middleware to allow seamless integration between SAP and non-SAP application in a ... Read More

You should do this using a Modify statement as in below − LOOP AT itab. SELECT SINGLE matnr INTO itab-matnr FROM zlldet WHERE palet = itab-palet. MODIFY itab. ENDLOOP. Also note that when you have an internal table itab with a header line, it means that you have a table itab and structure itab and usage of this depends on the situation. Few of the commands like MODIFY and LOOP AT uses both at the same time. DATA itab TYPE TABLE OF [something]. DATA wa ... Read More

You need to copy sapjco3.dll in a folder in your Java library path as he t library is not sapjco3.jar and it is a sapjco3.dll file.You can call in your application usingfollowing:System.getProperty("java.library.path")Following approaches can be used:First is by copying sapjco3.dll into one of the folder which are already in your library path like: C:\WINNT\system32Second would be to use the same path in Java library path using any of the following options:By accessing System.setProperty ("java.library.path", "C:\path\to\folder\with\dll\") before accessing the SAPJCoYou can set Java command line like this -Djava.library.path=C:\path\to\folder\with\dll\Read More

You can use class ZCL_MDP_JSON Library that can encode/parse any JSON. JSON is supported natively in ABAP by the following features:With the use of JSON-XML- it is known as special XML format that can be used for JSON data to be described using an XML representation. By defining a mapping between ABAP types and JSON. This is used in serializations and deserializations using the identity transformation ID.As you can specify JSON data in different forms as an XML source in the statement CALL TRANSFORMATION and JSON can be specified as a target.Check out the following sample code:Example:DATA text TYPE string VALUE ... Read More

You can do this by creating your own function module that can perform selection as per the requirement.You could also use to create a database view and that can be used to call RFC_READ_TABLE. Also, check for prebuilt SAP connectors provided by companies for SQL joins:

This can be done using – Legacy Systems Migration Workbench LSMW transaction. This workbench works like a sort of macro recorder and allows you to record the steps in a transaction and you can replay that record multiple times as per the requirement. This also allows you to replace the values you used in your recorded transaction with new values.A more complex option would be to write ABAP code and this is more flexible to add different privileges to different roles.

If you using Universe as the source, In UDT this can be defined at Universe level. You can limit the size of result set in Universe Parameters -> ControlsIn Query panel, you have an option to set the limit on rows retrieved for each individual query. This setting is called the Max rows retrieved.This option is linked to each individual query, not with Webi document as a whole. When your document has multiple queries, you need to set the Max rows retrieved for each of them.

You can use the COLLECT keyword or some aggregate functions to achieve the result. You should define some datatype to match the scenario.TYPES: BEGIN OFt_my_type,    key_aTYPE foo,    key_bTYPE foo,    nokey_cTYPE foo,    nokey_dTYPE foo, END OFt_my_type, tt_my_type_list TYPE STANDARD TABLE OF t_my_type WITH DEFAULT KEY, tt_my_type_hash TYPE HASHED TABLE OF t_my_type WITH KEY key_a key_b. DATA: lt_resultTYPE tt_my_type_list,    lt_sums TYPE tt_my_type_hash. FIELD-SYMBOLS: TYPE t_my_type. LOOP AT lt_result ASSIGNING .    COLLECT INTO lt_sums. ENDLOOP.Read More