topic Re: Dynamically fetching first column in internal table based on flat file in Application Development and Automation Discussions

Dynamically fetching first column in internal table based on flat file

Former Member — Sun, 18 Jan 2015 05:42:53 GMT

Hi All,

Let me explain this scenario.

I have a flat file which will be uploaded for a BDC. Based on which type pf business is operating we have two types of flat file template ->

Business 1 : Template

Land1

LIFNR

Bank details

Business 2 Template

LIFNR

BANK DETAILS.

In any case for further processing , I need the first column to be there which is LAND1. How do in create column 1 to my internal table at runtime and proceed.Also the other columns are fixed and will not change.

Please help.

Thanks

Re: Dynamically fetching first column in internal table based on flat file

archanapawar — Sun, 18 Jan 2015 06:42:23 GMT

Hi Swarna,

I think it is difficult to generate LAND1 column at runtime while reading dataset into internal table.

Did you try offset method to determin whether your first column is LAND1 or LIFNR?

May be based on that you can pass you record into respective internal table.

Re: Dynamically fetching first column in internal table based on flat file

former_member182888 — Sun, 18 Jan 2015 09:04:40 GMT

Please clarify and give example to your Flat file records

Re: Dynamically fetching first column in internal table based on flat file

Former Member — Sun, 18 Jan 2015 10:11:30 GMT

Hi ,

In case of Business 1

LAND1 LIFNR TAXID NAME1 SORT1 etc

In case of Business 2

LIFNR TAXID NAME1 SORT1.

Here in case of business 2 i need to add a column LAND1 at run time after uploading the flat file and set it to a specific country value.

Could you please help,

Thanks

Re: Dynamically fetching first column in internal table based on flat file

archanapawar — Sun, 18 Jan 2015 10:26:05 GMT

Hi swarna,

Did you try offset method? You can get the content of read dataset into a string type first and check the first field whether it is LAND1 or LIFNR. Further you can divide it as per your requirement.

Re: Dynamically fetching first column in internal table based on flat file

former_member182888 — Sun, 18 Jan 2015 10:39:45 GMT

thank you

ok,

you will concatenate the desired value to the beginning of the record

Re: Dynamically fetching first column in internal table based on flat file

Former Member — Sun, 18 Jan 2015 11:55:18 GMT

Hi Archana,

Could you please explain as im a bit confused here.

Thanks

Re: Dynamically fetching first column in internal table based on flat file

archanapawar — Sun, 18 Jan 2015 12:12:08 GMT

Hi Swarna,

Data element LIFNR is char10 and LAND1 is char3. So, define a work area type string.

Then read dataset into work area.

After reading into work area, split your work area at your file separator e.g. ' '(space) into 2 variables.

Read the length of first variable, if its 3, then it is LAND1 field and if it is more than 3 that means field is LIFNR.

Below is sample code.


DATA: wa_text TYPE string,
       lv_text1 TYPE char10,
       lv_text2 TYPE char10,
       lv_count TYPE i.


READ DATASET lv_path INTO wa_text.

split wa_text at ' ' into lv_text1 lv_text2.
lv_count = strlen( lv_text1 ).



if lv_count eq 3.
*- read dataset again to internal table with LAND1 and remaining columns.
else.
*- read dataset again to internal table for LIFNR.
ENDIF.

Hope it helps. It should work.

Re: Dynamically fetching first column in internal table based on flat file

VenkatRamesh_V — Sun, 18 Jan 2015 17:07:08 GMT

Hi,

Try with the Excel format using FM ALSM_EXCEL_TO_INTERNAL_TABLE .

Hope it helpful.

Regards,

Venkat.

Re: Dynamically fetching first column in internal table based on flat file

archanapawar — Tue, 20 Jan 2015 06:41:38 GMT

Hi Swarna,

Did you try this solution?