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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

59 columns | Print definition?ERP 6.0  | PSEGMENT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items110PSEGMENTnvarchar100
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact110PSEGMENTnvarchar100
3/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances26PSEGMENTnvarchar100
4/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items154PSEGMENTnvarchar100
5/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.27PSEGMENTnvarchar100
6/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs29PSEGMENTnvarchar100
7/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)29PSEGMENTnvarchar100
8BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)73PSEGMENTPartner Segment for Segmental Reportingnvarchar100
9BSEGAccounting Document Segment319PSEGMENTPartner Segment for Segmental Reportingnvarchar100
10BSIS_BAKAccounting: Secondary Index for G/L Accounts73PSEGMENTPartner Segment for Segmental Reportingnvarchar100
11FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)73PSEGMENTPartner Segment for Segmental Reportingnvarchar100
12FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts73PSEGMENTPartner Segment for Segmental Reportingnvarchar100
13FAGLFLEXCEMU: Sum of Open Items of Table FAGLFLEXT36PSEGMENTPartner Segment for Segmental Reportingnvarchar100
14FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT38PSEGMENTPartner Segment for Segmental Reportingnvarchar100
15FAGLFLEXT_BAKGeneral Ledger: Totals38PSEGMENTPartner Segment for Segmental Reportingnvarchar100
16FAGLFLEXT_DIFDelta Table: G/L Totals38PSEGMENTPartner Segment for Segmental Reportingnvarchar100
17FUDT_VDOCBSEGVerification Document Item with Additional Info308PSEGMENTPartner Segment for Segmental Reportingnvarchar100
18FUDT_VDOCBSEGEVVerification Document Item in the Entry View308PSEGMENTPartner Segment for Segmental Reportingnvarchar100
19FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)308PSEGMENTPartner Segment for Segmental Reportingnvarchar100
20GLPOS_C_CTFI Document: Entry View203PSEGMENTPartner Segment for Segmental Reportingnvarchar100
21GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items203PSEGMENTPartner Segment for Segmental Reportingnvarchar100
22GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items203PSEGMENTPartner Segment for Segmental Reportingnvarchar100
23GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items203PSEGMENTPartner Segment for Segmental Reportingnvarchar100
24GLPOS_N_CTNew General Ledger: Line Item with Currency Type208PSEGMENTPartner Segment for Segmental Reportingnvarchar100
25GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type208PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPAccounting Interface
26GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)414PSEGMENTPartner Segment for Segmental Reportingnvarchar100
27GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)414PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPControlling
28COKEY2CO Key Subnumbers Enhancement Table10PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPFinancial Accounting
29ACCTITCompressed Data from FI/CO Document157PSEGMENTPartner Segment for Segmental Reportingnvarchar100
30BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)73PSEGMENTPartner Segment for Segmental Reportingnvarchar100
31BSISAccounting: Secondary Index for G/L Accounts73PSEGMENTPartner Segment for Segmental Reportingnvarchar100
32FBICRC003AICRC: Open Items Customers/Vendors: Documents46PSEGMENTPartner Segment for Segmental Reportingnvarchar100
33KOMUAccount Assignment Templates for G/L Account Items96PSEGMENTPartner Segment for Segmental Reportingnvarchar100
34VBSEGADocument Segment for Document Parking - Asset Database72PSEGMENTPartner Segment for Segmental Reportingnvarchar100
35VBSEGSDocument Segment for Document Parking - G/L Account Database140PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPGeneral Ledger Accounting
36BSEG_ADDEntry View of Accounting Document for Additional Ledgers74PSEGMENTPartner Segment for Segmental Reportingnvarchar100
37FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)73PSEGMENTPartner Segment for Segmental Reportingnvarchar100
38FAGLBSISAccounting: Secondary Index for G/L Accounts73PSEGMENTPartner Segment for Segmental Reportingnvarchar100
39FAGLFLEX06General ledger: Sender SAP additional account assignment7PSEGMENTPartner Segment for Segmental Reportingnvarchar100
40FAGLFLEXAGeneral Ledger: Actual Line Items29PSEGMENTPartner Segment for Segmental Reportingnvarchar100
41FAGLFLEXPGeneral Ledger: Plan Line Items31PSEGMENTPartner Segment for Segmental Reportingnvarchar100
42FAGLFLEXTGeneral Ledger: Totals38PSEGMENTPartner Segment for Segmental Reportingnvarchar100
43FAGL_BW_LOG_TOTLFI-GL: Log for BW Extraction: Totals Records30PSEGMENTPartner Segment for Segmental Reportingnvarchar100
44FAGL_QUEUE_LOGLog of Delta Queue for Error Analysis28PSEGMENTPartner Segment for Segmental Reportingnvarchar100
45FAGL_SPLINFOSplittling Information of Open Items16PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPGeneral Ledger Reorganization
46FAGL_R_APARReorganization: Object List for Receivables and Payables18PSEGMENTPartner Segment for Segmental Reportingnvarchar100
47FAGL_R_BLNCEReorganization: Balances to Be Transferred27PSEGMENTPartner Segment for Segmental Reportingnvarchar100
48FAGL_R_MAP_SAPReorganization: Object Number of the Included SAP Fields7PSEGMENTPartner Segment for Segmental Reportingnvarchar100
49FAGL_R_SPLReorganization: Splitting Information of the Open Items15PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPGL Account Posting
50TCJ_POSITIONSCash Journal Document Items97PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPJoint Venture und Production Sharing Accounting
51JVGLFLEX06General ledger: Sender SAP additional account assignment7PSEGMENTPartner Segment for Segmental Reportingnvarchar100
52JVGLFLEXAGeneral Ledger: Actual Line Items28PSEGMENTPartner Segment for Segmental Reportingnvarchar100
53JVGLFLEXPGeneral Ledger: Plan Line Items30PSEGMENTPartner Segment for Segmental Reportingnvarchar100
54JVGLFLEXTGeneral Ledger: Totals37PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPOverhead Cost Controlling
55COEJCO Object: Line Items (by Fiscal Year)197PSEGMENTPartner Segment for Segmental Reportingnvarchar100
56COEPCO Object: Line Items (by Period)76PSEGMENTPartner Segment for Segmental Reportingnvarchar100
57COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis78PSEGMENTPartner Segment for Segmental Reportingnvarchar100
TOPProfitability Analysis
58CECOEJCO-PA Account Based Line Items199PSEGMENTPartner Segment for Segmental Reportingnvarchar100
59CECOEPCO-PA Account Based Line Items78PSEGMENTPartner Segment for Segmental Reportingnvarchar100