cancel
Showing results for 
Search instead for 
Did you mean: 

REFX - LEASE IN - CONTRACT MASTER DATA LOCK / UNLOCK - TABLE REQUIRED

narnei
Contributor
0 Kudos

Dear Experts,


I need a clarification in  REFX - lease in scenario.

For a  ( RECN) RENTAL contract we are locking the master data  ( RECN - MAIN MENU - EDIT - CHANGE STATUS - SET LOCK -- LOCK MASTER DATA ) when ever we dont use the contracts for long time / problematic conracts.Attached screen shot show the same.


Would like to see the CONTRACT DATA LOCK STATUS ( Master DATA UNLOCKED / LOCKED )  information from table for number of orders.


Can any one suggest the table name / any function module for that.

Thanks,

N.S.Rao

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you want to lock/unlock the master data, you can use BAPI

BAPI_RE_CN_CHANGE

for locking


CALLFUNCTION'BAPI_RE_CN_CHANGE'

         EXPORTING

           compcode            = 'XYZ'

           contractnumber     = lv_contract

           trans                    = 'PSSM'

         TABLES

return                   = lt_return.

for unlock / reset activation


CALLFUNCTION'BAPI_RE_CN_CHANGE'

         EXPORTING

           compcode            = 'XYZ'

           contractnumber     = lv_contract

           trans                    = 'PSEM'

         TABLES

return                   = lt_return.

Regards,

narnei
Contributor
0 Kudos

Dear Mr. Chandra,

Thanks for your reply, we are doing lock / unlock  manually, its not a problem but would like to generate a report for number of contract locked / unlocked with current status of the contract.

Regards,

N.S.Rao

Former Member
0 Kudos

table which saves status is JEST and TJ02.. and the logic is bit tricky

If you want read the status you can also use below methods:

CL_RECA_STATUS_MNGR-GET_CURRENT_STATUS

CL_RECA_STATUS_MNGR-GET_CURRENT_STATUS_X

Function module:

status_read

narnei
Contributor
0 Kudos

Dear Mr.Chandra Garu,

Thank you so much for your kind advise.Table JEST is solving my purpose.

Thank you so much.

Regards,

Subbarao.Narne

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

If getting the count of LOCKED/UNLOCKED is not the only objective, then you can create a selection profile in the configuration with inclusive and exclusive rules for desired system or user status example: Include all MDLK. Execute all standard reports like REISCN with this status profile and you should get all Master data locked contracts, best part is you can use rest of the massive selection criteria with this too to meet any reporting need. Similalry you may have a profile for active (unlocked) contracts too. This works for not only contracts objects too.

Let me know if you need help to set up a selection profile.

Jag

narnei
Contributor
0 Kudos

Dear Mr.Jagannath,

Thank you so much for your kind reply, i was unable to understand it, Can you pls clarify me the same with an example to do needful.

Once again thank you so much for your extended support here.

Regards,

N.S.Rao

Former Member
0 Kudos

Hello,

Please configure a new Status Profile in the below node.

In the selection profile you create enter the selection condition for MDLK and any other as you may need. Save your profile.

Now in any info system report you can use this selection profile for getting data per your selection condition (in your case MDLK Contracts). Go to REISCN, make sure Checkbox "Status Selection Active" is checked, enter the status profile and execute the report with any other criteria you need.

Hope this meets your requirement without development.

Jag

narnei
Contributor
0 Kudos

Dear Mr.Jagannath,

Well noted the solution, yes this will helps me.

Thank you so much for clarity for my understanding.

Regards,

N.S.Rao

narnei
Contributor
0 Kudos

Dear Mr.Jaganath,

I am using JEST table as you advised. But here did not understand the status id's of below objects.As highlighted in attached scren shot.

I0002

I0098

Also i understand  the below for rest of the objects. kindly confirm is it correct or not.

I0119 – ACTIVATES WHEN CONTRACT GET ACTIVATED.

I0065 – ACTIVATES WHEN CONTRACT MASTER DAT GET LOCKED / UNLOCKED.

I0064 - ACTIVATES WHEN CONTRACT  lock account assignment GET LOCKED / Un locked.

I0061 - - ACTIVATES WHEN CONTRACT  planning LOCK / UNLOCK



Thanks & Best Regards,

N.S.Rao


Former Member
0 Kudos

Dear Rao,

Yes, you are correct. You can check the system statuses in t-code BS22.

rgds,

Srini

narnei
Contributor
0 Kudos

Dear Mr.Srini Sir,

Well noted the given detail, Thank you so much for your reply.

Regards,

N.S.Rao

Former Member
0 Kudos

Hi,

Kindly try locating the table using trace tool (ST05).

Regards,

Sid

narnei
Contributor
0 Kudos

Dear Mr.Siddarth,

Thanks for your reply. i will try to follow the instructions given by you.

Thank you so much.

Regards,

N.S.Rao