topic Re: Issue in smart forms main window data display. in Application Development and Automation Discussions

Issue in smart forms main window data display.

Former Member — Thu, 16 Jul 2020 18:54:21 GMT

Hi experts,

I have an issue in displaying the data in the main window data display.

as I need to display the same in the below screenshot.

all these data is fetching from the EKEK & EKEH.

I wanted to know how to write the logic in smart forms and display in the main window.

Item Product and description

10 421335081921

HDR SCF657/43 AMZ 4PK TEATS

Delivery

schedule Quantity Cumulated quantity UoM Commitment

Daily

24.06.2020 0 81,513 PCE Firm

03.07.2020 9,000 90,513 PCE Firm

23.07.2020 6,200 96,713 PCE Forecast

30.07.2020 3,000 99,713 PCE Forecast

12.08.2020 3,000 102,713 PCE Forecast

Weekly

34.2020 3,000 105,713 PCE Forecast

37.2020 3,000 108,713 PCE Forecast

39.2020 6,000 114,713 PCE Forecast

Monthly

10.2020 6,200 120,913 PCE Forecast

12.2020 6,000 126,913 PCE Forecast

01.2021 3,000 129,913 PCE Forecast

02.2021 3,000 132,913 PCE Fo

Firm zone: 9

Trade off zone: 14

Call-off reference data

Release number: 439

Cumulated received quantity: 81,513 PCE

Date of last delivery: 24.06.2020

Last delivery note number: TW/240620/123

Date of last goods receipt: 24.06.2020

Last good receipt quantity: 4,600 PCE

End of Firm commitment: 03.07.2020

End of trade off commitment: 08.07.2020

Re: Issue in smart forms main window data display.

Abinathsiva — Fri, 17 Jul 2020 02:21:31 GMT

Hi,

Any ways for fetching EKEK and EKEH could have read EKKO and EKPO so based on EKKO-AEDAT use Function modules to get week / month details and filter/loop accordingly and collect the information menge and display to a table.

FM to filter dates in SAP - FM's related to DATES

Re: Issue in smart forms main window data display.

Sandra_Rossi — Fri, 17 Jul 2020 04:24:16 GMT

Do you have a specific problem (what is it?) or do you ask for a general guidance (can you explain what is your doubt?)

Re: Issue in smart forms main window data display.

Sandra_Rossi — Fri, 17 Jul 2020 04:28:33 GMT

Let see if it helps the OP, but it's always difficult to answer in two lines to the questions of the kind "this is my specification, tell me how to code it".

Re: Issue in smart forms main window data display.

shakirali7 — Fri, 17 Jul 2020 08:47:05 GMT

Hi! Fayazullah,

First of all do categorize your data into master and detail, then you have to maintain internal table of your ABAP Program which will call Smart Form with passing of both tables. In smart forms you should use looping on TABLE with selection and filter for detail table by using Foreign keys. It is the general practice for making these kind of requirement of SMART FORM reports.

Hope it help!

Shakir.