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

22 columns | Print definition?ERP 6.0  | TAX_CTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPCentral Part of Product Master
1CRMC_TAX_GROUPSales Taxes: Customizing2TAX_CTYCountrynvarchar30
2CRMC_TAX_GROUP_TSales Taxes: Customizing3TAX_CTYCountrynvarchar30
3CRMC_TAX_MAPR/3 to CRM Assignment Table for Taxes2TAX_CTYCountrynvarchar30
4CRMC_TAX_MAP_BPBP Tax Classification of Conditions: Mapping R/3 <-> CRM2TAX_CTYCountrynvarchar30
5CRMC_TAX_TCODEAssignment of Tax Scale Code to a Country2TAX_CTYCountrynvarchar30
6CRMC_TAX_TCODE_TDescription for Assignment of Tax Scale Code to a Country3TAX_CTYCountrynvarchar30
7CRMM_PR_TAXProduct Sales Tax3TAX_CTYCountrynvarchar30
8CRMM_PR_TAXHProduct Sales Tax - History4TAX_CTYCountrynvarchar30
TOPCountry-Specific Objects
9COMC_R3_FIELDSAssignment of R/3 material master fields to CFOP tax classif3TAX_CTYCountrynvarchar30
TOPCustomer Master
10TB070T_CMTax Classification: Tax Types per Country, Names3TAX_CTYTax Classification: Countrynvarchar30
11TB070_CMTax Classification: Tax Types per Country2TAX_CTYTax Classification: Countrynvarchar30
12TB071_CMTax Classification: Assignment of Tax Groups to Tax Types2TAX_CTYTax Classification: Countrynvarchar30
13TB072_CMTax Classification: Mapping R/3 <-> CRM2TAX_CTYTax Classification: Countrynvarchar30
14TB077_CMAssignment of R/3 Field to CRM Tax Type2TAX_CTYTax Classification: Countrynvarchar30
15TB078_CMAssignment of R/3 Field Value to CRM Tax Group2TAX_CTYTax Classification: Countrynvarchar30
TOPGlobal Trade Services
16/SAPSLL/PRTAXLegal and Logistics Services: Product Master - Tax Groups4TAX_CTYCountry Key for Tax Groupsnvarchar30
17/SAPSLL/TLC_VATImport Turnover Tax Rates for Europe2TAX_CTYCountry Key for Tax Groupsnvarchar30
TOPSAP Business Partner
18BUT_FRG0011Business Partner: Tax Classification3TAX_CTYCountrynvarchar30
19TB070Tax Classification: Tax Types per Country2TAX_CTYCountrynvarchar30
20TB070TTax Classification: Tax Types per Country, Descriptions3TAX_CTYCountrynvarchar30
21TB071Define Business Partner Tax Groups2TAX_CTYCountrynvarchar30
22TB071_TDefine Business Partner Tax Groups3TAX_CTYCountrynvarchar30