on 09-10-2013 6:08 AM
Dear experts.
Could you please help in understanding, where the "elements" tab page and "ATP TAb page" data are stored?
what iam doing is to build a customized report to see if any inconsistency between these 2 tab pages.
regards
Hi Rorie,
Please explore the BAPi BAPI_PPDSSRVAPS_GET_IO_NODES and BAPI_PBSRVAPS_GETDETAI
Regards,
R.Brahmankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rorie,
The data in the Elements / ATP tab is never stored in any of the DB tables. It is available in Live cache. But, if you need specific information related to some of the orders and its parameters you will get that info from the DB tables. I had written a blog long back about the list of DB tables in gATP. May be it will help you for a different purpose. But, for the time being please evaluate the BAPIs provided by Rupesh in the above reply.
Babu Kilari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rupesh / Babu,
thanks for your inputs and its very helpful.
while doing some digging today, found that there are a few thousand entries in /SAPAPO/MM_SCHED Table. And similar entries are found in the POSMAPN table, but not in /SAPAPO/MM_DOC nor MMFIELD.
Should there be entries in /SAPAPO/MM_SCHED? normally SDORDER_DEL should clear all these entries isnt it? or how do we delete the entries in /SAPAPO/MM_SCHED?
Regards,
Rorie
Hi Rorie,
The entries of the tables /sapapo/mm_doc, sapapo/mmfield and /sapapo/mm_sched are checked with the option 'Reconcile Available-to-Promise (ATP) tables with /SAPAPO/POSMAPN' of the /sapapo/sdorder_del report. This deletes entries which do not have a relevant entry from the /SAPAPO/POSMAPN table.
Execute the report /SAPAPO/SHOW_MM_DOC_MM_SCHED and /SAPAPO/SDORDER_DEL.
You have also selecte the checkbox "Delete obsolete records in the /SAPAPO/POSMAPN table" on the "Delete on Database" tab page in the "Additional Functions" segment.
Regards,
R.Brahmankar
Hi Rupesh,
we do run SDORDER_DEL on a weekly basis with 3 variants, which is the pab "delete on Database"
1st one - Only checked the "delete Obsolete records in /sapapo/posmapn table. No Wild card in Product / location
2nd one - Only checked the " Adjust ATP Tables with /sapapo/posmapn. No wild card for product / location.
3rd one - with Wild card in Product and location and last change before = current data - 90 days.
I checked the report - /SAPAPO/SHOW_MM_DOC_MM_SCHED - this is only display and i can see entries in all 3 tables.( POSMAPN / MM_DOC, MM_SCHED)
Question is the obsolte records are not supposed to be these tables right?
Regards,
Rorie
Hi Rorie,
I guess, even after deletion the entry still exists in //POSMPAN table. However, once the deletion reports are run the entry disappears. The reason why the entry still exits in //POSMAPN and other tables is due to the fact the the delivery can always be reversed / deleted and the STO turns to be an open document again. That's how SAP has designed it.
Also, as per my experience the amount of information that we get it in these DB tables for STO is lesser compared to that of an SO.
Babu Kilari
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.