SAP ABAP Table REA89 (Screen Fields for Price Maint. Transactns)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	REA89	Table Relationship Diagram
Short Description	Screen Fields for Price Maint. Transactns

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	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
3	PREIS	☐	E_PREIS	E_PREIS	CHAR	10	0	Price	*
4	PREISTYP	☐	PREISTYP	PREISTYP	CHAR	1	0	Price category
5	PREISTUF	☐	PREISTUF	PREISTUF	CHAR	10	0	Price level	*
6	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
7	TEXT30	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
8	MNGBASIS	☐	MENGENBAS	MENGENBAS	DEC	9	2	Long quantity base for amount
9	MASS	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	T006
10	AKLASSE	☐	AKLASSE	AKLASSE	CHAR	4	0	Billing class	EAKLASSE
11	TIMBASIS	☐	TIMBASIS	TIMBASIS	CHAR	3	0	Time Basis
12	TIMTYP	☐	TIMTYP	TIMTYP	CHAR	1	0	Time category (days or months)
13	PREIGKL	☐	PREIGKL	PREIGKL	CHAR	10	0	Price adjustment clause	EPRESCL
14	MITTELPR	☐	MITTELPR	MITTELPR	CHAR	1	0	Calculation of an average price when price change occurs
15	ABDATUM	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
16	VONZONE	☐	VONZONE	E_ZONE	NUMC	10	0	From-block
17	BISZONE	☐	BISZONE	E_ZONE	NUMC	10	0	To-block
18	PREISBTR	☐	PRSBTR	PRSBTR	DEC	17	8	Price amount
19	ZONB	☐	E_ZONB	KENNZX	CHAR	1	0	Ignore consumption in the following block
20	BISDATUM	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
21	DPREIKZ	☐	DPREIKZ	DPREIKZ	CHAR	1	0	Average Price
22	MNGBASISL	☐	MENGENBAS	MENGENBAS	DEC	9	2	Long quantity base for amount
23	RUNDART	☐	RUNDART	RUNDART	CHAR	1	0	Rounding Category
24	RUNDUNG	☐	E_RUNDUNG	E_RUNDUNG	CHAR	2	0	Starting Point for Rounding
25	PREISART	☐	E_PREISART	E_PREISART	CHAR	1	0	Price type
26	PREISV	☐	E_PREISV	E_PREIS	CHAR	10	0	Price key (reference)	*
27	PREISTYPV	☐	PREISTYPV	PREISTYP	CHAR	1	0	Price category (reference)
28	PREISTUFV	☐	PREISTUFV	PREISTUF	CHAR	10	0	Price level (reference)	TE471
29	HISTCOPY	☐	HISTCOPY	HISTCOPY	CHAR	1	0	Indicator: copy historical data
30	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
31	.INCLUDE	☐				0	0	Creation and Change Data
32	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
33	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
34	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
35	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
36	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
37	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
38	PTYPTEXT	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
39	PARTTEXT	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
40	PSTFTEXT	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
41	TIMTYPTEXT	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
42	DIMTEXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
43	PREINABG	☐	PREINABG	PREINABG	CHAR	1	0	Indicator: do not prorate price
44	PGKLTEXT	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
45	NEXTINT	☐	NEXTINT	NEXTINT	CHAR	1	0	Valuate quantity portions already started using full price
46	MARK	☐	MARK	XFELD	CHAR	1	0	Indicator: posting line selected?
47	FRAN_TYPE	☐	FRAN_TYPE	FRAN_TYPE	CHAR	1	0	Franchise Fee Category
48	EXTPRICE	☐	EXTPRICE	EXTPRICE	CHAR	1	0	External Price
49	TWAERS	☐	TWAERS	WAERS	CUKY	5	0	Transaction Currency	TCURC
50	PTYP_MEN	☐	PTYP_MEN	KENNZX	CHAR	1	0	Price Category "Quantity-Based"
51	PTYP_PAU	☐	PTYP_PAU	KENNZX	CHAR	1	0	Price Category "Flat Rate"
52	PTYP_VER	☐	PTYP_VER	KENNZX	CHAR	1	0	Price Category "Rental Price"
53	PTYP_ZEI	☐	PTYP_ZEI	KENNZX	CHAR	1	0	Price Category "Time-Based"
54	PART_NORM	☐	PART_NORM	KENNZX	CHAR	1	0	Price Type "Standard Price"
55	PART_ZONE	☐	PART_ZONE	KENNZX	CHAR	1	0	Price Type "Block Price"
56	PART_STAF	☐	PART_STAF	KENNZX	CHAR	1	0	Price Type "Scale Price"
57	PRCZONAJ	☐	PRCZONAJ	PRCZONAJ	CHAR	1	0	Type of Price Block Adjustment
58	PRCZOMIN	☐	PRCZOMIN	PRCZOMIN	NUMC	3	0	Lower limit of interval for price block adjustment in days
59	PRCZOMAX	☐	PRCZOMAX	PRCZOMAX	NUMC	3	0	Upper limit of interval for price block adjustment in days
60	FRAN_NO	☐	FRAN_NO	KENNZX	CHAR	1	0	No franchise tax
61	FRAN_CUS	☐	FRAN_CUS	KENNZX	CHAR	1	0	Customer Contribution for Franchise Fee
62	FRAN_COM	☐	FRAN_COM	KENNZX	CHAR	1	0	Company Contribution for Franchise Fee
63	ROUND_UP	☐	ROUND_UP	ROUND_UP	CHAR	1	0	Round up
64	ROUND_DOWN	☐	ROUND_DOWN	ROUND_DOWN	CHAR	1	0	Round down
65	ROUND_KAUF	☐	ROUND_KAUF	ROUND_KAUF	CHAR	1	0	Round Up or Down to the Nearest Whole Number
66	ROUND_NO	☐	ROUND_NO	ROUND_NO	CHAR	1	0	No Rounding
67	TIMTYPRAD1	☐	TIMTYPRAD1	KENNZX	CHAR	1	0	Time category: month
68	TIMTYPRAD2	☐	TIMTYPRAD2	KENNZX	CHAR	1	0	Time category: day
69	TIMTYP_NO	☐	TIMTYP_NO	TIMTYP_NO	CHAR	1	0	No time category required
70	NO_ZONADJ	☐	NO_ZONADJ	NO_ZOANADJ	CHAR	1	0	No Price Block Adjustment
71	KEY_ZONADJ	☐	KEY_ZONADJ	KEY_ZONADJ	CHAR	1	0	Same Price Key
72	AMT_ZONADJ	☐	AMT_ZONADJ	AMT_ZONADJ	CHAR	1	0	Same Price Key/ Amount
73	DPREI_NO	☐	DPREI_NO	DPREI_NO	CHAR	1	0	No Average Price
74	DPREI_HIST	☐	DPREI_HIST	DPREI_HIST	CHAR	1	0	Average Price with Price Hstory
75	DPREI_RUN	☐	DPREI_RUN	DPREI_RUN	CHAR	1	0	Average Price without Price History
76	KA_GRENZPREIS	☐	KA_GRENZPREIS	KENNZX	CHAR	1	0	Price Limit in Franchise Fee
77	PRCONKEY	☐	PRCONKEY	PRCONKEY	CHAR	26	0	Summarized Price Key for Navigation Function
78	APRICES	☐	APRICES	ALL_PRICES	CHAR	1	0	Only Current Valid Prices
79	TIM_ZONADJ	☐	TIM_ZONADJ	TIM_ZONADJ	CHAR	1	0	Price Block Adjustment for Each Time Slice
80	GROSSPRICE	☐	GROSSPRICE	KENNZX	CHAR	1	0	Gross Price
81	PRICEHIST	☐	PRICEHIST	PRICEHIST	CHAR	1	0	Display Complete History for Price Key
82	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	*
83	PRICEORIGIN	☐	PRICEORIGIN	PRICEORIGIN	CHAR	3	0	Price Origin
84	RABART	☐	RABART	RABART	CHAR	1	0	Discount type
85	RABTYP	☐	RABTYP	RABTYP	CHAR	1	0	Discount category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REA89	AKLASSE	EAKLASSE	AKLASSE	REF	1	CN
2	REA89	MANDT	T000	MANDT	KEY	1	CN
3	REA89	MASS	T006	MSEHI		1	CN
4	REA89	PREIGKL	EPRESCL	PREIGKL		1	CN
5	REA89	PREISTUFV	TE471	PREISTUF		1	CN
6	REA89	SPARTE	TSPA	SPART	REF	1	CN
7	REA89	TWAERS	TCURC	WAERS	REF

History

Last changed by/on	SAP	20130529
SAP Release Created in