As per the general standards and coding practice, you should use abap_bool for handling Boolean value or truth values. In this case, if any object is declared as abap_bool type, then it can hold values only from the set (abap_truth, abap_false and abap_undefined). But in older systems, you might not be able to use abap_bool as it is not available. For ex. In Web Dynpro abap_bool is not available.You need to use WDY_BOOLEAN as an alternative in this case. WDY_BOOLEAN only allows true Boolean values meaning it allows only true and false as permissible values but not undefined. Read More

DELETE command will have a result. You should make sure that once you delete the row, there should not be any reference or use of row subsequently in the loop. The best is to use CONTINUE as soon as you perform deletion. I will suggest avoiding “DELETE lt_itab INDEX sy-tabix” because it will change the sy-tabix i.e. table index. In case if you just want to delete the current row in the loop then you can simply use.“DELETE lt_itab”One more thing if you are using statement “DELETE lt_itab FROM ls_wa” then whether knowingly or unknowingly, you are deleting the same lines ... Read More

There are few third party libraries which can be used to perform this task however they involve some cost however best way here is to use an SAP Connector. SAP Connectors are available for almost all prevalent programming languages like JAVA, C#, Python. You can program against these connectors and read data from IDoc. You can do a lot many things with these connectors from reading data to convert them to flat files for further usage.I have used JAVA connector for a similar scenario. You can use SAP Java IDoc class library and SAP JCO libraries for parsing IDoc files. The SAP ... Read More

ABAP stands for Advanced Business Application Programming. It is one of the primary programming languages used for developing programs and applications for SAP R/3 systems and its related modules. It is a high-level language with respect to SAP as it is understood and known only to SAP environment.The latest version of ABAP which is ABAP Objects follows Object Oriented paradigm. Also, it is fully backward compatible with applications written in previous versions of ABAP whether it is ABAP/4 or other which were highly impressed by COBOL.Being an Object Oriented Programming language it fully supports features like inheritance, polymorphism, encapsulation, and ... Read More

In SM37 you can only see the scheduled background jobs as it is not used for foreground jobs. Below shows an initial screen of SM37 Transaction code:

First of all, the example you gave has different description for a fund. So, you should know which one to be kept. If you want to keep any description, you can use the below query using aggregation functionsSELECT    X1."FundName"    ,min( X0."Dscription")    , X0."FundId" FROM INV1 X0 INNER JOIN OINV X1 ON X0."FundId" = X1."FundId" INNER JOIN NNM1 X2 ON X1."SourceId" = X2."SourceId" WHERE X1."FundTotal" > 1000 AND X0."FundStart" between [%1] and [%2] GROUP BY X1."FundName", X0."FundId"

As far as I know, there is no direct way of inserting an Array using SQL query. You will first have to combine the columns (EMPL_Id + Skill Id) using the code and then do a bulk insert to the database.

You need to go to SE93 and input your Transaction code. It will display program name behind your transaction code. You can edit the programs using SE80 and SE38.  Below shows Transaction code: SE93 Following shows Transaction Code SE80 to edit an ABAP program by opening ABAP Development workbench: Following shows Transaction Code SE38 to edit an ABAP program by opening ABAP Editor Initial screen and to enter the name of Program −

It is possible that the older version of SAP B1 may not show you all the fields of all the forms. If you have the latest version, you should be able to see the data sources that are mapped to given field. You need to open the forms in SAP Business One Studio. There are a couple of methods to view fields. 1. In SAP Business One, go to TOOLS => select SAP B1 studio suite=>edit active form for Microsoft  visual studio. This will open up the form in edit mode for Microsoft visual studio.2. You can directly use the Microsoft ... Read More

Create a REST service hosted on a server and place java method inside it. Now you can call this REST service from a SAPUI5 application using AJAX by passing required parameters.