SAP FI TABLES

FI Tables

AGKO	Cleared Accounts
ANAR	Asset Types
ANAT	Asset type text
ANEK	Document Header Asset Posting
ANEP	Asset Line Items
ANEV	Asset downpymt settlement
ANKT	Asset classes- Description
ANLA	Asset Master Record Segment
ANLB	Depreciation terms
ANLC	Asset Value Fields
ANLH	Main asset number
AT02T	Transaction Activity Category- Description
AT02A	Transaction Code for Menu TIMN
AT10	Transaction type
AT10T	Name of Transaction Type
BKDF	Document Header Supplement for Recurring Entry
BKORM	Accounting Correspondence Requests
BKPF	Accounting Document Header
BLPK	Document log header
BLPP	Document log item
BLPR	Document Log Index and Planned Order (Backflush)
BNKA	Bank master record
BP000	Business Partner Master (General Data)
BPBK	Doc.Header Controlling Obj.
BPEG	Line Item Total Values Controlling Obj.
BPEJ	Line Item Annual Values Controlling Obj.
BPEP	Line Item Period Values Controlling Obj.
BPGE	Totals Record for Total Value Controlling obj.
BPJA	Totals Record for Annual Total Controlling Obj.
BSAD	Accounting- Secondary Index for Customers (Cleared Items)
BSAK	Accounting- Secondary Index for Vendors (Cleared Items)
BSAS	Accounting- Secondary Index for G/L Accounts (Cleared Items)
BSEC	One-Time Account Data Document Segment
BSEG	Accounting Document Segment
BSID	Accounting- Secondary Index for Customers
BSIK	Accounting- Secondary Index for Vendors
BSIM	Secondary Index, Documents for Material
BSIS	Accounting- Secondary Index for G/L Accounts
CEPC	Profit Center Master Data Table
CEPCT	Texts for Profit Center Master Data
COBRA	Settlement Rule for Order Settlement
COBRB	Distribution Rules Settlement Rule Order Settlement
COKA	CO Object- Control Data for Cost Elements
COSP	CO Object- Cost Totals for External Postings
COSS	CO Object- Cost Totals for Internal Postings
CRCO	Assignment of Work Center to Cost Center
CSKA	Cost Elements (Data Dependent on Chart of Accounts)
CSKB	Cost Elements (Data Dependent on Controlling Area)
CSLA	Activity master
FEBEP	Electronic Bank Statement Line Items
FPLA	Billing Plan
FPLT	Billing Plan- Dates
GLPCT	EC-PCA- Totals Table
KNA1	General Data in Customer Master
KOMK	Pricing Communication Header
MAHNV	Management Records for the Dunning Program
REGUT	TemSe - Administration Data
SKA1	G/L Account Master (Chart of Accounts)
SKAT	G/L Account Master Record (Chart of Accounts- Description)
SKB1	G/L account master (company code)
T003T	Document Type Texts
T007S	Tax Code Names
T087J	Text
TAPRFT	Text tab. for investment profile
TKA01	Controlling Areas
TKA09	Basic Settings for Versions
TKVS	CO Versions
TZB0T	Flow types text table
TZPAT	Financial Assets Management product type texts
VBSEGS	Document Segment for G/L Accounts Document Parking
VTBFHA	Transaction
VTBFHAPO	Transaction Flow
VTBFHAZU	Transaction Activity
VTBFINKO	Transaction Condition
VTIDERI	Master Data Listed Options and Futures
VTIFHA	Underlying transaction
VTIFHAPO	Underlying transaction flows
VTIFHAZU	Underlying transaction status table
VTIOF	Options Additional Data
VWPANLA	Asset master for securities

SAP FICO Faq's

1	What does the Field Status Group Controls?
Ans:	Field Status Group Controls the fields that have the statuses such as Suppressed, Display, Optional and Required. It is a mandatory field in General Ledger creation and it defines in which fields are displayed when you post business transactions to G/L account.

2	Give the Structure of an Organization of FI?
Ans:

