Application Development and Automation Discussions

Task 4 - Implement Criticality feature and create an Object page

This is the last task of the August Developer Challenge on ABAP Core Data Services. The responses we have seen so far is excellent and appreciate each one of you in taking time to complete the challenge. We have seen some good conversations about the...

Task 1 - Create CDS View Entity ( August Developer Challenge )

First of all, thanks for the overwhelming response to the ABAP Developer Challenge. Kudos to everyone who took time out of their busy schedule and finished the pre-requisite – Task 0 last week.Now let us dive right into the challenge.Task 1 - In this...

Resolved! SAP Web Service error text : The database returned a value containing an error , type CX_SY_OPEN_SQL_DB

Hello Guru's,we are creating sales order in SAP from a quote created in .NET, through Web Service created in SAP, and consumed in .NET.When ever a order is created in SAP for a given quote, SAP returns the sales order number to .NET.Orders are getti...

Resolved! How to forbid some deletes in table maintenance generator

Hey gurus,I'm using table maintenance generator on my table and I would like to achieve that I could check whether to allow or not allow the delete action.In other words I would like to forbid to delete those entries, which are referenced in some oth...

Resolved! Sample Code for Order Updation

Hi Experts I have a requirement , when ever I save a particular Type of Sales Order say ZRAB ,(which is basically a credit note ) , I need to update the Header->text . Now I want whenever a user creates ZRAB Order and if he dont update the Text part ...

Update vendor master

Hi Experts,I have requirement where I want to automatically update bank details.Update Bank account number with “-” at second last position only for preferred bank account.I have used BADI ‘VENDOR_ADD_DATA’ and method ‘CHECK_ALL_DATA’ but it isgiving...

Moderator note about blogs and documents - read this before making a submission

Re: If you post a blog or document that's gets rejected, you will, in addition to not getting the points for the content, suffer a penalty, as outlined in the link above.Since I've had to reject quite a few documents and blogs over recent weeks, I ju...

Excel file generated through SAP not opening on Smartphone

Hi,My program sends an email with excel attachment (Used FM : SO_DOCUMENT_SEND_API1).Receiving person able to open and view the Excel file attachments on Laptops / Desktops.But on Smartphone, it gives error 'Can't Open - Excel doesn't recognize the ...

Handling sign of currency field

Hi All,In the table FEBKO we have two fields ESVOZ(debit/credit indicator CHAR1) and ESBTR(CURR17).Now I need to display the currency along with is sign based on the indicator for which I have written thebelow piece of code.IF w_output-esvoz2 = 'H' ...

BDC For Miro Process

Hii am in a customized process of making miro i have tried with bapi , but since we have tool cost as manual excise it is not correctly capturing and i also have a doubt in itwhen i do j1iex and then miro the tool cost is correctly calculated at miro...

Resolved! Gray out Selection option while filling in value for another Selection Option

H Experts,I have a requiremen about dealing with two Selection Options elements as follows.Eg: S_Opt1 and S_Opt2While filling in value for S_Opt1, gray out S_Opt2 for input. And while filling in value for S_Opt2, gray out S_Opt1.Kindly let me know if...

Resolved! SE80 Bug, left navigation mostly hidden

Hi All,I am facing a problem in SE80. The left navigation ist mostly hidden and I cannot change the width. I tried to change the theme, but that did not worked out.Does anyone of you have a solution to this? WIthout se80 I cannot work propperly warm ...

Resolved! Read itab without header

Hi,I'm moving in an internal table (without header) using a loop and I need to read the lines.With the read line (saving data in a wa) sentence it can be done but it returns me an error because the itab hasn't header. Can anybody tell me the correct...

Resolved! Blank Lines in a table in Smartforms

Hey fellas,Why m i getting 2 blank lines after each table line...?My Line Spacing Setting in Smartstyle is exactly 1 LN...if changed to less output is jumbled...And my internal table doesn't contain any blank line too...Plzz HELP !

Resolved! Error in Receiver - IDoc with errors added

Hi All,I am getting error in 56 - IDoc with errors added in receiver System.I am new in Idoc - please tell me How to resolve this issue..Thanks in advance..

way to get list of all the IDs maintained in various connections

Hello,I'm not sure whether this is the right forum to discuss this issue,if its not, please redirect me to the right group.I'm stuck in a place in my project where the requirement is to implement some security parameter related to dialog IDs, mainly ...

Problems with BAPI_ACC_DOCUMENT_CHECK - System asking for currency conversions

Hi experts,I am using BAPI_ACC_DOCUMENT_CHECK to check before calling BAPI_ACC_DOCUMENT_POST.My problem is that bapi return all the time gives me an error indicating i Have no conversion date. It should not ask me for that because all Amounts are i...

