Table Regup

[waqar_ahmed]

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,

[nabheetscn]

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

[arindam_m]

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

[waqar_ahmed]

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

[nabheetscn]

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