topic Re: ABAP-Module Pool in Application Development and Automation Discussions

ABAP-Module Pool

former_member669595 — Sat, 08 Aug 2020 12:33:43 GMT

Can anyone help me with the logic ...I am a fresher ..

Material Document No- MSEG-MBLNR

Date - MKPF-BUDAT

I have to combine this two table and MBLNR is the key field

Re: ABAP-Module Pool

TammyPowlas — Sat, 08 Aug 2020 12:48:28 GMT

I recommend getting familiar with transaction SE11, and views and where used

View V_MKPF already joins tables MSEG and MKPF and has the fields BUDAT and MBLNR

Re: ABAP-Module Pool

Sandra_Rossi — Sat, 08 Aug 2020 12:53:00 GMT

Please choose a meaningful title (like how to read the tables MSEG and MKPF in a single shot).

Re: ABAP-Module Pool

former_member1716 — Sun, 09 Aug 2020 06:18:11 GMT

subhajitsaha,

I don't understand the need to Join MKPF and MSEG tables as both your required fields are present in MKPF itself. As suggested by tammy.powlas3 V_MKPF already has both your required fields as shown below:

Even the Join Conditions is as required as shown below:

You can write a select query directly up on V_MKPF using the below Code:

SELECT mblnr,
       budat
FROM v_mkpf
INTO TABLE @DATA(gt_vmkpf).
IF sy-subrc EQ 0.
  SORT gt_vmkpf BY mblnr.
ENDIF.

Regards!