Report

aman_mbs

Dear All,

Please provide me the sol for the particular scenario……

Scenario based on (coronus)

In item table I have mentioned two product group code and based on sales invoice line I need particular report:


Item Table,
No.

---

Product Group Code
1984-W Tube
1988-W Tube
1992-W Tube

Sales Invoice Line,
Doc No.

---

Sell-To Customer No. Qty Item No.

---

Product Group Code
103013 01445544 1 1988-W Tube
103017 35451236 1 1992-W Tube
103022 01454545 13 1988-W Tube
103022 01454545 2 1984-W Tube

Required Report,

<Group Code>Tube

Sell-To. Customer No. Qty
01445544 1
35451236 1
01454545 15

vikram7_dabas

firstly make 2 dataitems
Item
Sales Line

In the dataitemtableview of item table which is in properties use key as no. And in table filter Click the field Posting group code field ,filter and turbo(whatever u wants to filter).the two dataitems should be linked with the no. field of sales line and field "item no." of item table.The sorting should be done in the dataitemtableviews of both the dataitems.ok :whistle:

aman_mbs

Dear ,

Thnks For Help, How Do we know which Product Group Code User will Select & And in table filter there r only two option Const & Filter which Require Static Value..