3	Why do you use Special Periods and how many Normal and Special periods will be there in Fiscal Year and where do you Open and Close Periods?
Ans:	Special Periods are used for posting tax and audit adjustments to a closed fiscal year and there will be 12 Normal Posting Periods and 4 Special Periods. Transaction Code OB52, PPV is used to open and close the periods based on a/c types considering GL Accounts.

4	What is document type control? What are the entries in Company Code Global Settings?
Ans:	Vouchers containing line items and where Several Business Transaction can be identified particularly are known as document type. Document type controls the number ranges, Header part; IT controls the line item level. Coming to Global Settings it is a 4 digit Alphanumeric, Name of the Company, City, Country, Currency, Language and Address.

5	What does a Posting key control?
Ans:	Posting Key is a 2 character numerical key and it is special classification key and it determines Account type; Debit/Credit posting, Field status of transaction. Posting Key controls the entry of line items.

6

How many charts accounts can be assigned to a company?

Ans:

A charts account has to assign a chart of accounts to each company code. This chart of accounts is the Operating chart of accounts and is used for the daily postings in this company code. They have the following options when using multiple company codes. This can use the same chart of accounts for all company codes If the company codes all have the same requirements for the chart of accounts set up, assign all of the individual company codes to the same chart of accounts. This could be the case if all company codes are in the same country. In addition to the operating chart of accounts, you can use two additional charts of accounts if the individual company codes need different charts of accounts, it can assign unto two charts of accounts in addition to the operating chart of accounts. This could be the case if company codes lie in multiple countries. The use of different charts of accounts has no effect on the balance sheet and profit and loss statement. When creating the balance sheet or the profit and loss statement, choose whether to balance the company codes, which use different charts of accounts together or separately.

7	What does a Chart of Accounts Contain?
Ans:	Chart of Accounts Key Contain the a) Name b) Maintenance Language c) Length of the Gl Account Number d) Controlling Integration e) Group Chat of Accounts f) Block Indicator.

8	Can a COA be assigned to several companies?
Ans:	Yes. One COA can be assigned to several companies.

9	What does an account group control?
Ans:	The Account Group Controls the Number Ranges of GL account, the account group determines the fields that can configure on the G/L master record. It is necessary to have at least two B/S and P&L a/c.

10	Can a reconciliation account be directly entering documents in that a/c?
Ans:	It is not possible to use reconciliation account for direct posting since, When the data is posted into a subsidiary ledger, then the system would automatically posts the same data to the general ledger, each subsidiary ledger has more than one reconciliation accounts in the general ledger.
11	What is Residual and Part Payment?
Ans:	The payment that clears original invoice with incoming amount and creates new line item for remaining outstanding amount is a Residual Payment, the payment that leaves the original invoice amount and creates new line item for incoming amount is known as Part Payment.

12	Where does the Field Status of GL Master Records control?
Ans:	Field status of GL Master records is maintained by the field status variant since it maintains all Field Status Groups.

13	List the Segments of GL Master Record?
Ans:	COA Segment Account Group, Nature of Account, Short Text, GL account long text, Trading Partner, Group Account Number. Company Code Segment, Account Currency Tax and Reconciliation account for account type OIM, FSG.

14	Why do the Field Status Group assigned to GL Master Record Controls?
Ans:	Field Status Group is assigned to GL Master Record Controls since it controls the account assignments that are mode of the account.  Specifically the field status group controls whether postings to const centers, internal order, profitability segments and so as they require and not allowed (suppressed), or optional.

15	Why does a group chart of Account is used and what is Country and operational chart of Account?
Ans:	Chart of Account is used for consolidation of Company Codes and this is for group consolidation purpose. Where as the Operational Chart Of Account is for a day to day activities which is mandatory. Coming to COA it is used for legal specific requirement of each country, which is additional and optional.

16	What are the segments in a Customer Master Record?
Ans:	The Segments in a Customer Master Record are: a) General Data Segment      b) Company Code Segment and   c) Sales are Segment.

17	What are the Segments in a Vendor Master Record?
Ans:	The Segments in a Vendor Master Record are: General Data Segment  Company Code Segment and Purchasing Organization Segment.

