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...
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...
Hi, I am going through some of SAP tutorials and found the following: SELECT * FROM SPFLI WHERE CITYFROM LIKE '_R%'. WRITE: /10 SPFLI-CARRID, 20 SPFLI-CONNID, 30 SPFLI-CITYFROM. ENDSELECT. following is my resulting list which doesnot in...
Hi experts, I have written a query but its not producing right output... to be more precise quantity field condition is not checked. SELECT a~werks, a~lgort, a~matnr, a~charg, a~ersda, a~clabs, a~cinsm, a~cspem, b~maktx, ...
Hi experts, I wrote a simple query SELECT werks, lgort, matnr, charg, ersda, clabs, cinsm, cspem, concat( matnr, charg ) AS merge FROM mchb WHERE lgort = @p_store AND werks = @p_plant AND matnr IN @s_matnr AN...
Hi Experts, While adding new line item, ship to party address number of existing line item is getting deleted from ADRC table. Due to this address is not appearing in SAP GUI(VA42/VA43). I am adding new line using bapi_customercotract_change. Ex...
Hey guys,I've been having difficulties with this need, and from my research there's nowhere to run due to the column character limit, I wanted to know how a current problem is like you guys got around this. Since I need to show the entire ALV and sti...
according to my company point of view i zprice t-code 4 types of items price list are there so in that 4 items list pharmacy items ,surgical items,general items,consingment items are there so those 4 items price lists are generating in month e...
Hi all. I need to check Validity End field in agreement creation and show an error thats allows you to modify the field not correct, as the standard message in the example: I have tried with BADI ZME_PROCESS_PO_CUST and ZME_PURCHDOC_POSTED, I...
Hello, when we got a communication error with our SMTP relay, a lot of EMail's will get on error (Transaction SOST, message number 816).We are looking for a way to resend these EMail's (like F7 in SOST) via a job/report every couple of hours so tha...
Hi Friends, In Tcode VA01 - Shipping tab - delivery group field(GRKOR) is not coming in EXIT_SAPLVEDA_002. How to add the field in BDC(User exit). I have written the below code ASSIGN COMPONENT 'GRKOR' OF STRUCTURE dxvbap TO FIELD-SYMBOL(<lfs_g...
Hello experts, On my job, we are discussing about the performance and how to access to the data existing on database tables using a report. Is there any SQL sentence that we can use on SE38 without using an internal table? As far as I know it is al...
Good morning everyone, I need to have a percentage of the total revenue I have in a group. the revenues are given by two invoices + payments accounts each account must divide by the sum of the revenues .. How can I calculate it?
Hi experts, I got the value "1552895432011" of datetime field(createdAt) from SaaS, how to convert to date or timestamp using SQL ? to_date(createdAt) , to_timstamp(createdAt) not worked. Tks.
Hi, The spool entry is generated for a material document (PDF) but no printing done on printer. Spool entry status: Spool request has not yet been sent to the host spool system. Kindly assist me with what can be done to resolve this issue. Re...
While creating a SPRO role [SAP S/4HANA FOUNDATION 2021]; Created a project in SPRO_ADMIN and then in PFCG added it through authorization customizing but it is not pulling in any authorization objects [Auth Tab shows up blank]. Also the tab is not sh...
Hello Experts. I need to create new entries to add-on tables in SE16N not in SE16 because of a specific reason. When trying to do that, I noticed that maintenance entries checkbox which needs to be flagged to edit table entries is disabled. Howev...
Hello experts, my requirement is that once I get EDI X12 formatted data, I have to store them in SAP system to make FI posting later. I'm using FTP Function Modules, but I'm not sure how to parse the data. Data look like this(I got this from G...
Hello Everyone, I have a requirement where i need add standard fields from table TFLOT to API API_FUNCTIONALLOCATION. I am aware of process where i can directly go and add these fields in CDS view and then these will be available in this API. ...
I am trying to produce a table for multiple selections of users at once. My code works for one user but the client wants to be able to use the multiple selection to enter a group of 5 users at once to view a table for each. Is there a way to loop t...
Hi. This is how my productive code looks like. METHOD do_something DATA(lr_vehicle) = get_vehicle( ). IF lr_vehicle IS INSTANCE OF zif_interface_fuel_water. rv_no_wheels = abap_undefined. RETURN. ENDIF. data(lv_wheels) = lr_vehicle->get_wheels( )...
Hi, I know there is a possibility the SAP HANA DB using fuzzy search via constains( name, :iv_name, fuzzy) syntax. Is there anything similar possible in an internal table? I use currently CS (contains string) operator, but it doesn't support an...
What is the best practice for linking to test relations for private methods. For example I have a ABAP Class with some private methods. PRIVATE SECTION. METHODS set_remittance_vend_reference [...] And in my test class I want to link the Unit Te...
Who has already encountered this error. the Data Elements of ANGDT Field and other fields in DDIC are DATS while the EDM Core Type of oData entity set is EDM.DateTime. The Format of DATS is YYYYMMDD(original) MM.DD.YYYY(if view in DDIC ) and its not ...
Tables: BSIS, BSAS Required fields - DBMBTR
I followed this tutorial to create a program to upload a excel sheet to an sap ztable. How To SAP Upload Excel File With TEXT_CONVERT_XLS_TO_SAP (sap4tech.net) I am wondering if there is a way to start filling in the data to the second column of...
Hi!<br>How do I make a field autocomplete depending on what is loaded in another field? Example: Complete vendor field and the vendor code field is autocompleted with the vendor code<br>Thanks!<br>Valentin<br> <br><br>
I want to analyze costs (CO Objects in COBK/COEP) related to deliveries (Delivery Items in LIPS/LIKP) is there any way to link those tables ?
Dear Friends , I have made a program that call an API and the answer is in UTF-16 and I cannot handle it. I have searched many hours on the forum but I did;t managed to fix it. Can you propose something? CALL METHOD P_HTTP_CLIENT->RECEIVE EX...
Hi all, I am new to SAP. Please help me in resolving the below issue. I want to find the changes in material master of particular fields and upload a file on application server using AL11. I tried to find the material changes using CDHDR. But t...
Hi all, I am new to SAP. Please help me in resolving the below issue. Actually, I want to read a basic data text into a string variable. I have used FM READ_TEXT and used tdline to read the basic data text of material master. But the characters i...
SAP creates a document number, but does not update the database. It means although we can create a material master, vendor master, PO, PR, etc., but we cannot either get to Change or Display view.System says that "this xxx does not exist" I have ...
I have a selection screen with a couple radio buttons and select-options with my parameter for the file path at the end. If I just have the parameter without the rest the File Explorer will pop up no problem when I click on the button next to the box...
hi. there is a tcode cc32. Using this one we can release the Change request. Anybody used any bpai to Release the Change request. If yes.. kindly advice me the Bapi's I tried but not found.We can call ECR or ECO also. Thank u.
I made Listbox on screen using function `VRM_SET_VALUES`. It works normal, but I can't choose field from the list. Artibute is `DATA gs_screen1100-db_flight(40) TYPE c`. Have I forgotten something? MODULE init_listbox OUTPUT. DATA: ls_value ...
Very urgent help needed, there is custom report program which writes vendor data to application server. When the report is executed, at end we are getting pop up to log off from sap system. what would be the issue ??
Hello everyone , My table looks like DATE HOUR 21.05.2022 4 21.05.2022 3 22.05.2022 5 but I want output to be as, DATE HOUR 21.05.2022 7 22.05.2022 5 Can you please help me ?
Hi, I would like to ask, what is the standard way of development in SAP Landscape. Currently in our group of companies, all development in done on a SAP Sandbox (with latest data) , once the result is as expected, programs/functions/structures et...
Need ABAP program which will download all the SPRO configurations across modules in a folder structure in local file system
Hi gurus , I have a unique requirement client wants to send all the attachment of VF03 as mail(can be pdf , word , excel etc. Can you please share any ideas how to achieve this . Regards neelabh
Hi, I am trying to change the wbs element with Bapi_po_change i have the po_item and po_account filled and i receive a message that the wbs element is needed. I have the wbs_element in the po_account. What is missing? Can you help me? Thanks ...
Is there a definition of the CVA priorities 1,2 and 3. thank you
When I create my LSMW batch recording I get an error message "Please fill in the PC field", and then I enter a value and proceed and everything looks fine. When the batch session is created and I execute the batch job, I get the same message but th...
Dear Experts, We have an urgent requirement to add barcode for Storage Bin field as a new output column in LI04 transaction. And we have already copied this standard transaction to ‘Z’ program and added other additional fields as required. Issu...
I need Add a field in Screen standard tcode UDM_DISPUTE, after running Tcode UDM_DISPUTE input is case id or Company code, then a report will generate then after double clicking any of the record it will show screen with details there i need to add a...
DATA: RESULT(3) TYPE P DECIMALS 2, OPERATOR TYPE C. case val. when >=97. operator = 'A+'. when others. operator = 'F'. endcase. how can i use value of variable val with comparision operands of >= or <= signs in case statement ?Th...
I HAVE CREATED SIMPLE ALV REPORT IN WHICH I HAVE USED EKKO,EKPO AND LFA1 TABLES AND I WANT TO KNOW THAT WHAT ARE THE STEPS TO BE TAKEN TO SHOW ThE OUTPUT OF MY ALV REPORT INTO SMARTFORMS. REPORT ZAHDEMO_PO_REPORT. TABLES : EKKO, EKPO. TYPES : B...
Hi all, i want to convert ERDAT to YYYY-MM-DD format directly in select statement in Database - MSSQL. Date format YYYYMMDD to YYYY-MM-DD. is it possible? Regards
Hi,I have a question about how to add value help annotations to the odata metadata which is published by CDS Query? I tried different ways and read a lot of questions and documents but nothing helps.I have a CDS Qube and a CDS Query on top of it. The...
Is it possible to open a file explicitly in read only? Or have a project setting for that? Use-Case: I connect to two clients with AdT: a development client and a test client (connect for debugging). -> For the later, I don't have authorization ...
I have a report that generates this ALV output: When I click on the default 'Export to file' button and export to an unconverted text file, this is what gets downloaded: (the right-most ItemNo column gets written as the first row, and notificati...
Hi Guys, I am writing a function module in which i have some variables against which i want to check the input parameters. I want to maintain this configuration outside my FM and want to refer it. What are different ways of externalising such varia...
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
