SDPRCG_CNDNR - Condition Record for Pricing in Sales

Condition Record for Pricing in Sales information is stored in SAP table SDPRCG_CNDNR.
It is part of development package VDM_SD_MD_CM in software component SD-MD-CM. This development package consists of objects that can be grouped under "VDM SD Conditions".

Fields for table SDPRCG_CNDNR

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
CONDITIONRECORDUUID	UUID serving as key (parent key, root key)	X	/BOBF/UUID	RAW	16
CONDITIONRECORD	Number of the Condition Record		KNUMH	CHAR	20
CONDITIONSEQUENTIALNUMBER	Sequential number of the condition		KOPOS	NUMC	4
CONDITIONTABLE	Condition Table		KOTABNR_CHAR	CHAR	6
CONDITIONAPPLICATION	Application		KAPPL	CHAR	4
CONDITIONTYPE	Condition Type		KSCHA	CHAR	8
CONDITIONVALIDITYENDDATE	Valid To Date		DATBI	DATS	16
CONDITIONVALIDITYSTARTDATE	Valid-From Date		DATAB	DATS	16
CREATEDBYUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
CREATIONDATE	Date on which the record was created		ERDAT	DATS	16
CONDITIONTEXTID	Number of texts		KNUMT	CHAR	20
PRICINGSCALETYPE	Scale Type		STFKZ	CHAR	2
PRICINGSCALEBASIS	Scale Base Type		KZBZG	CHAR	2
CONDITIONSCALEQUANTITY	Condition Scale Quantity		KSTBM	QUAN	8
CONDITIONSCALEQUANTITYUNIT	Condition Scale Unit of Measure		KONMS	UNIT	6
CONDITIONSCALEAMOUNT	Scale Value		KSTBW	CURR	8
CONDITIONSCALEAMOUNTCURRENCY	Scale Currency		KONWS	CUKY	10
CONDITIONCALCULATIONTYPE	Calculation Type for Condition		KRECH	CHAR	2
CONDITIONRATEVALUE	Condition amount or percentage where no scale exists		KBETR_KOND	CURR	6
CONDITIONRATEVALUEUNIT	Condition Unit (Currency or Percentage)		KONWA	CUKY	10
CONDITIONQUANTITY	Condition Pricing Unit		KPEIN	DEC	3
CONDITIONQUANTITYUNIT	Condition Unit		KMEIN	UNIT	6
CONDITIONTOBASEQTYNMRTR	Numerator for converting condition units to base units		KUMZA	DEC	3
CONDITIONTOBASEQTYDNMNTR	Denominator for converting condition units to base units		KUMNE	DEC	3
BASEUNIT	Base Unit of Measure		MEINS	UNIT	6
CONDITIONLOWERLIMIT	Lower limit of the condition rate/amount		MXWRT	CURR	6
CONDITIONUPPERLIMIT	Upper limit for the condition rate		GKWRT	CURR	6
CONDITIONALTERNATIVECURRENCY	Condition Currency (for Cumulation Fields)		KWAEH	CUKY	10
CONDITIONEXCLUSION	Condition exclusion indicator		KZNEP	CHAR	2
CONDITIONISDELETED	Deletion Indicator for Condition Record		LOEVM_KO	CHAR	2
ADDITIONALVALUEDAYS	Additional Value Days		VALTG	NUMC	4
FIXEDVALUEDATE	Fixed Value Date		VALDT	DATS	16
PAYMENTTERMS	Terms of payment key		DZTERM	CHAR	8
CNDNMAXNUMBEROFSALESORDERS	Maximum number of sales orders per condition record		ANZAUF	NUMC	4
MINIMUMCONDITIONBASISVALUE	Minimum condition base value		MIKBAS	QUAN	8
MAXIMUMCONDITIONBASISVALUE	Maximum condition base value		MXKBAS	QUAN	8
MAXIMUMCONDITIONAMOUNT	Maximum condition value		KOMXWRT	CURR	7
INCREMENTALSCALE	Number of incremental scale		KLF_STG	NUMC	8
PRICINGSCALELINE	Scale number for pricing		KLF_KAL	NUMC	8
CONDITIONRELEASESTATUS	Release Status		KFRST	CHAR	2
SALESPRICEAPPROVALREQUEST	Sales Price Approval Request		SALESPRICEAPPROVALREQUEST	CHAR	20
CONDITIONCHANGEREASON	Reason for Changing Condition Record		CNDN_CHGREASON	CHAR	6