08-08-2020 1:33 PM
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
08-08-2020 1:48 PM
08-08-2020 1:53 PM
Please choose a meaningful title (like how to read the tables MSEG and MKPF in a single shot).
08-09-2020 7:18 AM
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!