Answer / ektagalani

Direct Input method in BDC happens through LSMW. Here are
the steps:-
Steps for LSMW Direct Input (Importing Technique)

Step 1: Tcode : LSMW

Step 2:

Project :
Sub Project :
Object : Object Name
Click On 'Create Entry' Button.

Step 3:

Project :
Enter Des :
Sub Project :
Enter Des :
Object :Object Name
Enter Des :Object Description
Click On Execute (F8)

Step 4:

Maintain Object Attributes.
click Execute and Clickon Edit/Change.
select Standard Batch/DirectInput Radio Button from
"Object type and Import Techniques"
Object: 0020
method:0000
Program Name: RMDATIND
Program Type: D (Direct Input)
Save, Back.


Step 5:

Maintain Source Structures.
Click on Execute(f8)
Highlight Source Structure.
Click on Display / Change button.
Click on Create Structure button.
Enter the Source Structure
Enter Description
Continue, Save, Back.

Step 6:

Maintain Source Fields.
Click on Execute(f8)
Highlight Source Structure.
click on Copy Fields.
Select "From Data File" Radio Button
Specify "Number Of Fields"
Specify "Max Record Length"
Specify "File Name "
Click On Transfer, Save, Back.

Step 7 :

Maintain Structure Relations
Select the target Structure
Click on 'Relationship' button
Repeat the same step for all the Structures
Save, Back.

Step 8:

Maintain Field Mapping & Conversion Rules.
Select the appropriate field
Click on change,
Click on Source Field button and map with Appl Field.
Repeat the process for the remaining fields.
Save, Back.

Step 9:

Maintain Field Values,Transactions, User defined Routines
Execute(F8),
Back.

Step 10:

Specify Files.
Execute(F8)
Click On "Change button"
Select the Legacy Data on 'R/3 Application Server'.
Click on "Create"
Specify filename, Description
Select Tabulator,
Field Names at the beginning of the file continue.

Step 11:

Assign Files.
Execute (F8).
Back.

Step 12:

Read Data
Execute (F8),Execute (F8),Back, Back.

Step 13:

Display Read Data
Execute (F8),
Continue,
Back.

Step 14:

Convert Data
Execute (F8),Execute (F8),Back, Back.
Step 15: Start Direct Input Program.
Execute(F8),
Select "Program" Radiobutton
Continue.
Select via 'Physical Filename' Radio Button
Select Lock Mode .

What is a bsp application? : sap abap hr

0 Answers  

---

explain the script component in script?

2 Answers   TCS,

---

Will the views get effected when updating the database?

3 Answers   Reliance,

---

What is asap methodology? : sap abap hr

0 Answers  

---

what is the variable to be used in sap scripts to find the total number of pages of the print job?

1 Answers   Accenture,

---

What is the difference between open sql & native sql ?

3 Answers   Accenture, SAP Labs,

---

Does SAP has a GUI screen painter or not? If yes what operating systems is it available on? What is the other type of screen painter called?

0 Answers  

---

List some of the many different ways that the sap standard functionality can be changed by a customer?

0 Answers  

---

What is the difference between select statement and provide statement

1 Answers  

---

what is the work of buffer in sap ?

1 Answers  

---

Differentiate select and select single?

2 Answers  

---

