sdv sap fico notes

Purpose

Automatic Clearing of Open Items in the General Ledger. It also provides clarity on the difference between SAPF124 and SAPF124E programs.

Overview

SAPF124 was first released in release 4.0 and made available in 3.1H and 3.1I as well (note 76536). It is the substitute for the programs SAPF123 and SAPF123W. These programs, too, cleared open items, but they did the posting on their own. For the final clearing of the open items, SAPF124 makes a CALL TRANSACTION ‘FB1S’ (G/L Account) or ‘FB1D’ (Customer) or ‘FB1K’ (Vendor), this avoiding double coding for the clearing itself. The differences between SAPF124 and SAPF123 are explained in note 76536.

Description

This program might clear open items from customer, vendor and G/L accounts (in particular, GR/IR clearing accounts) automatically.
This program clears open items from customer, vendor and G/L accounts (in particular, GR/IR clearing accounts) automatically.
It selects all accounts specified in the value sets that have debit and credit postings according with customizing for SAP table TF123 via SAP transaction OB74.
The defaulted Clearing Criteria or Rule for Additional Rules For Automatic Clearing are:
a.Criterion 1 = Technical Field ZUONR for Assignment Number.
b.Criterion 2 = Technical Field GSBER for Business Area.
c.Criterion 3 = Technical Field VBUND for Trading Partner.

The following items are not cleared:

• Noted items

• Statistical postings and special G/L transactions of the type bill of exchange

• Items with withholding tax postings

• Down payments can only be cleared if down payment clearing for the same amount has been posted

The remaining open items are grouped according to fixed system criteria:

• Company code

• Account type

• Account number

• Reconciliation account number

• Currency key

• • BSID-WAERS for customers

• • BSIK-WAERS for vendors

• • BSIS-PSWSL for G/L accounts

• Special G/L indicator

Clearing takes place when, for the group of line items selected according to the above criteria, the balance in document currency (for customers and vendors) or in update currency (for G/L accounts) is zero. The date for clearing is the clearing date according to your selection specifications. In an update run, if the clearing transaction is successful, the clearing document number is specified.
During the program run, all accounts in which clearing can be performed are blocked. They are then unblocked again after the clearing transaction. Accounts that are blocked by other transactions intended for the automatic payment run are not considered in automatic clearing.

Output

If, in the output control, you have selected that documents that can be cleared or documents that cannot be cleared are to be output, you receive a detailed list. If you have not set either of the indicators, the program outputs a short list.
The detail list is a list of the line items and gives information about the open or cleared (or clearable) line items selected. Group of items that comply with the system criteria and the user criteria are summarized optically. If the clearing conditions have been fulfilled, the clearing date and, in an update run, also the clearing document number are displayed if the clearing transaction was successful. If an error occurred during clearing, the message No clearing appears.

The short list of the open and cleared items provides a summary of the results of the program run. The number of open items selected per account are displayed, the number of those that can be cleared, and the items actually cleared are displayed.

From the error log, you can see which errors occurred during clearing of a group (of documents that can be cleared according to the system criteria and user criteria). Depending on the error message, you should then try to clear the group concerned manually.

If necessary, the system also issues an additional log that states that no customer, vendor, or G/L account documents could be read from the database as a result of the selection criteria. A log entry also occurs in the following cases:

• Items with withholding tax postings

• If accounts are blocked

• If company codes are blocked by the payment program

Customizing

The clearing will be done according to the rules defined in transaction OB74. All items that have the same criteria and the balances zero, will be cleared by the program.
OB74: Additional Rules for Automatic Clearing.
If the documents are in different groups, these documents cannot be cleared together in accordance with your Customizing settings. Change your Customizing settings
(transaction OB74), if you want these documents to be automatically cleared together.

SAPF124E - Automatic Clearing (Clearing with a different currency)

If you want to clear a document with automatic clearing in a different currency, you can use transaction F13E (SAPF124E).
You can define the currency in the automatic clearing screen in the "Clearing currency" field:

The GR/IR Account

