- 39
- 104 720
Muhammad Khan
Canada
เข้าร่วมเมื่อ 26 ก.ค. 2019
SAP Lessons
Create Queries in SAP with SQVI, SQ01, SQ02 (Hindi/Urdu)
Queries in SAP are report-building tools, and functional SAP consultants can use them to develop simple ad-hoc reports. This video will talk about the transaction codes SQVI, SQ01, and SQ02, which can be used to create these queries.
SQVI
SQVI is a simple ad-hoc report that can be written directly in the production system, meaning there is no need for transporting information between systems. Any functional consultant (or even business user) with a good understanding of SAP tables can write a query with SQVI.
MM PO Table
EKKO
EKPO
EKKN
EKKO - PO Header
EKPO - PO Line Item
EKKN - PO Account Assignment
Report
SQVI
SQ01
SQ02
SQVI
SQVI is a simple ad-hoc report that can be written directly in the production system, meaning there is no need for transporting information between systems. Any functional consultant (or even business user) with a good understanding of SAP tables can write a query with SQVI.
MM PO Table
EKKO
EKPO
EKKN
EKKO - PO Header
EKPO - PO Line Item
EKKN - PO Account Assignment
Report
SQVI
SQ01
SQ02
มุมมอง: 625
วีดีโอ
SAP S/4 HANA Create Queries in SAP with SQVI, SQ01, SQ02 (English)
มุมมอง 1.1Kปีที่แล้ว
Queries in SAP are report-building tools, and functional SAP consultants can use them to develop simple ad-hoc reports. This video will talk about the transaction codes SQVI, SQ01, and SQ02, which can be used to create these queries. SQVI SQVI is a simple ad-hoc report that can be written directly in the production system, meaning there is no need for transporting information between systems. A...
SAP User End training Material Management MM Create Purchase Order PO Services SES ME21N ME29N ML81N
มุมมอง 84ปีที่แล้ว
SAP User End training Material Management MM Create Purchase Order PO Services SES ME21N ME29N ML81N
SAP User End training Material Management MM Removing R Block MRBR
มุมมอง 108ปีที่แล้ว
SAP User End training Material Management MM Removing R Block MRBR
SAP User End training Material Management MM Reversal MIGO MIRO MR8M MBST
มุมมอง 327ปีที่แล้ว
SAP User End training Material Management MM Reversal MIGO MIRO MR8M MBST
SAP User End training Material Management MM Create Purchase Order PO Approval ME21N ME29N ME28 ME9F
มุมมอง 55ปีที่แล้ว
SAP User End training Material Management MM Create Purchase Order PO Approval ME21N ME29N ME28 ME9F
SAP User End training Material Management MM Create Purchase Requisition & Approval ME51N ME54N ME55
มุมมอง 329ปีที่แล้ว
SAP User End training Material Management MM Create Purchase Requisition & Approval ME51N ME54N ME55
SAP CO (Controlling) Reposting in cost center accounting - KB61, KB11N, KSB1
มุมมอง 1.7Kปีที่แล้ว
Controlling- KB61 T.Code: Kb61 is used for report line items with reference to FI. Documents. Primary accounts $ Cost Center FS00 430017 Printing & Stationary 1000 P1_C1 430018 Canteen Expenses 2000 P1_C1 430017 Printing & Stationary 100 P1_C2 430018 Canteen Expenses 200 P1_C2 FAGL3KEH Default Profit Center FB50 KSB1 Cost Centers Report -Line wise KB61 Change Cost Center/Split amount/Order/Post...
SAP Error Msg No: V1801 Mandatory Condition PROO is missing in SD VA11, use VK11
มุมมอง 2.7Kปีที่แล้ว
SAP Error Msg No: V1801 Mandatory Condition PROO is missing in SD VA11, use VK11
SAP S/4 HANA Msg No: V1599 No Business Can Be Determined for Item 000010 in SD VA11, use OX03, OMJ7
มุมมอง 617ปีที่แล้ว
SAP Error Msg No: V1599 No Business Can Be Determined for Item 000010 in SD VA11, use OX03, OMJ7
Short Videos - SAP S/4HANA Business Organization (business group/Parent Company)
มุมมอง 50ปีที่แล้ว
I am making a short series of videos for SAP modules like General Ledger, Accounts Payable, Accounts Receivables, Assets Accounting, Controlling, Sales Distribution, Material Management, and much more. After watching these videos, you don't need to attend any institute/college or purchase any Udemy courses. Subscribe to my channel so will not miss any videos.
SAP FI GL Cross Company Code Postings, OBYA, FBU2, FBU3 and FBU8
มุมมอง 566ปีที่แล้ว
OX15 Company (Business Group)- M116 Create 2 company codes and attached to Company (Business Group) OBA7 Define Document Type FBN1 Define Number Range Document Type Select "Inter-Company" Same Chart of Accounts for both companies Same GL account numbers for Receivables & Payables (recommended) Company Code P1 P2 Receivables (A/R) a/c s 100000 100000 Payables (A/P) a/c 200000 200000 Expense a/c ...
SAP End User Training -Open item Posting, Reversing Clearing and Non Clearing F-04, FB08 and FBRA
มุมมอง 423ปีที่แล้ว
FS00 Select open item Management Tax payable 124003 a/c Expense 411010 a/c FB50 100000156 FBL3N GL Report F-04 Post with clearing 100000157 PstKy- 50 Bank 218200 a/c 218200 Process Open Items 124001 a/c Reversing Document FB08 Try using FB08, no effect, as the account is cleared FB08 is for reversing a normal FI document that is not considered a clearing document FBRA FBRA is used to reverse “c...
SAP End User Training - Recurring Entries Creation and Posting , FBD1, F.15, F.14 & FS10N.
มุมมอง 1.1Kปีที่แล้ว
FBD1 To enter Recurring Entry F.15 To check above entry F.14 To process Recurring entry FS10N To check recurring entries in a ledger GL a/c Bank 218101 Expenses 411010 Reversal entry Doc no. 9100000013
SAP End User Training - Account Assignment Template FB50, FB60 ANF FB70
มุมมอง 227ปีที่แล้ว
SAP End User Training - Account Assignment Template FB50, FB60 ANF FB70
SAP Foreign Currency Valuation, Month / Year end closing, Realized / Unrealized FAGL_FCV OB08, OBA1
มุมมอง 336ปีที่แล้ว
SAP Foreign Currency Valuation, Month / Year end closing, Realized / Unrealized FAGL_FCV OB08, OBA1
SAP Parallel accounting, Leading Ledger, Non Leading Ledger and Extension Ledger
มุมมอง 302ปีที่แล้ว
SAP Parallel accounting, Leading Ledger, Non Leading Ledger and Extension Ledger
SAP End User Training - Account Assignment template with FB50, FKMT, F-02, FB01, O7E3
มุมมอง 6692 ปีที่แล้ว
SAP End User Training - Account Assignment template with FB50, FKMT, F-02, FB01, O7E3
SAP End User Training - Mass Reversal in SAP with F.80 & FB03
มุมมอง 2942 ปีที่แล้ว
SAP End User Training - Mass Reversal in SAP with F.80 & FB03
SAP End User - GL Reversal transaction FB08
มุมมอง 1202 ปีที่แล้ว
SAP End User - GL Reversal transaction FB08
SAP S/4 HANA Controlling Configuration (FICO)
มุมมอง 1.5K3 ปีที่แล้ว
SAP S/4 HANA Controlling Configuration (FICO)
SAP S/4 HANA LTMC G/L ACCOUNT / CHART OF ACCOUNT UPLOAD (Legacy Transfer Migration Cockpit)
มุมมอง 3.9K3 ปีที่แล้ว
SAP S/4 HANA LTMC G/L ACCOUNT / CHART OF ACCOUNT UPLOAD (Legacy Transfer Migration Cockpit)
SAP S/4 HANA LTMC Accounts Payable Upload/Transferred (Legacy Transfer Migration Cockpit)
มุมมอง 4.5K3 ปีที่แล้ว
SAP S/4 HANA LTMC Accounts Payable Upload/Transferred (Legacy Transfer Migration Cockpit)
SAP S/4 HANA LTMC Accounts receivable Upload/Opening Balance /TB (Legacy Transfer Migration Cockpit)
มุมมอง 6K3 ปีที่แล้ว
SAP S/4 HANA LTMC Accounts receivable Upload/Opening Balance /TB (Legacy Transfer Migration Cockpit)
Asset Accounting Configuration in SAP S/4HANA / EC08/OAOB/OAOA/AS08/AO90/OAYR/AFAMD/AFAMS/AFAMA/OAYZ
มุมมอง 2.7K3 ปีที่แล้ว
Asset Accounting Configuration in SAP S/4HANA / EC08/OAOB/OAOA/AS08/AO90/OAYR/AFAMD/AFAMS/AFAMA/OAYZ
Manual Cheque Payment in SAP FICO / FCHK / FCHI / FS00 / FK02 / OBZ5 / FB60 / F-58
มุมมอง 2.5K3 ปีที่แล้ว
Manual Cheque Payment in SAP FICO / FCHK / FCHI / FS00 / FK02 / OBZ5 / FB60 / F-58
House Bank and Bank Key Creation in SAP FICO / FI01 / FI12_HBANK / FI12
มุมมอง 2K3 ปีที่แล้ว
House Bank and Bank Key Creation in SAP FICO / FI01 / FI12_HBANK / FI12
SAP S/4 HANA Accounts Payables Implementation / OBD3 / XKN1 / OBB8 / OBB9 / BUCF / FK01/ OBXV / OBA3
มุมมอง 5953 ปีที่แล้ว
SAP S/4 HANA Accounts Payables Implementation / OBD3 / XKN1 / OBB8 / OBB9 / BUCF / FK01/ OBXV / OBA3
SAP S/4HANA FICO AP Automatic Payment Program Run F110
มุมมอง 6K3 ปีที่แล้ว
SAP S/4HANA FICO AP Automatic Payment Program Run F110
Become SAP Certified S/4 HANA FI Consultant - Sap Fi Certification Questions And Answers
มุมมอง 11K3 ปีที่แล้ว
Become SAP Certified S/4 HANA FI Consultant - Sap Fi Certification Questions And Answers
Why upload video without proper sound??
Thank you
Sir Very Elaborated and easy to described,
Thanks you so much for giving very valuable information....I can't see like this complete vedio...really salute you again thanks your patience....🎉🎉🎉🎉
Please add voice in video.. insted of typing
Voice is very slow
How much are registration fees and exam fees for FICO certification?
థాంక్యూ సర్
Thank you!
Nice video but I'm not able to see the secondary cost element, and it's value, in the KE30 report. Any clue?
🤗 P R O M O S M
Very well explained!
Glad it was helpful!
Your reply will be appreciated
Please I need your help. I have created a query but there is error messages “No data was selected” These are my tables: VBRK VBRP LIPS VBUK The joining is : VBELN
Thanks a lot sir.
Thank you.Very helpful !
Sir this is helped me lot i have a query i want to see batch wise profitability report for that i created batch as characteristic from which table i need to take please tell me sir. Thank you.
A beginner question- In Gl balance upload for customer Is there provision in template to enter customer account ? How to we know which customer opening balance is this ? Example customer A has 4000 OB and customer B has 5000 OB but reconciliation account for both is same 10001 . Can you help
Very detailed. Thank you for sharing
Please check your mail.
HI ..How to change name ..by mistake given one later wrong ?
Hi, call SAP help line or email them, they can change the name, it is very easy.
Thanks
Is it really possible to pass global certification in first attempt just by studying pdf?
Yes, all my friends and I passed in first attempt.
thank you sir.
thank you
how to get study material
email me at alikhan.fcma@gmail.com
check ur mail and respond
Hi, did you get pdf ?
Nice
Thanks
Hii sir it's me huzaifa sir please share pdf
Hi, did you get pdf ?
a good informative video but not happy with the voice not sure when u make a video next time atleast keep ur voice a bit loud dont talk in ur mouth so people can understand what r u talking about
Sorry for that
Hi sir..may i know the value of reguh-waers is derived from where? from the invoice currency or vendor master order currency?
It's excellent video
Could you please check your email and respond
Very poorly explained. You sound disinterested and hence its reflecting in the quality of your explanation.
How to get materials?
I have mailed you please check
Hi how much it costs and did he replied back?
hii sir In asset posting AS01 I have got error you cannot determine period rule 4 can you clwarify that error plz
Dear sir, I have given sap FI exam and i have also passed but i have not got certificate.....can you tell me how will i get certificate...Means where is the mail or where does it come from?
Hello Nishant kindly help me to clear my SAP exam with your guidance
Hello, Do you get the certificate? How you get it through email? Within how much days it took to get the certificate
thanks a lot for solving practical question in very less time.
Hi there, 400 is including VAT ? if we are not migrating VAT line item how will the offsetting account clears to zero? e.g. AR Ccustomer1 inv amt =120 including 20 VAT) Recon account = 120 offset ac =120 offset ac = 100 Revenue GL ac = 100 offset account bal 20?
How to get material and mcqs
I have sent you the mail
Hi bro is there anything like sap certificate nd sap global certificate. Kindly clear my doubt on certificate types
Thanks for the toturial video, but you sound super tired mate. :D Grab a nice cup of coffee for the next video maybe. :D
Thank you vey much for your consolidated video about Account based COPA.. Great one.
Very good video, thanks a lot. Keep posting!
Thanks for sharing, can you upload one with deffered tax
How can I edit company Short text and Long text in all GL accounts / COA (FS00)? Thank you.
Thank you Sir. It well explained, I have one more doubt here. If I want to show the planned values for each brand then how can I show it..?
Very well presented. Keep it up Man
Thanks for the appreciation bro