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

29 columns | Print definition?ERP 6.0  | ZTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPATARTCashier table - plant description.4ZTEXTTextnvarchar350
2/ATL/KPCRDLTYPTCredit Card Deal Type - description5ZTEXTText (length 35)nvarchar350
3/ATL/KPCRDTYPTCredit Types - Description5ZTEXTText (length 35)nvarchar350
4/ATL/KPFASRTCashir system - creadit card company descreption4ZTEXTTextnvarchar350
5/ATL/KPKUPATCashier table - Cashier Description4ZTEXTTextnvarchar350
6/ATL/KPKUPDTCashier table - subject description4ZTEXTTextnvarchar250
7T437ZRow Texts for Maintaining Run Schedule Headers5ZTEXTRow textnvarchar200
8T9COMComponents3ZTEXTText, 40 Characters Longnvarchar400
9T9PROProducts2ZTEXTText, 40 Characters Longnvarchar400
10TKA4ECost Element Attribute5ZTEXTName of cost element attributenvarchar400
TOPActivity Types
11TSC0EText table for assignments6ZTEXTText (30 Characters)nvarchar300
TOPAustria
12T5A6FText Table for Garnishment4ZTEXTGarnishment textnvarchar500
TOPBills of Material
13STZUPermanent BOM data11ZTEXTBOM textnvarchar400
TOPCompensation Management
14T504TTo be deleted - no longer used!8ZTEXTText (20 Characters)nvarchar200
TOPGermany
15T5D6FText Table for Garnishment4ZTEXTGarnishment textnvarchar500
TOPInterest
16TPI01TInterest Profile4ZTEXTName of Interest Calc.Profilenvarchar500
TOPNetherlands
17T5N2NText: Tax Table Periods (NL)4ZTEXTPayroll Period Textnvarchar200
TOPOverhead Cost Orders
18TKB4DText Table for Original Settlement Assignment5ZTEXTText (30 Characters)nvarchar300
19TKB5DText Table for Settlement Assignment5ZTEXTText (30 Characters)nvarchar300
20TKB9DText Table for Assignments in Profitability Analysis5ZTEXTText (30 Characters)nvarchar300
21TKZSLTName of Overhead Key4ZTEXTDescriptionnvarchar300
TOPPersonnel Time Management
22T551SPeriod Work Schedule Texts5ZTEXTText (20 Characters)nvarchar200
23T555BTime Type Texts5ZTEXTDescription for time typesnvarchar250
24T555VEmployee Status for Time Management: Texts4ZTEXTText for time recording status (IT Planned Working Time)nvarchar500
25T555XTexts for Access Control Groups (time-restricted)5ZTEXTText (30 Characters)nvarchar300
26T7050Time Management: Communication Times7ZTEXTText length 60nvarchar600
TOPRepetitive Manufacturing
27T437ATable for Field Selection: Repetitive Manufacturing5ZTEXTRow text in repetitive manufacturing - version or row textnvarchar10
TOPTransceiver
28T705ZCommunication Times6ZTEXTTextnvarchar250
TOPTranslation Tools
29LXE_XT_ZTEXTSpecial Texts6ZTEXTTextntext10737418230