Skip to Content
author's profile photo Former Member
Former Member

LSMW FOR IT0045

Dear Experts,

I have recorded the LSMW for IT0045 - Loan, but when I am uploading successfully the LSMW, but I am checking manually in IT0045 through PA30 not showing updated “payments” screen & showing blank.

I have recorded with the help of Tab key & all recording is working correct from start to end.

If anywhere I am doing mistake, please correct me.

Thanks in advance.

Regards,

Santosh Shivane

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2012 at 05:11 AM

    Hi,

    to update the IT0045 its better to go for a BDC. through LSMW, it will not update properly. the IT0078 will be updated automatically when you update IT0045 and nowadays it is not in use.

    John

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 30, 2012 at 12:21 PM

    Hi Santosh,

    Yes LSMW will not pick the payment tab.so you have to record the payment via the infotype 0078"loan payment"

    so basicaly you have to create for two recordings in PA30.

    Thanks,

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      You mentioned that you have recorded for IT0045 and "basic data" and "Condition" tabs are updated but only "payment" tab not updated.

      for this , you have to create another recoding for IT0078-Loan Payment

      Run LSMW for IT0045 first and IT0078 later.

      If you recording working fine for IT0045 then the same steps you have to follow to create IT0078.

      Thz,

      Dinesh

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2012 at 07:00 AM

    Dear Santosh,

    As you know infotype 0045 consists of 3 tabs, the first two tabs belongs to IT0045 but the third one belongs to IT0078, thus you should do the following:

    First: upload the first two tabs using a recording for IT0045. The fields used in this recording are (and you can add to them if required.

    PERNR Personnel Number

    CHOIC Infotype (0045)

    SUBTY Subtype

    BEGDA Start date

    ENDDA End date

    OBJPS Object ID

    EXTDL External Reference Number

    DATBW Approval date

    DARBT Loan amount granted

    DBTCU Currency key

    DKOND Loan conditions

    TILBG Repayment start

    TILBT Repaymenet installment

    TILCU Currency key

    Second: Then you can use a query to export data to an excel sheet with the loan types and the corresponding object IDs as they are automatically generated in order to correctly upload loan payments for each loan type. Example.

    Personnel Number 1 has 3 Loans of type 9000, when performing step 1 the object ID is automatically generated so records uploaded would be.

    Loan type Obj. ID Amount

    9000 01 1,000

    9000 02 2,000

    9000 03 3,000

    You then export a report on an excel sheet that includes this information in order to get the automatically generated Obj. ID, and then create the corresponding sheet for the third tab using IT0078.

    Note: You can skip this step if all employees in the upload sheet has one record only for a certain loan type. as the object ID then will be 01 for all.

    Third: upload the third tab using a recording for IT0078. The fields used in this recording are (and you can add to them if required.

    PERNR Personnel Number

    CHOIC Infotype

    SUBTY Subtype

    DLART Loan type

    OBJID Object ID

    BEGDA Start date

    BETRG Amount

    BTRCU Currency key

    Note: Object ID is required to together with the loan type form a unique key so you won't upload data for an incorrect loan using IT0078 if the employee has more than one record of the same infotype.

    Hope that helps.

    Thanks and regards,

    Sally

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      As I already clarified, I am doing so to get the object ID in case an employee has multiple records of the same loan type at the same time, as I need to fill the last tab with Loan payment external/payroll record but normally I won't be able to do so unless I get the object IDs for loans from the system.

      So such information needed would be personnel number/loan type/object ID/ start and end date of loan.

      and thus when uploading IT0078, you'd be able to correctly assign each loan payment to the corresponding loan type.

      Regarding the query itself, you can use a standard HR infoset to make a query through tcode SQ01 and SQ02.

      If you needed any help please feel free to contact.

      Thanks and regards,

      Sally Ahmed Amin

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.