Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Query between REGUH and REGUP

javier_rodruez
Participant

‎2010 Jun 22 10:52 AM

0 Likes
1,542

Hi experts,

I've got a limitation using SAP Infotype when I'm trying to make a join between these tables: REGUH (Header) and REGUP (Positions). R/3 show me this message: "Table REGUP cannot be used in a join".

I see that there is a logic database named PYF, so I decide to implement some extra fields to reach my requirements. I need the Terms of payment key (ZTERM) and Document Date in Document (BLDAT).

The last field is "Sales in the Posting Period", that sums up all the quantities of the table LFC1 of the last fiscal year and .

I would like to show only this field in the header (the extra field is defined there) but due to the join, it is shown into all the rows. The totaling fields so, show incorrect numbers

Could you please give me some advice?

Lots of thanks!!!

Javier

Hi experts,

I've got a limitation using SAP Infotype when I'm trying to make a join between these tables: REGUH (Header) and REGUP (Positions). R/3 show me this message: "Table REGUP cannot be used in a join".

I see that there is a logic database named PYF, so I decide to implement some extra fields to reach my requirements. I need the Terms of payment key (ZTERM) and Document Date in Document (BLDAT).

The last field is "Sales in the Posting Period", that sums up all the quantities of the table LFC1 of the last fiscal year and .

I would like to show only this field in the header (the extra field is defined there) but due to the join, it is shown into all the rows. The totaling fields so, show incorrect numbers

Could you please give me some advice?

Lots of thanks!!!

Javier

Reply
2 REPLIES 2
Read only

andreas_mann3
Active Contributor

‎2010 Jun 22 3:07 PM

0 Likes
872

I would integrate ldb PYF and table bsak and lfc1 in a Z-program

or use ldb KDF and integrate REGUH and REGUP

or can't you start at BSAK and LFC1???

A.

Read only

javier_rodruez
Participant

‎2010 Jun 22 3:11 PM

0 Likes
872

Lots of thanks!

Javier

Edited by: Javier Rodruez on Jun 22, 2010 4:11 PM