on 08-07-2007 3:18 PM
Hello,
What tables and relations would be used to access the customer master sales data short and long text fields in an SQ01 query?
Thanks for your reply.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Texts are stored in pool tables. You won't be able to access directly from SE16. You need to write function module.
ramesh
please award points if you find this information helpful/ resolves your issue.
RTEXT is an structure and iam not sure whether a structure can be used for Abap Query.
chan
structure can not be used in query- check in se11 for table name by specifying field name and also you have to use kna1 table along with knvv
Check this Table KNVV.
I think KNVV would be the starting table and the text tables would be related to KNVV. When doing an F1 on the short and long text fields I get RTEXT-TTEXT and RTEXT-LTEXT but these can't be used in an SQ01 query.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.