IMPORTANT TABLES IN SAP FI-CO

-
Go To SE11 ⇒ Click on Database Table⇒ Enter * and press F4 ⇒ Select the Development Class ⇒ Press F4 ⇒ You get a list of Objects and also – SAP Applications button⇒  Click on that ⇒ Select Financial Accounting

TABLE NAME

DESCRIPTION

IMPORTANT FIELDS

FINANCIAL ACCOUNTING

FBAS

FINANCIAL ACCOUNTING “BASIS”
BKPFAccounting Document HeaderMANDT / BUKRS / BELNR / GJAHR
BSEGAccounting Document SegmentMANDT / BUKRS / BELNR / GJAHR / BUZEI
BSIPIndex for Vendor Validation of Double DocumentsMANDT / BUKRS / LIFNR / WAERS / BLDAT / XBLNR / WRBTR / BELNR / GJAHR / BUZEI
BVORInter Company Posting ProcedureMANDT / BVORG / BUKRS / GJAHR / BELNR
EBKPFAccounting Document Header (docs from External Systems)MANDT / GLSBK / BELNR / GJHAR / GLEBK
FRUNRun Date of a ProgramMANDT / PRGID
KLPACustomer / Vendor LinkingMANDT / NKULI / NBUKR / NKOAR / PNTYP / VKULI / VBUKR / VKOAR
KNB4Customer Payment HistoryMANDT / KUNNR / BUKRS
KNB5Customer Master Dunning DataMANDT / KUNNR / BUKRS / MABER
KNBKCustomer Master Bank DetailsMANDT / KUNNR / BANKS / BANKL / BANKN
KNC1Customer Master Transaction FiguresMANDT / KUNNR / BUKRS / GJHAR
KNC3Customer Master Special GL Transactions FiguresMANDT / KUNNR / BUKRS / GJAHR / SHBKZ
LFB5Vendor Master Dunning DataMANDT / LIFNR / BUKRS / MABER
LFBKVendor Master Bank DetailsMANDT / LIFNR / BANKS / BANKL / BANKN
LFC1Vendor Master Transaction FiguresMANDT / LIFNR / BUKRS / GJHAR
LFC3Vendor Master Special GL Transactions FiguresMANDT / LIFNR / BUKRS / GJHAR / SHBKZ
VBKPFDocument Header for Document ParkingMANDT / AUSBK / BUKRS / BELNR / GJHAR

FBASCORE

FINANCIAL ACCOUNTING GENERAL SERVICES “BASIS”
KNB1Customer Master (Company Code)MANDT / KUNNR / BUKRS
LFA1Vendor Master (General Section)MANDT / LIFNR
LFB1Vendor Master (company Code Section)MANDT / LIFNR / BUKRS
SKA1G/L Account Master (Chart of Accounts)MANDT / KTOPL / SAKNR
SKATG/L Account Master (Chart of Accounts – Description)MANDT / SPRAS / KTOPL / SAKNR
MAHNSAccounts Blocked by Dunning SelectionMANDT / KOART / BUKRS / KONKO / MABER
MHNKDunning Data (Account Entries)MANDT / LAUFD / LAUFI / KOART / BUKRS / KUNNR / LIFNR / CPDKY / SKNRZE / SMABER / SMAHSK / BUSAB
FI-GL-GL (FBS)General Ledger Accounting: Basic Functions- G/L Accounts
SKASG/L Account Master (Chart of Accounts – Key Word list)MANDT / SPRAS / KTOPL / SAKNR / SCHLW
SKB1G/L Account Master (Company Code)MANDT / BUKRS / SAKNR
FI-GL-GL (FBSC)General Ledger Accounting: Basic Functions – R/3 Customizing for G/L Accounts
FIGLREPSettings for G/L Posting ReportsMANDT
TSAKRCreate G/L account with referenceMANDT / BUKRS / SAKNR
FI-GL-GL (FFE)General Ledger Accounting: Basic Functions – Fast Data Entry
KOMUAccount Assignment Templates for G/L Account itemsMANDT / KMNAM / KMZEI
FI-AR-AR (FBD)
ACCOUNTS RECEIVABLE: BASIC FUNCTIONS – CUSTOMERS
KNKACustomer Master Credit Management : Central DataMANDT / KUNNR
KNKKCustomer Master Credit Management : Control Area DataMANDT / KUNNR / KKBER
KNKKF1Credit Management : FI Status dataMANDT / LOGSYS / KUNNR / KKBER / REGUL
RFRRAccounting Data – A/R and A/P Information SystemMANDT / RELID / SRTFD / SRTF2
FI-BL-PT (BFIBL_CHECK_D)
BANK ACCOUNTING: PAYMENT TRANSACTIONS – GENERAL SECTIONS
PAYRPayment Medium FileMANDT / ZBUKR / HBKID / HKTID / RZAWE / CHECT
PCECPre-numbered CheckMANDT / ZBUKR / HBKID / HKTID / STAPL
FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments
F111GGlobal Settings for Payment Program for Payment RequestsMANDT
FDZACash Management Line Items in Payment RequestsMANDT / KEYNO
PAYRQPayment RequestsMANDT / KEYNO

