SAP ABAP Table VIGW_S_ARFLZ (Struktur über View Architektonische Flächen incl. Texte)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-MI (Application Component) Migration
     ⤷ RE_MI_CR (Package) RE: Migration CRE (Data Dictionary Only)

Basic Data

Table Category	INTTAB	Structure
Structure	VIGW_S_ARFLZ	Table Relationship Diagram
Short Description	Struktur über View Architektonische Flächen incl. Texte

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	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ARFLNO	☐	VIGWARFLNO	VVINTRENO	CHAR	13	0		VIGWARFL
4	VERSION	☐	VIGWSVERSION	VIGWVERSION	NUMC	4	0	Version Indicator
5	DGUELBIS	☐	VIGWSGUELBIS	DDAT	DATS	8	0	Date: Valid To
6	DGUELAB	☐	VIGWGUELAB	DDAT	DATS	8	0	Valid-from date
7	FLLBEZ	☐	VIGWARFLBEZ	XTEXT30	CHAR	30	0	Flächenbezeichnung einer arch. Fläche
8	DTRAGFKT	☐	VIGWFTRAGFKT	VIGWFTRAGFKT	QUAN	11	3	Durchschnittliche Tragfähigkeit der Bodenfläche
9	TFEINHT	☐	VIGWFTFEINHT	MEINS	UNIT	3	0		T006
10	DRAUMHOE	☐	VIGWFRAHOEHE	VIGWFRAHOEHE	QUAN	11	3
11	RHEINHT	☐	VIGWFRHEINHT	MEINS	UNIT	3	0		T006
12	UMBRAUM	☐	VIGWFUMBRAUM	VIGWFUMBRAUM	QUAN	11	3
13	REINHT	☐	VIGWFREINHT	MEINS	UNIT	3	0		T006
14	FLOT	☐	VIGWARFLOT	VIGWFLOT	NUMC	4	0	Arch. Flächentyp	TIG03AR
15	FLAA	☐	VIGWARFLAA	VIGWFLAA	NUMC	10	0		TIG01AR
16	OBJNR	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	ONR00
17	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
18	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
19	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
20	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
21	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
22	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
23	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
24	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
25	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
26	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
27	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
28	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
29	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
30	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
31	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
32	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
33	FLID	☐	VIGWASPID	VIGWFFLID	CHAR	13	0
34	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
35	FLOTTXT	☐	VIGWARFLOTTXT	TXT50	CHAR	50	0	Architektonische Flächentypbezeichnung
36	XSTOCKK	☐	VVXSTOCKK	VVXSTOCKK	CHAR	4	0	Short name of floor

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIGW_S_ARFLZ	ARFLNO	VIGWARFL	MANDT	KEY	1	CN
2	VIGW_S_ARFLZ	BUKRS	T001	BUKRS
3	VIGW_S_ARFLZ	FLAA	TIG01AR	ARFLAA	KEY	1	CN
4	VIGW_S_ARFLZ	FLOT	TIG03AR	FLOT
5	VIGW_S_ARFLZ	MANDT	T000	MANDT	KEY	1	CN
6	VIGW_S_ARFLZ	OBJNR	ONR00	OBJNR	KEY	1	CN
7	VIGW_S_ARFLZ	REINHT	T006	MSEHI
8	VIGW_S_ARFLZ	RHEINHT	T006	MSEHI
9	VIGW_S_ARFLZ	SGEBT	TIV12	SGEBT
10	VIGW_S_ARFLZ	SGENR	VIOB03	SGENR
11	VIGW_S_ARFLZ	SGRNR	VIOB02	SGRNR
12	VIGW_S_ARFLZ	SSTOCKW	TIV37	SSTOCKW
13	VIGW_S_ARFLZ	SWENR	VIOB01	SWENR
14	VIGW_S_ARFLZ	TFEINHT	T006	MSEHI

History

Last changed by/on	SAP	20020219
SAP Release Created in