Monday, 23 December 2019

Use of SAP T codes / how to use


Change Colour

To Change Colour of SAP Logon
First Logon SAP – Click Customized Local Layout or Alt + F12 – New Visual Design – Colour Setting – Click Theme Setting – Theme Enjoy – Colour Setting... Complementary – Now Choose One by One Colour – Apply – Ok.
For Other Than SAP Logon
First Logon SAP – Click Customized Local Layout or Alt + F12 – New Visual Design – General – Click Active –
System Development – Now Choose One by One Colour – Apply – Ok.
Upload From Clipboard
For Copy in Multiple Selection From Excel File to Multiple Selection first Copy by Control+C and then Click Upload From Clipboard Or Shift+F12
Fixed Layout
First Select Required Layout thereafter – Setting – Layout – Save – Give Name – Ticked User Specific – Description like Chennai etc. – Payment - Save.
Change Narration
Go to FBL1N, 3N, 5N etc. – Open the Ledger – Select the Document and Click – Document – Display<->Change – Thereafter Modify the Narration, Assignment etc. – Save.
Reversal (Cancellation)of Cheque Prepared
Step – I: FCH9 – Void Issued Cheque
Co. Code (1100) – House Bank (HD331) – Account ID (05331) – Cheque No. (007889) – Void Reason (5 i.e., Printed Incorrectly) – then go to Spects (Display) and confirm correct cheque document – Return  - Click Void – Then System will display “Cheque No.007889 voided, Payment Document Not Reversed” at bottom
Step – II: FBRA – Reset Clear Items
Doc. No. etc. then go to Clearing and Choose “Reset Clear Item” (i.e., Save) thereafter
Step – III: FB08 - Provision Reverse Entry: Reversal of Single Document
Reverse Party Ledger Document



