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'.        
Post a Comment

INSERT INTO Statement

After Creating Table successfully we need to insert value in the existing table.So,I am showing you how to insert value in a row.
The INSERT INTO Statement is used for insert value in a table as a row wise.
There are two basic syntax.I am giving both of them.
INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)  
VALUES (value1, value2, value3,...valueN);
and the other one is :
INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);
 
If we create a table for Customers then the query looks like: 
 
 INSERT INTO Customers(Cust_Id, Cust_Name, Cust_Addr,Cust_Phone)  
VALUES (1001, Harish, Park Street,+9178999999);
 
Similarly we can use the other one.Here we just put the value directly.
never break the sequence,otherwise you 'll get wrong values.

Comments

Post a Comment

Popular posts from this blog

New commodity code create in SAP S/4 Hana

Image
Commodity codes are internationally recognized reference numbers. A code describes a specific product when importing or exporting goods. You will use this code on any customs declarations and can find them in the Trade Tariff tool. Before S/4 Hana we can create commodity code by using GUI but from S/4 Hana need to use fiori interface to create commodity code. Let's explore it.   T-Code: /UI2/FLP Launchpad is opening and then select Manage commodity codes Tile. After that need to provide No. Scheme contend and click Go button and then need to click add button. Give commodity code and Description with valid from date to valid To date. After that press save button. That's it, your commodity code is created and now need to assign it against material number. Check /SAPSLL/CLSNR table for commodity code added or not.  Check MARC table stawn field to confirm material level assigned or not.
Read more

Convert First character to Upper case in SAP ABAP

 In SAP sometime we need to convert string as first letter in capital format and then start with small letter word wise. For that case we need to use Function module. In my profession i did so many times. Give here example, hope it will help you to solve the issues. FM: 'FI_CONVERT_FIRSTCHARS_TOUPPER'     Data :  string   type  char255 ,       OUT_STR  TYPE  CHAR255 . string  =  ' SMALL CHANGE' . CALL  FUNCTION  'FI_CONVERT_FIRSTCHARS_TOUPPER'    EXPORTING     INPUT_STRING         =  'string' *   SEPARATORS          = ' -.,;:'   IMPORTING    OUTPUT_STRING        =  OUT_STR            .   Output: Small Change...
Read more