SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

53 columns | Print definition?ERP 6.0  | LINETYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20100_T8G17Backup copy - T8G176LINETYPEnvarchar50
2FITDKWC_FSCLINESForm Structure: Lines7LINETYPELine Type in Formnvarchar10
3FITDKW_FSCLINES2Form Structure: Lines 2 (extended for new Zakat)7LINETYPELine Type in Form 2 (extended for new Zakat)nvarchar10
4FITDOMC_FSCLINESForm Structure: Lines (Oman)7LINETYPELine Type in Formnvarchar10
5FITDQAC_FSCLINESForm Structure: Lines7LINETYPELine Type in Formnvarchar10
6GLPOS_N_CTNew General Ledger: Line Item with Currency Type164LINETYPEItem categorynvarchar50
7GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type164LINETYPEItem categorynvarchar50
8IDSAU_FSCLINESForm Structure: Lines7LINETYPELine Type in Formnvarchar10
9MRP_REQ_LINEDate and Quantity Values for Change Requests9LINETYPELine Type of Change Request Line Recordnvarchar20
10REP_EAPS_DCOLN_CData Connector: Layout Customizing/Line Definition5LINETYPELine Typenvarchar10
TOPAccounting Interface
12GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)99LINETYPEItem categorynvarchar50
13GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)99LINETYPEItem categorynvarchar50
TOPActivity-Based Costing
14COTPLDEFCELLTemplate Cell Control2LINETYPETemplate Row Typesnvarchar10
15COTPLDEFLINETYPTemplate line types per application2LINETYPETemplate Row Typesnvarchar10
16COTPLLINETYPETemplate linetypes1LINETYPETemplate Row Typesnvarchar10
17COTPLLINETYPETTemplate line type texts2LINETYPETemplate Row Typesnvarchar10
TOPBusiness Consolidation
18UCF7000Flexible Upload: Method Categories2LINETYPEUpload: Row Type Indicatornvarchar10
TOPBusiness Object Builder
19SBMIGTTYPEMapping: Reference Type -> Table Type6LINETYPEName of Dictionary Typenvarchar300
TOPFund Accounting
20FMCCAVCAActual line item table46LINETYPEItem categorynvarchar50
21FMGLFLEXAGeneral Ledger: Actual Line Items43LINETYPEItem categorynvarchar50
22PSGLFLEXAGeneral Ledger: Actual Line Items47LINETYPEItem categorynvarchar50
TOPFunds Management
23FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60050LINETYPEItem categorynvarchar50
24FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60054LINETYPEItem categorynvarchar50
25FMFG_SAV_FMUSFGASaved FMUSFGA data for docs excluded from SL Repost for 60075LINETYPEItem categorynvarchar50
26FMSPLITAActual line item table53LINETYPEItem categorynvarchar50
27FMUSFGAActual line item table for US Federal Government.75LINETYPEItem categorynvarchar50
28FMUSFGFACTS1A4Actual line item table50LINETYPEItem categorynvarchar50
29FMUSFGFACTS2AActual line item table54LINETYPEItem categorynvarchar50
TOPGeneral Ledger Accounting
30FAGLFLEXAGeneral Ledger: Actual Line Items45LINETYPEItem categorynvarchar50
31FAGL_MIG_LINETYPDocument-Specific Item Category Assignment6LINETYPEItem categorynvarchar50
32GLFLEXAFlexible general ledger: Actual line items54LINETYPEItem categorynvarchar50
33T8G02Item categories1LINETYPEItem categorynvarchar50
34T8G02TItem categories2LINETYPEItem categorynvarchar50
35T8G16Allocation: internal key - item category (SAP)4LINETYPEItem categorynvarchar50
36T8G17Allocation: acct number - item type5LINETYPEItem categorynvarchar50
37T8G20Splitting Rule: Header Data5LINETYPEItem category of leading itemnvarchar50
38T8G21Splitting rule: Item categories to be processed5LINETYPEItem category to be processednvarchar50
39T8G21ASplitting rule: Base item categories5LINETYPEItem category to be processednvarchar50
40T8G22Splitting rule: Additional items5LINETYPEItem category from which the additional item pair is creatednvarchar50
41T8G28Item categories permitted per accounting transaction variant4LINETYPEItem categorynvarchar50
42T8G29Item categories permitted for each business transaction2LINETYPEItem categorynvarchar50
43T8G30AAcct determination key for doc splitting2LINETYPEItem categorynvarchar50
44T8G30ATAccount determination key description for doc splitting3LINETYPEItem categorynvarchar50
45T8G30BAcct determination for document splitting - accounts3LINETYPEItem categorynvarchar50
TOPGrantee Management
46GMIAActual Line Item Table68LINETYPEItem categorynvarchar50
47TE552Classification Indicator for Billing Line4LINETYPEIntended Purpose of Classification Linenvarchar20
TOPJoint Venture und Production Sharing Accounting
48JVGLFLEXAGeneral Ledger: Actual Line Items47LINETYPEItem categorynvarchar50
49IDCN_FSCLINESForm Structure: Lines7LINETYPELine Type in Formnvarchar10
TOPSAP Business Workflow
50SWF_TRC_HFILTTrace: Hierarchy Filter4LINETYPECondition Editor: Type of Line in Internal Displaynvarchar10
TOPSpecial Purpose Ledger
51/CCIS/PROFTAXAActual Line Items Table for General Ledger55LINETYPEItem categorynvarchar50
TOPTraders and Schedulers Workbench
52OIJ_EL_LAYT_EVLaytime start and end events7LINETYPEType of linenvarchar10
TOPTravel Expenses
53PTRV_CCCError Receipts for Credit Card Clearing3LINETYPELine Type in Credit Card Filenvarchar10