topic Re: Table Regup in Application Development and Automation Discussions

Table Regup

waqar_ahmed — Wed, 13 Nov 2013 11:41:48 GMT

Hi all,

I want to create query on BKPF, BSAK and Regup table, can someone please tell me the relations. Actually I need LAUFD field from REGUP table, as this table is cluster so cannot be used in joins. I know join between BKPF and BSAK but how will I pick this field from REGUP, as far I know REGUH is header table of REGUP. Please suggest.

regards,

Re: Table Regup

nabheetscn — Wed, 13 Nov 2013 11:47:31 GMT

in REGUP you have accounting document number BUKRS BELNR GJAHR BUZEI. You can items from BKPF and then fetch LAUFD

Re: Table Regup

arindam_m — Wed, 13 Nov 2013 12:19:47 GMT

Hi,

BKPF- Header data of the documents

BSAK- Cleared Items of the Vendor

REGUH & REGUP are the posting run related tables and you can find the data related to that in them along with the details.

So based on what you want to pick. If you want to pick items after posting then BKPF and BSEG, BSAK and BSIK(Open Items of the Vendor) might be of interest. If you are doing your stuff in posting runs (F110 and F110n etc ) you might want to do it from REGUH and REGUP.

Posting runs related tables are used in cases where you might have to pass or print data to Sapscripts. If in other situations BKPF, BSEG, BSAK, BSIK might be useful.

Cheers,

Arindam

Re: Table Regup

waqar_ahmed — Thu, 14 Nov 2013 07:38:18 GMT

Hi,

I am getting Invoice date and reference from BKPF and PO number vendor and payment date, amount from Table BSAK. There is LAUFD field the is actual payment date to vendor, I need to pick this field from REGUP table. So kindly tell me how to join these tables.

Below fields I have to pick in query.

Please Suggest,

regards,

VENDOR Number	BSAK	LIFNR	CHAR	10
PO Reference	BSAK	EBELN	CHAR	10
Invoice Reference	BKPF	BELNR	CHAR	10
Invoice Date	BKPF	BLDAT	DATS	8
Payment Date	BSAK	AUGDT	DATS	8
Due Date	BSAK	ZFBDT	DATS	8
Value Date	REGUP	LAUFD	DATS	8
Payment Document Number	BSAK	AUGBL	CHAR	10
DPR Number	BSAK	BELNR	CHAR	10
Item Number of Purchasing Document	BSAK	EBELP	NUMC	5
Payment Amount	BSAK	WRBTR	CURR	13
Payment Currency	BSAK	WAERS	CUKY	5

Re: Table Regup

nabheetscn — Thu, 14 Nov 2013 07:43:31 GMT

Bases on BKPF-BELNR BKPF-BUKRS and BKPF-GJAHR you can pick value from REGUP table