cancel
Showing results for 
Search instead for 
Did you mean: 

SE16N plant part number to Vendor name or Vendor Id.

former_member46993
Discoverer
0 Kudos

Hi, I would like to ask you about support for SE1N or any other transaction code to be able to find out on one common table : plant ( incoming part ) part number linked to Vendor name or Vendor Id. We order one part number from multiply Vendors and must follow traceability using Vendors lot number/ batch number.

Thank you in advance for your feedback!

Best regards

Marcin

jerryjanda
Community Manager
Community Manager
0 Kudos

Hi, bolokolo:

Welcome to the SAP Community! We're glad you've come here to get answers to your questions. If you're also interested in connecting with community members, please pay a visit to our Welcome Corner. You'll need to sign up, but it's a great way to interact with peers and connect with other experts!

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

Please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community. And connect with our SAP Champions for advice about asking questions.

You should also make sure your e-mail notifications are turned on for "Comments and answers to my questions and questions I follow" at #communications -- so you won't miss any replies to your question.

In addition, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always help our members better understand your problem.

* Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

I hope you find this advice useful, and please let me know if you require any additional guidance!

All the best,

--Jerry

ankurch
Active Contributor
0 Kudos

LFA1 is the table

former_member46993
Discoverer
0 Kudos

Hi Just let me add some print shot from my SAP 0R09: SE16N

1.

2. -> No Vendor Name or Vendor Code which I'm looking for?

Regards

Marcin

former_member46993
Discoverer
0 Kudos

Hi, who can support me to find out :

  • plant part number to Vendor name or Vendor Id. using SE16N or any other SAP transaction? BR Marcin
burcin_kilicaslan
Discoverer
0 Kudos

Hi Marcin,

Since you have purchase order number (EBELN) in your custom table you can get vender code (LIFNR) from table EKKO, plant code (WERKS) from table EKPO and vendor name (NAME1, NAME2, NAME3 and NAME4) from table LFA.

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

Neeraj_Jain
Active Contributor
0 Kudos

Hello bolokolo,

By joining tables MKPF, MSEG and LFA1 you can get your data. To join these tables please use transaction SQVI. In this transaction you can join above tables and get your data.

Let me know if any question on it.

Regards,

Neeraj Jain