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

67 tablesERP 6.0 

Logistics - General :: Logistics Basic Data :: Business Partners :: Customer Master
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CRMCLASSIF31Account Groups in Replication into R/3Customer Master
2ERP EHP76.0CRMKNVVFIL21Indicator: Completely Filter Customer Data Relating to KNVVCustomer Master
3ERP EHP76.0CRMKTOKD51Assign Classification and Grouping R/3 Account GroupsCustomer Master
4ERP EHP76.0CRMKUNNR32Mapping Table Business Partner - CustomerCustomer Master
5ERP EHP76.0CRMPARNR43Mapping Table Business Partner Relationship - Contact PersonCustomer Master
6ERP EHP76.0CRMTEXTID52Mapping of Text IDs Between R/3 and CRMCustomer Master
7ERP EHP76.0DUEFL_TAB21Fixing of Source Status or DUEFL at Pre Step TimeCustomer Master
8ERP EHP76.0KNA11949General Data in Customer MasterCustomer Master
9ERP EHP76.0KNVA391Customer Master Unloading PointsCustomer Master
10ERP EHP76.0KNVK753Customer Master Contact PartnerCustomer Master
11ERP EHP76.0KNVV882Customer Master Sales DataCustomer Master
12ERP EHP76.0T686D41Contact Person: Responsibilities in SD: TextsCustomer Master
13ERP EHP76.0TB070T_CM51Tax Classification: Tax Types per Country, NamesCustomer Master
14ERP EHP76.0TB070_CM51Tax Classification: Tax Types per CountryCustomer Master
15ERP EHP76.0TB071_CM61Tax Classification: Assignment of Tax Groups to Tax TypesCustomer Master
16ERP EHP76.0TB072_CM71Tax Classification: Mapping R/3 <-> CRMCustomer Master
17ERP EHP76.0TB077_CM42Assignment of R/3 Field to CRM Tax TypeCustomer Master
18ERP EHP76.0TB078_CM51Assignment of R/3 Field Value to CRM Tax GroupCustomer Master
19ERP EHP76.0TBRC21Industry Code (Customer Master)Customer Master
20ERP EHP76.0TBRCT41Industry code text (customer master)Customer Master
21ERP EHP76.0TCONV_ADR111Conversion of Old Address Fields to CAM Address FieldsCustomer Master
22ERP EHP76.0TKUNDEBUKRS31Reference Customer per Company Code (Consumer Master)Customer Master
23ERP EHP76.0TKUNDEVTBER51Reference Customer per Sales Area (Consumer Master)Customer Master
24ERP EHP76.0TSAVX21Assignment of Key to Tables TSAV and TSADVCustomer Master
25ERP EHP76.0TVBO21Sales Rebate GroupsCustomer Master
26ERP EHP76.0TVBOT41Sales Rebate Groups: TextsCustomer Master
27ERP EHP76.0TVGF21Legal Status (Customer Master)Customer Master
28ERP EHP76.0TVGFT41Legal status text (customer master)Customer Master
29ERP EHP76.0TVIP31Contact Person: VIP IndicatorCustomer Master
30ERP EHP76.0TVIPT41Contact Person: Texts for the VIP codeCustomer Master
31ERP EHP76.0TVK021Attribute 10 (customer master)Customer Master
32ERP EHP76.0TVK0T41Attribute 10 texts (customer master)Customer Master
33ERP EHP76.0TVK121Attribute 1 (customer master)Customer Master
34ERP EHP76.0TVK1T41Attribute 1 texts (customer master)Customer Master
35ERP EHP76.0TVK221Attribute 2 (customer master)Customer Master
36ERP EHP76.0TVK2T41Atribute 2 texts (customer master)Customer Master
37ERP EHP76.0TVK321Attribute 3 (customer master)Customer Master
38ERP EHP76.0TVK3T41Attribute 3 texts (customer master)Customer Master
39ERP EHP76.0TVK421Attribute 4 (customer master)Customer Master
40ERP EHP76.0TVK4T41Attribute 4 texts (customer master)Customer Master
41ERP EHP76.0TVK521Attribute 5 (customer master)Customer Master
42ERP EHP76.0TVK5T41Attribute 5 texts (customer master)Customer Master
43ERP EHP76.0TVK621Attribute 6 (customer master)Customer Master
44ERP EHP76.0TVK6T41Attribute 6 texts (customer master)Customer Master
45ERP EHP76.0TVK721Attribute 7 (customer master)Customer Master
46ERP EHP76.0TVK7T41Attribute 7 texts (customer master)Customer Master
47ERP EHP76.0TVK821Attribute 8 (customer master)Customer Master
48ERP EHP76.0TVK8T41Attribute 8 texts (customer master)Customer Master
49ERP EHP76.0TVK921Attribute 9 (customer master)Customer Master
50ERP EHP76.0TVK9T41Attribute 9 texts (customer master)Customer Master
51ERP EHP76.0TVKGG21Customer Condition Groups (Customer Master)Customer Master
52ERP EHP76.0TVKGGT41Texts for Customer Condition Groups (Customer Master)Customer Master
53ERP EHP76.0TVKP51Reference Customer Determination for Consumer(s)Customer Master
54ERP EHP76.0TVMS221Materials: Status in Sales and DistributionCustomer Master
55ERP EHP76.0TVMST41Materials: SD Status: TextsCustomer Master
56ERP EHP76.0TVPH21Contact Person: HobbiesCustomer Master
57ERP EHP76.0TVPHT41Contact Person Hobbies: TextsCustomer Master
58ERP EHP76.0TVPR21Commission GroupsCustomer Master
59ERP EHP76.0TVPRT41Commission Group TextsCustomer Master
60ERP EHP76.0TVPV31Contact Person: Decision AuthorityCustomer Master
61ERP EHP76.0TVPVT41Contact Person Decision Authority: TextsCustomer Master
62ERP EHP76.0TVRL31Relevance of Bill of Material Items for SDCustomer Master
63ERP EHP76.0TVRLT41Relevance of Bill of Material Items for SDCustomer Master
64ERP EHP76.0TVSB21Shipping ConditionsCustomer Master
65ERP EHP76.0TVSBT41Shipping Conditions: TextsCustomer Master
66ERP EHP76.0TVWA301Customers: Goods receiving hours (default values)Customer Master
67ERP EHP76.0TVWAT41Customers: Goods Receiving Hours: TextsCustomer Master