correct all performance problem without changing any functionality REPORT z_assignment_01. DATA: gt_user TYPE TABLE OF usr02 WITH HEADER LINE, gt_user_role TYPE TABLE OF agr_users WITH HEADER LINE, ********** DO NOT CHANGE THIS SECTION ********** g_begintime TYPE i, g_endtime TYPE i, g_tottime TYPE i. DATA: BEGIN OF gt_output OCCURS 0, bname LIKE usr02-bname, name_text LIKE adrp-name_text, agr_name LIKE agr_users-agr_name, text LIKE agr_texts-text, role_count TYPE i, END OF gt_output. TYPE-POOLS: slis. START-OF-SELECTION. GET RUN TIME FIELD g_begintime. ********** END NO CHANGE ********** SELECT * INTO TABLE gt_user FROM usr02 WHERE class > 'E'. SELECT * INTO TABLE gt_user_role FROM agr_users FOR ALL ENTRIES IN gt_user WHERE uname = gt_user-bname. PERFORM combine_tables. PERFORM get_addl_data. ********** DO NOT CHANGE THIS SECTION ********** GET RUN TIME FIELD g_endtime. g_tottime = ( g_endtime / 1000000 ) - ( g_begintime / 1000000 ). MESSAGE s398(00) WITH g_tottime. PERFORM output. ********** END NO CHANGE ********** *&---------------------------------------------------------------------* *& Form combine_tables *&---------------------------------------------------------------------* * Combine user and role tables *----------------------------------------------------------------------* FORM combine_tables. DATA: ls_usr21 TYPE usr21, ls_adrp TYPE adrp, ls_texts TYPE agr_texts. LOOP AT gt_user. * Get user name SELECT * INTO ls_usr21 FROM usr21 WHERE bname = gt_user-bname. SELECT * INTO ls_adrp FROM adrp WHERE persnumber = ls_usr21-persnumber. gt_output-name_text = ls_adrp-name_text. ENDSELECT. ENDSELECT. LOOP AT gt_user_role WHERE uname = gt_user-bname. * Only process roles that are currently active CHECK gt_user_role-from_dat <= sy-datum AND gt_user_role-to_dat >= sy-datum. * Get role text SELECT * INTO ls_texts FROM agr_texts WHERE agr_name = gt_output-agr_name AND spras = sy-langu AND line = 0. gt_output-text = ls_texts-text. ENDSELECT. gt_output-bname = gt_user-bname. gt_output-agr_name = gt_user_role-agr_name. APPEND gt_output. ENDLOOP. ENDLOOP. ENDFORM. " combine_tables *&---------------------------------------------------------------------* *& Form get_addl_data *&---------------------------------------------------------------------* * Get extra fields *----------------------------------------------------------------------* FORM get_addl_data. DATA: l_count TYPE i. * Count number of roles per user SORT gt_user_role BY uname. LOOP AT gt_user_role. ADD 1 TO l_count. AT END OF uname. LOOP AT gt_output WHERE bname = gt_user_role-uname. gt_output-role_count = l_count. MODIFY gt_output. CLEAR l_count. ENDLOOP. ENDAT. ENDLOOP. ENDFORM. " get_addl_data *&---------------------------------------------------------------------* *& Form output *&---------------------------------------------------------------------* * Output report *----------------------------------------------------------------------* FORM output. DATA: lt_fieldcat TYPE slis_t_fieldcat_alv, ls_fieldcat TYPE slis_fieldcat_alv, l_repid LIKE sy-repid, ls_layout TYPE slis_layout_alv, ls_variant TYPE disvariant. l_repid = sy-repid. CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_program_name = l_repid i_internal_tabname = 'GT_OUTPUT' i_inclname = l_repid CHANGING ct_fieldcat = lt_fieldcat EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3. IF sy-subrc <> 0. MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. ENDIF. ls_fieldcat-seltext_l = 'Role Count'. ls_fieldcat-seltext_m = 'Role Count'. ls_fieldcat-seltext_s = 'Role Count'. ls_fieldcat-reptext_ddic = 'Role Count'. MODIFY lt_fieldcat FROM ls_fieldcat TRANSPORTING seltext_l seltext_m seltext_s reptext_ddic WHERE fieldname = 'ROLE_COUNT'. ls_layout-zebra = 'X'. ls_layout-colwidth_optimize = 'X'. CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING is_layout = ls_layout it_fieldcat = lt_fieldcat i_save = 'A' is_variant = ls_variant TABLES t_outtab = gt_output EXCEPTIONS program_error = 1 OTHERS = 2. IF sy-subrc <> 0. MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. ENDIF. ENDFORM. " output

0 Answers  

---