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

53 columns | Print definition?ERP 6.0  | TELF1

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20305_CEPCSAP LT: Backup table of CEPC28TELF1First telephone numbernvarchar160
2CNV_20800_KNVKCNV backup copy: Customer master contact person13TELF1First telephone numbernvarchar160
3J_1GWTR0Vendor Tax Data13TELF1First telephone numbernvarchar160
4ZEIM_VBAKSales Document: Header Data45TELF1Telephone Numbernvarchar160
TOPAccounts Receivable Accounting Process Integration
5FDM_CONTACT_BUFPersonalization of Contact Person Data8TELF1Telephone Number of Contact Person at Business Partnernvarchar300
TOPAddress ManagementBusiness Address
6SADRAddress Management: Company Data25TELF1Addresses: telephone no.nvarchar300
TOPAdvertising Management
7JHAKIS-M/AM: Order-Publishing-Media (Header Data)110TELF1Telephone Numbernvarchar160
8JHAPIS-M/AM: Order-Publishing-Media Item121TELF1Telephone Numbernvarchar160
TOPBank Customer Accounts
9BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA122TELF11st telephone number of contact personnvarchar250
TOPBasic Data
10TN01IS-H: Institutions13TELF1Telephone Numbernvarchar160
TOPBasis Components
11ZCUSTOMER_IDESCustomer Master (IDES Demo)11TELF1First telephone numbernvarchar160
TOPBusiness Partner
12TIVBPVENDORGENVendor Preassignment (General Data)29TELF1First telephone numbernvarchar160
TOPBusiness Partner Enhancements for Financial Services
13BP030BP: Business partner - address17TELF1First telephone numbernvarchar160
TOPClinical System
14N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle45TELF1IS-H: Telefonnvarchar300
15N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle46TELF1IS-H: Telefonnvarchar300
16N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal46TELF1IS-H: Telefonnvarchar300
TOPControlling
17CSKSCost Center Master Data48TELF1First telephone numbernvarchar160
TOPCross-Application Components
18BC490KKNA1General data in customer master11TELF1First telephone numbernvarchar160
19KKNA1General Data in Customer Master11TELF1First telephone numbernvarchar160
20SKNA1Customer Master table for BC417 Course11TELF1First telephone numbernvarchar160
21SKNVKCustomer Master Contact table for BC417 Course12TELF1First telephone numbernvarchar160
22VVBAKSales Document: Header Data45TELF1Telephone Numbernvarchar160
TOPCustomer Master
23KNA1General Data in Customer Master11TELF1First telephone numbernvarchar160
24KNVKCustomer Master Contact Partner12TELF1First telephone numbernvarchar160
TOPCustomizing Tools Techniques
25ZC009Information for city4TELF1First telephone numbernvarchar160
TOPFinancial Accounting
26LFA1Vendor Master (General Section)46TELF1First telephone numbernvarchar160
TOPInformation System
27DKKOSBalance Audit Trail38TELF1First telephone numbernvarchar160
28DKOKSOpen Item Account Balance Audit Trail Master Record40TELF1First telephone numbernvarchar160
TOPLocalization
29J_1BNFDOCNota Fiscal Header82TELF1Addresses: telephone no.nvarchar300
30J_1BNFNADNota Fiscal partners22TELF1Addresses: telephone no.nvarchar300
TOPMaster Data
31JGTSADRIS-M: Extended Address Management73TELF1IS-M: Additional Fax Numbernvarchar160
32T012House Banks6TELF1First telephone numbernvarchar160
TOPOverhead Cost Controlling
33CMDT_ADRGeneric Master Record: Address21TELF1First telephone numbernvarchar160
TOPPatient Management
34NPATIS-H: Patient Master Data (General)35TELF1IS-H: Patient Telephone Numbernvarchar160
35NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)26TELF1IS-H: Patient Telephone Numbernvarchar160
TOPPendulum List Indirect Sales
36/BEV4/PLDUMKDNConversion Table Customer/Object Numbers18TELF1First telephone numbernvarchar160
TOPPeriodical Sales and Distribution
37JKAKSales Order Header Data31TELF1Telephone Numbernvarchar160
38JKAKPRAd Pre-Print Order: Header Data16TELF1Telephone Numbernvarchar160
39JVTZAEM2Sales Order Header Data33TELF1Telephone Numbernvarchar160
TOPProfit Center Accounting
40CEPCProfit Center Master Data Table28TELF1First telephone numbernvarchar160
TOPPurchasing
41EINAPurchasing Info Record: General Data16TELF1Vendor's Telephone Numbernvarchar160
42EKKOPurchasing Document Header38TELF1Vendor's Telephone Numbernvarchar160
TOPReceivablesPayment Management
43TZB21TName of Clerk (Processing Group)5TELF1First telephone numbernvarchar160
TOPRecycling Administration Core Functions
44J_7LSADRAddress Management: Company Data25TELF1Addresses: telephone no.nvarchar300
TOPRemaining Beverage - Obsolete Objects
45/BEV1/CLDEBCustomer Information20TELF1First telephone numbernvarchar160
46/BEV1/RBVBAKSales Document: Header Data45TELF1Telephone Numbernvarchar160
TOPSales
47VBAKSales Document: Header Data45TELF1Telephone Numbernvarchar160
TOPSales Promotions
48SADLSTRECBDynamic Part of Address List (Record Body)51TELF1Addresses: telephone no.nvarchar300
TOPShipping
49DVK01R/2-R/3 Link: Delivery Header Data R2 -> R319TELF1First telephone numbernvarchar160
TOPSimulation
50VSVBAK_CNVersion: Sales document: Header data46TELF1Telephone Numbernvarchar160
TOPTreasury
51VZKNA1Collector for batch input KNA1 from RF-VV36TELF1First telephone numbernvarchar160
TOPVendor Master
52LFM1Vendor master record purchasing organization data11TELF1Vendor's telephone numbernvarchar160
53LFM2Vendor Master Record: Purchasing Data13TELF1Vendor's telephone numbernvarchar160