Skip to Content
Aug 23, 2007 at 07:08 AM

Extract Month From Date Using SAP Query.


Hi Abap expert,

i'm using SAP query SQ01 to run the report from MKPF table, this table does not contain any monthly period. the available field that can i use is BUDAT.

how do i extract the month from date using SAP query report? example;

Date - 01.01.2007 (DD.MM.YYYY) extract to 01.2007 (MM.YYYY)

i think we can use 'local field' and just put the coding but i don't know how to use, please help ?