What are the career prospects for sap sd module at present?

SAP - SD is good. (In fact all the domains are nice). As a fresher you may find it difficult to enter into SAP domain without any relevant exp. But you need to try hard to get a break. Keep applying for jobs constantly without losing hope. Once you get a break and gain some 2-3yrs of relevant exp in SAP then you will have a wonderful career ahead. Its only a matter of time