SAP ABAP Table ISU2A_VB_W (Structure of Waste Disposal Services to be Billed)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-BI (Application Component) Contract Billing
     ⤷ EE20 (Package) IS-U: Billing

Basic Data

Table Category	INTTAB	Structure
Structure	ISU2A_VB_W	Table Relationship Diagram
Short Description	Structure of Waste Disposal Services to be Billed

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	Structure of Consumptions to be Billed (Quantities, Demands)
2	CSNO	☐	CSNO	LFDSCHEM	NUMC	6	0	Sequence number of schema step during billing
3	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
4	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
5	LOGIKZW	☐	LOGIKZW	LOGIKZW	NUMC	18	0	Logical register number
6	ABLBELNR	☐	ABLBELNR	ABLBELNR	CHAR	20	0	Internal ID for meter reading document	*
7	EXTPKZ	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
8	BEGPROG	☐	ADAT	DATUM	DATS	8	0	Meter reading date relevant to billing
9	ENDEPROG	☐	ADAT	DATUM	DATS	8	0	Meter reading date relevant to billing
10	QNT_NEW	☐	ISU2A_PACK16		DEC	31	14	Packed Operand Value
11	QNT_OLD	☐	ISU2A_PACK16		DEC	31	14	Packed Operand Value
12	ZEITANT	☐	E_ZEITANT_L	E_ZEITANT_L	DEC	31	14	Time portion, billing period in days or months
13	TIMTYPZA	☐	TIMTYP	TIMTYP	CHAR	1	0	Time category (days or months)
14	TCNUMTOR	☐	TCNUMTOR	TCNUMTOR	DEC	8	4	Numerator of the time portion in a time slice
15	TCDENOMTOR	☐	TCDENOMTOR	TCDENOMTOR	DEC	8	4	Denominator of the time portion in a time slice
16	TIMTYPQUOT	☐	TIMTYPQUOT	TIMTYP	CHAR	1	0	Time category of meter for time portion of a time slice
17	SPERRUNG	☐	SPERRUNG	KENNZX	CHAR	1	0	Time slice is in a disconnection period
18	NUMBER	☐	OPCSNO	LFDNR2	NUMC	2	0	Consecutive number of the operand
19	I_ZWSTNDAB	☐	I_VERBERW	I_VERBR	DEC	31	14	Expected consumption: internal format
20	I_ZWSTVOR	☐	I_VERBERW	I_VERBR	DEC	31	14	Expected consumption: internal format
21	I_ZWSTDIFF	☐	I_ZWSTDIFF	I_ZWSTDIFF	DEC	31	14	Meter reading difference in internal format
22	OPERAND	☐	E_OPERAND	E_OPERAND	CHAR	10	0	Operand	*
23	SAISON	☐	E_OPERAND	E_OPERAND	CHAR	10	0	Operand	*
24	TARIFNR	☐	TARIFNR	TARIFNR	CHAR	10	0	Rate key	*
25	DRCKSTUF	☐	DRCKSTUF	DRCKSTUF	CHAR	2	0	Gas pressure level
26	THGDATUM	☐	THGDATUM	DATUM	DATS	8	0	Gas allocation date
27	ORGAB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
28	ORGBIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
29	NOBILL	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
30	Q_NO_SUB	☐	ISU2A_PACK16		DEC	31	14	Packed Operand Value
31	SEC_SUBTR	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
32	CSNO_OLD	☐	CSNO	LFDSCHEM	NUMC	6	0	Sequence number of schema step during billing
33	BACKNO	☐	ISU2A_BACKNO		NUMC	2	0	Consecutive Number of a Backbilling Period
34	FROM_FACTS	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
35	FROM_OUTPUT	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
36	ABLESGR	☐	ABLESGR	ABLESGR	CHAR	2	0	Meter reading reason	*
37	ABLESGR_VA	☐	ABLESGR	ABLESGR	CHAR	2	0	Meter reading reason	*
38	ISTABLART	☐	ISTABLART	ISTABLART	CHAR	2	0	Meter reading type	*
39	ISTABLARTVA	☐	ISTABLART	ISTABLART	CHAR	2	0	Meter reading type	*
40	ATIMVA	☐	ATIM	HHMM	CHAR	4	0	Meter reading time (relevant to billing)
41	PERTYP_NEW	☐	BILLPERTYP	BILLPERTYP	CHAR	2	0	Category of the internal billing period
42	BACKNO_NEW	☐	ISU2A_BACKNO		NUMC	2	0	Consecutive Number of a Backbilling Period
43	COMPRESS	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
44	AKTIV	☐	E_AKTIV	E_AKTIV	CHAR	1	0	Meter reading active
45	INIT_AKTIV	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
46	LFDNR_IVB	☐	LFDNR5	NUMC5	NUMC	5	0	Sequence number
47	.INCLUDE	☐				0	0	Fields in Waste Disposal Order Item (Object Part)
48	CONTAINER	☐	BEHAELTER	GERNR	CHAR	18	0	Serial Number of Container
49	BEH_TYPE	☐	BEH_TYPE	MATNR	CHAR	18	0	Container category	MARA
50	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
51	ORDER_DATE	☐	EORDER_DATE	DATS	DATS	8	0	Planned Date for the Execution of the Waste Disposal Order
52	ACTUAL_DATE	☐	EORDER_ACTDATE	DATS	DATS	8	0	Actual Date of Waste Disposal Order
53	WASTE_TYPE	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste	*
54	SERVICE_TYPE	☐	SERVICE_TYPE	SERVICE_TYPE	CHAR	2	0	Service Type	*
55	WDPLANTNR	☐	EWAEL_WDPLANTNR	EWAEL_WDPLANTNR	CHAR	20	0	Identification of Waste Disposal Facility	*
56	WASTE_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
57	WASTE_LGORT	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	*
58	TIMEFRAME	☐	TIMEFRAME	TIMEFRAME	CHAR	2	0	Service window
59	START_TIME	☐	START_TIME	UZEIT	TIMS	6	0	Start time of a service window
60	END_TIME	☐	STOP_TIME	UZEIT	TIMS	6	0	End of service window
61	SERVFREQNR	☐	EOBJNR	EOBJNR	CHAR	10	0	Number of service frequency	EWAOBJ
62	SERVFREQ_LFNR	☐	LAUFNR	NUMC5	NUMC	5	0	Consecutive number of service frequency
63	ROUTE_SEQUENCE	☐	ROUTE_SEQUENCE	SEQUENCE	CHAR	4	0	Number of stop in route
64	SDAUFNR	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
65	SDPOSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
66	ADDRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
67	OLD_ORDER_DATE	☐	EORDER_DATE	DATS	DATS	8	0	Planned Date for the Execution of the Waste Disposal Order
68	EORDER_STATUS	☐	EORDER_STATUS	EORDER_STATUS	CHAR	2	0	Status of the waste disposal order
69	STATUS_TXT	☐	EORDER_STATUS_TXT	CHAR30	CHAR	30	0	Status Text of the Waste Disposal Order
70	POSTPONED	☐	POSTPONED	CHAR1	CHAR	1	0	Confirmation of Waste Disposal Order Reset
71	SMAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
72	ORDERTXT	☐	TEXT255	TEXT255	CHAR	255	0	Text, 255 Characters
73	SERVLOC	☐	SERVLOC	TPLNR	CHAR	30	0	Location of Container	IFLOT
74	BEH_TYPE_NEW	☐	BEHTYPNEU	MATNR	CHAR	18	0	New Container Category	*
75	SERNR_NEW	☐	BEHNEU	GERNR	CHAR	18	0	New Container Serial Number
76	BEH_ANZAHL	☐	CONT_COUNT	E_FAKTOR	INT4	10	0	Number of available containers
77	EPROP	☐	EEWA_CLEAN_PROP	EEWA_CLEAN_PROP	CHAR	12	0	Property	EEWA_PROP_H
78	KUNNR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
79	KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
80	CAPAB	☐	EEWA_CAPAB	EEWA_CAPAB	NUMC	10	0	Capacity Number
81	BULK_WEIGHT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
82	BULK_WASTE_WEIGH	☐	WASTE_WEIGHT	MENG10	QUAN	10	3	Weight of Waste Measured when Container Emptied
83	BULK_VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
84	BULK_WASTE_VOL	☐	WASTE_VOL	MENG10	QUAN	10	3	Waste Volume Measured when Container Emptied
85	ORDER_TYPE	☐	EORDER_TYPE	EORDER_TYPE	CHAR	2	0	Processing of Waste Disposal Order
86	ROB	☐	EEWA_CLEAN_ROB	ROB	CHAR	16	0	Cleaning Object	*
87	ROBTYP	☐	EEWA_ROB_ROBTYP	ROBTYP	CHAR	3	0	Cleaning object category	*
88	SUPERROB	☐	EEWA_CLEAN_SUPERROB	CHAR16	CHAR	16	0	Superordinate Cleaning Object
89	WINTERLEVEL	☐	EEWA_WINTERLEVEL	EEWA_WINTERLEVEL	CHAR	3	0	Winter Maintenance Level	*
90	CLEAN1	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
91	CLEAN2	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
92	CLEAN3	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
93	CLEAN4	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
94	CLEAN5	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
95	REMENG_TARGET	☐	EEWA_CLEAN_REMENGMET	DEC8_2	DEC	10	2	Assessment Value
96	REUNIT	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	*
97	BEHGRP	☐	BEHGRP	DEVGRP	CHAR	8	0	Container Group	*
98	ANZAHL_BEHGRP	☐	ECONT_BEHGRP	DEC5	DEC	5	0	Number of Containers in Container Group
99	BEHGRP_NEW	☐	BEHGRP	DEVGRP	CHAR	8	0	Container Group	*
100	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
101	MBLNR_GG	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
102	ADD_SERVICE	☐	ADD_SERVICE	XFELD	CHAR	1	0	Indicator for Additional Service
103	BELNR	☐	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
104	GGVERTRAG	☐	E_GUARANTOR_CONTRACT	E_GUARANTOR_CONTRACT	CHAR	18	0	Guarantor Contract
105	SDAUFNR_NACH	☐	VBELN_NACH	VBELN	CHAR	10	0	Subsequent sales and distribution document	*
106	CONTALLOC	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
107	.INCLUDE	☐				0	0	Integration Data for EHSWA
108	EHS_PARTNER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
109	INTAPPNO	☐	EWA_EHS_APPNOINT	EWA_EHS_APPNOINT	CHAR	10	0	Waste Approval
110	APPNO	☐	EWA_EHS_APPNO	EWA_EHS_APPNO	CHAR	20	0	Authority-Assigned Waste Approval Number
111	RECN	☐	EWAEHS_GUID		CHAR	32	0	Unique ID Number for Integration with EHS
112	WAKEYIDE	☐	EHS_WAKEYIDE	TEXT132	CHAR	132	0	Waste Code
113	WAKEYCATLG	☐	EHS_WAKEYCATLG	TEXT132	CHAR	132	0	Waste Catalog
114	MNAMIN	☐	EHS_MNAMIN	MENG13	QUAN	13	3	Disposal Quantity (Planning)
115	MNAMQIN	☐	EHS_MNAMQIN	MEINS	UNIT	3	0	Unit of Measure for Outgoing Quantity	*
116	MNINO_UNS	☐	EWA_EHSWAE_MNINO	CHAR15	CHAR	15	0	Disposal Document
117	MNINO_BGS	☐	EWA_EHSWAE_MNINO	CHAR15	CHAR	15	0	Disposal Document
118	TRANSPORTER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
119	DISPOSER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
120	RECNWAKEY	☐	EHS_WAKEY	ESDRECN	NUMC	20	0	Waste Code (RECN)
121	E_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
122	E_LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
123	POBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
124	CAPACITYKIND	☐	EWA_CAPACITYKIND	EWA_CAPACITYKIND	CHAR	20	0	Capacity Category
125	.INCLUDE	☐				0	0	Service Results for Waste Disposal Order for Container
126	BEHTYP_RM	☐	BEH_TYPE	MATNR	CHAR	18	0	Container category	*
127	SERNR_RM_NEW	☐	GERNR	GERNR	CHAR	18	0	Serial Number
128	BEH_ANZAHL_RM	☐	ANZSERN_RM	CK_INT4	INT4	10	0	Confirmed Number of Containers
129	WEIGHT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
130	WASTE_WEIGHT	☐	WASTE_WEIGHT	MENG10	QUAN	10	3	Weight of Waste Measured when Container Emptied
131	CONT_WGHT_TARA	☐	CONT_WGHT_TARA	MENG10	QUAN	10	3	Weight of empty container
132	CONT_WEIGHT_FULL	☐	CONT_WEIGHT_FULL	MENG10	QUAN	10	3	Container weight including waste
133	WASTE	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste	*
134	VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
135	WASTE_VOL	☐	WASTE_VOL	MENG10	QUAN	10	3	Waste Volume Measured when Container Emptied
136	UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
137	CONT_SERV_DURAT	☐	CONT_SERV_DURAT	TIMS	TIMS	6	0	Time required for emptying a container
138	REMENG	☐	EEWA_CLEAN_REMENGMET	DEC8_2	DEC	10	2	Assessment Value
139	CONFTYPE1	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
140	CONFTYPE2	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
141	CONFTYPE3	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
142	TEXT	☐	ETEXT250	ETEXT250	CHAR	250	0	Text with 250 characters
143	WCNT	☐	EWEIGHCNT	EWEIGHCNT	NUMC	4	0	Consecutive Number of Weighing Data Record
144	REF_ORDERNR	☐	EORDERNR_REF	EORDERNR	CHAR	20	0	Number of Waste Disposal Order for Weighing Data Record	*
145	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
146	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
147	ABRMENGE	☐	E_ABRMENGE	E_ABRMENGE	CHAR	36	0	Billing quantity
148	MIETDAUER	☐	E_MIETDAUER	LVS_ZEITD	QUAN	13	3	Term of Lease
149	ZEITUNIT	☐	MAIZE	MEINS	UNIT	3	0	Time unit	T006
150	.INCLUDE	☐				0	0
151	.INCLUDE	☐				0	0	Key for item of waste disposal order
152	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
153	ORDERNR	☐	EORDERNR	EORDERNR	CHAR	20	0	Internal Number for Identifying a Waste Disposal Order	EWA_ORDER_HEAD
154	ORDER_LAUFNR	☐	ORDER_LAUFNR	NUMC4	NUMC	4	0	Consecutive Number for Waste Disposal Order Item
155	EORDER_STATUS_I	☐	EORDER_STATUS	EORDER_STATUS	CHAR	2	0	Status of the waste disposal order
156	OPERAND_W	☐	E_OPERAND	E_OPERAND	CHAR	10	0	Operand	*
157	OPLFDNR_W	☐	OPLFDNR	LFDNR4	NUMC	4	0	Consecutive number of an operand
158	KONDIGR	☐	KONDIGR	KONDIGR	CHAR	10	0	Rate fact group	*
159	BILLTYPE	☐	EBILLTYPE	BILLTYPE_ID	CHAR	6	0	Waste Billing Category
160	BILLFLD1	☑	EBILL_FLD	FDNAME	CHAR	30	0	DDIC Name of Field Relevant for Billing	*
161	BILLFLD2	☑	EBILL_FLD	FDNAME	CHAR	30	0	DDIC Name of Field Relevant for Billing	*
162	BILLFLD3	☑	EBILL_FLD	FDNAME	CHAR	30	0	DDIC Name of Field Relevant for Billing	*
163	BILLFLD4	☑	EBILL_FLD	FDNAME	CHAR	30	0	DDIC Name of Field Relevant for Billing	*
164	BILLFLD5	☑	EBILL_FLD	FDNAME	CHAR	30	0	DDIC Name of Field Relevant for Billing	*
165	EXTRAPOLWASTE	☐	EXTRAPOLWASTE	EXTRAPOLWASTE	CHAR	2	0	Category of Waste Disposal Budget Billing Extrapolation
166	STAT	☐	J_STATUS	J_STATUS	CHAR	5	0	Object status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISU2A_VB_W	ADDRNR	ADRC	ADDRNUMBER
2	ISU2A_VB_W	BEH_TYPE	MARA	MATNR
3	ISU2A_VB_W	BULK_VOL_UNIT	T006	MSEHI
4	ISU2A_VB_W	BULK_WEIGHT_UNIT	T006	MSEHI
5	ISU2A_VB_W	CONFTYPE1	TEWACONFTYPE	CONFTYPE
6	ISU2A_VB_W	CONFTYPE2	TEWACONFTYPE	CONFTYPE
7	ISU2A_VB_W	CONFTYPE3	TEWACONFTYPE	CONFTYPE
8	ISU2A_VB_W	EPROP	EEWA_PROP_H	MANDT
9	ISU2A_VB_W	KUNNR	BUT000	PARTNER
10	ISU2A_VB_W	LGORT	T001L	LGORT
11	ISU2A_VB_W	MANDT	T000	MANDT	KEY	1	CN
12	ISU2A_VB_W	ORDERNR	EWA_ORDER_HEAD	ORDERNR	KEY	1	CN
13	ISU2A_VB_W	SDAUFNR	VBUK	VBELN
14	ISU2A_VB_W	SERVFREQNR	EWAOBJ	OBJNR
15	ISU2A_VB_W	SERVLOC	IFLOT	TPLNR
16	ISU2A_VB_W	SMAUFNR	AUFK	AUFNR
17	ISU2A_VB_W	VOL_UNIT	T006	MSEHI		1	CN
18	ISU2A_VB_W	WEIGHT_UNIT	T006	MSEHI
19	ISU2A_VB_W	ZEITUNIT	T006	MSEHI

History

Last changed by/on	SAP	20110901
SAP Release Created in	463