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

198 columns | Print definition?ERP 6.0  | VALFR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKK_MA_AGAObjects That Are Assigned to an Agreement7VALFRStart of Assignmentnvarchar80
2DFKK_MA_BPAPartners Who Belong to a Business Partner Group5VALFRStart of Assignmentnvarchar80
3DFKK_MA_PRAProducts That Belong to a Product Group6VALFRStart of Assignmentnvarchar80
4DFKK_VT_DCT: Discounts on Provider Contract5VALFRStart of Validity for Discount/Charge Keydecimal150
5DFKK_VT_TRCT: IDs of Provider Contract (Technical Resources)6VALFRValid From (Time Stamp)decimal150
6EHPRCD_DEC_DEObsolete4VALFRValid-From Datenvarchar80
7EHPRCD_DEC_INObsolete4VALFRValid-From Datenvarchar80
TOPAerospace Defence Industry Solution
8DIWPS_HEADReallocation: Conversion Plant/Work center6VALFRDatenvarchar80
9DIWPS_OPERReallocation: Conversion Plant/Work center6VALFRDatenvarchar80
10DIWPS_WORKReallocation: Conversion Plant/Work center8VALFRDatenvarchar80
TOPBasic Data and Tools
11EHSBC_BUF_PROTEHS-BAS: Object Change Log (see Documentation)4VALFRValid-From Datenvarchar80
TOPCompliance Check
12EHSBT_RC_ESTRHSHEHS: Table f. Storing Substs w. Constraints in Shared Memory7VALFRValid-From Datenvarchar80
TOPConfiguration management
13IBINCMIB: Config.Mang.: Component/Instance3VALFRIBase: Valid Fromdecimal150
14IBSPCMIB: Config.Mang.: Specialization3VALFRIBase: Valid Fromdecimal150
15IBSTCMIB: Conf.Mang.:Structure3VALFRIBase: Valid Fromdecimal150
TOPContract Accounts Receivable and Payable
16DFKK_VT_ICT: Items of Provider Contract11VALFRValid From (Time Stamp)decimal150
17TFKRFCODESelection Codes for Refill Packages3VALFRStart of Validity for the Selection Codenvarchar80
18TFKRFCODEPAssigned Refill Packages3VALFRStart of Validity for the Selection Codenvarchar80
TOPCross-Application Components
19FRE_DB_VKP_TDF&R Sales Price TD4VALFRF&R Time Stamp at Start of Validity Perioddecimal150
TOPDangerous Goods Management
20TDG67DG: Define UN numbers (new)4VALFRValid-From Datenvarchar80
21TDG68DG: Text table for UN number (new)5VALFRValid-From Datenvarchar80
TOPEnvironment, Health and Safety
22/TDAG/CPT_CHKENTCP: Check entries4VALFRValid-From Datenvarchar80
23/TDAG/CPT_DECSUBCP: Declarable Substances4VALFRValid-From Datenvarchar80
24/TDAG/CPT_DEC_DECP: Declarable Substances, Dependent attributes4VALFRValid-From Datenvarchar80
25/TDAG/CPT_DEC_INCP: Declarable Substances, Independent attributes4VALFRValid-From Datenvarchar80
26/TDAG/CPT_ESTMJEHS: Substance - material - allocation4VALFRValid-From Datenvarchar80
27/TDAG/CPT_HISENTCP: Worklist entries for Compliance History4VALFRValid-From Datenvarchar80
28/TDAG/CPT_IMDENTCP: IMDS entries4VALFRValid-From Datenvarchar80
29/TDAG/CPT_REAENTCP: Reach entries4VALFRValid-From Datenvarchar80
30/TDAG/CPT_REVENTCP: Revision entries4VALFRValid-From Datenvarchar80
31DGTPKDG: Packing Requirement4VALFRValid-From Datenvarchar80
32EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation4VALFRValid-From Datenvarchar80
33EHQMT_MAIN2EH&S-QM: Characteristics for Inspection Plan Creation4VALFRValid-From Datenvarchar80
34EHSBT_APPL_SCOPEEHS: General Scope of Application4VALFRValid-From Datenvarchar80
TOPEnvironment, Health and Safety Master Data
35CCDUTCARRProvisions for Carriage4VALFRValid-From Datenvarchar80
36CCDUTDGRELProduct Release4VALFRValid-From Datenvarchar80
37CCDUTPACKPackaging Code Approvals4VALFRValid-From Datenvarchar80
38CCDUTSPROVSpecial Provisions4VALFRValid-From Datenvarchar80
39CCDUTTRAPPRTransport Restrictions4VALFRValid-From Datenvarchar80
40DGTMDDG: Dangerous Goods Master4VALFRValid-From Datenvarchar80
41ESTPHEHS: Phrase Header4VALFRValid-From Datenvarchar80
42ESTPJEHS: Phrase set - phrase header assignment4VALFRValid-From Datenvarchar80
43ESTPOEHS: Original Phrase4VALFRValid-From Datenvarchar80
44ESTPPEHS: Phrase Item4VALFRValid-From Datenvarchar80
45ESTPSEHS: Phrase Set4VALFRValid-From Datenvarchar80
46ESTPTEHS: Language-Dependent Description for Phrase Sets4VALFRValid-From Datenvarchar80
47HSMT_DNEHS: Hazardous Substance Addit. Data 2 (Numeric Type)4VALFRValid-From Datenvarchar80
48HSMT_DTEHS: Hazardous Substance Addit. Data 1 (Text Type)4VALFRValid-From Datenvarchar80
49HSMT_MDEHS: Hazardous Substance Basic Data4VALFRValid-From Datenvarchar80
TOPFunds Management
50FMLGD_H_CUSTNote to Payee Control8VALFRClassification Key ofnvarchar300
TOPIndustrial Hygiene and Safety
51CCIHT_ACHEHS: Safety Measures - Header4VALFRValid-From Datenvarchar80
52CCIHT_AD08EHS: Customer Analysis Method 08 Detail Data4VALFRValid-From Datenvarchar80
53CCIHT_AD09EHS: Customer Analysis Method 09 Detail Data4VALFRValid-From Datenvarchar80
54CCIHT_AD10EHS: Customer Analysis Method 10 Detail Data4VALFRValid-From Datenvarchar80
55CCIHT_AM01EHS: Customer Analysis Method 014VALFRValid-From Datenvarchar80
56CCIHT_AM02EHS: Customer Analysis Method 024VALFRValid-From Datenvarchar80
57CCIHT_AM03EHS: Customer Analysis Method 034VALFRValid-From Datenvarchar80
58CCIHT_AM04EHS: Customer Analysis Method 044VALFRValid-From Datenvarchar80
59CCIHT_AM05EHS: Customer Analysis Method 054VALFRValid-From Datenvarchar80
60CCIHT_AM06EHS: Customer Analysis Method 064VALFRValid-From Datenvarchar80
61CCIHT_AM07EHS: Customer Analysis Method 074VALFRValid-From Datenvarchar80
62CCIHT_AM08EHS: Customer Analysis Method 084VALFRValid-From Datenvarchar80
63CCIHT_AM09EHS: Customer Analysis Method 094VALFRValid-From Datenvarchar80
64CCIHT_AM10EHS: Customer Analysis Method 104VALFRValid-From Datenvarchar80
65CCIHT_ANMLEHS: Analysis Method - Meas. Value - Ref. Value Comparison4VALFRValid-From Datenvarchar80
66CCIHT_ANNCEHS: Analysis Method - Standardized Criteria4VALFRValid-From Datenvarchar80
67CCIHT_ANQSEHS: Analysis Method Questionnaire4VALFRValid-From Datenvarchar80
68CCIHT_ANQSRELEHS: Analysis Method Questionnaire - Relevant Questions4VALFRValid-From Datenvarchar80
69CCIHT_ANSCEHS: Analysis Method - Summated Rating (Header)4VALFRValid-From Datenvarchar80
70CCIHT_ANSEEHS: Analysis Method - Summated Rating (Details)4VALFRValid-From Datenvarchar80
71CCIHT_EPIEHS: Exposure Profile Entry4VALFRValid-From Datenvarchar80
72CCIHT_ERAIEHS: Exposure Log - Additional Information4VALFRValid-From Datenvarchar80
73CCIHT_ERHEHS: Risk Assessment - Header4VALFRValid-From Datenvarchar80
74CCIHT_ERQTEHS: Exposure Assignment - Exposure Amounts4VALFRValid-From Datenvarchar80
75CCIHT_ERRAEHS: - Obsolete - Exposure Assignment - Risk Assessment4VALFRValid-From Datenvarchar80
76CCIHT_FALEHS: Injury/Illness Log4VALFRValid-From Datenvarchar80
77CCIHT_FALMAEHS: Medical Measures4VALFRValid-From Datenvarchar80
78CCIHT_FAVAEHS: Obsolete - Inj./Illn. Log Addit. Info. (Classif. Sys.)4VALFRValid-From Datenvarchar80
79CCIHT_IALEHS: Incident/Accident Log - Header4VALFRValid-From Datenvarchar80
80CCIHT_IAVAEHS: Obsolete - Inc./Acc. Log - Addit. Info. (Classif. Sys.)4VALFRValid-From Datenvarchar80
81CCIHT_IHVAEHS: Value Assignment Data Records for Classific. System4VALFRValid-From Datenvarchar80
82CCIHT_IPEHS: List of Persons Involved4VALFRValid-From Datenvarchar80
83CCIHT_IPABSSEHS: Incident/Accident Log - Absences for Person Affected4VALFRValid-From Datenvarchar80
84CCIHT_IPEVAEHS: Inc./Acc. Log - Data for Person Affected (Event)4VALFRValid-From Datenvarchar80
85CCIHT_IPEVALIMEHS: Incident/Accident Log - Link Accident to Restrictions4VALFRValid-From Datenvarchar80
86CCIHT_IPEVINJEHS: Injuries to Person Affected4VALFRValid-From Datenvarchar80
87CCIHT_IPVAEHS: Obsolete -IAL, Person Aff. - Addit. Info. (Class. Sys.)4VALFRValid-From Datenvarchar80
88CCIHT_MJEHS: Measurement4VALFRValid-From Datenvarchar80
89CCIHT_MJIMPORTEHS: Pooled Table for Imported Measurements4VALFRValid-From Datenvarchar80
90CCIHT_MJVAEHS: Measured Values4VALFRValid-From Datenvarchar80
91CCIHT_MJVAIMPEHS: Imported Measured Values4VALFRValid-From Datenvarchar80
92CCIHT_MJVAQTEHS: Table Temporary Data from Measured Values to Amounts4VALFRValid-From Datenvarchar80
93CCIHT_MJWAEHS: Assignment of Work Area to Measurement Job4VALFRValid-From Datenvarchar80
94CCIHT_MPEHS: Measurement Project4VALFRValid-From Datenvarchar80
95CCIHT_MPDVEHS: Devices Required for Measurement Project4VALFRValid-From Datenvarchar80
96CCIHT_MPMTEHS: Measurement Plan - Measurement Method4VALFRValid-From Datenvarchar80
97CCIHT_MPPLEHS: Project Plan4VALFRValid-From Datenvarchar80
98CCIHT_MPWAEHS: Assignment of Work Area to Measurement Project4VALFRValid-From Datenvarchar80
99CCIHT_PTCPEHS: Pattern to Collective Pattern Assignment4VALFRValid-From Datenvarchar80
100CCIHT_RCEHS: Accident Causes (Root Causes)4VALFRValid-From Datenvarchar80
101CCIHT_RFMJEHS: Reference Measurement4VALFRValid-From Datenvarchar80
102CCIHT_WAAEHS: Accident Location4VALFRValid-From Datenvarchar80
103CCIHT_WAADEHS: Language-Dependent Description of Accident Location4VALFRValid-From Datenvarchar80
104CCIHT_WADOEHS: Work Area - Links to Info Objects4VALFRValid-From Datenvarchar80
105CCIHT_WAHEHS: Work Area - Header4VALFRValid-From Datenvarchar80
106CCIHT_WAIHEHS: Work Area - Industrial Hygiene and Safety Data4VALFRValid-From Datenvarchar80
107CCIHT_WALDEHS: Language-Dependent Name and Descr. of Work Area4VALFRValid-From Datenvarchar80
108CCIHT_WAPTEHS: Assignment of Template to Work Area4VALFRValid-From Datenvarchar80
109CCIHT_WAQSEHS: Work Area - Specific Questionnaire Assignment4VALFRValid-From Datenvarchar80
TOPInstalled Base
110IBADDRIBase: Business Address Services Connection3VALFRIBase: Valid Fromdecimal150
111IBINIB: IBase Components - Condition3VALFRIBase: Valid Fromdecimal150
112IBINTXIBase: Text for the Instance3VALFRIBase: Valid Fromdecimal150
113IBSPIB: Installed Base Component - Enhancement/Specialization3VALFRIBase: Valid Fromdecimal150
114IBSTIB: Installation Component - Structure3VALFRIBase: Valid Fromdecimal150
TOPMaterials Management
115/ISDFPS/1DPERHEHS: Single Permit Header5VALFRValid-From Datenvarchar80
116/ISDFPS/DG_EXCPTDG Management: Exception Requests DG Check OBSOLETE15VALFRValid-From Datenvarchar80
TOPOccupational Health
117T7EHS00_VACCHEHS: Vaccination Data Header Information4VALFRValid-From Datenvarchar80
TOPProduct Safety
118CCGLT_LSDEEHS: Label Stock - Language-Dependent Descriptions4VALFRValid-From Datenvarchar80
119CCGLT_LSHDEHS: Label Stock Header Table4VALFRValid-From Datenvarchar80
120CCGLT_LSLTEHS: Label Stock - Assigned Label Categories4VALFRValid-From Datenvarchar80
121CCGLT_LSRVEHS: Label Stock - Assigned Validity Area4VALFRValid-From Datenvarchar80
122CCGLT_LSTGEHS: Label Stock - Assigned Transport Symbol Groups4VALFRValid-From Datenvarchar80
123CCRCC_BWEHS: Maintenance of Bonded Warehouses7VALFRValid-From Datenvarchar80
124CCRCT_EHS_COMPEHS: Composition (EH&S Data)8VALFRValid-From Datenvarchar80
125CCRCT_EHS_SLIMITEHS: Limit Values in Substance (EH&S Data)8VALFRValid-From Datenvarchar80
126CCRCT_ORMaterial Business Partner Only Representative Assignment14VALFRValid-From Datenvarchar80
127CCUNTCARRProvisions for Carriage4VALFRValid-From Datenvarchar80
128CCUNTPACKPacking Requirements4VALFRValid-From Datenvarchar80
129CCUNTSPROVSpecial Packing Provisions4VALFRValid-From Datenvarchar80
130CVDDCSEHS: Control Structure (Report Shipping)4VALFRValid-From Datenvarchar80
131CVDDCSPEHS: Control Structure Parameters (Report Shipping)4VALFRValid-From Datenvarchar80
132CVDDHEHS: Report shipping orders4VALFRValid-From Datenvarchar80
133CVDDPEHS: Parameter Values for Report Shipping4VALFRValid-From Datenvarchar80
134EST07EHS: Dangerous Goods Management - Transport Approval4VALFRValid-From Datenvarchar80
135EST0BEHS: Dangerous Goods Management - Packaging Code Approval4VALFRValid-From Datenvarchar80
136EST0DEHS: Dangerous Goods Management - Risk Classification4VALFRValid-From Datenvarchar80
137EST0FEHS: Dangerous Goods Management - Transport Classification4VALFRValid-From Datenvarchar80
138ESTDCSEHS: Control Structure (Report Body)4VALFRValid-From Datenvarchar80
139ESTDCSPEHS: Parameter Control Structure4VALFRValid-From Datenvarchar80
140ESTDFAdditional Information - User-Defined Text4VALFRValid-From Datenvarchar80
141ESTDHEHS: Report Header4VALFRValid-From Datenvarchar80
142ESTDJEHS: Assignment of Specifications to Reports4VALFRValid-From Datenvarchar80
143ESTDOEHS: Report application objects4VALFRValid-From Datenvarchar80
144ESTDREHS: Additional Information: Value Assignment Assessment4VALFRValid-From Datenvarchar80
145ESTDSEHS: Additional Information: Value Assignment Source4VALFRValid-From Datenvarchar80
146ESTDSCSEHS: eSDS Control Structure4VALFRValid-From Datenvarchar80
147ESTDUEHS: Additional Information: Value Assignment Usage4VALFRValid-From Datenvarchar80
148ESTLNEHS: Language-Dependent Description for Report Template4VALFRValid-From Datenvarchar80
149ESTLPEHS: Report Variant4VALFRValid-From Datenvarchar80
150ESTLREHS: Language-Dependent Description of Report Variant4VALFRValid-From Datenvarchar80
151ESTLUEHS: Report Variant Rating4VALFRValid-From Datenvarchar80
152ESTLVEHS: Report Variant Language (Labels Only)4VALFRValid-From Datenvarchar80
153ESTMJEHS: Specification-Material Assignment4VALFRValid-From Datenvarchar80
154ESTOHEHS: WWI generation / print jobs4VALFRValid-From Datenvarchar80
155ESTRHEHS: Specification Header4VALFRValid-From Datenvarchar80
156ESTRIEHS: Identifier (Numbers, Names, Chemical Formulas)4VALFRValid-From Datenvarchar80
157ESTRLEHS: Identifier - Regulatory List Assignment4VALFRValid-From Datenvarchar80
158ESTRREHS: Reference4VALFRValid-From Datenvarchar80
159ESTSTEHS: Specification Status Assignment4VALFRValid-From Datenvarchar80
160ESTVAEHS: Value Assignment4VALFRValid-From Datenvarchar80
161ESTVHEHS: Specification - Value Assignment Type Assignment4VALFRValid-From Datenvarchar80
162ESTVPEHS: Value Assignment Item4VALFRValid-From Datenvarchar80
163ESTWLEHS: BOMBOS - Worklist Table4VALFRValid-From Datenvarchar80
164ESTWOEHS: Print jobs4VALFRValid-From Datenvarchar80
165EST_CHANGE_DOCSEHS: Change Documents in the EH&S System13VALFRValid-From Datenvarchar80
166TCGHITEHS: No. of hits6VALFRFrom-Date for Specification Search Over Time Periodnvarchar80
167TCGOUTVAREHS: Output variants6VALFRFrom-Date for Specification Search Over Time Periodnvarchar80
168TCGQUEEHS: Queries6VALFRFrom-Date for Specification Search Over Time Periodnvarchar80
169TCGRULEHS: Easy Expert Set of Rules6VALFRFrom-Date for Specification Search Over Time Periodnvarchar80
170TCGTPLHEHS: Inheritance Template Header6VALFRFrom-Date for Specification Search Over Time Periodnvarchar80
171TCGTPLIEHS: Inheritance Templates - Identifiers4VALFRValid-From Datenvarchar80
172TCGTPLPEHS: Inheritance Templates - Properties4VALFRValid-From Datenvarchar80
173TCGTPLRELEHS: Inheritance Relationships4VALFRValid-From Datenvarchar80
174TCGTPLUEHS: Inheritance Templates - Usages4VALFRValid-From Datenvarchar80
TOPResourcen Management
175RMSAT_LASTATRMS-ATL: Translation Status4VALFRValid-From Datenvarchar80
176RMSAT_QMHDRQM: Header Table, Operation Level: Sample Drawing Takt, CCP4VALFRValid-From Datenvarchar80
177RMSAT_QMINSPRMS: ATL QM List of Inspection Data for General Recipes4VALFRValid-From Datenvarchar80
178RMSAT_QMINSPTRMS: ATL QM Detail Texts for Inspections in General Recipes4VALFRValid-From Datenvarchar80
TOPWaste Management
179EHSWAT000MD (BDT): Master Table for the Waste Management Master Data4VALFRValid-From Datenvarchar80
180EHSWAT001MD (BDT): Generator/Disposer/Transporter4VALFRValid-From Datenvarchar80
181EHSWAT001ACCMD (BDT): Generator/Disposer/Transporter - Accnt Assignment4VALFRValid-From Datenvarchar80
182EHSWAT001_DESCRMD (BDT): Language-Dependent Data for Partner5VALFRValid-From Datenvarchar80
183EHSWAT002MD (BDT): Waste Generation/Disposal/Transport4VALFRValid-From Datenvarchar80
184EHSWAT003MD (BDT): Disposal Channel4VALFRValid-From Datenvarchar80
185EHSWAT100MD (BDT): Business Partner Roles4VALFRValid-From Datenvarchar80
186EHSWAT_APPAMOUNTMD: Waste Permit Predicted Quantities4VALFRValid-From Datenvarchar80
187EHSWAT_APPBPMD: Waste Permit Partner4VALFRValid-From Datenvarchar80
188EHSWAT_APPBPCONMD: Waste Permit - Partner - Contracts4VALFRValid-From Datenvarchar80
189EHSWAT_APPROVALMD: Waste Approval4VALFRValid-From Datenvarchar80
190EHSWAT_APPWAKEYMD: Waste Permit Waste Code4VALFRValid-From Datenvarchar80
191EHSWAT_BPDEFINITMD: Partner Reference to Master Data Objects4VALFRValid-From Datenvarchar80
192EHSWAT_BPIDMD: Partner - Jurisdiction-Dependent Data4VALFRValid-From Datenvarchar80
193EHSWAT_BPLIZLicenses for Partner4VALFRValid-From Datenvarchar80
194EHSWAT_BPWAAMMD: Partner-Waste Quantity Predictions4VALFRValid-From Datenvarchar80
195EHSWAT_BPWAKEYMD: Partner Waste Codes4VALFRValid-From Datenvarchar80
196EHSWAT_BPWAWAKEYMD: Partner-Waste Waste Code4VALFRValid-From Datenvarchar80
197EHSWAT_DCAPPMD: Disposal Channel-Waste Permit4VALFRValid-From Datenvarchar80
198EWA_EHSWAV_100EHSWAV_100 Local Table4VALFRValid-From Datenvarchar80