topic Re: Question with database table in Application Development and Automation Discussions

Question with database table

Former Member — Thu, 28 Sep 2006 15:51:18 GMT

I want to update a z custom table with a set of new rows and also modify some of the rows. Do you have any sample code for this?

Also can you tell me what is the check table for states in usa?

Thanks,

Krishen

Re: Question with database table

Former Member — Thu, 28 Sep 2006 15:52:41 GMT

U can use MODIFY ZTABLE to either insert/update the row in your custom ztable.

Re: Question with database table

Former Member — Thu, 28 Sep 2006 15:52:57 GMT

DATA: T_DATA TYPE STANDARD TABLE OF ZTABLE WITH HEADER

LINE.

MODIFY ZTABLE FROM TABLE T_DATA.

INSERT ZTABLE FROM TABLE T_DATA.

The check table for state for US is T005S..

Thanks,

Naren

Re: Question with database table

Former Member — Thu, 28 Sep 2006 15:54:52 GMT

HI KRISHEN,

do this way ..

    it_zprtow-own_balance  = it_zprtow-own_balance
                               + it_ossl-gl_trans_am.

     IF NOT it_zprtow[] IS INITIAL.
      MODIFY zprtow_eom_babal FROM TABLE it_zprtow.
      IF sy-subrc = 0.
        COMMIT WORK.
        WRITE : 'Number of Entries Updated', sy-dbcnt.
      ENDIF.

Regards,

Santosh

Re: Question with database table

Former Member — Thu, 28 Sep 2006 15:55:26 GMT

Hi naren,

I understand. But i am just looking for states. That T005S has the details about land1 also. So, I could not figure out how to attach just the 'states' part of that check table to my 'state' field in custom table.

Any input?

Thanks a lot

Re: Question with database table

Former Member — Thu, 28 Sep 2006 15:56:28 GMT

Do I always have to 'commit' when I insert/modify databse tables?

Thanks.

Re: Question with database table

Former Member — Thu, 28 Sep 2006 15:57:58 GMT

Hi,

If you have land1 in your table while defining the foreign key, it will automatically take the value based on the field land1..Since the states is dependant in country..

Thanks,

Naren

Re: Question with database table

Former Member — Thu, 28 Sep 2006 15:58:48 GMT

Yes. You have to give commit work..

THanks,

Naren

Re: Question with database table

Former Member — Thu, 28 Sep 2006 16:03:31 GMT

Naren,

I don't have land1 field. I just have states field. The problem is when I am attaching this check table, and when I select the value from F4, only the land1 value is coming in my states field. What I am looking is just the state to come into that field. Any idea?

Thanks for your input.

Re: Question with database table

Former Member — Thu, 28 Sep 2006 16:10:32 GMT

Hi,

You can add a field for country in the table..

For more details check the table ADRC for the fields COUNTRY and REGION...You need to have the same setup in your custom table..

GOTO SE16 for ADRC..in the country field enter US and press F4 on the region field...you will get the states only for US...

Thanks,

Naren