Resolved! How to update vendor address based on vendor control data

Hello,i have a request to update one field (Search term 2) from Vendor master Address view:based on industry code populated for the supplier (LFA1-BRSCH):This means if industry code is populated, address field SORT2 must be updated with corresponding...

server path not drive CL_GUI_FRONTEND_SERVICES=>FILE_OPEN_DIALOG

Hi folksWhen using the CL_GUI_FRONTEND_SERVICES=>FILE_OPEN_DIALOG or WS_FILENAME_GET we some times have the server path returned.And sometimes the drive letter returned.See two examples:1: \\blrx1\os390out\id1\test.txt2: R:\os390out\id1\test.txtWhat ...

Resolved! Smartform two mainwindows issue ?

Hi Folks,I have a scenario in SMARTFORM in which i have 3 pages....First page is with a main window with a table to display some data.Second page is with secondary window with some data in int.Third Page is again a different main window with a differ...

Raising Error in Screen

Hi,I have a requirement to raise error in Screen(Module Pool) and again allow user to stay in the same screen.But if i raise error then it is throwing user directly out of transaction.For example,if we see in VL02N we will get error while providing s...

Resolved! Set default print parameters for ALV

Hi experts,I want to preset some print parameters for an alv report and specially "NO SHADING".I've tried calling MF GET_PRINT_PARAMETERS at several points (INITIALIZATION, AT SELECTION-SCREEN) but either i don't call it the right way or at the wrong...

Dynamic Height of a lines in Adobe forms

Hi All,Below is my form layout -The middle boxes are always blank and just need to show as columns. Now, there is a chance of more data on both Black circle data and red circle data.If any of these increased, then I want to show the blank cells as we...

IDoc ready for dispatch (ALE service)

Hi All,I want to use i idoc for normal Ztable data to move into another server (i.e SAP to SAP server ). In that i am not getting error IDoc ready for dispatch (ALE service) in WE02 for this i use this RSEOUT00 program and change the status of Idoc 0...

calling function module code CREDIT_

Dear Guru's,I am new to ABAP, i need to call the function module"CREDIT_EXPOSURE".i need to take the 'SUM_OPENS" field value.where i have the table KNKK in the report.Kindly provide the sample code to call this function module.Regards,Abdul Rahim

To enable a textfield in Tcode FB02

Hi, I want to enable the textfield of Business Area(COLB-GSBER) in FB02 Tcode. I found the layout of the screen and wouldn't let me change the status of the textfield. Can it be done using Implicit Enhancement? If positive, what would be the name of ...

CALL_FUNCTION_REMOTE_ERROR dump at RECEIVE RESULTS FROM FUNCTION

Hello ABAP experts!I am getting the dump CALL_FUNCTION_REMOTE_ERROR when receiving results.This is my code..Got the dump when executing the line RECEIVE RESULTS FROM FUNCTION.I only encounter the dump when processing thousands of records.For few reco...

Resolved! Using BAPI_PO_CREATE1 to create a PO - MoT from contract is overwriting input

We're using BAPI BAPI_PO_CREATE1 to create a PO with reference to a conract.On that contract, we assign a MoT Group - a MoT value that corresponds to several MoT values.For instance, MoT 91 allows MoT 07, 08, and 09.When we pass a value to the OI...

Resolved! check "BKPF-Xreversal is NULL" in select statement

Hi ,I have come across a wierd problem . I dont want the solution , I just want the reason why it happened.In production environment below statement was working correctly .select .....from BKPF into lt_bkpf where Xreversal is NULL .It gave correct r...

Resolved! Restrict Users from Changing Spool Request Attributes

Is there a way to restrict users from changing the Retention Period from our Default Setting of 8 Days to "Do Not Delete" when running a background job ? I thought maybe S_SPO_ACT would be an option but was wrong.Thank You !

Resolved! using LSMW Mass Update Ztable

Hi everybody,My requierement is to update a Ztable from text file using LSMW.I have created Ztable and choose level 2 of screen management (sm30) . When I create my batch input, it's ajusted with specifics dynpros (If my table contain more than 1 ...

Resolved! SELECT statement query

Hello all, I understand this is a very basic question in ABAP. But, I was just having this doubt and would like to get it cleared before I move on with my development. There is this piece of code: SELECT afield ...

method CMD_EI_API=>MAINTAIN_BAPI to update KNVI tax data

Hi Experts,I am using method CMD_EI_API=>MAINTAIN_BAPI to create/update customer. I could not find the parameters/fields in the deep structure to update KNVI data. Please suggest the solution.Regards,Ashok

How to find the objectslist with username, who create all the Objects in List?

