Community
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.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Display all line items.

Former Member

‎2010 Sep 23 8:11 AM

0 Likes
1,247

Dear Friends,

I develop to new screen in this screen having table control. Table control fields I taken a table fields of ZMDISP_ITEM table fields. but I call to this table control I want to directly display ZMSAMP_ITEM fields in our table control table. I given below coding. In this coding only one line item displayed. what can i do please help me any body.

SELECT SINGLE * FROM ZMRECIPT_ITEM "INTO TABLE IT_REC_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

IF SY-SUBRC = 0.

ZMDISP_ITEM-RECREFNO = ZMRECIPT_ITEM-RECREFNO.

ZMDISP_ITEM-BUKRS = ZMRECIPT_ITEM-BUKRS.

ZMDISP_ITEM-LOTNO = ZMRECIPT_ITEM-LOTNO.

ZMDISP_ITEM-SMPCODE = ZMRECIPT_ITEM-SMPCODE.

ZMDISP_ITEM-CDDATE = ZMRECIPT_ITEM-CDDATE.

ZMDISP_ITEM-LOTQTY = ZMRECIPT_ITEM-LOTQTY.

ZMDISP_ITEM-MEINS = ZMRECIPT_ITEM-MEINS.

ZMDISP_ITEM-VARCD = ZMRECIPT_ITEM-VARCD.

  • clear zmrecipt_header.

CALL SCREEN '0001'.

  • populating Dispatch item details

SELECT * FROM ZMDISP_ITEM INTO TABLE IT_DISP_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

CLEAR P_RREFNO.

  • V_RREFNO = ZMDISP_HEADER-RECREFNO.

IT_DISP_ITEM-RECREFNO = ZMDISP_ITEM-RECREFNO.

IT_DISP_ITEM-BUKRS = ZMDISP_ITEM-BUKRS.

IT_DISP_ITEM-LOTNO = ZMDISP_ITEM-LOTNO.

IT_DISP_ITEM-SMPCODE = ZMDISP_ITEM-SMPCODE.

IT_DISP_ITEM-CDDATE = ZMDISP_ITEM-CDDATE.

IT_DISP_ITEM-LOTQTY = ZMDISP_ITEM-LOTQTY.

IT_DISP_ITEM-MEINS = ZMDISP_ITEM-MEINS.

IT_DISP_ITEM-VARCD = ZMDISP_ITEM-VARCD.

APPEND IT_DISP_ITEM.

Regards

Sreelakshmi.

Dear Friends,

I develop to new screen in this screen having table control. Table control fields I taken a table fields of ZMDISP_ITEM table fields. but I call to this table control I want to directly display ZMSAMP_ITEM fields in our table control table. I given below coding. In this coding only one line item displayed. what can i do please help me any body.

SELECT SINGLE * FROM ZMRECIPT_ITEM "INTO TABLE IT_REC_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

IF SY-SUBRC = 0.

ZMDISP_ITEM-RECREFNO = ZMRECIPT_ITEM-RECREFNO.

ZMDISP_ITEM-BUKRS = ZMRECIPT_ITEM-BUKRS.

ZMDISP_ITEM-LOTNO = ZMRECIPT_ITEM-LOTNO.

ZMDISP_ITEM-SMPCODE = ZMRECIPT_ITEM-SMPCODE.

ZMDISP_ITEM-CDDATE = ZMRECIPT_ITEM-CDDATE.

ZMDISP_ITEM-LOTQTY = ZMRECIPT_ITEM-LOTQTY.

ZMDISP_ITEM-MEINS = ZMRECIPT_ITEM-MEINS.

ZMDISP_ITEM-VARCD = ZMRECIPT_ITEM-VARCD.

  • clear zmrecipt_header.

CALL SCREEN '0001'.

  • populating Dispatch item details

SELECT * FROM ZMDISP_ITEM INTO TABLE IT_DISP_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

CLEAR P_RREFNO.

  • V_RREFNO = ZMDISP_HEADER-RECREFNO.

IT_DISP_ITEM-RECREFNO = ZMDISP_ITEM-RECREFNO.

IT_DISP_ITEM-BUKRS = ZMDISP_ITEM-BUKRS.

IT_DISP_ITEM-LOTNO = ZMDISP_ITEM-LOTNO.

IT_DISP_ITEM-SMPCODE = ZMDISP_ITEM-SMPCODE.

IT_DISP_ITEM-CDDATE = ZMDISP_ITEM-CDDATE.

IT_DISP_ITEM-LOTQTY = ZMDISP_ITEM-LOTQTY.

IT_DISP_ITEM-MEINS = ZMDISP_ITEM-MEINS.

IT_DISP_ITEM-VARCD = ZMDISP_ITEM-VARCD.

APPEND IT_DISP_ITEM.

Regards

Sreelakshmi.

Reply
7 REPLIES 7
Read only

Former Member

‎2010 Sep 23 8:24 AM

