Select for all entries

Archive for April, 2009

Select for all entries

By rmsb on Thursday, April 30th, 2009 | 1 Comment

GA_googleFillSlot(“POSTSAP”); When you need to access many records from one internal table is better to use select for all entries. instead of doing this loop at internal-table select * from table where……. endloop. it’s better to SELECT * FROM bkpf INTO CORRESPONDING FIELDS OF TABLE it_bkpf FOR ALL ENTRIES IN it_vbrk WHERE bukrs = it_vbrk-bukrs [...]

Add SAP External Database Connection (DBCO)

By rmsb on Tuesday, April 28th, 2009 | No Comments

When you want to set up external database connection, you need to use DBCO Transaction. When using DBCO you are setting up the properties for an external database. REPORT ztest. DATA: BEGIN OF wa, ncust(40) TYPE c, name(35) TYPE c, END OF wa. DATA: dbs TYPE dbcon-con_name. DATA: con(20) TYPE c. DATA : ls_wa LIKE [...]

Button in Sales Order ( Generic Object Services )

By rmsb on Thursday, April 23rd, 2009 | No Comments

The Upload files button in ECC is missing from sales order. In order to place this button again in sales order, please do the following: Go to SU01; Insert Username and press Edit.; Go to parameters and set: SD_SWU_ACTIVE = X ; That’s it, go to sales order and the button will be there!!

Difference between select single and up to 1 row

By rmsb on Tuesday, April 21st, 2009 | No Comments

The ‘SELECT SINGLE’ statement selects the first row in the database that it finds that fulfils the ‘WHERE’ clause If this results in multiple records then only the first one will be returned and therefore may not be unique. The ‘SELECT ….*….. UP TO 1 ROWS’ statement is subtly different. The database selects all of the [...]

Calculate number of days, months and years in SAP ABAP

By rmsb on Friday, April 17th, 2009 | No Comments

In ABAP there is a function to calculate the number of days, months and years! Example: CALL FUNCTION ‘FIMA_DAYS_AND_MONTHS_AND_YEARS’ EXPORTING I_DATE_FROM = ’20081008′ I_DATE_TO = ’20090116′ IMPORTING E_DAYS = T_DAYS E_MONTHS = T_MONTHS E_YEARS = T_YEARS. 　 Result : T_DAYS = 466 T_MONTHS = 16 T_YEARS = 2

How to block an input field selection screen

By rmsb on Friday, April 17th, 2009 | No Comments

Just use this code: PARAMETERS: p_werks LIKE mseg-werks OBLIGATORY DEFAULT ‘PHAS’ MODIF ID bl2. AT SELECTION-SCREEN OUTPUT. LOOP AT SCREEN. IF screen-name = ‘P_WERKS’ . screen-input = ‘0′. screen-output = ‘1′. MODIFY SCREEN. ENDIF. ENDLOOP.

Upload Images to SAP SAPSCRIPT

By rmsb on Thursday, April 2nd, 2009 | No Comments

When you net to upload images to use in sapscript or smartforms you need to use report RSTXLDMC. this report will upload images as a standard text. Then call the text name as if you were calling an SO10 standard text:

M	T	W	T	F	S	S
« Mar				May »
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

SAP KD

Archive for April, 2009