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

About Programming & SQL query Introduction

Hello Everyone !!!
I am trying to help you for sharing some programming problem.Programming is a part of life.Sometimes its changed.Like life is valueless without programming.So,don't be upset. Don't be hopeless.There are lots of hope.If you can take it as a part of your life.
I am talking too much.Now come to the point. if I asked anybody say something about programming language,I sure most of them give me a vast description about specific language.How many programming language we have,I am just mentioning some of these: C,C++,C#,Java,Python,Ruby,PHP,JavaScript,Perl,CSS and so and. I am trying to give some idea about a few of these.
Today I am describing SQL query language.
SQL is a standard language for storing, manipulating and retrieving data in databases.

What is SQL?

  • SQL stands for Structured Query Language.
  • SQL lets you access and manipulate databases.
  • SQL is an ANSI (American National Standards Institute) standard.

    What Can SQL do?

    • SQL can execute queries against a database
    • SQL can retrieve data from a database
    • SQL can insert records in a database
    • SQL can update records in a database
    • SQL can delete records from a database
    • SQL can create new databases
    • SQL can create new tables in a database
    • SQL can create stored procedures in a database
    • SQL can create views in a database
    • SQL can set permissions on tables, procedures, and views.

     Here I am talking about Select Statement only.
    What is a select query?
    A select query is a database object that shows information in Datasheet view. A query does not store data, it displays data that is stored in tables. A query can show data from one or more tables, from other queries, or from a combination of the two.

    When we used Select query?
    After creating table ,sometimes we need to check table specific column or row value.At that time we used Select  statement. 
    Suppose we have a table name Student_Info having some of columns  like:Student_ID,Student_Name,Student_ContactNo,Student_address
    In that case if we want to check the total content of the table then we need to write the following statement:  Select * from Student_info (table name)
    As look like below image:Firstly I create a Database then create a table. I Insert some value in the table field.Then using Select statement single query and lastly using with where condition.Just check it out:

     



    By writing this statement we can check the total value of a table.
    Suppose we want to check specific column value against a specific ID then we need to write the following statement:
    Select   Student_ID,Student_Name,Student_ContactNo (Column Name) from Student_info (table name) where Student_ID='001'

    This is the end of today's description.Hope it will help you.If you have any query please give me knock.if am I made any mistake please correct me.

     

     

 

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