Skip to Content

How we can read SNP result logs using ABAP tables or function modules?

Hi

How we can read SNP result logs using ABAP tables or function modules? I want to read the Result logs of SNP Optimizer-IT_ARCMAT for reporting purpose like wise remaining logs had to be read.Suggest me the best way to read the SNP Logs data & write a report.

Thanks

Poorna

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Apr 08, 2014 at 06:21 PM

    Hi Poorna,

    Find the list of important tables used in optimizer log.

    Start with the table /sapapo/snpopkey to get the session is which is unique to every optimizer run and use that to get the respective data from the below list

    Table name Use /sapapo/snpopkey Fetch Optimizer Run GUI Id from Optimizer run name INPUT LOG /SAPAPO/SNPOPSE2 Location Products /SAPAPO/SNPOPBCT SNP Optimizer: Bucket Definitions (ET_BUCKDF) /SAPAPO/SNPOPLMA SNP Optimizer: Location Products (ET_LOCMAT) /SAPAPO/SNPOPRRE SNP Optimizer: Elementary Production Resources (ET_RESOURCE) /SAPAPO/SNPOPIAR SNP Opt.: Transportatn Lane Means of Transp.= "Arc" (ET_ARC) /SAPAPO/SNPOPIAM SNP Optimizer: Material Flow on Arcs (ET_ARCMAT) /SAPAPO/SNPOPPMA SNP Optimizer: PPM Products (ET_PROMAT) /SAPAPO/SNPOPPMO SNP Optimizer: PPM Attributes (ET_PROMO) /SAPAPO/SNPOPPRE SNP Optimizer: PPM Resource Consumption (ET_PRORES) /SAPAPO/SNPOPLPR SNP Opt.: Safety Stock, Fixed Demands, Receipts (ET_LOCPROD) OUTPUT LOG /SAPAPO/SNPOPMLO SNP Optimizer: Output Table for Location Product /SAPAPO/SNPOPAMA SNP Optimizer: Output Table for Product-Dependent Transport /SAPAPO/SNPOPPRO SNP Optimizer: Output Table for Production /SAPAPO/SNPOPPRC SNP Optimizer: Output Table for External Procurement /SAPAPO/SNPOPDEM,/SAPAPO/SNPOPDMN SNP Optimizer: Output Table for Fulfilled Demand /SAPAPO/SNPOPNDI,/SAPAPO/SNPOPNDE SNP Optimizer: Output Table for Not Delivering

    Cheers

    Ajay

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 02, 2014 at 01:02 PM

    To see which tables are saved for the SNP-optimizer output log you can
    check the include /SAPAPO/LMSDP_SNPOPTFD4. Most tables are directly
    saved with INSERT /SAPAPO/SNPOP*, so you can search the coding with
    "SAPAPO/SNPOP" to know this tables.

    Some tables are saved using the routine "write_out_table_to_db", in
    which the table name is concatenated with /SAPAPO/ and the parameter
    &2 when the routine is called, e.g. statement:

    "write_out_table_to_db lt_opama snpoparm."

    It means that it is saved to /SAPAPO/SNPOPARM. So you have to search the
    coding for "write_out_table_to_db" to know this tables.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.