Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

creating view on rseg,rbkp,ekpo

Former Member
0 Kudos

hi,

is it possiblle to create a view on rseg,rbkp and ekpo table,

if so can anyone tell me the relationships

i will assign points

1 ACCEPTED SOLUTION

Former Member
0 Kudos

U can join like this

rseg,rbkp on gjahr,belnr

rseg,ekpo on eblen,ebelp

Reward if useful

Message was edited by:

Arjun Puthuruthy

5 REPLIES 5

Former Member
0 Kudos

hi,

ekpo-ebeln = rseg-ebeln.

ekpo-ebelp = rseg-ebelp.

Former Member
0 Kudos

You can go to SQVI and there you will get to know the link between rseg and rbkp. The common fields between the two tables are BELNR (Document Number) and GJAHR (Fiscal Year).

Please reward the helpful entries.

Regards,

Raman.

Former Member
0 Kudos

U can join like this

rseg,rbkp on gjahr,belnr

rseg,ekpo on eblen,ebelp

Reward if useful

Message was edited by:

Arjun Puthuruthy

Former Member
0 Kudos

used database view.

see the relationship button click .

Former Member
0 Kudos

Hi Venkat,

U can establidh the link for DB view using ebeln ebelp for EKPO and RSEG.

RSEG-EBELN = EKPO-EBELN.

RSEG-EBELP = EKPO-EBELP.

and between RSEG and EBKP using fields GJAHR and BELNR.

RSEG-GJAHR = EBKP-GJAHR.

RSEG-BELNR = EBKP-BELNR.

Hope this helps you.

Regards,

Ravi Kumar.