How can I link RSEG table into BSEG or RBKP to BSEG?

abap sap-erp
Dumbest666 picture Dumbest666 · May 15, 2018 · Viewed 7.1k times · Source

I already browse the web but i find no answer that can solve my problem.

I tried the concatenation of RBKP-BELNR and RBKP-GJAHR into BKPF-AWKEY to get the BKPF-BELNR then BKPF-BELNR to BSEG-BELNR, but always show no records.

I need to link to the RSEG to BSEG or RBKP to BSEG .

Need some help! thanks!

Edit: I made the parked document in Tcode MIR7

I found this, but can't enter to VBSEGS table.

UPDATE: these are the details I want to get. but can't find the other details

IMAGE HERE

Answer

Oguz picture Oguz · May 16, 2018

Concatenate BELNR & GJAHR from RSEG and pass it to the AWKEY field of BKPF table and you will get Accounting document number "BELNR", year "GJAHR" & Company Code "BUKRS". Pass these fields to BSEG and you will get the other details. Did you try it exactly this way? You should check your belnr has left padding '0' you can check it with double click on the record in SE16n tcode.enter image description here

Actually, you can directly link these table. enter image description here Last option, If these are still not working for you, then you can link: However, it will kill the performance, I believe.

RSEG-EBELN = BSEG-EBELN
RSEG-EBELP = BSEG-EBELP
RSEG-MATNR = BSEG-MATNR

Related questions

How should I start learning about SAP?

I'm working as a MS developer working to provide bridging products between MS technology and SAP. I'm used to the MS space which seems to have an absolutely different philosophy than SAP. And this is starting to be an issue …

Read More
How to use CS_BOM_EXPL_MAT_V2 to get correct quantity of component for BOM explosions?

I am getting an issue with my program. I am using function module CS_BOM_EXPL_MAT_V2 to get the BOMs of a material. For example I have a material MAT1 that has the ff. BOM explosion. MAT1 - …

Read More
Move FMOIX/FMCOX structures into Internal Table

I am a newbie to ABAP (3 days experience) and I am currently on a task to write reports using ABAP code. It is like moving some data from a specific SAP database to a Business Intelligence staging area. So the …

Read More