T Codes
Description / Particulars
Paths / How to Execute
SP02
Output Controller: List of Spool Request
(If Print Command given but Printer hold i.e., not print then-)
Click Spool no. Box at left – Click Display – Spool Request – Print.
SU53
Display Authorization Date For User
First put an unauthorized code thereafter put SU53 then this code discloses which T-codes are authorized to this logging.
XD03
Customer Master Check
It provides Customer Details Like name address pan etc.
Xk03
Vendor Master Check: Display vendor (centrally)
It provides Vendor Details Like name address pan etc.
MIR4
Call MIRO – Change Status / Display Invoice Document For POST
Invoice Doc. No. i.e., Bill Entry No. i.e., Park Doc. No. – Follow On Doc. And Take Doc. No. Then Back – Vendor Name & Code – Invoice Date – Posting Date – Reference i.e., Invoice No. – Amount – Business Place – Text i.e., Narration – Tax/Vat Etc. – Compare PO Reference Thereafter – Simulate – Check Tax / TDS Etc. Then Post. 
Where A takes advance and paid freight to B then go in Details by Edit option in Display Invoice Document And Change the Vender Code of B And Put the Vender Code of A
F.01
Balance Sheet
Chart of Account – Co. code – Final Statement Version - Execute
F-01
Create Sample of Document
Narration can be change but amount cannot be changed in sample document
F-03
Clear G/L Account- Vat, Excise Ser. Tax Duty etc Payable
Account “VAT Ledger Code” – Clearing Date “Last Date of Completed Latest Month – Period – Co. Code – Additional Selection “Click Document Number” – Process Open Item – Partial Pmt – Document Overview – Double Click to Not Assigned……………….
F-32
Clear Customer: Header Data
Same As F-44
F-20
Customer Invoice Booking
Reference – Document Header Text – Posting Key 01 Automatic Coming For Debtor – Customer A/c No. – Enter – Amount – Business Place – Section – Assignment – Text – Posting Key 50 – A/c G/L 4 Series – Simulate - `*’For    Amount  - Cost Center 4143 – Assignment – 11000066.
F-29
Posting of  Customer Down Payment Request
Same As F-47 – Doc. No. – Customer A/c No. – Special G/L Amount – Text – profit Center – Assignment Means Check or DD – Enter – Simulate – Save.
F-37
Create Customer Down Payment Request
Request Same As F-47 – Customer A/c – Enter – Amount – Text – Document – Simulate.
F-39
Transfer from Special G/L to Normal G/L: Clearing Of Loan Payment
Reference – Doc. Header Text – Customer A/c No. – Enter – Simulate – Text – Save.
F-43
Invoice Create or Total Liability Creation: Vendor Invoice
Doc. Date – Posting Key Automatic Taken – Account No. of Vendor – Amount – Business Place – Section – Text – Posting Key 40 – 403003 – Enter – Amount – Cost Center – Simulate – Save. – 21000367.
F-44
1.    Clear Single Vendor Account











2.    Clear More than One Vendor account



















3.    Clear Special G/L



























4.    Clear One Account and Transfer the Entry to Another Account of Same Employee, if More than One account of One Employee

1. Clear Account: Account – Vendor Code – Co. Code – Special G/L ind Put `A’ – Process Open Item – Select All – Deactivate Items – Select One By One Items and see difference in `Assigned’ Box If Any Difference Come Then Double Click To `Difference Posting Box’ And Confirm That `Not Assigned Box’ is “0” – Document – Simulate – Save.
 
2. Clearing Between Two Vendor Account: Eg Advance taken by A and paid freight to B then –> A/c No. ‘B’ – Spl GL ind ‘a’ for advance – Process Open Item – Select – Deactivate – Select the figure Required to be adjust in A’s Advance balance – Double Click to Difference Posting – Document Overview – Choose Open Item – A/c No. ‘A’ – Special GL Ind ‘E’ for expense – Process Open Item – Select – Deactivate – Select both figures required to clear – Double Click to Difference Posting – Vendor A/c No. ‘A’ for balance left in the A/c – Document – Simulate – Save.  

3. Clear Special G/L: First Go to FBL1N – Open Ledger With Open Item – Select Type – Filer By KZ (i.e., Expenses) thereafter Open a New Session – F-44 – A/c Code – Clearing Date – Period (1=April, 2=May & So On) – Put `E’ for Expense, `T’ for Travelling etc. in Special G/L Ind – Enter – Select All – Deactivate Items – Control+F – Choose Document No. – Continue – Copy & Pest Doc. No. From Ledger – Continue – Doc. Overview – Put 29 in Pstky (Posting Key) – Account No. – Put `T’ (for Travelling) in SGL Ind – Enter – Amount – Business Place – Give Assignment No. & Narration – Display Doc. Overview – Choose Open Item – Enter – Select Amount – Document – Simulate – Click Cr. Entry – Give Text & Assignment No. – Document Overview – Post.

