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

95 tablesERP 6.0 

Logistics - General :: Logistics Basic Data :: Business Partners
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MDMCHP82MDM: Change events by incoming IDocsBusiness Partners
2ERP EHP76.0MDMCLASSIF31Account groups for vendor coming from MDSBusiness Partners
Logistics - General :: Logistics Basic Data :: Business Partners :: Customer Master
ProductVersionTableColumnsIndexesDescriptionModule
3ERP EHP76.0CRMCLASSIF31Account Groups in Replication into R/3Customer Master
4ERP EHP76.0CRMKNVVFIL21Indicator: Completely Filter Customer Data Relating to KNVVCustomer Master
5ERP EHP76.0CRMKTOKD51Assign Classification and Grouping R/3 Account GroupsCustomer Master
6ERP EHP76.0CRMKUNNR32Mapping Table Business Partner - CustomerCustomer Master
7ERP EHP76.0CRMPARNR43Mapping Table Business Partner Relationship - Contact PersonCustomer Master
8ERP EHP76.0CRMTEXTID52Mapping of Text IDs Between R/3 and CRMCustomer Master
9ERP EHP76.0DUEFL_TAB21Fixing of Source Status or DUEFL at Pre Step TimeCustomer Master
10ERP EHP76.0KNA11949General Data in Customer MasterCustomer Master
11ERP EHP76.0KNVA391Customer Master Unloading PointsCustomer Master
12ERP EHP76.0KNVK753Customer Master Contact PartnerCustomer Master
13ERP EHP76.0KNVV882Customer Master Sales DataCustomer Master
14ERP EHP76.0T686D41Contact Person: Responsibilities in SD: TextsCustomer Master
15ERP EHP76.0TB070T_CM51Tax Classification: Tax Types per Country, NamesCustomer Master
16ERP EHP76.0TB070_CM51Tax Classification: Tax Types per CountryCustomer Master
17ERP EHP76.0TB071_CM61Tax Classification: Assignment of Tax Groups to Tax TypesCustomer Master
18ERP EHP76.0TB072_CM71Tax Classification: Mapping R/3 <-> CRMCustomer Master
19ERP EHP76.0TB077_CM42Assignment of R/3 Field to CRM Tax TypeCustomer Master
20ERP EHP76.0TB078_CM51Assignment of R/3 Field Value to CRM Tax GroupCustomer Master
21ERP EHP76.0TBRC21Industry Code (Customer Master)Customer Master
22ERP EHP76.0TBRCT41Industry code text (customer master)Customer Master
23ERP EHP76.0TCONV_ADR111Conversion of Old Address Fields to CAM Address FieldsCustomer Master
24ERP EHP76.0TKUNDEBUKRS31Reference Customer per Company Code (Consumer Master)Customer Master
25ERP EHP76.0TKUNDEVTBER51Reference Customer per Sales Area (Consumer Master)Customer Master
26ERP EHP76.0TSAVX21Assignment of Key to Tables TSAV and TSADVCustomer Master
27ERP EHP76.0TVBO21Sales Rebate GroupsCustomer Master
28ERP EHP76.0TVBOT41Sales Rebate Groups: TextsCustomer Master
29ERP EHP76.0TVGF21Legal Status (Customer Master)Customer Master
30ERP EHP76.0TVGFT41Legal status text (customer master)Customer Master
31ERP EHP76.0TVIP31Contact Person: VIP IndicatorCustomer Master
32ERP EHP76.0TVIPT41Contact Person: Texts for the VIP codeCustomer Master
33ERP EHP76.0TVK021Attribute 10 (customer master)Customer Master
34ERP EHP76.0TVK0T41Attribute 10 texts (customer master)Customer Master
35ERP EHP76.0TVK121Attribute 1 (customer master)Customer Master
36ERP EHP76.0TVK1T41Attribute 1 texts (customer master)Customer Master
37ERP EHP76.0TVK221Attribute 2 (customer master)Customer Master
38ERP EHP76.0TVK2T41Atribute 2 texts (customer master)Customer Master
39ERP EHP76.0TVK321Attribute 3 (customer master)Customer Master
40ERP EHP76.0TVK3T41Attribute 3 texts (customer master)Customer Master
41ERP EHP76.0TVK421Attribute 4 (customer master)Customer Master
42ERP EHP76.0TVK4T41Attribute 4 texts (customer master)Customer Master
43ERP EHP76.0TVK521Attribute 5 (customer master)Customer Master
44ERP EHP76.0TVK5T41Attribute 5 texts (customer master)Customer Master
45ERP EHP76.0TVK621Attribute 6 (customer master)Customer Master
46ERP EHP76.0TVK6T41Attribute 6 texts (customer master)Customer Master
47ERP EHP76.0TVK721Attribute 7 (customer master)Customer Master
48ERP EHP76.0TVK7T41Attribute 7 texts (customer master)Customer Master
49ERP EHP76.0TVK821Attribute 8 (customer master)Customer Master
50ERP EHP76.0TVK8T41Attribute 8 texts (customer master)Customer Master
51ERP EHP76.0TVK921Attribute 9 (customer master)Customer Master
52ERP EHP76.0TVK9T41Attribute 9 texts (customer master)Customer Master
53ERP EHP76.0TVKGG21Customer Condition Groups (Customer Master)Customer Master
54ERP EHP76.0TVKGGT41Texts for Customer Condition Groups (Customer Master)Customer Master
55ERP EHP76.0TVKP51Reference Customer Determination for Consumer(s)Customer Master
56ERP EHP76.0TVMS221Materials: Status in Sales and DistributionCustomer Master
57ERP EHP76.0TVMST41Materials: SD Status: TextsCustomer Master
58ERP EHP76.0TVPH21Contact Person: HobbiesCustomer Master
59ERP EHP76.0TVPHT41Contact Person Hobbies: TextsCustomer Master
60ERP EHP76.0TVPR21Commission GroupsCustomer Master
61ERP EHP76.0TVPRT41Commission Group TextsCustomer Master
62ERP EHP76.0TVPV31Contact Person: Decision AuthorityCustomer Master
63ERP EHP76.0TVPVT41Contact Person Decision Authority: TextsCustomer Master
64ERP EHP76.0TVRL31Relevance of Bill of Material Items for SDCustomer Master
65ERP EHP76.0TVRLT41Relevance of Bill of Material Items for SDCustomer Master
66ERP EHP76.0TVSB21Shipping ConditionsCustomer Master
67ERP EHP76.0TVSBT41Shipping Conditions: TextsCustomer Master
68ERP EHP76.0TVWA301Customers: Goods receiving hours (default values)Customer Master
69ERP EHP76.0TVWAT41Customers: Goods Receiving Hours: TextsCustomer Master
Logistics - General :: Logistics Basic Data :: Business Partners :: Vendor Master
ProductVersionTableColumnsIndexesDescriptionModule
70ERP EHP76.0CDATA104Change DataVendor Master
71ERP EHP76.0CRMKTOKK51Role Cat. and Grouping of R/3 Acct Group Assgmnt (for Later)Vendor Master
72ERP EHP76.0CRMLIFNR32Mapping Table: Business Partner - VendorVendor Master
73ERP EHP76.0CRMROLECAT41Account Groups in Replication into R/3Vendor Master
74ERP EHP76.0ERP_VEND_APPLOG31Vendor API Application Log configurationVendor Master
75ERP EHP76.0LFLR41Vendor Master Record: Supply RegionsVendor Master
76ERP EHP76.0LFM1551Vendor master record purchasing organization dataVendor Master
77ERP EHP76.0LFM2471Vendor Master Record: Purchasing DataVendor Master
78ERP EHP76.0LFMH121Vendor hierarchyVendor Master
79ERP EHP76.0PDTC_T_EBELN21Table for Storing Data TemporarilyVendor Master
80ERP EHP76.0PDTC_T_MBLNR21Material Document NumberVendor Master
81ERP EHP76.0PDTC_T_WE_MA31Table for Storing Data TemporarilyVendor Master
82ERP EHP76.0TLHIOZ41Vendor hierarchy: allowed assignmentsVendor Master
83ERP EHP76.0TLHIT31Vendor Hierarchy CategoryVendor Master
84ERP EHP76.0TLHITT41Vendor hierarchy category (description)Vendor Master
85ERP EHP76.0TLHIZU41Vendor hierarchy: allowed account groupsVendor Master
86ERP EHP76.0TPAKL31Assignment of Partner Function to Account Group VendorVendor Master
87ERP EHP76.0TWYAZ21Price Marking AgreementVendor Master
88ERP EHP76.0TWYAZT41Price Marking AgreementVendor Master
89ERP EHP76.0WYT151Vendor SubrangeVendor Master
90ERP EHP76.0WYT1T51Vendor Sub-Range DescriptionVendor Master
91ERP EHP76.0WYT261Vendor-dependent char. value conversionVendor Master
92ERP EHP76.0WYT3131Partner FunctionsVendor Master
93ERP EHP76.0WYT4101Operative ControlVendor Master
94ERP EHP76.0WYT5251Changes to Vendor Master RecordVendor Master
95ERP EHP76.0WYT631Characteristics for characteristic value conversionVendor Master