API SP is the latest Petrol Engine Spec - SN is the previous generation spec and CF is a fairly old Diesel oil spec now - Current is CK-4 from memory. But with API specifications, anything starting with S = Spark ignition, C=Combustion ignition.
I would avoid using a pure API SP in a diesel engine as they have lower detergent levels to deal with soot particles(particularly calcium). This is to enable them to deal with low speed pre ignition better in direct injection petrol engine.

