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

79 columns | Print definition?ERP 6.0  | EGRUP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item100EGRUPEquity groupnvarchar30
2/OPT/VIM_TITEMDocument Item100EGRUPEquity groupnvarchar30
3AUAASettlement Document: Receiver Segment22EGRUPEquity groupnvarchar30
4BSAD_BAKAccounting: Secondary index for customers (cleared items)177EGRUPEquity groupnvarchar30
5BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)179EGRUPEquity groupnvarchar30
6BSEGAccounting Document Segment211EGRUPEquity groupnvarchar30
7BSID_BAKAccounting: Secondary Index for Customers177EGRUPEquity groupnvarchar30
8BSIK_BAKAccounting: Secondary index for vendors179EGRUPEquity groupnvarchar30
9BSSEGAccounting Document Segment200EGRUPEquity groupnvarchar30
10FUDT_VDOCBSEGVerification Document Item with Additional Info200EGRUPEquity groupnvarchar30
11FUDT_VDOCBSEGEVVerification Document Item in the Entry View200EGRUPEquity groupnvarchar30
12FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)200EGRUPEquity groupnvarchar30
13GLPOS_C_CTFI Document: Entry View101EGRUPEquity groupnvarchar30
14GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items101EGRUPEquity groupnvarchar30
15GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items101EGRUPEquity groupnvarchar30
16GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items101EGRUPEquity groupnvarchar30
17GLPOS_N_CTNew General Ledger: Line Item with Currency Type103EGRUPEquity groupnvarchar30
18GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type103EGRUPEquity groupnvarchar30
19MHNDDunning Data60EGRUPEquity groupnvarchar30
20YVIM_1ITEMDocument Item100EGRUPEquity groupnvarchar30
TOPAccounting Interface
21GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)207EGRUPEquity groupnvarchar30
22GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)207EGRUPEquity groupnvarchar30
TOPActual CostingMaterial Ledger
23FCML_CCS_REPHDB Reporting Structure for ML17EGRUPCost Component Groupnvarchar20
TOPElectronic Bank Statement
24FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)50EGRUPEquity groupnvarchar30
25FEB_ACTAcct Assignment Templates50EGRUPEquity groupnvarchar30
TOPFinancial Accounting
26/OPT/VIM_1ITEMDocument Item100EGRUPEquity groupnvarchar30
27ACCTITCompressed Data from FI/CO Document79EGRUPEquity groupnvarchar30
28BSADAccounting: Secondary Index for Customers (Cleared Items)177EGRUPEquity groupnvarchar30
29BSAKAccounting: Secondary Index for Vendors (Cleared Items)179EGRUPEquity groupnvarchar30
30BSIDAccounting: Secondary Index for Customers177EGRUPEquity groupnvarchar30
31BSIKAccounting: Secondary Index for Vendors179EGRUPEquity groupnvarchar30
32EBSEGDoc.Segment of Fin.Accntng External Documents64EGRUPEquity groupnvarchar30
33KMZEIFI: Account Assignment Model Item Information42EGRUPEquity groupnvarchar30
34KOMUAccount Assignment Templates for G/L Account Items42EGRUPEquity groupnvarchar30
35VBSEGADocument Segment for Document Parking - Asset Database55EGRUPEquity groupnvarchar30
36VBSEGDDocument Segment for Customer Document Parking40EGRUPEquity groupnvarchar30
37VBSEGKDocument Segment for Vendor Document Parking45EGRUPEquity groupnvarchar30
38VBSEGSDocument Segment for Document Parking - G/L Account Database68EGRUPEquity groupnvarchar30
TOPFunds Management-Specific Postings
39FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years67EGRUPEquity groupnvarchar30
40PSOSEGDDocument Segment: Recurring Request, Customer41EGRUPEquity groupnvarchar30
41PSOSEGKRecurring Request Document Segment, Vendors46EGRUPEquity groupnvarchar30
42PSOSEGSRecurring Request Document Segment, G/L Accounts66EGRUPEquity groupnvarchar30
TOPGeneral Ledger Accounting
43BSEG_ADDEntry View of Accounting Document for Additional Ledgers40EGRUPEquity groupnvarchar30
44FAGL_SPLINFOSplittling Information of Open Items83EGRUPEquity groupnvarchar30
TOPGL Account Posting
45TCJ_POSITIONSCash Journal Document Items57EGRUPEquity groupnvarchar30
TOPJoint Venture und Production Sharing Accounting
46JVBXJV Billing Database (INDX-Table)12EGRUPEquity groupnvarchar30
47JVGLFLEX07General Ledger: Joint Venture Accounting Fields3EGRUPEquity groupnvarchar30
48JVGLFLEXAGeneral Ledger: Actual Line Items30EGRUPEquity groupnvarchar30
49JVGLFLEXPGeneral Ledger: Plan Line Items32EGRUPEquity groupnvarchar30
50JVGLFLEXTGeneral Ledger: Totals39EGRUPEquity groupnvarchar30
51PSAITPSA Document Items17EGRUPEquity groupnvarchar30
52PSCITPSC document line items17EGRUPEquity groupnvarchar30
53T8J2CCarried Interest4EGRUPEquity groupnvarchar30
54T8J4BJV Cash Call Batch table7EGRUPEquity groupnvarchar30
55T8J4DNon-op Billing Item Table (Deprecated -> replaced by T8J4H)5EGRUPEquity groupnvarchar30
56T8J4ENon-op bill user currency (Deprecated -> replaced by T8J4J)5EGRUPEquity groupnvarchar30
57T8J4FNon op Bill table assets (Deprecated -> replaced by T8J4I)5EGRUPEquity groupnvarchar30
58T8J4HNon-Op saved bills - Detail Info (for holding bills)5EGRUPEquity groupnvarchar30
59T8J4INon operated Billing Asset Tables (for holding bills)5EGRUPEquity groupnvarchar30
60T8J4JNon-Operated Billing User Currency Table (for holding bills)5EGRUPEquity groupnvarchar30
61T8J9AEquity Group - JOA level4EGRUPEquity Group - JOA levelnvarchar30
62T8J9BEquity Group Description - JOA level5EGRUPEquity Group - JOA levelnvarchar30
63T8J9CJoint operating agreement partner shares4EGRUPEquity Group - JOA levelnvarchar30
64T8JC2Funding Currency by Equity Group4EGRUPEquity groupnvarchar30
65T8JDDJV EDI Inbound: Property Table6EGRUPEquity groupnvarchar30
66T8JFInvestment Group4EGRUPEquity groupnvarchar30
67T8JFTInvestment Group Description5EGRUPEquity groupnvarchar30
68T8JGValid Investment Group6EGRUPEquity groupnvarchar30
69T8JIJoint Venture Inter-Company Ventures4EGRUPEquity groupnvarchar30
70T8JQJoint Venture Owner Equity4EGRUPEquity groupnvarchar30
71T8JSCJoint Venture Substitute Cost Object4EGRUPEquity groupnvarchar30
TOPLocalization
72J_3RFTAX_EXTRDTax Extract Detail Lines136EGRUPEquity groupnvarchar30
TOPProduct Cost Planning
73TCKH3Cost Components6EGRUPCost Component Groupnvarchar20
74TCKH6Cost Component Groups - Texts3EGRUPCost Component Groupnvarchar20
75TCKH7Cost Component Groups2EGRUPCost Component Groupnvarchar20
TOPProject Risk Management for Contractors
76/SAPPCE/JVA_T8JVE&C table for JVA master data4EGRUPEquity groupnvarchar30
TOPPurchasing
77EBKNPurchase Requisition Account Assignment65EGRUPEquity groupnvarchar30
78EKKNAccount Assignment in Purchasing Document75EGRUPEquity groupnvarchar30
TOPRemaining Beverage - Obsolete Objects
79/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1202EGRUPEquity groupnvarchar30