Posted: Sat Oct 13, 2007 1:06 pm Post subject: Retrieve wage type cost assignment for infotype records
Shows how to retrieve wage type cost assignment for infotype records (i.e. 14 & 15).
Individual cost assignments can be made for wage types within infotypes such as 0014 and 0015.
However this data is not stored in the underlying infotype database tables or is not retrieved using
standard infotype retrieval techniques. The data is in-fact stored on tables 'ASSHR' and 'ASSOB_H',
which can be retrieved using code similar to the following. Please note the actual coding may change
depending on which infotype you are using and what data is required.
Code:
* Code used for retrieving cost assignment for infotype 0014 records
* ------------------------------------------------------------------
* Loop at infotype 0014 records
PROVIDE * FROM p0014 BETWEEN pn-begda AND pn-endda.
* Select all the PDC cost assignment records for each wage-type
SELECT * FROM asshr WHERE pernr = pernr-pernr
AND infty = '0014'
AND subty = p0014-lgart
AND begda = p0014-begda
AND endda = p0014-endda.
* Retrieve Cost Centre and WBS details
SELECT SINGLE * FROM assob_hr WHERE pdsnr = asshr-pdsnr.
* Store retrieved data into declared variables/itables
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
All product names are trademarks of their respective companies. SAPNET.RU websites are in no way affiliated with SAP AG. SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver and any other are registered trademarks of SAP AG. Every effort is made to ensure content integrity. Use information on this site at your own risk.