Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
I am working on infoset which is reteriving the data through Logical Database and trying to add the field for the field description.
It has to display the data through data element but it is not doing so .
Actually, i had created a query which shows the data about the changes made in the Material.I am able to display all the data but not the text that shows the description of what has been made .
Here's the code:-
TABLES: CDPOS.
DATA: E_DD04V LIKE DD04V OCCURS 0 WITH HEADER LINE.
DATA: E_DD03L LIKE DD03L OCCURS 0 WITH HEADER LINE.
DATA: P_DDTEXT LIKE DD04V-DDTEXT.
IF CDPOS-FNAME <> 'KEY'.
CALL FUNCTION 'GET_FIELDNAME_TEXT_1'
EXPORTING
I_AS4LOCAL = 'A'
I_AS4VERS = '0000'
I_FIELDNAME = CDPOS-FNAME
I_TABNAME = CDPOS-TABNAME
TABLES
E_DD03L = E_DD03L
E_DD04V = E_DD04V
EXCEPTIONS
ERROR_IN_PARAMETERS = 1
NOT_FOUND = 2
OTHERS = 3
.
ENDIF.
IF SY-SUBRC <> 0.
CLEAR E_DD04V-DDTEXT.
* ELSE.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
IF CDPOS-FNAME = 'KEY'.
P_DDTEXT = 'New Entry Made'.
ELSE.
P_DDTEXT = E_DD04V-DDTEXT.
ENDIF.
Please provide me guidelines to solve this problem.
I had chekced the Infoset as it is picking up the data from the Logical database created and when i try to write the code for it,it does not allow to display the data.
I want to know how to add a field in a INFOSET when data is extracting from the existing Logical Database .
Please provide me guidelines to solve this problem.
You can certainly add a additional field in your infoset.
When you are in sq02 tcode and you have made a logical database table than if you go to EXTRAS tab.
You will find a option of create from there you can select a table from where you want to select maktx except the table should have proper joins or you can select a field.
I had created a Logical Data Base where i had made the logic for the Changes Made To Material. I am fetching the data from the following tables:-
MARA,MAKT,CDHDR AND CDPOS.
As i am checking the LDB it is working fine as i had verified the data and i follow the whole procdeure to make Query and then generated it,it is working fine. But when i try to add the extra field (which shows the description what change has been made,it give errors for it).
Please provide me guidelines to solve this problem.
Are you following the procedure mentioned above for addition of field. If your data is getting fetched properly there might be a problem when you select the field in the query. Just check if the additional field has been selected in your query.
I think there might be a problem when you select fields from the query.
Bluesky
