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  | FM01D
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.0FM01D511Funds Management Update ControlFunds Management
SQL:  selectupdate insert create

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

SELECT MANDT, FIKRS, APPLC, BEG_INV, END_INV, CIACC, COACC, FLG_PODATE, FLG_MWST, FLG_WERE, FLG_AUTO, FLG_INDATE, FLG_PADATE, FLG_PRDATE, FLG_WAKNT, FLG_BEKNT, FLG_PAYM, FLG_PAYM_RC, FLG_PAYM_RC_DEL, FLG_PAYM_RC_66, FLG_CFPAY, FLG_SPLIT, FM_DP_DIT, CFLEV_OI, CFLEV_FI, FM_PAYM_FISTL, FM_PAYM_FIPEX, FM_MONTH_CLOSING, FM_YEAR_CLOSING, FM_PAYTR_PARAL, FM_PAYTR_DEST, FM_PAYTR_SDOC_1, FM_PAYTR_EDOC_1, FM_PAYTR_NPARA_1, FM_PAYM_S200_NRC, FM_PAYM_S200_RC, PCACC, FM_USEREAL, XSEC_CURRENCY, FM_PAYM_CM_UPD, FLG_TAX_TO_GL, FLG_MULTIANNUAL, FLG_AK_PAYM_FICA, FLG_AK_PAYM_FIAR, FLG_FM_CURTP, FLG_SDOR_UPDATE, FM_PAYM_PUR, FM_DTACT_PUR, FM_PO_ADJ_INV, FM_USE_INV_COMPL, FLG_BTC_CL FROM FM01D
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2FIKRSFinancial Management Areanvarchar40CHAR(N' ')NoFM01FIKRS Allow NULL? 
3APPLCFunds management application indicatorchar10CHAR(N' ')NoFM_APPLC Allow NULL? 
4BEG_INVStart year for Cash Budget Management balancesnvarchar40NUMC(N'0000')NoFM_BEG_INV Allow NULL? 
5END_INVLast year for Cash Budget Management balancesnvarchar40NUMC(N'0000')NoFM_END_INV Allow NULL? 
6CIACCAssignment of FM account assignment to account is bindingchar10CHAR(N' ')YesFM_CIACC Allow NULL? 
7COACCAssignment of FM-CO account assignment is bindingchar10CHAR(N' ')YesFM_COACC Allow NULL? 
8FLG_PODATEDate purchase order was recordedchar10CHAR(N' ')YesFM_PODATE Allow NULL? 
9FLG_MWSTControl on recording of taxchar10CHAR(N' ')YesFM_MWST Allow NULL? 
10FLG_WEREGoods receipt/invoice receipt flagchar10CHAR(N' ')YesFM_WERE Allow NULL? 
11FLG_AUTOControl lines generated automaticallychar10CHAR(N' ')YesFM_AUTO Allow NULL? 
12FLG_INDATEDate invoice recordedchar10CHAR(N' ')YesFM_INDATE Allow NULL? 
13FLG_PADATEDate payment was recordedchar10CHAR(N' ')YesFM_PADATE Allow NULL? 
14FLG_PRDATEPurchase requisition update datechar10CHAR(N' ')YesFM_PRDATE Allow NULL? 
15FLG_WAKNTAcct asst type for goods issuechar10CHAR(N' ')YesFM_WAKNT Allow NULL? 
16FLG_BEKNTAccount assignment type for unassigned purchase orderschar10CHAR(N' ')YesFM_BEKNT Allow NULL? 
17FLG_PAYMPayment conversionchar10CHAR(N' ')YesFM_PAYM Allow NULL? 
18FLG_PAYM_RCActivate payment matchchar10CHAR(N' ')YesFM_PAYM_RC Allow NULL? 
19FLG_PAYM_RC_DELDelete Payments on Accounts Without Invoice Referencechar10CHAR(N' ')YesFM_PAYM_RC_DEL Allow NULL? 
20FLG_PAYM_RC_66Evaluate Expenditure Transfer Postings with Payment Matchingchar10CHAR(N' ')YesFLG_PAYM_RC_66 Allow NULL? 
21FLG_CFPAYDeactivate check on fiscal year changechar10CHAR(N' ')YesFM_CFPAY Allow NULL? 
22FLG_SPLITActivate Splitting Procedure for Payment Conversionchar10CHAR(N' ')YesFM_SPLIT Allow NULL? 
23FM_DP_DITActivate Conversion of Bank Clearings (80-90)char10CHAR(N' ')YesFM_DP_DIT Allow NULL? 
24CFLEV_OIUse commitment documents to determine carrforward levelchar10CHAR(N' ')YesFM_CFLEVOI Allow NULL? 
25CFLEV_FIUse invoices to determine carryforward levelchar10CHAR(N' ')YesFM_CFLEVFI Allow NULL? 
26FM_PAYM_FISTLFunds center for payment transfer without invoice ref.nvarchar160CHAR(N' ')YesFMFCTRFM_PAYM_FISTL Allow NULL? 
27FM_PAYM_FIPEXCommitment item for payment transfer without invoice ref.nvarchar240CHAR(N' ')YesFMCIFM_PAYM_FIPEX Allow NULL? 
28FM_MONTH_CLOSINGPeriod for period-end closingnvarchar20NUMC(N'00')YesFM_MONTH_CLOSING Allow NULL? 
29FM_YEAR_CLOSINGFiscal year for period-end closingnvarchar40NUMC(N'0000')YesFM_YEAR_CLOSING Allow NULL? 
30FM_PAYTR_PARALNumber of Parallel Processes for Payment Processingnvarchar20NUMC(N'00')YesFM_PAYTR_PARAL Allow NULL? 
31FM_PAYTR_DESTRFC Server Group for Parallel Background Processingnvarchar200CHAR(N' ')YesFM_PAYTR_DEST Allow NULL? 
32FM_PAYTR_SDOC_1Doc Interval for Preferred Handling of Parallelizationnvarchar100CHAR(N' ')YesFM_PAYTR_DOCS Allow NULL? 
33FM_PAYTR_EDOC_1Doc Interval for Preferred Handling of Parallelizationnvarchar100CHAR(N' ')YesFM_PAYTR_DOCS Allow NULL? 
34FM_PAYTR_NPARA_1Number of Parallel Processes for Payment Processingnvarchar20NUMC(N'00')YesFM_PAYTR_PARAL Allow NULL? 
35FM_PAYM_S200_NRCActivated RFFMS200 with Original Functionschar10CHAR(N' ')YesFM_PAYM_S200_NRC Allow NULL? 
36FM_PAYM_S200_RCActivated RFFMS200 with Enhanced Functionchar10CHAR(N' ')YesFM_PAYM_S200_RC Allow NULL? 
37PCACCActivity/component account assignment in PM order activatedchar10CHAR(N' ')YesFM_PCACC Allow NULL? 
38FM_USEREALIndicator: Use Real CO Object to derive FM Assignmentchar10CHAR(N' ')YesFM_USEREAL Allow NULL? 
39XSEC_CURRENCYCompany Code Currency Corresponding to FM Area Currencychar10CHAR(N' ')YesFM_CURRENCY Allow NULL? 
40FM_PAYM_CM_UPDControl Update of Credit Memoschar10CHAR(N' ')YesFM_PAYM_CMEM_UPD Allow NULL? 
41FLG_TAX_TO_GLAdjust Tax Update in GL to FMchar10CHAR(N' ')YesFM_FLG_TAX_TO_GL Allow NULL? 
42FLG_MULTIANNUALBudget for all Yearschar10CHAR(N' ')YesFM_MULTIANNUAL_FMUPDATE Allow NULL? 
43FLG_AK_PAYM_FICATransfer Payments on Account from Contract A/R & A/Pchar10CHAR(N' ')YesFLG_AK_PAYM_FICA Allow NULL? 
44FLG_AK_PAYM_FIARPayments on Account from Accts Payable/Receivable Accountingchar10CHAR(N' ')YesFLG_AK_PAYM_FIAR Allow NULL? 
45FLG_FM_CURTPAssign Local Currency of Company Codes to FM Areanvarchar20CHAR(N' ')YesFLG_FM_CURTP Allow NULL? 
46FLG_SDOR_UPDATEIndicator: Deactivate Sales Order Updatechar10CHAR(N' ')YesFM_SDOR_UPDATE Allow NULL? 
47FM_PAYM_PURActivates the Online Payment Update (document splitting)char10CHAR(N' ')YesFM_PAYM_PUR Allow NULL? 
48FM_DTACT_PUROnline Payment Update in FM: Activation Datenvarchar80DATS(N'00000000')YesFM_DTACT_PUR Allow NULL? 
49FM_PO_ADJ_INVAdjust Only Using Invoice Unit Pricechar10CHAR(N' ')YesFM_PO_ADJ_INV_ONLY Allow NULL? 
50FM_USE_INV_COMPLReduce Purchase Order if Final Invoice Selectedchar10CHAR(N' ')YesFM_USE_INV_COMPL Allow NULL? 
51FLG_BTC_CLCash Budget Management: Clearing posted in batchchar10CHAR(N' ')YesCBM_BTC_CL Allow NULL? 
NamePrimaryUniqueTypeColumns
FM01D~0YesYesCLUSTEREDAPPLC, FIKRS, 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