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

DATA Uploads.. please help..

Hello Gurus!

We have to upload data to infotypes of PA, PY, TM and Ben. Can anyone suggest a strategy as to wht infotypes to upload thru Pa40 Action: Initial Data upload. And the infotypes to be updated through pa30? What are the key factors that guide for uploads?

Thanks in advance..

Point rewarded to helpful answers..

Soniya singh.....

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 05, 2008 at 07:18 AM

    Hi Soniya,

    U can use LSMW to upload the employee master and other information. For this you have to change the Number range to external using T Code PA04.Reply if u dnt know about the LSMW...Also u can hire employees through PA30 using LSMW

    Regards,

    Sushil

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 05, 2008 at 07:23 AM

    if u wnat to upload the data if can be done by LSMW or BDC so pls check the below thread

    http://www.scmexpertonline.com/downloads/SCM_LSMW_StepsOnWeb.doc

    let me know if there is anything else

    thanks

    sikindar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 05, 2008 at 01:41 PM

    i will recommend PA30 for actions..Go for LSMW.Wish you happy uploading.

    1. T-Code: LSMW.

    2. ENTER PROJECT NAME

    Sub project name

    Object name.

    Execute.

    3. MAINTAIN OBJECT ATTRIBUTES.

    Execute

    Select Batch Input recording

    go to->recording overview

    create

    Recording name.

    Enter transaction code.

    Start recording

    do recording as per your Requirement.

    Save à Back.

    Enter recording name in LSMW screen.

    Save à Back

    Now there will be 14 steps.

    2. MAINTAIN SOURCE STRUCTURES.

    Enter the name of internal table.

    Display change

    Create

    Save à Back

    3. MAINTAIN SOURCE FIELDS.

    Display change

    Select structure

    Source_fieldsàCopy fields. (a dialogue window will pop out )

    Select à From data file

    Apply source fields

    a. Enter No. of field's

    b. Length of fields

    c. Attach file

    Save à Back.

    If the number of fields are more, it is preferable to use the same field name as SAP Table field name. The benefit of this can be seen on Step 5.

    4. MAINTAIN STRUCTURE RELATIONS

    Display change

    Save à Back.

    5. MAINTAN FIELD MAPPING & CONVERSION RULE

    Display change

    Click on source field, select exact field from structure and Enter

    ***repeat these steps for all fields.

    Save à Back.

    If in Step 3, the field names are same as the SAP Table field names, then the field mapping can be simplified by Extras --> Auto Field Mapping. In the pop-up window, select No Confirmation.

    6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED

    Execute

    Save à Back.

    7. SPECIFY FILES.

    Display change

    Click on legacy data

    Attach flat file

    Give description

    Select tabulators

    Enter

    Save à Back.

    An advantage of using LSMW over other methods of data upload is that if you have the column names in the first row of the input file, then the columns need not be in the same order as the file definition (Step 3). LSMW will move the value to the appropriate field by comparing the field name and the column name.

    8. ASSIGN FILE

    Execute

    Display change

    Save à Back.

    9. IMPORT DATA.

    Execute

    Display change

    Save à Back.

    10. DISPLAY IMPORTED DATA

    Enter ok ***it will show records only.

    Back

    11. CONVERT DATA

    Execute

    Display change

    Save à Back.

    12. DISPLAY CONVERTED DATA

    Execute

    Display change

    Save à Back.

    13. CREATE BATCH INPUT SESSION

    Tick keep batch input folder

    F8

    Back

    14. RUN BATCH INPUT SESSION.

    SM35 will come

    Object name will be shown here

    Select object & process

    Add a comment
    10|10000 characters needed characters exceeded

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.