tables which can give information about the variables

[vivekmangalwedhekar]

When we on the system information, we can view the table associated with that field. However no table is linked to the variables. How can I pick this information in a query. eg : how can I catch the variable field at row level for the field, price after discount in the table PCH1.

[Former Member]

Almost all variables are calculated by system. There are no tables to hold such info.

However as for price after discount, it is not a variable but a field value. It is PRICE field in PCH1.

Thanks,

Gordon

[Former Member]

Hi Vivek,

Check this User Query,

SELECT T0.[DocNum], T1.[ItemCode], T1.[DiscPrcnt], T1.[Price], T1.[PriceAfVAT], 
T1.[PriceBefDi], T1.[LineTotal] 
FROM OPCH T0  
INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry

SELECT T0.[DocNum], T1.[ItemCode], T1.[DiscPrcnt], T1.[Price], T1.[LineTotal] 
FROM OPCH T0  
INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry 

Regards,

Madhan.

[vivekmangalwedhekar]

This query is specific for only one variable. Could you tell me how can I catch the data stored as variables.

[Former Member]

Hi!

Some variable fields may exposed in Table, some may not.

Use SDK Help Center > customization tools > Database table refrences to get clear view of Tables and its Fields.