Sunday, February 13, 2011

SQL Example COUNT , Select single and sql function(ABAP Programming)


SQL Example COUNT , Select single and sql function(ABAP Programming) 

*** counting the database rows

REPORT  ZCount_Test.
parameters: p1 LIKE VBAP-VBELN.
write:/ p1.
Tables VBAP.
SELECT COUNT(*)
FROM VBAP INTO total
WHERE VBELN <= p1 AND POSNR = '30'.
write:/ total.

*** selecting single Rows using sql function

REPORT  ZSelect_single-Test.
parameters: p1 LIKE VBAP-VBELN.
write:/ p1.
parameters: p1 LIKE VBAP-VBELN.
write:/ p1.
tables VBAP.
select single * from VBAP
where VBELN IN (p1).
write: / VBAP-VBELN,VBAP-POSNR,VBAP-MATNR,VBAP-MATWA, VBAP-ARKTX .
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Drop Down lists in the selection parameters

PROGRAM ztest.   TYPE-POOLS : vrm.   DATA : name TYPE vrm_id,        list TYPE vrm_values,        value LIKE LINE OF list. ...

  • EXIT, STOP, CONTINUE, RETURN and LEAVE PROGRAM
    EXIT:   The EXIT command will stop the LOOP passings, exit from the SUBROUTINES..etc. The behavior of EXIT keyword is depends on where yo...
  • GS1-128 barcode create/convert
    For GS1-128 barcode converter-- 1. need to create barcode label using t-code se73 . click on system barcode and create new barcode labe...
  • How to Color row in ALV report
    REPORT   ZROWCOLOR . TABLES :      vbak . TYPE-pools :  slis .                                  "ALV Declarations TYPES :  BEG...