18	What does the Clearing Open Line Items and Open Line item Management means?
Ans:	OIM allows displaying the open and cleared items and amounts in an account; it is used if an offsetting entry is made for every line item posted in the account. The account is reconciled and cleared against another account. Such as Salary clearing account and GR/IR Clearing account. And where as the open item management is a further re conciliation function.

19

What does the internal and external number ranges means?

Ans:

The document, which was generated by the system automatically in a serial order allotting the next available progressive number, which should be numerical, is termed as Internal Number Range. The document generated manually by the end user. System will not lock automatically in this case. So the user can pick the number randomly and it may be alpha numeric. So it was termed as External Number Range.

20	What is APC?
Ans:	APC stands for Acquisition and Production costs. Acquisition means any asset, which you may, acquire/ purchase externally. It includes invoice price and other related exp. Associated with it like customs, octopi, freight that you add and arrive at total cost of acquisition for capitalization of the asset. For ex say a computer. The total cost which you incur for the acquisition of the computer including installation will be your APC Production cost means any asset, which is created internally within the organization. This is normally created by means of AUC and you go on adding cost to the AUC as and when you incur exp. for the same. For ex. say addition to the office building. Therefore APC includes any external acquisition or internal construction of exp., which needs to be capitalized
21	What is Residual and Part Payment?
Ans:	The payment that clears original invoice with incoming amount and creates new line item for remaining outstanding amount is a Residual Payment, the payment that leaves the original invoice amount and creates new line item for incoming amount is known as Part Payment.

22	What is the importance of baseline date in Automatic Payment Program Run?
Ans:	In Automatic Payment Program Run the base line date helps to pick the relevant invoices for payments, during the Automatic Payment Program run when the invoices are pulled into the run, the system checks the Next Payment Date before picking the invoices to be paid. Since the Base line date is used to calculate the due date by taking into account the payment terms.

23	How does the Procurement Cycle run?
Ans:	When a Sales Order is placed for a requirement made by a customer, then it is passed to create a purchase order this would depend upon the requirement. Then the value flow gets passed to Finance at the time of goods movement. In case of Sales Dept. the impact on Finance happens only at the time of billing. The complete process explains about Procurement Cycle Run.

24	What is the difference between APC, Accumulated Depreciation and Depreciation?
Ans:	APC would refer to Asset Transactions other than depreciation; Accumulated Depreciation is the total amount of depreciation calculated on a particular asset and Depreciation is a decrease in the value of an asset due to wear and tear.

25	What are the Journal entries passed in GR/IR?
Ans:	The Journal entries are passed in GR/IR account to maintain the temporary record of flow, since during the time between the invoice being created and delivery of goods, there can be a timing difference, in order to accommodate this timing difference.

26	What are the accounting entries take place in MM and SD?
Ans:	Value from MM to FI is defined in OBYC…. on the material master the flow of values are assigned on the Costing, accounting, etc tabs where the system helps to post the necessary stock values into the appropriate GL accounts. Helps to determine, the GL accounts updated when there is a movement of goods

SAP Online Class Requirement

Pls check for online Classes . Pls send your Skype id


System with internet Connection
Skype
Head Set with mic
Showmypc (showmypc.com) for desktop sharing or Teamviewer ( teamviewer.com  )

In case of any queries pls call me.

Creation of Tabstrips In Report Selection screen

TABLES: ekko, ekpo, eket, marc, t134h.

*---------------------------------------------------------------------*
*   Tab Strips 1
*---------------------------------------------------------------------*
SELECTION-SCREEN BEGIN OF SCREEN 101 AS SUBSCREEN.
SELECTION-SCREEN BEGIN OF BLOCK vendor WITH FRAME TITLE text-t00.
SELECT-OPTIONS vendor FOR ekko-lifnr.
SELECTION-SCREEN SKIP.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN COMMENT (10) text-m01.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN SKIP.
SELECT-OPTIONS vplant FOR ekko-reswk.
SELECTION-SCREEN END OF BLOCK vendor.
SELECTION-SCREEN END OF SCREEN 101.
*---------------------------------------------------------------------*
*   Tab Strips 2
*---------------------------------------------------------------------*
SELECTION-SCREEN BEGIN OF SCREEN 102 AS SUBSCREEN.
SELECTION-SCREEN BEGIN OF BLOCK data1 WITH FRAME TITLE text-t02.
SELECT-OPTIONS: busarea FOR t134h-gsber,
                plant   FOR ekpo-werks,
                puorg   FOR ekko-ekorg.
