SAP ABAP View M_PREIA (Generated View for Matchcode ID PREI-A)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	M_PREIA
Short Description	Generated View for Matchcode ID PREI-A
Root table	EPREIH	History Table for All Prices

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EPREIH	EPREIH
2	EPREI	EPREI
3	EPREIT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EPREI	MANDT	JL	EQ				0	0
2	EPREIH	MANDT	JR	EQ			AND	0	0
3	EPREI	PREIS	JL	EQ				0	0
4	EPREIH	PREIS	JR	EQ			AND	0	0
5	EPREI	PREISTYP	JL	EQ				0	0
6	EPREIH	PREISTYP	JR	EQ			AND	0	0
7	EPREI	PREISTUF	JL	EQ				0	0
8	EPREIH	PREISTUF	JR	EQ			AND	0	0
9	EPREI	MANDT	JL	EQ				0	0
10	EPREIT	MANDT	JR	EQ			AND	0	0
11	EPREI	PREIS	JL	EQ				0	0
12	EPREIT	PREIS	JR	EQ			AND	0	0
13	EPREI	PREISTYP	JL	EQ				0	0
14	EPREIT	PREISTYP	JR	EQ			AND	0	0
15	EPREI	PREISTUF	JL	EQ				0	0
16	EPREIT	PREISTUF	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EPREIH	MANDT		☐	MANDT	☐	Client
2	PREIS	EPREIH	PREIS		☐	E_PREIS	☐	Price
3	PREISTYP	EPREIH	PREISTYP		☐	PREISTYP	☐	Price category
4	PREISTUF	EPREIH	PREISTUF		☐	PREISTUF	☐	Price level
5	BISDATUM	EPREIH	BISDATUM		☐	BISZEITSCH	☐	Date at Which a Time Slice Expires
6	AKLASSE	EPREI	AKLASSE		☐	AKLASSE	☐	Billing class
7	ERNAM	EPREI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
8	TEXT30	EPREIT	TEXT30		☐	TEXT50	☐	Text Field
9	PREIGKL	EPREI	PREIGKL		☐	PREIGKL	☐	Price adjustment clause
10	SPRAS	EPREIT	SPRAS		☐	SPRAS	☐	Language Key
11	TWAERS	EPREIH	TWAERS		☐	TWAERS	☐	Transaction Currency
12	TIMBASIS	EPREI	TIMBASIS		☐	TIMBASIS	☐	Time Basis
13	TIMTYP	EPREI	TIMTYP		☐	TIMTYP	☐	Time category (days or months)
14	ABDATUM	EPREIH	ABDATUM		☐	ABZEITSCH	☐	Date from which time slice is valid
15	PREISBTR	EPREIH	PREISBTR		☐	PRSBTR	☐	Price amount
16	MNGBASIS	EPREIH	MNGBASIS		☐	MENGENBAS	☐	Long quantity base for amount
17	FRAN_TYPE	EPREI	FRAN_TYPE		☐	FRAN_TYPE	☐	Franchise Fee Category
18	SPARTE	EPREI	SPARTE		☐	SPARTE	☐	Division
19	MASS	EPREI	MASS		☐	E_MASS	☐	Unit of Measurement

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	20130529
SAP Release Created in