on 11-25-2008 4:05 PM
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
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.......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks to all, i have got many tabels and i am not able to fild few feilds for below
in AP
VAT £
Gross Value £
Invoice Description
General Ledger Code
in AR
Clearing Allocation
in GL
Credit General Ledger Account
Credit Cost Centre Account
Credit Value
Credit Description
Debit General Ledger Account
Debit Cost Centre Account
Debit Vaue
Debit Description
can any body help me to get know the tablels and fileds for above
i will assign value points
thanks
Sunitha
Hi Sunitha,
http://www.erpgenie.com/sap/abap/tables.htm
pick table name like BSIK & then start searching the field in t.code SE16N. may b u can get the rest in this manner.
give some points who is helping u.
regards
Sirisha
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.