topic Re: Nast Table in Application Development and Automation Discussions

Nast Table

Former Member — Tue, 11 Jul 2006 04:43:02 GMT

Hi all,

I tried to adda field in NAST table and then modify the data type. I am getting an error that i cant alter the table. if i drop the database table and recreate it will it be affecting configuration .

regards,

Bala

Re: Nast Table

Former Member — Tue, 11 Jul 2006 04:47:00 GMT

NAST is a configuration table, you should never ever alter the table and even touch that for that matter. Why do you want to alter the table? In fact you should not modify any SAP Standard table.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: Nast Table

Former Member — Tue, 11 Jul 2006 04:49:09 GMT

hi,

Its a requirement i added a field here and change the data type. then i tried to adjust the table but i got some connectivity problem and now its not working.

regards,

Bala

Re: Nast Table

Former Member — Tue, 11 Jul 2006 04:51:59 GMT

I can't imagine a requirement where in you will have to alter a configuration table. I don't think that is the right design to do that. Its not even a transaction table, where in you can do a customer include to add custom tables.

If you can explain your requirement, the probably there is a work around for the same.

Regards,

Ravi

Re: Nast Table

Former Member — Tue, 11 Jul 2006 04:56:19 GMT

Hi,

For a report i have addeda column in the alv. When I try to change the data type and adjust It got sucked. I get error saying inconsistency in table field and primary index.

regards,

Bala

Re: Nast Table

Former Member — Tue, 11 Jul 2006 04:59:07 GMT

Hi Bala,

NAST table contains data related to your ouput triggered by SAP transaction like Print output,Fax,Telex,EDI and others.

For e.g. if you send output of PO to printer or send outbound IDOC then record will be added to NAST table.

This is not configurable table.Could you ppost your specific requirements? It will be easy to answer your query.

Regards,

Sunil

Re: Nast Table

Former Member — Tue, 11 Jul 2006 05:00:32 GMT

I am assuming that you are using the NAST structure for developing a ALV report. In that case, revert back NAST table to it old structure. Create a structure in SE11 which will look like NAST and add addition fields to that strcuture. Create a field catalog using that structure, then you will have all the fields that you want and you don't have to touch the database table.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: Nast Table

Former Member — Tue, 11 Jul 2006 05:08:21 GMT

Hi,

I added a field in the table to display a column in an alv. Then i changed the data type of the field. When i tried to adjust the database there was come connection problem and the process got stopped. now when i try to c the rrecords in the table i am getting an short dump. ANd in the index part the primary index are not created. The process was struck during the connection loss.

Now i am trying to create the index it says the index is already there in the data base. But it doesnt show in the data dictionary.

Now what i think is can i delete the database table and create it again.

regards,

Bala

Re: Nast Table

Former Member — Tue, 11 Jul 2006 05:11:46 GMT

I don't think you are getting the concept here.

<b>You are not supposed to touch the database tables directly in a ERP. </b>

Please talk to your BASIS team and they will be able to revert back the changes done to the NAST table.

Regards,

Ravi

Re: Nast Table

Former Member — Tue, 11 Jul 2006 05:14:33 GMT

Hi Ravi,

There are specific requirements where we make modifications in the std tables and program. I think you have not come across the scenario till now.

Regards,

Bala