SM30 table view

[nagaraju_gaddam]

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 ...

[PedroGuarita]

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.

[nagaraju_gaddam]

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.

[nagaraju_gaddam]

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?

[Former Member]

hi

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

[nagaraju_gaddam]

HI..

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

[nagaraju_gaddam]

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.

[Former Member]

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

[nagaraju_gaddam]

Hi.

thanks for your reply,

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

[Former Member]

Hi

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

[Former Member]

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.....

[nagaraju_gaddam]

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..

[Former Member]

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

thats enough to solve your problem

[nagaraju_gaddam]

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...

[Former Member]

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.

[nagaraju_gaddam]

Helpful answer

[Former Member]

>

> Helpful answer

Which one?

pk