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

[former_member379943]

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

[ajayprakash]

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

[former_member616050]

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.