Read Time31 Second
Lookup tables are stored in fragments. What a compensation analyst sees as a single readable row — “100,000 – 200,000 → 8%” — is physically spread across three or four tables (cs_relationalmdlt, CS_MDLTcell, cs_mdltindex), with separate columns used depending on whether the dimension value is a number, a string, or a date. Writing the SQL to reconstruct that row correctly takes time and is easy to get wrong.
Classifiers come in four distinct types. A classifier in SAP Commissions can be a Product (cs_product), a Customer (cs_customer), a Postal Code (cs_postalcode), or a Generic Classifier (cs_genericclassifier). Business users think of these
