Now we are going to check important tables for business partners. Okay, as we have discussed in SAP, we have tables. And we cannot live without tables and tables is really useful when you have to query multiple data for business partners. So the most important transaction for business partner is VP. So we go here, okay. Okay, here you see this is the vendor number, okay?

And I just click on Start, okay, and I get a bunch of these options. Okay, so just pick one. I'll just pick some of the ones that I did check some when you had proper data in it, okay. So we'll just check what was the business partner so this is the business partner. We are going to check query on. Okay.

So here you can do a find and suppose I want to see this business. You can you can get it from here. So, this is the business partner if you knew the stir the supplier number you can populate it here and it will give you all this business. So, if you notice this is the more this is the business partner screen. Now we are going to go to the table sc 16 okay here we are going to this table sc 16 and we will check all the tables that is very important okay. So we are now going to slash and sc 16 Okay.

So we are going to discuss this tables. So one is ibp address Okay, that tells so I VP like international business partner or something, so that's a new term that they have come I think international business processes something okay. So these are the tables okay ibp address and here if I give the business partner number, okay, here I get the address number Here you can see the validity date, the full name and all those things. So you might say Oh, let me verify it here. Okay, so we'll see the address thing. We'll go to the address and you see the name and everything is matching more or less.

Because the street is matching. Is it matching? Let me see 39343 Yeah, so this is really useful, you know, in before it was LFO one and other things. Now, important thing, I think, and these, for sure. LFO one is there so don't need to panic. This is something when you want to do it from a business partner endeavor.

If you don't like it, you don't really need to worry about because these things are still there. CSF is smart enough, they know they will not get rid of the core stuff. They can build stuff on top like a rapper, the business partner is like a rapper. So these core stuff is still there. So you if you want if you have reports, you have lots of reports running custom reports. standard reports, well, if you want these, these wheels will still be there, but you want to take it from the business partner level, okay, here you can get it.

So, if you notice here, the adds added stuffs like this, you know, validates the start date, and end date. So what will happen is when the value changes, these data will change automatically. Okay, those are the things that, that that happens. Okay. So those are the things so they they put start date into it, you know, and it also keeps it It also keeps us to the whole point is probably, they don't want to, they don't want to maintain the change history because it's a lot. So you stay put start and end it makes it easier to do the query.

And the whole reason for S for HANA is to make it simple and make it fast. So if you have a lot of change document tables, getting updated is not really useful. So because it brings down the system, you have a lot of entry. So that's the reason you might Want to again if you want to check in NFA one you'll get the current data but anything old you had to go through the change history and find all those things, you can get it from here if you have something multiple you can probably get multiple data multiple different validity date and value the start date and end okay. So, this is useful now what we are going to do, we are going to check the next table which is the most important So, the next table which is important is is all tax table let's see, I will put the same thing and the beauty of business partner.

So here you can see what are the different roles that has been created for a business partner so so reach into the language in okay. It's not that I don't know other languages, but you know, most of the people speak English. So here you You can see the different types of roles. Now, you might say what you are showing, as I told in business partner concept, everything is a role and you say, what is this role you're saying? So these are the rules. You see, these are the rules.

Now, if, if I'm in I'm in display, so, these are already maintained, now, if I go into change, okay. Now, you can see, as I told before, how you identify in change mode, whether something is maintained or not, they have given this defined defined so these are already defined, the others are not defined. So if you notice, you can create all these different types of rules for a business party. Now, if you're a manufacturing company, makes sense, to you know, define all the rules, but if you're a company where your customer base is in is another as for system or in a C four c system, you might not want to maintain again, you can hide all these things. So if you see, this is all defined, you can hide this, okay, you don't need to define you. So you it might sound alarming for the people who will immediately Oh, I had to go through all these all these options to pick some well you can hide it you can be controlled through rows, okay?

So don't panic, okay. So, this is everything that is can be given and you can put some z stuff also. Okay, so someone created the furniture or something. So, so, you know, these are the stuff and again, how will you know, whether something is defined already is by checking this thing. So if something is defined, it will be showing bracket defined defined. If you go into display mode, of course, it will only show the ones that has been created.

