Alv Report with AUSP TABLE fields.

[akshayd1998]

Hello Developers,

Actualy i need to create an Alv report where i have some fields from AUSP table like OBJEK PLANT. USERID, DOCTYPE.I have to pass OBJEK in ausp-objek and PR_PLANT in AUSP-ATINN and add all the corresponding ATWRT in PLANT field Of alv, similarly for rest two fields i.e. pass pr_userid and pr_doctype in atinn and get atwrt and pass it in userid and doctype field of alv. I want output like this👇.

The problem is that when i loop it_ausp into wa and read value based on atinn i am always getting same atwrt value and while using loop inside loop i am getting blank value in rest two field while apppending.

Please help.

[Yasin]

Hi Akshay

ATINN field has a converted value, make sure while you are reading the table you are reading via

the converted value. if you will pass the actual value you may get blank...

Value: ZCO_RELEASE
Converted Value: 0000000813

make sure also that you are including the left zeros don't ignore them in your SQL query otherwise the result may get impacted.

Regards

[akshayd1998]

Hi, Thankyou so much for responding.

I am converting the atinn field no problem with that.

Only issue is i am not able to properly append atwrt field in corresponding alv fields ie plant ,userid ,doctype by passing objek and (pr_plant or pr_userid or pr_doc in atinn field).

I will be really grateful to you if u help me to solve this.

[Yasin]

can you share the code ? at least your loop.

also you need to debug it_ausp see all values is it loaded correctly

you can use :

LOOP AT it_ausp1.
LOOP AT it_ausp2 WHERE ATINN = it_ausp1-ATINN