topic Re: How to create Dynamic Internal table based on unknown columns? in Application Development and Automation Discussions

How to create Dynamic Internal table based on unknown columns?

Former Member — Thu, 21 Mar 2019 13:31:45 GMT

I have a internal table Say ITAB.

DATA: Begin of itab,

F1 TYPE C, F2 TYPE N, F3 TYPE P DECIMALS 2 , F4(20) TYPE C,

end of itab.

User want to exclude certain fields from the output based on the if the fields are initial.

I.e, user want to maintain F2 AND F4 Fields names in TVARAVC.

I have to check for the all the employees that F2 OR F4 is initial , then I will eiminate from the output that particular employee and I need to send email with Employee number, F2 , F4 as columns( what ever fields TVARVC is maintained).

I am able to verify whch are empty dynmaically but unable to create email where I dont know how to capture the unknown fields in columns.

I need to create <zdynamin_fs> to be created with the fields that are maintained in the TVARVC,

how Can I do that , thanks in advance.

Regards

sas

Re: How to create Dynamic Internal table based on unknown columns?

Tomas_Buryanek — Thu, 21 Mar 2019 13:42:07 GMT

Do you really need dynamic internal table? What is the output that user wants to exclude fields from? Is it ALV (if so you can just not display these columns)?

Re: How to create Dynamic Internal table based on unknown columns?

Former Member — Thu, 21 Mar 2019 13:59:06 GMT

Hi Tomas,

I have to send the output of missing fields in email with attachment, so I need to dynamic internal table to so I can fit in those. Thanks.

Edit:

I have ITAB to send the output to the application server.

and I am excluding certain fields from ITAB, so those fields that are excluded from ITAB i need to notify the user.so to notify we need the attachment.

Regards

SAS

Re: How to create Dynamic Internal table based on unknown columns?

s1252 — Thu, 21 Mar 2019 15:30:39 GMT

Hi, did you try googling it . below is an example how to create dynamic internal table

https://blogs.sap.com/2013/06/11/dynamic-internal-table-iilustrated-with-an-example-of-creating-the-transpose-of-internal-table/

Re: How to create Dynamic Internal table based on unknown columns?

DoanManhQuynh — Thu, 21 Mar 2019 15:42:03 GMT

I find it little hard to understand your question. Are you talking that you have to check the data in an internal table and which field need to checked will be defined in tvarvc? You have the field name, have the internal table so what stop you using field symbols to do that?

Re: How to create Dynamic Internal table based on unknown columns?

Former Member — Thu, 21 Mar 2019 15:56:54 GMT

Thanks Krishna Sandala!! Yeah I have some good internet connection and I have access to google.

The example you are referring I have gone through multiple times is we have internal table, and you are going to create a structure based on all fields , my requirement is to creaet the structure with those particular fields which we dont know. Thanks for your suggestion.

Re: How to create Dynamic Internal table based on unknown columns?

Sandra_Rossi — Thu, 21 Mar 2019 17:11:43 GMT

Please use the COMMENT button to reply to someone asking for details. ANSWER is only to propose a solution.

Re: How to create Dynamic Internal table based on unknown columns?

Former Member — Thu, 21 Mar 2019 18:10:59 GMT

ok Sandra , Mistake happened and unable to revert !! Will make sure for future.

Re: How to create Dynamic Internal table based on unknown columns?

s1252 — Tue, 09 Apr 2019 08:36:38 GMT

Do you have any success in creating a structure with the field which you don't know?

Re: How to create Dynamic Internal table based on unknown columns?

matt — Tue, 09 Apr 2019 16:31:20 GMT

But you didn't. You did it again just now!

Re: How to create Dynamic Internal table based on unknown columns?

ArthurParisius — Wed, 10 Apr 2019 08:42:35 GMT

Since you are able to find which fields are initial, than why not create a csv type string where you place this information in, instead of creating a dynamic table?