08-01-2008 1:35 PM
In Table TVAG i have 6 fields : MANDT, ABGRU, DRAGR, EP_OFF, FK_ERL, KOWRR.
BUT WHEN I SEE THE DATA IN DATA BROWSER I AM GETTING ONE FIELD EXTRA WHICH IS 'BEZEI' WHICH IS DESCRIPTION FOR ABGRU.
AND IF I M USING SELECT STATEMENT TO FETCH BEZEI FROM TVAG, I AM GETTING SYNTAX ERROR.
CAN ANYBODY TELL ME THE REASON.
THANKS
KUMAR N.
08-01-2008 1:37 PM
08-01-2008 1:37 PM
08-01-2008 1:47 PM
Hi Kumar,
The data description for ABGRU is stored in table TVAGT. When you go to SE16 and enter the table TVAG and execute system will execute the report /1BCDWB/DBTVAG and in the program they have return a select query or whatver it is to display the data in output screen.
To no more about it check the program /1BCDWB/DBTVAG via SE38. Click on Display and click on Search button and enter the value SELECT for searching.
Thanks & Regards,
Nagaraj Kalbavi
08-01-2008 2:17 PM
Hi Kumar,
Sales Documents: Rejection Reasons will be stored in TVAG , but Its text are stored in different table TVAGT. In the Data browser view standard SAP combines both tables and displayed 6 fields as you have seen.
If you want to retrieve all the 6 fields you have to write like
select aABGRU aDRAGR aEP_OFF aFK_ERL aKOWRR bBEZEI into Itab from TVAG as A inner join TVAGT B on aABGRU = bABGRU
where b~SPRAS = sy-langu.
Best Regards,
SaravanaKumar.P
08-01-2008 2:18 PM
Hi Kumar,
Sales Documents: Rejection Reasons will be stored in TVAG , but Its text are stored in different table TVAGT. In the Data browser view standard SAP combines both tables and displayed 6 fields as you have seen.
If you want to retrieve all the 6 fields you have to write like
select aABGRU aDRAGR aEP_OFF aFK_ERL aKOWRR bBEZEI into Itab from TVAG as A inner join TVAGT B on aABGRU = bABGRU
where b~SPRAS = sy-langu.
Best Regards,
SaravanaKumar.P