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

41 columns | Print definition?ERP 6.0  | TAX_REG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CN/CTXSAPR0106Country/Region/Product Tax Group/Business Partner Tax Group4TAX_REGRegionnvarchar30
2/1CN/CTXSAPR0108Country/Region/Product Tax Group4TAX_REGRegionnvarchar30
3/1CN/CTXSAPX0100Country/Region4TAX_REGRegionnvarchar30
4/1CN/CTXSAPX0106Country/Region/Product Tax Group4TAX_REGRegionnvarchar30
5/1CN/CTXSAPX0146Country/Region/Product Tax Group4TAX_REGRegionnvarchar30
6/1CN/CTXSAPX0147Country/Region/Business Partner Tax Group4TAX_REGRegionnvarchar30
TOPCentral Part of Product Master
7CRMC_TAX_GROUPSales Taxes: Customizing3TAX_REGRegionnvarchar30
8CRMC_TAX_GROUP_TSales Taxes: Customizing4TAX_REGRegionnvarchar30
9CRMC_TAX_MAPR/3 to CRM Assignment Table for Taxes3TAX_REGRegionnvarchar30
10CRMC_TAX_MAP_BPBP Tax Classification of Conditions: Mapping R/3 <-> CRM3TAX_REGRegionnvarchar30
11CRMM_PR_TAXProduct Sales Tax4TAX_REGRegionnvarchar30
12CRMM_PR_TAXHProduct Sales Tax - History5TAX_REGRegionnvarchar30
TOPCustomer Master
13TB071_CMTax Classification: Assignment of Tax Groups to Tax Types3TAX_REGTax Classification: Regionnvarchar30
14TB072_CMTax Classification: Mapping R/3 <-> CRM3TAX_REGTax Classification: Regionnvarchar30
TOPGlobal Trade Services
15/SAPSLL/PRTAXLegal and Logistics Services: Product Master - Tax Groups5TAX_REGRegion Key for Tax Gruopsnvarchar30
16/SAPSLL/TLC_VATImport Turnover Tax Rates for Europe3TAX_REGRegion Key for Tax Gruopsnvarchar30
TOPSAP Business Partner
17BUT_FRG0011Business Partner: Tax Classification4TAX_REGRegionnvarchar30
18TB071Define Business Partner Tax Groups3TAX_REGRegionnvarchar30
19TB071_TDefine Business Partner Tax Groups4TAX_REGRegionnvarchar30
TOPTransaction Tax Engine
20TTE2C_BPTXGRPBusiness Partner Tax Group3TAX_REGRegionnvarchar30
21TTE2C_BPTXGRP_TDescription for Business Partner Tax Group4TAX_REGRegionnvarchar30
22TTE2C_PRTXGRPProduct Tax Group3TAX_REGRegionnvarchar30
23TTE2C_PRTXGRP_TProduct Tax Group Description4TAX_REGRegionnvarchar30
24TTEC_AUTHORITYTax Authority3TAX_REGRegionnvarchar30
25TTEC_AUTHORITY_TTax Authority4TAX_REGRegionnvarchar30
26TTEC_DEDREAS[Obsolete] Deductibility Reason4TAX_REGRegionnvarchar30
27TTEC_DEDREAS_T[Obsolete] Description for Deductibility Reason5TAX_REGRegionnvarchar30
28TTEC_EXEMPREASExemption reason3TAX_REGRegionnvarchar30
29TTEC_EXEMPREAS_TExemption reason4TAX_REGRegionnvarchar30
30TTEC_FISCCODEFiscal Code3TAX_REGRegionnvarchar30
31TTEC_FISCCODE_TDescription Fiscal Code4TAX_REGRegionnvarchar30
32TTEC_PATXGRPPartner Tax Group4TAX_REGRegionnvarchar30
33TTEC_PATXGRP_TDescription for Partner Tax Group5TAX_REGRegionnvarchar30
34TTEC_PRTXGRPProduct Tax Group4TAX_REGRegionnvarchar30
35TTEC_PRTXGRP_TProduct Tax Group Description5TAX_REGRegionnvarchar30
36TTEC_TAX_REGTax Region3TAX_REGRegionnvarchar30
37TTEC_TAX_REG_TTax Region Name4TAX_REGRegionnvarchar30
38TTEC_USAGE[Obsolete] Usage3TAX_REGRegionnvarchar30
39TTEC_USAGE_T[Obsolete] Usage Description4TAX_REGRegionnvarchar30
40TTEM_BPTXGRP2Mapping: Business Partner Tax Group5TAX_REGRegionnvarchar30
41TTEM_PRTXGRP2Mapping: Product Tax Group5TAX_REGRegionnvarchar30