So, if I'm going back to display mode, these are the ones that has been created, and it will show me those. Okay, now Let's go to the next table, which is very important ibp supply. Okay, so why it's important? Because here, I suppose go. So, so suppose I want to open another business partner. Okay.

And so you at one point of time, you might want all the business partners that for a particular render and all those things unless and until you have the same numbers coming out, you might want to get more details out. So this, this table will help you to get it. So I'll just put word ibp supply and I'll keep the same. So you can query based on the when this was brought up. So you see, so the supplier and the business partner on the same so the supplier accounting group is Sep Oh, okay. You can put more different accounting groups, okay?

Because we on different accounts in groups you can configure whether the field is mandatory or optional or display only or it can be hidden. So, all these are very important, you know, you can define one time vendor on all those things, okay. So, if you notice this place, you have the customers also. So this is useful, you see, vendor then as I said, vendor is sometimes called supplier and in especially the business partner, they may need it called suppliers and customers customers So, try if you're moving to S for these other you know, the conversion table you might want So, when I came first to us it's, it's pretty, it's a it was pretty funny and it was pretty important for me like in if someone is called Robert in us. They are actually designated as Bob. So I didn't know that.

So someone was saying, Oh, my, my name is Bob and then Check add your name is Robert is yeah Robert is Bob. So similarly, a vendor is a supplier in a city now, okay. So you have to put that conversion thing in your mind and then you will be moving on okay. So the next the next important table will be the withholding tax okay. So just check that one also. withholding tax is important especially for for customer for company countries where you have heavy taxes like in most of the countries like Brazil, us, India, China, Hungary, Russia, they have special taxes.

So withholding taxes, I think 1499 portable in us. Now for others, they have different Okay, so let's see, and I'll put this here. Okay, so this doesn't have the data for the withholding text. So that's why it's not showing up But if you have data for withholding tax, it will show up. So let me see, there is some data of course, there will be some data for other withholding tax. So what we'll do, we'll just take this, we copy it and we'll go to this transaction, and we'll just progress number.

Okay, and let's see, and they will be something with holdings is the vendor tax status, so we have withholding text data. So which is which is important. Okay, so we have to enter. Now the previous one didn't have the text data. Let me see the total in text data. So in half, so let's go back, we'll hit again, the same thing, this open button and we'll put this number 1010.

Or what I can do is, I want to see this on click on it. Wallah you have it search here if you notice there was no withholding tax data populated with the previous one had something so that's why it showed in that tip. Okay, so let's go to the next important table is this supplier TP they again is this you don't need to learn by heart just keep it just keep it in on just keep it in a variant by creating a 16 million and that would be enough for you to go through this and and eventually when you will you know when you will be using it more you will be learning because not on first day you learnt LFA one and key in one table you learned it as and when you are practicing or learning us For more SAP more so. So here, this is another table which is pretty useful, which also gives like SAP again, SCP doesn't.

They have multiple They don't do it in one time one table they can do it in multiple for some reason. So, if you notice this is the thing this is the customer okay. So you might say what is the customer How will I know the customer okay. So, there will be something financial data VP Let me see supplier to the general get the general this is not a general and then this this is the supplier This is the customer, customer, customer customer segment Don't be something customer and financial service. This is the supplier the supplier shows it is the vendor general data, okay. So here is testing, you see this.

So, this was similar so here is the customer, okay? So here it's populated from here. So this data is populated, then only this to this We will have the date. Okay? So this is important. So I think this this was there in ECC six where you had the, you know, customer number.

So let's change it and let's try to create customer out of it. That would be something. Okay. So let's create a custom. Okay, so here you see the customer probably will create. See the customer number is properly this.

So here, here I can put the same random number grants refers to customer. When the number refers to Oh, it's saying you cannot flip that thing. Display. So probably wrongly, that's where it's if it makes sense, it's giving me an error message. So now What I'll do is for the outcome, please give me an S message. Okay, so what was it referring to it in those I can get from here.

