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

179 columns | Print definition?ERP 6.0  | ACTN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCD_COD_SPECSpecification Data9ACTNSequential Number of the Change Statenvarchar200
2EHPRCD_DEC_DEObsolete3ACTNSequential Number of the Change Statenvarchar200
3EHPRCD_DEC_INObsolete3ACTNSequential Number of the Change Statenvarchar200
4EHPRCD_PCR_COMPLCompliance Check Result16ACTNSequential Number of the Change Statenvarchar200
TOPCompliance Check
5EHSBT_RC_ESTRHSHEHS: Table f. Storing Substs w. Constraints in Shared Memory6ACTNSequential Number of the Change Statenvarchar200
6EHSBT_RC_EXPLSHMEHS: Table for Storing Explosion Result in Shared Memory6ACTNSequential Number of the Change Statenvarchar200
TOPEnvironment, Health and Safety
7/TDAG/CPT_CHKENTCP: Check entries3ACTNSequential Number of the Change Statenvarchar200
8/TDAG/CPT_DECSUBCP: Declarable Substances3ACTNSequential Number of the Change Statenvarchar200
9/TDAG/CPT_DEC_DECP: Declarable Substances, Dependent attributes3ACTNSequential Number of the Change Statenvarchar200
10/TDAG/CPT_DEC_INCP: Declarable Substances, Independent attributes3ACTNSequential Number of the Change Statenvarchar200
11/TDAG/CPT_ESTMJEHS: Substance - material - allocation3ACTNSequential Number of the Change Statenvarchar200
12/TDAG/CPT_HISENTCP: Worklist entries for Compliance History3ACTNSequential Number of the Change Statenvarchar200
13/TDAG/CPT_IMDENTCP: IMDS entries3ACTNSequential Number of the Change Statenvarchar200
14/TDAG/CPT_REAENTCP: Reach entries3ACTNSequential Number of the Change Statenvarchar200
15/TDAG/CPT_REVENTCP: Revision entries3ACTNSequential Number of the Change Statenvarchar200
16DGTPKDG: Packing Requirement3ACTNSequential Number of the Change Statenvarchar200
17EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation3ACTNSequential Number of the Change Statenvarchar200
18EHQMT_MAIN2EH&S-QM: Characteristics for Inspection Plan Creation3ACTNSequential Number of the Change Statenvarchar200
19EHSBT_APPL_SCOPEEHS: General Scope of Application3ACTNGUID Numbernvarchar320
TOPEnvironment, Health and Safety Master Data
20CCDUTCARRProvisions for Carriage3ACTNSequential Number of the Change Statenvarchar200
21CCDUTDGRELProduct Release3ACTNSequential Number of the Change Statenvarchar200
22CCDUTPACKPackaging Code Approvals3ACTNSequential Number of the Change Statenvarchar200
23CCDUTSPROVSpecial Provisions3ACTNSequential Number of the Change Statenvarchar200
24CCDUTTRAPPRTransport Restrictions3ACTNSequential Number of the Change Statenvarchar200
25DGTM2DG: Dangerous Goods Master (App. Table)3ACTNSequential Number of the Change Statenvarchar200
26DGTMDDG: Dangerous Goods Master3ACTNSequential Number of the Change Statenvarchar200
27ESTPHEHS: Phrase Header3ACTNSequential Number of the Change Statenvarchar200
28ESTPJEHS: Phrase set - phrase header assignment3ACTNSequential Number of the Change Statenvarchar200
29ESTPOEHS: Original Phrase3ACTNSequential Number of the Change Statenvarchar200
30ESTPPEHS: Phrase Item3ACTNSequential Number of the Change Statenvarchar200
31ESTPSEHS: Phrase Set3ACTNSequential Number of the Change Statenvarchar200
32ESTPTEHS: Language-Dependent Description for Phrase Sets3ACTNSequential Number of the Change Statenvarchar200
33HSMT_DNEHS: Hazardous Substance Addit. Data 2 (Numeric Type)3ACTNSequential Number of the Change Statenvarchar200
34HSMT_DTEHS: Hazardous Substance Addit. Data 1 (Text Type)3ACTNSequential Number of the Change Statenvarchar200
35HSMT_MDEHS: Hazardous Substance Basic Data3ACTNSequential Number of the Change Statenvarchar200
TOPIndustrial Hygiene and Safety
36CCIHT_ACHEHS: Safety Measures - Header3ACTNSequential Number of the Change Statenvarchar200
37CCIHT_AD08EHS: Customer Analysis Method 08 Detail Data3ACTNSequential Number of the Change Statenvarchar200
38CCIHT_AD09EHS: Customer Analysis Method 09 Detail Data3ACTNSequential Number of the Change Statenvarchar200
39CCIHT_AD10EHS: Customer Analysis Method 10 Detail Data3ACTNSequential Number of the Change Statenvarchar200
40CCIHT_AM01EHS: Customer Analysis Method 013ACTNSequential Number of the Change Statenvarchar200
41CCIHT_AM02EHS: Customer Analysis Method 023ACTNSequential Number of the Change Statenvarchar200
42CCIHT_AM03EHS: Customer Analysis Method 033ACTNSequential Number of the Change Statenvarchar200
43CCIHT_AM04EHS: Customer Analysis Method 043ACTNSequential Number of the Change Statenvarchar200
44CCIHT_AM05EHS: Customer Analysis Method 053ACTNSequential Number of the Change Statenvarchar200
45CCIHT_AM06EHS: Customer Analysis Method 063ACTNSequential Number of the Change Statenvarchar200
46CCIHT_AM07EHS: Customer Analysis Method 073ACTNSequential Number of the Change Statenvarchar200
47CCIHT_AM08EHS: Customer Analysis Method 083ACTNSequential Number of the Change Statenvarchar200
48CCIHT_AM09EHS: Customer Analysis Method 093ACTNSequential Number of the Change Statenvarchar200
49CCIHT_AM10EHS: Customer Analysis Method 103ACTNSequential Number of the Change Statenvarchar200
50CCIHT_ANMLEHS: Analysis Method - Meas. Value - Ref. Value Comparison3ACTNSequential Number of the Change Statenvarchar200
51CCIHT_ANNCEHS: Analysis Method - Standardized Criteria3ACTNSequential Number of the Change Statenvarchar200
52CCIHT_ANQSEHS: Analysis Method Questionnaire3ACTNSequential Number of the Change Statenvarchar200
53CCIHT_ANQSRELEHS: Analysis Method Questionnaire - Relevant Questions3ACTNSequential Number of the Change Statenvarchar200
54CCIHT_ANSCEHS: Analysis Method - Summated Rating (Header)3ACTNSequential Number of the Change Statenvarchar200
55CCIHT_ANSEEHS: Analysis Method - Summated Rating (Details)3ACTNSequential Number of the Change Statenvarchar200
56CCIHT_EPIEHS: Exposure Profile Entry3ACTNSequential Number of the Change Statenvarchar200
57CCIHT_ERAIEHS: Exposure Log - Additional Information3ACTNSequential Number of the Change Statenvarchar200
58CCIHT_ERHEHS: Risk Assessment - Header3ACTNSequential Number of the Change Statenvarchar200
59CCIHT_ERQTEHS: Exposure Assignment - Exposure Amounts3ACTNSequential Number of the Change Statenvarchar200
60CCIHT_ERRAEHS: - Obsolete - Exposure Assignment - Risk Assessment3ACTNSequential Number of the Change Statenvarchar200
61CCIHT_FALEHS: Injury/Illness Log3ACTNSequential Number of the Change Statenvarchar200
62CCIHT_FALMAEHS: Medical Measures3ACTNSequential Number of the Change Statenvarchar200
63CCIHT_FAVAEHS: Obsolete - Inj./Illn. Log Addit. Info. (Classif. Sys.)3ACTNSequential Number of the Change Statenvarchar200
64CCIHT_IALEHS: Incident/Accident Log - Header3ACTNSequential Number of the Change Statenvarchar200
65CCIHT_IAVAEHS: Obsolete - Inc./Acc. Log - Addit. Info. (Classif. Sys.)3ACTNSequential Number of the Change Statenvarchar200
66CCIHT_IHVAEHS: Value Assignment Data Records for Classific. System3ACTNSequential Number of the Change Statenvarchar200
67CCIHT_IPEHS: List of Persons Involved3ACTNSequential Number of the Change Statenvarchar200
68CCIHT_IPABSSEHS: Incident/Accident Log - Absences for Person Affected3ACTNSequential Number of the Change Statenvarchar200
69CCIHT_IPEVAEHS: Inc./Acc. Log - Data for Person Affected (Event)3ACTNSequential Number of the Change Statenvarchar200
70CCIHT_IPEVALIMEHS: Incident/Accident Log - Link Accident to Restrictions3ACTNSequential Number of the Change Statenvarchar200
71CCIHT_IPEVINJEHS: Injuries to Person Affected3ACTNSequential Number of the Change Statenvarchar200
72CCIHT_IPVAEHS: Obsolete -IAL, Person Aff. - Addit. Info. (Class. Sys.)3ACTNSequential Number of the Change Statenvarchar200
73CCIHT_MJEHS: Measurement3ACTNSequential Number of the Change Statenvarchar200
74CCIHT_MJIMPORTEHS: Pooled Table for Imported Measurements3ACTNSequential Number of the Change Statenvarchar200
75CCIHT_MJVAEHS: Measured Values3ACTNSequential Number of the Change Statenvarchar200
76CCIHT_MJVAIMPEHS: Imported Measured Values3ACTNSequential Number of the Change Statenvarchar200
77CCIHT_MJVAQTEHS: Table Temporary Data from Measured Values to Amounts3ACTNSequential Number of the Change Statenvarchar200
78CCIHT_MJWAEHS: Assignment of Work Area to Measurement Job3ACTNSequential Number of the Change Statenvarchar200
79CCIHT_MPEHS: Measurement Project3ACTNSequential Number of the Change Statenvarchar200
80CCIHT_MPDVEHS: Devices Required for Measurement Project3ACTNSequential Number of the Change Statenvarchar200
81CCIHT_MPMTEHS: Measurement Plan - Measurement Method3ACTNSequential Number of the Change Statenvarchar200
82CCIHT_MPPLEHS: Project Plan3ACTNSequential Number of the Change Statenvarchar200
83CCIHT_MPWAEHS: Assignment of Work Area to Measurement Project3ACTNSequential Number of the Change Statenvarchar200
84CCIHT_PTCPEHS: Pattern to Collective Pattern Assignment3ACTNSequential Number of the Change Statenvarchar200
85CCIHT_RCEHS: Accident Causes (Root Causes)3ACTNSequential Number of the Change Statenvarchar200
86CCIHT_RFMJEHS: Reference Measurement3ACTNSequential Number of the Change Statenvarchar200
87CCIHT_WAAEHS: Accident Location3ACTNSequential Number of the Change Statenvarchar200
88CCIHT_WAADEHS: Language-Dependent Description of Accident Location3ACTNSequential Number of the Change Statenvarchar200
89CCIHT_WADOEHS: Work Area - Links to Info Objects3ACTNSequential Number of the Change Statenvarchar200
90CCIHT_WAHEHS: Work Area - Header3ACTNSequential Number of the Change Statenvarchar200
91CCIHT_WAIHEHS: Work Area - Industrial Hygiene and Safety Data3ACTNSequential Number of the Change Statenvarchar200
92CCIHT_WALDEHS: Language-Dependent Name and Descr. of Work Area3ACTNSequential Number of the Change Statenvarchar200
93CCIHT_WAPTEHS: Assignment of Template to Work Area3ACTNSequential Number of the Change Statenvarchar200
94CCIHT_WAQSEHS: Work Area - Specific Questionnaire Assignment3ACTNSequential Number of the Change Statenvarchar200
TOPOccupational Health
95T7EHS00_CAL_FAVEHS: Medical Practice Calendar Favorites3ACTNSequential Number of the Change Statenvarchar200
96T7EHS00_CAL_PHYSAssgmt of MP Calendar Owner to Physician for Service Appt3ACTNSequential Number of the Change Statenvarchar200
97T7EHS00_VACCHEHS: Vaccination Data Header Information3ACTNSequential Number of the Change Statenvarchar200
TOPProduct Safety
98CCGLT_AUDHEHS: Audit Data Header Entry3ACTNSequential Number of the Change Statenvarchar200
99CCGLT_AUDIEHS: Audit Icon/Parameter Values3ACTNSequential Number of the Change Statenvarchar200
100CCGLT_AUDSEHS: Audit Data for Serial Numbers3ACTNSequential Number of the Change Statenvarchar200
101CCGLT_CLBLEHS: Customer-Specific Labels3ACTNSequential Number of the Change Statenvarchar200
102CCGLT_LSDEEHS: Label Stock - Language-Dependent Descriptions3ACTNSequential Number of the Change Statenvarchar200
103CCGLT_LSHDEHS: Label Stock Header Table3ACTNSequential Number of the Change Statenvarchar200
104CCGLT_LSLTEHS: Label Stock - Assigned Label Categories3ACTNSequential Number of the Change Statenvarchar200
105CCGLT_LSRVEHS: Label Stock - Assigned Validity Area3ACTNSequential Number of the Change Statenvarchar200
106CCGLT_LSTGEHS: Label Stock - Assigned Transport Symbol Groups3ACTNSequential Number of the Change Statenvarchar200
107CCGLT_MTLDEHS: Labeling Data for a Material3ACTNSequential Number of the Change Statenvarchar200
108CCGLT_MTLSEHS: Label Definition for a Material3ACTNSequential Number of the Change Statenvarchar200
109CCGLT_MTLVEHS: Label Definition - Validity Areas3ACTNSequential Number of the Change Statenvarchar200
110CCRCT_ORMaterial Business Partner Only Representative Assignment3ACTNSequential Number of the Change Statenvarchar200
111CCUNTCARRProvisions for Carriage3ACTNSequential Number of the Change Statenvarchar200
112CCUNTPACKPacking Requirements3ACTNSequential Number of the Change Statenvarchar200
113CCUNTSPROVSpecial Packing Provisions3ACTNSequential Number of the Change Statenvarchar200
114CVDDCSEHS: Control Structure (Report Shipping)3ACTNSequential Number of the Change Statenvarchar200
115CVDDCSPEHS: Control Structure Parameters (Report Shipping)3ACTNSequential Number of the Change Statenvarchar200
116CVDDHEHS: Report shipping orders3ACTNSequential Number of the Change Statenvarchar200
117CVDDPEHS: Parameter Values for Report Shipping3ACTNSequential Number of the Change Statenvarchar200
118EST07EHS: Dangerous Goods Management - Transport Approval3ACTNSequential Number of the Change Statenvarchar200
119EST0BEHS: Dangerous Goods Management - Packaging Code Approval3ACTNSequential Number of the Change Statenvarchar200
120EST0DEHS: Dangerous Goods Management - Risk Classification3ACTNSequential Number of the Change Statenvarchar200
121EST0FEHS: Dangerous Goods Management - Transport Classification3ACTNSequential Number of the Change Statenvarchar200
122ESTALEEHS: ALE - reference to originals3ACTNSequential Number of the Change Statenvarchar200
123ESTDCSEHS: Control Structure (Report Body)3ACTNSequential Number of the Change Statenvarchar200
124ESTDCSPEHS: Parameter Control Structure3ACTNSequential Number of the Change Statenvarchar200
125ESTDFAdditional Information - User-Defined Text3ACTNSequential Number of the Change Statenvarchar200
126ESTDHEHS: Report Header3ACTNSequential Number of the Change Statenvarchar200
127ESTDJEHS: Assignment of Specifications to Reports3ACTNSequential Number of the Change Statenvarchar200
128ESTDOEHS: Report application objects3ACTNSequential Number of the Change Statenvarchar200
129ESTDREHS: Additional Information: Value Assignment Assessment3ACTNSequential Number of the Change Statenvarchar200
130ESTDSEHS: Additional Information: Value Assignment Source3ACTNSequential Number of the Change Statenvarchar200
131ESTDSCSEHS: eSDS Control Structure3ACTNSequential Number of the Change Statenvarchar200
132ESTDUEHS: Additional Information: Value Assignment Usage3ACTNSequential Number of the Change Statenvarchar200
133ESTLNEHS: Language-Dependent Description for Report Template3ACTNSequential Number of the Change Statenvarchar200
134ESTLPEHS: Report Variant3ACTNSequential Number of the Change Statenvarchar200
135ESTLREHS: Language-Dependent Description of Report Variant3ACTNSequential Number of the Change Statenvarchar200
136ESTLUEHS: Report Variant Rating3ACTNSequential Number of the Change Statenvarchar200
137ESTLVEHS: Report Variant Language (Labels Only)3ACTNSequential Number of the Change Statenvarchar200
138ESTMJEHS: Specification-Material Assignment3ACTNSequential Number of the Change Statenvarchar200
139ESTOCCEHS: OCC: Table for Saving Import Information3ACTNSequential Number of the Change Statenvarchar200
140ESTOCCADDINFOEHS: OCC: Information About Additional Tables Loaded3ACTNSequential Number of the Change Statenvarchar200
141ESTOHEHS: WWI generation / print jobs3ACTNSequential Number of the Change Statenvarchar200
142ESTRHEHS: Specification Header3ACTNSequential Number of the Change Statenvarchar200
143ESTRIEHS: Identifier (Numbers, Names, Chemical Formulas)3ACTNSequential Number of the Change Statenvarchar200
144ESTRLEHS: Identifier - Regulatory List Assignment3ACTNSequential Number of the Change Statenvarchar200
145ESTRREHS: Reference3ACTNSequential Number of the Change Statenvarchar200
146ESTSTEHS: Specification Status Assignment3ACTNSequential Number of the Change Statenvarchar200
147ESTVAEHS: Value Assignment3ACTNSequential Number of the Change Statenvarchar200
148ESTVHEHS: Specification - Value Assignment Type Assignment3ACTNSequential Number of the Change Statenvarchar200
149ESTVPEHS: Value Assignment Item3ACTNSequential Number of the Change Statenvarchar200
150ESTWLEHS: BOMBOS - Worklist Table3ACTNSequential Number of the Change Statenvarchar200
151ESTWOEHS: Print jobs3ACTNSequential Number of the Change Statenvarchar200
152TCGTPLIEHS: Inheritance Templates - Identifiers3ACTNSequential Number of the Change Statenvarchar200
153TCGTPLPEHS: Inheritance Templates - Properties3ACTNSequential Number of the Change Statenvarchar200
154TCGTPLRELEHS: Inheritance Relationships3ACTNSequential Number of the Change Statenvarchar200
155TCGTPLUEHS: Inheritance Templates - Usages3ACTNSequential Number of the Change Statenvarchar200
TOPResourcen Management
156RMSAT_LASTATRMS-ATL: Translation Status3ACTNGUID Numbernvarchar320
157RMSAT_QMHDRQM: Header Table, Operation Level: Sample Drawing Takt, CCP3ACTNGUID Numbernvarchar320
158RMSAT_QMINSPRMS: ATL QM List of Inspection Data for General Recipes3ACTNGUID Numbernvarchar320
159RMSAT_QMINSPTRMS: ATL QM Detail Texts for Inspections in General Recipes3ACTNGUID Numbernvarchar320
TOPWaste Management
160EHSWAT000MD (BDT): Master Table for the Waste Management Master Data3ACTNGUID Numbernvarchar320
161EHSWAT001MD (BDT): Generator/Disposer/Transporter3ACTNGUID Numbernvarchar320
162EHSWAT001ACCMD (BDT): Generator/Disposer/Transporter - Accnt Assignment3ACTNGUID Numbernvarchar320
163EHSWAT001_DESCRMD (BDT): Language-Dependent Data for Partner3ACTNGUID Numbernvarchar320
164EHSWAT002MD (BDT): Waste Generation/Disposal/Transport3ACTNGUID Numbernvarchar320
165EHSWAT003MD (BDT): Disposal Channel3ACTNGUID Numbernvarchar320
166EHSWAT100MD (BDT): Business Partner Roles3ACTNGUID Numbernvarchar320
167EHSWAT_APPAMOUNTMD: Waste Permit Predicted Quantities3ACTNGUID Numbernvarchar320
168EHSWAT_APPBPMD: Waste Permit Partner3ACTNGUID Numbernvarchar320
169EHSWAT_APPBPCONMD: Waste Permit - Partner - Contracts3ACTNGUID Numbernvarchar320
170EHSWAT_APPROVALMD: Waste Approval3ACTNGUID Numbernvarchar320
171EHSWAT_APPWAKEYMD: Waste Permit Waste Code3ACTNGUID Numbernvarchar320
172EHSWAT_BPDEFINITMD: Partner Reference to Master Data Objects3ACTNGUID Numbernvarchar320
173EHSWAT_BPIDMD: Partner - Jurisdiction-Dependent Data3ACTNGUID Numbernvarchar320
174EHSWAT_BPLIZLicenses for Partner3ACTNGUID Numbernvarchar320
175EHSWAT_BPWAAMMD: Partner-Waste Quantity Predictions3ACTNGUID Numbernvarchar320
176EHSWAT_BPWAKEYMD: Partner Waste Codes3ACTNGUID Numbernvarchar320
177EHSWAT_BPWAWAKEYMD: Partner-Waste Waste Code3ACTNGUID Numbernvarchar320
178EHSWAT_DCAPPMD: Disposal Channel-Waste Permit3ACTNGUID Numbernvarchar320
179EWA_EHSWAV_100EHSWAV_100 Local Table3ACTNGUID (Global Unique Identifier)nvarchar320