GR/IR is an interim account. In the legacy system of a client if the goods are received and the invoice is not received the provision is made for the same.
**************************************************************************************************************************************************************************************************************************************
Concerning 'Special GR/IR process' indicator in F.13 please refer to note 546410:
"The 'GR/IR account special process' indicator does not mean that this flag always has to be set for the clearing GR/IR accounts.
Generally, you can and should avoid setting the 'GR/IR account special process' indicator (correct Customizing required in Transaction OB74)."
If you set the GR/IR accounts special processing indicator, the program then automatically uses the EBELN and EBELP fields as well a as the XREF3 reference field as grouping criteria. The settings in OB74 are ignored for GR/IR accounts, because the purchase document and the material document number are to be used instead.
**************************************************************************************************************************************************************************************************************************************
If you select the field GR/IR Account Special Processing, then documents are assigned to GR/IR accounts using the material document in addition to the purchase order number and the purchase order item, assuming that a goods-receipt based invoice verification is defined in the purchase order item.
It only makes sense to use this indicator if the assignment of invoice receipts to the corresponding goods receipts using the purchase order number and the purchase order item is not sufficient (such as with scheduling agreements).

 In case of vendors or customers we have to prepare a separate statement showing only open items which should match with the trial balance figures


 In case of Assets, one  Asset wise acquisition value and accumulated depreciation should be shown in a separate statement.


 In case of material, prepare a statement showing material wise quantity, rate and amount which should match with the trail balance figures.


 we have to create 5 Dummy accounts under any one group,
     a) GL Clearing Account
     b) Vendor Clearing Account
     c) Customer Clearing Account
     d) Assets Clearing Account
     e) Stock Taking Account.


After uploading balances, if the above FIVE clearing accounts become ZERO, then our data takeover is correct.
Custm:-
1 : T code:



F-02

Enter all Credit Side items of trial balance as per the above clearing accounts classification in to SAP
eg:  GL Clearing Account Dr
             To Equity Share Capital Account
             To Vendor Clearing Account  (Sundry Creditors)
             To Asset Clearing Account (Accumulated Depreciation)
             To Sales Account
2 : T code:

F-02

Enter all Debit Side items of trial balance as per the above clearing accounts classification in to SAP
Customer Clearing Account  (Sundry debtors)   Dr
Asset Clearing Account (Fixed Assets)           Dr
Cash / Bank Account                                    Dr
Raw Material Consumption Account               Dr
Stock Taking Account                                  Dr
        To GL Clearing Account
3 :  T code:

F-43

 Vendor Open Line items.
Vendor Clearing Account   Dr
Party A (Spl GL account)(Type A)  Dr
          To  Party A Inv No. 1
          To Party A Inv No. 2
          To Party A Inv No. 3.


4: T code

F-22

Customer Open Line items.
Customer 1 -  Inv No. 1   Dr
Customer 1 -  Inv No. 2   Dr
Customer 1 -  Inv No. 3   Dr
           To Customer 1 (Spl GL Account)(Type A)
           To Customer Clearing Account.

KNA1: Customer master data At chart of acc
KNB1: Company code level master data
knc5: Customer payment history
KNC3
KNC1
KNBK
BSID:Invoice
BSAD:Clear


For AP Tables please click

Bank account Tables In Sap ,Electronic Bank Tables in Sap FICO,Bank Statement Tables In Sap,Clearing line item for Electronic Bank Statements In FICO,What is the Bank account Statement Table in Sap,F110 Tables in Sap,Bank Master Data Tables in Sap,Sap FICO Notes in 2016,Real time issues in Remedy Tool,Account Tables in Sap,FEBA Tables in Sap,Sap Bank account Tables In FICO,Bank Master Tables In SAP,Dunning Tables in Sap,Check num Tables in Sap

FEBKO :  Bank Statement Header
FEBEP  :   Bank Statement Line items
FEBRE  :   Electronic Bank Statement Refrence Line Items
FEBCL  :   Clearing line item for Electronic Bank Statements
BANK   :   Bank Master Data
PAYR    :    Payment Medium

FEBMS   :  Message table for Finnish bank statement
FEBPI    :    Polling Statement Line Item Information
FEBRE   :    Reference record for electronic bank statement
FEBVW :     Electronic Banking Management Records


APP and AP,AR,GL Tables

Vendor account tables in sap,APP Program Tables in sap,APP Tables in Sap,Automatic program Tables in Sap,FICO Tables in Sap,Vendor Mater data tables,Vendor Invoice Tables in Sap,Vendor clear Tables in sap,AP Tables in sap,Master Data Tables in FICO,

