UDF Value not showing in SQL

[former_member209725]

Dear Experts...

Here is a strange situation in my DB. I have some UDF on A/P Invoice for TAX details print preview.

UDF Values are properly showing in SAP but not in SQL in same table, Same document they are blank in SQL.

I can't understand why SQL does not showing me Value of UDF.

Regards,

Ravi

[former_member206488 · Accepted solution]

Hi Ravi,

Run below query in query generator for specific document number and check if udf values are shown or not?

SELECT T0.DocNum, T0.CardCode As 'Vendor Code',T0.CardName As 'Vendor Name', T0.NumAtCard As 'Vendor Ref. No.', T0.DocDate, T0.TaxDate, T0.DocTotal - T0.VatSum As 'Basic Value of Goods', T0.U_CENVAT As 'CENVAT', T0.U_ECess, T0.U_HSCess, T0.U_VAT_4, T0.U_Add_VAT1, T0.U_VAT_12,

T0.U_Add_VAT2, T0.U_CST2, T0.U_CST4, T0.U_CST5, T0.U_Service_Tax, T0.U_ST_ECess, T0.U_ST_HSCess,T0.TotalExpns As 'Others',T0.DocTotal - T0.VATSUM As 'Total' FROM OPCH T0 WHERE T0.docType = 'I' and T0.DocNum=[%0]

Thanks,

Neetu

[former_member209725 · Accepted solution]

Hi Mam..

Thanks for reply.

No, Value still not shown in Report.

Regards,

Ravi

[former_member206488 · Accepted solution]

It seems values dispalyed on screen in SAP are just screen values due to FMS. And they are not saved in SAP.

Did you applied FMS after adding the documents ,if so you have to update UDF's and then update invoice.

Thanks,

Neetu

[former_member209725 · Accepted solution]

closed.

[Former Member]

HI

is that values for that columns are 'empty' in SQL?

Did you select "TOP 1000 rows"?

[former_member209725]

Hi Kambadasan...

Thanks Man for reply.

here is clarification :

1. is that values for that columns are 'empty' in SQL

Yes, They are blank in SQL but Value shoing in SAP.

2. Did you select "TOP 1000 rows" ?

I just put query *Select * from OPCH* and found blank fields in SQL which have been stored Values in SAP.

Regards,

RAvi