SAP ABAP Table FKK_SEC_D (Screen Fields for Security Deposit)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA-BT-SE (Application Component) Security Deposits
     ⤷ FKK_SECURITY (Package) Contract A/R & A/P: Security Deposits

Basic Data

Table Category	INTTAB	Structure
Structure	FKK_SEC_D	Table Relationship Diagram
Short Description	Screen Fields for Security Deposit

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	SECURITY	☐	SECURITY_KK	SECURITY_KK	CHAR	12	0	Security Deposit	FKK_SEC
3	.INCLUDE	☐				0	0	General attributes for a security deposit
4	APPLK	☐	APPLK_KK	APPLK_KK	CHAR	1	0	Application area
5	NON_CASH	☐	NON_CASH_KK	XFELD	CHAR	1	0	Choose: noncash security deposit
6	REASON	☐	REASON_KK	REASON_KK	CHAR	4	0	Reason for Requesting a Security Deposit	TFK_SEC_REASON
7	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
8	SEC_START	☐	SEC_START_KK	DATUM	DATS	8	0	Start date for security deposit
9	SEC_RETURN	☐	SEC_RETURN_KK	DATUM	DATS	8	0	Return date for security deposit
10	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
11	OPBEL	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	DFKKKO
12	REV_REASON	☐	REV_REASON_KK	REV_REASON_KK	CHAR	4	0	Reversal reason for security deposit	TFK_SEC_REV
13	NRZAS	☐	NRZAS_KK	NRZAS_KK	CHAR	12	0	Payment Form Number
14	OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	TOJTB
15	OBJKEY	☐	SEC_OBJTYP_KK	SWO_TYPEID	CHAR	70	0	Object Key for Cash Securities
16	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
17	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
18	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
19	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	BRGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
21	IKEY	☐	IKEY_KK	IKEY_KK	CHAR	2	0	Interest Key	TFK056A
22	X_SEC_REV	☐	X_SEC_REV_KK	XFELD	CHAR	1	0	Security Deposit Reversed
23	X_SEC_REL	☐	X_SEC_REL_KK	XFELD	CHAR	1	0	Security Deposits Released
24	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
25	EXT_REF_NO	☐	SEC_XRFNR_KK	CHAR20	CHAR	20	0	External Reference Number of Security Deposit
26	.INCLUDE	☐				0	0	Contract data for security deposit
27	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
28	REQUEST	☐	REQUEST_KK	WERT6	CURR	11	2	Requested Amount for Security Deposit
29	C_STATUS	☐	C_STATUS_KK	C_STATUS_KK	NUMC	2	0	Cash security deposit status
30	.INCLUDE	☐				0	0	Attributes for a noncash security deposit
31	NC_STATUS	☐	NC_STATUS_KK	NC_STATUS_KK	NUMC	2	0	Noncash security deposit status	TFK_SEC_STATUS
32	TYP	☐	TYP_KK	TYP_KK	CHAR	4	0	Noncash security deposit category	TFK_SEC_TYPE
33	REFNO	☐	REFNO_KK	CHAR40	CHAR	40	0	Reference number for non-cash security deposit
34	GPART_GUARANTOR	☐	GPART_GUARANTOR_KK	BU_PARTNER	CHAR	10	0	Guarantor of a noncash security deposit	BUT000
35	XBUPP	☐	XBUPP_KK	XFELD	CHAR	1	0	Indicator: Guarantor is a Private Person
36	VKONT_GUARANTOR	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
37	SEC_EXPIRE	☐	SEC_EXPIRE_KK	DATUM	DATS	8	0	Expiration date of noncash security deposit
38	TOTAL	☐	TOTAL_KK	WERT6	CURR	11	2	Total amount
39	V_SECURITY	☐	SECURITY_KK	SECURITY_KK	CHAR	12	0	Security Deposit	FKK_SEC
40	CASH	☐	CASH_KK	XFELD	CHAR	1	0	Choose: cash security deposit
41	PAID	☐	PAID_KK	WERT6	CURR	11	2	Cash security deposit payment
42	SEC_INTEREST	☐	SEC_INTEREST_KK	WERT6	CURR	11	2	Cash Security Deposit Interest
43	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
44	TEXT1GP	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
45	VKBEZ	☐	VKBEZ_KK	TEXT35	CHAR	35	0	Contract account name
46	VBEZ	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
47	VKBEZ_GUARANTOR	☐	VKBEZ_KK	TEXT35	CHAR	35	0	Contract account name
48	TEXT1GP_GUARANTOR	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
49	APPLK_TXT	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
50	STATUS_TXT	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
51	REASON_TXT	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
52	REV_REASON_TXT	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
53	TYP_TXT	☐	TXT40	TEXT40	CHAR	40	0	Text, length 40
54	OJ_STEXT	☐	OJ_STEXT	TEXT20	CHAR	20	0	Name
55	SWL_SHTEXT	☐	SWL_SHTEXT	TEXT50	CHAR	50	0	Object Name
56	SEC_MONTH	☐	SEC_MONTH_KK	MONAT	NUMC	2	0	Validity Period for Security Deposits in Months
57	MAX_BONIT	☐	MAX_BONIT_KK	BONIT_KK	NUMC	4	0	Max. creditworthiness for refunding a security
58	XEVENT	☐	XEVENT_KK	CHAR1	CHAR	1	0	Trigger Event
59	RELEASED	☐	REL_PART_KK	WERT6	CURR	11	2	Released Part of Cash Security Deposit
60	PYMET	☐	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	TFK042Z
61	TO_RELEASE	☐	TO_RELEASE_KK	WERT6	CURR	11	2	Part of Cash Security Deposit to be Released
62	PWAERS	☐	PWAERS_KK	WAERS	CUKY	5	0	Payment currency	*
63	FWAERS	☐	PWAERS_KK	WAERS	CUKY	5	0	Payment currency	*
64	IWAERS	☐	PWAERS_KK	WAERS	CUKY	5	0	Payment currency	*
65	TWAERS	☐	PWAERS_KK	WAERS	CUKY	5	0	Payment currency	*
66	SEC_TAXES	☐	SEC_TAX_KK	WERT6	CURR	11	2	Taxes on Cash Security Deposits
67	SEC_PAID_TAXES	☐	SEC_PAID_TAX_KK	WERT6	CURR	11	2	Taxes Paid on Cash Security Deposit
68	TXWAERS	☐	BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency	*
69	SEC_NBETRW	☐	SEC_NBETRW_KK	WERT6	CURR	11	2	Cash Security Deposit: Requested Amount Net
70	NBTWWAERS	☐	BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency	*
71	REVERSED	☐	REVSEC_KK	XFELD	CHAR	1	0	Display Reversed Security Deposits
72	TXT1GP	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
73	S_STATUS_S	☐	S_STATUS_KK_S	NUM2	NUMC	2	0	Status of Cash/Non-Cash Security Deposit
74	S_STATUS_TEXT	☐	S_STATUS_TEXT_KK_	CHAR40	CHAR	40	0	Description of Status of Cash/Non-Cash Security Deposit
75	.INCLUDE	☐				0	0	Include Cash Security Deposit for Telecoms Companies IS-T

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FKK_SEC_D	GPART	BUT000	PARTNER	REF	C	CN
2	FKK_SEC_D	GPART_GUARANTOR	BUT000	PARTNER	REF	C	CN
3	FKK_SEC_D	IKEY	TFK056A	IKEY	KEY
4	FKK_SEC_D	MANDT	T000	MANDT	KEY	C	CN
5	FKK_SEC_D	NC_STATUS	TFK_SEC_STATUS	NC_STATUS	REF	C	CN
6	FKK_SEC_D	OBJTYPE	TOJTB	NAME	REF	C	CN
7	FKK_SEC_D	OPBEL	DFKKKO	OPBEL	REF	C	CN
8	FKK_SEC_D	PYMET	TFK042Z	ZLSCH
9	FKK_SEC_D	REASON	TFK_SEC_REASON	REASON	REF	C	CN
10	FKK_SEC_D	REV_REASON	TFK_SEC_REV	REV_REASON	REF	C	CN
11	FKK_SEC_D	SECURITY	FKK_SEC	SECURITY	KEY	C	CN
12	FKK_SEC_D	TYP	TFK_SEC_TYPE	TYP	REF	C	CN
13	FKK_SEC_D	VKONT	FKKVK	VKONT	REF	C	CN
14	FKK_SEC_D	VKONT_GUARANTOR	FKKVK	VKONT	REF	C	CN
15	FKK_SEC_D	V_SECURITY	FKK_SEC	SECURITY		C	CN
16	FKK_SEC_D	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in