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

173 columns | Print definition?ERP 6.0  | OWNID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCD_DEC_DEObsolete14OWNIDData Providernvarchar100
2EHPRCD_DEC_INObsolete14OWNIDData Providernvarchar100
TOPCompliance Check
3EHSBT_RC_ESTRHSHEHS: Table f. Storing Substs w. Constraints in Shared Memory17OWNIDData Providernvarchar100
TOPEnvironment, Health and Safety
4/TDAG/CPT_CHKENTCP: Check entries14OWNIDData Providernvarchar100
5/TDAG/CPT_DECSUBCP: Declarable Substances14OWNIDData Providernvarchar100
6/TDAG/CPT_DEC_DECP: Declarable Substances, Dependent attributes14OWNIDData Providernvarchar100
7/TDAG/CPT_DEC_INCP: Declarable Substances, Independent attributes14OWNIDData Providernvarchar100
8/TDAG/CPT_ESTMJEHS: Substance - material - allocation14OWNIDData Providernvarchar100
9/TDAG/CPT_HISENTCP: Worklist entries for Compliance History14OWNIDData Providernvarchar100
10/TDAG/CPT_IMDENTCP: IMDS entries14OWNIDData Providernvarchar100
11/TDAG/CPT_REAENTCP: Reach entries14OWNIDData Providernvarchar100
12/TDAG/CPT_REVENTCP: Revision entries14OWNIDData Providernvarchar100
13DGTPKDG: Packing Requirement14OWNIDData Providernvarchar100
14EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation14OWNIDData Providernvarchar100
15EHQMT_MAIN2EH&S-QM: Characteristics for Inspection Plan Creation14OWNIDData Providernvarchar100
16EHSBT_APPL_SCOPEEHS: General Scope of Application14OWNIDData Providernvarchar100
17TCG36EHS: Specification Authorization Object3OWNIDData Providernvarchar100
18TCGC3EHS: Exchange profile17OWNIDData Providernvarchar100
TOPEnvironment, Health and Safety Master Data
19CCDUTCARRProvisions for Carriage14OWNIDData Providernvarchar100
20CCDUTDGRELProduct Release14OWNIDData Providernvarchar100
21CCDUTPACKPackaging Code Approvals14OWNIDData Providernvarchar100
22CCDUTSPROVSpecial Provisions14OWNIDData Providernvarchar100
23CCDUTTRAPPRTransport Restrictions14OWNIDData Providernvarchar100
24DGTMDDG: Dangerous Goods Master14OWNIDData Providernvarchar100
25ESTPHEHS: Phrase Header14OWNIDData Providernvarchar100
26ESTPJEHS: Phrase set - phrase header assignment14OWNIDData Providernvarchar100
27ESTPOEHS: Original Phrase14OWNIDData Providernvarchar100
28ESTPPEHS: Phrase Item14OWNIDData Providernvarchar100
29ESTPSEHS: Phrase Set14OWNIDData Providernvarchar100
30ESTPTEHS: Language-Dependent Description for Phrase Sets14OWNIDData Providernvarchar100
31HSMT_DNEHS: Hazardous Substance Addit. Data 2 (Numeric Type)14OWNIDData Providernvarchar100
32HSMT_DTEHS: Hazardous Substance Addit. Data 1 (Text Type)14OWNIDData Providernvarchar100
33HSMT_MDEHS: Hazardous Substance Basic Data14OWNIDData Providernvarchar100
TOPIndustrial Hygiene and Safety
34CCIHT_ACHEHS: Safety Measures - Header14OWNIDData Providernvarchar100
35CCIHT_AD08EHS: Customer Analysis Method 08 Detail Data14OWNIDData Providernvarchar100
36CCIHT_AD09EHS: Customer Analysis Method 09 Detail Data14OWNIDData Providernvarchar100
37CCIHT_AD10EHS: Customer Analysis Method 10 Detail Data14OWNIDData Providernvarchar100
38CCIHT_AM01EHS: Customer Analysis Method 0114OWNIDData Providernvarchar100
39CCIHT_AM02EHS: Customer Analysis Method 0214OWNIDData Providernvarchar100
40CCIHT_AM03EHS: Customer Analysis Method 0314OWNIDData Providernvarchar100
41CCIHT_AM04EHS: Customer Analysis Method 0414OWNIDData Providernvarchar100
42CCIHT_AM05EHS: Customer Analysis Method 0514OWNIDData Providernvarchar100
43CCIHT_AM06EHS: Customer Analysis Method 0614OWNIDData Providernvarchar100
44CCIHT_AM07EHS: Customer Analysis Method 0714OWNIDData Providernvarchar100
45CCIHT_AM08EHS: Customer Analysis Method 0814OWNIDData Providernvarchar100
46CCIHT_AM09EHS: Customer Analysis Method 0914OWNIDData Providernvarchar100
47CCIHT_AM10EHS: Customer Analysis Method 1014OWNIDData Providernvarchar100
48CCIHT_ANMLEHS: Analysis Method - Meas. Value - Ref. Value Comparison14OWNIDData Providernvarchar100
49CCIHT_ANNCEHS: Analysis Method - Standardized Criteria14OWNIDData Providernvarchar100
50CCIHT_ANQSEHS: Analysis Method Questionnaire14OWNIDData Providernvarchar100
51CCIHT_ANQSRELEHS: Analysis Method Questionnaire - Relevant Questions14OWNIDData Providernvarchar100
52CCIHT_ANSCEHS: Analysis Method - Summated Rating (Header)14OWNIDData Providernvarchar100
53CCIHT_ANSEEHS: Analysis Method - Summated Rating (Details)14OWNIDData Providernvarchar100
54CCIHT_EPIEHS: Exposure Profile Entry14OWNIDData Providernvarchar100
55CCIHT_ERAIEHS: Exposure Log - Additional Information14OWNIDData Providernvarchar100
56CCIHT_ERHEHS: Risk Assessment - Header14OWNIDData Providernvarchar100
57CCIHT_ERQTEHS: Exposure Assignment - Exposure Amounts14OWNIDData Providernvarchar100
58CCIHT_ERRAEHS: - Obsolete - Exposure Assignment - Risk Assessment14OWNIDData Providernvarchar100
59CCIHT_FALEHS: Injury/Illness Log14OWNIDData Providernvarchar100
60CCIHT_FALMAEHS: Medical Measures14OWNIDData Providernvarchar100
61CCIHT_FAVAEHS: Obsolete - Inj./Illn. Log Addit. Info. (Classif. Sys.)14OWNIDData Providernvarchar100
62CCIHT_IALEHS: Incident/Accident Log - Header14OWNIDData Providernvarchar100
63CCIHT_IAVAEHS: Obsolete - Inc./Acc. Log - Addit. Info. (Classif. Sys.)14OWNIDData Providernvarchar100
64CCIHT_IHVAEHS: Value Assignment Data Records for Classific. System14OWNIDData Providernvarchar100
65CCIHT_IPEHS: List of Persons Involved14OWNIDData Providernvarchar100
66CCIHT_IPABSSEHS: Incident/Accident Log - Absences for Person Affected14OWNIDData Providernvarchar100
67CCIHT_IPEVAEHS: Inc./Acc. Log - Data for Person Affected (Event)14OWNIDData Providernvarchar100
68CCIHT_IPEVALIMEHS: Incident/Accident Log - Link Accident to Restrictions14OWNIDData Providernvarchar100
69CCIHT_IPEVINJEHS: Injuries to Person Affected14OWNIDData Providernvarchar100
70CCIHT_IPVAEHS: Obsolete -IAL, Person Aff. - Addit. Info. (Class. Sys.)14OWNIDData Providernvarchar100
71CCIHT_MJEHS: Measurement14OWNIDData Providernvarchar100
72CCIHT_MJIMPORTEHS: Pooled Table for Imported Measurements14OWNIDData Providernvarchar100
73CCIHT_MJVAEHS: Measured Values14OWNIDData Providernvarchar100
74CCIHT_MJVAIMPEHS: Imported Measured Values14OWNIDData Providernvarchar100
75CCIHT_MJVAQTEHS: Table Temporary Data from Measured Values to Amounts14OWNIDData Providernvarchar100
76CCIHT_MJWAEHS: Assignment of Work Area to Measurement Job14OWNIDData Providernvarchar100
77CCIHT_MPEHS: Measurement Project14OWNIDData Providernvarchar100
78CCIHT_MPDVEHS: Devices Required for Measurement Project14OWNIDData Providernvarchar100
79CCIHT_MPMTEHS: Measurement Plan - Measurement Method14OWNIDData Providernvarchar100
80CCIHT_MPPLEHS: Project Plan14OWNIDData Providernvarchar100
81CCIHT_MPWAEHS: Assignment of Work Area to Measurement Project14OWNIDData Providernvarchar100
82CCIHT_PTCPEHS: Pattern to Collective Pattern Assignment14OWNIDData Providernvarchar100
83CCIHT_RCEHS: Accident Causes (Root Causes)14OWNIDData Providernvarchar100
84CCIHT_RFMJEHS: Reference Measurement14OWNIDData Providernvarchar100
85CCIHT_WAAEHS: Accident Location14OWNIDData Providernvarchar100
86CCIHT_WAADEHS: Language-Dependent Description of Accident Location14OWNIDData Providernvarchar100
87CCIHT_WADOEHS: Work Area - Links to Info Objects14OWNIDData Providernvarchar100
88CCIHT_WAHEHS: Work Area - Header14OWNIDData Providernvarchar100
89CCIHT_WAIHEHS: Work Area - Industrial Hygiene and Safety Data14OWNIDData Providernvarchar100
90CCIHT_WALDEHS: Language-Dependent Name and Descr. of Work Area14OWNIDData Providernvarchar100
91CCIHT_WAPTEHS: Assignment of Template to Work Area14OWNIDData Providernvarchar100
92CCIHT_WAQSEHS: Work Area - Specific Questionnaire Assignment14OWNIDData Providernvarchar100
TOPOccupational Health
93T7EHS00_VACCHEHS: Vaccination Data Header Information14OWNIDData Providernvarchar100
TOPProduct Safety
94CCGLT_LSDEEHS: Label Stock - Language-Dependent Descriptions14OWNIDData Providernvarchar100
95CCGLT_LSHDEHS: Label Stock Header Table14OWNIDData Providernvarchar100
96CCGLT_LSLTEHS: Label Stock - Assigned Label Categories14OWNIDData Providernvarchar100
97CCGLT_LSRVEHS: Label Stock - Assigned Validity Area14OWNIDData Providernvarchar100
98CCGLT_LSTGEHS: Label Stock - Assigned Transport Symbol Groups14OWNIDData Providernvarchar100
99CCUNTCARRProvisions for Carriage14OWNIDData Providernvarchar100
100CCUNTPACKPacking Requirements14OWNIDData Providernvarchar100
101CCUNTSPROVSpecial Packing Provisions14OWNIDData Providernvarchar100
102CVDDCSEHS: Control Structure (Report Shipping)14OWNIDData Providernvarchar100
103CVDDCSPEHS: Control Structure Parameters (Report Shipping)14OWNIDData Providernvarchar100
104CVDDHEHS: Report shipping orders14OWNIDData Providernvarchar100
105CVDDPEHS: Parameter Values for Report Shipping14OWNIDData Providernvarchar100
106EST07EHS: Dangerous Goods Management - Transport Approval14OWNIDData Providernvarchar100
107EST0BEHS: Dangerous Goods Management - Packaging Code Approval14OWNIDData Providernvarchar100
108EST0DEHS: Dangerous Goods Management - Risk Classification14OWNIDData Providernvarchar100
109EST0FEHS: Dangerous Goods Management - Transport Classification14OWNIDData Providernvarchar100
110ESTDCSEHS: Control Structure (Report Body)14OWNIDData Providernvarchar100
111ESTDCSPEHS: Parameter Control Structure14OWNIDData Providernvarchar100
112ESTDFAdditional Information - User-Defined Text14OWNIDData Providernvarchar100
113ESTDHEHS: Report Header14OWNIDData Providernvarchar100
114ESTDJEHS: Assignment of Specifications to Reports14OWNIDData Providernvarchar100
115ESTDOEHS: Report application objects14OWNIDData Providernvarchar100
116ESTDREHS: Additional Information: Value Assignment Assessment14OWNIDData Providernvarchar100
117ESTDSEHS: Additional Information: Value Assignment Source14OWNIDData Providernvarchar100
118ESTDSCSEHS: eSDS Control Structure14OWNIDData Providernvarchar100
119ESTDUEHS: Additional Information: Value Assignment Usage14OWNIDData Providernvarchar100
120ESTLNEHS: Language-Dependent Description for Report Template14OWNIDData Providernvarchar100
121ESTLPEHS: Report Variant14OWNIDData Providernvarchar100
122ESTLREHS: Language-Dependent Description of Report Variant14OWNIDData Providernvarchar100
123ESTLUEHS: Report Variant Rating14OWNIDData Providernvarchar100
124ESTLVEHS: Report Variant Language (Labels Only)14OWNIDData Providernvarchar100
125ESTMJEHS: Specification-Material Assignment14OWNIDData Providernvarchar100
126ESTOHEHS: WWI generation / print jobs14OWNIDData Providernvarchar100
127ESTRHEHS: Specification Header14OWNIDData Providernvarchar100
128ESTRIEHS: Identifier (Numbers, Names, Chemical Formulas)14OWNIDData Providernvarchar100
129ESTRLEHS: Identifier - Regulatory List Assignment14OWNIDData Providernvarchar100
130ESTRREHS: Reference14OWNIDData Providernvarchar100
131ESTSTEHS: Specification Status Assignment14OWNIDData Providernvarchar100
132ESTVAEHS: Value Assignment14OWNIDData Providernvarchar100
133ESTVHEHS: Specification - Value Assignment Type Assignment14OWNIDData Providernvarchar100
134ESTVPEHS: Value Assignment Item14OWNIDData Providernvarchar100
135ESTWLEHS: BOMBOS - Worklist Table14OWNIDData Providernvarchar100
136ESTWOEHS: Print jobs14OWNIDData Providernvarchar100
137TCGTPLIEHS: Inheritance Templates - Identifiers14OWNIDData Providernvarchar100
138TCGTPLPEHS: Inheritance Templates - Properties14OWNIDData Providernvarchar100
139TCGTPLRELEHS: Inheritance Relationships14OWNIDData Providernvarchar100
140TCGTPLUEHS: Inheritance Templates - Usages14OWNIDData Providernvarchar100
TOPResourcen Management
141RMSAT_LASTATRMS-ATL: Translation Status14OWNIDData Providernvarchar100
142RMSAT_QMHDRQM: Header Table, Operation Level: Sample Drawing Takt, CCP14OWNIDData Providernvarchar100
143RMSAT_QMINSPRMS: ATL QM List of Inspection Data for General Recipes14OWNIDData Providernvarchar100
144RMSAT_QMINSPTRMS: ATL QM Detail Texts for Inspections in General Recipes14OWNIDData Providernvarchar100
TOPWaste Management
145EHSWAT000MD (BDT): Master Table for the Waste Management Master Data14OWNIDData Providernvarchar100
146EHSWAT001MD (BDT): Generator/Disposer/Transporter14OWNIDData Providernvarchar100
147EHSWAT001ACCMD (BDT): Generator/Disposer/Transporter - Accnt Assignment14OWNIDData Providernvarchar100
148EHSWAT001_DESCRMD (BDT): Language-Dependent Data for Partner15OWNIDData Providernvarchar100
149EHSWAT002MD (BDT): Waste Generation/Disposal/Transport14OWNIDData Providernvarchar100
150EHSWAT003MD (BDT): Disposal Channel14OWNIDData Providernvarchar100
151EHSWAT100MD (BDT): Business Partner Roles14OWNIDData Providernvarchar100
152EHSWAT_APPAMOUNTMD: Waste Permit Predicted Quantities14OWNIDData Providernvarchar100
153EHSWAT_APPBPMD: Waste Permit Partner14OWNIDData Providernvarchar100
154EHSWAT_APPBPCONMD: Waste Permit - Partner - Contracts14OWNIDData Providernvarchar100
155EHSWAT_APPROVALMD: Waste Approval14OWNIDData Providernvarchar100
156EHSWAT_APPWAKEYMD: Waste Permit Waste Code14OWNIDData Providernvarchar100
157EHSWAT_BPDEFINITMD: Partner Reference to Master Data Objects14OWNIDData Providernvarchar100
158EHSWAT_BPIDMD: Partner - Jurisdiction-Dependent Data14OWNIDData Providernvarchar100
159EHSWAT_BPLIZLicenses for Partner14OWNIDData Providernvarchar100
160EHSWAT_BPWAAMMD: Partner-Waste Quantity Predictions14OWNIDData Providernvarchar100
161EHSWAT_BPWAKEYMD: Partner Waste Codes14OWNIDData Providernvarchar100
162EHSWAT_BPWAWAKEYMD: Partner-Waste Waste Code14OWNIDData Providernvarchar100
163EHSWAT_DCAPPMD: Disposal Channel-Waste Permit14OWNIDData Providernvarchar100
164EHSWAT_ENACCDisposal Processing: Account Assignments for Entry Document10OWNIDData Providernvarchar100
165EHSWAT_ENFODDisposal Processing: Follow-On Document Table10OWNIDData Providernvarchar100
166EHSWAT_ENPRTDisposal Processing: Partner for Entry Document10OWNIDData Providernvarchar100
167EHSWAT_ENTAMDisposal Processing (Quantity Entry/Planning)10OWNIDData Providernvarchar100
168EHSWAT_MNWaste Manifest/Delivery Note: Header Data10OWNIDData Providernvarchar100
169EHSWAT_MNACCAccount Assignments for Disposal Document10OWNIDData Providernvarchar100
170EHSWAT_MNBPWaste Manifest/Delivery Note: Partners10OWNIDData Providernvarchar100
171EHSWAT_MNPOSWaste Manifest/Delivery Note: Items10OWNIDData Providernvarchar100
172EHSWAT_MNWAKEYWaste Manifest/Delivery Note: Waste Code10OWNIDData Providernvarchar100
173EWA_EHSWAV_100EHSWAV_100 Local Table14OWNIDData Providernvarchar100