0 Likes
1,172

HI Sri ,

Iam not getting wat is ur issue ,

1. do u want to display data from ZMDISP_ITEM or from ZMSAMP_ITEM ?

2. Are you displaying the records from the internal table IT_DISP_ITEM into table control ?

3. Check in the ZMDISP_ITEM table how many records are there for the combination in the select you have given

Read only

Former Member
In response to Former Member

‎2010 Sep 23 8:32 AM

0 Likes
1,172

Dear Friends,

I develop to new screen in this screen having table control. Table control fields I taken a table fields of ZMDISP_ITEM table fields. but I call to this table control I want to directly display ZMRECIPT_ITEM fields in our table control table. I given below coding. In this coding only one line item displayed. what can i do please help me any body.

SELECT SINGLE * FROM ZMRECIPT_ITEM "INTO TABLE IT_REC_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

IF SY-SUBRC = 0.

ZMDISP_ITEM-RECREFNO = ZMRECIPT_ITEM-RECREFNO.

ZMDISP_ITEM-BUKRS = ZMRECIPT_ITEM-BUKRS.

ZMDISP_ITEM-LOTNO = ZMRECIPT_ITEM-LOTNO.

ZMDISP_ITEM-SMPCODE = ZMRECIPT_ITEM-SMPCODE.

ZMDISP_ITEM-CDDATE = ZMRECIPT_ITEM-CDDATE.

ZMDISP_ITEM-LOTQTY = ZMRECIPT_ITEM-LOTQTY.

ZMDISP_ITEM-MEINS = ZMRECIPT_ITEM-MEINS.

ZMDISP_ITEM-VARCD = ZMRECIPT_ITEM-VARCD.

  • clear zmrecipt_header.

CALL SCREEN '0001'.

  • populating Dispatch item details

SELECT * FROM ZMDISP_ITEM INTO TABLE IT_DISP_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

CLEAR P_RREFNO.

  • V_RREFNO = ZMDISP_HEADER-RECREFNO.

IT_DISP_ITEM-RECREFNO = ZMDISP_ITEM-RECREFNO.

IT_DISP_ITEM-BUKRS = ZMDISP_ITEM-BUKRS.

IT_DISP_ITEM-LOTNO = ZMDISP_ITEM-LOTNO.

IT_DISP_ITEM-SMPCODE = ZMDISP_ITEM-SMPCODE.

IT_DISP_ITEM-CDDATE = ZMDISP_ITEM-CDDATE.

IT_DISP_ITEM-LOTQTY = ZMDISP_ITEM-LOTQTY.

IT_DISP_ITEM-MEINS = ZMDISP_ITEM-MEINS.

IT_DISP_ITEM-VARCD = ZMDISP_ITEM-VARCD.

APPEND IT_DISP_ITEM.

ZMRECIPT_ITEM table data strored 5 line items. but i want to getting in my table control ZMRECIPT_ITEM table data of all line items. Table control fields are in zmdisp_item fields.

zmreceipt_item fields and zmrecipt_item_fields are same.

Regards.

Sreelakshmi.

Read only

Former Member
In response to Former Member

‎2010 Sep 23 8:35 AM

0 Likes
1,172

HI,

You are selecting a single record from table ZMRECIPT_ITEM so you will get a single record

SELECT SINGLE * FROM ZMRECIPT_ITEM "INTO TABLE IT_REC_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

IF SY-SUBRC = 0.

ZMDISP_ITEM-RECREFNO = ZMRECIPT_ITEM-RECREFNO.

ZMDISP_ITEM-BUKRS = ZMRECIPT_ITEM-BUKRS.

ZMDISP_ITEM-LOTNO = ZMRECIPT_ITEM-LOTNO.

ZMDISP_ITEM-SMPCODE = ZMRECIPT_ITEM-SMPCODE.

ZMDISP_ITEM-CDDATE = ZMRECIPT_ITEM-CDDATE.

ZMDISP_ITEM-LOTQTY = ZMRECIPT_ITEM-LOTQTY.

ZMDISP_ITEM-MEINS = ZMRECIPT_ITEM-MEINS.

ZMDISP_ITEM-VARCD = ZMRECIPT_ITEM-VARCD.

Read only

Former Member
In response to Former Member

‎2010 Sep 23 9:56 AM

0 Likes
1,172

HI,

Already i tries this coading but not displed .

SELECT S * FROM ZMRECIPT_ITEM INTO TABLE IT_REC_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

IF SY-SUBRC = 0.

ZMDISP_ITEM-RECREFNO = ZMRECIPT_ITEM-RECREFNO.

ZMDISP_ITEM-BUKRS = ZMRECIPT_ITEM-BUKRS.

ZMDISP_ITEM-LOTNO = ZMRECIPT_ITEM-LOTNO.

ZMDISP_ITEM-SMPCODE = ZMRECIPT_ITEM-SMPCODE.

