SAP ABAP Table BDSMARTFORMS (Smartformübergabe)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-DM-MR (Application Component) Meter Reading
     ⤷ EE17 (Package) IS-U: Meter Reading Data Entry

Basic Data

Table Category	INTTAB	Structure
Structure	BDSMARTFORMS	Table Relationship Diagram
Short Description	Smartformübergabe

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	Registers to be Read for Premise
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
3	GERAET	☐	GERNR	GERNR	CHAR	18	0	Serial Number
4	ZWNUMMER	☐	E_ZWNUMMER	LFDNR3	NUMC	3	0	Register
5	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	*
6	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	*
7	STORTZUS	☐	STORTZUS	TEXT30	CHAR	30	0	Addition to device location
8	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	*
9	PREV_MRRES	☐	E_ZWSTAND	E_ZWSTAND	CHAR	36	0	Meter reading recorded
10	PREV_MRDATE	☐	ADAT	DATUM	DATS	8	0	Meter reading date relevant to billing
11	ZWART	☐	E_ZWART	E_ZWART	CHAR	2	0	Register type	*
12	ZWARTTXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
13	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
14	NO_MRORDER	☐	E_NO_MRODER	KENNZX	CHAR	1	0	Internet Entry: No Meter Reading Order
15	CONT_ACCT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
16	ACCT_NAME	☐	VKBEZ_KK	TEXT35	CHAR	35	0	Contract account name
17	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	*
18	VBEZ	☐	E_VBEZ	TEXT35	CHAR	35	0	Text for contract
19	ADDRESS_FILTER	☐	LINES	LINES	CHAR	80	0	Address line
20	ADDRESS	☐	LINES	LINES	CHAR	80	0	Address line
21	SPARTTXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
22	MASSREAD	☐	E_MASSREAD	MEINS	UNIT	3	0	Unit of measurement for meter reading	*
23	STANZVOR	☐	STANZVOR	STANZVOR	NUMC	2	0	Places before the decimal point in a register
24	STANZNAC	☐	STANZNAC	STANZNAC	NUMC	2	0	Places after the decimal in a register
25	LAST_DATE	☐			CHAR	8	0
26	REGKENNZIFF	☐	KENNZIFF	CHAR15	CHAR	15	0	Code for Identifying a Register
27	REGEXT_UI	☐	EXT_UI	EXT_UI	CHAR	50	0	Point of delivery ID
28	MS_MULTI	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
29	.INCLUDE	☐				0	0	BAPI Upload Structure for MR Document
30	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
31	SERIALNO	☐	GERNR	GERNR	CHAR	18	0	Serial Number
32	REGISTER	☐	E_ZWNUMMER	LFDNR3	NUMC	3	0	Register
33	MRREASON	☐	ABLESGR	ABLESGR	CHAR	2	0	Meter reading reason	TE609
34	MRIDNUMBER	☐	ABLBELNR	ABLBELNR	CHAR	20	0	Internal ID for meter reading document	EABL
35	READINGRESULT	☐	READINGRESULT	READINGRESULT	CHAR	32	0	Meter reading recorded
36	METERREADINGNOTE	☐	ABLHINW	ABLHINW	CHAR	4	0	Note from meter reader	TE259
37	ACTUALCUSTOMERMRTYPE	☐	ISTABLART	ISTABLART	CHAR	2	0	Meter reading type	TE436
38	METERREADER	☐	ABLESER	ABLESER	CHAR	3	0	Meter reader number	TE115
39	MRDATEFORBILLING	☐	ADAT	DATUM	DATS	8	0	Meter reading date relevant to billing
40	MRTIMEFORBILLING	☐	ATIM	HHMM	CHAR	4	0	Meter reading time (relevant to billing)
41	ACTUALMRDATE	☐	ADATTATS	DATUM	DATS	8	0	Actual meter reading date
42	ACTUALMRTIME	☐	ATIMTATS	HHMM	CHAR	4	0	Actual meter reading time
43	MRDATEOFMAXIMUM	☐	ADATMAX	DATUM	DATS	8	0	Date of maximum meter reading
44	MRTIMEOFMAXIMUM	☐	ATIMMAX	HHMM	CHAR	4	0	Time of maximum meter reading
45	SMORDER	☐	SM_AUFNR	AUFNR	CHAR	12	0	Service order or service notification number	AUFK
46	ACTIVE	☐	E_AKTIV	E_AKTIV	CHAR	1	0	Meter reading active
47	REFNUMBER	☐	KENNZIFF	CHAR15	CHAR	15	0	Code for Identifying a Register
48	TARGETMRDATE	☐	ADATSOLL_UPL	DATS	DATS	8	0	Planned Meter Reading Date (for Upload)
49	EXT_UI	☐	EXT_UI	EXT_UI	CHAR	50	0	Point of delivery ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BDSMARTFORMS	ACTUALCUSTOMERMRTYPE	TE436	ISTABLART	KEY	1	CN
2	BDSMARTFORMS	MATERIAL	MARA	MATNR	KEY	1	CN
3	BDSMARTFORMS	METERREADER	TE115	ABLESER	KEY
4	BDSMARTFORMS	METERREADINGNOTE	TE259	ABLHINW	KEY	1	CN
5	BDSMARTFORMS	MRIDNUMBER	EABL	ABLBELNR	KEY	1	CN
6	BDSMARTFORMS	MRREASON	TE609	ABLESGR	KEY	1	CN
7	BDSMARTFORMS	SMORDER	AUFK	AUFNR	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	472