SAP ABAP Table U_30070 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_30070	Table Relationship Diagram
Short Description	Generated Table for View

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	VERTRAG	☑	VERTRAG	VERTRAG	CHAR	10	0	Contract
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TESPT
5	EIGENVERBR	☐	EIGENVERBR	EIGENVERBR	CHAR	1	0	Plant or company consumption
6	KOFIZ	☐	E_KOFIZ	E_KOFIZ	CHAR	2	0	Account determination ID for IS-U contracts	TE097
7	PORTION	☐	PORTIONABW	PORTION	CHAR	8	0	Alternative portion	TE420
8	ABSLANFO	☐	ABSLANFO	ABSLANFOAB	CHAR	1	0	Budget billing request for debtor
9	ABSZYK	☐	ABSZYKV	ABSZYKV	CHAR	2	0	Overrriding BB cycle on contract level
10	ABSMNANP	☐	ABSMNANP	AS4FLAG	CHAR	1	0	Do not adjust budget billing amount automatically
11	GEMFAKT	☐	E_GEMFAKT	E_GEMFAKT	CHAR	1	0	Invoice Contracts Jointly (Mandatory Contracts)
12	MANABR	☐	MANABR	KENNZX	CHAR	1	0	Bill contract manually
13	ABRSPERR	☐	ABRSPERR	ABRSPERR	CHAR	2	0	Reason for blocking billing	TE021
14	ABRFREIG	☐	ABRFREIG	ABRFREIG	CHAR	2	0	Reason for releasing billing	TE023
15	BSTATUS	☐	BEARKZ	BEARSTAT	CHAR	2	0	Processing status	TE643
16	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
17	VBEZ	☐	E_VBEZ	TEXT35	CHAR	35	0	Text for contract
18	VBEGINN	☐	E_VBEGINN	DATUM	DATS	8	0	Start of contract
19	VENDE	☐	E_VENDE	DATUM	DATS	8	0	End of contract
20	KUENDDAT	☐	KUENDAT	DATUM	DATS	8	0	Cancellation date of contract
21	KFRIST	☐	KUENZEIT	PERWERT	NUMC	3	0	Number of time units for cancellation
22	KUENPER	☐	KUENPER	PERART	CHAR	1	0	Time unit for cancellation
23	VBISDAT	☐	E_VBISDAT	DATUM	DATS	8	0	Renewal date of contract
24	VERLAENG	☐	VERZEIT	PERWERT	NUMC	3	0	Number of time units for renewal
25	VERPER	☐	VERPER	PERART	CHAR	1	0	Time unit for renewal
26	VABSCHLEVU	☐	E_VSCHLEVU	DATUM	DATS	8	0	Date on which utility concluded the contract
27	VABSCHLKND	☐	E_VSCHLKND	DATUM	DATS	8	0	Date on which customer concluded the contract
28	PERSNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
29	VREFER	☐	E_VREFER	TEXT20	CHAR	20	0	Contract number from legacy system
30	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
31	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
32	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
33	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
34	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
35	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
36	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation
37	VKONTO	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
38	KZSONDAUSZ	☐	KZSONDAUSZ	KZSONDAUSZ	CHAR	1	0	Special move-out processing case exists
39	AUTEIGEINZ	☐	AUTEIGEINZ	KENZX	CHAR	1	0	Automatic Owner Move-In
40	EINZDAT	☐	EINZDAT	DATUM	DATS	8	0	Move-In Date
41	AUSZDAT	☐	AUSZDAT	DATUM	DATS	8	0	Move-Out Date
42	ABSSTOPDAT	☐	ABSSTOPDAT	DATUM	DATS	8	0	Stop date for budget bill. requests in the case of move-out
43	SCHLFAKT	☐	SCHLFAKT	E_GEMFAKT	CHAR	1	0	Joint final billing for move-in/out
44	BEZUG	☐	BEZUG	KENNZX	CHAR	1	0	Reference

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_30070	ABRFREIG	TE023	ABRFREIG		1	CN
2	U_30070	ABRSPERR	TE021	ABRSPERR		1	CN
3	U_30070	BSTATUS	TE643	BEARKZ
4	U_30070	BUKRS	T001	BUKRS
5	U_30070	KOFIZ	TE097	KOFIZ		1	CN
6	U_30070	KOSTL	CSKS	KOSTL
7	U_30070	MANDT	T000	MANDT
8	U_30070	PORTION	TE420	TERMSCHL		1	CN
9	U_30070	SPARTE	TESPT	SPARTE	REF	1	CN
10	U_30070	VKONTO	FKKVK	VKONT		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in