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

83 columns | Print definition?ERP 6.0  | ADATANR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/THRADZNHTable for additional data relationship ZNK/ZNL2ADATANRADATA Numbernvarchar320
2/NAKISA/THRADZNKTable for additional data relationship ZNK/ZNL2ADATANRADATA Numbernvarchar320
3/NAKISA/TZNBAdditional Data Table For Relationship ZNB2ADATANRADATA Numbernvarchar320
4/NAKISA/TZNCAdditional Data Table For Relationship ZNC2ADATANRADATA Numbernvarchar320
5/NAKISA/TZNDAdditional Data Table For Relationship ZND2ADATANRADATA Numbernvarchar320
6/NAKISA/TZNEAdditional Data Table For Relationship ZNE2ADATANRADATA Numbernvarchar320
7/NAKISA/TZNFAdditional Data Table For Relationship ZNF2ADATANRADATA Numbernvarchar320
8/XLSO/HRPAD25XLSO specific HRPAD25 Table2ADATANRADATA Numbernvarchar320
9/XLSO/HRPAD27XLSO specific HRPAD27 Table2ADATANRADATA Numbernvarchar320
10/XLSO/HRPAD614XLSO Specific HRPAD614 Table2ADATANRADATA Numbernvarchar320
11GRPC_UPG_HRP1001Backup Data24ADATANRADATA Numbernvarchar320
12HRPAD460Données complémentaires PAD4602ADATANRNuméro ADATAnvarchar320
13HRPAD790Additional Data Relationship 'Has Curric BundleType Element'2ADATANRADATA Numbernvarchar320
14HRPAD791Additional Data Relationship 'Has Curriculum Bundle Element'2ADATANRADATA Numbernvarchar320
15HRPAD792Additional Data Relationship 'Has Subscription_Type Element'2ADATANRADATA Numbernvarchar320
16HRPAD794Additional Data Relationship 'Has MixandMatch Type Element'2ADATANRADATA Numbernvarchar320
17HRPAD795Additional Data Relationship 'Has MixandMatch Element'2ADATANRADATA Numbernvarchar320
18T7QAPBS035Additional Data for PQAP0352ADATANRADATA Numbernvarchar320
19ZRP1001Infotype 1001 DB Table24ADATANRADATA Numbernvarchar320
20HRPAD500Additional Data for PAD5002ADATANRADATA Numbernvarchar320
21HRPAD503Additional Data for PAD5032ADATANRADATA Numbernvarchar320
22HRPAD506Additional Data for PAD5062ADATANRADATA Numbernvarchar320
23HRPAD508Additional Data for PAD5082ADATANRADATA Numbernvarchar320
24HRPAD509Additional Data for PAD5092ADATANRADATA Numbernvarchar320
25HRPAD512Additional Data for PAD5122ADATANRADATA Numbernvarchar320
26HRPAD513Additional Data for PAD5132ADATANRADATA Numbernvarchar320
27HRPAD515Additional Data for PAD5152ADATANRADATA Numbernvarchar320
28HRPAD516Additional Data for PAD5162ADATANRADATA Numbernvarchar320
29HRPAD521Additional data for PAD5212ADATANRADATA Numbernvarchar320
30HRPAD528Additional Data for PAD5282ADATANRADATA Numbernvarchar320
31HRPAD529Additional Data for PAD5062ADATANRADATA Numbernvarchar320
32HRPAD530Additional Data for PAD5302ADATANRADATA Numbernvarchar320
33HRPAD532Additional Data for PAD5082ADATANRADATA Numbernvarchar320
34HRPAD533Additional Data for PAD5332ADATANRADATA Numbernvarchar320
35HRPAD543Additional Data for PAD5432ADATANRADATA Numbernvarchar320
36HRPAD547Additional Data PAD5472ADATANRADATA Numbernvarchar320
TOPAppraisal Systems
37HRPAD47PAD47 Additional Data2ADATANRADATA Numbernvarchar320
TOPAppraisal, Valuation, and Survey Tool
38HRPAD605Additional Data PAD6052ADATANRADATA Numbernvarchar320
TOPBudget Management
39HRPADP1Additional Data PADP12ADATANRADATA Numbernvarchar320
40HRPADP2Additional Data PADP22ADATANRADATA Numbernvarchar320
41HRPADPMAdditional Data PADPM2ADATANRADATA Numbernvarchar320
TOPDevelopment Plans
42HRPAD77Additional data for PAD772ADATANRADATA Numbernvarchar320
TOPE-Recruiting
43HRPAD658Additional Data: Source of Assignment Talent Group/Candidate2ADATANRADATA Numbernvarchar320
TOPFrance
44HRPAD940Additional data PAD9402ADATANRADATA Numbernvarchar320
45HRPAD941Additional data PAD9412ADATANRADATA Numbernvarchar320
TOPHospital Structure
46HRPAD860PAD860 Additional Data2ADATANRADATA Numbernvarchar320
TOPObjective Setting and Appraisals
47HRPAD713Additional Data PAD 7132ADATANRADATA Numbernvarchar320
TOPOrganizational Management
48HRIADATANRAdditional Data Numbers2ADATANRADATA Numbernvarchar320
49HRP1001Infotype 1001 DB Table24ADATANRADATA Numbernvarchar320
50HRP1001_ARCHInfotype 1001: Inverse Relationship After Archiving24ADATANRADATA Numbernvarchar320
51HRPAD007Additional Data PAD0072ADATANRADATA Numbernvarchar320
52HRPADD2Additional Data PADD22ADATANRADATA Numbernvarchar320
53HRPADD3Additional Data PADD32ADATANRADATA Numbernvarchar320
54HRPADNNGeneral Additional Data Table2ADATANRADATA Numbernvarchar320
55HRPADXNAdditional Data PADXN2ADATANRADATA Numbernvarchar320
TOPQualifications and Requirements
56HRPAD31Additional data PAD312ADATANRADATA Numbernvarchar320
57HRPAD44PAD44 Additional Data2ADATANRADATA Numbernvarchar320
TOPSAP Business Partner
58HRPADICAdditional Data PADD22ADATANRADATA Numbernvarchar320
TOPShift Planning
59HRPAD067Additional Data for Temporary Assignments2ADATANRADATA Numbernvarchar320
60HRPAD071Additional Data for Temporary Assignments2ADATANRADATA Numbernvarchar320
61HRPAD63PAD63 Additional Data2ADATANRADATA Numbernvarchar320
62HRPADTIPADTI Additional Data2ADATANRADATA Numbernvarchar320
63HRPADUZPADUZ Additional Data: Requirements Assignment of Persons2ADATANRADATA Numbernvarchar320
TOPStaffing
64HRPAD48Additional Data PAD482ADATANRADATA Numbernvarchar320
TOPTalent Management
65HRPAD450Additional Data PAD4502ADATANRADATA Numbernvarchar320
66HRPAD451Additional Data PAD4512ADATANRADATA Numbernvarchar320
67HRPAD740Additional Data for Relationship 'Is Successor Of'2ADATANRADATA Numbernvarchar320
68HRPAD741Additional Data for Relationship 'Is Responsible For'2ADATANRADATA Numbernvarchar320
69HRPAD743Additional Data for Relationship 'Is Talent In'2ADATANRADATA Numbernvarchar320
70HRPAD744Additional Data for Relationship ''Has Potential For''2ADATANRADATA Numbernvarchar320
TOPTraining and Event Management
71HRPAD21Additional data PAD212ADATANRADATA Numbernvarchar320
72HRPAD22Additional data PAD222ADATANRADATA Numbernvarchar320
73HRPAD23Additional data PAD232ADATANRADATA Numbernvarchar320
74HRPAD25Additional data PAD252ADATANRADATA Numbernvarchar320
75HRPAD27Additional data PAD272ADATANRADATA Numbernvarchar320
76HRPAD34Additional Data for Relationship 'has attended'2ADATANRADATA Numbernvarchar320
77HRPAD50Additional Data PAD502ADATANRADATA Numbernvarchar320
78HRPAD51Additional data PAD512ADATANRADATA Numbernvarchar320
79HRPAD53Additional Data PAD532ADATANRADATA Numbernvarchar320
TOPTraining Management
80HRPAD612Additional Data Relationship 'Has Curriculum Element'2ADATANRADATA Numbernvarchar320
81HRPAD613Additional Data Relationship 'Has Curriculum Element'2ADATANRADATA Numbernvarchar320
82HRPAD614Additional Data PAD6142ADATANRADATA Numbernvarchar320
83HRPAD618Additional Data - "Has Course Program Element" Relationship2ADATANRADATA Numbernvarchar320