1. Home
  2. Resources
  3. SAP Tables
  4. CRM_COND_STAT_S - contains statistical values for CRM conditions

SAP Table CRM_COND_STAT_S

contains statistical values for CRM conditions

CRM_COND_STAT_S (contains statistical values for CRM conditions) 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 CRM_COND_STAT_S to other SAP tables.

CRM_COND_STAT_S table fields

Field Data element Checktable Datatype Length Decimals
VARNUMH GUID for Condition Interchange Tables VARNUMH_R3 RAW 16 0
KNUMH Condition record number KNUMH CHAR 10 0
KAWRT_ORD Cumulated condition base value MC_KAWRT CURR 19 2
KWERT_ORD Accumulated condition value in local currency MC_KWERT CURR 19 2
NMB_OF_SALES_ORDER Natural Number INT4 INT4 10 0
SALES_ORDER_EXISTS Checkbox XFELD CHAR 1 0
X Yes
NULL No
KWERT_INV Cumulative condition value (Cond.curr.) MC_KWERT_K CURR 19 2
KAWRT_INV Cumulative condition base value (cond.curr.) MC_KAWRT_K CURR 19 2
KSTBS_INV Cumulative scale base value MC_KSTBS CURR 19 2
STWAE_ORD Statistics currency STWAE CUKY 5 0
KWAEH_INV Condition currency (for cumulation fields) KWAEH CUKY 5 0
KMEIN_INV Condition unit KMEIN UNIT 3 0
KZBZG_INV Scale basis indicator KZBZG CHAR 1 0
B Value scale
C Quantity scale
D Gross weight scale
E Net weight scale
F Volume scale
G Scale based on a formula
L Point scale
M Time period scale - Month
N Time period scale - Years
O Time period scale - Days
P Time period scale - Week
R Distance
S Number of shipping units
T reserved (IS-OIL, time prices)
X reserved (IS-OIL, day prices)
KONMS_INV Condition scale unit of measure KONMS UNIT 3 0
KONWS_INV Scale currency KONWS CUKY 5 0
KRECH_INV Calculation type for condition KRECH CHAR 1 0
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly price
O Quantity - daily price
P Quantity - weekly price
Q Commodity Price
R Distance-dependent
S Number of shipping units
T Multi-dimensional
U Percentage FIN (CRM Only)