SAP Transactions inquiry in MM and FICO modules

[aaj-sap]

good day sap experts

I'm checking Vendor's status ( active or blocked ) and other details regularly through SAP Transaction ( MK03 - Display vendor (Purchasing) ,

2- and transaction ( ME23N - Display Purchase Order ) to check PO's details for each vendor individually ( such as balance remaining and expiry date ) ,

3- and Transaction ( ML81N - Service Entry Sheet ) to check whether there has been GR / IR issued for SES or not and their details ( also individually )
4- and transaction ( ME53N - Display Purchase Requisition ) look up PR status changes by PR numbers individually
such as (PR released / PO created / PO released )

I would like to inquire if there's SAP transactions that enables me to look up in batches through copy-paste from excel and also to generate an excel reports that would help me in the sorting and save time ?

Best regards

[BijayKumarBarik]

Vendor blocked report you can get it with t.code MKVZ but vendor active or inactive- you need to have your business concept with your design. Decide which vendor is inactive with a concept for example those have latest transactions till last 2years from today date else all are active. You can design your own concept with newly design t.code where no transactions such as no PO creation and no invoice creation along with no payment done for last two years for vendors/suppliers for inactive!

[aaj-sap]

thank you kumar , by the way i’m not IT , can I customize this as a normal user ? I have experience with ad hoc reports in HR module , is there such a reporting t-code in mm module that would serve my purposes ??

[aaj-sap]

thank you sir , transaction MKVZ is great it reportsall types of blocking ,

[sanilbhandari]

Hi

Please check if ME80FN helps in your requirement

Thanks & regards

Sanil

[aaj-sap]

thank you sanil , i’ll check it out and feedback you soon , regards