topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Thu, 30 Nov 2006 05:09:54 GMT

Hi all,

i got a code like this

select EKKO_{EBELN EKKO}BUKRS EKKO~BSTYP "n603595

EKKO_{LIFNR EKKO}EKORG EKKO~EKGRP "n603595

EKPO_{EBELP EKPO}MATNR EKPO~MENGE "n603595

EKPO_{MEINS EKPO}BPRME EKPO~NETPR "n603595

EKPO_{PEINH EKPO}WEBRE EKPO~WEPOS "n603595

EKPO_{REPOS EKKO}WAERS EKPO~WEUNB "n603595

EKPO_{ELIKZ ekpo}retpo "n603595

Item category PO and flag for service-based IV "n725824

ekpo_{pstyp ekpo}lebre "n725824

ekpo~ktmng "n603595

into corresponding fields of table ibs "n603595

from ekko inner join ekpo "n603595

on ekko_{mandt = ekpo}mandt "n603595

and ekko_{ebeln = ekpo}ebeln "n603595

"n603595

WHERE ekko~lifnr IN lifnr "n603595

AND ekko~ekorg IN ekorg "n603595

AND ekko~ekgrp IN ekgrp "n603595

AND ekpo~matnr IN matnr "n603595

AND ekpo~ebeln IN ebeln "n603595

AND ekpo~ebelp IN ebelp . "n603595

SORT ibs BY ebeln ebelp lifnr.

Eliminate entries without authority for the purchase organization

LOOP AT ibs.

IF NOT cl_mmim_auth=>check( i_object = 'M_BEST_EKO'

I_VALUE1 = IBS-EKORG ) IS INITIAL.

DELETE ibs.

ENDIF.

ENDLOOP.

I want to know what does

LOOP AT ibs.

IF NOT cl_mmim_auth=>check( i_object = 'M_BEST_EKO'

I_VALUE1 = IBS-EKORG ) IS INITIAL.

DELETE ibs.

ENDIF.

ENDLOOP.

do.............

Re: reports

Former Member — Thu, 30 Nov 2006 05:13:14 GMT

Alex

That method is check if the user has authorization to view the data of a specific Purchasing organization. If NOT that row is being deleted from the internal table.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: reports

Former Member — Thu, 30 Nov 2006 05:13:50 GMT

Hi Alex

This is to exclude entries for which the user doesnt have authorization for Purchase Organization in Purchase Order.

<b>M_BEST_EKO Purchasing Organization in Purchase Order</b>

Kind Regards

Eswar

Re: reports

Former Member — Thu, 30 Nov 2006 05:15:40 GMT

hi ,

Class cl_mmim_auth having static variables i_object I_VALUE1 . it is checking the value of these varibales if not delting the Tuple fron IBs.

For more details while debugging double click on class to view its contents

*Please mark use full Answers

Re: reports

Former Member — Thu, 30 Nov 2006 05:17:54 GMT

hi alex,

This block of code checks whether the user has authorization to view the data or not...

just go through this for more info on authorization...

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/authorit.htm

regards,

~Sri.

Re: reports

Former Member — Thu, 30 Nov 2006 05:22:51 GMT

Check the Authorization Object, check the user's purchase org is permited.