2 Table Maintenance generation & validation using events
Create table lets say ZXXXX hold Object Locations.
Field key data element Type Length Dec text
MANDT x MANDT Clnt 3 0 Client
ZCTRY x LAND1 Char 3 Country Key
ZOLOC x ZOLOC Char 15 Object
Location
ZOLOC20 ZOLOC20 Char 20 Object
Location short text
ZOLOC40 ZOLOC40 Char 40 Object
Location long text
ZAWSYS LOGSYSTEM Char 10
Logical System
ZSTREET AD_STREET Char 60
Street
ZSTREET2 AD_STRSPP1 Char 40
Street 2
ZPOSTAL_CODE AD_PSTCD1 Char 10
City postal code
ZCITY AD_CITY1 Char 40 City
ZCOUNTRY ZLAND Char 3
Address Country
ZOBJ_SIGN ZOBJ_SIGN Char 10
Object Sign
ZREF1 ZREF1 Char 10 Reference 1
ZREF2 ZREF2 Char 10 Reference 2
ZREF3 ZREF3 Char 10 Reference 3
ZREF4 ZREF4 Char 10 Reference 4
ZNOTE1 ZNOTE1 Char 20 Note 1
ZNOTE2 ZNOTE2 Char 20 Note 2
ZCREAETDATE CREATEDATE Dats 8
Creation/Change Date
ZCREATETIME CREATIETIME Tims 6
Creation/Change Time
Create a table maintenance generator for ZXXXX.
Create two events in Table Maintenance Generator:
- To update the filed value SAP in ZAWSYS and
creation date and time
- To update change date and time after saving the
entry
Event ‘21’ – At Create:
ZXXXX-ZAWSYS = SAP.
ZXXXX-ZCREATEDATE = sy-datum.
ZXXXX-ZCREATETIME = sy-uzeit.
Event ‘01’- After Save
ZXXXX-mandt = extract+0(3).
ZXXXX-zctry = extract+3(3).
ZXXXX-zoloc = extract+6(15).
ZXXXX-zoloc20 = extract+21(20).
ZXXXX-zoloc40 = extract+41(40).
ZXXXX-zawsys = log_sys.
ZXXXX-zstreet = extract+91(60).
ZXXXX-zstreet2 = extract+151(40).
ZXXXX-zpostal_code = extract+191(10).
ZXXXX-zcity = extract+201(40).
ZXXXX-zcountry = extract+241(3).
ZXXXX-zobj_sign = extract+244(10).
ZXXXX-zref1 = extract+254(10).
ZXXXX-zref2 = extract+264(10).
ZXXXX-zref3 = extract+274(10).
ZXXXX-zref4 = extract+284(10).
ZXXXX-znote1 = extract+294(20).
ZXXXX-znote2 = extract+314(20).
ZXXXX-zcreatedate = sy-datum.
ZXXXX-zcreatetime = sy-uzeit.
modify ZXXXX.
Answer Posted / pravin
Views
Match code
Lock object
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What type of user exits have you written ?
What are local objects? : abap data dictionary
What are the different types of luws?
I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?
What are the differences between domain and data element?
Can we specify the next screen number with a variable?
Can multiple abap systems connect to abap database?
Define infotype ? : abap hr
What is the significance of delivery class? : abap data dictionary
what is defference between repository and non repository Object?
In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?
How to display if the value entered contains records or not?
where do we store all custom programs in SD module?
What is the basic difference internal tables and database tables? : abap data dictionary
In which time constraint does the infotype records depend on the subtype ? : abap hr