10-08-2008 9:35 AM
10-08-2008 9:39 AM
10-08-2008 9:59 AM
10-08-2008 10:04 AM
hi shivam..
try what dileep kumar has said earlier..!!
Goto se11 with ur table name.
click the entry help/check TAB
and see the CHECK TABLES.
Regards,
Padma
10-08-2008 9:43 AM
Hi Shivam,
RBKP - Invoice Header
RSEG- Invoice Item
They are header and item tables,
RBKP-BELNR -> RSEG-BELNR
RBKP-GJAHR-> RSEG-GJAHR
10-08-2008 9:59 AM
10-08-2008 10:07 AM
Hi Shivam,
Goto the tables RBKP and RSEG in SE11.
Press CtrlShiftF11 (or) Utilities -> Graphics
Then you can see all the tables related to that table. In List and also graphically
Try this
Cheers,
Kothand
10-08-2008 10:11 AM
Hi,
Goto se11 , put table name RBKP press display button
Press the Graphic button (Ctrl + Shift + F11 )
You will get the list of related tables. Choose from the list and execute. You will see a graphical view of the relationship of the tables that are related to RBKP.
Repeat the same for RSEG.
regards,
Advait
10-08-2008 10:22 AM
As I expected Your requirement is different from your post. And now you can try with se11 in entry help/ check or from the graphics.
or atleast mention which table do you expect to be related from these tables.
Regards.
Dileep .C
10-08-2008 9:44 AM
hi..
Use TCODE - SQVI
1: Create a quick view.
2: give a title and select the DATA SOURCE as TABLE JOIN
enter.
3: Press Insert tble ICON and give ur desired table name1(in our case - RBKP )..enter.
4: Again repeat step 3 and enter table name2 - RSEG.
Here u can find the links between them.
U can use tcode to know all transparent Table links.
regards,
Padma
10-08-2008 9:53 AM
Hi,
Relationship between those 2 tables is
RBKP-BELNR -> RSEG-BELNR
RBKP-GJAHR-> RSEG-GJAHR
10-08-2008 9:55 AM
I am unable to understand ur requirement,
Do you need relation for RSEG and RBKP
or you need relation of these two tables with other tables.
1. Relation b/n RSEG abd RBKP is given already.
2. Go to the SE11 and give the table name and from there you can see all the related check tables through Entry help/Check
These two tables are related to many major tables like, Mara, Lfa1, Ekko,.......
check out SE11 for your required relations like this...
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.