SAP Table J_1IEXCDEFN

Default Condition Types

J_1IEXCDEFN (Default Condition Types) 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 J_1IEXCDEFN to other SAP tables.

J_1IEXCDEFN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D T683 CHAR 6 0
KSCHL Condition Type KSCHL T685 CHAR 4 0
COND_NAME Condition name for Indian tax conditions J_1ICONDNAME CHAR 10 0
ECSARTOT A/R ECS total
BEDSETOFFQ BED Set Off condition Quantity based
BEDINVENTQ BED Inventory Quantity Based
AEDSETOFFQ AED Set Off condition Quantity Based
AEDINVENTQ AED Inventory Quantity Based
SEDSETOFFQ SED Set Off Condition Quantity Based
SEDINVENTQ SED Inventory Quantity Based
BEDSETOFFT BED Set Off condition Total
AEDSETOFFT AED Set Off condition Total
SEDSETOFFT SED Set Off Condition Total
BEDINVENTT BED Inventory Total
AEDINVENTT AED Inventory Total
SEDINVENTT SED Inventory Total
BEDSETOFFP BED Set Off condition Percentage
BEDINVENTP BED Inventory Percentage
AEDSETOFFP AED Set Off condition Percentage
AEDINVENTP AED Inventory Percentage
SEDSETOFFP SED Set Off ConditionPercentage
SEDINVENTP SED Inventory Percentage
BEDARPERC A/R BED Percentage
BEDARQTY A/R BED Quantity based
AEDARPERC A/R AED Percentage
AEDARQTY A/R AED Quantity based
SEDARPERC A/R SED Percentage
SEDARQTY A/R SED Quantity based
CESARPERC A/R Cess Percentage
CESARQTY A/R Cess Quantity Based
APCST A/P Central Sales tax
APLST A/P Local Sales tax
APSUR A/P ST Surcharge
APSETOFF A/P ST setoff
BEDARTOT A/R BED total
AEDARTOT A/R AED total
SEDARTOT A/R SED total
CESARTOT A/R Cess total
NCDSETOFFQ NCCD Set Off condition Quantity Based
NCDSETOFFT NCCD Set Off condition Total
NCDINVENTQ NCCD Inventory Quantity Based
NCDINVENTT NCCD Inventory Total
NCDSETOFFP NCCD Set Off condition Percentage
NCDINVENTP NCCD Inventory Percentage
NCDARPERC A/R NCCD Percentage
NCDARQTY A/R NCCD Quantity based
NCDARTOT A/R NCCD total
ECSSETOFFQ ECS Set Off condition Quantity Based
ECSSETOFFT ECS Set Off condition Total
ECSINVENTQ ECS Inventory Quantity Based
ECSINVENTT ECS Inventory Total
ECSSETOFFP ECS Set Off condition Percentage
ECSINVENTP ECS Inventory Percentage
ECSARPERC A/R ECS Percentage
ECSARQTY A/R ECS Quantity based
CSTAPND A/P CST Non Deductible under VAT
RMDAPVAT A/P VAT RM Deductible
RMNDAPVAT A/P VAT RM Non Deductible
CGDAPVAT A/P VAT CG Deductible
CGNDAPVAT A/P VAT CG Non Deductible
PARVAT A/R VAT Payable
CSTARVAT A/R CST Payable under VAT
AT1SETOFFQ AT1 Set Off condition Quantity Based
AT1SETOFFT AT1 Set Off condition Total
AT1INVENTQ AT1 Inventory Quantity Based
AT1INVENTT AT1 Inventory Total
AT1SETOFFP AT1 Set Off condition Percentage
AT1INVENTP AT1 Inventory Percentage
AT1ARPERC A/R AT1 Percentage
AT1ARQTY A/R AT1 Quantity based
AT1ARTOT A/R AT1 total
AT2SETOFFQ AT2 Set Off condition Quantity Based
AT2SETOFFT AT2 Set Off condition Total
AT2INVENTQ AT2 Inventory Quantity Based
AT2INVENTT AT2 Inventory Total
AT2SETOFFP AT2 Set Off condition Percentage
AT2INVENTP AT2 Inventory Percentage
AT2ARPERC A/R AT2 Percentage
AT2ARQTY A/R AT2 Quantity based
AT2ARTOT A/R AT2 total
AT3SETOFFQ AT3 Set Off condition Quantity Based
AT3SETOFFT AT3 Set Off condition Total
AT3INVENTQ AT3 Inventory Quantity Based
AT3INVENTT AT3 Inventory Total
AT3SETOFFP AT3 Set Off condition Percentage
AT3INVENTP AT3 Inventory Percentage
AT3ARPERC A/R AT3 Percentage
AT3ARQTY A/R AT3 Quantity based
AT3ARTOT A/R AT3 total
SEROFFT A/P Service Tax Set Off
SERECSOFFT A/P Service ECS Set Off
SERAT1OFFT A/P Service SHCess Set Off
SERART A/R Service Tax
SERECSART A/R Service ECS
SERAT1ART A/R Service SHCess
GTASERT GTA Service Tax

J_1IEXCDEFN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1IEXCDEFN KALSM J_1IEXCDEFN KALSM T683 Pricing procedures KALSM
J_1IEXCDEFN KALSM J_1IEXCDEFN MANDT T683 Pricing procedures MANDT
J_1IEXCDEFN KALSM * T683 Pricing procedures KVEWE
J_1IEXCDEFN KALSM * T683 Pricing procedures KAPPL
J_1IEXCDEFN KSCHL J_1IEXCDEFN MANDT T685 Conditions: Types MANDT
J_1IEXCDEFN KSCHL * T685 Conditions: Types KVEWE
J_1IEXCDEFN KSCHL * T685 Conditions: Types KAPPL
J_1IEXCDEFN KSCHL J_1IEXCDEFN KSCHL T685 Conditions: Types KSCHL