SAP ABAP: ALV Interactive Report Need Help!

Dear All ABAPERS,

Note: I am a beginner,

I am making an Interactive ALV report and I need your help to understand and complete it.

Required Fields:

Data from KNA1:

Kunnr – Customer Number

LAND1 – Country Key

NAME1 – Name1

ORT01 – City

Data from VBAK:

VBELN – Sales Document

ERDAT – Date

ERZET – Entry Time

ERNAM – Name

KUNNR – Sold to Party

I have to develop a report where if the user clicks on the Customer Number it must show the sales order of that customer.

I want to develop this report with Inline declaration method and I have done this far please help me to complete it.

TYPE-POOLS: SLIS.
TYPES: t_fieldcat type slis_fieldcat_alv.
DATA: i_fieldcat type table of t_fieldcat,
w_fieldcat type t_fieldcat.

PARAMETERS: P_CUST type KUNNR OBLIGATORY,
P_SD type VBELN.
IF P_CUST is not initial.
Select KUNNR, LAND1, NAME1, ORT01 from KNA1 into table @(IT_KNA1) where KUNNR eq @P_CUST.
IF P_SD is not initial.
SELECT VBELN, ERDAT, ERZET, ERNAM, KUNNR from VBAK into table u/data(IT_VBAK) where P_SD eq @P_CUST. **this line might be incorrect
ENDIF.
ENDIF.

Thanks in Advance, Please help!

submitted by /u/iamOkazaki
[link] [comments]


Go to Source of this post
Author Of this post: /u/iamOkazaki
Title Of post: SAP ABAP: ALV Interactive Report Need Help!
Author Link: {authorlink}