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

37 columns | Print definition?ERP 6.0  | TXGRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSEGAccounting Document Segment47TXGRPGroup Indicator for Tax Line Itemsnvarchar30
2BSETTax Data Document Segment8TXGRPGroup Indicator for Tax Line Itemsnvarchar30
3BSSEGAccounting Document Segment36TXGRPGroup Indicator for Tax Line Itemsnvarchar30
4FUDT_VDOCBSEGVerification Document Item with Additional Info36TXGRPGroup Indicator for Tax Line Itemsnvarchar30
5FUDT_VDOCBSEGEVVerification Document Item in the Entry View36TXGRPGroup Indicator for Tax Line Itemsnvarchar30
6FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)36TXGRPGroup Indicator for Tax Line Itemsnvarchar30
7FUDT_VDOCBSETTax Data Document Segment of Verification Document8TXGRPGroup Indicator for Tax Line Itemsnvarchar30
8FUDT_VDOCBSETHTax Data Document Segment of Verification Document(History)8TXGRPGroup Indicator for Tax Line Itemsnvarchar30
9GLPOS_C_CTFI Document: Entry View244TXGRPGroup Indicator for Tax Line Itemsnvarchar30
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items244TXGRPGroup Indicator for Tax Line Itemsnvarchar30
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items244TXGRPGroup Indicator for Tax Line Itemsnvarchar30
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items244TXGRPGroup Indicator for Tax Line Itemsnvarchar30
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type253TXGRPGroup Indicator for Tax Line Itemsnvarchar30
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type253TXGRPGroup Indicator for Tax Line Itemsnvarchar30
15P2CN_TAXPayroll result: Income Tax (CN)16TXGRPTax rate groupingnvarchar10
16T7CN10Tax Calculation for Casual Worker3TXGRPTax rate groupingnvarchar10
17T7CN11Tax Rate for Additional Tax3TXGRPTax rate groupingnvarchar10
TOPChina
18T7CN30Tax Withholding Fast Formula2TXGRPTax rate groupingnvarchar10
19T7CN31Special rule category3TXGRPTax rate groupingnvarchar10
TOPContract Accounts Receivable and Payable
20DFKKMOPItems in contract account document123TXGRPGrouping Key for Tax Itemsnvarchar60
21DFKKMOPKItems in contract account document27TXGRPGrouping Key for Tax Itemsnvarchar60
22DFKKOPItems in contract account document123TXGRPGrouping Key for Tax Itemsnvarchar60
23DFKKOPKItems in contract account document27TXGRPGrouping Key for Tax Itemsnvarchar60
24DFKKOP_REPOpen Items from FPO4129TXGRPGrouping Key for Tax Itemsnvarchar60
TOPData Retention Tool
25TXW_S_BSEGRetrieve BSEG from archive79TXGRPGroup Indicator for Tax Line Itemsnvarchar30
TOPFinancial Accounting
26EBSEGDoc.Segment of Fin.Accntng External Documents24TXGRPGroup Indicator for Tax Line Itemsnvarchar30
TOPIndia
27T7IN0PPersonnel area/subarea grouping for India6TXGRPPersonnel subarea grouping for Taxnvarchar20
28T7INT5Personnel subarea grouping for Tax2TXGRPPersonnel subarea grouping for Taxnvarchar20
TOPLocalization
29J_1ISER_BSEGTransaction table having the Invoices with Service Category18TXGRPGroup Indicator for Tax Line Itemsnvarchar30
TOPMalaysia
30T5LMDText for Tax office grouping for Malaysia3TXGRPIncome tax office grouping for Malaysianvarchar20
31T5LMOTax office grouping for Malaysia2TXGRPIncome tax office grouping for Malaysianvarchar20
32T5LTOTax office table for Malaysia5TXGRPIncome tax office grouping for Malaysianvarchar20
33T5LTPEmployer reference for tax4TXGRPIncome tax office grouping for Malaysianvarchar20
TOPPhilippines
34T7PH0APersonnel area and personnel sub area groupings6TXGRPTax groupingnvarchar40
35T7PHCTTax Grouping2TXGRPTax groupingnvarchar40
TOPProduct Cost Planning
36TCKH6Cost Component Groups - Texts4TXGRPName of Cost Component Groupnvarchar200
TOPRemaining Beverage - Obsolete Objects
37/BEV3/CH1030BSG1Document Segment CH Event Ledger Part138TXGRPGroup Indicator for Tax Line Itemsnvarchar30