Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on May 6 at 2:29 PM Neal is correct, but the issue at hand that you have is that the document numbers in the two tables are not the same format. You can't use Query to join fields that are different formats. VBRK is CHAR 10 and J_1BNFDOC is NUMC 10.
Although there could be a way around this, it would involve coding within the infoset and defeat the purpose of doing a simple query.
- Lou
| | | ---------------Original Message---------------
From: eZayan
Sent: Monday, May 06, 2013 1:35 PM
Subject: How to Make a Query Using Tables VBRK, J_1BNFDOC and J_1BNFLIN?
Hi, I need to make a query using tables VBRK, J_1BNFDOC and J_1BNFLIN. How do I make this relationship? I know that the fields J_1BNFDOC-DOCNUM and VBRP-VGBEL have the same information, however, the query does not allow this relationship.
Thanks,
Eduardo |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