ZMDISP_ITEM-CDDATE = ZMRECIPT_ITEM-CDDATE.

ZMDISP_ITEM-LOTQTY = ZMRECIPT_ITEM-LOTQTY.

ZMDISP_ITEM-MEINS = ZMRECIPT_ITEM-MEINS.

ZMDISP_ITEM-VARCD = ZMRECIPT_ITEM-VARCD.

below vales are blank.

ZMDISP_ITEM-RECREFNO

ZMDISP_ITEM-BUKRS

ZMDISP_ITEM-LOTNO

ZMDISP_ITEM-SMPCODE

ZMDISP_ITEM-CDDATE

ZMDISP_ITEM-LOTQTY

ZMDISP_ITEM-MEINS

ZMDISP_ITEM-VARCD

please give correct solution of this problem.

Regards

Sreelakshmi.

Read only

Former Member
In response to Former Member

‎2010 Sep 23 10:10 AM

0 Likes
1,172

Hi

First you have to manually check the table ZMRECIPT_ITEM

with your input ,check all field are having value for that input...

For multiple line item you have use loop.

is there any relation ship netween teo tables?

Read only

Former Member
In response to Former Member

‎2010 Sep 23 10:16 AM

0 Likes
1,172

Hi,

is ZMDISP_ITEM-RECREFNO your internal table or data dictionary table?

you cannot modify the data dictionary table directly using

ZMDISP_ITEM-RECREFNO = ZMRECIPT_ITEM-RECREFNO.
ZMDISP_ITEM-BUKRS = ZMRECIPT_ITEM-BUKRS.
ZMDISP_ITEM-LOTNO = ZMRECIPT_ITEM-LOTNO.
ZMDISP_ITEM-SMPCODE = ZMRECIPT_ITEM-SMPCODE.
ZMDISP_ITEM-CDDATE = ZMRECIPT_ITEM-CDDATE.
ZMDISP_ITEM-LOTQTY = ZMRECIPT_ITEM-LOTQTY.
ZMDISP_ITEM-MEINS = ZMRECIPT_ITEM-MEINS.
ZMDISP_ITEM-VARCD = ZMRECIPT_ITEM-VARCD.

you have to use modify statement.

SELECT * FROM ZMDISP_ITEM INTO TABLE IT_DISP_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

Check sy-subrc after this statement may be there are no records at all or just one record

CLEAR P_RREFNO.

  • V_RREFNO = ZMDISP_HEADER-RECREFNO.

IT_DISP_ITEM-RECREFNO = ZMDISP_ITEM-RECREFNO.

IT_DISP_ITEM-BUKRS = ZMDISP_ITEM-BUKRS.

IT_DISP_ITEM-LOTNO = ZMDISP_ITEM-LOTNO.

IT_DISP_ITEM-SMPCODE = ZMDISP_ITEM-SMPCODE.

IT_DISP_ITEM-CDDATE = ZMDISP_ITEM-CDDATE.

IT_DISP_ITEM-LOTQTY = ZMDISP_ITEM-LOTQTY.

IT_DISP_ITEM-MEINS = ZMDISP_ITEM-MEINS.

IT_DISP_ITEM-VARCD = ZMDISP_ITEM-VARCD.

APPEND IT_DISP_ITEM.

for displaying multiple records, you need to write the above code in loop.

regards,

Sakshi

Read only

Former Member
In response to Former Member

‎2010 Sep 23 10:17 AM

0 Likes
1,172

Sri,

SELECT *

FROM ZMRECIPT_ITEM INTO TABLE IT_REC_ITEM

WHERE ( BUKRS = P_BUKRS AND ZYEAR = P_YEAR AND RECREFNO = P_RREFNO ).

Solution 1.

Have u written this code in Flow logic PBO

loop at IT_REC_ITEM.

module update_field_val.

endloop.

MOdule update_field_val.

ZMDISP_ITEM-RECREFNO = IT_REC_ITEM-RECREFNO.

ZMDISP_ITEM-BUKRS = IT_REC_ITEM-BUKRS.

ZMDISP_ITEM-LOTNO = IT_REC_ITEM-LOTNO.

ZMDISP_ITEM-SMPCODE = IT_REC_ITEM-SMPCODE. me11

ZMDISP_ITEM-CDDATE = IT_REC_ITEM-CDDATE. vk11

ZMDISP_ITEM-LOTQTY = IT_REC_ITEM-LOTQTY. rm06ibi0

ZMDISP_ITEM-MEINS = IT_REC_ITEM-MEINS.

ZMDISP_ITEM-VARCD = IT_REC_ITEM-VARCD.

endmodule.

Solution 2.

Or else goto the screen painter and change the field ref specified i.e

Now i think u have taken the field in the table control from table ZMDISP_ITEM by getting it from dictionary , so now delete all the field from the table control and put the internal table name IT_REC_ITEM and press the get it from table program

Hope this will sove the problem