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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

175 columns | Print definition?ERP 6.0  | SRSID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCC_INTPLIncoming Template3SRSIDSource of Datanvarchar100
2EHPRCD_DEC_DEObsolete13SRSIDSource of Datanvarchar100
3EHPRCD_DEC_INObsolete13SRSIDSource of Datanvarchar100
TOPCompliance Check
4EHSBT_RC_ESTRHSHEHS: Table f. Storing Substs w. Constraints in Shared Memory16SRSIDSource of Datanvarchar100
TOPEnvironment, Health and Safety
5/TDAG/CPC_IMFOCP: Import format3SRSIDSource of Datanvarchar100
6/TDAG/CPT_CHKENTCP: Check entries13SRSIDSource of Datanvarchar100
7/TDAG/CPT_DECSUBCP: Declarable Substances13SRSIDSource of Datanvarchar100
8/TDAG/CPT_DEC_DECP: Declarable Substances, Dependent attributes13SRSIDSource of Datanvarchar100
9/TDAG/CPT_DEC_INCP: Declarable Substances, Independent attributes13SRSIDSource of Datanvarchar100
10/TDAG/CPT_ESTMJEHS: Substance - material - allocation13SRSIDSource of Datanvarchar100
11/TDAG/CPT_HISENTCP: Worklist entries for Compliance History13SRSIDSource of Datanvarchar100
12/TDAG/CPT_IMDENTCP: IMDS entries13SRSIDSource of Datanvarchar100
13/TDAG/CPT_REAENTCP: Reach entries13SRSIDSource of Datanvarchar100
14/TDAG/CPT_REVENTCP: Revision entries13SRSIDSource of Datanvarchar100
15/TDAG/RCSC_INTPLIncoming Template3SRSIDSource of Datanvarchar100
16DGTPKDG: Packing Requirement13SRSIDSource of Datanvarchar100
17EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation13SRSIDSource of Datanvarchar100
18EHQMT_MAIN2EH&S-QM: Characteristics for Inspection Plan Creation13SRSIDSource of Datanvarchar100
19EHSBT_APPL_SCOPEEHS: General Scope of Application13SRSIDSource of Datanvarchar100
TOPEnvironment, Health and Safety Master Data
20CCDUTCARRProvisions for Carriage13SRSIDSource of Datanvarchar100
21CCDUTDGRELProduct Release13SRSIDSource of Datanvarchar100
22CCDUTPACKPackaging Code Approvals13SRSIDSource of Datanvarchar100
23CCDUTSPROVSpecial Provisions13SRSIDSource of Datanvarchar100
24CCDUTTRAPPRTransport Restrictions13SRSIDSource of Datanvarchar100
25DGTMDDG: Dangerous Goods Master13SRSIDSource of Datanvarchar100
26ESTPHEHS: Phrase Header13SRSIDSource of Datanvarchar100
27ESTPJEHS: Phrase set - phrase header assignment13SRSIDSource of Datanvarchar100
28ESTPOEHS: Original Phrase13SRSIDSource of Datanvarchar100
29ESTPPEHS: Phrase Item13SRSIDSource of Datanvarchar100
30ESTPSEHS: Phrase Set13SRSIDSource of Datanvarchar100
31ESTPTEHS: Language-Dependent Description for Phrase Sets13SRSIDSource of Datanvarchar100
32HSMT_DNEHS: Hazardous Substance Addit. Data 2 (Numeric Type)13SRSIDSource of Datanvarchar100
33HSMT_DTEHS: Hazardous Substance Addit. Data 1 (Text Type)13SRSIDSource of Datanvarchar100
34HSMT_MDEHS: Hazardous Substance Basic Data13SRSIDSource of Datanvarchar100
35TCG56EHS: Data Origin2SRSIDSource of Datanvarchar100
TOPIndustrial Hygiene and Safety
36CCIHT_ACHEHS: Safety Measures - Header13SRSIDSource of Datanvarchar100
37CCIHT_AD08EHS: Customer Analysis Method 08 Detail Data13SRSIDSource of Datanvarchar100
38CCIHT_AD09EHS: Customer Analysis Method 09 Detail Data13SRSIDSource of Datanvarchar100
39CCIHT_AD10EHS: Customer Analysis Method 10 Detail Data13SRSIDSource of Datanvarchar100
40CCIHT_AM01EHS: Customer Analysis Method 0113SRSIDSource of Datanvarchar100
41CCIHT_AM02EHS: Customer Analysis Method 0213SRSIDSource of Datanvarchar100
42CCIHT_AM03EHS: Customer Analysis Method 0313SRSIDSource of Datanvarchar100
43CCIHT_AM04EHS: Customer Analysis Method 0413SRSIDSource of Datanvarchar100
44CCIHT_AM05EHS: Customer Analysis Method 0513SRSIDSource of Datanvarchar100
45CCIHT_AM06EHS: Customer Analysis Method 0613SRSIDSource of Datanvarchar100
46CCIHT_AM07EHS: Customer Analysis Method 0713SRSIDSource of Datanvarchar100
47CCIHT_AM08EHS: Customer Analysis Method 0813SRSIDSource of Datanvarchar100
48CCIHT_AM09EHS: Customer Analysis Method 0913SRSIDSource of Datanvarchar100
49CCIHT_AM10EHS: Customer Analysis Method 1013SRSIDSource of Datanvarchar100
50CCIHT_ANMLEHS: Analysis Method - Meas. Value - Ref. Value Comparison13SRSIDSource of Datanvarchar100
51CCIHT_ANNCEHS: Analysis Method - Standardized Criteria13SRSIDSource of Datanvarchar100
52CCIHT_ANQSEHS: Analysis Method Questionnaire13SRSIDSource of Datanvarchar100
53CCIHT_ANQSRELEHS: Analysis Method Questionnaire - Relevant Questions13SRSIDSource of Datanvarchar100
54CCIHT_ANSCEHS: Analysis Method - Summated Rating (Header)13SRSIDSource of Datanvarchar100
55CCIHT_ANSEEHS: Analysis Method - Summated Rating (Details)13SRSIDSource of Datanvarchar100
56CCIHT_EPIEHS: Exposure Profile Entry13SRSIDSource of Datanvarchar100
57CCIHT_ERAIEHS: Exposure Log - Additional Information13SRSIDSource of Datanvarchar100
58CCIHT_ERHEHS: Risk Assessment - Header13SRSIDSource of Datanvarchar100
59CCIHT_ERQTEHS: Exposure Assignment - Exposure Amounts13SRSIDSource of Datanvarchar100
60CCIHT_ERRAEHS: - Obsolete - Exposure Assignment - Risk Assessment13SRSIDSource of Datanvarchar100
61CCIHT_FALEHS: Injury/Illness Log13SRSIDSource of Datanvarchar100
62CCIHT_FALMAEHS: Medical Measures13SRSIDSource of Datanvarchar100
63CCIHT_FAVAEHS: Obsolete - Inj./Illn. Log Addit. Info. (Classif. Sys.)13SRSIDSource of Datanvarchar100
64CCIHT_IALEHS: Incident/Accident Log - Header13SRSIDSource of Datanvarchar100
65CCIHT_IAVAEHS: Obsolete - Inc./Acc. Log - Addit. Info. (Classif. Sys.)13SRSIDSource of Datanvarchar100
66CCIHT_IHVAEHS: Value Assignment Data Records for Classific. System13SRSIDSource of Datanvarchar100
67CCIHT_IPEHS: List of Persons Involved13SRSIDSource of Datanvarchar100
68CCIHT_IPABSSEHS: Incident/Accident Log - Absences for Person Affected13SRSIDSource of Datanvarchar100
69CCIHT_IPEVAEHS: Inc./Acc. Log - Data for Person Affected (Event)13SRSIDSource of Datanvarchar100
70CCIHT_IPEVALIMEHS: Incident/Accident Log - Link Accident to Restrictions13SRSIDSource of Datanvarchar100
71CCIHT_IPEVINJEHS: Injuries to Person Affected13SRSIDSource of Datanvarchar100
72CCIHT_IPVAEHS: Obsolete -IAL, Person Aff. - Addit. Info. (Class. Sys.)13SRSIDSource of Datanvarchar100
73CCIHT_MJEHS: Measurement13SRSIDSource of Datanvarchar100
74CCIHT_MJIMPORTEHS: Pooled Table for Imported Measurements13SRSIDSource of Datanvarchar100
75CCIHT_MJVAEHS: Measured Values13SRSIDSource of Datanvarchar100
76CCIHT_MJVAIMPEHS: Imported Measured Values13SRSIDSource of Datanvarchar100
77CCIHT_MJVAQTEHS: Table Temporary Data from Measured Values to Amounts13SRSIDSource of Datanvarchar100
78CCIHT_MJWAEHS: Assignment of Work Area to Measurement Job13SRSIDSource of Datanvarchar100
79CCIHT_MPEHS: Measurement Project13SRSIDSource of Datanvarchar100
80CCIHT_MPDVEHS: Devices Required for Measurement Project13SRSIDSource of Datanvarchar100
81CCIHT_MPMTEHS: Measurement Plan - Measurement Method13SRSIDSource of Datanvarchar100
82CCIHT_MPPLEHS: Project Plan13SRSIDSource of Datanvarchar100
83CCIHT_MPWAEHS: Assignment of Work Area to Measurement Project13SRSIDSource of Datanvarchar100
84CCIHT_PTCPEHS: Pattern to Collective Pattern Assignment13SRSIDSource of Datanvarchar100
85CCIHT_RCEHS: Accident Causes (Root Causes)13SRSIDSource of Datanvarchar100
86CCIHT_RFMJEHS: Reference Measurement13SRSIDSource of Datanvarchar100
87CCIHT_WAAEHS: Accident Location13SRSIDSource of Datanvarchar100
88CCIHT_WAADEHS: Language-Dependent Description of Accident Location13SRSIDSource of Datanvarchar100
89CCIHT_WADOEHS: Work Area - Links to Info Objects13SRSIDSource of Datanvarchar100
90CCIHT_WAHEHS: Work Area - Header13SRSIDSource of Datanvarchar100
91CCIHT_WAIHEHS: Work Area - Industrial Hygiene and Safety Data13SRSIDSource of Datanvarchar100
92CCIHT_WALDEHS: Language-Dependent Name and Descr. of Work Area13SRSIDSource of Datanvarchar100
93CCIHT_WAPTEHS: Assignment of Template to Work Area13SRSIDSource of Datanvarchar100
94CCIHT_WAQSEHS: Work Area - Specific Questionnaire Assignment13SRSIDSource of Datanvarchar100
TOPOccupational Health
95T7EHS00_VACCHEHS: Vaccination Data Header Information13SRSIDSource of Datanvarchar100
TOPProduct Safety
96CCGLT_LSDEEHS: Label Stock - Language-Dependent Descriptions13SRSIDSource of Datanvarchar100
97CCGLT_LSHDEHS: Label Stock Header Table13SRSIDSource of Datanvarchar100
98CCGLT_LSLTEHS: Label Stock - Assigned Label Categories13SRSIDSource of Datanvarchar100
99CCGLT_LSRVEHS: Label Stock - Assigned Validity Area13SRSIDSource of Datanvarchar100
100CCGLT_LSTGEHS: Label Stock - Assigned Transport Symbol Groups13SRSIDSource of Datanvarchar100
101CCUNTCARRProvisions for Carriage13SRSIDSource of Datanvarchar100
102CCUNTPACKPacking Requirements13SRSIDSource of Datanvarchar100
103CCUNTSPROVSpecial Packing Provisions13SRSIDSource of Datanvarchar100
104CVDDCSEHS: Control Structure (Report Shipping)13SRSIDSource of Datanvarchar100
105CVDDCSPEHS: Control Structure Parameters (Report Shipping)13SRSIDSource of Datanvarchar100
106CVDDHEHS: Report shipping orders13SRSIDSource of Datanvarchar100
107CVDDPEHS: Parameter Values for Report Shipping13SRSIDSource of Datanvarchar100
108EST07EHS: Dangerous Goods Management - Transport Approval13SRSIDSource of Datanvarchar100
109EST0BEHS: Dangerous Goods Management - Packaging Code Approval13SRSIDSource of Datanvarchar100
110EST0DEHS: Dangerous Goods Management - Risk Classification13SRSIDSource of Datanvarchar100
111EST0FEHS: Dangerous Goods Management - Transport Classification13SRSIDSource of Datanvarchar100
112ESTDCSEHS: Control Structure (Report Body)13SRSIDSource of Datanvarchar100
113ESTDCSPEHS: Parameter Control Structure13SRSIDSource of Datanvarchar100
114ESTDFAdditional Information - User-Defined Text13SRSIDSource of Datanvarchar100
115ESTDHEHS: Report Header13SRSIDSource of Datanvarchar100
116ESTDJEHS: Assignment of Specifications to Reports13SRSIDSource of Datanvarchar100
117ESTDOEHS: Report application objects13SRSIDSource of Datanvarchar100
118ESTDREHS: Additional Information: Value Assignment Assessment13SRSIDSource of Datanvarchar100
119ESTDSEHS: Additional Information: Value Assignment Source13SRSIDSource of Datanvarchar100
120ESTDSCSEHS: eSDS Control Structure13SRSIDSource of Datanvarchar100
121ESTDUEHS: Additional Information: Value Assignment Usage13SRSIDSource of Datanvarchar100
122ESTLNEHS: Language-Dependent Description for Report Template13SRSIDSource of Datanvarchar100
123ESTLPEHS: Report Variant13SRSIDSource of Datanvarchar100
124ESTLREHS: Language-Dependent Description of Report Variant13SRSIDSource of Datanvarchar100
125ESTLUEHS: Report Variant Rating13SRSIDSource of Datanvarchar100
126ESTLVEHS: Report Variant Language (Labels Only)13SRSIDSource of Datanvarchar100
127ESTMJEHS: Specification-Material Assignment13SRSIDSource of Datanvarchar100
128ESTOHEHS: WWI generation / print jobs13SRSIDSource of Datanvarchar100
129ESTRHEHS: Specification Header13SRSIDSource of Datanvarchar100
130ESTRIEHS: Identifier (Numbers, Names, Chemical Formulas)13SRSIDSource of Datanvarchar100
131ESTRLEHS: Identifier - Regulatory List Assignment13SRSIDSource of Datanvarchar100
132ESTRREHS: Reference13SRSIDSource of Datanvarchar100
133ESTSTEHS: Specification Status Assignment13SRSIDSource of Datanvarchar100
134ESTVAEHS: Value Assignment13SRSIDSource of Datanvarchar100
135ESTVHEHS: Specification - Value Assignment Type Assignment13SRSIDSource of Datanvarchar100
136ESTVPEHS: Value Assignment Item13SRSIDSource of Datanvarchar100
137ESTWLEHS: BOMBOS - Worklist Table13SRSIDSource of Datanvarchar100
138ESTWOEHS: Print jobs13SRSIDSource of Datanvarchar100
139TCGTPLIEHS: Inheritance Templates - Identifiers13SRSIDSource of Datanvarchar100
140TCGTPLPEHS: Inheritance Templates - Properties13SRSIDSource of Datanvarchar100
141TCGTPLRELEHS: Inheritance Relationships13SRSIDSource of Datanvarchar100
142TCGTPLUEHS: Inheritance Templates - Usages13SRSIDSource of Datanvarchar100
TOPResourcen Management
143RMSAT_LASTATRMS-ATL: Translation Status13SRSIDSource of Datanvarchar100
144RMSAT_QMHDRQM: Header Table, Operation Level: Sample Drawing Takt, CCP13SRSIDSource of Datanvarchar100
145RMSAT_QMINSPRMS: ATL QM List of Inspection Data for General Recipes13SRSIDSource of Datanvarchar100
146RMSAT_QMINSPTRMS: ATL QM Detail Texts for Inspections in General Recipes13SRSIDSource of Datanvarchar100
TOPWaste Management
147EHSWAT000MD (BDT): Master Table for the Waste Management Master Data13SRSIDSource of Datanvarchar100
148EHSWAT001MD (BDT): Generator/Disposer/Transporter13SRSIDSource of Datanvarchar100
149EHSWAT001ACCMD (BDT): Generator/Disposer/Transporter - Accnt Assignment13SRSIDSource of Datanvarchar100
150EHSWAT001_DESCRMD (BDT): Language-Dependent Data for Partner14SRSIDSource of Datanvarchar100
151EHSWAT002MD (BDT): Waste Generation/Disposal/Transport13SRSIDSource of Datanvarchar100
152EHSWAT003MD (BDT): Disposal Channel13SRSIDSource of Datanvarchar100
153EHSWAT100MD (BDT): Business Partner Roles13SRSIDSource of Datanvarchar100
154EHSWAT_APPAMOUNTMD: Waste Permit Predicted Quantities13SRSIDSource of Datanvarchar100
155EHSWAT_APPBPMD: Waste Permit Partner13SRSIDSource of Datanvarchar100
156EHSWAT_APPBPCONMD: Waste Permit - Partner - Contracts13SRSIDSource of Datanvarchar100
157EHSWAT_APPROVALMD: Waste Approval13SRSIDSource of Datanvarchar100
158EHSWAT_APPWAKEYMD: Waste Permit Waste Code13SRSIDSource of Datanvarchar100
159EHSWAT_BPDEFINITMD: Partner Reference to Master Data Objects13SRSIDSource of Datanvarchar100
160EHSWAT_BPIDMD: Partner - Jurisdiction-Dependent Data13SRSIDSource of Datanvarchar100
161EHSWAT_BPLIZLicenses for Partner13SRSIDSource of Datanvarchar100
162EHSWAT_BPWAAMMD: Partner-Waste Quantity Predictions13SRSIDSource of Datanvarchar100
163EHSWAT_BPWAKEYMD: Partner Waste Codes13SRSIDSource of Datanvarchar100
164EHSWAT_BPWAWAKEYMD: Partner-Waste Waste Code13SRSIDSource of Datanvarchar100
165EHSWAT_DCAPPMD: Disposal Channel-Waste Permit13SRSIDSource of Datanvarchar100
166EHSWAT_ENACCDisposal Processing: Account Assignments for Entry Document9SRSIDSource of Datanvarchar100
167EHSWAT_ENFODDisposal Processing: Follow-On Document Table9SRSIDSource of Datanvarchar100
168EHSWAT_ENPRTDisposal Processing: Partner for Entry Document9SRSIDSource of Datanvarchar100
169EHSWAT_ENTAMDisposal Processing (Quantity Entry/Planning)9SRSIDSource of Datanvarchar100
170EHSWAT_MNWaste Manifest/Delivery Note: Header Data9SRSIDSource of Datanvarchar100
171EHSWAT_MNACCAccount Assignments for Disposal Document9SRSIDSource of Datanvarchar100
172EHSWAT_MNBPWaste Manifest/Delivery Note: Partners9SRSIDSource of Datanvarchar100
173EHSWAT_MNPOSWaste Manifest/Delivery Note: Items9SRSIDSource of Datanvarchar100
174EHSWAT_MNWAKEYWaste Manifest/Delivery Note: Waste Code9SRSIDSource of Datanvarchar100
175EWA_EHSWAV_100EHSWAV_100 Local Table13SRSIDSource of Datanvarchar100