7 Replies Latest reply: Nov 27, 2008 11:28 AM by Sirisha VT RSS

tables and fields

sunitha reddy
Currently Being Moderated

Hi GURU;S

 

CAN ANYBODY HELP ME TO GET TABLES AND FILEDS FOR BELOW

Vendor Number

Vendor Name

Net Value £

VAT £

Gross Value £

Document Number

Document Date

Invoice Date

Invoice Description

General Ledger Code

VAT Code

Fiscal Year

Period

Company Code

 

Customer Number

Customer Name

Net Value £

VAT £

Gross Value £

Document Number

Document Date

Clearing Date

Clearing Allocation

Document Text

Fiscal Year

Period

Company Code

 

Document Number

Document Date

Posting Date

Fiscal Year

Period

Reference Document Number

Credit General Ledger Account

Credit Cost Centre Account

Credit Value

Credit Description

Debit General Ledger Account

Debit Cost Centre Account

Debit Vaue

Debit Description

Company Code

 

i WILL ASSIGN VALUE POINTS

RGDS

Sunitha

 

  • Re: tables and fields
    M N
    Currently Being Moderated

    To get to the table/field name : click on the field, F1 key, Techincal information button(4th button), get the table name and field name from that screen

  • Re: tables and fields
    Gupta Kallepalli
    Currently Being Moderated

    Some standard tables you can verify are

    LFA1 -  Vendor master data

    LFB1 -  Company Code - Vendir master tables

     

    KNA1 - For Customer master data

    KNB1 - Comapnyc doe - customer master

     

    Go to SE16N and enter the table name

  • Re: tables and fields
    Currently Being Moderated

    hi reddy,

     

    Table Name Description Important Fields

    Financial Accounting

    FBAS Financial Accounting u201CBasisu201D

    BKPF Accounting Document Header BUKRS / BELNR / GJAHR

    BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI

    BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT /

    Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI

    BVOR Inter Company Posting Procedure BVORG / BUKRS / GJAHR / BELNR

    EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK

    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 Figures KUNNR / BUKRS / GJHAR

    KNC3 Customer Master Special GL Transactions KUNNR / BUKRS / GJAHR / SHBKZ

    Figures

    LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER

    LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN

    LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR

    LFC3 Vendor Master Special GL Transactions LIFNR / BUKRS / GJHAR / SHBKZ

    Figures

    VBKPF Document Header for Document Parking AUSBK / BUKRS / BELNR / GJHAR

    FBASCORE Financial Accounting General Services u201CBasisu201D

    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 u2013 SPRAS / KTOPL / SAKNR

    Description)

    MAHNS Accounts Blocked by Dunning Selection KOART / BUKRS / KONKO / MABER

    MHNK Dunning Data (Account Entries) LAUFD / LAUFI / KOART / BUKRS /

    KUNNR / LIFNR / CPDKY / SKNRZE /

    SMABER / SMAHSK / BUSAB

    FI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L Accounts

    SKAS G/L Account Master (Chart of Accounts u2013 SPRAS / KTOPL / SAKNR / SCHLW

    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 : FI Status data LOGSYS / KUNNR / KKBER / REGUL

    RFRR Accounting Data u2013 A/R and A/P RELID / SRTFD / SRTF2

    Information System

    FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions u2013 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 u2013 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

     

    Also check the below link

    http://www.sap-img.com/financial/important-tables-in-sap-fi.htm

     

    Hope this will be help full to you......

     

    Cheers.......

Actions