Skip to Content
0
Jan 10, 2011 at 11:31 AM

Which Field Required to join 2LIS_13_VDHDR and 0FI_AR_4

35 Views

Hi to all,

I need to join 2LIS_13_VDHDR (VBRK) and 0FI_AR_4 ( BSID ) and want to combine VBRK->SPART

and BSIB->SHKZG/DMBTR to a CUBE for Receivables aging Report.

so i have created one DSO1 for 2LIS_13_VDHDR and second DSO2 for 0FI_AR_4 and combined in a third DSO3 and then move data to CUBE.

But i have a question which field i required for join between DSO1 and DSO2 .

is that VBRK->VBELN = BSID->XBLNR

OR VBRK->VBELN = BSID->VEBLN

*or any other logic or Field i required to make a join *

Please can any one tell me the solution.

I shall be thankful to you for this.

Regards

Pavneet Rana

Edited by: pavneet rana on Jan 10, 2011 12:31 PM

Edited by: pavneet rana on Jan 10, 2011 1:41 PM