SAP ABAP View V_BULKYCUST (View of all Data for Bulk Waste Order Type)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-WA (Application Component) Waste Management
     ⤷ EEWA (Package) IS-U: Waste Management

Basic Data

View Type	D	Database View
Database View	V_BULKYCUST
Short Description	View of all Data for Bulk Waste Order Type
Root table	TEEWA_BULKY_CUST	Bulk Refuse Order Types

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TEEWA_BULKY_CUST	TEEWA_BULKY_CUST
2	TEEWA_BULK_CUSTT
3	TEEWA_BULK_CUSTZ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TEEWA_BULKY_CUST	MANDT	JL	EQ				0	0
2	TEEWA_BULK_CUSTT	MANDT	JR	EQ			AND	0	0
3	TEEWA_BULKY_CUST	SPAUA	JL	EQ				0	0
4	TEEWA_BULK_CUSTT	SPAUA	JR	EQ			AND	0	0
5	TEEWA_BULKY_CUST	MANDT	JL	EQ				0	0
6	TEEWA_BULK_CUSTZ	MANDT	JR	EQ			AND	0	0
7	TEEWA_BULKY_CUST	SPAUA	JL	EQ				0	0
8	TEEWA_BULK_CUSTZ	SPAUA	JR	EQ			AND	0	0
9	TEEWA_BULKY_CUST	SERVICE_TYPE	JL	EQ				0	0
10	TEEWA_BULK_CUSTZ	SERVICE_TYPE	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TEEWA_BULKY_CUST	MANDT		☐	MANDT	☐	Client
2	SPAUA	TEEWA_BULK_CUSTT	SPAUA		☐	EEWA_SPAUA	☐	Waste Disposal Order Type
3	MATKL	TEEWA_BULKY_CUST	MATKL		☐	MATKL	☐	Material Group
4	VKORG	TEEWA_BULKY_CUST	VKORG		☐	VKORG	☐	Sales Organization
5	VTWEG	TEEWA_BULKY_CUST	VTWEG		☐	VTWEG	☐	Distribution Channel
6	SPART	TEEWA_BULKY_CUST	SPART		☐	SPART	☐	Division
7	AUART	TEEWA_BULKY_CUST	AUART		☐	AUART	☐	Sales Document Type
8	WERKS	TEEWA_BULKY_CUST	WERKS		☐	WERKS_D	☐	Plant
9	PSTYV_EXP	TEEWA_BULKY_CUST	PSTYV_EXP		☐	PSTYV_WA_EXPRESS	☐	Item Category for Bulk Waste Express Order
10	PSTYV_N	TEEWA_BULKY_CUST	PSTYV_N		☐	PSTYV_WA_NORMAL	☐	Sales Document Item Category
11	PSTYV_VOR	TEEWA_BULKY_CUST	PSTYV_VOR		☐	PSTYV_WA_VOR	☐	Item Category for Sales Document Advance Payment
12	PSTYV_BAR	TEEWA_BULKY_CUST	PSTYV_BAR		☐	PSTYV_WA_BAR	☐	Item Category for Sales Document Cash Payment
13	PSTYV_K	TEEWA_BULKY_CUST	PSTYV_K		☐	PSTYV_WA_KOSTENLOS	☐	Sales Document Item Category for Free Items
14	PRDEF	TEEWA_BULKY_CUST	PRDEF		☐	EEWA_PRDEF	☐	Price Control
15	KOND0	TEEWA_BULKY_CUST	KOND0		☐	EEWA_KSCHL1	☐	Condition for Express Surcharge
16	KOND0_PRS	TEEWA_BULKY_CUST	KOND0_PRS		☐	KBETRC	☐	Condition rate with decimal places and minus sign
17	KOND1	TEEWA_BULKY_CUST	KOND1		☐	EEWA_KSCHL2	☐	Condition for Material Price
18	KOND2	TEEWA_BULKY_CUST	KOND2		☐	EEWA_KSCHL3	☐	Condition Type for Absolute Note Surcharge
19	KOND3	TEEWA_BULKY_CUST	KOND3		☐	EEWA_KSCHL4	☐	Condition for Percentage Note Surcharge
20	KOND4	TEEWA_BULKY_CUST	KOND4		☐	KSCHL	☐	Condition Type
21	SPRAS	TEEWA_BULK_CUSTT	SPRAS		☐	LANGU	☐	Language Key
22	LFDTX	TEEWA_BULK_CUSTT	LFDTX		☐	TEXT40	☐	Text, 40 Characters Long
23	PRODUCT_AREA	TEEWA_BULK_CUSTZ	PRODUCT_AREA		☐	PRODUCT_AREA	☐	Service Area
24	MTART	TEEWA_BULK_CUSTZ	MTART		☐	MTART	☐	Material type
25	SERVICE_TYPE	TEEWA_BULK_CUSTZ	SERVICE_TYPE		☐	SERVICE_TYPE	☐	Service Type

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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