SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table for Security deposit status

Former Member
0 Kudos

Hi,

I have FM which gets the status but is there any way to get table related to status of security deposit.

Thanks in Advance

Regards

Haricharan

11 REPLIES 11

Former Member
0 Kudos

FKK_SEC

FKK_SEC_C

FKK_SEC_N

FKK_SEC_REQ

Regards,

Siva Kumar

0 Kudos

Hi Shiva,

Thanks for the reply. But we do not have field for status in these tables.

Regards

Haricharan

0 Kudos

TFK_SEC_STATUS_T is the table for status of the security deposit.

You can also refer these tables:

TFK_SEC_APPLK

TFK_SEC_REASON

TFK_SEC_REASON_T

TFK_SEC_REV

TFK_SEC_REV_T

TFK_SEC_STATUS

TFK_SEC_STATUS_T

TFK_SEC_TYPE

TFK_SEC_TYPE_T

Regards,

Siva Kumar

0 Kudos

If you see this table :: FKK_SEC_N and the field NC_STATUS

FKK_SEC_N-NC_STATUS "Noncash security deposit status

See the domain values for C_STATUS_KK . These all values are updated in this table :: FKK_SEC_N-NC_STATUS

Former Member
0 Kudos

Hi Shiva,

The above tables are generic ones. Let me explain the question in better way.. Open a security deposit using the transaction code FPD2 for a particular contract account. U'll have status field . I want to find the value of the status field of that particular security deposit.

Thanks in advance

Regards

Haricharan

0 Kudos

This domain is having these values C_STATUS_KK :: Cash security deposit status

00 Created

01 Request not posted

02 Requested

03 Partially paid

04 Paid

88 Partially released

96 Partially paid/cleared

97 Released

98 Returned

99 Reversed

89 Partially Returned

These values are updating in the FKK_SEC_N-NC_STATUS field.

Regards,

Shiva Kumar

Former Member
0 Kudos

Shiva,

Do we have to do any setting to get values in this table FKK_SEC_N-NC_STATUS ? I do not find any values in this table.

Regards

Haricharan

0 Kudos

As per my understanding these values are not updating into any tables.

They are using this Function Module to reterive the status <FKK_DB_CASH_SECURITY_STATUS_GP>.

I have seen this program they are maintaining these values as constant.

When you are creating they are collecting data from Domain <C_STATUS_KK>

Execute this FM to get the status, just give the security deposity no. You will get the status.

Regards,

Shiva Kumar

former_member421481
Participant
0 Kudos

Hi Haricharan,

I am also looking for the table which stores the status of the security deposit. Have you been able to find it?

Thanks and regards,

Malini

0 Kudos

hi malini

i hope its in table FKK_SEC_D field name NC_STATUS

just have a check

kr

raj

Former Member
0 Kudos

Dear Haricharan

This is pavan, hope you remember me.Are you still in Netherlands.

pl give me you mail address

pavankumar,hyderabad