1. Home
  2. Resources
  3. SAP Tables
  4. PRIT_CONDITION - Pricing Condition

SAP Table PRIT_CONDITION

Pricing Condition

PRIT_CONDITION (Pricing Condition) 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 PRIT_CONDITION to other SAP tables.

Source: PRIT_CONDITION (Pricing Condition)

PRIT_CONDITION table fields

Field Data element Checktable Datatype Length Decimals
DOCUMENT_ID Pricing Document GUID PRCT_PRIDOC_GUID RAW 16 0
ITEM_ID Item Number PRCT_ITEM_NO RAW 16 0
STEP_NUMBER Level Number PRCT_PP_STEP NUMC 3 0
COND_COUNTER Condition Counter PRCT_PP_COUNTER NUMC 3 0
APPLICATION Application as Condition Technique /SAPCND/APPLICATION CHAR 3 0
USAGE Usage for Condition Technique /SAPCND/USAGE CHAR 2 0
COND_TYPE Condition Type /SAPCND/COND_TYPE CHAR 4 0
COND_TYPE_DESCR Description of condition PRCT_PRINT_COND_TEXT CHAR 40 0
PURPOSE Condition Function PRCT_COND_PURPOSE CHAR 4 0
DATASOURCE Data Record Source for a Condition Record PRCT_COND_SOURCE CHAR 2 0
NULL Condition technique (old)
A Condition technique (new)
B Cash Flow (FS/Leasing)
C Tax Determination
D Financial mathematics (Leasing)
E Cash Discount
F Billing for One-Time Payments
G EBP: Price From Product Catalog
H Cost
I Floating Rates / Indexation
J IPM: Basic Value
K EBP: Price From Backend Contract
L Social: Requirement Determination
M CRM: Condition from ERP Purchasing Contract
N CRM: Download of an ERP Dispute Case
O CRM: Accruals
Q CRM: Pricing
U UBB: Prebilling
X Customer Reserve 1
Y Customer Reserve 2
Z Customer Reserve 3
EC CRM: External Configurator
CP Pricing: Calculation Tool
COND_RATE Condition Rate PRIT_COND_RATE DEC 28 9
COND_CURRENCY Condition Currency PRCT_COND_CURR CUKY 5 0
COND_UNIT_VALUE Condition Pricing Unit PRCT_COND_PRICING_UNIT DEC 5 0
COND_UNIT Condition Unit PRCT_COND_UOM UNIT 3 0
COND_VALUE Condition Value PRIT_COND_VALUE DEC 28 9
EXCH_RATE Exchange Rate CNVT_EXCH_RATE DEC 9 5
NUMERATOR Counter for Conversion to Base Unit of Measure PRCT_NUMERATOR INT4 10 0
DENOMINATOR Denominator for Conversion to Base Unit of Measure PRCT_DENOMINATOR INT4 10 0
EXPONENT Base 10 Exponent for Conversion to the Base Unit of Measure PRCT_CONV_COND_EXP INT2 5 0
MANUALLY_CHANGED Indicator: Condition Manually Changed PRCT_FLAG_COND_MAN_CHANGED CHAR 1 0
X Yes
NULL No
STATISTICAL Condition is Statistical PRCT_FLAG_COND_STATISTICAL CHAR 1 0
X Yes
NULL No
CALC_TYPE Calculation Type for Condition PRCT_CALCULATION_TYPE CHAR 3 0
PRICING_DATE Time Stamp /SAPCND/TIMESTAMP CHAR 14 0
COND_BASE Condition Base PRIT_COND_BASE DEC 28 9
COND_CATEGORY Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost PRCT_COND_CATEGORY CHAR 1 0
$ TaxJurCode trigger (without license check KNVL)
+ Tax exemption license via conditions
- Reserved (IS-OIL)
0 Reserved (IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer Reserve 5
6 Customer Reserve 6
7 Customer Reserve 7
8 Customer Reserve 8
9 Customer Reserve 9
A Packaging
B Delivery costs
C Insurance
D Tax
E Cash Discount
F Freight
G Cost
H Basic price
I Price for intercompany billing
J Customer expected price / customer value (excl.tax)
K Base amount excluding tax
L Generally new when copying
M Sales tax w/license-checking (VAT)
N Sales tax not deductible (VAT)
O Variants
P Base amount including tax
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer Reserve X
Y Customer Reserve Y
Z Customer Reserve Z
a Reserved (fixed extra pay)
b Transfer price for group valuation for reporting purposes
c Transfer price for profit centers
d Confirmed purchase net price/value
e Down payment request/down payment clearing
f Free goods - inclusive
g Payment
h Profit Center Cost
SCALE_TYPE Scale Type of a Condition PRCT_COND_SCALE_TYPE CHAR 1 0
A Base-scale
B To-scale
D Graduated-to interval scale
ACCRUAL_FLAG Accruals are Set up for the Condition (e.g. Freight) PRCT_FLAG_ACCRUAL CHAR 1 0
X Yes
NULL No
INVOICE_LIST Invoice List Condition Flag PRCT_FLAG_INVOICE_LIST CHAR 1 0
X Yes
NULL No
COND_ORIGIN Condition Origin PRCT_COND_ORIGIN CHAR 1 0
A Automatic pricing
B Duplicated from main item
C Manually entered
D Header condition
E Item total
F Condition supplement
G Original header condition
H Correction Rebate
I Cost Correction
J Transaction Tax Engine
GROUP_CONDITION Condition is Group Condition PRCT_FLAG_GROUP_COND CHAR 1 0
X Group condition
COND_UPDATE Condition Update Flag PRCT_FLAG_COND_UPDATE CHAR 1 0
X Yes
NULL No
ACCESS_COUNTER Condition Counter PRCT_COND_COUNT NUMC 3 0
COND_RECORD_ID ID of a Condition Record PRCT_COND_REC_GUID RAW 16 0
ACCOUNT_KEY_1 Account Key PRCT_ACCOUNT_KEY_1 CHAR 3 0
ACCOUNT_KEY_2 Account Key - Accruals PRCT_ACCOUNT_KEY_2 CHAR 3 0
ROUNDING_DIFF Rounding Difference PRIT_ROUNDING_DIFFERENCE DEC 28 9
COND_CONTROL Condition Control PRCT_COND_STATUS CHAR 1 0
A Adjust for quantity variance
B Free
C Changed manually
D Fixed
E Condition value and basis fixed
F Condition value fixed (billed items)
G Condition basis fixed
H Condition value fixed (cost price)
COND_INACTIVE Condition is Inactive PRCT_FLAG_COND_INACTIVE CHAR 1 0
A Condition exclusion item
G Not applying scale level (in interval scales)
K Inactive due to calculation basis/shipping material type
L Condition exclusion header or inactive at header level
M Inactive due to manual entry
T Inactive at header level
W The document item is statistical
X Inactive Via Formulas or Incorrect
Y Inactive because of subsequent price
COND_CLASS Condition Class PRCT_COND_CLASS CHAR 1 0
A Discount or Surcharge
B Prices
C Expense Reimbursement
D Taxes
E Extra Pay
F Reserved (IS-OIL)
G Tax Code
H Sales Deal Determination
Q Reserved (IS-OIL)
W Withholding Tax
HEADER_COUNTER Condition Counter (Header) PRCT_COND_COUNT_HEAD NUMC 3 0
VARCOND_FACTOR Correction Factor for Conditions From Configuration PRCT_COND_FACTOR_CONFIG FLTP 16 16
SCALE_BASE_TYPE Indicator: Scale Base Type PRCT_SCALE_BASE_TYPE CHAR 3 0
SCALE_BASE_VALUE Pricing: Scale Basis PRCT_SCALE_BASIS DEC 18 5
SCALE_UNIT Condition Scale Unit of Measure PRCT_COND_SCALE_UOM UNIT 3 0
SCALE_CURRENCY Currency Key: Condition Scale PRCT_COND_SCALE_CURR CUKY 5 0
INTER_COMPANY Condition for Inter-Company Billing PRCT_COND_INTER_COMPANY CHAR 1 0
X Yes
NULL No
VARCOND_FLAG Condition for Configuration PRCT_COND_VARIANTS CHAR 1 0
X Yes
NULL No
VARCOND_KEY Variant Key of a Variant Condition PRCT_VARIANT_KEY CHAR 26 0
VARCOND_DESCR Text for a Variant Condition PRCT_VARIANT_DESCRIPTION CHAR 50 0
SALES_TAX_CODE Sales Tax Code PRCT_SALES_TAX_CODE CHAR 2 0
WITHHOLDING_TAX_CODE Withholding Tax Code PRCT_WITHHOLDING_TAX CHAR 2 0
STRUCTURE_CONDITION Structure Condition PRCT_COND_STRUCT CHAR 1 0
A Condition to be duplicated
B Cumulation condition
PERIOD_FACTOR Correction Factor for Condition Basis (Interval Scale) PRCT_COND_BASIS_FACTOR FLTP 16 16
COND_TABLE_NAME Condition Table /SAPCND/COND_TABLE_ID CHAR 8 0
MANUAL_ENTRY_FLAG Give Way Rule for Manual Entries (KMANU) PRCT_COND_MAN_PRIORITY CHAR 1 0
NULL No restrictions
B Automatic entry has priority
C Manual entry has priority
D Not possible to process manually
CHANGE_OF_RATE Condition Rate of Change for Amount/Percentage PRCT_FLAG_EDIT_RATE CHAR 1 0
X Yes
NULL No
CHANGE_OF_UNIT Condition Scope of Change for Unit of Measure PRCT_FLAG_EDIT_UNIT CHAR 1 0
X Yes
NULL No
CHANGE_OF_VALUE Scope for Changing the Value PRCT_FLAG_EDIT_VALUE CHAR 1 0
X Yes
NULL No
CHANGE_OF_CALC_TYPE Condition Rate of Change for Calculation Type PRCT_FLAG_EDIT_RULE CHAR 1 0
X Yes
NULL No
CHANGE_OF_CONV_FACTORS Scope for Changing Conversion Factors PRCT_FLAG_EDIT_CONV CHAR 1 0
X Yes
NULL No
DELETION_ALLOWED Delete the Scope for Changing Rate PRCT_FLAG_EDIT_DELE CHAR 1 0
X Yes
NULL No
ALT_COND_CURRENCY Condition Currency PRCT_COND_CURR CUKY 5 0
ALT_COND_BASE Condition Base PRIT_COND_BASE DEC 28 9
ALT_COND_VALUE Condition Value PRIT_COND_VALUE DEC 28 9