Fetching single record from database


Steps.


  1. Go to transaction code SE38.
  2. Enter the program name Z or Y<program name>
  3. Select attribute type as Executable program.
  4. Click on Save.

Source Code

DATA : WA_MAKT TYPE MAKT.

PARAMETERS : P_MATNR TYPE MAKT-MATNR.

SELECT SINGLE * FROM MAKT INTO WA_MAKT WHERE MATNR = P_MATNR.


WRITE : / WA_MAKT-MATNR ,WA_MAKT-SPRAS , WA_MAKT-MAKTX, WA_MAKT-MAKTX.




Input

Output

Comments

Post a Comment

Popular posts from this blog

Image
SAP MM Tables Link and Flow MM flow is processing  between business organisation and Vendor: 1...Purchase Requisition --- T.code ---ME51 2...Source List -----T.code-----ME41 3...Request for Quation (RFQ)---T.code--ME21N  (To Vendor) 4...Purchase Order  ---- T.code ----ME21N (To Vendor) 5...Goods Receipt-------T.code....MIGO       (Tables:  MKPF, MSEG) 6...Invoice Verification----T.code...MIRO       (Tables: BKPF , BSEG) 7...Vendor Payment----T.code...FB60 (FI - Account Payable)
Read more

RADIO-BUTTONS IN BASIC REPORT

Image
*&---------------------------------------------------------------------* *& Report  ZSAPRADIO *& *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT   ZSAPRADIO. TYPES:  BEGIN  OF  TY_VBAK,         VBELN  TYPE  VBAK-VBELN,         ERDAT  TYPE  VBAK-ERDAT,         VKORG  TYPE  VBAK-VKORG,        END  OF  TY_VBAK. TYPES:  BEGIN  OF  TY_VBAP,         VBELN  TYPE  VBAP-VBELN,         POSNR  TYPE  VBAP-POSNR,         MATNR  TYPE  VBAP-MATNR, ...
Read more

ALV-LIGHT_SET

Image
REPORT  ZLIGHT_SET. TYPE-POOLS: SLIS. TYPES: BEGIN OF TY_VBAK,         VBELN TYPE VBAK-VBELN,         ERNAM TYPE VBAK-ERNAM,         NETWR TYPE VBAK-NETWR,         LIGHTS TYPE  C,       END OF TY_VBAK.  DATA: IT_VBAK TYPE  TABLE OF TY_VBAK,        WA_VBAK TYPE TY_VBAK. DATA: WA_LAYOUT TYPE  SLIS_LAYOUT_ALV ,        IT_FCAT   TYPE  SLIS_T_FIELDCAT_ALV ,         WA_FCAT LIKE LINE OF IT_FCAT.  SELECT-OPTIONS : S_VBELN FOR WA_VBAK-VBELN. START-OF-SELECTION.    SELECT VBELN ERNAM NETWR FROM VBAK           INTO TABLE IT_VBAK UP TO 10 ROWS. LOOP AT  IT_VBAK INTO WA_VBAK. IF  WA_VBAK-ERNAM = 'BOLLINGER'.    WA_VBAK-LIGHTS = 1. MODIFY IT_VBAK FROM WA_VBAK TRANSPORTING LIGHTS.    ELSEIF  WA_VBAK-E...
Read more