SAP ABAP Table BIW_ISUWA_ROUTE_ATTR (Business Warehouse Master Data for Route)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IS-ST (Application Component) Statistics
     ⤷ EE71_R461 (Package) IS-U: BW Extractors

Basic Data

Table Category	INTTAB	Structure
Structure	BIW_ISUWA_ROUTE_ATTR	Table Relationship Diagram
Short Description	Business Warehouse Master Data for Route

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	*
2	ROUTE	☑	EROUTE	EROUTE	CHAR	10	0	Planned Waste Disposal Order Route	*
3	.INCLUDE	☐				0	0	Fields for Route
4	ROUTE_TXT	☐	EROUTE_TXT	CHAR30	CHAR	30	0	Text for route
5	STICHTAG	☐	EGUELTIGVON	DATUM	DATS	8	0	Date from which the route is valid
6	WASTE_TYPE1	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste	MARA
7	PRODUCT_AREA1	☐	PRODUCT_AREA	PRODUCT_ID	CHAR	2	0	Service Area	TPRDCTAREA
8	RESULTYP	☐	ERESULT	ERESULT_ID	CHAR	2	0	Confirmation category	TEWARESULT
9	PRODUCT_AREA2	☐	PRODUCT_AREA2	PRODUCT_ID	CHAR	2	0	Secondary service area	TPRDCTAREA
10	RESULTYP2	☐	ERESULT	ERESULT_ID	CHAR	2	0	Confirmation category	TEWARESULT
11	PRODUCT_AREA3	☐	PRODUCT_AREA3	PRODUCT_ID	CHAR	2	0	Tertiary service area	TPRDCTAREA
12	RESULTYP3	☐	ERESULT	ERESULT_ID	CHAR	2	0	Confirmation category	TEWARESULT
13	FLEET_CAT	☐	FLEET_CAT	EQART	CHAR	10	0	Vehicle Type	T370FLT
14	CAL_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
15	CORR_OPT	☐	CALCORR	CALCORR	CHAR	1	0	Correct non-workday
16	WASTE_CAL	☐	WASTE_CAL	CHAR8	CHAR	8	0	Waste Management Calendar as Template for Route	EWACALENDER
17	KOLONNE	☐	KOLONNE	ORGEH	NUMC	8	0	Resource master	T527X
18	KOLONNE_TXT	☐	KOLONNE_TXT	TEXT25	CHAR	25	0	Resource master text
19	STANDARDDRIVER	☐	STANDARDDRIVER	CR_OBJID	NUMC	8	0	Standard driver of route	CRID
20	EVOL_ROUTE_TARGE	☐	EVOL_ROUTE_TARGET	MENG13	QUAN	13	3	Planned volume of route
21	VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
22	EPREM_ROUTE_TARG	☐	EPREMISE_TARGET	NUMC5	NUMC	5	0	Target Number of Premises
23	ECONT_ROUTE_TARG	☐	ECONT_ROUTE_TARGET	DEC5	DEC	5	0	Planned number of containers for route
24	ETIME_ROUTE_TARG	☐	ETIME_ROUTE_TARGET	TIME	TIMS	6	0	Planned duration of route
25	MEIZT	☐	MEIZT	MEINS	UNIT	3	0	Unit of measure for travelling times	T006
26	EDIST_ROUTE_TARG	☐	EDIST_ROUTE_TARGET	MENG13	QUAN	13	3	Planned distance of route
27	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	T006
28	EWGHT_ROUTE_TARG	☐	EWGHT_ROUTE_TARGET	MENG13	QUAN	13	3	Planned weight of route
29	WEIGHT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
30	WASTE_DISP_PLANT	☐	WASTE_DISP_PLANT	KUNNR	CHAR	10	0	Waste Disposal Facility	KNA1
31	REGIOGROUP	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	TE227
32	FORM_ALLORD	☐	FORM_ALLORD	FORMKEY	CHAR	30	0	Application Form "Waste Disposal Orders in Full"	EFRM
33	FORM_POSORD	☐	FORM_POSORD	FORMKEY	CHAR	30	0	Application Form "Waste Disposal Order Items"	EFRM
34	FORM_HEADORD	☐	FORM_HEADORD	FORMKEY	CHAR	30	0	Application Form "Waste Disposal Orders Cover Sheet"	EFRM
35	ESHIFT	☐	ESHIFT	CHAR4	CHAR	4	0	Shift	TEWASHIFTS
36	SHIFT_VON	☐	TIMEFROM		TIMS	6	0	Start time
37	SHIFT_BIS	☐	TIMETO		TIMS	6	0	End time
38	EPNT_ROUTE_TARG	☐	EPOINT_ROUTE_TARG	CHAR4	CHAR	4	0	Target Service Points for Route
39	FLEET_EQUNR1	☐	E_VEHICLE	EQUNR	CHAR	18	0	Vehicle Number (Equipment Number)	EQUI
40	ARBID1	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
41	ARBPL1	☐	ARBPL	ARBPL	CHAR	8	0	Work center
42	WERKS1	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
43	FLEET_EQUNR2	☐	E_VEHICLE	EQUNR	CHAR	18	0	Vehicle Number (Equipment Number)	EQUI
44	ARBID2	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
45	ARBPL2	☐	ARBPL	ARBPL	CHAR	8	0	Work center
46	WERKS2	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
47	FLEET_EQUNR3	☐	E_VEHICLE	EQUNR	CHAR	18	0	Vehicle Number (Equipment Number)	EQUI
48	ARBID3	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	CRID
49	ARBPL3	☐	ARBPL	ARBPL	CHAR	8	0	Work center
50	WERKS3	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
51	INACTIVE	☐	ROUTE_INACTIVE	KENNZX	CHAR	1	0	Indicator to Show Whether Route Has Been Deactivated
52	INACTIVE_DATE	☐	INACTIVE_DATE	DATUM	DATS	8	0	Date, From Which Route Is Inactive
53	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
54	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
55	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
56	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
57	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
58	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
59	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
60	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
61	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
62	AUFNR	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
63	DWERK	☐	DWERK	WERKS	CHAR	4	0	Delivering Plant	T001W
64	BEH_LGORT	☐	L_LGORT	LGORT	CHAR	4	0	Location: Storage location in plant	T001L
65	COSTCOL	☐	ECOSTCOL	ECOSTCOL	CHAR	2	0	Cost Collector for Waste Disposal Order
66	INITIAL_STATUS	☐	INITIAL_STATUS	INITIAL_STATUS	CHAR	4	0	Initial Status When Creating Waste Disposal Order
67	FRAKTION	☐	WASTETYPE	MATKL	CHAR	9	0	Waste Fraction	TEWAWASTE
68	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
69	.INCLUDE	☐				0	0	Creation and Change Data
70	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
71	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
72	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
73	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
74	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
75	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIW_ISUWA_ROUTE_ATTR	ARBID1	CRID	OBJID
2	BIW_ISUWA_ROUTE_ATTR	ARBID2	CRID	OBJID
3	BIW_ISUWA_ROUTE_ATTR	ARBID3	CRID	OBJID
4	BIW_ISUWA_ROUTE_ATTR	AUFNR	AUFK	AUFNR
5	BIW_ISUWA_ROUTE_ATTR	BEBER	T357	BEBER
6	BIW_ISUWA_ROUTE_ATTR	BEH_LGORT	T001L	LGORT
7	BIW_ISUWA_ROUTE_ATTR	BUKRS	T001	BUKRS
8	BIW_ISUWA_ROUTE_ATTR	CAL_ID	TFACD	IDENT
9	BIW_ISUWA_ROUTE_ATTR	DAUFN	AUFK	AUFNR
10	BIW_ISUWA_ROUTE_ATTR	DWERK	T001W	WERKS
11	BIW_ISUWA_ROUTE_ATTR	ESHIFT	TEWASHIFTS	ESHIFT		1	CN
12	BIW_ISUWA_ROUTE_ATTR	FLEET_CAT	T370FLT	FLEET_CAT
13	BIW_ISUWA_ROUTE_ATTR	FLEET_EQUNR1	EQUI	EQUNR
14	BIW_ISUWA_ROUTE_ATTR	FLEET_EQUNR2	EQUI	EQUNR
15	BIW_ISUWA_ROUTE_ATTR	FLEET_EQUNR3	EQUI	EQUNR
16	BIW_ISUWA_ROUTE_ATTR	FORM_ALLORD	EFRM	FORMKEY
17	BIW_ISUWA_ROUTE_ATTR	FORM_HEADORD	EFRM	FORMKEY
18	BIW_ISUWA_ROUTE_ATTR	FORM_POSORD	EFRM	FORMKEY
19	BIW_ISUWA_ROUTE_ATTR	FRAKTION	TEWAWASTE	MATKL
20	BIW_ISUWA_ROUTE_ATTR	GSBER	TGSB	GSBER
21	BIW_ISUWA_ROUTE_ATTR	KOKRS	TKA01	KOKRS
22	BIW_ISUWA_ROUTE_ATTR	KOLONNE	T527X	ORGEH
23	BIW_ISUWA_ROUTE_ATTR	KOSTL	CSKS	KOSTL
24	BIW_ISUWA_ROUTE_ATTR	MEDST	T006	MSEHI
25	BIW_ISUWA_ROUTE_ATTR	MEIZT	T006	MSEHI
26	BIW_ISUWA_ROUTE_ATTR	OBJNR	ONR00	OBJNR
27	BIW_ISUWA_ROUTE_ATTR	PRODUCT_AREA1	TPRDCTAREA	PRODUCT_AREA
28	BIW_ISUWA_ROUTE_ATTR	PRODUCT_AREA2	TPRDCTAREA	PRODUCT_AREA
29	BIW_ISUWA_ROUTE_ATTR	PRODUCT_AREA3	TPRDCTAREA	PRODUCT_AREA
30	BIW_ISUWA_ROUTE_ATTR	REGIOGROUP	TE227	REGPOLIT
31	BIW_ISUWA_ROUTE_ATTR	RESULTYP	TEWARESULT	RESULTYP
32	BIW_ISUWA_ROUTE_ATTR	RESULTYP2	TEWARESULT	RESULTYP
33	BIW_ISUWA_ROUTE_ATTR	RESULTYP3	TEWARESULT	RESULTYP
34	BIW_ISUWA_ROUTE_ATTR	STANDARDDRIVER	CRID	OBJID
35	BIW_ISUWA_ROUTE_ATTR	STORT	T499S	STAND
36	BIW_ISUWA_ROUTE_ATTR	SWERK	T001W	WERKS
37	BIW_ISUWA_ROUTE_ATTR	VOL_UNIT	T006	MSEHI
38	BIW_ISUWA_ROUTE_ATTR	WASTE_CAL	EWACALENDER	WASTE_CAL
39	BIW_ISUWA_ROUTE_ATTR	WASTE_DISP_PLANT	KNA1	KUNNR
40	BIW_ISUWA_ROUTE_ATTR	WASTE_TYPE1	MARA	MATNR
41	BIW_ISUWA_ROUTE_ATTR	WEIGHT_UNIT	T006	MSEHI
42	BIW_ISUWA_ROUTE_ATTR	WERKS1	T001W	WERKS
43	BIW_ISUWA_ROUTE_ATTR	WERKS3	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in	473