UrbanPro
Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕

Learn SAP from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Book a Free Demo

SAP > Learn SAP > What is the difference between lookup and join in SAP...
✕

Search in

What is the difference between lookup and join in SAP BODS?

Asked by Last Modified  

2 Answers

Learn SAP +1 Informatica

Follow 1
Answer

Please enter your answer

IT Corporate Trainer with 9 years of experience in Edu tech

The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select...
read more
The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select the most relevant row in the case of multiple matches). There are various aspects to the performace of both mechanisms, but you only need to be concerned with this if you have performace issues. read less
Comments
Dislike Bookmark

I am online Quran teacher 7 years

The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select...
read more
The most important thing to note is that a join and the lookup functions are not always functionally similar. Joining one table to another on key columns can potentially return multiple matching rows, whereas an invocation of a lookup function will only ever return 1 matching row (there are ways to select the most relevant row in the case of multiple matches). There are various aspects to the performace of both mechanisms, but you only need to be concerned with this if you have performace issues. read less
Comments
Dislike Bookmark

Related Questions

Hi, I did my graduation (B.Com) in 2010, after struggling a lot I started my career in 2013 as an executive in BPO and presently working as analyst back-end process us healthcare, I'm looking for job change. At present I'm doing tally ERP 9 GST with Ad Excel training and simultaneously I want to do SAP FICO module training, is it best to do SAP FICO according to my profile. Please, suggest me.
Hi Chaitanya, SAP FICO module always has a lot of scope to start your career, as it has lot of submodules, practices and you later on do vertical/Horizontal expansion in your career FICO has sub...
Chaitanya
I have BPO experience of 3 years, but now I want to shift to IT. I want to do SAP course. Can you suggest me which module I have to do, as I am an electronics background student? Tier 1 companies will hire me?
Hi Harsh, As you have 3experience into BPO so don't have any knowledge into IT. rather than going with SAP we suggest u to take Software Testing Tools best entry level to get into IT Sector for non technical background
Harish
Hi Team, I have done my MBA in Marketing & Operations management, I have experience in Business Development Executive, and I want to learn SAP SD but am confused. Can you guide me like how the market for career opportunities is? Request to guide me.
Your confusion can be best addressed by asking yourself what you are good at and which of the career options can best utilize the skills you are good at. That way you will have a satisfying career and...
Krishna murthy
0 0
8
I am a fresher. But i have that zeal to learn SAP is this OK.?
Hi You can opt sap but in real scenario it will be problem to get job immediately as a fresher in SAP world.if u go for certification then u might be getting chance to get a job in sap...I m giving you...
Lokesh
What is SAP?
An enterprise software to manage business operations and customer relations which is developed by a German multinational software corporation of the same name.
Ganesh
0 0
9

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Development, Quality & Production Client And Change Management Process In Sap
Clients (development client, testing client, production client) are basically logically discrete or separate subsystem within SAP system. Clients can be considered as logical sub-units within SAP system. User...

Rahul

0 0
0
Material Master Data
Material master: Storing the material related data into the database is called as material master data. In material master data, we can save the information for different views or different operations....

Ragunath

0 0
0
How can we create a Digital Signature in SAP QM?
Digital Signature - SAP QM Use the signature method – using with authorization by SAP user id and password We need to create an authorization group And we need to define this authorization group...

Devraj

0 0
0
SAP FICO Overview By Future Labs Technology
SAP FICO pertains to System Analysis and Program development Finance and Control. It is computer software intended for identifying financial details in a business organization. It is supposed for external...

Future

0 0
0
Highlights Of Some Recent GST Council Meetings
Highlights of 22nd GST Council Meeting at New Delhi on 6 Oct. 2017 GST Council in its 22nd Meeting at New Delhi has recommended certain facilitative changes to ease the burden of compliance on small and...

Talent Hub Training Institute

0 0
0

Recommended Articles

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Find SAP Training near you
SAP Training in Bangalore
SAP Training in Hyderabad
SAP Training in Pune
SAP Training in Chennai
SAP Training in Mumbai
SAP Training in Delhi
SAP Training in Kolkata
SAP Training in Noida
SAP Training in Gurgaon
SAP Training in Ghaziabad
Online SAP Training

Looking for SAP Training?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for SAP Classes?

The best tutors for SAP Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn SAP with the Best Tutors

The best Tutors for SAP Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more

ThinkVidya Learning Pvt Ltd © 2010-2026 All Rights Reserved