expertsask994@gmail.com
My Account
  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account
Blog
Home General SAP Everything about FEBKO & FEBEP Table (Part 2)
General SAP

Everything about FEBKO & FEBEP Table (Part 2)

ERP College February 21, 2022 0 Comments

This is second part of this blog series. (Read first blog here – FEBKO details)

In continuation with previous blog, we will start this one with FEBEP table.

Introduction

FEBEP table stores line item records of bank statements. FEBKO & FEBEP table can be compared with BKPF & BSEG table, earlier one stores header information and latter one stores line item information.

If you check FEBEP Table fields, you can notice it is hard to directly look into FEBEP table without referencing FEBKO table. So you should always start your search from FEBKO table, where you have various key fields to narrow down your result data as per the requirement. Once you got the relevant entries in FEBKO which you need to further dig into line item level, then you can take the common field ‘short key – KUKEY’ and search for it in FEBEP table.

FEBEP Table field details

Lets execute one record and start checking FEBEP table field

First field is short key, unique key for each statement and common field between FEBKO & FEBEP

Then we can see LC field i.e. line item completed. It will show if the posting of this particular line is completed or not.

So in FEBEP table there will separate line for each transaction of bank statement.

U1 & U2 field represents posting area 1 & 2 postings. If the line item is associated with posting rule, which has accounting entry in two areas, then system will check if both areas are posted or not. This can be verified by x mark in U1 & U2 field.

Document number & posting date  is document posted in SAP against statement transaction.

Read Blogpost: Tips and tricks on Bank Reconciliation in SAP

Further we have fields like account currency, amount of transaction. BTC – Business transaction code is used to determine posting rule based on the mapping in OT83. So here in FEBEP, system will capture the BTC (VORGC) from bank statement and search in OT83 if there is any external transaction code available of same character, if it is available then system will put it into FEBEP external transaction field (VGEXT). Posting rule (VGINT) will be determined from external transaction code.

There are several fields for partner bank details. These will be populated in case of clearing open vendor invoice.

Then there are various BDC fields available, which are supported by search string. If you remember there are various options available in search string setup to manipulate the final posting.

Then there will be fields like interpretation algorithm, it will have interpretation algorithm number which is used to post this line.

This all field data will make sense if you know the underlying configuration and how it evolve in each process. If you want to learn search string configuration, interpretation algorithm & posting rules with multiple posting areas, then you can read this ebook.

With this we have come to an end of this two part series blogpost. Hope you enjoyed reading it and learned few things. You can subscribe below to receive email update of every new blogpost:

100
5564 Views
AboutERP College
ERP College is a knowledge portal for all of those who want to learn SAP. This is a one-stop reference for your entire SAP needs. Here you will find blogs that will help you to point out daily support issues. The blog covers technical, educational, and psychological aspects of working with SAP, mostly from the point of view of consultants or people responsible for implementing SAP software.
In Socials:
PrevEverything about FEBKO & FEBEP tables in SAP (Electronic & Manual Bank reconciliation)February 11, 2022
Every Cost Object settlement (K088, CJ88, VA88, C088)March 1, 2022Next

Related Posts

ABAPGeneral SAP

ST05 Database Trace: How it is helpful to Functional consultant

You can trace the database using ST05 transaction to find out what tables /...

ERP College October 28, 2022
General SAP

What is MT101 file format and it’s application in SAP

MT101 message is a request to transfer fund from payer’s account to...

ERP College August 24, 2021

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Home
  • About
  • Contact
Categories
  • ABAP 8
  • FICO 23
  • General SAP 29
  • MM 1
  • SD 2
Products
  • SAP Accounts Payable (AP) Training
    Rated 4.00 out of 5
    ₹1,999.00 ₹1,699.00
  • SAP Accounts Receivable (AR) Training ₹999.00 ₹699.00
  • SAP DME - A Simplified Guide
    Rated 4.50 out of 5
    ₹349.00 ₹280.00
  • SAP Classic Vs New GL Accounting
    Rated 5.00 out of 5
    ₹999.00 ₹799.00
Sign Up to get update of latest Blogs

Find Us

Address
123 Main Street
New York, NY 10001

Hours
Monday–Friday: 9:00AM–5:00PM
Saturday & Sunday: 11:00AM–3:00PM

About This Site

This may be a good place to introduce yourself and your site or include some credits.

Contacts
Website: https://erpcollege.co/
Email: expertsask994@gmail.com
Terms & Condition

Copyright © 2020 ERP College by Smarksys Technologies. All Rights Reserved.