FI-AA-AA (AA)

ASSET ACCOUNTING: BASIC FUNCTIONS – MASTER DATA
ANKAAsset Classes: General DataMANDT / ANLKL
ANKPAsset Classes: Fld Cont Dpndnt on Chart of DepreciationMANDT / ANLKL / AFAPL
ANKTAsset Classes: DescriptionMANDT / SPRAS / ANLKL
ANKVAsset Classes: Insurance TypesMANDT / ANLKL / VRSLFD
ANLAAsset Master Record SegmentMANDT / BUKRS / ANLN1 / ANLN2
ANLBDepreciation TermsMANDT / BUKRS / ANLN1 / ANLN2 / AFABE / BDATU
ANLTAsset TextsMANDT / SPRAS / BUKRS / ANLN1 / ANLN2
ANLUAsset Master Record User Fields.INCLUDE / MANDT / BUKRS / ANLN1 /  ANLN2
ANLWInsurable Values (Year Dependent)MANDT / BUKRS / ANLN1 / ANLN2 / VRSLFD / GJAHR
ANLXAsset Master Record SegmentMANDT / BUKRS / ANLN1 / ANLN2
ANLZTime Dependent Asset AllocationsMANDT / BUKRS / ANLN1 / ANLN2 / BDATU

FI-AA-AA (AA2)

ASSET ACCOUNTING: BASIC FUNCTIONS – MASTER DATA 2.0
ANARAsset TypesMANDT / ANLAR
ANATAsset Type TextMANDT / SPRAS / ANLAR

FI-AA-AA (AB)

ASSET ACCOUNTING: BASIC FUNCTIONS – ASSET ACCOUNTING
ANEKDocument Header Asset PostingMANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN
ANEPAsset Line ItemsMANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRAN / AFABE
ANEVAsset Downpymt SettlementMANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / LNRANS
ANKBAsset Class: Depreciation AreaMANDT / ANLKL / AFAPL / AFABE / BDATU
ANLCAsset value FieldsMANDT / BUKRS / ANLN1 / ANLN2 / GJAHR / AFABE
ANLHMain Asset NumberMANDT / BUKRS / ANLN1
ANLPAsset Periodic ValuesMANDT / BUKRS / GJAHR / PERAF / AFBNR / ANLN1 / ANLN2 / AFABER

FI-SL-VSR (GVAL)

SPECIAL PURPOSE LEDGER: VALIDATION, SUBSTITUTION AND RULES
GB03Validation / Substitution UserVALUSER
GB92SubstitutionsMANDT / SUBSTID
GB93ValidationMANDT / VALID
Controlling

AUSP

CHARACTERISTIC VALUES

MANDT / OBJEK / ATINN / ATZHL / MAFID / KLART / ADZHL

CO-KBAS

OVERHEAD COST CONTROLLING

A132Price per Cost CenterMANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / KOSTL / DATBI
A136Price per Controlling AreaMANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / DATBI
A137Price per Country / RegionMANDT / KAPPL / KSCHL / KOKRS / VERSN / RESRC / LAND1 / REGIO / DATBI
COSCCO Objects: Assignment of Original Costing SheetsMANDT / OBJNR / SCTYP / VERSN / GJAHR
CSSKCost Center / Cost ElementMANDT / VERSN / KOKRS / GJAHR / KOSTL / KSTAR
CSSLCost Center / Activity TypeMANDT / KOKRS / KOSTL / LSTAR / GJAHR
KAPSCO Period LocksMANDT / KOKRS / GJAHR / VERSN / VRGNG / PERBL

