Wednesday, July 23, 2014

How to get Cancel invoice from VBRK table.

TO get the cancelled invoice the query will be like below:

if FKSTO EQ 'X'
and VBTYP EQ 'N' OR FKART EQ 'S1'.


AND SFAKN is for getting cancelled invoice number.

at 8 comments:
Subscribe to: Posts (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...