SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | FM01
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Funds Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FM01631Financial Management AreasFunds Management
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, FIKRS, OBJNR, FIPOE, FIPOA, NZSTL, FCODE_PERIV_ACTV, FUND_BLANK, FUND_BLANK_TO, FUNCTION_BLANK, FUNCT_BLANK_TO, MEASURE_BLANK, MEASURE_BLANK_TO, GRANT_BLANK, GRANT_BLANK_TO, WAERS, SPRAS, PERIV, FMAKT, DATBIS, CB_PROFIL, CA_PROFIL, CA_PERIV, CA_NUMKR, CA_AKTIV, CO_PERIV, SP_PROFIL, CA_STSMA, FMCARR, XFMCS, SEQUENCE, CO_TIMEDEP, YEARPOS, YEARCTR, FS_PROFIL, FS_PROFIL_AL, CO_INTEGRATION, CO_INT_START_HR, HRBA_PRECOM, HRBA_COMMIT, HRBA_BLOCK, VERSACT, AUGRP, ACTMODE, FSTVARE, DR_NUMKR, FIPOE24, FIPOA24, FAREA_ACTIVE, NO_HIERARCHY, BUDGETTYPE_RIB, BUDGETTYPE_COVER, BUDGETTYPE_FYC, BUDGETTYPE_HR, CREATE_VAD, HRBA_PRECOM_NEG, HRBA_COMMIT_NEG, BUD_PER_BLANK, BUD_PER_BLANK_TO, REV_CI_POST_OBJ, CO_PLAN_NO_CHECK, KENNZIFFER, XBGACTIVE FROM FM01
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2FIKRSFinancial Management Areanvarchar40CHAR(N' ')NoFIKRS Allow NULL? 
3OBJNRObject numbernvarchar220CHAR(N' ')No*J_OBJNR Allow NULL? 
4FIPOEUnassignable revenues: commitment itemnvarchar140CHAR(N' ')No*FM_NZFPE Allow NULL? 
5FIPOAUnassignable expenditures: commitment itemnvarchar140CHAR(N' ')No*FM_NZFPA Allow NULL? 
6NZSTLUnassignable revenues/expenditures: Funds centernvarchar160CHAR(N' ')No*FM_NZSTL Allow NULL? 
7FCODE_PERIV_ACTVFiscal year variant active for funds (indicator)char10CHAR(N' ')YesFM_PERIV_ACTV Allow NULL? 
8FUND_BLANKBlank is a Valid Value for Fundchar10CHAR(N' ')NoFM_FUND_BLANK Allow NULL? 
9FUND_BLANK_TOFiscal Year Until Which BLANK is a Valid Valuenvarchar40NUMC(N'0000')YesFM_BLANK_TO_YEAR Allow NULL? 
10FUNCTION_BLANKBlank is Valid Value for the Functional Areachar10CHAR(N' ')NoFM_FUNCTION_BLANK Allow NULL? 
11FUNCT_BLANK_TOFiscal Year Until Which BLANK is a Valid Valuenvarchar40NUMC(N'0000')YesFM_BLANK_TO_YEAR Allow NULL? 
12MEASURE_BLANKBLANK is a Valid Value for the Funded Programchar10CHAR(N' ')NoFM_MEASURE_BLANK Allow NULL? 
13MEASURE_BLANK_TOFiscal Year Until Which BLANK is a Valid Valuenvarchar40NUMC(N'0000')YesFM_BLANK_TO_YEAR Allow NULL? 
14GRANT_BLANKBLANK is a Valid Value for the Grantchar10CHAR(N' ')NoGM_GRANT_BLANK Allow NULL? 
15GRANT_BLANK_TOFiscal Year Until Which BLANK is a Valid Valuenvarchar40NUMC(N'0000')YesFM_BLANK_TO_YEAR Allow NULL? 
16WAERSFM area currencynvarchar50CUKY(N' ')YesTCURCFM_WAERS Allow NULL? 
17SPRASLanguage Keychar10LANG(N' ')YesT002FM_SPRAS Allow NULL? 
18PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
19FMAKTIndicator: Cash Budget Management activechar10CHAR(N' ')YesFM_FMAKT Allow NULL? 
20DATBISFM: Valid to datenvarchar80DATS(N'00000000')YesFM_DATBIS Allow NULL? 
21CB_PROFILPlanning profilenvarchar60CHAR(N' ')YesTBP1CBP_PPROFIL Allow NULL? 
22CA_PROFILBudget Profilenvarchar60CHAR(N' ')YesTBP1CBP_BPROFIL Allow NULL? 
23CA_PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
24CA_NUMKRNumber range numbernvarchar20CHAR(N' ')YesNRNR Allow NULL? 
25CA_AKTIVFunds Management Active (Indicator)char10CHAR(N' ')YesFCA_AKTIV Allow NULL? 
26CO_PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
27SP_PROFILBudget profile for fundnvarchar60CHAR(N' ')YesTBP1CBP_PROF_SP Allow NULL? 
28CA_STSMAStatus Profilenvarchar80CHAR(N' ')YesTJ20J_STSMA Allow NULL? 
29FMCARRActive budget objects (indicator)char10CHAR(N' ')YesFM_CARR Allow NULL? 
30XFMCSCO Cash budget management: manual master data maintenancechar10CHAR(N' ')YesXFMCS Allow NULL? 
31SEQUENCERanking Order in Generic Searchchar10NUMC(N'0')YesFM_SEQUENC Allow NULL? 
32CO_TIMEDEPYear-dependent assignmentchar10CHAR(N' ')YesFM_TIMEDEP Allow NULL? 
33YEARPOSYear-dependent commitment itemschar10CHAR(N' ')YesFM_YEARPOS Allow NULL? 
34YEARCTRYear-dependent funds centerschar10CHAR(N' ')YesFM_YEARCTR Allow NULL? 
35FS_PROFILFM update profilenvarchar60CHAR(N' ')YesFMUP00FM_PROFIL Allow NULL? 
36FS_PROFIL_ALFM update profilenvarchar60CHAR(N' ')YesFMUP00FM_PROFIL Allow NULL? 
37CO_INTEGRATIONActivate CO Integration with Funds Managementchar10CHAR(N' ')YesFM_CO_INTEGRATION Allow NULL? 
38CO_INT_START_HRActive for HR fromnvarchar80DATS(N'00000000')YesFM_CO_START_HR Allow NULL? 
39HRBA_PRECOMFunds precommitment document type, HR integrationnvarchar20CHAR(N' ')YesTKBBAFM_HRBA_PRECOM Allow NULL? 
40HRBA_COMMITFunds commitment document type, HR integrationnvarchar20CHAR(N' ')YesTKBBAFM_HRBA_COMMIT Allow NULL? 
41HRBA_BLOCKFunds block document type, HR integrationnvarchar20CHAR(N' ')YesTKBBAFM_HRBA_BLOCK Allow NULL? 
42VERSACTBudget Version Activation Processchar10NUMC(N'0')YesFM_VERSACT Allow NULL? 
43AUGRPFM: Fund authorization groupnvarchar100CHAR(N' ')YesFM_AUTHGRF Allow NULL? 
44ACTMODEActivating mode for commitment itemschar10CHAR(N' ')YesFM_ACTMODE Allow NULL? 
45FSTVAREFunds reservation field status var.nvarchar40CHAR(N' ')Yes*FSTVARE Allow NULL? 
46DR_NUMKRNumber range numbernvarchar20CHAR(N' ')YesNRNR Allow NULL? 
47FIPOE24Unassignable revenues: commitment itemnvarchar240CHAR(N' ')YesFM_NZFPE24 Allow NULL? 
48FIPOA24Unassignable expenditures: commitment itemnvarchar240CHAR(N' ')YesFM_NZFPA24 Allow NULL? 
49FAREA_ACTIVEFunctional Area in Funds Management Activechar10CHAR(N' ')YesFM_FAREA_ACTIVE Allow NULL? 
50NO_HIERARCHYNo Budget Hierarchy in Budget Planningchar10CHAR(N' ')YesFM_NO_HIERARCHY Allow NULL? 
51BUDGETTYPE_RIBBudget Subtype for Automated Procedure Revs Incr. Bdgtnvarchar40CHAR(N' ')Yes*FM_SUBVO_RIB Allow NULL? 
52BUDGETTYPE_COVERBudget Subtype for Automated Procedure Cover Eligibilitynvarchar40CHAR(N' ')Yes*FM_SUBVO_COVER Allow NULL? 
53BUDGETTYPE_FYCBudget Subtype for Carryforwardnvarchar40CHAR(N' ')Yes*FM_SUBVO_FYC Allow NULL? 
54BUDGETTYPE_HRBudget Subtype for HR Budgetnvarchar40CHAR(N' ')Yes*FM_SUBVO_HR Allow NULL? 
55CREATE_VADChange of document amounts only by value adjustment docschar10CHAR(N' ')YesFMHRBA_USE_VAD Allow NULL? 
56HRBA_PRECOM_NEGFunds precommitment doc. type HR integration for neg. valuesnvarchar20CHAR(N' ')YesTKBBAFM_HRBA_PRECOM_NEG Allow NULL? 
57HRBA_COMMIT_NEGFunds cmmt doc. type HR integration for negative valuesnvarchar20CHAR(N' ')YesTKBBAFM_HRBA_COMMIT_NEG Allow NULL? 
58BUD_PER_BLANKBlank value is allowed for Budget Periodchar10CHAR(N' ')YesFM_BUD_PER_BLANK Allow NULL? 
59BUD_PER_BLANK_TOFiscal Year Until Which BLANK is a Valid Valuenvarchar40NUMC(N'0000')YesFM_BLANK_TO_YEAR Allow NULL? 
60REV_CI_POST_OBJRevenue Acct Assignments can be Defined as Posting Objectschar10CHAR(N' ')YesFMBS_REV_CI_POSTABLE Allow NULL? 
61CO_PLAN_NO_CHECKNo Check for FM in CO Planningchar10CHAR(N' ')YesFM_CO_PLAN_NO_CHECK Allow NULL? 
62KENNZIFFERFM area reference numbernvarchar80NUMC(N'00000000')YesFM_KENNZIF Allow NULL? 
63XBGACTIVEActivation Switch for Public-Owned Commercial Operationschar10CHAR(N' ')YesFMBGACTIVE Allow NULL? 
NamePrimaryUniqueTypeColumns
FM01~0YesYesCLUSTEREDFIKRS, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy