Posts

BAPI for material storage location Add

 We can add material storage location plant wise using third party app or web. BAPI names : BAPI_MATERIAL_MAINTAINDATA_RT Import parameters: HEADDATA: Material Tables: STORAGELOCATIONDATA: Material: Plant: STGE_LOC:   STORAGELOCATIONDATAX: Material: Plant: STGE_LOC:   use below code after completing steps. CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'.        

Material Documents cancellation

 Use transaction MIGO.  Select A03 Cancellation & R02 Material Document and then provide material document number then check the indicator that item is OK then check and post. Check MMBE, stock is transferred.

Open SQL & Native SQL

 In ABAP programming language there are two types of SQL used: i) Open SQL ii)Native SQL . Open SQL allows you to access the database tables declared in the ABAP dictionary regardless of the database platforms that the R/3 system is used Open SQL consists of a set of ABAP statements that perform operations on the central database in the R/3 system. The results of the operations and any error messages are independent of the database system in use. Open SQL thus provides a uniform syntax and semantics for all of the database systems supported by SAP. Basic Open SQL Commands: Select , Insert , Update, Modify , Delete, Fetch , Open cursor, Close cursor.   Native SQL allows to use database-specific SQL statements in an ABAP/4 program. This means that you can use database tables that are not administered by ABAP dictionary, and therefore integrate data that is not part of the R/3 system.      

Important T-Code

T-Code Description Module COR2 Change Process Order PP-PI-POR COPD Print Process Order PP-PI-POR COR1 Create Process Order PP-PI-POR COR3 Display Process Order PP-PI-POR CO44 Mass process ing of order s PP-SFC CORN Order Types Process Order PP-PI BBPOR02 Post- Process ing Order s SRM-EBP CO06 Back order Process ing SD-BF-AC MSAM_ORDER Order Process ing Profile PM-WOC ALM_ME_ORDER Order Process ing Profile PM-WOC FN_PPO2 Edit Post- Process ing Order FS-CML-PO BKK_PPO_CHANGE Edit Post- Process ing Order IS-B-BCA BKK_PPO_DISPLAY Edit Post- Proc...

Do you want to check fiori is active or not

 In T-Code panel provide /n/ui2/flp If Fiori is active then it will open a browser window. ui2 for user interface. flp for fiori lunch pad.

Find SAP tabel without knowing anything

Image
 SAP is just like an ocean and we cannot know all the things. Sometimes we need to work with unknown tables without having table ideas.Using below step we can find out related tables information. Step 1: Use T-code SE16T     Step 2: Just Execute     Step 3:In table search term provide relevant business process name. Here I am using Bom link to find out all relevant table.    Hope so it will help you lot.