4. Clear One Account and Transfer the Entry to Another Account of Same Employee, if More than One account of One Employee: First Go to FBL1N – Open Ledger With Open Item – F-44 – A/c Code `old a/c’– Clearing Date – Period (1=April, 2=May & So On) – Put `E’ for Expense, `T’ for Travelling etc. in Special G/L Ind – Enter Doc. Overview – Put 29 (if Dr Bal And 39 if Cr Bal. in old Ledger) in Pstky (Posting Key) – Account No. “New A/c No. ” – Put `T’ (for Travelling) in SGL Ind – Enter – Amount (or *) – Business Place – Give Assignment No. & Narration – Click Display Doc. Overview –Document – Simulate – Click Cr. Entry – Give Text & Assignment No. – Display Doc. Overview – Post.
F-47
Down Payment Request / Creation of Loan / Advance
Down Payment Request – Doc. No. – Vendor A/c – Type Advance
Doc. Date – Type of Doc. – Company Code – Posting Date SAME – Period – Currency INR – Vendor A/c No. Means Vendor Code – Type Special G/L (A) Advance to Vendor – Enter – Amount – Tax Code VO – Business Place Chennai – Section is Also Chennai – Due on That is Due Date – Text Narration - Enter. Creation of Loan Payment Request – Doc. Date – Amount – Type of Special GL A/c – Amount. 
Advance to Vendor That means (A) – Enter – Amount as Advance Amount – Business Place – section – Text – Enter – If Tax Than `OT’ enter or If No Tax that Means Delete the `OT’ – Display Doc. Preview – Save.
F-48
Posting of Advance / Down Payment Request
Same Vendor A/c No. – Special DL A/c – Bank A/c No. – Enter – For Amount * - Business Place – Due On (Date) – Simulate – Enter – Save.
Same Vendor A/c No. – Bank A/c No. – Amount – Request – Double Click – Create Down Payment – Save.
Under F-48 Advance is paid by Bank but Under F-53 Payment is made by Bank Against Bills While Under F-02 is used for all types of Payments.
F-53
Posting of Outgoing Payment
Bank A/c No. – Amount – Open Item Selection – Vendor A/c No. – Process Open Item – Amount Double Click On Amount – Difference Amount Given – Document – Simulate – Save.  (Automatic Cleared and F-44 not required)
F-54
Clear Vendor  Down Payment
Doc. Date – Vendor A/c No.  – Invoice No. Deleted – Physical Year 2008 – Down Payment Write – In Text Type Narration – Simulate – Post – Then You Get Doc. No.
F-90
Acquisition from purchase w. vendor
Same As F-43
F-65
Make Requisition Or Park
Document Party: Date – SA – Co. – Date – Doc. No. N P – Reference – Doc. Header – Ram – Cost Centre – Text – Posting Key 34 i.e. Other Payable
FB03
Display Document : Post Document Day Book
Prepaid Exp. – A/c No. – Clearing Date – Process – Execute – Doc. Date – Simulate – G/L – Save.
Post Document Day Book: FB03 – Document List – Co. Code. – Fiscal Year – Posting Date – Execute – Select User Name and Filter the Logging No.
FB08
Provision Reverse Entry: Reversal of Single Document
Give all information and save
FB8N
Reversal of FI Document
Give all information and save
FB65
Enter Vendor Credit Memos (Debit Note)
First Select Credit Memo – Vendor Code – Doc. Date – Posting Date – Amount – Tax , if Necessary, - Business Place – Text – Reference – `0’ Item Entry – In Profit Centre put code and Double Click to Same and see that profit centre is correct and click Profit Segment – Continue – Back – Simulate – Take the Number of Debit Note.
FGI0
1. Trial Balance:


2. Execute Drill-Down Report: Initial Screen:


3. Total Vendor / Creditor List: P/L A/c,

4. Total Customer / Debtors List
Trial Balance Execution: –> 002:Reporting For Table FAGLFLE – Directly Click To G/L Account Balance – Currency Type 10 – Co Code 1100 – Account No. 300000 To 499999 – Ledger `0L’ – Fiscal Year – Period From `1’ To `12’ – Profit Center `multiple selection’ – Execute.
Creditors List For Scrutiny –> 033: Payable According to General Ledger Account Assignment – Payable Profit Center Double Click (Don’t Open the Line) – Customized Selection – General Ledger Line Item – Profit Center – Save – Company Code (1100) – Posting Date, if required  – CO Area (1100) – Hie: Profit Centre (1100) – Execute.
Report – Save TO PC – Spreadsheet – Directory – Desktop – name – Generate.
Debtors List For Scrutiny –>044: Receivables According to General Ledger Account Assignment – Receivable: Profit Center Double Click (Don’t Open the Line) – Balance Same As Creditors.
FB60
Enter Incoming (Vendor) Invoice
Vendor Code – Invoice Date – Posting Date – Amount – Tax – Business Place – Text – Reference – `0’ Item Entry and Thereafter Simulate – Park.
S_ALR_87012178
Age Wise Analysis of Customer
If you want to know any particular ledger give Co. code and execute
S_ALR_87012168
Display Age-wise Customer Or A Particular Customer
Display Age-wise Customer Or A Particular Customer fill required date & execute.
S_ALR_87012172
Sub-Trail
ALL Reports Under Information System
FBV0
Post Parked Document Directly Without MIR 4. : Park Document Day Book
Check Doc. No. – Enter – Entry will be Shown - Control+S – or Post the Doc. Then Confirmed in which company Changed.
Park Document Day Book: FBV0 – Document List – Co. Code. – Fiscal Year – Posting Date – Entered by “*chen*” – Execute.
FBV2
Display / Change Park Document
Click F5 – Change Amount One by one Debit and Credit – Document – Complete.
BRS
To prepare AUTO BRS through SAP system first Download bank statement from Inter net and Prepare an Excel Sheet with following sequence horizontally and  attached it with following T-codes
Company Code “1100”, House Bank – i.e., bank A/c No. in SAP System “HD331”, Account ID “5331”, Statement No. – i.e., new no. supposes upto 34no. Stm. Has been posted then take new no. 35, Stm Date – suppose last transaction date is shown by stm. 19.09.2009 then takes 19.09.2009, Opening Bal – i.e., Closing bal of stm. No. 34 will be opening of stm. 35, Closing Bal – i.e., closing fig. in stm. Be care that is fig. must tallied with total transaction, ( Note that Opening and Closing figures always be same figure in all the rows of the column),
Posting Date – it will be Stm. Date i.e., 19.09.2009, Bank Posting Session – it will be House Bank & Stm. No. i.e., HD331 – 35, Tran. – it contains R001=Cheque Issue R002=Cheque Deposit R005=RTGS(Real Time Gross Settlement), Value Date – Starting date of BRS period i.e., if BRS for 11.09.09 to 19.09.09 then value date will be 11.09.09. Amount – as given in Stm. Banker – Put Cheque No. in equal Digits if one no. is 4856 then you take ‘004856 to complete 6 digits, Allocation – Put Cheque No. i.e., Copy the Banker Column, Cost Center – Leave Blank, Vendor – Leave Blank, GL Account – Leave Blank, Profit Center – Leave Blank, Line Item – Copy the Text.

