SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7FCO_DOC_HEAD61Failure Cost Document Header
8FMIA65Actual Line Item Table for Funds Management
9/OPT/Z1344Reporting table: Text table for exception definitions
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OCRD332Business Partner
3OINV386A/R Invoice
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OUSR101Users

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OPCH268A/P Invoice
4OIVL77Whse Journal
5OSRN20Serial Numbers Master Data
6OVPM154Outgoing Payments
7ORCT154Incoming Payment
8OOCR9Loading Factors
9OBOT10Bill Of Exchang Transaction
10JDT1110Journal Entry - Rows
PHPRef.com - the webs number one PHP Function reference tool
Financial Accounting :: General Ledger Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FAGL_ACTIVEC201Activation of New General LedgerGeneral Ledger Accounting
SQL:  selectupdate insert create

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

SELECT MANDT, ACTIVE, WRITE_GLT0, READ_GLT0, SPLITMETHD, SPLITDATE_CHECK, SPLITDATE_ACTIVE, FAREA_FROM_COBL, FAREA_DRV_ALWAYS, FAREA_IN_CO_SUM, SGMNT_IN_CO_SUM, CO_SUM_DATE_FROM, FAREA_OBLIGATORY, SEGMENT_PRCTR_MD, SPLIT_INHERIDITY, SPLIT_DEFAULT, SPLIT_DEF_CONST, FLG_CUM_PLN_ACT, FAGL_HCM_COMP_EN, FAGL_NO_COMP_SD FROM FAGL_ACTIVEC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2ACTIVEIndicator: New General Ledger Accounting Is Activechar10CHAR(N' ')YesFAGL_GLFLEX_ACTIVE Allow NULL? 
3WRITE_GLT0Continue to Update Classic General Ledgerchar10CHAR(N' ')YesFAGL_WRITE_GLT0 Allow NULL? 
4READ_GLT0Read Classic Gen. Ledger (GLT0) Instead of New Gen. Ledgerchar10CHAR(N' ')YesFAGL_READ_GLT0 Allow NULL? 
5SPLITMETHDDocument Splitting Methodnvarchar100CHAR(N' ')YesT8G01SPLITMETHD Allow NULL? 
6SPLITDATE_CHECKSystem Date from which Document Splitting Is Checkednvarchar80DATS(N'00000000')YesFAGL_SPLITDATE_CHECK Allow NULL? 
7SPLITDATE_ACTIVESystem Date from which Document Splitting Is Activenvarchar80DATS(N'00000000')YesFAGL_SPLITDATE_ACTIVE Allow NULL? 
8FAREA_FROM_COBLDetermine Functional Area on Entry Screenchar10CHAR(N' ')YesFAGL_FAREA_FROM_COBL Allow NULL? 
9FAREA_DRV_ALWAYSAlways Determine Functional Area Automaticallychar10CHAR(N' ')YesFAREA_DRV_ALWAYS Allow NULL? 
10FAREA_IN_CO_SUMIndicator: Update Functional Area in CO Totals Tableschar10CHAR(N' ')YesFAGL_FAREA_IN_CO_SUMMTAB Allow NULL? 
11SGMNT_IN_CO_SUMIndicator: Update Segment in CO Totals Tableschar10CHAR(N' ')YesFAGL_SEGMENT_IN_CO_SUMMTAB Allow NULL? 
12CO_SUM_DATE_FROMFrom Date: For Updating CO Totals Tablesnvarchar80DATS(N'00000000')YesFAGL_CO_SUMMTAB_DATE_FROM Allow NULL? 
13FAREA_OBLIGATORYIndicator: Functional Area Is Mandatorychar10CHAR(N' ')YesFAGL_FAREA_OBLIGATORY Allow NULL? 
14SEGMENT_PRCTR_MDIndicator:Changes Possible to Segment in PrCtr Master Recordchar10CHAR(N' ')YesFAGL_SEGMENT_IN_PRCTR_MD Allow NULL? 
15SPLIT_INHERIDITYInheritance of Account Assignments in Document Splitchar10CHAR(N' ')YesFAGL_SPL_INHERIT Allow NULL? 
16SPLIT_DEFAULTStandard Account Assignment in Document Splittingchar10CHAR(N' ')YesFAGL_SPL_DEFAULT Allow NULL? 
17SPLIT_DEF_CONSTConstants for document splittingnvarchar50CHAR(N' ')YesT8G41AGLCONST Allow NULL? 
18FLG_CUM_PLN_ACTIndicator: Cumulative Display of Plan Datachar10CHAR(N' ')YesFAGL_CUMULATIVE_PLANNING_ACTIV Allow NULL? 
19FAGL_HCM_COMP_ENHCM Integration: Compress Entry Viewchar10CHAR(N' ')YesFAGL_HCM_COMP_ENTRY_VIEW Allow NULL? 
20FAGL_NO_COMP_SDDocument Splitting: Do Not Summarize SD Tax Itemschar10CHAR(N' ')YesFAGL_NO_COMPRESS_SD_TAX Allow NULL? 
NamePrimaryUniqueTypeColumns
FAGL_ACTIVEC~0YesYesCLUSTEREDMANDT