CO-KBASCORE

OVERHEAD COST CONTROLLING: GENERAL SERVICES

CSKACost Elements (Data Dependent on Chart of Accounts)MANDT / KTOPL / KSTAR
CSKBCost Elements (Data Dependent on Controlling Area)MANDT / KOKRS / KSTAR / DATBI
CSKSCost Center Master DataMANDT / KOKRS / KOSTL / DATBI
CSLAActivity MasterMANDT / KOKRS / LSTAR / DATBI
CO-OM (KACC)

OVERHEAD COST CONTROLLING

COBKCO Object: Document HeaderMANDT / KOKRS / BELNR
COEJCO Object: Line Items (by Fiscal Year)MANDT / KOKRS / BELNR / BUZEI / PERBL
COEJLCO Object: Line Items for Activity Types (by Fiscal Yr)MANDT / KOKRS / BELNR / BUZEI / PERBL
COEJRCO Object: Line Items for SKF (by Fiscal Year)MANDT / KOKRS / BELNR / BUZEI / PERBL
COEJTCO Object: Line Items for Prices (by Fiscal Year)MANDT / KOKRS / BELNR / BUZEI / PERBL
COEPCO Object: Line Items (by Period)MANDT / KOKRS / BELNR / BUZEI
COEPLCO Object: Line Items for Activity Types (by Period)MANDT / KOKRS / BELNR / BUZEI
COEPRCO Object: Line Items for SKF (by Period)MANDT / KOKRS / BELNR / BUZEI
COEPTCO Object: Line Items for Prices (by Period)MANDT / KOKRS / BELNR / BUZEI
COKACO Object: Control Data for Cost ElementsMANDT / OBJNR / GJAHR / KSTAR / HRKFT
COKLCO Object: Control Data for Activity TypesMANDT / LEDNR / OBJNR / GJAHR / VERSN
COKPCO Object: Control Data for Primary PlanningMANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / KSTAR / HRKFT / VRGNG / VBUND / PARGB / BEKNZ / TWAER
COKRCO Object: Control Data for Statistical Key FiguresMANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / STAGR / HRKFT / VRGNG
COKSCO Object: Control Data for Secondary PlanningMANDT / LEDNR / OBJNR / GJAHR / WRTTP / VERSN / KSTAR / HRKFT / VRGNG / PAROB / USPOB / BEKNZ / TWAER
CO-OM-CEL (KKAL)Cost Element Accounting (Reconciliation Ledger)
COFI01Object Table for Reconciliation Ledger COFITMANDT / OBJNR
COFI02Transaction Dependent Fields for Reconciliation LedgerMANDT / OBJNR
COFIPSingle Plan Items for Reconciliation LedgerRCLNT / GL_SIRID
COFISActual Line Items for Reconciliation LedgerRCLNT / GL_SIRID
CO-OM-CCACost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S
A138Price per Company CodeMANDT / KAPPL / KSCHL / KOKRS /  VERSN / RESRC / BUKRS / GSBER / DATBI
A139Price per Profit CenterMANDT / KAPPL / KSCHL / KOKRS /  VERSN / RESRC / PRCTR / DATBI

CO-OM-OPA(KABR)