First:
FF67 Process Manual Bank Statement: – Setting – Specification – Further Processing – Processing Types “4” – Overview – Chennai – Click Statement No. 35 etc. i.e., last no. with status manu entered – Copy – Save.

Second:
Open New Session:
Customize Code F005 Upload Manual Bank Statement BDC: – Select File “HDFC.xls” – Session “Arbind” – Execute. Look at bottom whether system disclose “that upload done. Check batch input session”. Now Select “Arbind” – Process – Select the Display Errors only, Extended Log, Expert Mode, Dynpro Standard Size – Process – Session Overview.
   
Third:
Again FF67 – Click Overview and Choose our Bank then put last statement and click on Copy and Check Opening and Closing Balance then click on Save. Now it is posted.

Fourth:
Open Another New Session:
Customize Code FR017 Manual Bank Statement Report: – Co. Code. “1100”, House Bank “HD331”, Account ID “05331”, Statement No. “35”, Statement Date “19-09-09” – Now Click on “Not Posted Document” – Execute. Now Convert the generated list into Excel and Doc. No.

Fifth:
Again go to FF67 – Setting – Specification – Further Processing “Select 2” for forcefully. Again same process goto Overview, Choose location Chennai and Copy Statement further processing take bank posting session “Arbind” (any name can be give) and then Save.

Sixth:    
SM35 Batch Input Session Overview (List of Parked) – Choose your created session (i.e., select session posted name like ARBIND or HDFC etc.) – Process – Process/Foreground, Extended Log, Expert Mode, Dynpro Standard Mode – Process – Enter (for safe posting we can take one by one Cheque No. and search in the bank ledger the cheque issued etc. either in Bank Ledger or Excel Sheet and Copy the Doc. No. for that Cheque no. assignment) Thereafter Again Enter – Again Enter – Process Open Item – Control+F – Mark Doc. No. – Enter/Continue – Post Doc. No. – Enter – Select the Amount By Double Click – Document – Simulate – Save – Post.

Note: To exit from Session enter “/BEND” – Enter
         To cross one document to another enter /N – Enter
