Formatted search on User Table

[Former Member]

Hi..,

I need to set formatted search for user table which is @DCNR . My Requirement is that i need to Pick CST NO from BP Master . In my user screen i had taken CARDCODE value using CFL which is binded to the field U_ven in the table @DCNR.Using this CARDCODE value i need to pick CSTNO from BP master to the user screen which is binded to the table (@DCNR).My Query is as follows but it is not working,

SELECT crd7.taxid1 from crd7 inner join @dcnr on crd7.cardcode = @dcnr.u_ven where crd7.cardcode = $[@dcnr.u_ven]

U_VEN field contains card code value.

Do i need to follow some other terms in order to write formatted search on user table.

Hope some one would help to fix this problem.

thank u,

-Ashok Krishnan

[former_member583013 · Accepted solution]

Ashok,

User tables generally have the Item number as 3. This is in connection with using them in a formatted search. Therefore instead of using [@DCNR\], I would suggest you use $\[$3......]

Please try the SQL below and let me know

SELECT T0.TaxID1 FROM [dbo\].[CRD7\] T0 WHERE T0.CardCode=$\[$3.U_Ven]

Best wishes

Suda

[Former Member]

hi try this one

SELECT crd7.taxid1 from crd7 inner join @dcnr on crd7.cardcode = @dcnr.u_ven where crd7.cardcode = $[@dcnr.u_ven]

regards,

Avijit

[former_member583013]

Ashok,

If this question is answered please mark this answered.

Suda

[Former Member]

Hi Ashok,

Try to use full name of your table:

dbo.[@DCNR]

Thanks,

Gordon

[marcella_rivi]

Dear Mr Krishnan,

As a starting poing I would suggest reading these documents regarding UDF and Formatted search:

https://websmp108.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_HIER_KEY=701100035871000437965&_OBJECT=01...;

https://websmp108.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_HIER_KEY=701100035871000437965&_OBJECT=01...;

let us know if they were usefull.

Kind Regards,

Marcella Rivi

SAP Business One Forums Team

Edited by: Paul Finneran on Aug 14, 2008 1:15 PM