I have the username and how can I get the objects, which are created by the User.Thanks

enhancement for BADI ME_PROCESS_PO_CUST is not getting triggered in quality

Hi experts, We are facing a strange error in SAP standard behavior. We Created an enhancement for BADI "ME_PROCESS_PO_CUST" BADI and exported it to quality, but the problem here is BADI itself is not getting called in quality. There is no ot...

Displaying picture (jpg) from binary table at subscreen

Hi,I was looking for answer, but no success and I decided to ask you for help.I have database with picture saved in binary format. I filled the db using 'GUI_UPLOAD' and now I would like to display this picture on my sub-screen.I found the method CAL...

Customer creation BAPI

Hi experts, Is there any BAPI for Customer creation? I tried with BAPI_CUSTOMER_CREATFROMDATA1, but it doesn't have account group field and also reference customer is mandatory field.There are many fields are unavailable in that BAPI. Ple...

Resolved! Help with Changing Loop logic to Read logic

Hi, I am looking to change the following Loop logic to using read logic because it will probably lead to faster performance. Table is Sorted Table with Key MATERIAL DATEFROM DATETO. This code is trying to find a material price record within a price...

SAP Smartform- how to print character '

Hi Experts,In my Smart Forms, i have to print word " Customer's " . when Checking in the print preview it is showing good. but after converting the spool to PDF it is showing " Customer#s ". Please suggest how we can fix the same.Regards,Priyanka

How to create a long text with CALL TRANSACTION

Hello,I am trying to create a notification like this CALL TRANSACTION 'IW21' USING gt_bdcdata MODE l_mode UPDATE 'S' MESSAGES INTO retour_avis. It works but I need to attac...

Resolved! How to get the line I marked to delete in Table control in Pop up Message

Hi experts,I want to delete a line in Table control and hence from Ztable. All is working fine till here. But I want that as soon as I select the line to be deletedand then hit the delete button, then a pop up must appear carrying a messsage in which...

Hiding SAP clinet selection and Logon screen from BDC

Hi ,I am newbee to this community and SAP as well.I am running a BDC to open MIRO screen , but i will give username , password from background , so is htere anyway where i can hide sap client and loggin info dialogs while opening this in SAP ui , I a...

Problems of Modifying XVBAP

Hi all,To move data from xkomv to vbap table i have coded as below.FORM USEREXIT_MOVE_FIELD_TO_VBAK.loop at xvbap.read table xkomv with key kschl = 'MWST' kposn = xvbap-posnr. xvbap-zz_mwsk1 = xkomv-mwsk1.modify xvbap.endlo...

want to remove duplicate values from calibration report

Hi all,I developed a report in sap for calibration. i just wanted to remove duplicate values from one column . when i use collect statement on internal table it affects other columns also. kindly suggest how it is possible. i screen shot highlighted...

I want to add new field in FBL5N that need to done from BTE 1650

Hi all,I am having a requirement i want to add XREF1_HD field fromBKPF table to FBl5N screen ,can any one say me the procedure to how to handle it..Thanks,Ramesh

load (.xlsx) file to internal table

hello all,is there any function module to load excel file(.xlsx-2010) internal table...thanks in advance....

Hot to remove button for a particular record in ALV lvc version

Hi,i have created ALV using'REUSE_ALV_GRID_DISPLAY_LVC' function module, in which am displaying buttons in a colomn.Now i want to remove the button for few records based on some condition.How is it possible.Regards,Manoj.

Resolved! Setting Cursor Position in ALV List

Hi Experts,I have an ALV List with two input fields in the end_of_page.My requirement is to set the cursor position on these two input fields in list output on validation.I have tried with ,SET CURSOR FIELD 'GWA_HDR-ZZCHK_EMPN' LINE lv_pos.Unfortunat...

Getting data from pcl4 in optimize way and optimization of code

Hi all,Acutally I have two problems, first the report that I have assigned to make it better in performance, was actually created back in 2000.In this there is lot of select endselect statemtns which makes the report slower then usual, and second thi...

passing internal table to sap script

Dear all,I have passed internal table values as standard text into sap script. The table values are coming in dev and qas server. while executing in production , it shows as follows instead of table values.Standard text is existing in production ser...

Resolved! PO list - 3 approvers

Hi,I've created a report showing all Purchase Orders approved by the same user who created the PO. Through CDPOS-USERNAME I got the user who approved the PO. In case a PO may be approved by 3 different users, how could I get the names of all 3 approv...

XML format of IDOC

Hi Experts,I would like to download the XML format of an IDOC. For example, I would like to have something like this with all the fields of the IDOC:<?xml version="1.0" encoding="UTF-8"?><ZORDERS01 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instanc...