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_TIDAT
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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Environment, Health and Safety :: SAP EHS Management :: Incident Management :: Incident Recording
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EHHSSD_INC_TIDAT243Incident - Time DataIncident Recording
SQL:  selectupdate insert create

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

SELECT MANDT, DB_KEY, ROOT_KEY, PARENT_KEY, DATETIME_CR, USER_ID_CR, DATETIME_CH, USER_ID_CH, WO_CE_TIMESTAMP, WO_CE_TIME_ZONE, ACT_START_TIME, ACT_END_TIME, WC_DUR_MEAS, WC_DUR_UNIT, STANDARD_JOB_TS, ORG_DUR_MEAS, ORG_DUR_UNIT, TP_DUR_MEAS, DUR_TI_PO_UNIT, ORG_START_DATE, POS_START_DATE, WOC_START_DATE, DESC_KEY_REF, EEW_INC_TIDAT_D FROM EHHSSD_INC_TIDAT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DB_KEYNodeIDvarbinary160RAWNo/BOBF/CONF_KEY
3ROOT_KEYNodeIDvarbinary160RAWYes/BOBF/CONF_KEY
4PARENT_KEYNodeIDvarbinary160RAWYes/BOBF/CONF_KEY
5DATETIME_CRDate/Time of Item Creationdecimal150DEC((0))Yes/BOBF/DATETIME_CR
6USER_ID_CRObject Created Bynvarchar120CHAR(N' ')Yes/BOBF/USER_ID_CR Allow NULL? 
7DATETIME_CHDate/Time of Item Changedecimal150DEC((0))Yes/BOBF/DATETIME_CH
8USER_ID_CHObject Changed Bynvarchar120CHAR(N' ')Yes/BOBF/USER_ID_CH Allow NULL? 
9WO_CE_TIMESTAMPWorking ceased date(UTC)decimal150DEC((0))YesEHHSS_WO_CEASED_TIME_STAMP
10WO_CE_TIME_ZONETime Zone of Ceased Worknvarchar60CHAR(N' ')Yes*EHHSS_WO_CEASED_TIME_ZONE Allow NULL? 
11ACT_START_TIMEStart of Actual Working Timenvarchar60TIMS(N'000000')YesEHHSS_WO_ACTUAL_START_TIME Allow NULL? 
12ACT_END_TIMEEnd of Actual Working Timenvarchar60TIMS(N'000000')YesEHHSS_WO_ACTUAL_END_TIME Allow NULL? 
13WC_DUR_MEASDuration at Work Centerdecimal92QUAN((0))YesEHHSS_WO_CE_DUR_MEAS
14WC_DUR_UNITUnit of Duration at Work Centernvarchar30UNIT(N' ')Yes*EHHSS_WO_CE_DUR_UNIT_CODE Allow NULL? 
15STANDARD_JOB_TSPerformed Regular Jobchar10CHAR(N' ')YesEHHSS_STANDARD_JOB_TS Allow NULL? 
16ORG_DUR_MEASDuration at Organizationdecimal92QUAN((0))YesEHHSS_ORG_DUR_MEAS
17ORG_DUR_UNITUnit of Duration at Organizationnvarchar30UNIT(N' ')Yes*EHHSS_ORG_DUR_UNIT_CODE Allow NULL? 
18TP_DUR_MEASDuration in Positiondecimal92QUAN((0))YesEHHSS_TI_PO_DUR_MEAS
19DUR_TI_PO_UNITUnit of Duration in Positionnvarchar30UNIT(N' ')Yes*EHHSS_TI_PO_DUR_UNIT_CODE Allow NULL? 
20ORG_START_DATEStart Date of Work at Organizationnvarchar80DATS(N'00000000')YesEHHSS_TIDAT_ORG_START_DATE Allow NULL? 
21POS_START_DATEStart Date of Work at Current Positionnvarchar80DATS(N'00000000')YesEHHSS_TIDAT_POS_START_DATE Allow NULL? 
22WOC_START_DATEStart Date of Work at Current Work Centernvarchar80DATS(N'00000000')YesEHHSS_TIDAT_WOC_START_DATE Allow NULL? 
23DESC_KEY_REFNodeIDvarbinary160RAWYes/BOBF/CONF_KEY
24EEW_INC_TIDAT_DDummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
NamePrimaryUniqueTypeColumns
EHHSSD_INC_TIDATDSNoNoNONCLUSTEREDDESC_KEY_REF, MANDT
EHHSSD_INC_TIDATPANoNoNONCLUSTEREDPARENT_KEY, MANDT
EHHSSD_INC_TIDAT~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