BDC

[Former Member]

Hi all,

I am having requirement in HR module to read all employees from infotype1 and get appraisals for each employee. After getting all appraisals we need to update those records in the another infotype2 comparing the existing records in the infotype2.

This new program should be the automated daily batch job to update the infotype2.

Please provid me solution on this..

Thanks

[Former Member]

Hi,

Write a BDC Programwith below Logic and Schedule it in Background.

First, Get the Employees and their Appraisals from Infotype 1 into a Internal Table ITAB1.

Second, Get the Existing data of Employees and Appraisals from infotype 2 into another internal Table ITAB2.

Compare the ITAB1 records with that of ITAB2 and delete the existing records.

so ITAB1 will now have the new records only, which will be updated using BDC.

Now call the transaction of the HR where the new Appraisals are to be added.

Regards,

Anji

[Former Member]

Thanks for your reply and valuable information..

I am getting difficulty while recording the transaction.

Actually while recording the transaction i am facing the problem. I am having two fields on that transaction which are output only.

The possible solution for this is

i need to remove the output only option for that field while recording the transaction

after that we need to make the field again as output only

do we have any function module to accomplish this task?

Thanks in advance

vinay

[amit_khare]

Hi,

to read output only fields just goto PA30 and go into the infotype and check the name there and pass it to your BDC, but remember you cannot pass a value to them from BDC when they are output only But can read them.

Regards,

Amit

Reward all helpful replies.

[Former Member]

Yes, actually those fields are output only fileds. But we need to populate the date to store it in the infotype.

when i record thru SHDB i will take out the output only option for those fields. After completing the recording i will make it again output only fields, because client want those fields to be output only always. (user shouldn't able to enter those fields)

When i develop a BDC program i need to modify the already created program by using the function module to enable and disable the output only option for those fields.

In this case i need the function module which does the same thing..

I think there should be some function module which satify the above criteria.

It would be great, somebody provides the FM name..

thanks

Vinay

[amit_khare]

Hi,

I dont think it is possible, as we transfer the control from our program once we do call transaction and the BDC table is the standrd table to fetch record.

But if still you get one than its a good one.

I may advice you an alternative solution to put an authority check in the module pool for that infotype which as per the check makes the field input or output only.

Regards,

Amit