Thank you for your reply. I think you refer to TXT20, TXT50, and MCOD1. Unfortunately, while those attirbutes display in SE16, the attributes do not physically exist on SKA1. It only appears as though they do. Notice that those 3 trailing attributes do not display in the official structure when you view SKA1 via SE11.
SAPGUI does this "trick" often for the COA Name (eg T004 table)
I just would like to confirm what you mean with "its not working".
Do you mean for joining process or retrieving the data ? Since we can retrieve the data even for cluster or pool table.
And I am sorry telling you that we only found this field of COA description (KTPLT) in table T004T as you said. You can double check by using T-code SE84 (ABAP Dictionary -> Fields -> Table Fields, put the field names - KTPLT, and execute to list down all the table(s) using this field)
I should have been more clear. "It is not working" because I need to access these table using native SQL, not Open SQL. At the moment, I need to access the underlying SAP Oracle tables directly.
Hi Ravi, I need to use native SQL (not ABAP Open SQL) to access Chart-of-Account-Name (KTPLT). Unfortunately, I need to access that attribute (KTPLT) from a transparent table, not pooled. The attribute does not physically reside in T004. However, it does reside in SKAT, and that works for me. Thank you for the information!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.