Three tables inner join in SAP

Thu May 03, 2012 4:47 pm by Uma_ABAP

SELECT a~matnr INTO TABLE lt_mat
FROM mara AS a INNER JOIN marc AS c ON c~matnr = a~matnr
INNER JOIN mard AS d ON d~matnr = a~matnr
WHERE ( c~werks = p_werks AND d~lgort IN s_lgort ) AND matkl IN lt_mgreg AND
a~lvorm = ' ' AND c~lvorm = ' ' .

Comments: 0

Creating table type in ABAP

Sat Apr 28, 2012 9:03 pm by Uma_ABAP

*&---------------------------------------------------------------------*
*& Report ZCH_DEFINING_TABLE_TYPE
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT ZCH_DEFINING_TABLE_TYPE.

TYPES: BEGIN OF TY_SPFLI,
CARRID TYPE SPFLI-CARRID,


[ Full reading ]

Comments: 0

Creating user defined types and structures in ABAP

Sat Apr 28, 2012 8:55 pm by Uma_ABAP

*&---------------------------------------------------------------------*
*& Report ZCH_USER_DEFINED_TYPES
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT ZCH_USER_DEFINED_TYPES.

TYPES: TXT TYPE STRING. " Creating user defined type using standard …

[ Full reading ]

Comments: 0

Creating Dynamic Internal Table and Dynamic Field catalog in SAP-ABAP

Fri Apr 27, 2012 11:00 am by Admin

*&---------------------------------------------------------------------*
*& Report Z_SUKS_DYNAMIC_ITAB
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT Z_SUKS_DYNAMIC_ITAB.

DATA: TY_DTRF TYPE REF TO DATA,
ALVF_CAT TYPE TABLE OF LVC_S_FCAT,


[ Full reading ]

Comments: 0

Calculate/find number of working days between two dates in SAP

Tue Apr 24, 2012 2:06 pm by Uma_ABAP

REPORT ZFIND_WORKING_DAYS.

SELECTION-SCREEN: BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
PARAMETERS: P_INDAT TYPE SY-DATUM,
P_OUTDAT TYPE SY-DATUM.
SELECTION-SCREEN: END OF BLOCK B1.

DATA: BEGIN OF ETH_DATS OCCURS 0.
INCLUDE STRUCTURE RKE_DAT.
DATA: END OF ETH_DATS .


DATA: V_LINES TYPE I.

IF P_INDAT LE P_OUTDAT.

CALL FUNCTION …

[ Full reading ]

Comments: 0

Introduction to Basic ABAP Program

Tue Apr 10, 2012 8:00 pm by Admin

REPORT ZBASIC_ABAP_PROGRAM.

DATA: msg(20) TYPE C.

msg = 'Welcome to SAP-ABAP Programming'.

WRITE: / msg.

Comments: 0

Inner join example in SAP-ABAP

Wed Mar 14, 2012 1:05 am by Admin

Code:
*&---------------------------------------------------------------------*
*& Report  ZSU_INNERJOIN_FOR3
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  ZSU_INNERJOIN_FOR3.

tables :mara,marc,mard.
types  :begin of t_mar,
        matnr type matnr,
  …


[ Full reading ]

Comments: 0

EVENTS IN ALV

Wed Mar 07, 2012 4:58 pm by govind

EVENTS in ALV:-
SAP has given standard events that can be used on reports. When you use display function modules like ‘REUSE_ALV_GRID_DISPLAY’ in that we have some parameters to handle events listed below.
I_CALLBACK_PF_STATUS_SET
I_CALLBACK_USER_COMMAND
I_CALLBACK_TOP_OF_PAGE
I_CALLBACK_HTML_TOP_OF_PAGE
I_CALLBACK_HTML_END_OF_LIST

If you want to use standard 17 events given by SAP then use …

[ Full reading ]

Comments: 0

ALV-REPORTS

Wed Mar 07, 2012 3:28 pm by govind

ALV( ABAP List Viewer )
We use Function module to display ALV’s. While there are three different types of ALV’s possible.
1. Simple Display :-
REUSE_ALV_GRID_DISPLAY
2. Hierarchal Display
REUSE_ALV_HIERSEQ_LIST_DISPLAY
3. Block Display
REUSE_ALV_BLOCK_LIST_INIT
REUSE_ALV_BLOCK_LIST_APPEND
REUSE_ALV_BLOCK_LIST_DISPLAY
You can use fieldcatlog in three different ways.
Automatically -
Use …

[ Full reading ]

Comments: 0

Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics