topic SQ01 Query for without Access Sequence or table in Application Development and Automation Discussions

SQ01 Query for without Access Sequence or table

Former Member — Mon, 25 Nov 2013 08:26:29 GMT

Hi All,

Kindly let me know, how we can use Query SQ01. IF there is no access sequence and user enter it Manually in billing. I have checked VBRK and KONP table as well, but there is no linkage.

Kindly let me know, if you have any solution. I dont want to use programme

Regards,

Puneet

Re: SQ01 Query for without Access Sequence or table

former_member207541 — Mon, 25 Nov 2013 08:57:39 GMT

Hi,

try to work with:

KONV-KNUMV

VBRK-KNUMV

VBRK-VBELN

VBRP-VBELN

KONV-POSNR

VBRP-POSNR

You will be able to overcome your issue.

Regards,

Re: SQ01 Query for without Access Sequence or table

Former Member — Mon, 25 Nov 2013 09:04:57 GMT

Hi,

I want to use/linked 2 different tables VBRK and KONV/ KONP, but there is no linkage. There is no Access Sequence or Table as user entring data Manually in Billing.

If some one tell me which 2 tables linked in SQ02/SQ01 if user entring value Manually.

Thanks

Re: SQ01 Query for without Access Sequence or table

Former Member — Mon, 25 Nov 2013 10:01:28 GMT

Thanks everyone, we have to use program for this report as it is not possible to get the data from SQ02/SQ01. I am closing this issue.

Re: SQ01 Query for without Access Sequence or table

Former Member — Tue, 17 Dec 2013 07:29:55 GMT

Issue closed.

If there is no access sequence or key combination, we can not use SQ01.

We developed a Z development for condition type in which there is no access sequence.