Posts

Showing posts from October, 2017

Create Secondary Index on SAP Table

Image
Why We need to create Secondary Index :      Secondary Index is the one which we create separately for the speed access    of a database table. Procedure Sequences are given below : To create a secondary index on SAP table, display the table in ABAP dictionary (Tcode : SE11) Follow the screenshot Write the index name : Add filed name for secondary index : Finally save and activate. Some It may occurs warning.  So  goto Tcode : SE14 and activate and adjust database. If you query by using secondary index :  Query  may like as :  SELECT SINGLE xblnr INTO t_xblnr FROM bkpf      WHERE xblnr = trcode     %_HINTS ORACLE 'INDEX("bkpf" "bkpf~ZRF")'. I have shown this query only for Oracle database. Also don't need by following this query. You can write Normal Query by using Secondary index. It will be called automatically. Note :    You ca...

Create/Edit/Delete Attachments using GOS in Sap ABAP

Image
Describe step by step of Create/Edit/Delete Attachments using GOS in Sap ABAP : Implented abap code here : DATA : is_object TYPE sibflporb,        ip_mode TYPE char1,        ip_edit TYPE char1.     ip_mode = 'D'. “ for display purpose     ip_mode = 'C'. “ for create/edit purpose            is_object-instid =  “must be unique no it may seles order number           is_object-typeid = “must be unique no it may seles order number           is_object-catid = 'BO'.           IF  is_object IS NOT INITIAL.             CALL FUNCTION 'GOS_ATTACHMENT_LIST_POPUP'             ...