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

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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

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
11ZSPLITAIsteinzelposten-Tabelle50LINETYPEPositionstypnvarchar50
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
TOPInvoicing
47TE552Classification Indicator for Billing Line4LINETYPEIntended Purpose of Classification Linenvarchar20
TOPJoint Venture und Production Sharing Accounting
48JVGLFLEXAGeneral Ledger: Actual Line Items47LINETYPEItem categorynvarchar50
TOPLocalization
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