topic Re: BSEG - PAYR relation in Application Development and Automation Discussions

BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 19:14:00 GMT

I am trying to determine how I can relate the account in BSEG (bseg-belnr) to a record in PAYR table.. if anyone know of a access path that will use index all the way through, that would be great.

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 19:28:00 GMT

The relationship is PAYR-VBLNR = BSEG-AUGBL. But if you know you are accessing vendor cleared items or customer cleared items, then use BSIK or BSID instead of BSEG.

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 19:39:33 GMT

I am starting with BSIS table (can i use that?).. i see that std. index on PAYR is ZBUKR, VBLNR and GJAHR. Can i substitute ZBUKR with BUKRS (from BSIS/BSEG?)

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 19:51:38 GMT

I don't know if for every GL account entry there will be a corresponding PAYR record, because some GL accounts may not be either a customer account or a vendor account. But if you already accessed BSEG, then you don't have to worry about any other link.

Yes, ZBUKR is BUKRS and also GJAHR can be used.

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 20:02:44 GMT

Thanks Srini. I have to do some validation to confirm this at my end.. but will assign points for now.. Will close the thread after confirmation at my end

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 21:58:39 GMT

I doubt BSEG-AUGBL is populated in all cases.

Try to join PAYR-VBLNR with BSEG-BELNR

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 22:01:23 GMT

You can retrive the house bank details (HBKID &

HKTID) from the paying company code (from BSEG/BKPF) and include it in your PAYR lookup.

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 22:09:35 GMT

> I doubt BSEG-AUGBL is populated in all cases.

> Try to join PAYR-VBLNR with BSEG-BELNR

But Sam, isn't this true only if your accounting document number(BELNR) is configured to be the same as your VBLNR?

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 22:10:38 GMT

Thanks Sam. I will take a look at it..

I am now confused a little.. As per Srini the clearing document(AUGBL) is to be used and you are saying use BELNR itself.. Are they usually a same document?

From transaction perspective, how do I find out whether a accounting document has the associated PAYR (without going to the associated tables)..

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 22:15:13 GMT

But Sam, isn't this true only if your accounting document number(BELNR) is configured to be the same as your VBLNR?

Srini, where will this be configured? Depending on the configuration, I presume we need to use AUGBL or BELNR?

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 22:25:52 GMT

I am not sure where. I guess what you should do is to try out both and see if you are getting consistant results. If not, then verify which one is not giving correct results. I would suggest talking to your FI functional person to help you out.

Srinivas

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 22:47:36 GMT

I think BSEG-AUGBL will be populated if the check has been produced. In any event, you can't use BSEG in a join.

Rob

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 22:59:16 GMT

Yeah I agree you cannot join BSEG since it is a cluster table. What I meant is to relate BELNR in BKPF/BSEG to VBLNR in PAYR. I thought there is no config required to relate these two fields.

Re: BSEG - PAYR relation

Former Member — Thu, 05 Jan 2006 23:04:14 GMT

Maybe give this a try...Go to the data browser for BKPF and include field BLART in the selection screen. Now filter the documents with type related to payment posting. Display the documents. Now try to lookup these documents (BELNR) in PAYR by matching VBLNR and company code.

Re: BSEG - PAYR relation

Former Member — Fri, 06 Jan 2006 16:13:17 GMT

Thanks Sam, Robert and Srini.. I have to do some checking at my end,after which I will award more points..

Sam, Is there any way to kinda relate an accounting document from transactions (without going through tables) to PAYR table? Is there any transaction, where I can view the records in PAYR table?

Re: BSEG - PAYR relation

Former Member — Fri, 06 Jan 2006 16:23:26 GMT

Try program RFCHKL00.

If that's not what you want, do a 'where used' on table PAYR. There are a lot of reports that use it.

Rob

Message was edited by: Rob Burbank

Re: BSEG - PAYR relation

Former Member — Fri, 06 Jan 2006 16:44:59 GMT

You can view them from the regular FB03. Alternatively you can look at FCH1, FCH2, or FCHN.

Re: BSEG - PAYR relation

Former Member — Fri, 06 Jan 2006 17:15:05 GMT

> Thanks Sam, Robert and Srini.. I have to do some

> checking at my end,after which I will award more

> points..

> Sam, Is there any way to kinda relate an accounting

> document from transactions (without going through

> tables) to PAYR table? Is there any transaction,

> where I can view the records in PAYR table?

Goto trasaction FB03.

Give the Acct Doc No number and CoCode. Press Enter.

Now in the menu goto Environment --> Check Information

You will find the payment document no in the display.

Re: BSEG - PAYR relation

Former Member — Sat, 07 Jan 2006 01:03:46 GMT

Thanks Sam.. That was really a useful information..

This is probably a stupid question (newbie to FI world), so please bear with me..

From MM perspective, I presume this is the flow,

PO -> MIRO (Invoice verifcation )

MIRO results in Accounting document A1

Payment Run to process the Accounting document A1?

Sam, the Link you provided me is it from Accounting document A1?

Re: BSEG - PAYR relation

Former Member — Sat, 07 Jan 2006 01:42:53 GMT

When a FI document is posted the informations about which procedure have done it is stored in the BKPF: field AWTYP (Reference procedure) and AWKEY (Reference Key).

You can find out the procedure from table TTYP.

For example:

IF billing 100 create an account document, you can find out the number of account document by this way:

SELECT * FROM BKPF WHERE AWTYP = 'VBRK'

AND AWKEY = '0000000100'.

EXIT.

ENDSELECT.

The field AWTYP and AWKEY are in index of BKPF, so this select is very fast.

After you can read the items data from BSEG

SELECT * FROM BSEG WHERE BUKRS = BKPF-BUKRS

AND BELNR = BKPF-BELNR

AND GJAHR = BKPF-GJAHR

.............

If account document is created by MIRO

AWTYP = RMRP

AWKEY = Number+Year of Invoice

CONCATENATE RBKP-MBLNR MBLNR-GJAHR INTO AWKEY

SELECT * FROM BKPF WHERE AWTYP = 'RMRP'

AND AWKEY = AWKEY.

EXIT.

ENDSELECT.

....

Max