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

63 columns | Print definition?ERP 6.0  | SCNTR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances21SCNTRnvarchar100
2/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.22SCNTRnvarchar100
3/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs24SCNTRnvarchar100
4/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)24SCNTRnvarchar100
5FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT31SCNTRSender cost centernvarchar100
6FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT33SCNTRSender cost centernvarchar100
7FAGLFLEXT_BAKGeneral Ledger: Totals33SCNTRSender cost centernvarchar100
8FAGLFLEXT_DIFDelta Table: G/L Totals33SCNTRSender cost centernvarchar100
9ZSAWAActual line item table23SCNTRPartner cost centernvarchar100
10ZSAWPPlan line items table23SCNTRPartner cost centernvarchar100
11ZSAWTSummary table22SCNTRPartner cost centernvarchar100
12ZZ001AActual Line Item Table30SCNTRPartner cost centernvarchar100
13ZZ001PPlan Line Items Table30SCNTRPartner cost centernvarchar100
14ZZ001TSummary Table29SCNTRPartner cost centernvarchar100
15ZZSL01AActual line item table27SCNTRPartner cost centernvarchar100
16ZZSL01PPlan line items table27SCNTRPartner cost centernvarchar100
17ZZSL01TSummary table26SCNTRPartner cost centernvarchar100
TOPBasic Functions
18GGREFAExample for Global FI-SL Line Items (Actual)25SCNTRPartner cost centernvarchar100
19GGREFPExample for Global FI-SL Line Items (Plan)25SCNTRPartner cost centernvarchar100
20GGREFTExample for Global FI-SL Summary Table24SCNTRPartner cost centernvarchar100
21GLPO1Plan Line Items for Object Table32SCNTRCost Centernvarchar100
22GLPO2Plan Line Items for Object Table Global36SCNTRCost Centernvarchar100
23GLPO3Plan Line Items for Object Table32SCNTRCost Centernvarchar100
24GLREFAExample for Local FI-SL Line Items (Actual)23SCNTRPartner cost centernvarchar100
25GLREFPExample for Local FI-SL Line Items (Plan)23SCNTRPartner cost centernvarchar100
26GLREFTExample for Local FI-SL Summary Table22SCNTRPartner cost centernvarchar100
27GLREFUExample for FI-SL Rollup Line Items (Actual)24SCNTRPartner cost centernvarchar100
28GLREFVExample for Rollup FI-SL Line Items (Plan)24SCNTRPartner cost centernvarchar100
29GLSO1FI-SL Line Item Table with Objects for GLTO132SCNTRCost Centernvarchar100
30GLSO2FI-SL Table with Objects, Structure corresponds to GLS236SCNTRCost Centernvarchar100
31GLSO3FI-SL LI Table with Objects for GLTO332SCNTRCost Centernvarchar100
32GLTO1FI-SL Table with Objects, Structure Corresponds to GLT129SCNTRCost Centernvarchar100
33GLTO2FI-SL Table with Objects, Structure Corresponds to GLT233SCNTRCost Centernvarchar100
34GLTO3FISL Table with Objects, Amounts and Quantities in Format P929SCNTRCost Centernvarchar100
TOPCollectionsDisbursements
35GLISDEAActual Line Item Tables for Insurance (DE)37SCNTRPartner cost centernvarchar100
36GLISDEPPlan Line Item Table for Insurance (DE)37SCNTRPartner cost centernvarchar100
37GLISDETSummary Table for Insurance (DE)36SCNTRPartner cost centernvarchar100
38GRISDEAActual Line Item Table for Insurance (DE) - Rollup37SCNTRPartner cost centernvarchar100
39GRISDEPPlan Line Item Table for Insurance (DE) - Rollup37SCNTRPartner cost centernvarchar100
40GRISDETSummary Table for Insurance (DE) - Rollup36SCNTRPartner cost centernvarchar100
TOPFinancial Services Localization
41/CEEIS/RUAActual line item table31SCNTRPartner cost centernvarchar100
42/CEEIS/RUPPlan line items table31SCNTRPartner cost centernvarchar100
43/CEEIS/RUTTotals Table30SCNTRPartner cost centernvarchar100
TOPFunds Management
44FMSPLITAActual line item table28SCNTRPartner cost centernvarchar100
45FMSPLITPPlan line items table28SCNTRPartner cost centernvarchar100
46FMSPLITTSummary table29SCNTRPartner cost centernvarchar100
TOPGeneral Ledger Accounting
47FAGLFLEX06General ledger: Sender SAP additional account assignment2SCNTRSender cost centernvarchar100
48FAGLFLEXAGeneral Ledger: Actual Line Items24SCNTRSender cost centernvarchar100
49FAGLFLEXPGeneral Ledger: Plan Line Items26SCNTRSender cost centernvarchar100
50FAGLFLEXTGeneral Ledger: Totals33SCNTRSender cost centernvarchar100
51FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records25SCNTRSender cost centernvarchar100
52FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis23SCNTRSender cost centernvarchar100
53GLFLEX06General ledger: Sender SAP additional account assignment2SCNTRSender cost centernvarchar100
54GLFLEXAFlexible general ledger: Actual line items19SCNTRSender cost centernvarchar100
55GLFLEXPFlexible G/L: Plan line items19SCNTRSender cost centernvarchar100
56GLFLEXTFlexible G/L: Totals25SCNTRSender cost centernvarchar100
TOPJoint Venture und Production Sharing Accounting
57JVGLFLEX06General ledger: Sender SAP additional account assignment2SCNTRSender cost centernvarchar100
58JVGLFLEXAGeneral Ledger: Actual Line Items23SCNTRSender cost centernvarchar100
59JVGLFLEXPGeneral Ledger: Plan Line Items25SCNTRSender cost centernvarchar100
60JVGLFLEXTGeneral Ledger: Totals32SCNTRSender cost centernvarchar100
TOPTariffs, Duties and Permits
61OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger37SCNTRPartner cost centernvarchar100
62OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger37SCNTRPartner cost centernvarchar100
63OIHEDTSummary table, IS-OIL Excise Duty Special Ledger36SCNTRPartner cost centernvarchar100