ALV format display

[Former Member]

HI ALl,

I have a requirement to change the below list layout format to ALV format. Kindly let me know how i can do the same. Also i am more comfortable using FM for ALV than classes.

LAYOUT: (the Production order etc section is dynamic and can have 4-5 rows to display).

-

---

	Date 30.11.2007
INVENTORY QUALITY	Time 05:58:05
	Page 73

-

---

-

---

MATERIAL

PLAN

DESCRIPTION

CURRENT STOCK

STOCK VALUE

WEEK -1

WEEK 48

WEEK 49

WEEK 50

WEEK 51

WEEK 52

WEEK 01

END PERIOD VALUE

-

---

2009738

0301

NP522334-RG1/2CU '575

200 PCE

1,894 EUR

-

---

Production order	2,588
Planned order	2,100			2,100			2,100
Available stock	4,488-	4,488-	4,488-	6,588-	6,588-	6,588-	8,688-	0 EUR

-

---

2009752

0301

NP078914-RG1/2CU '33114

0 PCE

0 EUR

-

---

Planned order	700		700				700
Available stock	700-	700-	1,400-	1,400-	1,400-	1,400-	2,100-	0 EUR

-

---

2009755

0301

NP149573-RG1/2CU '33114

0 PCE

0 EUR

-

---

Planned order	700		700				700
Available stock	700-	700-	1,400-	1,400-	1,400-	1,400-	2,100-	0 EUR

-

---

-

---

TOTAL CURRENT STOCK AND STOCK VALUE

38,774 PCE

118,731 EUR

-

---

TOTAL REQUIREMENTS	3,561,529	262,651	516,859	415,860	664,526	2	498,847
TOTAL AVAILABLE STOCK	2,296	2,296	2,296	2,296	2,296	2,296	2,296	3,296 EUR

-

---

Thanks and regards

shilpa

[former_member386202 · Accepted solution]

Hi,

I think u have to use hierchical alv just refer these standard reports

BCALV_TEST_HIERSEQ_LIST Program BCALV_TEST_HIERSEQ_LIST

BCALV_TEST_HIERSEQ_LIST_EVENTS Program BCALV_TEST_HIERSEQ_LIST_EVENTS

BCALV_TREE_01 ALV tree control: build up the hierarchy tree

BCALV_TREE_DND ALV tree control: Drag & Drop within a hierarchy

BCALV_TREE_DND_MULTIPLE ALV tree control: Drag & Drop within a hierarchy

Regards,

Prashant

[Former Member]

Define a fieldcat with required fields.

and use It_sort parameter.

<u>for your reference check the sample code.</u>

g_counter = g_counter + 1.

wa_fieldcat-col_pos = g_counter.

wa_fieldcat-fieldname = 'Field name'.

wa_fieldcat-tabname = 'IT_alv'.

wa_fieldcat-seltext_l = 'Text'.

APPEND wa_fieldcat TO it_fieldcat.

CLEAR wa_fieldcat.

CLEAR wa_sort.

wa_sort-fieldname = 'Field name'.

wa_sort-up = 'X'.

wa_sort-group = 'UL'.

APPEND wa_sort TO it_sort.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

i_callback_program = sy-repid

is_layout = it_layout

it_fieldcat = it_fieldcat

it_sort = it_sort

i_save = 'A'

it_events = events

it_event_exit = lt_event_exit

TABLES

t_outtab = it_alv

EXCEPTIONS

program_error = 1

OTHERS = 2.

Reward if hellpful.