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

Home | ERP 6.0  | EHHSSD_INC_BINFA
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
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
10OINM101Whse Journal
Environment, Health and Safety :: SAP EHS Management :: Incident Management :: Incident Recording
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EHHSSD_INC_BINFA468Incident - Basic Information AllIncident Recording
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DB_KEY, PARENT_KEY, DATETIME_CR, USER_ID_CR, DATETIME_CH, USER_ID_CH, TITLE, ORG_ID, PLANT_ID, LOC_ROOT_KEY_REF, LOC_TYPE, START_TIMESTAMP, START_TIME_ZONE, END_TIMESTAMP, END_TIME_ZONE, TIME_NOT_DET_IND, REP_TIMESTAMP, REP_TIME_ZONE, CONFIDENTIAL_TS, LOSS_OF_PROD_TS, EMERG_RESP_TS, LATIT_MEAS, LONG_MEAS, ALTIT_MEAS, ALTIT_UNIT, STREET_HOUSE_NUM, POSTAL_CODE, CITY, COUNTRY, REGION, SHIFT_GROUP, SHIFT_PLAN_ID, REP_ANONYM_IND, DIS_WA_MEAS, DIS_WA_UNIT, PRECIP_MEAS, PRECIP_UNIT, WI_DIREC, WI_FO_MEAS, WI_FO_UNIT, TXC_WEA_COMM_KEY, TXC_DESC_KEY, TXC_LOC_DESC_KEY, TXC_IMA_DESC_KEY, EEW_INC_BINFA_D FROM EHHSSD_INC_BINFA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DB_KEYNodeIDvarbinary160RAWNo/BOBF/CONF_KEY
3PARENT_KEYNodeIDvarbinary160RAWYes/BOBF/CONF_KEY
4DATETIME_CRDate/Time of Item Creationdecimal150DEC((0))Yes/BOBF/DATETIME_CR
5USER_ID_CRObject Created Bynvarchar120CHAR(N' ')Yes/BOBF/USER_ID_CR Allow NULL? 
6DATETIME_CHDate/Time of Item Changedecimal150DEC((0))Yes/BOBF/DATETIME_CH
7USER_ID_CHObject Changed Bynvarchar120CHAR(N' ')Yes/BOBF/USER_ID_CH Allow NULL? 
8TITLEIncident Titlenvarchar800CHAR(N' ')YesEHHSS_INC_TITLE Allow NULL? 
9ORG_IDOrganizational Unit IDnvarchar80NUMC(N'00000000')Yes*EHHSS_ORG_UNIT_ID Allow NULL? 
10PLANT_IDPlant IDnvarchar40CHAR(N' ')Yes*EHFND_PLANT_ID Allow NULL? 
11LOC_ROOT_KEY_REFLocationvarbinary160RAWYesEHFND_LOCATION_KEY_REF
12LOC_TYPELocation Classificationnvarchar210CHAR(N' ')Yes*EHHSS_LOCATION_TYPE_CODE Allow NULL? 
13START_TIMESTAMPStart date (UTC)decimal150DEC((0))YesEHFND_START_TIME_STAMP
14START_TIME_ZONETime Zone of Incident Startnvarchar60CHAR(N' ')Yes*EHHSS_INC_START_TIME_ZONE Allow NULL? 
15END_TIMESTAMPEnd date(UTC)decimal150DEC((0))YesEHFND_END_TIME_STAMP
16END_TIME_ZONETime Zone for Incident Endnvarchar60CHAR(N' ')Yes*EHHSS_INC_END_TIME_ZONE Allow NULL? 
17TIME_NOT_DET_INDTime Unknown for Incident Startchar10CHAR(N' ')YesEHHSS_INC_TIME_NOT_DET_IND Allow NULL? 
18REP_TIMESTAMPDate of Incident reporting(UTC)decimal150DEC((0))YesEHHSS_INC_REP_TIME_STAMP
19REP_TIME_ZONETime Zone for Initial Incident Reportnvarchar60CHAR(N' ')Yes*EHHSS_INC_REPORTED_TIME_ZONE Allow NULL? 
20CONFIDENTIAL_TSRestricted Access to Incident Recordchar10CHAR(N' ')YesEHHSS_INC_CONFID_TS Allow NULL? 
21LOSS_OF_PROD_TSLoss of Productionchar10CHAR(N' ')YesEHHSS_LOSS_OF_PRODUCTION_TS Allow NULL? 
22EMERG_RESP_TSEmergency Responder Calledchar10CHAR(N' ')YesEHHSS_EMERGENCY_RESPONDER_TS Allow NULL? 
23LATIT_MEASGeographic Latitudedecimal1512DEC((0))YesEHHSS_GEO_LATITUDE_MEAS
24LONG_MEASGeographic Longitudedecimal1512DEC((0))YesEHHSS_GEO_LONGITUDE_MEAS
25ALTIT_MEASGeographic Altitudedecimal72QUAN((0))YesEHHSS_GEO_ALTIT_MEAS
26ALTIT_UNITUnit of Geographic Altitudenvarchar30UNIT(N' ')Yes*EHHSS_GEO_ALTIT_UNIT_CODE Allow NULL? 
27STREET_HOUSE_NUMStreet / House Number of Incidentnvarchar600CHAR(N' ')YesEHHSS_INC_STREET_HOUSE_NUM Allow NULL? 
28POSTAL_CODEPostal Code of Incidentnvarchar100CHAR(N' ')YesEHHSS_INC_POSTAL_CODE Allow NULL? 
29CITYCity of Incidentnvarchar400CHAR(N' ')YesEHHSS_INC_CITY Allow NULL? 
30COUNTRYCountry of Incidentnvarchar30CHAR(N' ')Yes*EHHSS_INC_COUNTRY_CODE Allow NULL? 
31REGIONRegion of Incidentnvarchar30CHAR(N' ')Yes*EHHSS_INC_REGION_CODE Allow NULL? 
32SHIFT_GROUPShift Group for Organizational Unitsnvarchar100CHAR(N' ')Yes*EHFND_SHIFT_GROUP_ORGUNIT Allow NULL? 
33SHIFT_PLAN_IDShift Abbreviation for Shift Planningnvarchar40CHAR(N' ')Yes*EHFND_SHIFT_PLAN_ABBR Allow NULL? 
34REP_ANONYM_INDReport Incident Anonymouslychar10CHAR(N' ')YesEHHSS_INC_REPORTED_ANONYM_IND Allow NULL? 
35DIS_WA_MEASDistance to Waterdecimal152QUAN((0))YesEHHSS_DIS_WATER_MEAS
36DIS_WA_UNITUnit of Distance to Waternvarchar30UNIT(N' ')Yes*EHHSS_DIS_WATER_UNIT_CODE Allow NULL? 
37PRECIP_MEASAmount of Precipitationdecimal152QUAN((0))YesEHHSS_PRECIPIT_MEAS
38PRECIP_UNITPrecipitation Unitnvarchar30UNIT(N' ')Yes*EHHSS_PRECIPIT_UNIT_CODE Allow NULL? 
39WI_DIRECWind Directionnvarchar210CHAR(N' ')Yes*EHHSS_WIND_DIRECTION_CODE Allow NULL? 
40WI_FO_MEASWind Speeddecimal152QUAN((0))YesEHHSS_WIND_FOR_MEAS
41WI_FO_UNITWind Speed Unitnvarchar30UNIT(N' ')Yes*EHHSS_WIND_FOR_UNIT_CODE Allow NULL? 
42TXC_WEA_COMM_KEYNodeIDvarbinary160RAWYes/BOBF/CONF_KEY
43TXC_DESC_KEYNodeIDvarbinary160RAWYes/BOBF/CONF_KEY
44TXC_LOC_DESC_KEYNodeIDvarbinary160RAWYes/BOBF/CONF_KEY
45TXC_IMA_DESC_KEYNodeIDvarbinary160RAWYes/BOBF/CONF_KEY
46EEW_INC_BINFA_DDummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
NamePrimaryUniqueTypeColumns
EHHSSD_INC_BINFAADNoNoNONCLUSTEREDTXC_DESC_KEY, MANDT
EHHSSD_INC_BINFAAINoNoNONCLUSTEREDTXC_IMA_DESC_KEY, MANDT
EHHSSD_INC_BINFAALNoNoNONCLUSTEREDTXC_LOC_DESC_KEY, MANDT
EHHSSD_INC_BINFALONoNoNONCLUSTEREDLOC_ROOT_KEY_REF, MANDT
EHHSSD_INC_BINFAPANoNoNONCLUSTEREDPARENT_KEY, MANDT
EHHSSD_INC_BINFATSNoNoNONCLUSTEREDSTART_TIMESTAMP, PLANT_ID, MANDT
EHHSSD_INC_BINFAWENoNoNONCLUSTEREDTXC_WEA_COMM_KEY, MANDT
EHHSSD_INC_BINFA~0YesYesCLUSTEREDDB_KEY, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy