Abap basic list .

Former Member — Mon, 08 Oct 2007 06:11:38 GMT

My requirement is as below .

For every new sales org /Distribution Channel /Division Combination of these three . I have to display the basic list .Can some one guide me on this .

Required output

Sales Area: <KONA-VKORG>/ <KONA-VTWEG>/ <KONA-SPART>

Document no date Validity date

--- --- -

Thanks in advance

-padma

Re: Abap basic list .

Former Member — Mon, 08 Oct 2007 08:54:34 GMT

Hi Padma,

Select the data into an internal table.

Sort the table by vkorg vtweg spart.

delete adjacent duplicates

at new spart.

write statements (display the list)

endat.

Regards,

Aarti

Re: Abap basic list .

hymavathi_oruganti — Mon, 08 Oct 2007 08:58:34 GMT

u go into abap editor se38,

write

parameters: and press f1, u will come to know syntax and all.

next press f1 on select statement and u will come to know about that.

like this. u can use f1 as a greatest help.

u try coding ur self then u can learn.

Re: Abap basic list .

Former Member — Mon, 08 Oct 2007 09:03:26 GMT

go through this report

&----

TABLES DECLARATION

&----

type-pools: slis.

data: it_fieldcat type slis_t_fieldcat_alv,

wa_fieldcat like line of it_fieldcat.

tables:vbak, "Sales Document Header Details

vbap, "Sales Document Item Details

kna1. "Customer Master Details

&----

INTERNAL TABLES DECLARATION

&----

data:begin of it_vbak occurs 0,

vbeln like vbak-vbeln, "Sales Document

erdat like vbak-erdat, "Date on which the record was created

erzet like vbak-erzet, "Entry time

ernam like vbak-ernam, "Name of Person who Created the Object

auart like vbak-auart, "Sales Document Type

end of it_vbak.

data: begin of it_vbap occurs 0,

vbeln like vbap-vbeln,

posnr like vbap-posnr,

matnr like vbap-matnr,

matwa like vbap-matwa,

matkl like vbap-matkl,

arktx like vbap-arktx,

end of it_vbap.

data:begin of it_finaltable occurs 0,

vbeln like vbak-vbeln, "Sales Document

erdat like vbak-erdat, "Date on which the record was created

erzet like vbak-erzet, "Entry time

ernam like vbak-ernam, "Name of Person who Created the Object

auart like vbak-auart,

posnr like vbap-posnr,

matnr like vbap-matnr,

matwa like vbap-matwa,

matkl like vbap-matkl,

arktx like vbap-arktx,

end of it_finaltable.

&----

SELECTION-SCREEN

&----

selection-screen begin of block b1.

select-options:s_vbeln for vbak-vbeln.

selection-screen end of block b1.

selection-screen begin of block b2.

select-options:s_erdat for vbak-erdat.

selection-screen end of block b2.

selection-screen begin of block b3.

select-options:s_erzet for vbak-erzet,

s_ernam for vbak-ernam,

s_auart for vbak-auart.

selection-screen end of block b3.

&----

START-OF-SELECTION

&----

start-of-selection.

perform get_vbak.

perform alv_datas.

perform alv_displays.

&----

END-OF-SELECTION

&----

end-of-selection.

form alv_datas .

wa_fieldcat-fieldname = 'VBELN'.

wa_fieldcat-seltext_l = 'SALES DOCUMENT NUMBER'.