SAP table ISU_PRICE_D (Screen Price)

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

ISU_PRICE_D foreign key relationships

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