KOND SAP (Conditions (Data)) Table details

Dictionary Type: Table
Description: Conditions (Data)




ABAP Code to SELECT data from KOND
Related tables to KOND
Access table KOND




Table field list including key, data, relationships and ABAP select examples

KOND is a standard SAP Table which is used to store Conditions (Data) data and is available within R/3 SAP systems depending on the version and release level.

The KOND table consists of various fields, each holding specific information or linking keys about Conditions (Data) data available in SAP. These include KNUMD (Condition record number), ZUSKO (Number of additional condition), KSCHL (Condition Type), ERNAM (Name of Person who Created the Object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP KOND table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
KNUMDCondition record number KNUMDCHAR10KNUMB
ZUSKONumber of additional condition DZUSKONUMC2NUM02
KSCHLCondition Type KSCHLCHAR4Assigned to domainKSCHLVKS
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
KNUMBRebate data number KNUMBCHAR10KNUMB
KNUMKAccount assignment number KNUMKCHAR10KNUMB
KNUMTNumber of texts KNUMTCHAR10KNUMB
KNUMSNumber of scale values KNUMSCHAR10KNUMB
KNUM1Number of the line scale (scaling) KNUM1CHAR10KNUMB
STFKZScale Type STFKZCHAR1STFKZ
KZBZGScale basis indicator KZBZGCHAR1KZBZG
KONBEScale basis (unit of measure) KONBECHAR5KONBE
KNUM2Number of column scale KNUM2CHAR10KNUMB
STFK2Scale Type STFKZCHAR1STFKZ
KZBZ2Scale basis indicator KZBZGCHAR1KZBZG
KONB2Scale basis (unit of measure) KONBECHAR5KONBE
KRECHCalculation type for condition KRECHCHAR1KRECH
KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
KPEINCondition pricing unit KPEINDEC5KPEIN
KUMZANumerator for converting condition units to base units KUMZADEC5UMBSZ
KUMNEDenominator for converting condition units to base units KUMNEDEC5UMBSN
KWAEHCondition currency (for cumulation fields) KWAEHCUKY5Assigned to domainWAERSFWS
KSKTOCondition is qualifying for cash discount KSKTOCHAR1XFELD
KNTYPCondition category (examples: tax, freight, price, cost) KNTYPCHAR1KNTYP
KMWSTCondition VAT indicator KMWSTCHAR2KMWST
KSTATCondition is used for statistics KSTATCHAR1XFELD
KNPRSPricing type KNPRSCHAR1KNPRS
KRUEKCondition is Relevant for Accrual (e.g. Freight) KRUEKCHAR1XFELD
KRELICondition for invoice list KRELICHAR1KRELI
KMANUMaking manual entries KMANUCHAR1KMANU
KGRPEGroup condition KGRPECHAR1KGRPE
KAUFTAbsolute condition is to be split up KAUFTCHAR1KAUFT
MXWRTLower limit of the condition rate/amount MXWRTCURR11(2) WERTV6
GKWRTUpper limit for the condition rate GKWRTCURR11(2) WERTV6
PKWRTPlanned condition value PKWRTCURR15(2) WERTV8
FKWRTCumulative guaranteed discount (not used) FKWRTCURR15(2) WERTV8
RSWRTAccumulated accruals values (not used) RSWRTCURR15(2) WERTV8
UKBASPlanned condition basis UKBASCURR15(2) WERTV8
PRBASPrice basis PRBASCURR11(2) WERTV6
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KONKZAccount assignment allowed KONKZCHAR1KONKZ
KZNEPCondition exclusion indicator KZNEPCHAR1Assigned to domainKZNEP
KOUPDCondition update KOUPDCHAR1XFELD
STBASAccumulated scale base (from settlement run) STBASCURR15(2) WERTV8
KOBASCumulative condition basis (from settlement run) KOBASCURR15(2) WERTV8
GRUMSMinimum business volume GRUMSCURR15(2) WERTV8
MAXRAMaximum discount from total sales volume MAXRACURR11(2) WERTV6
AUBETPayment amount AUBETCURR11(2) WERTV6
ABRBGStart of accounting settlement period ABRBGDATS8DATUM
ABRENEnd of accounting settlement period ABRENDATS8DATUM
KWRTAPayment amount KWRTACURR11(2) WERTV6
KWRTRAccrual Amount KWRTRCURR11(2) WERTV6
KVSL1Account key KVSL1CHAR3Assigned to domainKVSCHL
KVSL2Account key - accruals / provisions KVSL2CHAR3Assigned to domainKVSCHL
KSTBSScale base value of the condition KSTBSCURR15(2) WERTV8
KBETRRate (condition amount or percentage) where no scale exists KBETR_KONDCURR11(2) WERTV6

Key field Non-key field



How do I retrieve data from SAP table KOND using ABAP code

The following ABAP code Example will allow you to do a basic selection on KOND to SELECT all data from the table
DATA: WA_KOND TYPE KOND.

SELECT SINGLE *
FROM KOND
INTO CORRESPONDING FIELDS OF WA_KOND
WHERE...

How to access SAP table KOND

Within an ECC or HANA version of SAP you can also view further information about KOND and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!