Guide for Testing SAP Financial
TESTING
Unit Testing
When you test every single document is called unit testing.
String Testing
One transaction full activity is called string testing . For example Vendor invoice, goods received and vendor payment.
Integration Testing
It is purely with other modules and we have to check whether the FI testing is working with other related modules or not.
Regression Testing
Testing for whole database. Bring all the data into another server and do the testing is called regression.
UAT
When we test any particular document with the user and if it is ok immediately we have to take the signature on the document, which is signed off and can be forwarded to the immediate boss. There are some steps to be followed when we go for user acceptance testing.
Transaction – Script Writing – Expected Results – Compare with Actual Results
TPR (Transaction Problem Reporting)
While doing the user acceptance testing if we get any problems then there are some methodologies to be followed according to the company’s policy and normally as a tester we always need to write on Test Script itself.
Key Features
Understanding the business scenarios
Organization Structure to incorporate the tune of the script.
Preparation of test scripts
Execute and record results to see if it is fine before going to approval.
Make changes to your test script if required.
What is Test Script (Scenario Testing)
Header Data
Step in Process
Transaction Code / Program (FB60)
Menu Path
Description
Field Data and actions to complete
Expected Results
Actual Results
TPR
Closing Period
F.19 Clearing GR/IR Account
F.13 Adjustments GR/IR Account
Using of these above two accounts will help us in clearing the balances and adjustments to those respective clearing accounts so that the GR/IR account will be zero balance and the balances will appear in respective reconciliation accounts accordingly the balances will be carried forwarded to next fiscal year.
GR/IR Clears the following Documents
GL Document
Customer Documents
Vendor Documents
Assignment Field is important in any document (ZUONR), Amount (DMBTR)
Foreign Currency Valuation
Lowest Value Method, If we are in loss then only we will account for it.
GL Accounts which are important in Testing
Enjoy Transaction - FB50
Normal Transaction - FB01
Document Parking - FV50
Post with Clearing - F-04
Incoming Payment - F-06
Outgoing Payment - F-07
Document Related
Reset Cleared Items - FBRA
Parking Document Posting - FBVO
Reversal Documents - F-14
Company Code Clearing A/C
(Trial Balance purposes) reversal - (FBUB)
Clearing Account
Partial clearing Invoice - 100 - Open Item
Paid - 70 - Open Item
Balance - 30
In Partial Clearing you can see 100 and 70 are cleared line items and 30 as balance and if it is in Residual you can only 30 as balance as it creates new line item and you can’t see the other cleared line items.
As no company will use residual clearing as it affects on ageing reports.
Open Items in Foreign Currency in all Modules GL/AP/AR - F.05
Master Data
Company Code
Currency
Only Balances in local currencies
Reconciliation Account Type
Year End Scripts
Re Grouping Receivables / Payables - (F101)
Bad Debts Provisions – Scripts
We assume that the customer has not paid at the end of the year you doubt whether this receivable will ever be paid. So you make a transfer posting for the receivables to an account for individual value adjustments using special GL Indicator E and Transaction Code F-21
Carry forward Balances
Sub Ledgers and General Ledger balances to be forwarded to next Fiscal Year
Accounts Payables
Vendor Down Payments
Invoice
Parking
Reversal
Outgoing Payments
Automatic Clearing
Manual Clearing
Advance (Down Payment)
Post with Clearing
Post without Clearing
Reset Clearing
Carry forward
Regrouping
Foreign Currency Valuations
Accounts Receivables
Customer Down Payments
Invoice
Parking
Reversal
Incoming Payments
Manual Clearing
Advance (Down Payment)
Post with Clearing
Post without Clearing
Reset Clearing
Carry forward
Regrouping
Foreign Currency Valuations
May 31, 2008
May 29, 2008
GL ACCOUNT TYPE
G/L NO.---------LONG TEXT-----------ACCOUNT GROUP------ACCOUNT TYPE-----RECON ACCOUNT
100001----------EQUITY CAPITAL------SHARE CAPTIAL------BALANCE SHEET----- NO
100401---------A/P DOMESTIC---------CURRENT LIABILITY----BS SHEET-----VENDOR
100402----------ACCUMULATED DEPRECIATION CURRENT LIABILITY---BS-----------ASSETS
200000-----------PLANT AND MACHINERY------
100001----------EQUITY CAPITAL------SHARE CAPTIAL------BALANCE SHEET----- NO
100401---------A/P DOMESTIC---------CURRENT LIABILITY----BS SHEET-----VENDOR
100402----------ACCUMULATED DEPRECIATION CURRENT LIABILITY---BS-----------ASSETS
200000-----------PLANT AND MACHINERY------
Account Group
ACCOUNT GROUP------DESCRIPTION----------FROM----------------TO
SCPL-----------SHARE CAPITAL-----------100000------------100100
RSPL----------RESERVES & SURPLUS------100100-------------100200
SCLN----------SECURED LOANS-----------100200-------------100300
UNSC----------UNSECURED LOANS---------100301-------------100400
CLPS----------CURRENT LIABILITIES-----100401-------------100500
FXAT----------FIXED ASSET-------------200000-------------200100
CAST----------CURRENT ASSETS----------200101-------------200200
LNAN----------LOANS AND ADV-----------200201-------------200300
SALE----------SALE REVENUE------------300000-------------300100
OTIN----------OTHER REVENUE-----------300101-------------300200
RMCN----------RAW MAT CONSUMPTION-----400000-------------400100
PERN----------PERSONAL COST-----------400100-------------400200
ADMN----------ADMIN COST--------------400201-------------400300
SEDN----------SELLING DISTRU----------400301-------------400400
DEPN----------DEPRECIATION------------400401-------------400500
SCPL-----------SHARE CAPITAL-----------100000------------100100
RSPL----------RESERVES & SURPLUS------100100-------------100200
SCLN----------SECURED LOANS-----------100200-------------100300
UNSC----------UNSECURED LOANS---------100301-------------100400
CLPS----------CURRENT LIABILITIES-----100401-------------100500
FXAT----------FIXED ASSET-------------200000-------------200100
CAST----------CURRENT ASSETS----------200101-------------200200
LNAN----------LOANS AND ADV-----------200201-------------200300
SALE----------SALE REVENUE------------300000-------------300100
OTIN----------OTHER REVENUE-----------300101-------------300200
RMCN----------RAW MAT CONSUMPTION-----400000-------------400100
PERN----------PERSONAL COST-----------400100-------------400200
ADMN----------ADMIN COST--------------400201-------------400300
SEDN----------SELLING DISTRU----------400301-------------400400
DEPN----------DEPRECIATION------------400401-------------400500
May 22, 2008
Validation GGB0
Validation are used to check setting and return a message if the prerequisite check condition is met you can used validation to supplement existing sap logic to fit you business needs a validation is a valuable tool that can be used in many of the financial and controlling modules.
Fi validation to fulfill our requirement of allowing posting from company code 1200 to be posted to only business area EES to maintain the validation.
Fi validation to fulfill our requirement of allowing posting from company code 1200 to be posted to only business area EES to maintain the validation.
May 20, 2008
Variant
A variant is a particular setting when we post any transcations some data input screen allow us to save and execute variant we can create variant is a good way to save time because we already put some data for this and next time we just execute this variant so no need to enter all data.
May 15, 2008
Depreciation
When you do a midyear takeover of assets, as opposed to a yearend
takeover, you'll need to handle
current year transactions in a special way in order to have
correct info on acquisition reports for both
book and tax purposes. Assets acquired in the current fiscal
year will require an acquisition transaction
to load them correctly.
*
Assets acquired before the current fiscal year
The AS91 transaction looks for three amount fields:
KANSW
Asset cost as of the end of the last fiscal
year
KNAFA
Accumulated depreciation balance as of the
end of the last FY
NAFAG
Depreciation expense posted this FY
*
Assets with a capitalization date in the current fiscal year
The AS91 transaction grays out the cost and accumulated depreciation
fields (KANSW) and (KNAFA) and requires
the following:
NAFAG
Depreciation expense posted this FY
BZDAT
Acquisition date
BWASL
Transaction type - default 100
ANBTR
Asset cost
*
Current year acquisitions to prior year assets
Create old asset the normal way and add the current year transaction.
KANSW
Asset cost as of the end of the last fiscal year
KNAFA
Accumulated depreciation balance as of the end
of the last FY
NAFAG
Depreciation expense posted this FY
BZDAT
Acquisition date of current year posting
BWASL
Transaction type - default 152
ANBTR
Cost of additional asset posting
*
Current year retirements of prior year assets
DEAKT
Asset deactivation date, which is the retirement
transaction date
KANSW
Asset cost as of the end of the last fiscal year
KNAFA
Accumulated depreciation balance as of the end
of the last FY
NAFAG
Depreciation expense posted this FY
BZDAT
Transaction date of current year retirement
BWASL
Transaction type - default 200
ANBTR
Retirement amount. Should be current month NBV
for area 01 and prior year NBV for the tax areas.
takeover, you'll need to handle
current year transactions in a special way in order to have
correct info on acquisition reports for both
book and tax purposes. Assets acquired in the current fiscal
year will require an acquisition transaction
to load them correctly.
*
Assets acquired before the current fiscal year
The AS91 transaction looks for three amount fields:
KANSW
Asset cost as of the end of the last fiscal
year
KNAFA
Accumulated depreciation balance as of the
end of the last FY
NAFAG
Depreciation expense posted this FY
*
Assets with a capitalization date in the current fiscal year
The AS91 transaction grays out the cost and accumulated depreciation
fields (KANSW) and (KNAFA) and requires
the following:
NAFAG
Depreciation expense posted this FY
BZDAT
Acquisition date
BWASL
Transaction type - default 100
ANBTR
Asset cost
*
Current year acquisitions to prior year assets
Create old asset the normal way and add the current year transaction.
KANSW
Asset cost as of the end of the last fiscal year
KNAFA
Accumulated depreciation balance as of the end
of the last FY
NAFAG
Depreciation expense posted this FY
BZDAT
Acquisition date of current year posting
BWASL
Transaction type - default 152
ANBTR
Cost of additional asset posting
*
Current year retirements of prior year assets
DEAKT
Asset deactivation date, which is the retirement
transaction date
KANSW
Asset cost as of the end of the last fiscal year
KNAFA
Accumulated depreciation balance as of the end
of the last FY
NAFAG
Depreciation expense posted this FY
BZDAT
Transaction date of current year retirement
BWASL
Transaction type - default 200
ANBTR
Retirement amount. Should be current month NBV
for area 01 and prior year NBV for the tax areas.
Important Enteris FI
Inventory Accounting Entries
For Example: during Goods Receipt
Stock Account - Dr
G/R I/R Account - Cr
Freight Clearing account - Cr
Other expenses payable - Cr
During Invoice Verification
G/R I/R Account - Dr
Vendor - Cr
When the Goods are issued to the Production Order the following transactions takes place:
Consumption of Raw Materials - Dr
Stock A/c - Cr
When the Goods are received from the Production Order the following transactions takes place:
Inventory A/c - Dr
Cost of Goods Produced - Cr
Price difference - Dr/Cr
(depending on the difference between standard cost and actual cost)
When the Goods are dispatched to customer through delivery the following transactions takes place:
Cost of Goods Sold - Dr
Inventory A/c - Cr
When the Goods are issued to a Cost Center or charged off against expenses the following transactions takes place:
Repairs and Maintenance - Dr
Inventory A/c - Cr
When the Goods are stock transferred from one plant to another, the following transactions takes place:
Stock A/c - Dr (Receiving location)
Stock A/c - Cr (Sending location)
Price difference - Dr/Cr
(due to any difference between the standard costs between the two locations)
When the stocks are revalued, the following transactions takes place:
Stock A/c - Dr/Cr
Inventory Revaluation A/c - Cr / Dr
When the Work in Progress is calculated the following transaction takes place:
Work in Progress A/c - Dr
Change WIP A/c - Cr
Physical verification /shortages and excesses : Shortages/excesses on authorizations shall be adjusted using the physical inventory count transaction.
For Example: during Goods Receipt
Stock Account - Dr
G/R I/R Account - Cr
Freight Clearing account - Cr
Other expenses payable - Cr
During Invoice Verification
G/R I/R Account - Dr
Vendor - Cr
When the Goods are issued to the Production Order the following transactions takes place:
Consumption of Raw Materials - Dr
Stock A/c - Cr
When the Goods are received from the Production Order the following transactions takes place:
Inventory A/c - Dr
Cost of Goods Produced - Cr
Price difference - Dr/Cr
(depending on the difference between standard cost and actual cost)
When the Goods are dispatched to customer through delivery the following transactions takes place:
Cost of Goods Sold - Dr
Inventory A/c - Cr
When the Goods are issued to a Cost Center or charged off against expenses the following transactions takes place:
Repairs and Maintenance - Dr
Inventory A/c - Cr
When the Goods are stock transferred from one plant to another, the following transactions takes place:
Stock A/c - Dr (Receiving location)
Stock A/c - Cr (Sending location)
Price difference - Dr/Cr
(due to any difference between the standard costs between the two locations)
When the stocks are revalued, the following transactions takes place:
Stock A/c - Dr/Cr
Inventory Revaluation A/c - Cr / Dr
When the Work in Progress is calculated the following transaction takes place:
Work in Progress A/c - Dr
Change WIP A/c - Cr
Physical verification /shortages and excesses : Shortages/excesses on authorizations shall be adjusted using the physical inventory count transaction.
SAP CO TABLE NAME
Table Name Description Important Fields
AUSP Characteristic Values MANDT / OBJEK / ATINN / ATZHL
CO-KBAS Overhead Cost Controlling
A132 Price per Cost Center MANDT / KAPPL / KSCHL / KOKRS
A136 Price per Controlling Area MANDT / KAPPL / KSCHL / KOKRS
A137 Price per Country / Region MANDT / KAPPL / KSCHL / KOKRS
COSC CO Objects: Assignment of Origina MANDT / OBJNR / SCTYP / VERSN
CSSK Cost Center / Cost Element MANDT / VERSN / KOKRS / GJAHR
CSSL Cost Center / Activity Type MANDT / KOKRS / KOSTL / LSTAR
KAPS CO Period Locks MANDT / KOKRS / GJAHR / VERSN
CO-KBASCORE Overhead Cost Controlling: General Services
CSKA Cost Elements (Data Dependent on MANDT / KTOPL / KSTAR
CSKB Cost Elements (Data Dependent on MANDT / KOKRS / KSTAR / DATBI
CSKS Cost Center Master Data MANDT / KOKRS / KOSTL / DATBI
CSLA Activity Master MANDT / KOKRS / LSTAR / DATBI
CO-OM (KACC) Overhead Cost Controlling
COBK CO Object: Document Header MANDT / KOKRS / BELNR
COEJ CO Object: Line Items (by Fiscal MANDT / KOKRS / BELNR / BUZEI
COEJL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEJR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEJT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI
COEP CO Object: Line Items (by Period) MANDT / KOKRS / BELNR / BUZEI
COEPL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEPR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEPT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI
COKA CO Object: Control Data for Cost MANDT / OBJNR / GJAHR / KSTAR
COKL CO Object: Control Data for Activ MANDT / LEDNR / OBJNR / GJAHR
COKP CO Object: Control Data for Prima MANDT / LEDNR / OBJNR / GJAHR
COKR CO Object: Control Data for Stati MANDT / LEDNR / OBJNR / GJAHR
COKS CO Object: Control Data for Secon MANDT / LEDNR / OBJNR / GJAHR
CO-OM-CEL (KKAL) Cost Element Accounting (Reconciliation Ledger)
COFI01 Object Table for Reconciliation L MANDT / OBJNR
COFI02 Transaction Dependent Fields for MANDT / OBJNR
COFIP Single Plan Items for Reconciliat RCLNT / GL_SIRID
COFIS Actual Line Items for Reconciliat RCLNT / GL_SIRID
CO-OM-CCA Cost Center Accounting (Cost Accounting Planning RK-S)
– What is RK-S
A138 Price per Company Code MANDT / KAPPL / KSCHL / KOKRS
A139 Price per Profit Center MANDT / KAPPL / KSCHL / KOKRS
CO-OM-OPA (KABR) Overhead Orders: Application Development R/3
Cost Accounting Settlement
AUAA Settlement Document: Receiver Seg MANDT / BELNR / LFDNR
AUAB Settlement Document: Distribution MANDT / BELNR / BUREG / LFDNR
AUAI Settlement Rules per Depreciation MANDT / BELNR / LFDNR / AFABE
AUAK Document Header for Settlement MANDT / BELNR
AUAO Document Segment: CO Objects to b MANDT / BELNR / LFDNR
AUAV Document Segment: Transactions MANDT / BELNR / LFDNR
COBRA Settlement Rule for Order Settlem MANDT / OBJNR
COBRB Distribution Rules Settlement Rul MANDT / OBJNR / BUREG / LFDNR
CO-OM-OPA (KAUF) Overhead Orders: Cost Accounting Orders
AUFK Order Master Data MANDT / AUFNR
AUFLAY0 Enttity Table: Order Layouts MANDT / LAYOUT
EC-PCA (KE1) Profit Center Accounting
CEPC Profit Center Master Data Table MANDT / PRCTR / DATBI / KOKRS
CEPCT Texts for Profit Center Master Da MANDT / SPRAS / PRCTR / DATBI
CEPC_BUKRS Assignment of Profit Center to a MANDT / KOKRS / PRCTR / BUKRS
GLPCA EC-PCA: Actual Line Items RCLNT / GL_SIRID
GLPCC EC-PCA: Transaction Attributes MANDT / OBJNR
GLPCO EC-PCA: Object Table for Account MANDT / OBJNR
GLPCP EC-PCA: Plan Line Items RCLNT / GL_SIRID
EC-PCA BS (KE1C) PCA Basic Settings: Customizing for
Profit Center Accounting
A141 Dependent on Material and Receive MANDT / KAPPL / KSCHL / KOKRS
A142 Dependent on Material MANDT / KAPPL / KSCHL / WERKS
A143 Dependent on Material Group MANDT / KAPPL / KSCHL / WERKS
AUSP Characteristic Values MANDT / OBJEK / ATINN / ATZHL
CO-KBAS Overhead Cost Controlling
A132 Price per Cost Center MANDT / KAPPL / KSCHL / KOKRS
A136 Price per Controlling Area MANDT / KAPPL / KSCHL / KOKRS
A137 Price per Country / Region MANDT / KAPPL / KSCHL / KOKRS
COSC CO Objects: Assignment of Origina MANDT / OBJNR / SCTYP / VERSN
CSSK Cost Center / Cost Element MANDT / VERSN / KOKRS / GJAHR
CSSL Cost Center / Activity Type MANDT / KOKRS / KOSTL / LSTAR
KAPS CO Period Locks MANDT / KOKRS / GJAHR / VERSN
CO-KBASCORE Overhead Cost Controlling: General Services
CSKA Cost Elements (Data Dependent on MANDT / KTOPL / KSTAR
CSKB Cost Elements (Data Dependent on MANDT / KOKRS / KSTAR / DATBI
CSKS Cost Center Master Data MANDT / KOKRS / KOSTL / DATBI
CSLA Activity Master MANDT / KOKRS / LSTAR / DATBI
CO-OM (KACC) Overhead Cost Controlling
COBK CO Object: Document Header MANDT / KOKRS / BELNR
COEJ CO Object: Line Items (by Fiscal MANDT / KOKRS / BELNR / BUZEI
COEJL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEJR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEJT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI
COEP CO Object: Line Items (by Period) MANDT / KOKRS / BELNR / BUZEI
COEPL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEPR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEPT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI
COKA CO Object: Control Data for Cost MANDT / OBJNR / GJAHR / KSTAR
COKL CO Object: Control Data for Activ MANDT / LEDNR / OBJNR / GJAHR
COKP CO Object: Control Data for Prima MANDT / LEDNR / OBJNR / GJAHR
COKR CO Object: Control Data for Stati MANDT / LEDNR / OBJNR / GJAHR
COKS CO Object: Control Data for Secon MANDT / LEDNR / OBJNR / GJAHR
CO-OM-CEL (KKAL) Cost Element Accounting (Reconciliation Ledger)
COFI01 Object Table for Reconciliation L MANDT / OBJNR
COFI02 Transaction Dependent Fields for MANDT / OBJNR
COFIP Single Plan Items for Reconciliat RCLNT / GL_SIRID
COFIS Actual Line Items for Reconciliat RCLNT / GL_SIRID
CO-OM-CCA Cost Center Accounting (Cost Accounting Planning RK-S)
– What is RK-S
A138 Price per Company Code MANDT / KAPPL / KSCHL / KOKRS
A139 Price per Profit Center MANDT / KAPPL / KSCHL / KOKRS
CO-OM-OPA (KABR) Overhead Orders: Application Development R/3
Cost Accounting Settlement
AUAA Settlement Document: Receiver Seg MANDT / BELNR / LFDNR
AUAB Settlement Document: Distribution MANDT / BELNR / BUREG / LFDNR
AUAI Settlement Rules per Depreciation MANDT / BELNR / LFDNR / AFABE
AUAK Document Header for Settlement MANDT / BELNR
AUAO Document Segment: CO Objects to b MANDT / BELNR / LFDNR
AUAV Document Segment: Transactions MANDT / BELNR / LFDNR
COBRA Settlement Rule for Order Settlem MANDT / OBJNR
COBRB Distribution Rules Settlement Rul MANDT / OBJNR / BUREG / LFDNR
CO-OM-OPA (KAUF) Overhead Orders: Cost Accounting Orders
AUFK Order Master Data MANDT / AUFNR
AUFLAY0 Enttity Table: Order Layouts MANDT / LAYOUT
EC-PCA (KE1) Profit Center Accounting
CEPC Profit Center Master Data Table MANDT / PRCTR / DATBI / KOKRS
CEPCT Texts for Profit Center Master Da MANDT / SPRAS / PRCTR / DATBI
CEPC_BUKRS Assignment of Profit Center to a MANDT / KOKRS / PRCTR / BUKRS
GLPCA EC-PCA: Actual Line Items RCLNT / GL_SIRID
GLPCC EC-PCA: Transaction Attributes MANDT / OBJNR
GLPCO EC-PCA: Object Table for Account MANDT / OBJNR
GLPCP EC-PCA: Plan Line Items RCLNT / GL_SIRID
EC-PCA BS (KE1C) PCA Basic Settings: Customizing for
Profit Center Accounting
A141 Dependent on Material and Receive MANDT / KAPPL / KSCHL / KOKRS
A142 Dependent on Material MANDT / KAPPL / KSCHL / WERKS
A143 Dependent on Material Group MANDT / KAPPL / KSCHL / WERKS
SAP FICO TABLE NAME
Table Name Description Important Fields
Financial Accounting
FBAS Financial Accounting “Basis”
BKPF Accounting Document Header BUKRS / BELNR / GJAHR
BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI
BSIP Index for Vendor Validation BUKRS / LIFNR / WAERS / BLDAT /
of Double Documents XBLNR / WRBTR / BELNR / GJAHR
/ BUZEI
BVOR Inter Company Posting BVORG / BUKRS / GJAHR / BELNR
Procedure
EBKPF Accounting Document Header GLSBK / BELNR / GJHAR / GLEBK
(docs from External Systems)
FRUN Run Date of a Program PRGID
KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP
/ VKULI / VBUKR / VKOAR
KNB4 Customer Payment History KUNNR / BUKRS
KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER
KNBK Customer Master Bank Details KUNNR / BANKS / BANKL / BANKN
KNC1 Customer Master Transaction KUNNR / BUKRS / GJHAR
Figures
KNC3 Customer Master Special KUNNR / BUKRS / GJAHR / SHBKZ
GL Transactions Figures
LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER
LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN
LFC1 Vendor Master Transaction LIFNR / BUKRS / GJHAR
Figures
LFC3 Vendor Master Special LIFNR / BUKRS / GJHAR / SHBKZ
GL Transactions Figures
VBKPF Document Header for AUSBK / BUKRS / BELNR / GJHAR
Document Parking
FBASCORE Financial Accounting General Services “Basis”
KNB1 Customer Master (Company Code) KUNNR / BUKRS
LFA1 Vendor Master (General Section) LIFNR
LFB1 Vendor Master (company Code Section) LIFNR / BUKRS
SKA1 G/L Account Master (Chart of Accounts) KTOPL / SAKNR
SKAT G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR
Description)
MAHNS Accounts Blocked by Dunning KOART / BUKRS / KONKO / MABER
Selection
MHNK Dunning Data LAUFD / LAUFI / KOART / BUKRS /
(Account Entries) KUNNR / LIFNR / CPDKY / SKNRZE /
SMABER / SMAHSK / BUSAB
FI-GL-GL (FBS) General Ledger Basic Functions-
G/L Accounts
SKAS G/L Account Master – SPRAS / KTOPL / SAKNR / SCHLW
(Chart of Accounts Key Word list)
SKB1 G/L Account Master (Company Code) BUKRS / SAKNR
FI-GL-GL (FBSC) General Ledger Accounting: Basic
Functions - R/3 Customizing for G/L Accounts
FIGLREP Settings for G/L Posting Reports MANDT
TSAKR Create G/L account with reference BUKRS / SAKNR
FI-GL-GL FFE) General Ledger Accounting: Basic
Functions - Fast Data Entry
KOMU Account Assignment Templates for G/L KMNAM / KMZEI
Account items
FI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers
KNKA Customer Master Credit Management : KUNNR
Central Data
KNKK Customer Master Credit Management : KUNNR / KKBER
Control Area Data
KNKKF1 Credit Management : LOGSYS / KUNNR / KKBER / REGUL
FI Status data
RFRR Accounting Data – A/R and A/P RELID / SRTFD / SRTF2
Information System
FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D)
Transactions – General Sections
PAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /
CHECT
PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPL
FI-BL-PT-AP(FMZA)Bank Accounting: Payment
Transactions – Automatic Payments
F111G Global Settings for Payment Program for MANDT
Payment Requests
FDZA Cash Management Line Items in Payment KEYNO
Requests
PAYRQ Payment Requests KEYNO
What is the table name for G/L Master data, when we create
centrally (T.Code - FS00)?
As far as general ledger master data is concerned, the following tables are involved :
Table name : SKB1 : G/L Account Master ( Company Code)
Fields:
BUKRS : Company Code
SAKNR : G/L Account
Table name : SKA1 : G/L Account Master ( Chart of Accounts )
Fields:
KTOPL : Char of Accounts
SAKNR : G/L Account
Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )
Fields:
SPRAS : Language
KTOPL : Char of Accounts
SAKNR : G/L Account
Financial Accounting
FBAS Financial Accounting “Basis”
BKPF Accounting Document Header BUKRS / BELNR / GJAHR
BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI
BSIP Index for Vendor Validation BUKRS / LIFNR / WAERS / BLDAT /
of Double Documents XBLNR / WRBTR / BELNR / GJAHR
/ BUZEI
BVOR Inter Company Posting BVORG / BUKRS / GJAHR / BELNR
Procedure
EBKPF Accounting Document Header GLSBK / BELNR / GJHAR / GLEBK
(docs from External Systems)
FRUN Run Date of a Program PRGID
KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP
/ VKULI / VBUKR / VKOAR
KNB4 Customer Payment History KUNNR / BUKRS
KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER
KNBK Customer Master Bank Details KUNNR / BANKS / BANKL / BANKN
KNC1 Customer Master Transaction KUNNR / BUKRS / GJHAR
Figures
KNC3 Customer Master Special KUNNR / BUKRS / GJAHR / SHBKZ
GL Transactions Figures
LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER
LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN
LFC1 Vendor Master Transaction LIFNR / BUKRS / GJHAR
Figures
LFC3 Vendor Master Special LIFNR / BUKRS / GJHAR / SHBKZ
GL Transactions Figures
VBKPF Document Header for AUSBK / BUKRS / BELNR / GJHAR
Document Parking
FBASCORE Financial Accounting General Services “Basis”
KNB1 Customer Master (Company Code) KUNNR / BUKRS
LFA1 Vendor Master (General Section) LIFNR
LFB1 Vendor Master (company Code Section) LIFNR / BUKRS
SKA1 G/L Account Master (Chart of Accounts) KTOPL / SAKNR
SKAT G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR
Description)
MAHNS Accounts Blocked by Dunning KOART / BUKRS / KONKO / MABER
Selection
MHNK Dunning Data LAUFD / LAUFI / KOART / BUKRS /
(Account Entries) KUNNR / LIFNR / CPDKY / SKNRZE /
SMABER / SMAHSK / BUSAB
FI-GL-GL (FBS) General Ledger Basic Functions-
G/L Accounts
SKAS G/L Account Master – SPRAS / KTOPL / SAKNR / SCHLW
(Chart of Accounts Key Word list)
SKB1 G/L Account Master (Company Code) BUKRS / SAKNR
FI-GL-GL (FBSC) General Ledger Accounting: Basic
Functions - R/3 Customizing for G/L Accounts
FIGLREP Settings for G/L Posting Reports MANDT
TSAKR Create G/L account with reference BUKRS / SAKNR
FI-GL-GL FFE) General Ledger Accounting: Basic
Functions - Fast Data Entry
KOMU Account Assignment Templates for G/L KMNAM / KMZEI
Account items
FI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers
KNKA Customer Master Credit Management : KUNNR
Central Data
KNKK Customer Master Credit Management : KUNNR / KKBER
Control Area Data
KNKKF1 Credit Management : LOGSYS / KUNNR / KKBER / REGUL
FI Status data
RFRR Accounting Data – A/R and A/P RELID / SRTFD / SRTF2
Information System
FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D)
Transactions – General Sections
PAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /
CHECT
PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPL
FI-BL-PT-AP(FMZA)Bank Accounting: Payment
Transactions – Automatic Payments
F111G Global Settings for Payment Program for MANDT
Payment Requests
FDZA Cash Management Line Items in Payment KEYNO
Requests
PAYRQ Payment Requests KEYNO
What is the table name for G/L Master data, when we create
centrally (T.Code - FS00)?
As far as general ledger master data is concerned, the following tables are involved :
Table name : SKB1 : G/L Account Master ( Company Code)
Fields:
BUKRS : Company Code
SAKNR : G/L Account
Table name : SKA1 : G/L Account Master ( Chart of Accounts )
Fields:
KTOPL : Char of Accounts
SAKNR : G/L Account
Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )
Fields:
SPRAS : Language
KTOPL : Char of Accounts
SAKNR : G/L Account
May 11, 2008
Closing Activities
A) Month end year end closing processes
pre closing activities takes place in old month at month end level include
a)open new accounting period technical
b)Enter accrual/deferral bad debets depreciation, interest calculation fi
c)maintain GR/IR account clearing -mm
d)post payroll process HR
e)record goods issues for deliveries and invoice customers SD
f) co allocation and reposting locking old accounting period co
g)reconcilation posting to fi -co
h) foreign currency valuation
i) final closing of old period
in addition to pre closing activities at month end level following activitie are performed for year end closing
a) perform physical inventory-- MM
b)update product cost estimates pp/Co
c)valuation of materials on fifo/lifo -MM
d)assets valuation and investment support-AA
e)balance confirmation -a/p,Ar
f)fiscal year change AA
g)balance carried forward program-fi
pre closing activities takes place in old month at month end level include
a)open new accounting period technical
b)Enter accrual/deferral bad debets depreciation, interest calculation fi
c)maintain GR/IR account clearing -mm
d)post payroll process HR
e)record goods issues for deliveries and invoice customers SD
f) co allocation and reposting locking old accounting period co
g)reconcilation posting to fi -co
h) foreign currency valuation
i) final closing of old period
in addition to pre closing activities at month end level following activitie are performed for year end closing
a) perform physical inventory-- MM
b)update product cost estimates pp/Co
c)valuation of materials on fifo/lifo -MM
d)assets valuation and investment support-AA
e)balance confirmation -a/p,Ar
f)fiscal year change AA
g)balance carried forward program-fi
May 9, 2008
Dunning
SAP FICO WHAT IS DUNNING
Dunning is kind of reminder we mostly send to our customers and some time vendors as well to collect our bills and invoice on time its is statement which showing how much amount is due.
When we sending notice to our customers about payments due we define dunning level which level is best for that customer we can define 1 to 9 levels and final levels is kind of legal notice we sending to customers about his due amounts.
As dunning level getting higher the content of letter is changed.
Dunning configuration steps
1-Define Dunning Area
2-Define Dunning Key
3-Define Dunning Block Reasons
4-Define Dunning Procedures Tcode FBMP
Dunning procedure
a)Define dunning interval reminder may be weekly, fornightly,monthly etc.
b)Define no. of days is arrears after which dunning notice will be sent
c)grace period per line item
d)interest calculation indicator for calculation of dunning interest
e)dunning key for dunning procedure.
Dunning levels
a)the first dunning level included the line item grace period
b)if option always dun selected the dunning notice will still printed even not change have been made in account
c) in dunning notice total account balance or item wise details can be print
Expenses/Changes
a)dunning charges may be depending on dunning level
b)dunning charges is either fixed for percentage of amount dunned
c)you can either choose fixed or precentage of amount dunned
d)dunning charges are define for currency wise
Minimum amount or percentage must be specifying for dunning notice the dunning notice will not generate until overdue item reached up to dunning level.
Minimum amount can also be fixed for calculating interest on dunning amount
dunning text must be defined according to the dunning level
predefined form of dunning text is available in sap
dunning program can generate payment advice note dunning notice and payment form
Environment
a) company code
b)short field
s)sender details
d)dunning areas
e)dunning key
f)dunning block reason
g)interest
h)dunning grouping
Running of dunning program
enter parameters
a) run date
b)identification
c)selection of company codes may be single company or no of companies
d)range of customer/vendor account
e)document define up to which posting date include in dunning run
Dunning run
Dunning is kind of reminder we mostly send to our customers and some time vendors as well to collect our bills and invoice on time its is statement which showing how much amount is due.
When we sending notice to our customers about payments due we define dunning level which level is best for that customer we can define 1 to 9 levels and final levels is kind of legal notice we sending to customers about his due amounts.
As dunning level getting higher the content of letter is changed.
Dunning configuration steps
1-Define Dunning Area
2-Define Dunning Key
3-Define Dunning Block Reasons
4-Define Dunning Procedures Tcode FBMP
Dunning procedure
a)Define dunning interval reminder may be weekly, fornightly,monthly etc.
b)Define no. of days is arrears after which dunning notice will be sent
c)grace period per line item
d)interest calculation indicator for calculation of dunning interest
e)dunning key for dunning procedure.
Dunning levels
a)the first dunning level included the line item grace period
b)if option always dun selected the dunning notice will still printed even not change have been made in account
c) in dunning notice total account balance or item wise details can be print
Expenses/Changes
a)dunning charges may be depending on dunning level
b)dunning charges is either fixed for percentage of amount dunned
c)you can either choose fixed or precentage of amount dunned
d)dunning charges are define for currency wise
Minimum amount or percentage must be specifying for dunning notice the dunning notice will not generate until overdue item reached up to dunning level.
Minimum amount can also be fixed for calculating interest on dunning amount
dunning text must be defined according to the dunning level
predefined form of dunning text is available in sap
dunning program can generate payment advice note dunning notice and payment form
Environment
a) company code
b)short field
s)sender details
d)dunning areas
e)dunning key
f)dunning block reason
g)interest
h)dunning grouping
Running of dunning program
enter parameters
a) run date
b)identification
c)selection of company codes may be single company or no of companies
d)range of customer/vendor account
e)document define up to which posting date include in dunning run
Dunning run
May 8, 2008
Automatic Payments APP
SAP FI moudule we used automatic payment program.
APP we can used different payment methods such as check,transfers in printing a check or a electronic form
Account payable payment process
Create a financial accounting document to record the transaction it determines the following
Open items to be paid
when open items will be paid
bank from which payment will be made
payment medium to be used
to whom the payment will be made
Some tcode we used in automatic payment program
maintain paymet programm tcode-fbzp
setup all company code tcode-obvu
payment method country tcode-obvcu
define house bank tcode-fi12
Automatic payment configuration steps
------------------------------------
step 1
All company code:
a)inter company payment relationships
b) company code that process the payment
c)cash discount amount or percentage
d)tolerance days for payments
step -2
Paying company code
a)Minimum amount for incoming and outgoing payment
b)bills of exchange specification
c)Forms for payment advice EDI (payment advice format)
step-3
Payment methods/Country
a)payment methods eg. check bank transfer,bills of exchange
b)master record requirements address etc.
c)document type for posting
d) currencies if not set valid for all currencies
step -4
Payment method company code
a)Minimum and maximum payment amount
b)forign payment and foreign currencies allowed
d) postal code optimization
step -5
Bank selection
a)ranking if define the order of the various bank for payments
b)Amount- if define the available amount in bank account for payment
c)accounts
d) expenses/charges if any charges or amount short received the system post the amount in clearing account in case of outgoing payment and subtracts from incoming payment in case of payment received.
e)value date this is used for cash management if specify in how many days.
step 6
Maintain parameters (running payment program)
a)run date
b)identification
c)open item selection it defines that documents entered up to this date include in payment run
d)posting date this is the date on which general ledger is updated this is the default date from run date
e)company code selection maybe one company code or multiple company code in case of multiple company code,comma should be used between two company codes
Proposal Run
On the basis of parameters system run the proposal and if it found any incorrect in payment methods,bank data, payment block it adds these item exception list
On completion of proposal run system create two reports payment proposal list and exception list
Payment Block may configure in following ways
a) While invoice verification process
b)In Master records
c) During entering of account payable invoice
Editing Payment proposal
While editing the payment proposal a user can change the payment terms,
block of payment or remove the block
Start payment run
In this step we locked all the selected items for payment proposal for further posting updated the gl accounts and sub ledger accounts and clear open item.
Debit balance check if debit balance check carry out then transaction in exception list
I hope you will learn app
Syed Muzaffar
APP we can used different payment methods such as check,transfers in printing a check or a electronic form
Account payable payment process
Create a financial accounting document to record the transaction it determines the following
Open items to be paid
when open items will be paid
bank from which payment will be made
payment medium to be used
to whom the payment will be made
Some tcode we used in automatic payment program
maintain paymet programm tcode-fbzp
setup all company code tcode-obvu
payment method country tcode-obvcu
define house bank tcode-fi12
Automatic payment configuration steps
------------------------------------
step 1
All company code:
a)inter company payment relationships
b) company code that process the payment
c)cash discount amount or percentage
d)tolerance days for payments
step -2
Paying company code
a)Minimum amount for incoming and outgoing payment
b)bills of exchange specification
c)Forms for payment advice EDI (payment advice format)
step-3
Payment methods/Country
a)payment methods eg. check bank transfer,bills of exchange
b)master record requirements address etc.
c)document type for posting
d) currencies if not set valid for all currencies
step -4
Payment method company code
a)Minimum and maximum payment amount
b)forign payment and foreign currencies allowed
d) postal code optimization
step -5
Bank selection
a)ranking if define the order of the various bank for payments
b)Amount- if define the available amount in bank account for payment
c)accounts
d) expenses/charges if any charges or amount short received the system post the amount in clearing account in case of outgoing payment and subtracts from incoming payment in case of payment received.
e)value date this is used for cash management if specify in how many days.
step 6
Maintain parameters (running payment program)
a)run date
b)identification
c)open item selection it defines that documents entered up to this date include in payment run
d)posting date this is the date on which general ledger is updated this is the default date from run date
e)company code selection maybe one company code or multiple company code in case of multiple company code,comma should be used between two company codes
Proposal Run
On the basis of parameters system run the proposal and if it found any incorrect in payment methods,bank data, payment block it adds these item exception list
On completion of proposal run system create two reports payment proposal list and exception list
Payment Block may configure in following ways
a) While invoice verification process
b)In Master records
c) During entering of account payable invoice
Editing Payment proposal
While editing the payment proposal a user can change the payment terms,
block of payment or remove the block
Start payment run
In this step we locked all the selected items for payment proposal for further posting updated the gl accounts and sub ledger accounts and clear open item.
Debit balance check if debit balance check carry out then transaction in exception list
I hope you will learn app
Syed Muzaffar
Account Payable
Sap Financial accounting system Account payable
Account payable A/P, is sub ledger in Sap Fico and its used for vendor transctions and each transction create a documents with unique documents nos for audit trails purpose.
Step 1
Creation of vendor group
Menupath
Financial accounting-----–>account receivable and payble --->vendor accounts ---------master data---------->preparation -------->define accounts vendors
Assign nos rangs to vender accounts group
Financial accounting------->account receivable and payable ---master data-----preparation----assign nos ranges
Creation of vendor master data
Tcdoe FK01
Vendor Invoce posting TCODE FB60
vendor document type
Kr vendor invoice
KZ Vendor Payment
Posting key
Vendor debit 40
vendor credit 31
Menu path for account payable
SPRO--IMG--->accounting--->finanical accounting----->account payable---document entry account.
We can not post account payable transtions at fb50 tcode we have to post in specific vendor account and using vendor posting key
Vendor debit 40
vendor credit 31
We can post vendor invoice with purchase order and without purchase order
when invoice is posted MM material master record and PO History updated
Payable are paid by Automatic payment program APP
I cover in Next topic ....Automatic payment
Account payable A/P, is sub ledger in Sap Fico and its used for vendor transctions and each transction create a documents with unique documents nos for audit trails purpose.
Step 1
Creation of vendor group
Menupath
Financial accounting-----–>account receivable and payble --->vendor accounts ---------master data---------->preparation -------->define accounts vendors
Assign nos rangs to vender accounts group
Financial accounting------->account receivable and payable ---master data-----preparation----assign nos ranges
Creation of vendor master data
Tcdoe FK01
Vendor Invoce posting TCODE FB60
vendor document type
Kr vendor invoice
KZ Vendor Payment
Posting key
Vendor debit 40
vendor credit 31
Menu path for account payable
SPRO--IMG--->accounting--->finanical accounting----->account payable---document entry account.
We can not post account payable transtions at fb50 tcode we have to post in specific vendor account and using vendor posting key
Vendor debit 40
vendor credit 31
We can post vendor invoice with purchase order and without purchase order
when invoice is posted MM material master record and PO History updated
Payable are paid by Automatic payment program APP
I cover in Next topic ....Automatic payment
May 7, 2008
Lockbox
SAP Lockbox Process with Screen shot
Lockbox setting Segments
Define Lockbox
Define Control Parameters
Define Postind Data
tcode-ob10
tcode-obax
Q&A
What file used in Lockbox file extentions
Answrs is BAI or BAI2
Menu Paht
SPRO---->FININCIAL ACCOUNTING--->BANK ACCOUNTING--->BANK ACCOUNT-->DEFINE LOCKBOX FOR HOUSE BANK
Define control parameters
Menu path
spro-->financial accounting-->bank accounting--->business transactions--->payment transaction--->lockbox--->define control paramenters.
Define posting Data
Menu Path IMG
spro-->financial accounting-->bank accounting--->business transactions--->payment transaction--->lockbox--->define posting data
FBL1 UPLOAD LOCKBOX FILE DATA
FBL2 POSTING PRCOESSING OF LOCKBOX DATA
Lockbox setting Segments
Define Lockbox
Define Control Parameters
Define Postind Data
tcode-ob10
tcode-obax
Q&A
What file used in Lockbox file extentions
Answrs is BAI or BAI2
Menu Paht
SPRO---->FININCIAL ACCOUNTING--->BANK ACCOUNTING--->BANK ACCOUNT-->DEFINE LOCKBOX FOR HOUSE BANK
Define control parameters
Menu path
spro-->financial accounting-->bank accounting--->business transactions--->payment transaction--->lockbox--->define control paramenters.
Define posting Data
Menu Path IMG
spro-->financial accounting-->bank accounting--->business transactions--->payment transaction--->lockbox--->define posting data
FBL1 UPLOAD LOCKBOX FILE DATA
FBL2 POSTING PRCOESSING OF LOCKBOX DATA
House Bank
SAP FICO MODULE WHAT IS HOUSE BANK
House Bank Tcode FI12 Bank Directory
Question
1--What is House bank......?
Answers
House bank we call all accounts that belong to company. A house bank refers to the bank a company uses for receivables and/or payments. It is any bank with which your company code does business. Each house bank contains a company’s bank accounts. It also contains a bank key that defines address and control data for the bank. The house bank establishes a link between the various G/L cash accounts and the actual bank accounts.
2---What is bank directory.....?
Automatically, if master data exists for the Bank Directory on tape or disk. ). Data can also be manually entered when creating a customer or vendor master record, a one-time account, or by directly creating an account.
a---Bank Directory contain
a---Bank Directory contains complete details about each house bank.
3--where are bank master records created in SAP...?
Unlike customer, and vendor master records, the bank master records may be maintained on the configuration side in SAP. They are also created on the application side in the Banking and Treasury sections.
Bank configuration steps screen shot
House Bank Tcode FI12 Bank Directory
Question
1--What is House bank......?
Answers
House bank we call all accounts that belong to company. A house bank refers to the bank a company uses for receivables and/or payments. It is any bank with which your company code does business. Each house bank contains a company’s bank accounts. It also contains a bank key that defines address and control data for the bank. The house bank establishes a link between the various G/L cash accounts and the actual bank accounts.
2---What is bank directory.....?
Automatically, if master data exists for the Bank Directory on tape or disk. ). Data can also be manually entered when creating a customer or vendor master record, a one-time account, or by directly creating an account.
a---Bank Directory contain
a---Bank Directory contains complete details about each house bank.
3--where are bank master records created in SAP...?
Unlike customer, and vendor master records, the bank master records may be maintained on the configuration side in SAP. They are also created on the application side in the Banking and Treasury sections.
Bank configuration steps screen shot
May 5, 2008
Customer Master Record
ALL ABOUT CUSTOMER MASTER DATA RECORDS
Transctions code related to Customer accounts
Create customer master records TCODE FD01
Change customer master records TCODE FD02
Display customer master records Tcode fd03
Block/unblock customer master Tcode FD05
Mark customer master records for deletion fd06
Questions.
What is customer data record Segments.
Answers.
Customer master record has three segments
In General Data Account Name, Address
In Company code level payment terms
In Sales Data Shipping information, billing information
Customer master Data record in two levels
1- Client Level : Data at this level pertain to all companies in that client can open
2- Company Code Level Company specific data is entered at this level is for specific company.
Account receiveable is customer account in sap its a sub ledger accounts recon account and we cant post directly thought enjoy posting fb50,
Questions
How to prevent Duplicates of customer master records
Answers
Check for duplicates can be configured to prevent the creation of more then one master record for the same customers.
This check configured on address match when create new customer records.
Menu Path IMG SPRO-->Logistics -->Sales and Distribution---> Master Data---> Business Partner-----> Customer----> Create---> Complete
tcode is xd01 Create customer master record
Display xd03 display customer list
tcode FD32 customer credit management master record
Qustions
What is Payment terms
answers
Payments terms In payment terms define incentive which company give to there customers to pay invoice early and get some discounts and when due date is calculated to calculate due date we used baseline.
Baseline date is date when payment begin calculate from
Transctions code related to Customer accounts
Create customer master records TCODE FD01
Change customer master records TCODE FD02
Display customer master records Tcode fd03
Block/unblock customer master Tcode FD05
Mark customer master records for deletion fd06
Questions.
What is customer data record Segments.
Answers.
Customer master record has three segments
In General Data Account Name, Address
In Company code level payment terms
In Sales Data Shipping information, billing information
Customer master Data record in two levels
1- Client Level : Data at this level pertain to all companies in that client can open
2- Company Code Level Company specific data is entered at this level is for specific company.
Account receiveable is customer account in sap its a sub ledger accounts recon account and we cant post directly thought enjoy posting fb50,
Questions
How to prevent Duplicates of customer master records
Answers
Check for duplicates can be configured to prevent the creation of more then one master record for the same customers.
This check configured on address match when create new customer records.
Menu Path IMG SPRO-->Logistics -->Sales and Distribution---> Master Data---> Business Partner-----> Customer----> Create---> Complete
tcode is xd01 Create customer master record
Display xd03 display customer list
tcode FD32 customer credit management master record
Qustions
What is Payment terms
answers
Payments terms In payment terms define incentive which company give to there customers to pay invoice early and get some discounts and when due date is calculated to calculate due date we used baseline.
Baseline date is date when payment begin calculate from
May 4, 2008
Open Item Management
Q&A
What is open item managements
Answers
Open item management account is a offsetting accounts which can be settled automatically by manually
we can used for cheque clearing account when our cheque is debits from our account the open item clear account balance is zero GR & IR account is an example of an account that should be managed on an open item basis.
If I am not correct please correct me thanks
syed
What is open item managements
Answers
Open item management account is a offsetting accounts which can be settled automatically by manually
we can used for cheque clearing account when our cheque is debits from our account the open item clear account balance is zero GR & IR account is an example of an account that should be managed on an open item basis.
If I am not correct please correct me thanks
syed
Chart of Account COA
Q&A About SAP FI Chart of Account COA
Q&A
How many chart of account we can used for one company code
Three type of Chat of account we can used for one company code
1-Operation Chart of account
2-Country chart of account
3-Group chart of account we can used in company code
1-operational chat of account is record you daily transactions
2-country chart of account is used for country specific requirement
3-Group chart of account is used when we have two or many legal entities I mean company code and we need consolidation report of all companies combine report.
Company can share chart of accounts
and GL accounts as well if we create gl account at chart of account level we can create gl account at two levels in SAP FI Module we can create chart of account COA, Level then other companies can share gl accounts if they using the same chart of accounts but if we crate gl account at company code level we can used this gl accounts only for that company code where we created
What is Chart of accounts.
Chart of account is list of GL accounts, and creat at client level one client can have many chart of accounts, but one company can have only one operational chart of accounts.
COA segment contains information such as the Account Number, Account Name, and Account Group
Q&A
How many chart of account we can used for one company code
Three type of Chat of account we can used for one company code
1-Operation Chart of account
2-Country chart of account
3-Group chart of account we can used in company code
1-operational chat of account is record you daily transactions
2-country chart of account is used for country specific requirement
3-Group chart of account is used when we have two or many legal entities I mean company code and we need consolidation report of all companies combine report.
Company can share chart of accounts
and GL accounts as well if we create gl account at chart of account level we can create gl account at two levels in SAP FI Module we can create chart of account COA, Level then other companies can share gl accounts if they using the same chart of accounts but if we crate gl account at company code level we can used this gl accounts only for that company code where we created
What is Chart of accounts.
Chart of account is list of GL accounts, and creat at client level one client can have many chart of accounts, but one company can have only one operational chart of accounts.
COA segment contains information such as the Account Number, Account Name, and Account Group
May 3, 2008
Organizational Hierarchy
Major Organizational Hierarchy
The hierarchy, from the highest organizational unit to the lowest, is the
Client,
Chart of Accounts (COA),
Company Code
and the optional Business Areas (BA).
Two other optional areas include the Dunning Area and the Credit Control Area
(CCA). Credit Control Areas come above the Company Code, and Dunning Areas come below the Company Code.
There is only one Client and its values are the same across all Company Codes that are attached to it. Every Company Code is a legal independent entity. Business Areas can be shared among Company Codes (many-to-many relationship) and they are used for internal reporting purposes. Each Company Code is assigned a COA. The COA may be the same for multiple Company Codes, but each Company Code may only use one COA.
The hierarchy, from the highest organizational unit to the lowest, is the
Client,
Chart of Accounts (COA),
Company Code
and the optional Business Areas (BA).
Two other optional areas include the Dunning Area and the Credit Control Area
(CCA). Credit Control Areas come above the Company Code, and Dunning Areas come below the Company Code.
There is only one Client and its values are the same across all Company Codes that are attached to it. Every Company Code is a legal independent entity. Business Areas can be shared among Company Codes (many-to-many relationship) and they are used for internal reporting purposes. Each Company Code is assigned a COA. The COA may be the same for multiple Company Codes, but each Company Code may only use one COA.
Sap Conf & Org Struct
Sap Configuration and Application
Questions Give examples of activities performed on the configuration side in SAP? On the application side in SAP?
Answer
Configuration:
• Create Organizational structures
• Define foreign currencies
• Define financial statements
• Outline Credit Management functionality
Application:
• Post Accounting transactions
• Post Customer Invoice
• Post Vendor Invoice
• Create Master records
• Process financial statements
• Display accounting documents
Questions Give examples of activities performed on the configuration side in SAP? On the application side in SAP?
Answer
Configuration:
• Create Organizational structures
• Define foreign currencies
• Define financial statements
• Outline Credit Management functionality
Application:
• Post Accounting transactions
• Post Customer Invoice
• Post Vendor Invoice
• Create Master records
• Process financial statements
• Display accounting documents
Interview Q&A
SAP FICO Interview Questions
What is Client and Company code relation...
Answers
The Client is the highest level in the SAP organizational structure. Anything specified for a Client applies to all Company Codes that are attached to that Client. Clients have a one-to-many relationship with Company Codes. Clients are generally not reported on with balance sheet and P&L’s, the company codes are the legal entities and serve for this purpose. However, clients can be reported on as part of consolidation or extended G/L.
Questions
Major organizational hierarchy elements
Answer
The hierarchy, from the highest organizational unit to the lowest, is the
Client,
Chart of Accounts (COA),
Company Code
and the optional Business Areas (BA).
Two other optional areas include the Dunning Area and the Credit Control Area
(CCA). Credit Control Areas come above the Company Code, and Dunning Areas come below the Company Code.
There is only one Client and its values are the same across all Company Codes that are attached to it. Every Company Code is a legal independent entity. Business Areas can be shared among Company Codes (many-to-many relationship) and they are used for internal reporting purposes. Each Company Code is assigned a COA. The COA may be the same for multiple Company Codes, but each Company Code may only use one COA.
Question
What is the correction and transport system? Who operates this system?
Answers
Transport request tcode se01,T-code STMS ,se09
------------------
The Correction and Transport System provides a method to move configuration and program code from system to system or Client to Client. It would be used to move customized data from a development system to a test system, and then to a production system.
The Correction and Transport System is usually operated by the System Administrator.
You have the option to search with - User range , request range & date range. There are other selection criteria too if you want Here you can find ANY request ( prod, testing, devlp) - whether released or modifiable.
you can see list of old trans requests tcode SE01
Workbench transport request se09
For customising transport request tcode se10
Questions
What is organizational structure?
Answers
Company code
controlling area
buiness area
functional area
Credit control area
Sap structure levels
Client level ---Chart of accounts,controlling area,business area,
One clint can have many company code, controlling area.
But one Company code can not have many client,or many controlling area,
company code level gl accounts,vendor,customers for master data
company code is legal entity... reporting to external auditors...income tax dept..
business area is uses for internal report
Question
Who is usually responsible for establishing the organizational structure on an implementation
Answers
FI/CO Team
Question : What are the tables that are configured under global settings?
Answers : Calendar, Units of Measure, Country Table, and Currency & Exchange Rate Table
Questions :-Cash Management is a sub-module of which module..?
Answers :Treasury module
Questions :Can depreciation be processed from Asset Accounting sub-module directly to the FI and CO Modules?
Answers : YES
Question:What are the two major areas within the SAP environment? Describe each.
Answers : Configuration - Maintenance of settings in the system to support customized business requirements of the client.
&
Application - On going processes required to record and report business activity
Questions: What are the two methods available for accessing the configuration functions in FI? Describe each.
Answers :Implementation Guide (IMG) - leads you through the steps required for configuration in an implementation.
Transaction codes - takes you directly to the first screen of a transaction without the use of the IMG or menu paths
Questions
What is in Account Management....?
Answers
Open Item Management
Line Item Display
Sort Key
Questions:What are the four configuration areas of the IMG? Describe each.
Anwers :
General Settings - non-application dependent specifications
Enterprise Structure - definition of organizational units and their relationships
Cross-applications component
Functional Areas (e.g., Financial Accounting, Sales and Distribution)
Question
What is the highest level of information in SAP? Where is this configured?
Answers
General Settings, which is configured in the IMG
Questions
What is simple accounts
Anwers
A sample account kind of template that can be used to create GL accounts is not actual account in GL.
What is Client and Company code relation...
Answers
The Client is the highest level in the SAP organizational structure. Anything specified for a Client applies to all Company Codes that are attached to that Client. Clients have a one-to-many relationship with Company Codes. Clients are generally not reported on with balance sheet and P&L’s, the company codes are the legal entities and serve for this purpose. However, clients can be reported on as part of consolidation or extended G/L.
Questions
Major organizational hierarchy elements
Answer
The hierarchy, from the highest organizational unit to the lowest, is the
Client,
Chart of Accounts (COA),
Company Code
and the optional Business Areas (BA).
Two other optional areas include the Dunning Area and the Credit Control Area
(CCA). Credit Control Areas come above the Company Code, and Dunning Areas come below the Company Code.
There is only one Client and its values are the same across all Company Codes that are attached to it. Every Company Code is a legal independent entity. Business Areas can be shared among Company Codes (many-to-many relationship) and they are used for internal reporting purposes. Each Company Code is assigned a COA. The COA may be the same for multiple Company Codes, but each Company Code may only use one COA.
Question
What is the correction and transport system? Who operates this system?
Answers
Transport request tcode se01,T-code STMS ,se09
------------------
The Correction and Transport System provides a method to move configuration and program code from system to system or Client to Client. It would be used to move customized data from a development system to a test system, and then to a production system.
The Correction and Transport System is usually operated by the System Administrator.
You have the option to search with - User range , request range & date range. There are other selection criteria too if you want Here you can find ANY request ( prod, testing, devlp) - whether released or modifiable.
you can see list of old trans requests tcode SE01
Workbench transport request se09
For customising transport request tcode se10
Questions
What is organizational structure?
Answers
Company code
controlling area
buiness area
functional area
Credit control area
Sap structure levels
Client level ---Chart of accounts,controlling area,business area,
One clint can have many company code, controlling area.
But one Company code can not have many client,or many controlling area,
company code level gl accounts,vendor,customers for master data
company code is legal entity... reporting to external auditors...income tax dept..
business area is uses for internal report
Question
Who is usually responsible for establishing the organizational structure on an implementation
Answers
FI/CO Team
Question : What are the tables that are configured under global settings?
Answers : Calendar, Units of Measure, Country Table, and Currency & Exchange Rate Table
Questions :-Cash Management is a sub-module of which module..?
Answers :Treasury module
Questions :Can depreciation be processed from Asset Accounting sub-module directly to the FI and CO Modules?
Answers : YES
Question:What are the two major areas within the SAP environment? Describe each.
Answers : Configuration - Maintenance of settings in the system to support customized business requirements of the client.
&
Application - On going processes required to record and report business activity
Questions: What are the two methods available for accessing the configuration functions in FI? Describe each.
Answers :Implementation Guide (IMG) - leads you through the steps required for configuration in an implementation.
Transaction codes - takes you directly to the first screen of a transaction without the use of the IMG or menu paths
Questions
What is in Account Management....?
Answers
Open Item Management
Line Item Display
Sort Key
Questions:What are the four configuration areas of the IMG? Describe each.
Anwers :
General Settings - non-application dependent specifications
Enterprise Structure - definition of organizational units and their relationships
Cross-applications component
Functional Areas (e.g., Financial Accounting, Sales and Distribution)
Question
What is the highest level of information in SAP? Where is this configured?
Answers
General Settings, which is configured in the IMG
Questions
What is simple accounts
Anwers
A sample account kind of template that can be used to create GL accounts is not actual account in GL.
GL Accounts
Features of the FI GL Accounts module
Fi-GL accounts,
• Multiple currency capability
• Flexible real-time reporting
• Real-time transaction entry
Fi-GL accounts,
• Multiple currency capability
• Flexible real-time reporting
• Real-time transaction entry
Integrated FI-SD
FI-AR Integrated with Sales & distribution
Questions:-FI-AR is closely integrated with which other module(s) within SAP? Which cycle does this support?
The Accounts Receivable (FI-AR) module is closely integrated with the Sales & Distribution and Material Management modules. FI-AR supports the Sales cycle
Questions :-FI-AP is closely integrated with which other module(s) within SAP? Which cycle does this support?
The FI-AP module is a closely integrated with the Materials Management (MM) module. The Accounts Payable module supports the Procurement Cycle
Sap fi Finance GL Account integrate with sd sale and distributions We used tcode vkoa
But when sales order create no affect on FI
But when billing documents create its affect in FI
customer account dr
Sales and revenue account cr
and When payment received from customers
Bank account dr
customers account dr
Questions:-FI-AR is closely integrated with which other module(s) within SAP? Which cycle does this support?
The Accounts Receivable (FI-AR) module is closely integrated with the Sales & Distribution and Material Management modules. FI-AR supports the Sales cycle
Questions :-FI-AP is closely integrated with which other module(s) within SAP? Which cycle does this support?
The FI-AP module is a closely integrated with the Materials Management (MM) module. The Accounts Payable module supports the Procurement Cycle
Sap fi Finance GL Account integrate with sd sale and distributions We used tcode vkoa
But when sales order create no affect on FI
But when billing documents create its affect in FI
customer account dr
Sales and revenue account cr
and When payment received from customers
Bank account dr
customers account dr
SAP & ERP
What Is ERP and SAP
ERP is Enterprise resource planning.
In very simple way I can say that ERP is a system which help you to used one centerlised database which integrate with all department so you dont need to enter same data for other department you can save time and cost to entry data in two places and lot more.....
Sap is a ERP system.
SAP was founded in 1972 in Walldorf, Germany. It stands for Systems, Applications and Products.
ERP is Enterprise resource planning.
In very simple way I can say that ERP is a system which help you to used one centerlised database which integrate with all department so you dont need to enter same data for other department you can save time and cost to entry data in two places and lot more.....
Sap is a ERP system.
SAP was founded in 1972 in Walldorf, Germany. It stands for Systems, Applications and Products.
May 2, 2008
Integration SD,MM,PP
Integration With Other Modules SD,MM,PP
Integration is the process by which data entered in one module is used by or updates another module on a real-time basis.
SD=Sales and distributions
mm=Material Management
PP=Production planning
Integration is the process by which data entered in one module is used by or updates another module on a real-time basis.
SD=Sales and distributions
mm=Material Management
PP=Production planning
- Main questions in this topic is when FI -GL account data is update real time and how to connect with mm and what is the tcode uses for.......~
TCode for MM-FI- OBYC.
When PO Purchase order is issues No affect on FI
But When GR Goods Received is posted that affect in FI Inventory/Stock Account entry should
Inventory Account Dr
GRIR account Cr
But When IR/GR. Invoice Received is post entry is
GRIR account Dr
Vendor Account Cr
When you paid to vendor entry .....
Vendor account Dr.
Bank account CR.
Goods movement Goods Receipt, Goods Issue will affect the FI GL-accous and stock will update from MM to FI. Tcodes we used for OMJJ,OMWN,OMWB
FI Sub Modules
SAP FICO SUB MODULES
Accounts Receivable (A/R) - sub-module where customer transactions are recorded and administered within FI.
Accounts Payables (A/P) - sub-module where vendor transactions are recorded and administered within FI.
General Ledger (G/L) - submodule where financial accounting data for a legal entity is recorded.
Special Ledger (S/L) - provides summary information from multiple applications at a level of detail that the user defines that provides summary information from multiple applications at user defined levels.
Asset Accounting (AA)- encompasses the entire lifetime of the assets from purchase order or the initial acquisition through retirement. To a large extent the system automatically calculates the values for depreciation, interest, insurance.
Legal Consolidations: (FI-LC) is the sub-module with the central task of combining the financial operating results of the companies within a group to provide overall results for the group.
Funds Management: (FI-FM) is the sub-module that supports financial checking and control using budgeting techniques.
Travel Management (FI-TM): processes business trip and expense data. It may be integrated with HR (Personnel Data and Payroll).
Accounts Receivable (A/R) - sub-module where customer transactions are recorded and administered within FI.
Accounts Payables (A/P) - sub-module where vendor transactions are recorded and administered within FI.
General Ledger (G/L) - submodule where financial accounting data for a legal entity is recorded.
Special Ledger (S/L) - provides summary information from multiple applications at a level of detail that the user defines that provides summary information from multiple applications at user defined levels.
Asset Accounting (AA)- encompasses the entire lifetime of the assets from purchase order or the initial acquisition through retirement. To a large extent the system automatically calculates the values for depreciation, interest, insurance.
Legal Consolidations: (FI-LC) is the sub-module with the central task of combining the financial operating results of the companies within a group to provide overall results for the group.
Funds Management: (FI-FM) is the sub-module that supports financial checking and control using budgeting techniques.
Travel Management (FI-TM): processes business trip and expense data. It may be integrated with HR (Personnel Data and Payroll).
SAP FI Module
. What is the SAP Financial Accounting (FI) module?
The SAP Financial Accounting (FI) Module provides integrated, on-line, real-time functionality for processing, recording and maintaining the financial accounting transactions of the business for external reporting purposes.
The SAP Financial Accounting (FI) Module provides integrated, on-line, real-time functionality for processing, recording and maintaining the financial accounting transactions of the business for external reporting purposes.
Subscribe to:
Posts (Atom)
Subscribe To
Posts
All Comments