Yes and no.....
Technically, you could run the audio outs from your cd player to the video inputs of the screen and have sound without video. But you will need an adapter for the CCD connection on the back of the screen for video input (the yellow RCA connect is for CNEt connection only, not video input). You best option would be a standalone DVD/CD player and the adapter.
Do you have the wire harness for the screen?