Let US ABAPLet US ABAPThis blog has information on SAP ABAP. Will contain short tutorials on the following topics Basics of ABAP, Reports, Interfaces, conversions, Enhancements, Sapscripts, ALE, EDI. Some of the functional topics will also be covered which are relevant fo
Articles:
1, 2
Articles
SAP SD Tables
2008-02-16 12:59:00 SAP SD Tables Table Description VBAKUK Sales Document Header and Status Data VBUK Sales Document Header Status and Administrative Data VBKD Sales Document Business Data VBEP Sales Document Schedule Line Data VBFA Sales Document Flow VBAK Sales Document Header Data VBUP Sales Document Item Status VBAP Sales Document Item Data VBPA Sales Document Partner VBBE Sales Requirements Individual Records KNVV Customer Master Sales Data KNVI Customer Master Tax Indicator KNVP Customer Master Partner Functions KNV...
Sales Document Flow
2008-02-15 16:05:00 Sales Document Flow Many a times ABAP professionals need to check the document flow in SD. To do so run transaction VA03.Enter the Sales Order Number.To see the document flow press F5 or click on Display Document Flow.Select Delivery and click on Display document Keyboard shortcut F8The outbound delivery connected to the selected sales order is displayed.Similarly the goods issue document can be displayed.And the Material Document.And the Financial Document.Similarly you can open the Delivery and see the document flow for the delivery. Use transaction code VL03N to display the delivery.Enter the Delivery Number.Press the document flow button. Keyboard shortcut F7.As shown below the documents related to the Delivery are displayed.Use transaction SE16 or SE16N or SE11 to display the table VBFA.VBFA is the Sales Document Flow Table.Double click on the first row.We need to check the Sub Document Category. More About: Sales
Sales Document Flow
2008-02-15 16:05:00 Sales Document Flow DownLoad PDFMany a times ABAP professionals need to check the document flow in SD. To do so run transaction VA03.Enter the Sales Order Number.To see the document flow press F5 or click on Display Document Flow.Select Delivery and click on Display document Keyboard shortcut F8The outbound delivery connected to the selected sales order is displayed.Similarly the goods issue document can be displayed.And the Material Document.And the Financial Documents.Similarly you can open the Delivery and see the document flow for the delivery. Use transaction code VL03N to display the delivery.Enter the Delivery Number.Press the document flow button. Keyboard shortcut F7.As shown below the documents related to the Delivery are displayed.Use transaction SE16 or SE16N or SE11 to display the table VBFA.VBFA is the Sales Document Flow Table.Double click on the first row.We need to check the Sub Document Category.Sub Document Category 'R' ----- Goods movement. Similarly the desire... More About: Sales
Creating a Table in SAP
2008-02-14 17:42:00 Creating a Table in SAPRun transaction code SE11 to create table.Enter the desired table name. Make sure that you follow the naming convention. Name should either start with 'Z' or 'Y'.Delivery class needs to be entered as shown in the figure below.Select A application table master and transaction data.Check the table maintenance box. And click on the Fields Tab.Enter the Filed names as shown in the figure below. Matnr with data element 'MATNR'For the 'ADDDESC' field please click on the Data element button as shown in the figure below.Click on the technical settings button. For data class select APPL0And For size category select 0Select buffering not allowed for this table.Make Material number as the Primary Key.Activate the table.Go back to transaction SE11 and select Utilities------> Table maintenance generator.In the resulting screen for Authorization group select &NC&Select the one step and standard recording routineNow we need to create a Function group. For th... More About: Creating
Recording a BDC using transaction SHDB
2008-02-13 15:19:00 Recording a BDC using transaction SHDBEnter trasaction code SHDB as shown. The following illustration shows BDC recordingto create a customer in the SAP system.Press F5 or click on New RecordingEnter transaction code XD01 to Create Customer and Click on Start RecordingEnter the desired account group, in this case Sold to PartyIn the trasaction XD01 enter the desired dataHit enter to go to the next screen. Once all the desird data is eneterd click on save.You will then see the following screen.Select the recording as shown below. And click on Program.Enter the program name. Select transfer from recording for this example. And hit Enter.Enter the Program description. And click on save. Create a $tmp objector let the system generate the transport request number.The code as shown below is generated.Run the program by presing F8 More About: Recording
USER EXITS in SAP SD
2008-02-11 07:10:00 USER EXITS IN SAP SD DownLoad PDFOne of the methods to identify the user exits for Sales and distribution is through IMG. We would be exploring other methods later in this month.Enter transaction SPRO as shown below.Click on SAP Reference IMG or press F5 as shown belowSelect the Sales And Distribution option as shown in the figure below.Select User Exits in Sales Document Processing as shown belowYou should get a listing of all the user exits related to Sales Documents as shown below
Important Transaction Codes
2008-02-07 18:15:00 Important Transaction Codes (The list will be updated soon)SE38 ABAP EditorSE37 ABAP/4 Function ModulesSHDB BDC RecordingLSMW Legacy System Migration Workbench. S001 ABAP WorkbenchS002 System AdministrationSA38 Execute a program. SCAT Computer Aided Test ToolSE30 ABAP/4 Runtime AnalysisSE32 ABAP/4 Text Element MaintenanceSE35 ABAP/4 Dialog ModulesSCUO Customizing Cross-System ViewerST05 Trace SQL Database Requests. ST22 ABAP Dump analysisSU53 Display Authorization Values for User....
Creating a function Module in SAP ABAP
2008-02-06 16:31:00 Creating a Function Module in SAP ABAP. DownLoad PDFExecute transaction SE37 and create a function group as shown in the figure below. Give the desired function group name and a short text.Once the function group is created type the desired function module name as shown below.And click on create.Enter the function group name created earlier and the desired short text for function module.and click on save.Save the function module as a $tmp object.Now the following screen will be presented to you, here you need to enter theimport and export parameters. These are nothing but the variables that youwould be passing to the function module and the returned values from thefunction module.The following screen shot shows the returned values from the function module.Type the following code in the source code area.Active the function module and the related code.Call the above created function module from an ABAP Report. The following screen shotshows the details to insert the code.Type the cod... More About: Creating
List Of Important System Variables
2008-02-05 17:10:00 List Of Important System Variables INDEX SYINDEX INT4 10 0 Loops, number of current pass PAGNO SYPAGNO INT4 10 0 List creation, current page TABIX SYTABIX INT4 10 0 Internal table, current line index TFILL SYTFILL INT4 10 0 Internal tables, current number of lines DBCNT SYDBCNT INT4 10 0 DB operations, number of table lines processed FDPOS SYFDPOS INT4 10 0 Character strings, offset in character string COLNO SYCOLNO INT4 10 0 List creation, current column of list LINCT SYLINCT INT4 10 0 List proce... More About: List
ABAP Tricks and Tips
2008-02-04 07:02:00 SQL Interface. Download PDF Select Where VS Select + CheckAlways specify your conditions in the Where-clause instead of checking them yourself with check statements. The database system can then use an index (if possible) and the network load is considerably less.Select with Index SupportFor all frequently used Select statements, try to use an index. You always use an index if you specify (a generic part of) the index fields concatenated with logical Ands in the Select statement's Where clause. Note that complex Where clauses are poison for the statement optimizer in any database system.Select single vs. Select-Endselectif there exists at least one row of a database table or view with a certain condition, use the Select Single statement instead of a Select-Endselect-loop. Select Single requires one communication with the database system, whereas Select-Endselect needs two.Select Into table tIt is always faster to use the Into Table version of a Select statement than to use Append ... More About: Tips , Tricks
Text Elements
2008-02-01 08:55:00 Text element maintenance can be done in the ABAP Workbench. It is used to maintain program text in different languages. The text that program uses can be maintained centrally for a program. Transaction SE38 (ABAP Editor) Menu Path >>>>> Goto--------TEXT ELEMENTS---------------Selection Text Please check the screen shots below. More About: Elements , Text
Displaying Data Using SE11/SE12/SE16/SE16N
2008-01-24 12:05:00 Logon to SAPEnter Transaction Code SE11.Note that transaction SE11 can be used to Display/Change/Create database tables. Other transactions for ABAP dictionary are as followsSE12 DisplayData base TablesViewData TypesDomainSearch HelpLock ObjectsSE11 Display/Change/CreateDatabase TablesViewData TypesDomainSearch HelpLock ObjectsSE16 and SE16N Data BrowserEnter the Table name in this case VBAKClick on Display.Click on COntents as shown below or use shortcutCTRL+SHIFT+F10Enter the desired data. In this case the sales order number.The data is displayed as shown below.
Select Statement
2008-01-23 14:30:00 Retrieve the data from the SAP database using the select statement and the where clause.Some examples of SELECT Statement .SELECT * INTO wa FROM (name) CLIENT SPECIFIED WHERE mandt = '000'. WRITE: / wa-carrid, wa-carrname.ENDSELECT.SELECT * INTO wa FROM scarr UP TO 4 ROWS. WRITE: / wa-carrid, wa-carrname.ENDSELECT.For more examples pleas refer to SAP help click on the links given below.SELECT ClauseVariants:1. SELECT [SINGLE [FOR UPDATE] | DISTINCT] *2. SELECT [SINGLE [FOR UPDATE] | DISTINCT] s1 ... sn3. SELECT [SINGLE [FOR UPDATE] | DISTINCT] (itab)Please check the following discussion on Select ing a single row.SAP SDN Select Single row.
A simple ABAP Report
2008-01-22 12:58:00 Program to display sales order header dataIn this program we will display the sales order header data.Following fields will be displayedSales Order numberSold to party numberShip to partyBuyerNet ValuePayment TermsFocus1) Retrieve the data from the SAP database using the SELECT statement and the WHERE clause2) Selecting SINGLE rows3) Using SELECT-OPTIONS4) Displaying data from tables using SE115) Using TEXT ELEMENTS6) Data Declaration7) Table Declaration8) Using the WRITE statement9) Using the debugger10) Using double click to display the tableTables usedVBAK Sales Document Header DataVBPA Sales Document PartnerVBKD Sales Document Business DataTo get help on any of the statements in SAP, move the cursor on the statement and press F1Fully Functional Sample Code for the Program.********************************* ***************************************** ***************************ABAP Report to display Sales Order Data************************************* ***************************... More About: Simple
Creating your first Program in ABAP
2008-01-13 08:03:00 Steps to create a simple program in ABAP.1) Login to SAP.2) Enter the transaction code SE38 as shown in the figure.3) Hit enter.You will then be taken to the ABAP Editor initial screen.Enter the name starting with Y or Z as shown below. Let the source code radio button be selected and then press create.See the attributes dialog box below.Click on SaveEnter $tmp in development class and click on save button More About: Creating , Program
Introduction
More articles from this author:2008-01-06 07:52:00 ABAPABAP (Advanced Business Application Programming) is a programming language for developing applications for the SAP R/3 system, a widely-installed business application subsystem. The latest version, ABAP Objects, is object-oriented programming. SAP will run applications written using ABAP/4, the earlier ABAP version, as well as applications using ABAP Objects.Creating your first Program in ABAP More About: Introduction 1, 2 |
|
 |
|
 |
