SAP ABAP View V_EWAOBJH_AAT (View All Data for Customer-Specific Prices)

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_EWAOBJH_AAT
Short Description	View All Data for Customer-Specific Prices
Root table	EWAOBJH_AAT	Waste Billing Categories for Service Frequency Service

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EWAOBJH_AAT	EWAOBJH_AAT
2	EWAOBJH_AAT_HIST	EWAOBJH_AAT_HIST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EWAOBJH_AAT	MANDT	JL	EQ				0	0
2	EWAOBJH_AAT_HIST	MANDT	JR	EQ			AND	0	0
3	EWAOBJH_AAT	OBJNR	JL	EQ				0	0
4	EWAOBJH_AAT_HIST	OBJNR	JR	EQ			AND	0	0
5	EWAOBJH_AAT	LAUFNR	JL	EQ				0	0
6	EWAOBJH_AAT_HIST	LAUFNR	JR	EQ			AND	0	0
7	EWAOBJH_AAT	BILLTYPE	JL	EQ				0	0
8	EWAOBJH_AAT_HIST	BILLTYPE	JR	EQ			AND	0	0
9	EWAOBJH_AAT	VERTRAG	JL	EQ				0	0
10	EWAOBJH_AAT_HIST	VERTRAG	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EWAOBJH_AAT	MANDT		☐	MANDT	☐	Client
2	OBJNR	EWAOBJH_AAT	OBJNR		☐	EOBJNR	☐	Number of service frequency
3	LAUFNR	EWAOBJH_AAT	LAUFNR		☐	LAUFNR	☐	Consecutive number of service frequency
4	BILLTYPE	EWAOBJH_AAT	BILLTYPE		☐	EBILLTYPE	☐	Waste Billing Category
5	VERTRAG	EWAOBJH_AAT	VERTRAG		☐	VERTRAG	☐	Contract
6	BIS	EWAOBJH_AAT_HIST	BIS		☐	BISDATUM	☐	Valid-To Date
7	AB	EWAOBJH_AAT_HIST	AB		☐	ABDATUM	☐	Start of Period
8	OPERAND	EWAOBJH_AAT_HIST	OPERAND		☐	E_OPERAND	☐	Operand
9	SERVICE_TYPE	EWAOBJH_AAT_HIST	SERVICE_TYPE		☐	SERVICE_TYPE	☐	Service Type
10	ANLAGE	EWAOBJH_AAT_HIST	ANLAGE		☐	ANLAGE	☐	Installation
11	SAISON	EWAOBJH_AAT_HIST	SAISON		☐	SAISON	☐	Season
12	ABLFDNR	EWAOBJH_AAT_HIST	ABLFDNR		☐	ABLFDNR	☐	Consecutive Number for a From-Date
13	BELNR	EWAOBJH_AAT_HIST	BELNR		☐	E_BELNR	☐	Number of a billing document
14	MBELNR	EWAOBJH_AAT_HIST	MBELNR		☐	E_BELNR	☐	Number of a billing document
15	MAUSZUG	EWAOBJH_AAT_HIST	MAUSZUG		☐	MAUSZUG	☐	Fact was changed as a result of move-out
16	ALTBIS	EWAOBJH_AAT_HIST	ALTBIS		☐	BISZEITSCH	☐	Date at Which a Time Slice Expires
17	INAKTIV	EWAOBJH_AAT_HIST	INAKTIV		☐	INAKTIVKZ	☐	Entry Inactive
18	MANAEND	EWAOBJH_AAT_HIST	MANAEND		☐	MANAEND	☐	Indicator: manual change to calculated value
19	TARIFART	EWAOBJH_AAT_HIST	TARIFART		☐	TARIFART	☐	Rate Type
20	KONDIGR	EWAOBJH_AAT_HIST	KONDIGR		☐	KONDIGR	☐	Rate fact group
21	WERT1	EWAOBJH_AAT_HIST	WERT1		☐	E_WERT1	☐	Entry value (installed value) for a device
22	WERT2	EWAOBJH_AAT_HIST	WERT2		☐	E_WERT2	☐	Value to be billed
23	STRING1	EWAOBJH_AAT_HIST	STRING1		☐	STRING1	☐	First key field for operand value
24	STRING2	EWAOBJH_AAT_HIST	STRING2		☐	STRING2	☐	Second key field for operand value
25	STRING3	EWAOBJH_AAT_HIST	STRING3		☐	STRING3	☐	Third key field for operand value
26	STRING4	EWAOBJH_AAT_HIST	STRING4		☐	STRING4	☐	Fourth key field for operand value
27	ERSATZWERT	EWAOBJH_AAT_HIST	ERSATZWERT		☐	ERSATZWERT	☐	Replacement value for operands
28	BETRAG	EWAOBJH_AAT_HIST	BETRAG		☐	E_BETRAG	☐	Currency-dependent amount
29	WAERS	EWAOBJH_AAT_HIST	WAERS		☐	WAERS	☐	Currency Key

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	471