file operations

TYPES: BEGIN OF ts_tab,
        matnr TYPE matnr,
        maktx TYPE maktx,
        meins TYPE meins,
      END OF ts_tab.

TYPES: tt_tab TYPE STANDARD
        TABLE OF ts_tab.

DATA: gs_tab TYPE ts_tab,
      gt_tab TYPE tt_tab,
      gt_exe TYPE STANDARD
        TABLE OF alsmex_tabline,
      gs_exe TYPE alsmex_tabline.

DATA: v_file TYPE ibipparms-path.

PARAMETERS: p_file TYPE string,
            p_file2 TYPE string,
            p_file3 TYPE string.


AT SELECTION-SCREEN ON
  VALUE-REQUEST FOR p_file.

  CALL FUNCTION 'F4_FILENAME'
    EXPORTING
      program_name  = syst-cprog
      dynpro_number = syst-dynnr
      field_name    = 'P_FILE'
    IMPORTING
      file_name     = v_file.
  p_file = v_file.

START-OF-SELECTION.

  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                = p_file
      i_begin_col             = 1
      i_begin_row             = 1
      i_end_col               = 3
      i_end_row               = 3
    TABLES
      intern                  = gt_exe
    EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole              = 2
      OTHERS                  = 3.
  IF sy-subrc EQ 0.
    LOOP AT gt_exe INTO gs_exe.
      CASE gs_exe-col.
        WHEN 1.
          gs_tab-matnr = gs_exe-value.
        WHEN 2.
          gs_tab-maktx = gs_exe-value.
        WHEN 3.
          gs_tab-meins = gs_exe-value.
      ENDCASE.
      AT END OF row.
        APPEND gs_tab TO gt_tab.
        CLEAR: gs_tab,gs_exe.
      ENDAT.
    ENDLOOP.
  ENDIF.

  LOOP AT gt_tab INTO gs_tab.
    WRITE:/ gs_tab-matnr,gs_tab-maktx,
            gs_tab-meins.
  ENDLOOP.

Difference between structure and table ?

Structure cannot hold the data where table can hold data.

Customer ,Vendor &Material table names ?

Vendor Master	Tables
Vendor Master (General Section)	LFA1
Vendor Master (Company Code)	LFB1
Vendor master (VAT registration numbers general section)	LFAS
Vendor master (dunning data)	LFB5
Vendor Master (Bank Details)	LFBK
Vendor master record (withholding tax types) X	LFBW
Vendor master record purchasing organization data	LFM1
Vendor Master Record: Purchasing Data	LFM2
Vendor Subrange	WYT1
Vendor Sub Range Description	WYT1T
Partner Functions	WYT3
Customer Master	Tables
General Data in Customer Master	KNA1
Customer Master (Company Code)	KNB1
Assign customer credit card	VCKUN
Customer Master Contact Partner	MASSKNVK
Customer master record sales request form	MASSKNVD
Customer Master Sales Data	KNVV
Customer Master Partner Functions	KNVP
Customer Master Licenses	KNVL
Customer Master Tax Indicator	KNVI
Customer Master Unloading Points	KNVA
Customer master credit management: Control area data	KNKK
Customer master credit management: Central data	KNKA
Customer Master: Legal Control  Sanctioned Party List	KNEX
Customer Master (Bank Details)	KNBK
Customer master (dunning data)	KNB5
Customer master (VAT registration numbers general section)	KNAS
Material Master	Tables
General Material Data	MARA
Material Descriptions	MAKT
Plant Data for Material	MARC
Material Valuation	MBEW
Storage Location Data for Material	MARD
Units of Measure for Material	MARM
Sales Data for Material	MVKE
Forecast Parameters	MPOP
Planning Data	MPGD_MASS
Tax Classification for Material	MLAN
Material Data for Each Warehouse Number	MLGN
Material Data for Each Storage Type	MLGT

Transaction codes in SAP

se-37  Function library.
se -51 Screen  painter screen..
se -41 Menu painter screen.
se -80 Object browser.
se -16 Data browser.
sm -30  General table contents display.

File handling in sap

File son application server are sequential files.Files on presentation server workstation are local files.
sequential files are also called a data set.

what is the difference between macros and subrotines?

1.macro doesn't have any return statemen.but a subroutine
can have 
2.execution time needed for a macro is much lesser than
subroutine
3.memory requirement for a macro is generally heigher
4.subroutine can be classified as stated in Previous
answers..but no such classification is available with macro
although macro can have different types of nested form
5.generally no of instructions in macro are smaller than
subroutine
6.macro is always local to the program that defines it
subroutine may or may not be local.

What is file handling in abap?

ABAP provides three statements for handling files:

• The OPEN DATASET statement opens a file.

• The CLOSE DATASET statement closes a file.

• The DELETE DATASET statement deletes a file.