SAP Conditions Tables
Are you looking for the right table related to SAP Conditions Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Conditions (SD-MD-CM) module.
Top 10 tables in Conditions
| Table | Description |
|---|---|
| A113 | Service agent/Dep.cntry/Dep.post.code/Dest.cntry/Dest.PC |
| T682V | Conditions: Condition Type/Access (Execute Header Check) |
| A021 | Vendor/Material/Unit of Measure |
| A073 | Material per SOrg/DstCh |
| A002 | Country/Customer Classification/Material Classification |
| A043 | Purchasing Organization/Material Type |
| A044 | Vendor |
| A007 | Division/Customer |
| A059 | Controlling Area/Company Code |
| A036 | Overhead Type/Order Type |
List of tables in Conditions
| Table | Description |
|---|---|
| A113 | Service agent/Dep.cntry/Dep.post.code/Dest.cntry/Dest.PC |
| T682V | Conditions: Condition Type/Access (Execute Header Check) |
| A021 | Vendor/Material/Unit of Measure |
| A073 | Material per SOrg/DstCh |
| A002 | Country/Customer Classification/Material Classification |
| A043 | Purchasing Organization/Material Type |
| A044 | Vendor |
| A007 | Division/Customer |
| A059 | Controlling Area/Company Code |
| A036 | Overhead Type/Order Type |
| A050 | Sales conditions sample structure for pricing |
| A022 | Material/Unit of Measure |
| A049 | Market Price for Material |
| A016 | Contract Item |
| A064 | Customer Hierarchy |
| A072 | EAN per SOrg/DstCh |
| A037 | Overhead Type/Order Catg. |
| A014 | Overhead Type/Overhead Key |
| A052 | Invoicing Party (Specific to Info Record) |
| A045 | Vendor Condition Group |
| A066 | Info record per order unit |
| A032 | Price group/Material |
| MMPRCG_CM_O_IDX | Index table for Sales Condition Reocrd |
| A025 | Info Record for Non-Stock Item (Plant-Specific) |
| A024 | Distribution Channel/Material/Unit of Measure |
| A033 | Incoterms |
| T681H | Conditions: Usage/Application with Client |
| A015 | Not Used in Standard |
| A054 | Market Price for Material Group |
| A077 | Cost Split for Activities in Contract |
| A069 | Vendor Subrange |
| A063 | Controlling Area/Business Area/Cost Center |
| T681S | Conditions: Fast Entry Types |
| KOTF005 | Search Term |
| A005 | Customer/Material |
| T681Y_BMEN | Condition Maintenance to Area Menu |
| A034 | Incoterms Part 1 + 2 |
| A079 | Sales Organization/Distribution Channel/Material Group |
| A078 | Departure Country / Destination Country |
| MASTER_3000 | Condition Table for Campaign Determination |
| A097 | Activities for Vendor with Plant |
| T681COMP | Cond.: Fig. (KVEWE, KAPPL) --> DF14L (Component Hierarchy) |
| T681T | Conditions: Fast Entry: Texts |
| A120 | Overhead Type/Version |
| A350 | Sales org. |
| A107 | Vendor Hierarchy |
| A147 | Customer Hierarchy (Sales Deal) |
| A080 | Taxes: Material |
| T681OT | Object Category Texts for Index to Conditions |
| TKALSM_VARIANTT | Processing Variants of a Procedure (Pricing,...) Text |
| A071 | Material per Plant |
| T686E | Conditions: Processing Status |
| T682Z | Conditions: Access Sequences (Fields) |
| A027 | Controlling Area |
| A076 | Master Conditions for Activities in Contract |
| T6B1 | Rebate : Rebate Agreement Types |
| SDPRCG_CM_O_IDX | Index table for Sales Condition Reocrd |
| A103 | SOrg/DstCh/MaterialPricingGroup-MainItem/MatPricingGroup |
| A009 | Additional Selling Plant/EAN |
| TVARC | Variant conditions |
| T683V_CMP | Campaign Determination Procedure: Sales Doc. Determination |
| T681YF | Pricing Report: Fields Used |
| T681E | Conditions: Fast-Entry Fields |
| A106 | Price List/Material Group |
| T680VT | Condition: Tree Control: Variants: Texts |
| A058 | Controlling Area/Cost Center Type |
| KOTF006 | Tax exemption license number |
| T681D | Condition: Tables used per Application |
| A109 | Vendor hierarchy: vendor sub-range |
| T682I | Conditions: Access Sequences (Generated Form) |
| A119 | Service agent/Dep.ctry/Dep.post.code /Dest. country |
| VKONDPP_C_FCAT_S | DPP: Relevant Fields in Condition Tables |
| A129 | Service Agent/TariffZDep/TariffZDest/ShipMatType/VSEGR 1 |
| T680M | Condition: Tree Control: Features |
| T681YT | Pricing Report: Texts |
| A104 | Service Conditions (Own Estimate) |
| A114 | Tax Exemption: Customer |
| T681Z | Conditions: Dependent Data for Application/Usage |
| A035 | Overhead Type/Plant |
| LFMC | Supplier master (short texts for condition types) |
| T6B2F | Rebate : Permitted Condition Types/Tables per Group |
| A304 | Material with release status |
| A082 | Contract Conditions without Plant |
| T682IA | Conditions: Access Sequences (Generated Form) |
| T680MT | Condition: Tree Control: Features: Texts? |
| A145 | Sales Deal - Customer/Material |
| T681O | Permitted Document Categories for the Index to Conditions |
| T6B2 | Rebate : Group of permitted Condition Types/Tables |
| T680V | Condition: Tree Control: Variants |
| T686A | Conditions: Exclusion Indicator |
| PRCG_UPLOAD_DATA | Temporary data for pricing excel upload |
| T681A | Conditions: Applications |
| A117 | Tax Exemption - Customer/Material |
| A017 | Material Info Record (Plant-Specific) |
| A116 | Tax Exemption - Customer/Tax Classification 2-Material |
| A055 | Sales conditions sample structure for pricing |
| B521 | Sales org./Customer/Distr. Chl |
| T671 | Conditions: Views |
| CMPB_MAP | Conversion Table CAIMPAIGN CRM <> CMPGN_ID |
| A146 | Customer Hierarchy |
| A173 | CO Area/Ovrhd Type/Fund/Func. Area/GM_GRANT_N |
| A001 | Not Used in Standard |
| SDPRCG_CNDNR | Condition Record for Pricing in Sales |
| A128 | Service Agent/TariffZoneDep/TariffZoneDest/ShippingMatType |
| T6B2T | Rebates : Group of Allowed Condition Types/Tables : Texts |
| A000 | Condition Table for Pricing $ |
| T672 | Conditions: View Sequence |
| T685 | Conditions: Types |
| A004 | Material |
| A353 | ST Code/Region/PlntRegion |
| F000 | Condition Table for Secondary Indexes $ |
| A178 | CO Area/Ovrhd Type/GM_GRANT_N |
| T685T | Conditions: Types: Texts |
| T682VA | Conditions: Condition Type/Access (Execute Header Check) |
| SDPRCG_CNDNR_D | I_SLSPRICINGCONDITIONRECORDTP I_SLSPRICINGCONDITIONRECORDTP |
| T681B | Conditions: Applications: Texts |
| CND_MEM_INITIAL | Conditions: Buffer for Initial Upload |
| A355 | Jur. code |
| KONPT | Conditions (Item) Text |
| A012 | Additional Selling Plant/Material Group |
| A085 | Metal Prices |
| C001 | Cust.Grp/MaterialGrp/AcctKey |
| A4AC | Sales org./Distr. Chl/ChargeCode |
| A108 | Vendor Hierarchy / Material |
| A4AL | Sales Org./Distr. Chl/Refund Code |
| A307 | Customer with Release Status |
| A026 | Controlling Area/Cost Center |
| A371 | Country/Plant/Ctrl code/Ship-to |
| KOTE017 | Campaign ID/Customer/Material |
| A4AF | Stock Segment Price |
| A092 | Wage Type Surcharge without Plant |
| A359 | Plant/Matl group |
| A100 | SOrg/DstCh/Material_MainItem/Material |
| A105 | Controlling Area/Company Code/Business Area |
| A981 | Post.Code/Dest. Ctry |
| KONM | Conditions (1-Dimensional Quantity Scale) |
| KONDIND | General Document Index for Conditions |
| KOTF003 | SD Document/Item |
| A357 | Country/Plant/Ctrl code |
| A068 | Outline Agreement Item: Plant-Dependent |
| KOND | Conditions (Data) |
| A028 | Info Record for Non-Stock Item |
| A352 | ST Code/Post.code/PlntRegion |
| A089 | SD Document/Material |
| KONDH | Conditions: Batch Strategy - Data Division |
| CNDN_UPLD_MSG | Condition upload data and application log |
| A065 | Customer Hierarchy/Material |
| A125 | Service agent/Tariff zone dep./Tariff zone target |
| A274 | Sales org./Distr. chl/Division/Material/Item |
| A008 | Plant/Additional selling plant |
| A148 | Product Hierarchy |
| A057 | Variants |
| A075 | Master Conditions for SRV with Material Group |
| A4AJ | Sales org./Distr. Chl/Customer/Material/Srvc. Org./Pers.No./ |
| A150 | Dest. Ctry/Material |
| A083 | Vendor Conditions with Plant |
| A088 | Taxes: Material, Plant, Account Assignment and Origin |
| A124 | Service agent/Dep.cntry/Dep. PostCode/Tariff zone Dest. loc. |
| A090 | SD Document/Item/Material |
| CND_TABNAM_USAGE | Usage per TABNAME (in BAPIMTCS) |
| COND_POWL_HEAD | Object Types for Conditions@POWL: Header |
| A099 | SD Document/Item |
| A067 | Plant Info Record per Order Unit |
| CNDNRECD_EXTEND | Condition Record Extension |
| A101 | SOrg/DstCh/Material-Main Item/Material Pricing Group |
| A306 | Price list category/currency/material with release status |
| A110 | Sales Organization/Destination Country |
| A179 | CO Area/Ovrhd Type/Fund/GM_GRANT_N |
| A358 | Country/Plant/Ctrl code/Material |
| A096 | Activities for Vendor |
| A135 | Transp. service agent/shipping type/bulk group |
| A093 | Wage Type Surcharge - General |
| COND_O001_105 | for eCATT /SMBUSE/VK15_O001_105 |
| A356 | Country/PlntRegion/ST Code/TaxCl1Cust/TaxCl.Mat |
| COND_POWL_ITEMS | Object Types for Conditions@POWL: Item Data |
| A087 | Taxes: Plant, Account Assignment and Origin |
| B050 | Output Control: Sample Structure for Output Data |
| A273 | Sales org./Distr. chl/Division/Material/Customer/Item |
| A354 | Country/Region/PlntRegion |
| A094 | Taxes: Material, Plant, Origin and Region |
| COND_O300_3G7 | for eCATT /SMB99/VK15_O300_3G7 |
| CND_MAPM_FIELD | Condions Exchange: Convert Field Contents |
| KONAIND | Index: Groups of Conditions/Header Record Conditions |
| A123 | Discount Type/Resp. Cost Center |
| A308 | SD doc./Item/Customer/Personnel |
| A156 | Country of Departure/Destination Country/Del. Country |
| KONA | Agreements |
| A165 | Export Taxes Depending on the Billing Category |
| A086 | Taxes: Material, Plant and Origin |
| CNDN_CHG_REASON | Reason for Changing Condition Record |
| A011 | Country/Country of Dest./Customer Classif./Material Classif. |
| CFG_SD_VK30 | for eCATT /SMB12/VK30_I001_1YM |
| A4AK | Cust Proj/WBS El/WBS WP/Material/Srv Org/Pers No/Wrk Itm |
| C999 | Sales org./AcctAssgGr/AcctAsgnmt/Acct key/Plant |
| A098 | SD Document/Item/Material Pricing Group |
| A095 | Activities + Purchasing Organization |
| A053 | Taxes Using Jurisdiction Code |
| COND_O001_TAX | for eCATT /SMBUSE/TAX_CONDITIONS_O001 |
| A180 | Country/Preference Zone/Cross-Plant Grouping |
| A122 | Surch. type /Profit Center |
| KOTF001 | Material/Sales Org./Distrib.Channel |
| A4AH | Stock Segment price |
| A362 | Country/NBM-NCM Code |
| A369 | Country/Plant/Ctrl code/TaxCl1Cust |
| A601 | SalesDocTy/Ship to |
| A003 | Tax Classification |
| CNDN_CHG_REASONT | Texts: Reason for Changing Condition Record |
| A4CI | Sales Org./Distr. Chl/Customer/Material/Overtime |
| A435 | Sales org./Distr. chl/Customer/Material/DRM Agr No/DRM Itm |
| A030 | Customer/Material Pricing Group |
| T681Y | Conditions: List Variants |
| B055 | C Status, Laboratory |
| T681X | Condition tables for lists |
| A038 | Overhead Type/Company Code |
| T686F | Conditions: Processing Status: Texts |
| KOTF004 | Service No./Plant/PurchOrg/Vendor/Package Number/Line Number |
| T685A | Conditions: Types: Additional Price Element Data |
| A081 | Contract Conditions at Plant Level |
| T681 | Conditions: Structures |
| A042 | Country/State/City/Customer Classif.3/Material Classif.3 |
| T681U | Parameters for creating pricing reports |
| T681W | Conditions: Usage: Texts |
| A774 | CoCode/Customer/Material |
| A4AD | Purch.Org./ChargeCode |
| CND_MEM_INF_UPL | Lock Table for Initial Load |
| A4AG | Stock Segment Price (Supplier Specific) |
| A185 | Order no./Item/Configuration no./Material/Preference zone |
| A181 | TaxIndPlnt/Tax type |
| KOTD602 | New Material Sub Access Seq |
| A019 | Contract Header |
| KOTN017 | Campaign ID/Material |
| T671T | Conditions: Views (Text) |
| CNDN_UPLD_HIST | Condition upload data log |
| A166 | Region-Dependent Tax on Sales |
| T686B | Conditions: Exclusion Indicator: Texts |
| A060 | Controlling Area/Business Area |
| A112 | Service agent |
| KOTD601 | Sales org./Material |
| A018 | Material Info Record |
| K002 | Condition(s) for Customer |
| T682T | Conditions: Access Sequences: Texts |
| A4PB | Cust Proj/Material |
| A084 | Vendor Conditions without Plant |
| A118 | Empties Prices (Material-Dependent) |
| A144 | Sales Deal Basic Data |
| A149 | Customer-dependent data determination |
| T689 | Download Profile for the Conditions |
| T689K | Reference: Download Profile - Pricing Procedures |
| A041 | Country/State/County/Customer Classif.2/Material Classif.2 |
| KONP | Conditions (Item) |
| PRCGCNDN_EXTN | Condition Table Extension for Pricing |
| A4MA | Purch.doc./Item/Unique ID |
| COND_O200_J01 | for eCATT /SMB99/VK15_O200_J01 |
| T682 | Conditions: Access Sequences |
| A039 | Overhead Type/Business Area |
| A047 | Material Group Prices (Plant-Specific) |
| CND_MIG_SAP_FLDS | Condition Migration: SAP Fields |
| VKONDPP_C_FCAT_C | DPP: Relevant Fields in Condition Tables |
| A177 | CO Area/Ovrhd Type/Func. Area |
| TVARCT | Text for Variants Conditions |
| A126 | Service Agent/TariffZoneDep/TariffZoneDest/Freight Class |
| A115 | Ser.agnt/Dep.ctry/Dep.PC /Ship-to party |
| A023 | Additional Selling Plant/Material/Unit of Measure |
| CND_MAP_KNUMH | Conversion Table VARNUMH CRM <> KNUMH ... DATBI |
| A051 | Invoicing Party |
| A102 | SOrg/DstCh/Material Pricing Group-Main Item/Material |
| A302 | SD doc./Item/Customer |
| A313 | SD Doc./Item/Personnel/Sold-to pt/No.ser.no./Customer |
| KONH | Conditions (Header) |
| T681V | Conditions: Usages |
| A4AE | Requirement Segment Price |
| A182 | Region/PlntRegion/Plant/Tax ind. |
| VBOX | SD Document: Billing Document: Rebate Index |
| A390 | Brazil: 100% reversals |
| T681F | Conditions: Allowed Fields Per Usage and Application |
| T682T_I | Text Verticalization: Delta Table for T682T |
| A172 | Campaign ID/Material |
| T6B1T | Rebate: Agreement Types : Texts |
| A029 | Material Pricing Group |
| T685Z | Condition Types: Lower/Higher Limits for Pricing Elements |
| T682ZA | Conditions: Access Sequences (Fields) |
| COND_O001_J01 | for eCATT /SMB99/MEK1_O001_J01 |
| A309 | SD Doc./Customer/Personnel |
| A4CL | Sales Org./Distr. Chl/Overtime/Customer/Material |
| A006 | Price List Type/Currency/Material |
| A305 | Customer/material with release status |
| A046 | Material Group Prices |
| A013 | Overhead Type |
| TREB_DEF_MAP_IM | Billing Document Determination Rebate: Mapping |
| A176 | CO Area/Ovrhd Type/Fund |
| CND_MAPC_FIELD | Condions Exchange: Convert Field Contents |
| T688T | Condition: Copying Rules for Condition Tables |
| T688 | Condition: Copying Rules for Condition Tables |
| A031 | Price Group/Material Pricing Group |
| A040 | Country/State/Customer Classif.1/Material Classification 1 |
| A368 | Country/PlntRegion/Region/TaxCl1Cust/TaxCl.Mat |
| TKALSM_VARIANT | Processing Variants of a Procedure (Pricing,...) |
| A932 | custom SO DC Price group material |
| A010 | Additional Selling Plant/Material |
| TREB_CUST_MAP_IM | Billing Doc. Determination f. Rebate: Cust.-Specific Mapping |
| KOTF002 | Customer/Sales Org./Dist.Channel/Division |
| BONARCH | Archiving: Billing Documents Subject to Volume-Based Rebate |
| CND_USAGE_PREFIX | Prefix for Every Usage |
| A061 | Controlling Area/Cost Center Type/Cost Center |
| A174 | CO Area/Ovrhd Type/Func. Area/GM_GRANT_N |
| A300 | Statistical value of subcontracting components |
| A056 | Sales conditions sample structure for pricing |
| A127 | Service Agent/TariffZoneDep/TariffZoneDest/Incoterms |
| A363 | Plant/Vendor/Material |
| A367 | Country/Plant/Region/Material |
| KONW | Conditions (1-Dimensional Value Scale) |
| A062 | Controlling Area/Company Code/Cost Center |
| T688K | Condition: Copying Rules for Condition Types |
| A301 | Info record type and Incoterms |
| A372 | Sales org./Ref.doc./Ref.item |
| C002 | Cust.Grp/Account Key |
| A175 | CO Area/Ovrhd Type/Fund/Func. Area |
| A140 | Sales Area / Accounting Indicator |
| A048 | Sales conditions sample structure for pricing |
| T689T | Text Table for T689 |
| A070 | EAN per Plant |
| A020 | Division/Price Group |
| A091 | Wage Type Surcharge at Plant Level |