FF67
Process Manual Bank Statement
Bank A/c No. – Statement No. – Statement Date – Opening Balance – Posting Date – Enter – Save – Statement List Saved.
System – Services – Batch input – Session – Enter – Enter.
KOB1
Display Internal Orders: Actual Line Items / Area of Internal Order / Order Line Item
PROCESS (not step): Assets Create – Purchase Order Prepare – Goods Receipt Note – Bill Entry – Post.
BF04
Create Group of Billing the Document: Sales Invoice
Party No. – Execute – Select Any One No. – Line Item Double Click – Goto Condition – Save The Doc. – Ok
VA01
Create Credit Memo Request (ZRCR)
Select type or click on ZRCR – Co. code normal sale – create with reference – Bill document no. – Copy – click on line item – goto condition – click radio bottom – then give document amount.
VA01
Create Debit Memo Request (ZRCR)
Select type or click on ZRCR – Co. code - normal Purchase – create with reference – Bill document no. – copy – click on line item – edit -  condition – Log – completion – complete or not.
What should be debit or credit are going through accounting mode.
FB50
No. of Debit Or No. of Credit
JV Posting (Multiple Line): Doc. Date – Currency – Reference – Doc. Head – Doc. Type S A.
FB01
Cash Receipt / Cash Payment
Post document – type ZP cash payment – co. code – posting date – period – currency INR – Doc. No. not required – Doc. Header text – posting Key(40 for Dr) – expenses book – entry – Amount – cost centre – Text – posting key 50(Cr.) – account – cash in hand Ellapuram – enter – enter – amount – text + - simulate    save.
FBZ5
Printing Of Payment Document With Cheque Printing
Doc. No. – Payment method – check – house bank – A/c ID – Cheque No. – Save
Customize
Display Document: Voucher Printing & Printing Command – Cash Voucher
Doc. No. – Co. code – physical year – print immediately
F-49
Bank Guarantee Receipt – Customer Note
Date – Doc. Header Text bank Guarantee – Spl. G/L Bank Guarantee Customer – Customer A/c No. – Amount – Due – Text (Bank Guarantee) – Enter – Save.
PA30
Maintain HR Master Data
Personnel No. Put and Enter – Info type it relate 580 to 588 for Tax purposes. In case of New Employee Click Create and in case of old employee Click Display
J1INCHLN
Challan Creation
1ST Year – Business Place – Posting Date is Last Month Period – Section 194C – Document Date of Deposit – Posting Date – Bank A/c No. – Execute – Enter – Click on line Item – Amount – Document – Simulate – Save.
J1INBANK
Bank Challan Update
Code – Year – Challan Clearing No. – Date – Bank Key Execute – Challan is Updated – Deposited into Bank.
J1INCERT
Print Withholding Tax Certificate for Vendors: Issue TDS Certificates
Code – FY – Business Place Section Code “Chen” – Section – Posting Date – Bank Challan Date – Vendor “Vendor Code No.” – Certificates Date – Signatory – Designation (of Signatory) – Place of Printing “Chennai” – Official Date – Execute – Printer Name “LP01”– Print Preview (Check Whether TDS Amount coming in certificate is correct and tallied with ledger).
J1INQEFile
Quarterly E-Return
Co. Code – Deductee Company – State (TN) – TAN No. – Period – Section Code (Chennai) – Name of Deductor – Address – Execute – Copy in EXCEL.
ME41
Create RFQ (Request For Quotation): Initial Screen
General Request – Purchase Organization (1100) – Group (714 Chennai) – Enter – One Vendor Select and enter Again Enter.
ME42
Change RFQ (Request For Quotation): Initial Screen
ME43
Display Request For Quotation
ME49
Price Comparison List
Quotation No. – To – Quotation No. – Execute.
Miro
Enter Incoming Invoice / Invoice Verification
Invoice Date – P.O. Date – Enter – Goods and Services Item – Enter.
PC00_M99_CIPE
Salary Posting to Accounts: Create Posting Rune
First HR Department will park Salary thereafter Accounts Department shall post it.
Period –> Current Payment Period
Payroll Area –> CN (for Chennai)
Selection Criteria –> Payroll Area “CN” (In case of Individuals Employee give following Details – Personal No. – Vendor ID – Payroll Area “CN”)
Run Attributes –> Types of Document Creation “P”
Date for Document Creation –> Doc. Date (Always last date of the month)
Posting Variant – “RS” (i.e., Ruchi Soya) – Enter – Execute.
Now Click on Document Overview – Select Doc. No. – Edit – Release Doc. – Yes
Now go back to Screen Evaluation of Passing (Posting) Items – Posting Run Overview – Select our Payroll Posting – Edit – Post Doc. – Click “Immediately”.
Now go back to the first Screen – Edit – Filter – Edit Filter – Choose Payroll Posting (i.e., Run No. “601”) – Go to – Doc. Overview – Go to – Accounting Doc. Now Salary is Posted take the Accounting Doc. No. And Controlling Doc. No.
Now Deduct the Advance etc.