topic Re: SM30 table view in Application Development and Automation Discussions

SM30 table view

nagaraju_gaddam — Tue, 16 Nov 2010 12:20:20 GMT

I Created one custom table with 6 fileds in that i want to change start date and end date automatically delimit the date and i need to put first 3 fileds to be not editable and if user create the new entries then the third record should delimit with the first record

automatically it is in sm30 screen ...

Re: SM30 table view

PedroGuarita — Tue, 16 Nov 2010 12:36:58 GMT

You can make your table time dependent, in order to do that, one of the date fields must be in the key and the other should be the first key of the non-key fields. The fields should have the data element BEGDA/ENDDA or VIM_BEGDA/ENDDA. In the table maintenaince generator you will have to go to Environment--> Generate time dependant. This will create a delimit button the status interface of the table maintenaince. Anyway, after that you will have to code a lot to do what you want, delimitation is not automatic, the only thing it does is delimit the record itself but won't have any influence in other records. So, most of the work will have to be done by coding in the modules created by the table maintenaince generator, a lot like infotype logic.

Re: SM30 table view

nagaraju_gaddam — Tue, 16 Nov 2010 14:11:19 GMT

Thanks for your reply..

My custom table contain the BK_CODE,CODE,RATE,DESCRIPTION,START_DATE,END_DATE first 3 are key fields ...in SM30 Screen when im creating the new entries

CITI POSTCHRG 0.30 CITIPOSTCHARG 14.09.2010 31.07.2011(default)

CITI CHKRECHR 0.30 CITICHKCHARG 14.09.2010 31.07.2011 (defaulf)

Change like this

CITI POSTCHRG 0.30 CITIPOSTCHARG 14.09.2010 31.12.9999

CITI CHKRECHR 0.30 CITICHKTCHARG 14.09.2010 31.12.9999

when user creating new entries the start date and end date should change like ( date 15.11.2010 want to create)

CITI POSTCHRG 0.30 CITIPOSTCHARG 14.09.2010 14.11.2010( No Overlaping)

CITI POSTCHRG 0.30 CITIPOSTCHARG 15.11.2010 31.12.9999

this should be automatically done by the system

could you send me sample code.

Re: SM30 table view

nagaraju_gaddam — Thu, 18 Nov 2010 03:06:27 GMT

Could you help on above issue..i'm able to change the delimit but only the new record is showing in sm30 screen i need the delimit histroty also how can i do?

Re: SM30 table view

Former Member — Thu, 18 Nov 2010 06:17:51 GMT

i think you have to get data dump and resend with delimit

Re: SM30 table view

nagaraju_gaddam — Thu, 18 Nov 2010 06:52:24 GMT

HI..

yes..could you help on this ..with correct result, i need to change on the end date delimitation...

Re: SM30 table view

nagaraju_gaddam — Thu, 18 Nov 2010 06:57:17 GMT

Hi,

Just i need to change in start date with different charges then it is delimit the old record and create the new record and shows the all the history in screen and end date should be default (31.12.9999)for example:

cust1 0.90 18.11.2010 31.12.9999

after change:

cust1 0.87 27.11.2010 31.12.9999

and shows all the records history in screen.

cust1 0.90 18.11.2010 26.11.2010

cust1 0.87 27.11.2010 31.12.9999

how can i do this.

Re: SM30 table view

Former Member — Thu, 18 Nov 2010 07:12:34 GMT

dear

i think your data in ztable and you have attached table maintenance view for that

1st get all the records to the itab


SELECT * FROM ZTable into itab.

now change what you want in itab by looping

now modify your ZTable


MODIFY ZTable FROM TABLE itab.

Edited by: Nelson Rodrigo on Nov 18, 2010 2:12 AM

Re: SM30 table view

nagaraju_gaddam — Thu, 18 Nov 2010 07:23:41 GMT

Hi.

thanks for your reply,

Still i have the problem in SM30 could you brief the senario how to resovle....

Re: SM30 table view

Former Member — Thu, 18 Nov 2010 08:04:04 GMT

you have two ways to do this

1. delete all the invalid data from your ztable by using sm30 and re upload with correct delimiter

2. over i mentioned thing

create a simple zprogram like

assume your table name is ZTABLE


REPORT  ZDELIMIT_UPDATE .

TABLES : ZTABLE.
DATA : IT_ZTABLE TYPE STANDARD TABLE OF ZTABLE.
DATA : WA_ZTABLE TYPE ZTABLE.


SELECT * FROM ZTABLE INTO TABLE IT_ZTABLE.
  
  LOOP AT IT_ZTABLE INTO WA_ZTABLE.
    WA_ZTABLE-ENDDATE = <WA_ZTABLE-ENDDATE> 'Do your change here
    MODIFY ZTABLE FROM WA_ZTABLE.
  ENDLOOP.

this will solve your problem

Re: SM30 table view

Former Member — Thu, 18 Nov 2010 08:11:38 GMT

Hi Nagaraju,

If you want to be delimited the date authomatically, you have write create Events.

These events make to save in table as per you write the code in Evnents.

Please refer how to write/create Events for Table.

Regards,

AVSP.....

Re: SM30 table view

nagaraju_gaddam — Thu, 18 Nov 2010 08:17:30 GMT

Hi...

Thanks for your reply..

Still I'm facing the same problem in sm30 screen it is not showing the old record it is showing created record after delimit record only...

could you tell me step by step from ztable to SM30...

1. Created ztable with (BK_CODE(P.K) ,CODE(P.K) , END_DATE(P.K), START_DATE ,RATE)

after that created Table maintanance generator and i given F.Group and authorization created screen and displaying the fields and after that environments----->Generate Time Dep. for delimit

when i m creating the new records in SM30 its not showing the history..

Re: SM30 table view

Former Member — Thu, 18 Nov 2010 08:29:01 GMT

Dear Do what i am telling 1st and regenerate the table maintenance

thats enough to solve your problem

Re: SM30 table view

nagaraju_gaddam — Thu, 18 Nov 2010 14:28:41 GMT

Hi Nelson,

Thanks for your reply,Still after i regenerate the TMG also same problem it is not showing the histroy..

i searched alot in for this issue...

Re: SM30 table view

Former Member — Thu, 18 Nov 2010 14:42:25 GMT

Hi,

To make entries into your two of the fields,

I think you can use events in your TMG.

Use event like 05-Creating a new entry.

And to make some fields non editable

*double click on the screen no and edit the properties in screen painter.

Thanks,

Anmol.

Re: SM30 table view

nagaraju_gaddam — Tue, 30 Nov 2010 01:28:09 GMT

Helpful answer

Re: SM30 table view

Former Member — Tue, 30 Nov 2010 04:23:11 GMT


> Helpful answer

Which one?