[email protected]
My Account
  • Home
  • Blog
  • eBooks
  • ECC/S4 system Access
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • ECC/S4 system Access
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • ECC/S4 system Access
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • ECC/S4 system Access
  • 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)

SAP 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:

19
1600 Views
AboutSAP College
SAP 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

General SAP

7 Secrets about SAP transportation request that every Functional consultant Should Knows

Transportation request is considered pool of changes that you did in database tables...

Ayman Mohmed December 2, 2020
General SAP

Material price calculation in PO, GR, and Invoice

In this blogpost we will see how material price is calculated in procure to pay...

SAP College March 18, 2022

Leave a Reply Cancel reply

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

  • Home
  • About
  • Contact
Categories
  • ABAP 8
  • FICO 18
  • General SAP 23
  • MM 1
  • SD 2
Products
  • Controlling - Profitability analysis (CO-PA): Comprehensive coverage of the SAP CO-PA module ₹449.00 ₹299.00
  • S4HANA 2021 – BASIS & Security Server ₹1,849.00 – ₹11,999.00
  • Manual and electronic bank reconciliation in SAP: Step by step guide for EBS with real time business scenarios ₹250.00 ₹229.00
  • SAP DME - A Simplified Guide ₹349.00 ₹280.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

SAP College is a knowledge portal for all of those who wants to learn SAP. This is a one-stop reference for your entire SAP needs.

sap_college

Few insights about Brexit from the SAP's latest we Few insights about Brexit from the SAP's latest webinar. Brexit is still open with all the possibilities and still everything is clear... as said... they are very close to the deal and yet too far from the deal.

#SAP #ERP #SAPERP #brexit #sapcommunity #s4hana
To read full blog and more like this one visit the To read full blog and more like this one visit the website mentioned in bio.... 
@sap_college 

#sap #saphana #SAPUI5 #saperp #sapcommunity #S4 #s4hana
End-User Manual - Asset Accounting in S4 In this f End-User Manual - Asset Accounting in S4
In this free document, you will get a broader picture of how end-user transactions are changed/affected with New Asset Accounting.
All the information about new transactions and obsolete transactions in S4.

You will learn the newly introduced topics in below areas:

1. Asset Master data
2. Asset Accounting business transactions
3. Month-End closing activities
4. Year-End closing activities
5. Asset Accounting - Information System

Download this free book now from the link in bio

https://lnkd.in/gtvPz-U

#SAP #s4hana #sapcommunity #erp #sapfico #saperp #fico #accounting #assetaccounting #s4 #HANA
Follow SAP College on LinkedIn and stay up to date Follow SAP College on LinkedIn and stay up to date with SAP's new releases. New blog post everyday. eBooks review. Free books. Documents. And many more....

#SAP #S4 #SAPCOMMUNITY #S4HANA #ERP #SAPUI5 #SAPERP
Follow on Instagram
This error message is only visible to WordPress admins

Error: API requests are being delayed for this account. New posts will not be retrieved.

Log in as an administrator and view the Instagram Feed settings page for more details.

Contacts
Website: https://sapcollege.co/
Email: [email protected]
Facebook Page
Terms & Condition

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