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

58 columns | Print definition?ERP 6.0  | ENTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2KR_KRSIPayroll Result Korea : Social Insurance11ENTIDSI entitlement reasonnvarchar20
2TDM12Attribute Short/Long Name2ENTIDEntity IDnvarchar40
3TDM25Assign Entities to Data Element1ENTIDEntity IDnvarchar40
4TFM06Process-Function-Entity Assignment7ENTIDEntity IDnvarchar40
5TFM10Entity-Event Type Assignment1ENTIDEntity IDnvarchar40
6TFM16Function-Entity Assignment5ENTIDEntity IDnvarchar40
TOPChina
7T7CN0PPersonal Areas/Subareas (CHINA)4ENTIDEnterprise unified IDnvarchar200
TOPCorrespondence Tool
8DFKKCODCorrespondence - Correspondence Data6ENTIDCorrespondence datanvarchar40
9TFK070DCorrespondence data2ENTIDCorrespondence datanvarchar40
10TFK070DTCorrespondence data3ENTIDCorrespondence datanvarchar40
11TFK070ECorrespondence data fields2ENTIDCorrespondence datanvarchar40
TOPData Modeler
12DM02LDM Entity Type1ENTIDEntity type namenvarchar260
13DM02SDM Entity Type Definition Variant1ENTIDEntity type namenvarchar260
14DM02TDM Entity Type Short Text2ENTIDEntity type namenvarchar260
15DM03SDM Attribute1ENTIDEntity type namenvarchar260
16DM25LDM View-Entity Type Assignment1ENTIDEntity type namenvarchar260
17DM26LDM Table-Entity Type Assignment1ENTIDEntity type namenvarchar260
18DM43TDM Entity Type Aliases2ENTIDEntity type namenvarchar260
19DM45LDM Specialization Category1ENTIDEntity type namenvarchar260
20DM45TDM Short text for specialization type2ENTIDEntity type namenvarchar260
21DM50TDM ADW Text on Entity Type2ENTIDEntity type namenvarchar260
22TDI01Entity Type - View Assignment1ENTIDEntity IDnvarchar40
23TDM02Assignment of Entities to SAP Tables1ENTIDEntity IDnvarchar40
24TDM03Entity Short/Long Name2ENTIDEntity IDnvarchar40
25TDM04Entity Type1ENTIDEntity IDnvarchar40
26TDM07Assignment of Entities to Data Models3ENTIDEntity IDnvarchar40
27TDM09Entity Attributes1ENTIDEntity IDnvarchar40
28TDM10Assignment Synonyms-Entity2ENTIDEntity IDnvarchar40
29TDM11Assignment Entity - Alias Name2ENTIDEntity IDnvarchar40
30TDM13Attributes of entity types, assignment of data elements1ENTIDEntity IDnvarchar40
31TDM14Customizing attributes of entity types1ENTIDEntity IDnvarchar40
32TDM21Entity Specialization Category1ENTIDEntity IDnvarchar40
33TDM22Entity Specialization Category Text2ENTIDEntity IDnvarchar40
34TDM29EDM Cluster Assignment: Data Model-Entity Type5ENTIDEntity IDnvarchar40
TOPJapan
35PA0140HR Master Record: Infotype 0140 (SI Basic Data JP)30ENTIDIndicator for SI Entitlementnvarchar20
36T5J31HR SI Entitlement JPN4ENTIDIndicator for SI Entitlementnvarchar20
37T5J32HR Social Insurance Entitlement JPN5ENTIDIndicator for SI Entitlementnvarchar20
TOPKorea
38PA0543HR Master Record: Infotype 054325ENTIDSI entitlement reasonnvarchar20
39T7KR21HR Combination of entitlement reason & SI code4ENTIDSI entitlement reasonnvarchar20
40T7KR25HR SI Entitlement Reason (KOR)3ENTIDSI entitlement reasonnvarchar20
41T7KR26HR Text for SI Entitlement Reason (KOR)4ENTIDSI entitlement reasonnvarchar20
TOPPatient Transport Service
42N1FATGENIS-H*MED: Help Table for Transport-Relevant Entities5ENTIDPatient Transport Service: Generic Key Corr. Entitynvarchar200
TOPPersonnel Administration
43T5JSEHR Reason for Acuired/lost JP4ENTIDIndicator for SI Entitlementnvarchar20
44T7CO31DIAN items grouping8ENTIDSocial insurance entity flagnvarchar10
TOPPreconfigured Systems
45ZHRBPJPT_SIIID9ENTID????????????/??????nvarchar20
TOPTaiwan
46T7TW0PPersonal Areas/Subareas (Taiwan)5ENTIDEnterprise unified IDnvarchar80
47T7TW2FSequence number of income tax return reporting2ENTIDEnterprise unified IDnvarchar80
48T7TW2GTax media filing sequence number reservation3ENTIDEnterprise unified IDnvarchar80
49T7TW2IReported data of Tax withdrawal report13ENTIDEnterprise unified IDnvarchar80
TOPTools
50T52SEHRPAY-Status Management: Program Categories2ENTIDProgram category in process modelnvarchar80
51T52SEIOCHRPAY-Status Management: Program Categories2ENTIDProgram category in process modelnvarchar80
52T52SEOCTProcess Manager: Program Categories, Targets of Objects3ENTIDProgram category in process modelnvarchar80
53T52SESHRPAY-Status Management: Default Values for Categories2ENTIDProgram category in process modelnvarchar80
54T52SESCHRPAY Process Manager: Override Consistency Check2ENTIDProgram category in process modelnvarchar80
55T52SES_CHRPAY Status Management:Default Values for Customer Category2ENTIDProgram category in process modelnvarchar80
56T52SETHRPAY-Status Management: Text for Program Category3ENTIDProgram category in process modelnvarchar80
57T52SMSHRPAY-Status Management: Steps in a Process Model4ENTIDProgram category in process modelnvarchar80
58T52STHHRPAY-Status Management: Status Table7ENTIDProgram category in process modelnvarchar80