SAP ABAP Table VISCRIPT (RE: Correspondence - Additional Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	VISCRIPT	Table Relationship Diagram
Short Description	RE: Correspondence - Additional Fields

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	ANRED_MIET	☐	ANRED	TEXT15	CHAR	15	0	Title
2	NAME1_MIET	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
3	STRAS_MIET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
4	LAND1_MIET	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
5	PSTLZ_MIET	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
6	ORT01_MIET	☐	ORT01_GP	TEXT35	CHAR	35	0	City
7	RETURNDATE	☐	RET_DATE	DDAT	DATS	8	0	Date for returning the answer
8	KAUTARTTXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
9	ZAHLWTXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
10	ERHBTR	☐	ERHBTR	WRTV7	CURR	13	2	Increase amount after rent adjustment
11	DRUCKDTM	☐	DRUCKDTM	DATS	DATS	8	0	Print date for letters in Real Estate Management
12	ZAHLWEGTXT	☐	TEXT1_042Z	TEXT30	CHAR	30	0	Name of Payment Method in Language of the Country
13	RPROMHG	☐	VVRPROMHG	NUMC2	NUMC	2	0	Yearly rent surcharge percentage rate
14	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
15	ISOCD	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
16	MGKZIFFER	☐	MGKZIFFER	NUMC2	NUMC	2	0	Rent Index Clause Number
17	MIETJAHRE	☐	MIETJAHRE	NUMC3	NUMC	3	0	Term of tenancy in years
18	OPTJAHRE	☐	OPTJAHRE	NUMC3	NUMC	3	0	Renewal of lease for ... years
19	ZFBMONAT	☐	VVZFBMONAT	NUM2	NUMC	2	0	Base month for due date calculation
20	ZFBJAHR	☐	VVZFBJAHR	GJAHR	NUMC	4	0	Base year for due date calculation
21	BTKLNULL	☐	VVBTKLNULL	XFELD	CHAR	1	0	Indicator: Amount has negative sign
22	RCHNNG	☐	VVRCHNNG	CHAR028	CHAR	28	0	Invoice number
23	BINDDIFF	☐	BINDDIFF	DEC5_3	DEC	8	3	Index marker difference
24	OPTRDJ	☐	VVOPTRDJ	NUMC2	NUMC	2	0	Length of preemptive right in years
25	CNT_MV	☐	NUM5	NUM5	NUMC	5	0	Internal pointer
26	DGKUE	☐	VVDGKUE	DDAT	DATS	8	0	Legal date of notice
27	MZST	☐	VVMZST	XFELD	CHAR	1	0	Indicator: Tenant assessed for tax
28	LTTRDATE	☐	VVLTTRDATE	DDAT	DATS	8	0	Date of the letter which this appendix belongs to
29	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
30	JKBLL	☐	VVJKBLL	XFELD	CHAR	1	0	Indicator to create long version of tenant account sheet
31	JKOBLLST	☐	VVJKOBLLST	XFELD	CHAR	1	0	Indicator: Tenant account sheet item table as list on screen
32	JSGTXT	☐	VVJSGTXT	XFELD	CHAR	1	0	Indicator: Disp.item text in tenant acct sheet long version
33	SPRSLRCP	☐	VVSPRSLRCP	SPRAS	LANG	1	0	Language key for texts for letter printout	*
34	BSALDO	☐	VVBSALDO	WRTV8	CURR	15	2	Balance carried forward in document currency
35	HWAERS	☐	VVHAUSWHR	WAERS	CUKY	5	0	Local currency of company code	*
36	BSALDOH	☐	VVBSALDOH	WRTV8	CURR	15	2	Balance carried forward in local currency
37	KOBLBEG	☐	VVKOBLBEG	DDAT	DATS	8	0	Tenant acct sheet: Start date for cleared items
38	KOBLEND	☐	VVKOBLEND	DDAT	DATS	8	0	Tenant acct sheet: End date for open/cleared items
39	JOPVORH	☐	VVJOPVORH	XFELD	CHAR	1	0	Indicator: OI's exist in tenant account sheet
40	JAPVORH	☐	VVJAPVORH	XFELD	CHAR	1	0	Indicator: Cleared items exist in tenant account sheet
41	JKOBLMHN	☐	VVJKOBLMHN	XFELD	CHAR	1	0	Indic.for tenanct acct sheet call-up from dunn.not.printout
42	IHPZS	☐	VVIHPZS	DEC5_3	DEC	8	3	New mortgage interest rate
43	IHPZSALT	☐	VVIHPZSALT	DEC5_3	DEC	8	3	Old mortgage interest rate
44	ITEUR	☐	VVITEUR	DEC5_3	DEC	8	3	Stand.liv.index
45	ITEURALT	☐	VVITEURALT	DEC5_3	DEC	8	3	Old standard of living index
46	JWBNLHD	☐	VVJWBNLHD	XFELD	CHAR	1	0	Indicator: Dutch apartment val., line with feature category
47	JWBNLMML	☐	VVJWBNLMML	XFELD	CHAR	1	0	Indicator: Dutch apartment val., line with feature/points
48	JWBNLSUM	☐	VVJWBNLSUM	XFELD	CHAR	1	0	Indicator: Dutch apartment val., line with total of points
49	JWBNLRA	☐	VVJWBNLRA	XFELD	CHAR	1	0	Indcator: Apartment valuation NL, line with room type
50	JKUENDCH	☐	VVJKUENDCH	XFELD	CHAR	1	0	Indicator: Notice under Swiss law
51	JREPETPR	☐	VVREPETPR	XFELD	CHAR	1	0	Repetition run for debited open items
52	DERSTDRUCK	☐	DERSTDRUCK	DATS	DATS	8	0	Date of first letter print in Real Estate Management
53	DMELD01V	☐	DMELD01V	DDAT	DATS	8	0	Reporting Interval Start for Sales-Based Lease-Out
54	DMELD01B	☐	DMELD01B	DDAT	DATS	8	0	End of Reporting Interval for Sales-Based Lease-Out
55	DGULTAB	☐	DGULTAB	DDAT	DATS	8	0	Date from when assignment is valid
56	DGULTBIS	☐	DGULTBIS	DDAT	DATS	8	0	Date up to when the assignment is valid
57	DOPVON	☐	VVDOPVON	DDAT	DATS	8	0	Tenant account sheet: Start date for open items
58	DOPBIS	☐	VVDOPBIS	DDAT	DATS	8	0	Tenant account sheet: End date for open items
59	DAPVON	☐	VVDAPVON	DDAT	DATS	8	0	Tenant acct sheet: Start date for cleared items
60	DAPBIS	☐	VVDAPBIS	DDAT	DATS	8	0	Tenant account sheet: End date for cleared items
61	SWHRKNDCUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	TCURC
62	XKWHRKCUK	☐	XWHRKCUKK	TEXT15	CHAR	15	0	RE: Short Text of Second Currency for Correspondence
63	XLWHRKCUK	☐	XWHRKCUKL	TEXT40	CHAR	40	0	RE: Long Text of Second Currency for Correspondence
64	DEXCHCUK	☐	VVDEXCH	SYDATS	DATS	8	0	Translation date for second currency
65	DINVFROM	☐	VVDINVFROM	DDAT	DATS	8	0	Start Date for Due Period of Open Items
66	DINVTO	☐	VVDINVTO	DDAT	DATS	8	0	End Date for Due Period of Open Items
67	JFLATRATE	☐	VVJFLATRTE	XFELD	CHAR	1	0	Indicator: Flat rates in SCS correspondence available
68	JDONT_ARCH	☐	VVDONT_ARCH	XFELD	CHAR	1	0	Do Not Archive Correspondence
69	.INCLUDE	☐				0	0	RE-WB: WiBe-Felder für allg. Korrespondenzschnittstelle
70	DDATE	☐	VVWBDATE	DATE	DATS	8	0	Stichtag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VISCRIPT	SWHRKNDCUK	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in