1. Home
  2. Resources
  3. SAP Tables
  4. ISU_PRICE_D - Screen Price

SAP Table ISU_PRICE_D

Screen Price

ISU_PRICE_D (Screen Price) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ISU_PRICE_D to other SAP tables.

Source: ISU_PRICE_D (Screen Price)

ISU_PRICE_D table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PREIS Price E_PREIS CHAR 10 0
PREISTYP Price category PREISTYP CHAR 1 0
1 Quantity-based price
2 Flat rate
3 Rental price
4 Time-Dependent Price
PREISTUF Price level PREISTUF TE471 CHAR 10 0
SPARTE Division SPARTE TSPA CHAR 2 0
TEXT30 Text Field TEXT50 CHAR 50 0
MASS Unit of Measurement E_MASS T006 UNIT 3 0
AKLASSE Billing class AKLASSE EAKLASSE CHAR 4 0
TIMBASIS Time Basis TIMBASIS CHAR 3 0
TIMTYPRAD1 Time category: month TIMTYPRAD1 CHAR 1 0
NULL Field inactive
X Field active
TIMTYPRAD2 Time category: day TIMTYPRAD2 CHAR 1 0
NULL Field inactive
X Field active
TIMTYP_NO No time category required TIMTYP_NO CHAR 1 0
NULL Field not active
X No time category
DPREI_NO No Average Price DPREI_NO CHAR 1 0
NULL Field not selected
X No average price
DPREI_HIST Average Price with Price Hstory DPREI_HIST CHAR 1 0
NULL Field not selected
X Average price with history
DPREI_RUN Average Price without Price History DPREI_RUN CHAR 1 0
NULL Field not selected
X From billing without history
RUNDUNG Starting Point for Rounding E_RUNDUNG CHAR 2 0
NULL No rounding
-9 Rounding to 9 places before the decimal point
-8 Rounding to 8 places before the decimal point
-7 Rounding to 7 places before the decimal point
-6 Rounding to 6 places before the decimal point
-5 Rounding to 5 places before the decimal point
-4 Rounding to 4 places before the decimal point
-3 Rounding to 3 places before the decimal point
-2 Rounding to 2 places before the decimal point
-1 Rounding to 1 places before the decimal point
0 Rounding to whole numbers
+1 Rounding to 1 decimal place
+2 Rounding to 2 decimal places
+3 Rounding to 3 decimal places
+4 Rounding to 4 decimal places
+5 Rounding to 5 decimal places
+6 Rounding to 6 decimal places
+7 Rounding to 7 decimal places
+8 Rounding to 8 decimal places
+9 Rounding to 9 decimal places
ROUND_UP Round up ROUND_UP CHAR 1 0
X Round up
NULL Field not active
ROUND_DOWN Round down ROUND_DOWN CHAR 1 0
NULL Field not active
X Round down
ROUND_KAUF Round Up or Down to the Nearest Whole Number ROUND_KAUF CHAR 1 0
NULL Field not active
X Round up or down to the nearest whole number
ROUND_NO No Rounding ROUND_NO CHAR 1 0
NULL Field not active
X Do not round
PREISART Price type E_PREISART CHAR 1 0
0 Standard price
1 Block charge
2 Scale price
PSTFTEXT Short Description of Repository Objects AS4TEXT CHAR 60 0
TIMTYPTEXT Short Description of Repository Objects AS4TEXT CHAR 60 0
DIMTEXT Unit of Measurement Text (Maximum 30 Characters) MSEHL CHAR 30 0
PGKLTEXT Short Description of Repository Objects AS4TEXT CHAR 60 0
FRAN_NO No franchise tax FRAN_NO CHAR 1 0
NULL Field inactive
X Field active
FRAN_CUS Customer Contribution for Franchise Fee FRAN_CUS CHAR 1 0
NULL Field inactive
X Field active
FRAN_COM Company Contribution for Franchise Fee FRAN_COM CHAR 1 0
NULL Field inactive
X Field active
NO_ZONADJ No Price Block Adjustment NO_ZONADJ CHAR 1 0
NULL Field not active
X No price block adjustment
KEY_ZONADJ Same Price Key KEY_ZONADJ CHAR 1 0
NULL Field not selected
X Same price key
AMT_ZONADJ Same Price Key/ Amount AMT_ZONADJ CHAR 1 0
NULL Field not selected
X Same price key/ amount
TIM_ZONADJ Price Block Adjustment for Each Time Slice TIM_ZONADJ CHAR 1 0
NULL Field not selected
X By time slice
PRCZOMIN Lower limit of interval for price block adjustment in days PRCZOMIN NUMC 3 0
PRCZOMAX Upper limit of interval for price block adjustment in days PRCZOMAX NUMC 3 0
GROSSPRICE Gross Price GROSSPRICE CHAR 1 0
NULL Field inactive
X Field active
KA_GRENZPREIS Price Limit in Franchise Fee KA_GRENZPREIS CHAR 1 0
NULL Field inactive
X Field active
EXTPRICE External Price EXTPRICE CHAR 1 0
NULL Regular price
X External price
TWAERS Transaction Currency TWAERS TCURC CUKY 5 0
NEXTINT Valuate quantity portions already started using full price NEXTINT CHAR 1 0
NULL No rounding up
X Rounding up to nearest whole number
ANLAGE Installation ANLAGE CHAR 10 0
PRICEORIGIN Price Origin PRICEORIGIN CHAR 3 0
NULL Price Created in IS-U
CRM Price Created in CRM
PREIGKL Price adjustment clause PREIGKL EPRESCL CHAR 10 0
BEGRU Authorization Group BEGRU CHAR 4 0
RABART Discount type RABART CHAR 1 0
1 Fixed discount rate as absolute specification
2 Fixed discount rate as a percentage
RABTYP Discount category RABTYP CHAR 1 0
1 Discount
2 Surcharge

ISU_PRICE_D foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ISU_PRICE_D AKLASSE SYST MANDT EAKLASSE IS-U Billing Classes MANDT
ISU_PRICE_D AKLASSE ISU_PRICE_D AKLASSE EAKLASSE IS-U Billing Classes AKLASSE
ISU_PRICE_D MANDT ISU_PRICE_D MANDT T000 Clients MANDT
ISU_PRICE_D MASS SYST MANDT T006 Units of Measurement MANDT
ISU_PRICE_D MASS ISU_PRICE_D MASS T006 Units of Measurement MSEHI
ISU_PRICE_D PREIGKL SYST MANDT EPRESCL Price Adjustment Clause for All Price Categories MANDT
ISU_PRICE_D PREIGKL ISU_PRICE_D PREIGKL EPRESCL Price Adjustment Clause for All Price Categories PREIGKL
ISU_PRICE_D PREISTUF SYST MANDT TE471 Rental Price Levels MANDT
ISU_PRICE_D PREISTUF ISU_PRICE_D PREISTUF TE471 Rental Price Levels PREISTUF
ISU_PRICE_D SPARTE SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
ISU_PRICE_D SPARTE ISU_PRICE_D SPARTE TSPA Organizational Unit: Sales Divisions SPART
ISU_PRICE_D TWAERS ISU_PRICE_D MANDT TCURC Currency Codes MANDT
ISU_PRICE_D TWAERS ISU_PRICE_D TWAERS TCURC Currency Codes WAERS