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

47 columns | Print definition?ERP 6.0  | TELFX

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/SH_PGRPTable for ERP Search Help Purchasing Groups6TELFXFax Numbernvarchar310
2CNV_20305_CEPCSAP LT: Backup table of CEPC30TELFXFax Numbernvarchar310
TOPAddress ManagementBusiness Address
3SADRAddress Management: Company Data27TELFXFax numbernvarchar310
TOPAdvertising Management
4JHAKIS-M/AM: Order-Publishing-Media (Header Data)111TELFXFax Numbernvarchar310
5JHAPIS-M/AM: Order-Publishing-Media Item122TELFXFax Numbernvarchar310
TOPBank Customer Accounts
6BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA125TELFXFax numbernvarchar250
TOPBasic Data
7NBAUIS-H: Building Units8TELFXFax Numbernvarchar310
8NC301PIS-H EDI Data Collection Points19TELFXFax Number of Contact Personnvarchar160
9NGPAIS-H: Business Partners27TELFXFax Number of Business Partnernvarchar310
10NORGIS-H: Organizational Units15TELFXFax Number of Organizational Unitnvarchar310
11TN01IS-H: Institutions14TELFXFax Numbernvarchar310
TOPBasis Services Communication Interfaces
12NASTMessage Status31TELFXFax numbernvarchar310
TOPBusiness Partner
13TIVBPVENDORGENVendor Preassignment (General Data)31TELFXFax Numbernvarchar310
TOPClinical System
14N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient20TELFXFax Number of Business Partnernvarchar310
15N2MV_DISREQDispatch Request Data Table26TELFXDispatch Control: Fax Numbernvarchar400
16N2MV_VSDATRecipient Data Table25TELFXDispatch Control: Fax Numbernvarchar400
TOPCompany Pension Scheme Germany
17T5DC3Pension Organization for Company Pension Scheme13TELFXFax numbernvarchar310
TOPControlling
18CSKSCost Center Master Data50TELFXFax Numbernvarchar310
TOPCross-Application Components
19BC490KKNA1General data in customer master12TELFXFax Numbernvarchar310
20KKNA1General Data in Customer Master12TELFXFax Numbernvarchar310
21SKNA1Customer Master table for BC417 Course12TELFXFax Numbernvarchar310
TOPCustomer Master
22KNA1General Data in Customer Master12TELFXFax Numbernvarchar310
TOPFinancial Accounting
23LFA1Vendor Master (General Section)48TELFXFax Numbernvarchar310
TOPFrance
24T5F4EDDTEFP7TELFXFax Numbernvarchar310
25T5F4E1DDTEPP address8TELFXFax Numbernvarchar310
TOPGeneral Application Functions
26DFAXDFax information extendable sample SAP-WB3TELFXFax Numbernvarchar310
27TFAX1Fax information extendable sample3TELFXFax Numbernvarchar310
TOPInformation System
28DKKOSBalance Audit Trail40TELFXFax Numbernvarchar310
29DKOKSOpen Item Account Balance Audit Trail Master Record42TELFXFax Numbernvarchar310
TOPLocalization
30J_1BNFDOCNota Fiscal Header83TELFXFax Numbernvarchar310
31J_1BNFNADNota Fiscal partners23TELFXFax Numbernvarchar310
TOPMaster Data
32JGTSADRIS-M: Extended Address Management72TELFXFax Numbernvarchar310
TOPOverhead Cost Controlling
33CMDT_ADRGeneric Master Record: Address23TELFXFax Numbernvarchar310
TOPPendulum List Indirect Sales
34/BEV4/PLDUMKDNConversion Table Customer/Object Numbers19TELFXFax Numbernvarchar310
TOPPeriodical Sales and Distribution
35JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet35TELFXFax Numbernvarchar310
36JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data53TELFXFax Numbernvarchar310
37JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data53TELFXFax Numbernvarchar310
38JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet34TELFXFax Numbernvarchar310
TOPProfit Center Accounting
39CEPCProfit Center Master Data Table30TELFXFax Numbernvarchar310
TOPPurchasing
40EKANVendor Address: Purchasing Document15TELFXFax Numbernvarchar310
41T024Purchasing Groups6TELFXFax number of purchasing (buyer) groupnvarchar310
TOPRecycling Administration Core Functions
42J_7LSADRAddress Management: Company Data27TELFXFax numbernvarchar310
TOPRemaining Beverage - Obsolete Objects
43/BEV1/CLDEBCustomer Information21TELFXFax Numbernvarchar310
TOPSales Promotions
44SADLSTRECBDynamic Part of Address List (Record Body)52TELFXFax numbernvarchar310
TOPSpain
45T5EDHLocal tax offices/authorities12TELFXFax Numbernvarchar310
TOPTreasury
46VZKNA1Collector for batch input KNA1 from RF-VV38TELFXFax Numbernvarchar310
TOPUser and Authorization Management
47USR03User address data24TELFXFax Numbernvarchar310