09-04-2008 7:32 AM
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
09-04-2008 7:44 AM
09-04-2008 9:53 AM
Hi Shiva,
Thanks for the reply. But we do not have field for status in these tables.
Regards
Haricharan
09-04-2008 10:25 AM
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
09-04-2008 10:38 AM
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
09-04-2008 10:57 AM
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
09-04-2008 11:28 AM
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
09-04-2008 11:26 AM
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
09-04-2008 12:35 PM
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
11-05-2008 6:55 AM
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
11-05-2008 9:19 AM
hi malini
i hope its in table FKK_SEC_D field name NC_STATUS
just have a check
kr
raj
07-29-2010 7:58 AM
Dear Haricharan
This is pavan, hope you remember me.Are you still in Netherlands.
pl give me you mail address
pavankumar,hyderabad