topic Re: coding an append-structure for a table? in Application Development and Automation Discussions

coding an append-structure for a table?

Former Member — Fri, 09 Sep 2011 07:00:23 GMT

Hey Team ABAP,

i was browsing the forum to find a solution to append a DB-table via coding instead of manually doing it via SE11.

Maybe i was just using wrong keywords i wouldnt neglect that, but i wasnt able to find something.

So i come here asking.

What i want to do is:

creating an append to a DB table, or rather a DDIC-structure at runtime via coding.

And well i dont really want to manually create DD02L entries, thats a bit too hot and dangerous in my eyes.

when looking in which FM´s DD02L is used i found FM DB_ALTER_TABLE, which somehow sounds promising, but ias far as i understood, it wont help we much. There are some other FM´s in function group SDB2 which somehow sound useful, but before checking them all out, i wanted to ask here if someone has done this before and can set me on the right track.

I just a hint how i could proceed. I´m very confident that coding wont be my problem then.

Thanks for listening.

Re: coding an append-structure for a table?

Former Member — Fri, 09 Sep 2011 07:28:22 GMT

Have you tried using the keyword APPEND or APPEND LINES. Check this [link|http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb36c8358411d1829f0000e829fbfe/content.htm]

Re: coding an append-structure for a table?

Former Member — Fri, 09 Sep 2011 07:53:36 GMT

Thanks for your answer.

probably i have to make myself a bit more clear.

I do not want to append lines to an itab.

i want to create an append structure, like going to SE11 with a specific table and hitting the "append stucture" button.

Background:

We have a tool for master data and price management. E.G. for material master data.

If a customer has customer fields in e.G. table MARA, i have to append this field in various structures that our tool is using.

So our tool can not only handle standard fields, but customer fields as well.

I´ve done all neccessary steps yesterday manually, and well for 3 MARA fields it took me around 2.5 hours.

So i had the vision to automate what i was doing in a simple report, which does the neccessary steps for me, since there are always the same actions to do..

Re: coding an append-structure for a table?

former_member222709 — Fri, 09 Sep 2011 08:40:08 GMT

Hi Florian,

I'm sure a FM will be the best way, but, I'm not aware of any.

If you are ok with a workaround and have not thought of it, then try with a BDC for SE11. That should be of some help.

Regards,

Pranav.

Re: coding an append-structure for a table?

Former Member — Fri, 09 Sep 2011 08:48:31 GMT

Oh thanks,

actually calling some FM´s would be my prefered solution, but BCD would be a solution as well.

And yeah i really didnt think of it!

going to check that out.

Re: coding an append-structure for a table?

Former Member — Fri, 09 Sep 2011 09:45:22 GMT

Hi,

You could check FM DDIF_TABL_PUT and FM DDIF_TABL_ACTIVATE to activate the table.

Also check FM documentation..

Regards,

Ravi.

Re: coding an append-structure for a table?

Former Member — Sat, 10 Sep 2011 22:15:03 GMT

Since my quest to find FM´s takes too long, i will go for a BCD-solution.

Thank you guys.