So it was saying on 010007 vendor as customer and that vendor so I can just populate any vendor here and make it so that hopefully teach let's see how it doesn't make sense to Okay, let's take one out. Let's see how it works. Okay, so now does not exist. Okay. So here we'll probably put populate something one doesn't currently Reference will be. Okay.

Let's see. Okay, so here. So I think it goes into into a deadlock situation where I'm trying to update both of these. So here you can see the what was the customer and all those things. So we created here. So now let's go to the next piece.

So the next piece, the next table would be the bank, bank. Okay? banking is very important. Now, you might say this bank is important. And also you have to probably put a special role to view these tables because you don't want to allow every person in your company to see banking. So what we can do is you can ask the security team Hey, can you Put some banking thing.

So here what we'll do now, we'll just go to this view. And we'll change it to supplier. And in the payment transactions, here we have the banking. So you might say, let's check the banking. Really agreeing or, you know, just making it up. It seems like it's agreeing is the bank number, everything is fine.

And again, good thing is there's a start date and me. Okay? So that's, that's pretty useful. Okay, you can do it here. And you can put the change history, you can change the validity and all those things. This is pretty useful in those 401 that brings down the change history a lot too, to a limit with the s for HANA system can run Unlike a Ferrari car, Okay, the next one which is important is this table is this table.

So we are now going to this table which is pretty useful is this one and we put this business partner, okay. And if you notice, this is the business partner and here what we get is the purchase organization. So this is similar to what is similar to LFM one. So you might say Okay, can you please show me a lesson one? Well, I will, I would love to show you LFM one now, with this random number. So, we are going to show this vendor number.

And again, funny part if I populate something wrong. It gives me an error message. It gives me that I shouldn't enter these things in in my headphones. Okay, so here's the thing. See, it's the same. It's the same NP, you see?

This is 1010 purchasing organization, and you get all the information. Okay? Do I get much information? Oh, yeah, I have payment terms. Have you noticed one good thing on I think these these are mostly views. That's why they can change the name but and make it more meaningful.

One of the biggest complaints I receive from all American American clients customers is why a vendor is needs to be called listener. Why I need to change it from fee level. So if you if you notice every time you want to see the real useful information, you have to change it to feel level okay? means that the English one but the field name is always listener, Mara magner, and all the table names, they couldn't change the field name. Well, they have changed because they have created a bunch of views and they could change. So if I change it to field label, okay, it's back to payment terms.

But if by mistake calls, someone has this septic field name, I an IT guy doesn't need to go and say you know to something, you know SAP is a German company and they like to name it based on that and it's a lot of work to change it change the field name based on the based on the type of login you're doing because it's something core, it's the table field name, but they what they did is a smart way they created a bunch of views and then they renamed all these fields. So people will not complain and that those are the tables only. I'm giving it to you. So if you don't flag if you Don't understand German, and you don't need to worry in s for HANA because you're getting all these things, okay? So, all those constraints are used to get as an IT person Tuesdays are oh and as quite fine, right.

So, this is the thing for purchasing group. Now this is the table. Now you I said okay, you can read the purchase. Now what is the other one company called data? Okay? It is the company code.

So, you might say, Okay, can I check in Lfb one now that's the table row. Let's see, probably based on what we are teaching, nothing has changed. And if you see a with this random number, and, and I have company code 1010 Let's match it here. Magic here. Okay, again, please stick around one. And here.

Wallah. You have it and guess what? If you notice the same thing the field field name has changed. Its meaning it's more meaningful now it's English you don't need to worry. Okay? If you don't look if you don't you if your complaints that oh I I don't understand German and I don't need to understand to learn to run sa p well those days are over she moved to S for HANA and all European of understanding why lift Nara is not vendor number and why lifter is not supplier why Kunal which was customer number is not customer number.

So all those things are gone. So you can use this very effectively and this is pretty useful, nothing has changed what so as you are seeing the changes that are making life easier, like this is a very big change which will make life easier for both it as well as the business Again 16 is there and the next thing which you want to do is this all these tables will be added in the tutorial. Keep it in a cheat sheet and use it accordingly. You probably will be using once a week or twice a week or once a month and after that you will learn it by heart. So this these are the very important tables in us for