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

116 columns | Print definition?ERP 6.0  | ENAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10940_VARHStoring all variants for relevant reports6ENAMEUser Namenvarchar120
2P2RN_NNAMPersonal Data21ENAMEName Formatnvarchar400
3SLDW_ELEMENTSElements of Whitelists (Design)2ENAMEName of Whitelist Entrynvarchar2980
4SLDW_ELEMENTS_RTElements of Whitelists (Runtime)2ENAMEName of Whitelist Entrynvarchar2980
5T535WASB Reporting Schema4ENAMEField namenvarchar50
6T5H7UCertificate for tax allowance8ENAMEFormatted Name of Employee or Applicantnvarchar400
7T5REGEmployee Information Log for Destruction of Data27ENAMEFormatted Name of Employee or Applicantnvarchar400
8T5RPDPersonnel Data Deletion Log37ENAMEFormatted Name of Employee or Applicantnvarchar400
9TKB7CPseudonyms for Field Names4ENAMEField name in tablenvarchar240
TOPAustria
10T5A1LELDA: Record Structures5ENAMEELDA: Field Namenvarchar60
11T5A1MELDA: Field Conversion4ENAMEELDA: Field Namenvarchar60
12T5A1NELDA: Value Conversion4ENAMEELDA: Field Namenvarchar60
TOPCross-Application Objects in HR
13HRP5581DB Table for Infotype 558120ENAMEFormatted Name of Employee or Applicantnvarchar400
TOPIncentive and Commission Management ICM
14CACS00_B_VAR_ACTVariants for Commission Case Activities2ENAMEUser Namenvarchar120
15CACS00_B_VAR_BDLVariants for Bundling2ENAMEUser Namenvarchar120
16CACS00_B_VAR_CASVariants for Commission Case2ENAMEUser Namenvarchar120
17CACS00_B_VAR_INVVariants for Commission Case Participants2ENAMEUser Namenvarchar120
18CACS00_B_VAR_LINVariants for Alternative Commission2ENAMEUser Namenvarchar120
19CACS00_B_VAR_OBJVariants for Commission Case Object Data2ENAMEUser Namenvarchar120
20CACS00_B_VAR_PARVariants for Commission Case Participant2ENAMEUser Namenvarchar120
21CACS00_B_VAR_RELVariants for Participant Relations2ENAMEUser Namenvarchar120
22CACS_B_VARVariants for BDTI3ENAMEUser Namenvarchar120
23YCRM01_B_VAR_ACTVariants for Commission Case Activities2ENAMEUser Namenvarchar120
24YCRM01_B_VAR_BDLVariants for Bundling2ENAMEUser Namenvarchar120
25YCRM01_B_VAR_CASVariants for Commission Case2ENAMEUser Namenvarchar120
26YCRM01_B_VAR_INVVariants for Commission Case Participants2ENAMEUser Namenvarchar120
27YCRM01_B_VAR_LINVariants for Alternative Commission2ENAMEUser Namenvarchar120
28YCRM01_B_VAR_OBJVariants for Commission Case Object Data2ENAMEUser Namenvarchar120
29YCRM01_B_VAR_PARVariants for Commission Case Participant2ENAMEUser Namenvarchar120
30YCRM01_B_VAR_RELVariants for Participant Relations2ENAMEUser Namenvarchar120
31YHITEC_B_VAR_ACTVariants for Commission Case Activities2ENAMEUser Namenvarchar120
32YHITEC_B_VAR_BDLVariants for Bundling2ENAMEUser Namenvarchar120
33YHITEC_B_VAR_CASVariants for Commission Case2ENAMEUser Namenvarchar120
34YHITEC_B_VAR_INVVariants for Commission Case Participants2ENAMEUser Namenvarchar120
35YHITEC_B_VAR_LINVariants for Alternative Commission2ENAMEUser Namenvarchar120
36YHITEC_B_VAR_OBJVariants for Commission Case Object Data2ENAMEUser Namenvarchar120
37YHITEC_B_VAR_PARVariants for Commission Case Participant2ENAMEUser Namenvarchar120
38YHITEC_B_VAR_RELVariants for Participant Relations2ENAMEUser Namenvarchar120
39YSVMA_B_VAR_ACTVariants for Commission Case Activities2ENAMEUser Namenvarchar120
40YSVMA_B_VAR_BDLVariants for Bundling2ENAMEUser Namenvarchar120
41YSVMA_B_VAR_CASVariants for Commission Case2ENAMEUser Namenvarchar120
42YSVMA_B_VAR_INVVariants for Commission Case Participants2ENAMEUser Namenvarchar120
43YSVMA_B_VAR_LINVariants for Alternative Commission2ENAMEUser Namenvarchar120
44YSVMA_B_VAR_OBJVariants for Commission Case Object Data2ENAMEUser Namenvarchar120
45YSVMA_B_VAR_PARVariants for Commission Case Participant2ENAMEUser Namenvarchar120
46YSVMA_B_VAR_RELVariants for Participant Relations2ENAMEUser Namenvarchar120
47YTEL01_B_VAR_ACTVariants for Commission Case Activities2ENAMEUser Namenvarchar120
48YTEL01_B_VAR_BDLVariants for Bundling2ENAMEUser Namenvarchar120
49YTEL01_B_VAR_CASVariants for Commission Case2ENAMEUser Namenvarchar120
50YTEL01_B_VAR_INVVariants for Commission Case Participants2ENAMEUser Namenvarchar120
51YTEL01_B_VAR_LINVariants for Alternative Commission2ENAMEUser Namenvarchar120
52YTEL01_B_VAR_OBJVariants for Commission Case Object Data2ENAMEUser Namenvarchar120
53YTEL01_B_VAR_PARVariants for Commission Case Participant2ENAMEUser Namenvarchar120
54YTEL01_B_VAR_RELVariants for Participant Relations2ENAMEUser Namenvarchar120
55YTEL05_B_VAR_ACTVariants for Commission Case Activities2ENAMEUser Namenvarchar120
56YTEL05_B_VAR_BDLVariants for Bundling2ENAMEUser Namenvarchar120
57YTEL05_B_VAR_CASVariants for Commission Case2ENAMEUser Namenvarchar120
58YTEL05_B_VAR_INVVariants for Commission Case Participants2ENAMEUser Namenvarchar120
59YTEL05_B_VAR_LINVariants for Alternative Commission2ENAMEUser Namenvarchar120
60YTEL05_B_VAR_OBJVariants for Commission Case Object Data2ENAMEUser Namenvarchar120
61YTEL05_B_VAR_PARVariants for Commission Case Participant2ENAMEUser Namenvarchar120
62YTEL05_B_VAR_RELVariants for Participant Relations2ENAMEUser Namenvarchar120
63ZICMAG_B_VAR_ACTVariants for Commission Case Activities2ENAMEUser Namenvarchar120
64ZICMAG_B_VAR_BDLVariants for Bundling2ENAMEUser Namenvarchar120
65ZICMAG_B_VAR_CASVariants for Commission Case2ENAMEUser Namenvarchar120
66ZICMAG_B_VAR_INVVariants for Commission Case Participants2ENAMEUser Namenvarchar120
67ZICMAG_B_VAR_LINVariants for Alternative Commission2ENAMEUser Namenvarchar120
68ZICMAG_B_VAR_OBJVariants for Commission Case Object Data2ENAMEUser Namenvarchar120
69ZICMAG_B_VAR_PARVariants for Commission Case Participant2ENAMEUser Namenvarchar120
70ZICMAG_B_VAR_RELVariants for Participant Relations2ENAMEUser Namenvarchar120
TOPIreland
71T7IE6Employer Registered Numbers (HR-IE)5ENAMEEmployer Namenvarchar300
72T7IE9SIPTU6ENAMEEmployer Namenvarchar300
TOPLocalization
73J_3RSEXTRACTDExctract details (obsolete)2ENAMEExtract Namenvarchar100
74J_3RSEXTRACTHExtract header (obsolete)2ENAMEExtract Namenvarchar100
TOPLogical DB, Selection Screens, Selection Variants
75VARIDVariant directory11ENAMEUser Namenvarchar120
76VARID_CIVariant Catalog, Cross-Client9ENAMEUser Namenvarchar120
TOPMaintenance Processing
77/MRSS/C_PREMKDummy table for creating Org. Assgnmnt Search Help (No Data)16ENAMEFormatted Name of Employee or Applicantnvarchar400
TOPNorway
78T5VT0Annual tax statements - Reporting status4ENAMEEmployer namenvarchar420
TOPOccupational Health
79T7EHS00_EXAMTExaminations (Text Table)7ENAMEName of Examinationnvarchar750
TOPPayroll
80T5H11Minimális járulékalap - jelentett munkavállalók4ENAMEDolgozó ill. pályázó formatált nevenvarchar400
81T7SIA1Annual tax - Master data6ENAMEFormatted Name of Employee or Applicantnvarchar400
82T7SIA3M4 - Temporary data4ENAMEFormatted Name of Employee or Applicantnvarchar400
83T7SIA4DPZ temporary data9ENAMEFormatted Name of Employee or Applicantnvarchar400
TOPPersonnel Administration
84PA0001HR Master Record: Infotype 0001 (Org. Assignment)43ENAMEFormatted Name of Employee or Applicantnvarchar400
TOPPersonnel Management
85T7HRA2IP Form - Master data8ENAMEFormatted Name of Employee or Applicantnvarchar400
86T7HRA2NIP Form - Master data - New (w. OIB)8ENAMEFormatted Name of Employee or Applicantnvarchar400
87T7HRA2OIP Form - Master data - with IDENT in key9ENAMEFormatted Name of Employee or Applicantnvarchar400
TOPPortugal
88T5P2UHR-PT: Social Security Contributor13ENAMEEntity designationnvarchar600
TOPProcess Controls -Automated Controls
89GRPCRTA_HRDA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)17ENAMEFormatted Name of Employee or Applicantnvarchar400
90GRPCRTA_HRDA0045PC HR control data for infotype 0045 - Loan17ENAMEFormatted Name of Employee or Applicantnvarchar400
91GRPCRTA_HRDA0078PC HR control data for infotype 0078 - Loan Payments17ENAMEFormatted Name of Employee or Applicantnvarchar400
92GRPCRTA_HRDA0267PC HR control data for infotype 026717ENAMEFormatted Name of Employee or Applicantnvarchar400
93GRPCRTA_HRDAT1PC HR control data for infotype 0014 and 001517ENAMEFormatted Name of Employee or Applicantnvarchar400
94GRPCRTA_HRDAT2PC HR control data for infotype 0014 and 001517ENAMEFormatted Name of Employee or Applicantnvarchar400
TOPProfitability Analysis
95COVADVariant catalog7ENAMEUser Namenvarchar120
96COVALLog Management Table7ENAMEUser Namenvarchar120
TOPRecruitment
97PB0001HR Master Record: Infotype 0001 (Org. Assignment)43ENAMEFormatted Name of Employee or Applicantnvarchar400
TOPRegulatory reporting for insurance companies
98ISSRPREFLOWISSR: Basistabelle/Bewegungstabelle59ENAMENome utentenvarchar120
99ISSR_RPI_MFTISSR: Feste und variable Daten Meldewesen55ENAMEBenutzernamenvarchar120
100ISSR_RPI_MFT_BCKISSR: Feste und variable Daten Meldewesen als Backuptabelle55ENAMEBenutzernamenvarchar120
101TISSR_CHA_MDATAAufzeichnung von Aktivitaeten zur Stammdatenaenderung6ENAMEBenutzernamenvarchar120
102TISSR_LT_HEADERKopftabelle zur Speicherung von Listinhalten im neuen Mw10ENAMEBenutzernamenvarchar120
TOPRepository Browser
103OBJTYPEGROUPSSemantic Group Affiliation of Object Types3ENAMECreated Bynvarchar120
104WVOBJECTTYPESRegistry Table for Object Types3ENAMECreated Bynvarchar120
TOPSales and Distribution
105J_1USEXTRACTDEXTRACTD2ENAMEnvarchar100
106J_1USEXTRACTD_MMEXTRACTD_MM2ENAMEnvarchar100
107J_1USEXTRACTHEXTRACTH2ENAMEnvarchar100
TOPSamples and SPC
108QASHQuality control chart37ENAMEName of Person who Created the Objectnvarchar120
109QASTControl chart track19ENAMEName of Person who Created the Objectnvarchar120
TOPSAP Note Assistant
110SVRS_VCNT_HEADHeader table for TLogo test objects7ENAMEAuthor of the Repository objectnvarchar120
TOPSingapore
111PA0412HR Master Record: Infotype 0412 [View to I0021] (SG)24ENAMEName of employernvarchar1000
TOPSouth Africa
112T5W9SStatus/Level of a Labour Relation intervention process7ENAMESAPScript text used in email bodynvarchar160
TOPSubsequent Settlement
113AVORRATWorklist8ENAMEWorklist, Entry Made by Usernvarchar120
TOPTransport Organizer
114VERSOBJ_ALIASList of Active Alias Object Types9ENAMEAuthor of the Repository objectnvarchar120
TOPWarehouse Management
115LTAPTransfer order item134ENAMEUser Name in Pick Confirmation (First Step)nvarchar120
TOPXBRL Reporting
116UGXV00CVariant - Check Table4ENAMEUser Namenvarchar120