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

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 commitment item must be defined in each line item of an FI document for integration with FI.
Read more

SAP FICO (SAP Finance and SAP Controlling)

-
Image
In this post I'll try to explain what the definition of SAP FI (Finance) and SAP CO (Controlling) Companies that implement SAP SAP FICO is a core functional component in SAP ERP Central Component that allows an organization to manage all of its financial data. The purpose of SAP FICO is to help companies generate and manage financial statements for analysis and reporting and help with effective business planning and decision-making. SAP FICO consists of two modules, SAP Finance (FI) and SAP Controlling (CO), each of which is used for specific financial processes. SAP FI deals with overall financial reporting and accounting while SAP CO focuses more narrowly on planning and monitoring costs. SAP FI and SAP CO were originally released as separate modules but are now so tightly integrated that many people refer to them as simply one module. SAP FI modules SAP FI enables companies to generate financial statements -- such as balance sheets or profit and loss statements
Read more

Asset Accounting in SAP S/4HANA

-
Image
Asset Transaction Types Every transaction in Asset Accounting carries an asset transaction type. There are groups of transaction types for specific operations:   Acquisitions   Retirements   Transfers   Post-capitalizations   Investment support measures   Depreciation   Write-ups The group a transaction type is assigned to defines a lot of basic characteristics for the transaction, such as which value fields are updated, the valid fiscal year (current or previous), the sign (positive, negative) of the sum of the postings for a fiscal year, and more. The transaction type groups are hardcoded system settings and can’t be changed. Additionally, each transaction type has a set of controls that you configure. The specifications can differ according to the transaction type group. Depending on the transaction type group of the transaction type, you define settings such as the following:   Debit/Credit    Capitalize/Retire    Document Type    Posting to Affiliated Company    Post Gross/Net   
Read more