ABAP-Module Pool

[former_member669595]

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

[TammyPowlas]

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

[Sandra_Rossi]

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

[former_member1716]

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!