SAP ABAP Table VZKOPF (General header structure Treasury)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM (Application Component) Treasury and Risk Management
     ⤷ FTVV (Package) TR - Objects from FVV in both Loans/Securities areas

Basic Data

Table Category	INTTAB	Structure
Structure	VZKOPF	Table Relationship Diagram
Short Description	General header structure Treasury

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	*
2	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RANLVD	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
5	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
6	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
7	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
8	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
9	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
10	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
11	ZUONR	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
12	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
13	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
14	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
15	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
16	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
17	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
18	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
19	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
20	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
21	SZINSTYP	☐	VVSZINSTYP	VVSZINSTYP	CHAR	1	0	Interest type: fixed, variable, other
22	PKOND	☐	TB_PKOND	DECV3_7	DEC	10	7	Interest rate as a percentage
23	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
24	SNOTTYPE	☐	TB_NOTTYPE	T_NOTTYPE	CHAR	1	0	Quotation type for option, future, security etc.
25	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
26	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
27	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
28	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
29	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
30	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	TCURC
31	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	TCURC
32	KKURS	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
33	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
34	BZUSAGE	☐	BZUSAGE	WERTV7	CURR	13	2	Commitment capital
35	SOFTYP	☐	TI_SOFTYP	T_SOFTYP	NUMC	2	0	Options/futures category
36	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
37	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VZKOPF	BUKRS	T001	BUKRS
2	VZKOPF	RANL	VWPANLA	RANL
3	VZKOPF	RANLVD	VDARL	RANL
4	VZKOPF	RFHA	VTBFHA	RFHA
5	VZKOPF	RLDEPO	TWD01	RLDEPO		1	CN
6	VZKOPF	RPORTB	TWPOB	RPORTB
7	VZKOPF	RREFKONT	T037S	RREFKONT
8	VZKOPF	SANLF	TZAF	SANLF
9	VZKOPF	SBILK	TW11	SBILK
10	VZKOPF	SBWHR	TCURC	WAERS
11	VZKOPF	SFGTYP	AT01	SFGTYP
12	VZKOPF	SFGZUSTT	AT02	SFGZUSTT
13	VZKOPF	SFHAART	AT10	SFHAART
14	VZKOPF	SGLZB	TW07	SGLZB
15	VZKOPF	SGSART	TZPA	GSART
16	VZKOPF	SZSREF	T056R	REFERENZ
17	VZKOPF	WGSCHFT1	TCURC	WAERS
18	VZKOPF	WGSCHFT2	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in