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

134 columns | Print definition?ERP 6.0  | DESCRIPTION_LONG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CPFC_CUSSTRUCC_TCPF Custom Structure Component - Description6DESCRIPTION_LONGCustom Structure: Description (Long)nvarchar600
2CPFC_CUSSTRUC_TCPF Custom Structure - Description5DESCRIPTION_LONGCustom Structure: Description (Long)nvarchar600
3CPFC_PARAMCAT_TCPF Parameter Catalog - Description6DESCRIPTION_LONGDescription Parameter Catalognvarchar600
4EHFNDC_AUTHENT_TAuthorization Entity description5DESCRIPTION_LONGDescription (Long)nvarchar1320
5EHFNDC_CHALIST_TChemical Approval Checklist5DESCRIPTION_LONGDescription (Long)nvarchar1320
6EHFNDC_CHASTEP_TChemical Approval Step Descriptions5DESCRIPTION_LONGDescription (Long)nvarchar1320
7EHFNDC_CHCLASS_TClassification of Chemicals5DESCRIPTION_LONGDescription (Long)nvarchar1320
8EHFNDC_CHCOLOR_TColors of Chemicals5DESCRIPTION_LONGDescription (Long)nvarchar1320
9EHFNDC_CHFORM_TForms of Chemicals5DESCRIPTION_LONGDescription (Long)nvarchar1320
10EHFNDC_CHODOR_TOdor of Chemicals5DESCRIPTION_LONGDescription (Long)nvarchar1320
11EHFNDC_CTQUEST_TControl Inspection Question5DESCRIPTION_LONGDescription (Extra Long)nvarchar2550
12EHFNDC_EWGHC_TClassification According to 67/548/EEC (Text Table)5DESCRIPTION_LONGDescription (Long)nvarchar1320
13EHFNDC_EWGRS_TRisk Phrases (Text Table)5DESCRIPTION_LONGDescription (Long)nvarchar1320
14EHFNDC_EXP_DS_TDescription of Data Selection5DESCRIPTION_LONGDescription (Long)nvarchar1320
15EHFNDC_EXP_FFM_TDescriptions of File Formats of Export Files5DESCRIPTION_LONGDescription (Long)nvarchar1320
16EHFNDC_EXP_PROFTDescription of Export Profile5DESCRIPTION_LONGDescription (Long)nvarchar1320
17EHFNDC_FFSEM_TFire Fight Suitable Extinguishing Media5DESCRIPTION_LONGDescription (Long)nvarchar1320
18EHFNDC_FFUEM_TFire Fight Unsuitable Extinguishing Media5DESCRIPTION_LONGDescription (Long)nvarchar1320
19EHFNDC_HAZSTM_THazard Statements5DESCRIPTION_LONGDescription (Long)nvarchar1320
20EHFNDC_HAZSW_THazard Signalword5DESCRIPTION_LONGDescription (Long)nvarchar1320
21EHFNDC_LOCROLE_TRole of Responsible Person for Location5DESCRIPTION_LONGDescription (Long)nvarchar1320
22EHFNDC_MEA_CAT_TMeasurement Categories5DESCRIPTION_LONGDescription (Long)nvarchar1320
23EHFNDC_MEA_ROL_TMeasurement Data Collector Roles5DESCRIPTION_LONGDescription (Long)nvarchar1320
24EHFNDC_METH_TMethod of Use of the Chemical5DESCRIPTION_LONGDescription (Long)nvarchar1320
25EHFNDC_PROF_TAuthorization Field Profile5DESCRIPTION_LONGDescription (Long)nvarchar1320
26EHFNDC_PURP_TPurpose of the Chemical5DESCRIPTION_LONGDescription (Long)nvarchar1320
27EHFNDC_REGLIST_TRegulatory List5DESCRIPTION_LONGDescription (Long)nvarchar1320
28EHFNDC_SCLASS_TStorage Class5DESCRIPTION_LONGDescription (Long)nvarchar1320
29EHFNDC_SHADJUS_TShift Adjustment5DESCRIPTION_LONGDescription (Long)nvarchar1320
30EHFNDC_SHFTPAT_TShift Pattern for for OEL Adjustment5DESCRIPTION_LONGDescription (Long)nvarchar1320
31EHFNDC_SOM_TState of Matter5DESCRIPTION_LONGDescription (Long)nvarchar1320
32EHFNDC_SPLMT_TSampling Method Type Texts5DESCRIPTION_LONGDescription (Long)nvarchar1320
33EHFNDC_TPL_NOD_TTable Template for CODE-Phrase-Attributes Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
34EHFNDC_VALTYPE_TValue Types5DESCRIPTION_LONGDescription (Long)nvarchar1320
35EHFNDC_WHCLASS_TWater Hazard Class5DESCRIPTION_LONGDescription (Long)nvarchar1320
36EHFNDC_WSOL_TWater Solubility Remark5DESCRIPTION_LONGDescription (Long)nvarchar1320
37EHHSSC_CONFLVL_TConfidence Level Rating5DESCRIPTION_LONGDescription (Long)nvarchar1320
38EHHSSC_SEGROLE_TSEG Team Member Role Code5DESCRIPTION_LONGDescription (Long)nvarchar1320
39EHPRCC_RLSREL_TRelease Relevant Levels5DESCRIPTION_LONGDescription (Long)nvarchar1320
40EHPRCI_CMPLC_TCompliance Status Code - translated4DESCRIPTION_LONGDescription (Long)nvarchar1320
TOPBusiness Objects, Common Components
41EHDMOC_ADR_DST_TCustomizing Table for District5DESCRIPTION_LONGDescription (Long)nvarchar1320
42EHDMOC_ADR_FLR_TCustomizing Table for Floor5DESCRIPTION_LONGDescription (Long)nvarchar1320
43EHFNDC_ACTEFF_TAction Effectivity Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
44EHFNDC_ACTPRTG_TAction Protection Goal Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
45EHFNDC_ACTSUB_TSubtypes - Dependent on Type6DESCRIPTION_LONGDescription (Long)nvarchar1320
46EHFNDC_ACTTMPL_TAction template Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
47EHFNDC_ACTTYPE_TAction Type Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
48EHFNDC_AMN_CAT_TAmount Categories5DESCRIPTION_LONGDescription (Long)nvarchar1320
49EHFNDC_CONTROL_TControls5DESCRIPTION_LONGDescription (Long)nvarchar1320
50EHFNDC_CTRLEFF_TControl Effectiveness Descriptions5DESCRIPTION_LONGDescription (Long)nvarchar1320
51EHFNDC_DTS_ST_TSampling Types5DESCRIPTION_LONGDescription (Long)nvarchar1320
52EHFNDC_EXPDR_TTime Units for Exposure5DESCRIPTION_LONGDescription (Long)nvarchar1320
53EHFNDC_EXP_TTime Intervals for Exposure5DESCRIPTION_LONGDescription (Long)nvarchar1320
54EHFNDC_REG_TRegulation Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
55EHFNDC_TEMPL_TTable Template for CODE-Phrase-Attributes Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
TOPHR Administrative Services
56T5ASRPROCTName for Processes5DESCRIPTION_LONGProcess Descriptionnvarchar2550
TOPIncident Recording
57EHHSSC_AFFLAND_TAffected Land Type Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
58EHHSSC_BDYPART_TBody Part Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
59EHHSSC_BDYSIDE_TBody Side Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
60EHHSSC_CLUPMTH_TCleanup Method Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
61EHHSSC_CSEODTH_TCause of Death Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
62EHHSSC_DAMTYPE_TDamage Type Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
63EHHSSC_EST_RSK_TEstimated Risk Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
64EHHSSC_FINCAT_TFinancial Tracking Categories (Trans)5DESCRIPTION_LONGDescription (Long)nvarchar1320
65EHHSSC_IMMACT_TImmediate Action Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
66EHHSSC_INCAUSE_TIncident Cause Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
67EHHSSC_INCCOBJ_TIncident-Causing Object Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
68EHHSSC_INCCOBM_TMovement of Incident-Causing Object Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
69EHHSSC_INCXTIN_TIncident External Influence Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
70EHHSSC_INC_ASP_TIncident Aspect Type Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
71EHHSSC_INC_DUC_TIncident Duration Classification Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
72EHHSSC_INC_FRE_TIncident Frequency Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
73EHHSSC_INC_GRP_TIncident Group Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
74EHHSSC_INC_LIK_TIncident Likelihood Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
75EHHSSC_INC_RIT_TIncident Risk Type Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
76EHHSSC_INC_SEV_TIncident Severity Code Description6DESCRIPTION_LONGDescription (Long)nvarchar1320
77EHHSSC_INJILTP_TInjury / Illness Type Code Description6DESCRIPTION_LONGDescription (Long)nvarchar1320
78EHHSSC_INJIL_TInjury / Illness Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
79EHHSSC_INVGUID_TInvestigation Guideline Description6DESCRIPTION_LONGDescription (Long)nvarchar1320
80EHHSSC_LOCAT_TLocation Classification Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
81EHHSSC_LOCODTH_TLocation of Death Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
82EHHSSC_MATDSPM_TDisposal Method Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
83EHHSSC_MATDSPR_TMaterial Recovery Method Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
84EHHSSC_MATDSPS_TDisposal Site Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
85EHHSSC_MATSTAT_TMaterial State Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
86EHHSSC_MATWAST_TMaterial Waste Type Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
87EHHSSC_NM_GRP_TNear Miss Group Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
88EHHSSC_OCC_TYP_TOccupational Incident Type Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
89EHHSSC_PERACTY_TActivity of Injured Person Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
90EHHSSC_PERMOVE_TMovement of Injured Person Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
91EHHSSC_PERPEQ_TPersonal Protective Equipment Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
92EHHSSC_PER_ROL_TPerson Role Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
93EHHSSC_RCNODE_TTexts for Causes and Root Causes5DESCRIPTION_LONGDescription (Long)nvarchar1320
94EHHSSC_REL_SIZ_TRelease Size Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
95EHHSSC_REL_TYP_TRelease Type Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
96EHHSSC_REPCRIT_TReporting Criteria (OSHA) Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
97EHHSSC_RES_TYP_TRestriction Type Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
98EHHSSC_SO_GRP_TSafety Observation Group Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
99EHHSSC_STEPCAT_TInvestigation Step Category Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
100EHHSSC_ST_CODE_TIncident Investigation - Step Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
101EHHSSC_TCSADEV_TTechnical Safety Device Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
102EHHSSC_TR2FAID_TTransport to First Aid Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
103EHHSSC_TRFURT_TFurther Transport Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
104EHHSSC_VIOCAT_TViolation Category Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
105EHHSSC_VIOSRCE_TViolation Notice Source Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
106EHHSSC_VIOTYPE_TViolation Type Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
107EHHSSC_WNDDREC_TWind Direction Code Description5DESCRIPTION_LONGDescription (Long)nvarchar1320
108EHHSSC_XSLT_TL_TFilters for Extraction to XML File5DESCRIPTION_LONGDescription (Long)nvarchar1320
TOPIntegration Objects
109EHFNDC_PERGRP_TPerson Group text5DESCRIPTION_LONGDescription (Long)nvarchar1320
TOPLocations Location Structure
110EHFNDC_LOC_EVL_TEvaluation Path for Position5DESCRIPTION_LONGDescription (Long)nvarchar1320
TOPRisk Assessment
111EHHSSC_ANMETH_TAnalysis Methods5DESCRIPTION_LONGDescription (Long)nvarchar1320
112EHHSSC_EAMRSKL_TRisk Levels5DESCRIPTION_LONGDescription (Long)nvarchar1320
113EHHSSC_EFFDET_TEffectiveness Determination Descriptions5DESCRIPTION_LONGDescription (Long)nvarchar1320
114EHHSSC_ER_CH_TExposure ratings for Chemicals5DESCRIPTION_LONGDescription (Long)nvarchar1320
115EHHSSC_GOALOBJ_TControl Objective Descriptions5DESCRIPTION_LONGDescription (Long)nvarchar1320
116EHHSSC_GOALTAR_TControl Target Descriptions5DESCRIPTION_LONGDescription (Long)nvarchar1320
117EHHSSC_HAZARD_THazards5DESCRIPTION_LONGDescription (Long)nvarchar1320
118EHHSSC_HAZCAT_THazard Categories5DESCRIPTION_LONGDescription (Long)nvarchar1320
119EHHSSC_IMPACT_TImpacts5DESCRIPTION_LONGDescription (Long)nvarchar1320
120EHHSSC_IMPTYP_TImpact Types5DESCRIPTION_LONGDescription (Long)nvarchar1320
121EHHSSC_JOB_TYP_TJob Type Customizing Table5DESCRIPTION_LONGDescription (Long)nvarchar1320
122EHHSSC_OPSTAT_TOperational Statuses5DESCRIPTION_LONGDescription (Long)nvarchar1320
123EHHSSC_RASROLE_TPerson Roles5DESCRIPTION_LONGDescription (Long)nvarchar1320
124EHHSSC_RASSTEP_TAssessment Step Descriptions5DESCRIPTION_LONGDescription (Long)nvarchar1320
125EHHSSC_RASTYP_TRisk Assessment Types5DESCRIPTION_LONGDescription (Long)nvarchar1320
126EHHSSC_REASON_TReasons for Risk Assessment5DESCRIPTION_LONGDescription (Long)nvarchar1320
127EHHSSC_RISKEVA_TRisk Evaluations5DESCRIPTION_LONGDescription (Long)nvarchar1320
128EHHSSC_RISKEXP_TExposure Frequency5DESCRIPTION_LONGDescription (Long)nvarchar1320
129EHHSSC_RISKLIK_TLikelihood5DESCRIPTION_LONGDescription (Long)nvarchar1320
130EHHSSC_RISKLVL_TRisk Levels5DESCRIPTION_LONGDescription (Long)nvarchar1320
131EHHSSC_RISKSEV_TSeverity6DESCRIPTION_LONGDescription (Long)nvarchar1320
132EHHSSC_VALTYPE_TValue Types5DESCRIPTION_LONGDescription (Long)nvarchar1320
TOPWD ABAP Page Builder
133CHIP_TEST_TAGSTest Tags CHIPs4DESCRIPTION_LONGLong Textnvarchar2550
TOPWorkflows and Tasks for Risk Assessment
134EHHSSC_RVWRES_TResult Code of Risk Assessment Review5DESCRIPTION_LONGDescription (Long)nvarchar1320