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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded