SAP ABAP Table VTVDETA_CFM_PL (CFM Operative/Parallel: Profit/Loss Reporting)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI (Package) Application development R/3 Treasury information system

Basic Data

Table Category	INTTAB	Structure
Structure	VTVDETA_CFM_PL	Table Relationship Diagram
Short Description	CFM Operative/Parallel: Profit/Loss Reporting

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	.INCLUDE	☐				0	0	Treasury: Revenue and Cash Flow Information
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
5	TR_ACC_CODE	☐	TPM_ACC_CODE	TPM_ACC_CODE	CHAR	4	0	Accounting Code	TRGC_TR_ACC_CODE
6	VALUATION_AREA	☐	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
7	VALUATION_CLASS	☐	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class	TRGC_VAL_CLASS
8	ACTIVE_PASSIVE	☐	TPM_ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	CHAR	1	0	Indicator: Assets/Liabilities Position
9	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
10	PORTFOLIO	☐	TPM_PORTFOLIO_DIFF	RPORTB	CHAR	10	0	Portfolio as Differentiation Characteristic	TWPOB
11	SECURITY_ID	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
12	LOANS_CONTRACT	☐	RANL	RANL	CHAR	13	0	Contract Number	VDARL
13	DEAL_NUMBER	☐	FTI_POSRFHA	T_RFHA	CHAR	13	0	Financial Transaction That Creates a Position	VTBFHA
14	HEDGE_ID	☐	THM_HEDGE_ID	THM_HEDGE_ID	NUMC	10	0	Hedge Item Identification Number	*
15	ACCOUNT_GROUP	☐	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group	TRGT_SECACCGRP
16	SECURITY_ACCOUNT	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
17	POSITION_ACCOUNT	☐	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures	TRFT_POS_ACCOUNT
18	FLAG_LONG_SHORT	☐	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
19	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
20	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
21	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
22	LOTGENERATION_USER	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
23	LOTGENERATION_BUSTRANSCAT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	TRDTS_BT_CAT
24	LOTPOS_INIT_DATE	☐	FTI_LOTPOSITION_INIT_DATE	TPM_POSITION_DATE	DATS	8	0	Position Acquisition Date of a Lot
25	LOTPOS_ORG_DATE	☐	FTI_LOTPOSITION_ORG_DATE	TPM_POSITION_DATE	DATS	8	0	Original Position Acquisition Date of a Lot
26	LOTGEN_BUKRS	☐	FTI_LOTGENERATION_BUKRS	BUKRS	CHAR	4	0	Company Code of Lot-Generating Transaction	*
27	LOTGEN_DEALNR	☐	FTI_LOTGENERATION_DEALNR	T_RFHA	CHAR	13	0	Lot-Generating Transaction Number	*
28	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
29	RANTYP_R	☐	FTI_RANTYP	FTI_RANTYP	CHAR	1	0	Contract type
30	RREFKONT_R	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
31	ACC_ASS_REF	☐	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management	TRACC_AA_REF
32	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
33	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
34	.INCLUDE	☐				0	0	Quasi Key Figures Occurring in Position and Flow Lists
35	RLZTG_F	☐	FTI_RLZTG_F	NUMC5	NUMC	5	0	Remaining Term in Days
36	RLZMO_F	☐	FTI_RLZMO_F	NUMC4	NUMC	4	0	Remaining Term in Months
37	RLZJA_F	☐	FTI_RLZJA_F	NUMC3	NUMC	3	0	Remaining Term in Years
38	UEBTG_F	☐	FTI_UEBTG_F	NUMC5	NUMC	5	0	Overdue Period in Days
39	UEBMO_F	☐	FTI_UEBMO_F	NUMC3	NUMC	3	0	Overdue Period in Months
40	UEBJA_F	☐	FTI_UEBJA_F	NUMC2	NUMC	2	0	Overdue Period in Years
41	.INCLUDE	☐				0	0	Include for Data of Commitment Partner (->LDBs)
42	.INCLUDE	☐				0	0	Treasury: Commitment Partner
43	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
44	.INCLUDE	☐				0	0	Treasury: Partner Attributes
45	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
46	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
47	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
48	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
49	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
50	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
51	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
52	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
53	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
54	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
55	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
56	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
57	.INCLUDE	☐				0	0	Business partner credit standing data
58	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
59	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
60	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
61	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
62	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
63	.INCLUDE	☐				0	0	Include for Transaction Attributes Rel. for Position (->LDB)
64	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
65	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
66	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
67	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
68	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
69	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
70	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
71	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
72	PORTFOLIO_TM	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
73	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
74	RDPBANK	☐	RDEPOTBANK	BU_PARTNER	CHAR	10	0	Depository Bank	BUT000
75	SECACC_TYPE	☐	TPM_SECACC_TYPE	TPM_SECACC_TYPE	CHAR	3	0	Securities Account Type	TRSC_SECACC_TYPE
76	SECACC_CAT	☐	TPM_SECACC_CAT	TPM_SECACC_CAT	CHAR	1	0	Securities Account Category
77	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
78	.INCLUDE	☐				0	0	Include for Time-Dependent Class Data (-> LDBs)
79	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
80	ALWPKL	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	TW22
81	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	TW20
82	SOL_INS_RANL	☐	FTI_SOL_INS_RANL	BP_SOL_INS	CHAR	4	0	Institut Supplying Credit Rating Information for Secur. ID	TP07
83	RATING_RANL	☐	BP_RATING_RANL	BP_RATING	CHAR	3	0	Rating for Securities ID Number/OTC Transaction	TP06
84	SWPKLASS	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	TW01
85	SAKAR	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
86	SFOART	☐	VVSFOART	VVSFOART	CHAR	2	0	Fund category indicator
87	SFOTY	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	TW21
88	SARTBET	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	TW02
89	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
90	VVRANLWX	☐	VVRANLWXS	CHAR20S	CHAR	20	0	Secondary index class data
91	AAAAKTIE_E	☐	FTI_AAAKTIE_E	DEC12	DEC	12	0	Number of Stocks Issued: End
92	KBNEWE_E	☐	FTI_VVBNEWE_E	VVKWKURS	DEC	15	6	Nominal Value per Stock (Independent of Currency)
93	KZAHLAKT_E	☐	FTI_KZAHLAKT_E	DEC3_7	DEC	10	7	Pay-in rate
94	PKOND_E	☐	FTI_PKOND_E	DECV3_7	DEC	10	7	Interest rate - end
95	BKOND_E	☐	FTI_BKOND_E	WERTV7	CURR	13	2	Interest Rate as Amount: End
96	PEFFZINS_E	☐	FTI_PEFFZINS_E	DEC3_7	DEC	10	7	Effective Interest Rate at End of Period
97	SHWHR	☐	TB_SHWHR	WAERS	CUKY	5	0	Local Currency	TCURC
98	SVWHR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	TCURC
99	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
100	ANZGW	☐	FTI_ANZGW	WAERS	CUKY	5	0	Display Currency	TCURC
101	SWHRKOND	☐	TB_WHRKOND	WAERS	CUKY	5	0	Interest Currency	TCURC
102	WVERB1	☐	FTI_WHR_SHORT	WAERS	CUKY	5	0	Nominal currency borrowing/sale/outgoing side/short	TCURC
103	WFORD1	☐	FTI_WHR_LONG	WAERS	CUKY	5	0	Nominal currency investment/purchase incoming side/long	TCURC
104	DBEWEG	☐	DBEWEG	DATUM	DATS	8	0	Flow Date
105	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
106	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
107	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
108	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
109	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
110	JAHR	☐	TB_JAHR	GJAHR	NUMC	4	0	Calendar year
111	MONAT	☐	TB_MONAT	TB_MONAT	NUMC	2	0	Calendar month
112	WOCHE	☐	FTI_WOCHE	NUMC2	NUMC	2	0	Calendar Week
113	MONAT_JAHR	☐	FTI_MONTH_YEAR	MCPERIOD	NUMC	6	0	Calendar Month/Year
114	WOCHE_JAHR	☐	FTI_WEEK_YEAR	MCPERIOD	NUMC	6	0	Calendar Week/Year
115	SE_DEAL_NUMBER	☐	FTI_SE_RFHA	T_RFHA	CHAR	13	0	Securities/Futures Transaction	*
116	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	BUT000
117	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	TWH01
118	JFDBUC	☐	FTI_FDBUC	FTI_FDBUC	CHAR	1	0	Relevance to CM
119	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
120	BANKK_HB	☐	FTI_BANKK	BANKK	CHAR	15	0	Bank key of house bank
121	BANKN_HB	☐	FTI_BANKN	BANKN	CHAR	18	0	Bank account number of house bank
122	BANKK_BP	☐	FTI_BANKKP	BANKK	CHAR	15	0	Bank key of business partner bank
123	BANKN_BP	☐	FTI_BANKNP	BANKN	CHAR	18	0	Bank account number of business partner
124	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
125	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
126	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
127	.INCLUDE	☐				0	0	Include for FI Document Data/Filling FI Document Data ->LDB
128	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
129	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
130	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	SKB1
131	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	SKB1
132	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
133	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
134	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
135	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
136	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
137	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
138	BUCHST	☐	BUCHST_CFM	BUCHST_CFM	CHAR	1	0	Posting Status of Flow for CFM (Operative Only)
139	TRL_BOOKINGSTATE	☐	BUCHST_CFM_PAR	TPM_TRL_BOOKINGSTATE	CHAR	1	0	Position Status of Flow for CFM (Parallel Only)
140	SBEWART_R	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
141	FLOW_TYPE	☐	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
142	GSVGANG	☐	GSVGANG	GSVGANG	NUMC	3	0	TR transaction activity for securities
143	BUSTRANSCAT	☐	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
144	SOURCETARGET_FLG	☐	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
145	PL_CATEGORY	☐	TPM_PL_CATEGORY	TPM_PL_CATEGORY	CHAR	3	0	P/L Type	TRGC_PL_CATE
146	KMNR	☐	KMNR	VKMNR	CHAR	13	0	Corporate Action Number	VWKMKO
147	WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	TCURC
148	SPLWHR	☐	SPLWHR	WAERS	CUKY	5	0	Profit/loss currency	TCURC
149	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
150	CF_CC	☐	FTI_PAYAMOUNT_PYC	TPM_AMOUNT	CURR	21	2	Payment amount in payment currency
151	CF_LC	☐	FTI_PAYAMOUNT_LC	TPM_AMOUNT	CURR	21	2	Payment Amount in Local Currency
152	CF_DC	☐	FTI_PAYAMOUNT_DC	TPM_AMOUNT	CURR	21	2	Payment Amount in Display Currency
153	PL_PC	☐	FTI_PLAMOUNT_PLC	TPM_AMOUNT	CURR	21	2	Profit/loss amount in profit/loss currency
154	PL_LC	☐	FTI_PLAMOUNT_LC	TPM_AMOUNT	CURR	21	2	Profit/loss amount in local currency
155	PL_DC	☐	FTI_PLAMOUNT_DC	TPM_AMOUNT	CURR	21	2	Profit/Loss Amount in Display Currency
156	PABGERF_PC	☐	FTI_PERACC_PLC	TPM_AMOUNT	CURR	21	2	Revenue Accrued/Deferred in Profit/Loss Currency
157	PABGERF_VC	☐	FTI_PERACC_VC	TPM_AMOUNT	CURR	21	2	Period-Based Revenue Accrued/Deferred in Valuation Currency
158	PABGERF_LC	☐	FTI_PERACC_LC	TPM_AMOUNT	CURR	21	2	Revenue Accrued/Deferred in Local Currency
159	PABGERF_DC	☐	FTI_PERACC_DC	TPM_AMOUNT	CURR	21	2	Revenue Accrued/Deferred in Display Currency
160	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
161	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
162	MPKOND_A	☐	MPKOND_A	FTI_NUMC3	NUMC	3	0	Interest rate - start (drilldown reporting characteristic)
163	MPKOND_E	☐	MPKOND_E	FTI_NUMC3	NUMC	3	0	Interest rate - end (drilldown reporting characteristic)
164	PKOND_A	☐	FTI_PKOND_A	DECV3_7	DEC	10	7	Interest rate: Start
165	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
166	RSTICH_PB	☐	FTI_RSTICH_PB	RSTICH_PB	CHAR	1	0	Key Date Reference for Parallel Books
167	.INCLUDE	☐				0	0	Actual Key Figures Occurring in Position and Flow Lists
168	RLZTG_K_F	☐	FTI_RLZTGK_F	DEC7	DEC	7	0	Remaining Term in Days (Key Figure)
169	UEBTG_K_F	☐	FTI_UEBTGK_F	DEC7	DEC	7	0	Overdue Period in Days (Key Figure)
170	SARCHIV	☐	SARCHIV	SARCHIV	CHAR	1	0	Archiving Category Indicator
171	.INCLUDE	☐				0	0	Additional Treasury Selections
172	NUMBR	☐	CFNUMBR	CFNUMBR	NUMC	3	0	Number of translation key in currency translation	T242Q
173	NUMBR_LC	☐	FTI_NUMBR_LC	CFNUMBR	NUMC	3	0	Translation Type for Currency Translation into Local Crcy	T242Q
174	KURSA	☐	VVKURSAUSW	VVSKURSART	CHAR	2	0	Price type for evaluations	TW56
175	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
176	VVRANLWI	☐	VVRANLWI	VVRANLWI	NUMC	2	0	No. of the secondary index description for class data	TWX1
177	CASHF	☐	SCASHFLOW	XFELD	CHAR	1	0	Indicator for cash flow calculation up to end of term
178	BILST	☐	FTI_BILST	DATUM	DATS	8	0	Reference Date
179	BILST2	☐	FTI_BILST2	DATUM	DATS	8	0	Reference Date
180	BILST_REF_B	☐	FTI_BILST_REF_B	FTI_BILST_REF_B	CHAR	1	0	Positions: Remaining Term/Overdue Period Based On
181	BILST_REF_F	☐	FTI_BILST_REF_F	FTI_BILST_REF_F	CHAR	1	0	Flows: Remaining Term/Overdue Period Based On
182	STORNO	☐	FTI_STORNO	XFELD	CHAR	1	0	Evaluate Reversed Flows
183	AUSWT	☐	FTI_EVALTYPE	JBREVAL	CHAR	4	0	Evaluation Type (Risk Management)	JBREVAL
184	FLG_SE	☐	FTI_LDB_FLG_SE	XFELD	CHAR	1	0	Product Group Securities: Yes/No
185	FLG_LO	☐	FTI_LDB_FLG_LO	XFELD	CHAR	1	0	Product Group Loans: Yes/No
186	FLG_OTC	☐	FTI_LDB_FLG_OTC	XFELD	CHAR	1	0	Product Group OTC (MM, FX, DE): Yes/No
187	FLG_LOF	☐	FTI_LDB_FLG_LOF	XFELD	CHAR	1	0	Product Group Listed Derivatives (Futures): Yes/No
188	FLG_COUPLING_SECACCGRP	☐	FTI_LDB_FLG_COUPLING_SECACCGRP	XFELD	CHAR	1	0	Interpret Assignment of Sec. Account to Sec. Account Group
189	FLG_HISTORIC_ACCASSREF	☐	FTI_LDB_FLG_HISTORIC_ACCASSREF	XFELD	CHAR	1	0	Indicator: Historical Account Assignment Reference
190	FLG_CONDENSE	☐	FTI_CONDENSE	XFELD	CHAR	1	0	Summarize Results (for Query)
191	FLG_NO_NULL	☐	FTI_NO_NULL	XFELD	CHAR	1	0	Hide Zero Records
192	FLG_EXCLUDING_PLAN	☐	FTI_EXCL_PLAN	XFELD	CHAR	1	0	Exclude Plan Data (for Query)
193	FLG_REVERSED_FLOWS	☐	FTI_REVERSED_FLOWS	XFELD	CHAR	1	0	Process Reversed Flows (for Query)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVDETA_CFM_PL	ACCOUNT_GROUP	TRGT_SECACCGRP	SEC_ACCT_GRP
2	VTVDETA_CFM_PL	ACC_ASS_REF	TRACC_AA_REF	AA_REF
3	VTVDETA_CFM_PL	ALWPKL	TW22	ALWPKL
4	VTVDETA_CFM_PL	ANZGW	TCURC	WAERS
5	VTVDETA_CFM_PL	AUSWT	JBREVAL	AUSWERTUNG
6	VTVDETA_CFM_PL	BUKRS	T001	BUKRS
7	VTVDETA_CFM_PL	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
8	VTVDETA_CFM_PL	CNTRY_COMP	T005	LAND1
9	VTVDETA_CFM_PL	DEAL_NUMBER	VTBFHA	RFHA
10	VTVDETA_CFM_PL	FLOW_TYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE
11	VTVDETA_CFM_PL	GL_ACCOUNT_C	SKB1	SAKNR
12	VTVDETA_CFM_PL	GL_ACCOUNT_D	SKB1	SAKNR
13	VTVDETA_CFM_PL	GROUP_D	TP13	GROUP_D
14	VTVDETA_CFM_PL	GROUP_ID	TB001	BU_GROUP
15	VTVDETA_CFM_PL	GSART	TZPA	GSART
16	VTVDETA_CFM_PL	IND_SECTOR	TB038A	IND_SECTOR
17	VTVDETA_CFM_PL	ISTYPE	TB038	ISTYPE
18	VTVDETA_CFM_PL	KMNR	VWKMKO	KMNR
19	VTVDETA_CFM_PL	KURSA	TW56	SKURSART
20	VTVDETA_CFM_PL	LAND1	T005	LAND1
21	VTVDETA_CFM_PL	LEGAL_ENTY	TB019	LEGAL_ENTY
22	VTVDETA_CFM_PL	LEGAL_ORG	TB032	LEGAL_ORG
23	VTVDETA_CFM_PL	LOANS_CONTRACT	VDARL	RANL
24	VTVDETA_CFM_PL	LOTGENERATION_BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
25	VTVDETA_CFM_PL	MANDT	T000	MANDT
26	VTVDETA_CFM_PL	NATION	T005	LAND1
27	VTVDETA_CFM_PL	NUMBR	T242Q	NUMBR
28	VTVDETA_CFM_PL	NUMBR_LC	T242Q	NUMBR
29	VTVDETA_CFM_PL	PARTNR	BUT000	PARTNER
30	VTVDETA_CFM_PL	PERIV	T009	PERIV
31	VTVDETA_CFM_PL	PL_CATEGORY	TRGC_PL_CATE	PL_CATEGORY
32	VTVDETA_CFM_PL	PORTFOLIO	TWPOB	RPORTB		1	CN
33	VTVDETA_CFM_PL	PORTFOLIO_TM	TWPOB	RPORTB
34	VTVDETA_CFM_PL	POSITION_ACCOUNT	TRFT_POS_ACCOUNT	POS_ACCOUNT
35	VTVDETA_CFM_PL	PRKEY	PAYRQ	KEYNO		C	CN
36	VTVDETA_CFM_PL	RAHABKI	T012	HBKID
37	VTVDETA_CFM_PL	RAHKTID	T012K	HKTID
38	VTVDETA_CFM_PL	RATING	TP06	RATING
39	VTVDETA_CFM_PL	RATING_RANL	TP06	RATING
40	VTVDETA_CFM_PL	RDEALER	TZDEA	RDEALER
41	VTVDETA_CFM_PL	RDPBANK	BUT000	PARTNER
42	VTVDETA_CFM_PL	RGARANT	BUT000	PARTNER
43	VTVDETA_CFM_PL	RHANDPL	TWH01	RHANDPL
44	VTVDETA_CFM_PL	RKONTRA	BUT000	PARTNER
45	VTVDETA_CFM_PL	RMAID	VTBMA	RMAID
46	VTVDETA_CFM_PL	RREFKONT_R	T037S	RREFKONT
47	VTVDETA_CFM_PL	SANLF	TZAF	SANLF
48	VTVDETA_CFM_PL	SARTBET	TW02	SARTBET
49	VTVDETA_CFM_PL	SBEWART_R	TZB0A	SBEWART
50	VTVDETA_CFM_PL	SBILK	TW11	SBILK
51	VTVDETA_CFM_PL	SBWHR	TCURC	WAERS
52	VTVDETA_CFM_PL	SECACC_TYPE	TRSC_SECACC_TYPE	SECACC_TYPE
53	VTVDETA_CFM_PL	SECURITY_ACCOUNT	TWD01	RLDEPO
54	VTVDETA_CFM_PL	SECURITY_ID	VWPANLA	RANL
55	VTVDETA_CFM_PL	SFOTY	TW21	SFOTY
56	VTVDETA_CFM_PL	SHWHR	TCURC	WAERS
57	VTVDETA_CFM_PL	SOL_INS	TP07	SOL_INS
58	VTVDETA_CFM_PL	SOL_INS_RANL	TP07	SOL_INS
59	VTVDETA_CFM_PL	SPLWHR	TCURC	WAERS		C	CN
60	VTVDETA_CFM_PL	STAFF_GRP	TP05	STAFF_GRP
61	VTVDETA_CFM_PL	STATE	T005	LAND1
62	VTVDETA_CFM_PL	SVWHR	TCURC	WAERS
63	VTVDETA_CFM_PL	SWERTTYP	TW20	SWERTTYP
64	VTVDETA_CFM_PL	SWHRKOND	TCURC	WAERS
65	VTVDETA_CFM_PL	SWPKLASS	TW01	SWPKLASS
66	VTVDETA_CFM_PL	TR_ACC_CODE	TRGC_TR_ACC_CODE	TR_ACC_CODE
67	VTVDETA_CFM_PL	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA
68	VTVDETA_CFM_PL	VALUATION_CLASS	TRGC_VAL_CLASS	VALUATION_CLASS
69	VTVDETA_CFM_PL	VVRANLWI	TWX1	VVRANLWI
70	VTVDETA_CFM_PL	WFORD1	TCURC	WAERS
71	VTVDETA_CFM_PL	WVERB1	TCURC	WAERS
72	VTVDETA_CFM_PL	WZBETR	TCURC	WAERS
73	VTVDETA_CFM_PL	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20131127
SAP Release Created in	110