SELECTION-SCREEN END OF BLOCK data1.
SELECTION-SCREEN SKIP.
SELECTION-SCREEN BEGIN OF BLOCK data2 WITH FRAME TITLE text-t03.
SELECT-OPTIONS  sched   FOR ekko-ebeln.
SELECT-OPTIONS  matl    FOR ekpo-matnr.
SELECTION-SCREEN END OF BLOCK data2.
SELECTION-SCREEN END OF SCREEN 102.
*---------------------------------------------------------------------*
*   Tab Strips 3
*---------------------------------------------------------------------*
SELECTION-SCREEN BEGIN OF SCREEN 103 AS SUBSCREEN.
SELECTION-SCREEN BEGIN OF BLOCK rype WITH FRAME TITLE text-t04.
SELECTION-SCREEN BEGIN OF LINE.
PARAMETERS del RADIOBUTTON GROUP one.
SELECTION-SCREEN COMMENT 4(35) text-c05 FOR FIELD del.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
PARAMETERS fix RADIOBUTTON GROUP one.
SELECTION-SCREEN COMMENT 4(35) text-c06 FOR FIELD fix.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF BLOCK rype.
SELECTION-SCREEN SKIP.
SELECTION-SCREEN BEGIN OF BLOCK interval WITH FRAME TITLE text-t05.
SELECTION-SCREEN BEGIN OF LINE.
PARAMETERS mon RADIOBUTTON GROUP two.
SELECTION-SCREEN COMMENT 4(15) text-c01 FOR FIELD mon.
PARAMETERS evalmon TYPE spbup.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
PARAMETERS wek RADIOBUTTON GROUP two.
SELECTION-SCREEN COMMENT 4(15) text-c02 FOR FIELD wek.
PARAMETERS evalweek TYPE sptag.
SELECTION-SCREEN COMMENT 35(30) text-i01.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF BLOCK interval.
SELECTION-SCREEN SKIP.
SELECTION-SCREEN BEGIN OF BLOCK type WITH FRAME TITLE text-t01.
SELECTION-SCREEN BEGIN OF LINE.
PARAMETERS ext RADIOBUTTON GROUP thr.
SELECTION-SCREEN COMMENT 4(15) text-c08 FOR FIELD int.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
PARAMETERS int RADIOBUTTON GROUP thr.
SELECTION-SCREEN COMMENT 4(15) text-c07 FOR FIELD ext.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF BLOCK type.
SELECTION-SCREEN BEGIN OF BLOCK pre WITH FRAME TITLE text-t06.
SELECTION-SCREEN BEGIN OF LINE.
PARAMETERS vn RADIOBUTTON GROUP slv.
SELECTION-SCREEN COMMENT 4(15) text-c09 FOR FIELD vn.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN BEGIN OF LINE.
PARAMETERS bp RADIOBUTTON GROUP slv.
SELECTION-SCREEN COMMENT 4(17) text-c10 FOR FIELD bp.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF BLOCK pre.
SELECTION-SCREEN END OF SCREEN 103.

SELECTION-SCREEN BEGIN OF TABBED BLOCK uno FOR 20 LINES.
SELECTION-SCREEN TAB (15) name1 USER-COMMAND ucomm1
DEFAULT SCREEN 101.
SELECTION-SCREEN TAB (17) name2 USER-COMMAND ucomm2
DEFAULT SCREEN 102.
SELECTION-SCREEN TAB (23) name3 USER-COMMAND ucomm3
DEFAULT SCREEN 103.
SELECTION-SCREEN END OF BLOCK uno.

INITIALIZATION.
  name1 = text-n01.
  name2 = text-n02.
  name3 = text-n03.