topic Re: SAP Functional in Application Development and Automation Discussions

SAP Functional

former_member711689 — Tue, 12 Jan 2021 18:08:23 GMT

How can I join tables VBRK , VBRP, ZOBILLING, VBAK in SQVI. I am getting field

ZOBILLING-Wholesaleequivalentamount (Output field) duplicates values its just repeating.

I am joining VBRK with VBRP

VBRP with ZOBILLING

VBRP with VBAK

Input fields given are sales document number and client number.

Please help with this?

Re: SAP Functional

iklovski — Tue, 12 Jan 2021 18:45:19 GMT

Please, give a meaningful title to your questions; it will make it more efficient.

Re: SAP Functional

VeselinaPeykova — Tue, 12 Jan 2021 18:48:20 GMT

Are you a consultant or a business user?

In the first case: all tables starting with Z* or Y* are specific to your system. This means that people with no access to this system cannot easily answer what is the best approach for linking tables in order to avoid duplicates. In this case I would recommend that you read the available project documentation to understand better how this custom table is used and how it is filled. Depending on how the data looks like, it may be more efficient to use SQ01/SQ02 to create an infoset and a query to display the data (probably with some custom code in SQ02) or even an ABAP report.

If you are a business user - most likely you have no access to the project documentation and to the transactions which I mentioned. Reach out to your local support team for assistance by submitting a ticket.