How to get Diagnoses data from table NDIP

[Former Member]

Hi,

Requirement is to get Diagnoses data for Patient during clinical order printing using NWP1.

For this using table NDIP as following:

SELECT * FROM ndip WHERE vkgid = n1vkg-vkgid.

But many times the vkgid (Id of order item) is blank and we couldn't get the data..

Any idea how this can be solved.

Thanks

Anya

[Former Member · Accepted solution]

hi,

according to component model of the clinical order, (preliminary) diagnoses relate to the whole order and therfore are placed in a header component. so, diagnoses have to have a relation to the clinical order and not to the order item. this relation is created via table N1COMPA, which relates most component data to a component and this in turn is related to either the whole order or just an order item.

anyway, IMHO you're not supposed to select data via SQL but use CL_ISH_CORDER->get_diagnosis* methods to retrieve diagnoses for a clinical order.

my 2 cents,

anton