SAP ABAP Table BIW_ISU_WASTE (BW Extraction Structure for ISU-WA Waste Disposal Order)
Hierarchy
☛
IS-UT (Software Component) SAP Utilities/Telecommunication
⤷ IS-U-IS-ST (Application Component) Statistics
⤷ EE71_R461 (Package) IS-U: BW Extractors
⤷ IS-U-IS-ST (Application Component) Statistics
⤷ EE71_R461 (Package) IS-U: BW Extractors
Basic Data
Table Category | INTTAB | Structure |
Structure | BIW_ISU_WASTE | Table Relationship Diagram |
Short Description | BW Extraction Structure for ISU-WA Waste Disposal Order |
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 | ORDERNR | EORDERNR | EORDERNR | CHAR | 20 | 0 | Internal Number for Identifying a Waste Disposal Order | EWA_ORDER_HEAD | |
3 | ORDER_LAUFNR | ORDER_LAUFNR | NUMC4 | NUMC | 4 | 0 | Consecutive Number for Waste Disposal Order Item | ||
4 | ACTUAL_DATE | EORDER_ACTDATE | DATS | DATS | 8 | 0 | Actual Date of Waste Disposal Order | ||
5 | SERVICE_TYPE | SERVICE_TYPE | SERVICE_TYPE | CHAR | 2 | 0 | Service Type | TESERVICETYPE | |
6 | ACTUAL_ROUTE | EROUTE_ACT | EROUTE | CHAR | 10 | 0 | Actual Route of Waste Disposal Order | EWAROUTE | |
7 | FLEET_EQUNR_1 | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
8 | FLEET_EQUNR_2 | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
9 | PERNR_WASTE_1 | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
10 | PERNR_WASTE_2 | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
11 | PERNR_WASTE_3 | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
12 | KUNNR | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | BUT000 | |
13 | KUNNR_BPID | EEWA_KUNBPID | CHAR15 | CHAR | 15 | 0 | Authority Number for Waste Generator | ||
14 | NAME_TXT | TEXT1GP_KK | TEXT132 | CHAR | 132 | 0 | Text for business partner | ||
15 | ADRESS | EWA_ADRESSE | CHAR132 | CHAR | 132 | 0 | Address of Waste Disposal Object | ||
16 | BPKIND | BU_BPKIND | BU_KIND | CHAR | 4 | 0 | Business Partner Type | * | |
17 | ADDRNR | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
18 | CITY_CODE | AD_CITYNUM | CITY_CODE | CHAR | 12 | 0 | City code for city/street file | * | |
19 | CITYP_CODE | AD_CITYPNM | CITYP_CODE | CHAR | 8 | 0 | District code for City and Street file | * | |
20 | STREETCODE | AD_STRNUM | STRT_CODE | CHAR | 12 | 0 | Street Number for City/Street File | * | |
21 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
22 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
23 | REGPOLIT | REGPOLIT | REGPOLIT | CHAR | 8 | 0 | Political regional structure element | * | |
24 | BEH_TYPE | BEH_TYPE | MATNR | CHAR | 18 | 0 | Container category | * | |
25 | WASTE | WASTE_TYPE | MATNR | CHAR | 18 | 0 | Waste | MARA | |
26 | WASTE_WEIGHT | WASTE_WEIGHT | MENG10 | QUAN | 10 | 3 | Weight of Waste Measured when Container Emptied | ||
27 | WEIGHT_UNIT | WEIGHT_UNIT | MEINS | UNIT | 3 | 0 | Unit of weight | T006 | |
28 | WASTE_VOL | WASTE_VOL | MENG10 | QUAN | 10 | 3 | Waste Volume Measured when Container Emptied | ||
29 | VOL_UNIT | VOL_UNIT | MEINS | UNIT | 3 | 0 | Volume unit | T006 | |
30 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
31 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
32 | CONFTYPE1 | CONFTYPE | CHAR8 | CHAR | 8 | 0 | Confirmation note | TEWACONFTYPE | |
33 | CONFTYPE2 | CONFTYPE | CHAR8 | CHAR | 8 | 0 | Confirmation note | TEWACONFTYPE | |
34 | CONFTYPE3 | CONFTYPE | CHAR8 | CHAR | 8 | 0 | Confirmation note | TEWACONFTYPE | |
35 | APPNO | EWA_EHS_APPNO | EWA_EHS_APPNO | CHAR | 20 | 0 | Authority-Assigned Waste Approval Number | ||
36 | WAKEYIDE | EHS_WAKEYIDE | TEXT132 | CHAR | 132 | 0 | Waste Code | ||
37 | IDENT | EWA_EHSIDENT | TEXT132 | CHAR | 132 | 0 | Waste Code Description | ||
38 | HAZARDOUS | KENNZX | KENNZX | CHAR | 1 | 0 | Indicators | ||
39 | SPECHAZARDOUS | KENNZX | KENNZX | CHAR | 1 | 0 | Indicators | ||
40 | WDPLANT | EWAEL_WDPLANTNR | EWAEL_WDPLANTNR | CHAR | 20 | 0 | Identification of Waste Disposal Facility | * | |
41 | DESCRIPTION | EWAEL_DESCRIPTION | EWAEL_CUSTOMTEXT | CHAR | 254 | 0 | Description | ||
42 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
43 | POST_CODE1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
44 | CITY1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
45 | DISPOSER | EHS_PARTNER | EHS_PARTNER | CHAR | 10 | 0 | Waste Management Business Partner | ||
46 | DISPOSER_RECN | EWAEL_UUID_32 | EWAEL_UUID_32 | CHAR | 32 | 0 | Unique ID Number | * | |
47 | DISPO_BPID | EEWA_DISPBPID | CHAR15 | CHAR | 15 | 0 | Authority Number for Disposer | ||
48 | DISPOSEPROC | TEXT40 | TEXT40 | CHAR | 40 | 0 | Text, 40 Characters Long | ||
49 | TRANSPORTER | EHS_PARTNER | EHS_PARTNER | CHAR | 10 | 0 | Waste Management Business Partner | ||
50 | TRANS_BPID | EEWA_TRANSBPID | CHAR15 | CHAR | 15 | 0 | Authority Number for Waste Transporter | ||
51 | TRANSADDRES | ADDRESS_INFO | CHAR55 | CHAR | 55 | 0 | Address | ||
52 | STATANZ | STATANZ | STATANZ | INT4 | 10 | 0 | Number in statistics | ||
53 | UPDMOD | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BIW_ISU_WASTE | ACTUAL_ROUTE | EWAROUTE | ROUTE | |||
2 | BIW_ISU_WASTE | CONFTYPE1 | TEWACONFTYPE | CONFTYPE | |||
3 | BIW_ISU_WASTE | CONFTYPE2 | TEWACONFTYPE | CONFTYPE | |||
4 | BIW_ISU_WASTE | CONFTYPE3 | TEWACONFTYPE | CONFTYPE | |||
5 | BIW_ISU_WASTE | KUNNR | BUT000 | PARTNER | |||
6 | BIW_ISU_WASTE | LGORT | T001L | LGORT | |||
7 | BIW_ISU_WASTE | MANDT | T000 | MANDT | |||
8 | BIW_ISU_WASTE | ORDERNR | EWA_ORDER_HEAD | ORDERNR | |||
9 | BIW_ISU_WASTE | SERVICE_TYPE | TESERVICETYPE | SERVICE_TYPE | |||
10 | BIW_ISU_WASTE | VOL_UNIT | T006 | MSEHI | |||
11 | BIW_ISU_WASTE | WASTE | MARA | MATNR | |||
12 | BIW_ISU_WASTE | WEIGHT_UNIT | T006 | MSEHI | |||
13 | BIW_ISU_WASTE | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 464 |