04-28-2008 8:04 AM
HI,
I want to know common fields in the BSEG AND RSEG table.
plzz tell me its really urgent.
04-28-2008 8:08 AM
PO , its item and material number are the common fields b/w MSEG and RSEG tables.
Other than that there is no relation b/w them.
MKPF & MSEG contains the material movement documents. Against the material documents, you have accounting documents and these hit the accounts. you can find the accoutning docs created against the material docs in mkpf and mseg in bkpf and bseg tables.
RBKP and RSEG contains the incoming invoices (accounting docs) created against the POs.
See the following link.
http://sapr3consultant.com/saptables.asp
Hope this helps.
04-28-2008 8:23 AM
Between RSEG - BKPF, we have fields BELNR, GJAHR, BUKRS
In BSEG we have BUKRS, BELNR.
with QALS and RSEG, we have
MBLNR - BELNR
MJAHR - GJAHR.
Regards,
Dara.
04-28-2008 8:29 AM
Hi,
Bseg-BELNR = Rseg-BELNR.
Bseg-GJAHR = Rseg-GJAHR.
Bseg-BUZEI = Rseg-BUZEI.
Bseg-MATNR = Rseg-MATNR.
Please reward if help!
Amit.
04-28-2008 8:40 AM
HI,
wheni check the fields of Rseg-BELNR and take the values into BSEG- BELNR then it says the documents not present in it.
how sholud i make a link b/w them?
plzz it is really urgent.
Edited by: ric .s on Apr 28, 2008 10:53 AM
04-28-2008 9:58 AM
04-28-2008 10:03 AM
Hi ric,
You can link BSEG AND RSEG table through
EBELN Purchasing document number this is only applicable for MM Document numbers.
for FI document numbers you need to link using fields
RSEG-BELNR = BSEG-XREF3+4(10).
CORRECT ME IF I AM WRONG
REGARDS,
NEELESH
04-28-2008 8:36 AM
Hi,
some comman fields of bseg and rseg tables.
GJAHR;EBELN;EBELP;BELNR;BUZEI;ZEKKN;MATNR;WERKS;BUKRS;BWKEY;WRBTR;MENGE