topic Re: Table TVAG WITH BEZEI ? in Application Development and Automation Discussions

Table TVAG WITH BEZEI ?

Former Member — Fri, 01 Aug 2008 12:35:15 GMT

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.

Re: Table TVAG WITH BEZEI ?

ThomasZloch — Fri, 01 Aug 2008 12:37:32 GMT

happy to tell you once you changed the post to lower case.

Re: Table TVAG WITH BEZEI ?

former_member70391 — Fri, 01 Aug 2008 12:47:39 GMT

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

Re: Table TVAG WITH BEZEI ?

Former Member — Fri, 01 Aug 2008 13:17:29 GMT

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 a_{ABGRU a}DRAGR a_{EP_OFF a}FK_ERL a_{KOWRR b}BEZEI into Itab from TVAG as A inner join TVAGT B on a_{ABGRU = b}ABGRU

where b~SPRAS = sy-langu.

Best Regards,

SaravanaKumar.P

Re: Table TVAG WITH BEZEI ?

Former Member — Fri, 01 Aug 2008 13:18:36 GMT

Hi Kumar,

If you want to retrieve all the 6 fields you have to write like

select a_{ABGRU a}DRAGR a_{EP_OFF a}FK_ERL a_{KOWRR b}BEZEI into Itab from TVAG as A inner join TVAGT B on a_{ABGRU = b}ABGRU

where b~SPRAS = sy-langu.

Best Regards,

SaravanaKumar.P