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

171 columns | Print definition?ERP 6.0  | PARKFLG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCD_DEC_DEObsolete8PARKFLGData Record Is Inactivenvarchar10
2EHPRCD_DEC_INObsolete8PARKFLGData Record Is Inactivenvarchar10
TOPCompliance Check
3EHSBT_RC_ESTRHSHEHS: Table f. Storing Substs w. Constraints in Shared Memory11PARKFLGData Record Is Inactivenvarchar10
TOPEnvironment, Health and Safety
4/TDAG/CPT_CHKENTCP: Check entries8PARKFLGData Record Is Inactivenvarchar10
5/TDAG/CPT_DECSUBCP: Declarable Substances8PARKFLGData Record Is Inactivenvarchar10
6/TDAG/CPT_DEC_DECP: Declarable Substances, Dependent attributes8PARKFLGData Record Is Inactivenvarchar10
7/TDAG/CPT_DEC_INCP: Declarable Substances, Independent attributes8PARKFLGData Record Is Inactivenvarchar10
8/TDAG/CPT_ESTMJEHS: Substance - material - allocation8PARKFLGData Record Is Inactivenvarchar10
9/TDAG/CPT_HISENTCP: Worklist entries for Compliance History8PARKFLGData Record Is Inactivenvarchar10
10/TDAG/CPT_IMDENTCP: IMDS entries8PARKFLGData Record Is Inactivenvarchar10
11/TDAG/CPT_REAENTCP: Reach entries8PARKFLGData Record Is Inactivenvarchar10
12/TDAG/CPT_REVENTCP: Revision entries8PARKFLGData Record Is Inactivenvarchar10
13DGTPKDG: Packing Requirement8PARKFLGData Record Is Inactivenvarchar10
14EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation8PARKFLGData Record Is Inactivenvarchar10
15EHQMT_MAIN2EH&S-QM: Characteristics for Inspection Plan Creation8PARKFLGData Record Is Inactivenvarchar10
16EHSBT_APPL_SCOPEEHS: General Scope of Application8PARKFLGData Record Is Inactivenvarchar10
TOPEnvironment, Health and Safety Master Data
17CCDUTCARRProvisions for Carriage8PARKFLGData Record Is Inactivenvarchar10
18CCDUTDGRELProduct Release8PARKFLGData Record Is Inactivenvarchar10
19CCDUTPACKPackaging Code Approvals8PARKFLGData Record Is Inactivenvarchar10
20CCDUTSPROVSpecial Provisions8PARKFLGData Record Is Inactivenvarchar10
21CCDUTTRAPPRTransport Restrictions8PARKFLGData Record Is Inactivenvarchar10
22DGTMDDG: Dangerous Goods Master8PARKFLGData Record Is Inactivenvarchar10
23ESTPHEHS: Phrase Header8PARKFLGData Record Is Inactivenvarchar10
24ESTPJEHS: Phrase set - phrase header assignment8PARKFLGData Record Is Inactivenvarchar10
25ESTPOEHS: Original Phrase8PARKFLGData Record Is Inactivenvarchar10
26ESTPPEHS: Phrase Item8PARKFLGData Record Is Inactivenvarchar10
27ESTPSEHS: Phrase Set8PARKFLGData Record Is Inactivenvarchar10
28ESTPTEHS: Language-Dependent Description for Phrase Sets8PARKFLGData Record Is Inactivenvarchar10
29HSMT_DNEHS: Hazardous Substance Addit. Data 2 (Numeric Type)8PARKFLGData Record Is Inactivenvarchar10
30HSMT_DTEHS: Hazardous Substance Addit. Data 1 (Text Type)8PARKFLGData Record Is Inactivenvarchar10
31HSMT_MDEHS: Hazardous Substance Basic Data8PARKFLGData Record Is Inactivenvarchar10
TOPIndustrial Hygiene and Safety
32CCIHT_ACHEHS: Safety Measures - Header8PARKFLGData Record Is Inactivenvarchar10
33CCIHT_AD08EHS: Customer Analysis Method 08 Detail Data8PARKFLGData Record Is Inactivenvarchar10
34CCIHT_AD09EHS: Customer Analysis Method 09 Detail Data8PARKFLGData Record Is Inactivenvarchar10
35CCIHT_AD10EHS: Customer Analysis Method 10 Detail Data8PARKFLGData Record Is Inactivenvarchar10
36CCIHT_AM01EHS: Customer Analysis Method 018PARKFLGData Record Is Inactivenvarchar10
37CCIHT_AM02EHS: Customer Analysis Method 028PARKFLGData Record Is Inactivenvarchar10
38CCIHT_AM03EHS: Customer Analysis Method 038PARKFLGData Record Is Inactivenvarchar10
39CCIHT_AM04EHS: Customer Analysis Method 048PARKFLGData Record Is Inactivenvarchar10
40CCIHT_AM05EHS: Customer Analysis Method 058PARKFLGData Record Is Inactivenvarchar10
41CCIHT_AM06EHS: Customer Analysis Method 068PARKFLGData Record Is Inactivenvarchar10
42CCIHT_AM07EHS: Customer Analysis Method 078PARKFLGData Record Is Inactivenvarchar10
43CCIHT_AM08EHS: Customer Analysis Method 088PARKFLGData Record Is Inactivenvarchar10
44CCIHT_AM09EHS: Customer Analysis Method 098PARKFLGData Record Is Inactivenvarchar10
45CCIHT_AM10EHS: Customer Analysis Method 108PARKFLGData Record Is Inactivenvarchar10
46CCIHT_ANMLEHS: Analysis Method - Meas. Value - Ref. Value Comparison8PARKFLGData Record Is Inactivenvarchar10
47CCIHT_ANNCEHS: Analysis Method - Standardized Criteria8PARKFLGData Record Is Inactivenvarchar10
48CCIHT_ANQSEHS: Analysis Method Questionnaire8PARKFLGData Record Is Inactivenvarchar10
49CCIHT_ANQSRELEHS: Analysis Method Questionnaire - Relevant Questions8PARKFLGData Record Is Inactivenvarchar10
50CCIHT_ANSCEHS: Analysis Method - Summated Rating (Header)8PARKFLGData Record Is Inactivenvarchar10
51CCIHT_ANSEEHS: Analysis Method - Summated Rating (Details)8PARKFLGData Record Is Inactivenvarchar10
52CCIHT_EPIEHS: Exposure Profile Entry8PARKFLGData Record Is Inactivenvarchar10
53CCIHT_ERAIEHS: Exposure Log - Additional Information8PARKFLGData Record Is Inactivenvarchar10
54CCIHT_ERHEHS: Risk Assessment - Header8PARKFLGData Record Is Inactivenvarchar10
55CCIHT_ERQTEHS: Exposure Assignment - Exposure Amounts8PARKFLGData Record Is Inactivenvarchar10
56CCIHT_ERRAEHS: - Obsolete - Exposure Assignment - Risk Assessment8PARKFLGData Record Is Inactivenvarchar10
57CCIHT_FALEHS: Injury/Illness Log8PARKFLGData Record Is Inactivenvarchar10
58CCIHT_FALMAEHS: Medical Measures8PARKFLGData Record Is Inactivenvarchar10
59CCIHT_FAVAEHS: Obsolete - Inj./Illn. Log Addit. Info. (Classif. Sys.)8PARKFLGData Record Is Inactivenvarchar10
60CCIHT_IALEHS: Incident/Accident Log - Header8PARKFLGData Record Is Inactivenvarchar10
61CCIHT_IAVAEHS: Obsolete - Inc./Acc. Log - Addit. Info. (Classif. Sys.)8PARKFLGData Record Is Inactivenvarchar10
62CCIHT_IHVAEHS: Value Assignment Data Records for Classific. System8PARKFLGData Record Is Inactivenvarchar10
63CCIHT_IPEHS: List of Persons Involved8PARKFLGData Record Is Inactivenvarchar10
64CCIHT_IPABSSEHS: Incident/Accident Log - Absences for Person Affected8PARKFLGData Record Is Inactivenvarchar10
65CCIHT_IPEVAEHS: Inc./Acc. Log - Data for Person Affected (Event)8PARKFLGData Record Is Inactivenvarchar10
66CCIHT_IPEVALIMEHS: Incident/Accident Log - Link Accident to Restrictions8PARKFLGData Record Is Inactivenvarchar10
67CCIHT_IPEVINJEHS: Injuries to Person Affected8PARKFLGData Record Is Inactivenvarchar10
68CCIHT_IPVAEHS: Obsolete -IAL, Person Aff. - Addit. Info. (Class. Sys.)8PARKFLGData Record Is Inactivenvarchar10
69CCIHT_MJEHS: Measurement8PARKFLGData Record Is Inactivenvarchar10
70CCIHT_MJIMPORTEHS: Pooled Table for Imported Measurements8PARKFLGData Record Is Inactivenvarchar10
71CCIHT_MJVAEHS: Measured Values8PARKFLGData Record Is Inactivenvarchar10
72CCIHT_MJVAIMPEHS: Imported Measured Values8PARKFLGData Record Is Inactivenvarchar10
73CCIHT_MJVAQTEHS: Table Temporary Data from Measured Values to Amounts8PARKFLGData Record Is Inactivenvarchar10
74CCIHT_MJWAEHS: Assignment of Work Area to Measurement Job8PARKFLGData Record Is Inactivenvarchar10
75CCIHT_MPEHS: Measurement Project8PARKFLGData Record Is Inactivenvarchar10
76CCIHT_MPDVEHS: Devices Required for Measurement Project8PARKFLGData Record Is Inactivenvarchar10
77CCIHT_MPMTEHS: Measurement Plan - Measurement Method8PARKFLGData Record Is Inactivenvarchar10
78CCIHT_MPPLEHS: Project Plan8PARKFLGData Record Is Inactivenvarchar10
79CCIHT_MPWAEHS: Assignment of Work Area to Measurement Project8PARKFLGData Record Is Inactivenvarchar10
80CCIHT_PTCPEHS: Pattern to Collective Pattern Assignment8PARKFLGData Record Is Inactivenvarchar10
81CCIHT_RCEHS: Accident Causes (Root Causes)8PARKFLGData Record Is Inactivenvarchar10
82CCIHT_RFMJEHS: Reference Measurement8PARKFLGData Record Is Inactivenvarchar10
83CCIHT_WAAEHS: Accident Location8PARKFLGData Record Is Inactivenvarchar10
84CCIHT_WAADEHS: Language-Dependent Description of Accident Location8PARKFLGData Record Is Inactivenvarchar10
85CCIHT_WADOEHS: Work Area - Links to Info Objects8PARKFLGData Record Is Inactivenvarchar10
86CCIHT_WAHEHS: Work Area - Header8PARKFLGData Record Is Inactivenvarchar10
87CCIHT_WAIHEHS: Work Area - Industrial Hygiene and Safety Data8PARKFLGData Record Is Inactivenvarchar10
88CCIHT_WALDEHS: Language-Dependent Name and Descr. of Work Area8PARKFLGData Record Is Inactivenvarchar10
89CCIHT_WAPTEHS: Assignment of Template to Work Area8PARKFLGData Record Is Inactivenvarchar10
90CCIHT_WAQSEHS: Work Area - Specific Questionnaire Assignment8PARKFLGData Record Is Inactivenvarchar10
TOPOccupational Health
91T7EHS00_VACCHEHS: Vaccination Data Header Information8PARKFLGData Record Is Inactivenvarchar10
TOPProduct Safety
92CCGLT_LSDEEHS: Label Stock - Language-Dependent Descriptions8PARKFLGData Record Is Inactivenvarchar10
93CCGLT_LSHDEHS: Label Stock Header Table8PARKFLGData Record Is Inactivenvarchar10
94CCGLT_LSLTEHS: Label Stock - Assigned Label Categories8PARKFLGData Record Is Inactivenvarchar10
95CCGLT_LSRVEHS: Label Stock - Assigned Validity Area8PARKFLGData Record Is Inactivenvarchar10
96CCGLT_LSTGEHS: Label Stock - Assigned Transport Symbol Groups8PARKFLGData Record Is Inactivenvarchar10
97CCUNTCARRProvisions for Carriage8PARKFLGData Record Is Inactivenvarchar10
98CCUNTPACKPacking Requirements8PARKFLGData Record Is Inactivenvarchar10
99CCUNTSPROVSpecial Packing Provisions8PARKFLGData Record Is Inactivenvarchar10
100CVDDCSEHS: Control Structure (Report Shipping)8PARKFLGData Record Is Inactivenvarchar10
101CVDDCSPEHS: Control Structure Parameters (Report Shipping)8PARKFLGData Record Is Inactivenvarchar10
102CVDDHEHS: Report shipping orders8PARKFLGData Record Is Inactivenvarchar10
103CVDDPEHS: Parameter Values for Report Shipping8PARKFLGData Record Is Inactivenvarchar10
104EST07EHS: Dangerous Goods Management - Transport Approval8PARKFLGData Record Is Inactivenvarchar10
105EST0BEHS: Dangerous Goods Management - Packaging Code Approval8PARKFLGData Record Is Inactivenvarchar10
106EST0DEHS: Dangerous Goods Management - Risk Classification8PARKFLGData Record Is Inactivenvarchar10
107EST0FEHS: Dangerous Goods Management - Transport Classification8PARKFLGData Record Is Inactivenvarchar10
108ESTDCSEHS: Control Structure (Report Body)8PARKFLGData Record Is Inactivenvarchar10
109ESTDCSPEHS: Parameter Control Structure8PARKFLGData Record Is Inactivenvarchar10
110ESTDFAdditional Information - User-Defined Text8PARKFLGData Record Is Inactivenvarchar10
111ESTDHEHS: Report Header8PARKFLGData Record Is Inactivenvarchar10
112ESTDJEHS: Assignment of Specifications to Reports8PARKFLGData Record Is Inactivenvarchar10
113ESTDOEHS: Report application objects8PARKFLGData Record Is Inactivenvarchar10
114ESTDREHS: Additional Information: Value Assignment Assessment8PARKFLGData Record Is Inactivenvarchar10
115ESTDSEHS: Additional Information: Value Assignment Source8PARKFLGData Record Is Inactivenvarchar10
116ESTDSCSEHS: eSDS Control Structure8PARKFLGData Record Is Inactivenvarchar10
117ESTDUEHS: Additional Information: Value Assignment Usage8PARKFLGData Record Is Inactivenvarchar10
118ESTLNEHS: Language-Dependent Description for Report Template8PARKFLGData Record Is Inactivenvarchar10
119ESTLPEHS: Report Variant8PARKFLGData Record Is Inactivenvarchar10
120ESTLREHS: Language-Dependent Description of Report Variant8PARKFLGData Record Is Inactivenvarchar10
121ESTLUEHS: Report Variant Rating8PARKFLGData Record Is Inactivenvarchar10
122ESTLVEHS: Report Variant Language (Labels Only)8PARKFLGData Record Is Inactivenvarchar10
123ESTMJEHS: Specification-Material Assignment8PARKFLGData Record Is Inactivenvarchar10
124ESTOHEHS: WWI generation / print jobs8PARKFLGData Record Is Inactivenvarchar10
125ESTRHEHS: Specification Header8PARKFLGData Record Is Inactivenvarchar10
126ESTRIEHS: Identifier (Numbers, Names, Chemical Formulas)8PARKFLGData Record Is Inactivenvarchar10
127ESTRLEHS: Identifier - Regulatory List Assignment8PARKFLGData Record Is Inactivenvarchar10
128ESTRREHS: Reference8PARKFLGData Record Is Inactivenvarchar10
129ESTSTEHS: Specification Status Assignment8PARKFLGData Record Is Inactivenvarchar10
130ESTVAEHS: Value Assignment8PARKFLGData Record Is Inactivenvarchar10
131ESTVHEHS: Specification - Value Assignment Type Assignment8PARKFLGData Record Is Inactivenvarchar10
132ESTVPEHS: Value Assignment Item8PARKFLGData Record Is Inactivenvarchar10
133ESTWLEHS: BOMBOS - Worklist Table8PARKFLGData Record Is Inactivenvarchar10
134ESTWOEHS: Print jobs8PARKFLGData Record Is Inactivenvarchar10
135TCGTPLIEHS: Inheritance Templates - Identifiers8PARKFLGData Record Is Inactivenvarchar10
136TCGTPLPEHS: Inheritance Templates - Properties8PARKFLGData Record Is Inactivenvarchar10
137TCGTPLRELEHS: Inheritance Relationships8PARKFLGData Record Is Inactivenvarchar10
138TCGTPLUEHS: Inheritance Templates - Usages8PARKFLGData Record Is Inactivenvarchar10
TOPResourcen Management
139RMSAT_LASTATRMS-ATL: Translation Status8PARKFLGData Record Is Inactivenvarchar10
140RMSAT_QMHDRQM: Header Table, Operation Level: Sample Drawing Takt, CCP8PARKFLGData Record Is Inactivenvarchar10
141RMSAT_QMINSPRMS: ATL QM List of Inspection Data for General Recipes8PARKFLGData Record Is Inactivenvarchar10
142RMSAT_QMINSPTRMS: ATL QM Detail Texts for Inspections in General Recipes8PARKFLGData Record Is Inactivenvarchar10
TOPWaste Management
143EHSWAT000MD (BDT): Master Table for the Waste Management Master Data8PARKFLGData Record Is Inactivenvarchar10
144EHSWAT001MD (BDT): Generator/Disposer/Transporter8PARKFLGData Record Is Inactivenvarchar10
145EHSWAT001ACCMD (BDT): Generator/Disposer/Transporter - Accnt Assignment8PARKFLGData Record Is Inactivenvarchar10
146EHSWAT001_DESCRMD (BDT): Language-Dependent Data for Partner9PARKFLGData Record Is Inactivenvarchar10
147EHSWAT002MD (BDT): Waste Generation/Disposal/Transport8PARKFLGData Record Is Inactivenvarchar10
148EHSWAT003MD (BDT): Disposal Channel8PARKFLGData Record Is Inactivenvarchar10
149EHSWAT100MD (BDT): Business Partner Roles8PARKFLGData Record Is Inactivenvarchar10
150EHSWAT_APPAMOUNTMD: Waste Permit Predicted Quantities8PARKFLGData Record Is Inactivenvarchar10
151EHSWAT_APPBPMD: Waste Permit Partner8PARKFLGData Record Is Inactivenvarchar10
152EHSWAT_APPBPCONMD: Waste Permit - Partner - Contracts8PARKFLGData Record Is Inactivenvarchar10
153EHSWAT_APPROVALMD: Waste Approval8PARKFLGData Record Is Inactivenvarchar10
154EHSWAT_APPWAKEYMD: Waste Permit Waste Code8PARKFLGData Record Is Inactivenvarchar10
155EHSWAT_BPDEFINITMD: Partner Reference to Master Data Objects8PARKFLGData Record Is Inactivenvarchar10
156EHSWAT_BPIDMD: Partner - Jurisdiction-Dependent Data8PARKFLGData Record Is Inactivenvarchar10
157EHSWAT_BPLIZLicenses for Partner8PARKFLGData Record Is Inactivenvarchar10
158EHSWAT_BPWAAMMD: Partner-Waste Quantity Predictions8PARKFLGData Record Is Inactivenvarchar10
159EHSWAT_BPWAKEYMD: Partner Waste Codes8PARKFLGData Record Is Inactivenvarchar10
160EHSWAT_BPWAWAKEYMD: Partner-Waste Waste Code8PARKFLGData Record Is Inactivenvarchar10
161EHSWAT_DCAPPMD: Disposal Channel-Waste Permit8PARKFLGData Record Is Inactivenvarchar10
162EHSWAT_ENACCDisposal Processing: Account Assignments for Entry Document4PARKFLGData Record Is Inactivenvarchar10
163EHSWAT_ENFODDisposal Processing: Follow-On Document Table4PARKFLGData Record Is Inactivenvarchar10
164EHSWAT_ENPRTDisposal Processing: Partner for Entry Document4PARKFLGData Record Is Inactivenvarchar10
165EHSWAT_ENTAMDisposal Processing (Quantity Entry/Planning)4PARKFLGData Record Is Inactivenvarchar10
166EHSWAT_MNWaste Manifest/Delivery Note: Header Data4PARKFLGData Record Is Inactivenvarchar10
167EHSWAT_MNACCAccount Assignments for Disposal Document4PARKFLGData Record Is Inactivenvarchar10
168EHSWAT_MNBPWaste Manifest/Delivery Note: Partners4PARKFLGData Record Is Inactivenvarchar10
169EHSWAT_MNPOSWaste Manifest/Delivery Note: Items4PARKFLGData Record Is Inactivenvarchar10
170EHSWAT_MNWAKEYWaste Manifest/Delivery Note: Waste Code4PARKFLGData Record Is Inactivenvarchar10
171EWA_EHSWAV_100EHSWAV_100 Local Table8PARKFLGData Record Is Inactivenvarchar10