class 99
asset transaction:
1. create asset master AS01 AS91
2. asset purchase without po f-90
class 100
asset purchase/aquisition with vendor without po
new asset accounting:
1.operational view liability vendor OFFSET A/C= ASSET TECH CLRG
2. valuation view assets fixed asset OFFSET A/C= ASSET TECH CLRG
entry IAS IFRS vendor invoices
non-leading leading 50000
1. asset debit 50000(separate) 50000(separate)
2. vendor credit 50000(common) cr
doc numbers
1900000006 1900000006
3400000007 1010000021
dep @ 5 year 10000 -
dep @ 10% slm 5000
net book value 40000 45000
T095 Balance sheet accounts for depreciation areas
f-90/MIRO
s_alr_87012936 - Depriciation simulation: capitalized assets
Main-sub
The asset 1000000003 0 is created
inr
632,91 BM1001
632,91- BM1001
632,91- 01.12.2024
632,91 BM1001
11101000
90009000
23100001
90009000
15.01.2025
ebrs/ebs/electronic bank statement
example 1:
lenovo purchase water bottles from supplier bisleri ltd for 80000 inr…. On 10th nov 2024
payment terms are 10% discount if paid within 20 days…. No discount in 30 days
lenovo paid through hdfc bank check # 44763287 dated 25th nov 2024. for 72000 inr
1. vendor
2 vendor invoice
3. discount
4. payment from hdfc bank
5. check number & date
6. payment reconcilliation
7. water Expenses
8. cost center
9. profit center
10. house bank
11. account id
12. bank GL main & sub
TRANSACTION CODE TO CREATE P.TERM= OBB8
in ecc creation of cost element is ka01
in ecc creation of secondary element is ka06
default account assignmnet=okb9
03.02.2025
INTERVIEW SESSION
1. EBS
2. FIXED ASSETS
bank reconcilliation Restart
fixed asset Restart
BASIC ASSGNMENT FOR EBS:
1. TWO VENDOR PAYMENT
2. TWO CUSTOMER PAYMENT
3. THREE EXPENSES
4. THREE INCOMES
default profit center
default cost center
FEBAN 3 Unreconciled Transactions
FEB_BSPROC
31st Jan
1st Feb
BASIC ASSGNMENT FOR EBS:
1. TWO VENDOR PAYMENT
2. TWO CUSTOMER PAYMENT received
3. THREE EXPENSES
4. THREE INCOMES
example 1
bmw purchase water bottles from supplier bisleri ltd for 80000 inr…. On 10th nov 2024
payment terms are 10% discount if paid within 20 days…. No discount in 30 days
bmw paid through hdfc bank check # 44763287 dated 25th nov 2024. for 72000 inr
example 2
bmw purchase printer from Infotech Pvt Ltd for 25000 INR on 5 nov 2024
payment terms are 5% discount if paid within 25 days… no discount in 30 days
bmw paid through hdfc bank transfer ref no 4476328845 dated 25.11.2024 for 23750 inr
example 3
bmw sale car accessaries to Naresh Tyres & LLp Ltd for 50000 INR on 10 nov 2024
payment terms are 10% discount if received payment within 20 days... no discount in 30 days
bmw received payment check # CHQ4476321 as on 25.11.2024 for Rs 45000 inr
example 4
bmw sale car to honda india ltd for 650000 inr on 6 nov 2024
payment terms are 5% discount if paid within 25 days… no discount in 30 days
bmw received payment neft TRANSF 4476328846 as on 25.11.2024 for Rs 617500 inr
example 5
bank charges oct-24 deducted from banks of rs 2000 25.11.2024
example 6
bank commission charges oct-24 deducted from bank of rs 2500 25.11.2024
example 7
bank late payment fees oct-24 deducted from bank of Rs 3000 25.11.2024
example 8
bank paid interest of Rs 3500 of oct-24 25.11.2024
example 9
bank paid commission of Rs 3800 of oct-24 25.11.2024
example 10
bank paid Brokerage of rs 3200 of oct-24 25.11.2024
T.CODE IS USED FBR2 BY POSTING ENTRY FOR REFERENCE
EBRS
BANK OPENING BALANCE 0.00
1. TWO VENDOR PAYMENT
EXTERNAL TRANSACTION TYPE GL AMOUNT BANK REF
NCHK 12201012 -72,000.00 CHEQ44763287
NTRF 12201014 -23,750.00 TRNF 4476328845
2. TWO CUSTOMER PAYMENT received
NCHK 12201011 45,000.00 CHQ4476321
NTRF 12201013 617,500.00 TRANSF 4476328846
3. THREE EXPENSES SEARCH STRING FUNCTIONALITY
NCHG 44100001 -2,000.00 BNK CHG
NCHG 44100002 -2,500.00 BNK COM
NCHG 44100003 -3,000.00 LATE FEE
4. THREE INCOMES SEARCH STRING FUNCTIONALITY
NMSC 32100001 3,500.00 INT RCD
NMSC 32100002 3,800.00 COMM RCD
NMSC 32100003 3,200.00 BRKG RCD
BANK CLOSING BALANCE 569,750.00
WED CLASS 07.02.2024
ACCOUNT SYMBOL DESCRIPTION
BM10BM Main Account
BM10CI Check Incoming
BM10CO Check Outgoing
BM10TI Transfer Incoming
BM10TO Transfer Outgoing
BM10IR Interest Received
BM10CR Commission Received
BM10BR Brokerage Received
BM10BC Bank Charges
BM10CC Bank Comm Charges
BM10LP BANK Late Fees
19.02.2025
EBS - Search strings
This is used for PNL postings from mt 940 statement
we use key words to used tags 86 to determine search string.
Example: if bank is showing all Expenses in NCHG Transaction type….
WE have below 3 expenses to be posted from MT940.
1. Bank Charges 42101011 le10bc NCHG-
2.Bank commission charges 42101012 le10cc NCHG-
3.Late Payment fee 42101013 le10lp NCHG-
le10bm
ecc s/4 hana
bisleri ltd
80000 inr
8000 inr
72000 inr APP
44763287 & 25.11.2024
ebs-mt940 format
AACT SYMBOL DESCRIPTION
BHDCOT BM10: CHECK OUT
BHDCIN BM10: CHECK IN
BHDTIN BM10: TRANSFER IN
BHDTOT BM10: TRANSFER OUT
BHDKMN BM10: MAIN ACCOUNT
BHDCHG BM10: BANK CHARGES
BHDINC BM10: BANK INCOME
WE UPLOADED PAYMENT ENTRY… WE HAVE TO SEE SEARCH STRING
WE NEED TO CREATE ASSET AND SIMULATE TRANSACTIONS
IN ANY MODE FBL1N
IN ANY MODE FBL5N
IN ANY MODE FAGLL03
IN ANY MODE FAGLL03
how brs is actually used in any organization
MBS
EBS
RECONCILED ITEMS 100%
UN-RECONCILLED ITEMS IMPORTANT
FF_5 .TXT/FLAT FILE SM37 BACKROUND JOB
IN ANY MODE FBL1N
IN ANY MODE FBL5N
IN ANY MODE FAGLL03
IN ANY MODE FAGLL03
BRS ENTRY
DEBIT CREDIT
12201012 12201010
12201014 12201010
12201010 12201011
12201010 12201013
ONE ATTEMPT
ALL POSTING WITHOUT ERRORS
44100001 12201010 BANK CHARGES
44100002 12201010 COMMISSION
44100003 12201010 LATE FEES
12201010 32100001 INT RECEIVED
12201010 32100002 COMMISSION RECEIVED
12201010 32100003 BROKERAGE RECEIVED
12201010
12201011
12201012
12201013 34650
12201014 7000
32100001
32100002
32100003
44100001
44100002
44100003
L1BC BNK CHG
L1CC COMM CHRG
L1LP LATE PMT
8R 180001 189999 EXTERNAL BUSINESS PARTNER
HC 180001 189999 INTERNAL VENDOR
BMWE BUSINESS PARTNER
11 180001 189999 CUSTOMER
BV 12601 12650
DESCRIPTION
BM10: CHECK OUT
BM10: CHECK IN
BM10: TRANSFER IN
BM10: TRANSFER OUT
BM10: MAIN ACCOUNT
BM10: BANK CHARGES
BM10: BANK INCOME BV 12601 12650
BMBX BUSINESS PARTNER
thusday, feb 20, 2025 b6
Validation & substutions:
Validation: Check Point or Control Point
Configuration:
GGB0 - Create Validation
ob28-Activate Validation in company code
Document Header
Line Item
Complete Document
We can assign only one Validation in Company Code
In Header= Only 1 Assignment is possible
In Line Item= Only 1 Assignment is possible
To create Validation, we need below information:
In Each Validation, we must Create Steps to define multple validations
Each Validation step is created with below parameters
1. Prerequisite
2. Check
3. Message
Example 1: Allow only INR entries in BM10 Co Code…
Prerequisite Co. code BKPF-BUKRS BM10
Check Doc. CCY BKPF-WAERS ONLY INR IS ALLOWED
Message ERROR ONLY INR is allowed in BM10 CO.C
Examble 2: Allow only SUBSTITUTION TEXT in Reference column for BM10 Co. code
Prerequisite Co. code BKPF-BUKRS BM10
Substitution Reference BKPF-XBLNR Substitution
HEADER TEXT BKPF-BKTXT Substitution 1
110 class
validations & substututions:
Validation: Check Point or Control Point Substitution: change or Replace value during posti
Configuration: CONFIGURATION:
GGB0 - Create Validation GGB1 -Create Substitution
ob28-Activate Validation in company code OBBH- Activate substitution in company code
Example:
Business wants to have postings to Bank Main GL Account only from selected user ID's only.
we need to validate G/L Account for Users?
we need to validate users for G/L account?
To create the sets( is like a master)
t.code-gs01
111 class
table no-E070 to see the TR is imported or not by TR no
table no-e07t is track the TR by name
test cases:
1. validation for posting period
keep period jan, feb, mar open and allow only selected users to post in jan, feb. all users can post you need sets for user,
you need sets for user, period
2. validation for posting key
4.16.23
validation
1.ggb0 & ob28
3. header, line item, complete document
3.prerequisite, check, message
validation example
1. stop using future document date in co. code bm10
2.if document types is AB, currency must be either usd,eur, aed, sgd.
3.allow posting in the privious(closed) period only for selected users
1. stop using future document date in co. code bm10
message no. f5192 -check-document date is in the future
Option 1= we convert warning message to error message. t.code oba5
option 2= validation
prerequisite company code=bm10 & doc type=sa & kr
check document date cannot be future date
message future doc. Date is not allowed.
exceptional handling
abap dictionery t.code-se11
109
Substitution: change or Replace value during posting
CONFIGURATION
GGB1 -Create Substitution
OBBH- Activate substitution in company code
Document Header
Line Item
Complete Document
We can assign only one substitution in Company Code
In Header= Only 1 Assignment is possible
In Line Item= Only 1 Assignment is possible
To create substitution, we need below information:
In Each substitution, we must Create Steps to define multple substitutions
Each substitution step is created with below parameters
1. Prerequisite
2. Substitution
ONLY INR IS ALLOWED
ONLY INR is allowed in BM10 CO.CODE
ference column for BM10 Co. code
Substitution
Substitution 1
hange or Replace value during posting
Substitution
e substitution in company code
can post you need sets for user,