Overhead Orders: Application Development R/3 Cost Accounting Settlement
AUAASettlement Document: Receiver SegmentMANDT / BELNR / LFDNR
AUABSettlement Document: Distribution RulesMANDT / BELNR / BUREG / LFDNR
AUAISettlement Rules per Depreciation AreaMANDT / BELNR / LFDNR / AFABE
AUAKDocument Header for SettlementMANDT / BELNR
AUAODocument Segment: CO Objects to be SettledMANDT / BELNR / LFDNR
AUAVDocument Segment: TransactionsMANDT / BELNR / LFDNR
COBRASettlement Rule for Order SettlementMANDT / OBJNR
COBRBDistribution Rules Settlement Rule Order SettlementMANDT / OBJNR / BUREG / LFDNR
CO-OM-OPA(KAUF)Overhead Orders: Cost Accounting Orders
AUFKOrder Master DataMANDT / AUFNR
AUFLAY0Enttity Table: Order LayoutsMANDT / LAYOUT
EC-PCA (KE1)
PROFIT CENTER ACCOUNTING
CEPCProfit Center Master Data TableMANDT / PRCTR / DATBI / KOKRS
CEPCTTexts for Profit Center Master DataMANDT / SPRAS / PRCTR / DATBI / KOKRS
CEPC_BUKRSAssignment of Profit Center to a Company CodeMANDT / KOKRS / PRCTR / BUKRS
GLPCAEC-PCA: Actual Line ItemsRCLNT / GL_SIRID
GLPCCEC-PCA: Transaction AttributesMANDT / OBJNR
GLPCOEC-PCA: Object Table for Account Assignment ElementMANDT / OBJNR
GLPCPEC-PCA: Plan Line ItemsRCLNT / GL_SIRID
EC-PCA BS (KE1C)PCA Basic Settings: Customizing for Profit Center Accounting
A141Dependent on Material and Receiver Profit CenterMANDT / KAPPL / KSCHL / KOKRS / WERKS / MATNR / PPRCTR / DATBI
A142Dependent on MaterialMANDT / KAPPL / KSCHL / WERKS / MATNR / DATBI
A143Dependent on Material GroupMANDT / KAPPL / KSCHL / WERKS / MATKL / DATBI

Comments

Post a Comment

Popular posts from this blog

Using T-Code GGB1 (Substitution Maintenance) to create FI Substitutions

-
Image
Substitution in SAP FI is done to insert/infuse values into existing set of value(s) in fields. There are many cases where functional consultant don’t want to clutter up things using User-exits and SAP Enhancements. This is one of the best tool/method provided for keeping all the things/coding tidy as far as simple Substitutions are concerned. For complex Substitution, of-course User-exit (within the Substitution) needs to be written down as per requirements. In this step-by-step document, we will traverse through a simple Substitution case involving Customer User-Exit showing the flexibility of SAP Substitution. Our Example Case: Substitute ‘Additional asset description’ field (ANLA-TXA50) value with 15 digit code maintained in Key word for G/L accounts in G/L account master. 1. Execute Tcode  GGB1  and define the Substitution. Insert step in it. Here you can define the prerequisite based upon your requirements. In our case lets say we want it in all cases so we ...
Read more

SAP PSM-FM (Fund Management - BCS) Master Data and Derivation Tool

-
Image
  Organizational Structures LESSON OVERVIEW The lesson will explain the organize structures in Funds Management. LESSON OBJECTIVES After completing this lesson, you will be able to: Organize structures in Funds Management         Figure 6: Organizational Elements Within Accounting Depending on the level at which accounting data is viewed, the organization is represented in the SAP system using the following structures: The organizational unit for Funds Management is the financial management area (FM area). The organizational unit for Controlling is the controlling area. The organizational unit for Financial Accounting is the company code. The FM area and the controlling area take precedence over the company code.         Figure 7: Organizational Structures         Figure 8: Organizational Structures - Scenario 1 Scenario 1 :  Funds/Functional Area/Funded Prog...
Read more

SAP PSM-FM (Fund Management-BCS) Integration with other SAP Module

-
Image
  Financial and Asset Accounting Integration LESSON OVERVIEW This lesson will explain the process to integrate Funds Management, core processes within purchasing and the uses of Asset Accounting components. LESSON OBJECTIVES After completing this lesson, you will be able to: Define the business processes that are integrated in Funds Management Explain the ways in which the Controlling, Project System, Asset Accounting, Plant Maintenance, and Sales and Distribution application components can be integrated with Funds Management Compare the different core processes that take place within purchasing, and within payroll and trip cost accounting Troubleshoot the individual steps to be followed and a detailed explanation of how they are inter-linked and how assessed value is adjusted         Figure 146: Financial and Asset Accounting Integration         Figure 147: Integration FI - Funds Management A commitmen...
Read more