LFB1: Company code level vendor list
LFA1:Chart of account level vendors
BSIK:Vendor open items(Invoices)
BSAK(Clear items(vendor)

APP Tables:
REGUV: Control records for the payment program
REGUH: Settlement data from payment program (Payment Transactions)
REGUS: Accounts blocked at payment proposal -
T042E :Company Code-Specific Specifications for payment Methods
T042Z :payment Methods for automatic payment 
T042B: Details on the company codes that must pay- Payment Transactions
LFZA: Permitted Alternative Payee FI - Financial Accounting
REGUV:Control records for the payment program  Payment Transactions
 B504 - Sales org./Bill.type/Inv.maint. SD - Conditions
V_T043G -
DFKKCR - Repository For Checks  Contract Accounts Receivable and Payable
DPAYCHKNUM - Check Number Lot: Header  Contract Accounts Receivable and Payable


Gl account tables please click here

sdv sap fico notes: GL Account Tables in Sap: Gl Tables: SKA1:Gl account  at Chart of accounts level SKB1:GL account at Company code level SKAT:gL ACCOUNT description IN BOTH LEVE...

Gl Tables in sap,Gl Account Tables in Sap,What are the Imp Gl account Tables in sap,What are the Tables in Gl,What are the general ledger table names in sap,New Gl Account Tables in sap,Account tables in Sap,CO Tables in Sap

SKA1:Gl account  at Chart of accounts level

SKB1:GL account at Company code level

SKAT:gL ACCOUNT description IN BOTH LEVEL

BSIS:Gl open items

SKAS: Gl account description at key word list

BVOR:Inter Company Postings

VBKPF:Document Header parking
FAGLFLEXA General Ledger :Actual Line Items

FAGLFLEXT General Ledger :Totals

PLEASE CLICK HERE FOR APP Tables


LFA1:Vendor at chart of account level
LFB1:Vendor at company code level
BSIK: Vendor Open Items(invoice)
BSAK:Vendor payment (Cleard)
LFBK:Vendor master Bank Detalies
LFB5:Vendor Dunning Data
LFC1:Vendor Master Transaction Figures
LFC3:Vendor Master Special Gl  Transaction Figures
PAYR:Payment medium file
PCEC : Pre Number Checks(Check lots)

F111G:Global Settings: Payment Program for Payment Requests
FDZA:Cash Management line items in payment requests
PAYRQ:Payment Request.
REGUP:Processed items from payment program
REGUH:INFORMATION PAYMENT ITEMS



AR Tables:

What is the Diff Between The BSEG vs BKPF,RSEG VS RKPF,MSEG vs MKPF.The Major difference  BKPF vs BSEG

BKPF:Document header level at company code.
BSEG:Document Segment level


This two are mostly will be used in FICO.


RKPF:Document Header LEVEL: Reservation
RSEG:Document Item LEVEL:Incoming Invoice

This two are mostly in Procurement side


MKPF:
MSEG:

This two are also same for material

Asset Tables in Sap,Asst Accounting Entries in Sap,Fixed Asset Configuration in Sap,Asset end to end testing Documents In Sap,Asset AUC configuration Document in Sap

New GL in sap fico,What is New gl accounting in Sap,New gl in sap interview questions,New gl in sap fico pdf,New gl in sap ecc6,New general ledger sap advantages,New general ledger accounting sap,New gl accounting configuration in sap,Difference between gl and new gl in sap fico,New gl in sap,Allocations in sap new gl,New gl concept in sap,New gl tables in sap,New gl concept presentation slide in sap,Document splitting in sap new gl,How to create a new gl account in sap,what is the new gl in sap

What is New gl in sap:New gl is very high mode when compare to classic gl.

New gl purpose: New gl purpose is to record the business transaction in external posting internal posting level(FI,CO),To Generate the finical reports

Advantages:

New gl has many advantages when compare with classic gl

1.New gl have the fields more table level fields when compare with classic gl

2.We can generate the finical statements at individual level (Like a Customer ,vendor)

3.We can pull the gl balances each vendor wise and customer Wise to add the fields to the tables.

4.We can split the documents individually ,PROFIT CENTER WISE,SEGMENT WISE,

5.if the new gl activated then it's not required to perform the FI-CO reconciliations

Concepts:

Multiple Ledgers

Paralle  currency

Document spliting

Fi-co Recancilations

Segement Reporting.

For more about this please New gl concept