client wants one report to know which documents are credit management and which are avil check

[Former Member]

Dear sd Experts First of all thank you so much in Advance

   Dear i have one requirement From client side  , we have different type of documents , but my client is asking only which documents are maintained with credit management and which documents are maintained with availability checks

ex we have some documents

11.... no credit management,, avial check

12----- no credit management

13......credit management,,,, avial check

14  ------no credit management

15------- credit managment 

     he wants one report to know which documents are credit management and which are avil check

plz let me know , if you feel this is generic question plz forgive me , but i need your help

[moazzam_ali · Accepted solution]

Dear

For credit management status please use Field CMGST in VBUK table. In this field system saves credit management status data. If credit management is not performed there will be nothing in this field e.g. CMGST = Space. For availability check you can use field VERFP in VBEP table. If there is availability check then there will be x in this field and if there is no availability check then there will be nothing e.g VERFP = Space.

You can create report with SQVI or SQ01, SQ02 and SQ03. IF you don't know Query report you can create ABAP report too by using these two fields.

Thanks

[Former Member · Accepted solution]

Dear MoazzaM , my heartful thanks to you