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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Clinical System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0N2CLIM_VALVS484Vital Signs: Measured ValuesClinical System
SQL:  selectupdate insert create

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

SELECT MANDT, VALID, VALID_VERS, OBSID, OBSID_VERS, MTYPE, STATUS, BCHID, BCPID, VALTIMESTAMP, VALTIMESTAMP_TO, DESCR, LGTXT, VALUE, UNIT, VALUE_STRING, VALUE_ZERO, VALQUAL, ABNORM, ORIGIN, CODE_ORIG, CODETEXT_ORIG, UNIT_ORIG, VALUE_ORIG, NORMAL_ORIG, ABNORM_ORIG, PLDTIMESTAMP, PLDID, ERDAT, ERTIM, ERUSR, UPDAT, UPTIM, UPUSR, STORN, STOID, STDAT, STTIM, STUSR, REASON_NMEA, NORMAL_LOW, NORMAL_HIGH, WARNING_LOW, WARNING_HIGH, ALARM_LOW, ALARM_HIGH, DISPLAY_LOW, DISPLAY_HIGH FROM N2CLIM_VALVS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VALIDInternal Key of Measured Value (GUID)nvarchar320CHAR(N' ')NoN2CLIM_VALID Allow NULL? 
3VALID_VERSVersion Number of Measured Valuenvarchar40NUMC(N'0000')NoN2CLIM_VALID_VERS Allow NULL? 
4OBSIDInternal Key of Examination (GUID)nvarchar320CHAR(N' ')Yes*N2CLIM_OBSID Allow NULL? 
5OBSID_VERSVersion Number of Examinationnvarchar40NUMC(N'0000')YesN2CLIM_OBSID_VERS Allow NULL? 
6MTYPEMeasurement Type of Clin. Msrmntchar10CHAR(N' ')YesN2CLIM_MTYPE Allow NULL? 
7STATUSStatus (Internal ID)nvarchar20CHAR(N' ')YesN2CLIM_STATUS Allow NULL? 
8BCHIDBasic Catalog: Catalog Keynvarchar330CHAR(N' ')YesN1BCHN1BCHID Allow NULL? 
9BCPIDBasic Cat.: Item Keynvarchar330CHAR(N' ')YesN1BCPN1BCPID Allow NULL? 
10VALTIMESTAMPTime Stamp for Measured Value (YYYYMMDDhhmmss)decimal150DEC((0))YesN2CLIM_VALTIMESTAMP
11VALTIMESTAMP_TOTo Time Stamp for Measured Value (YYYYMMDDhhmmss)decimal150DEC((0))YesN2CLIM_VALTIMESTAMP_TO
12DESCRShort Descriptionnvarchar800CHAR(N' ')YesN2CLIM_DESCR Allow NULL? 
13LGTXTIndicator Whether Comment Existschar10CHAR(N' ')YesN2CLIM_LONGTEXT Allow NULL? 
14VALUEMeasured Valuedecimal315QUAN((0))YesN2CLIM_VALUE
15UNITUnitnvarchar30UNIT(N' ')YesN2CLIM_UNIT Allow NULL? 
16VALUE_STRINGMeasured Value as Text Stringntext10737418230YesN2CLIM_VALSTRING
17VALUE_ZEROCheckbox: Zero Valuechar10CHAR(N' ')YesN2CLIM_VALUE_ZERO Allow NULL? 
18VALQUALMeasured Value Qualitychar10CHAR(N' ')YesN2CLIM_VALQUAL Allow NULL? 
19ABNORMAbnormality Indicatornvarchar2550(N'')YesN2CLIM_ABNORM Allow NULL? 
20ORIGINSource System, External Catalognvarchar400CHAR(N' ')YesN2CLIM_ORIGIN Allow NULL? 
21CODE_ORIGCode from Source Systemnvarchar400CHAR(N' ')YesN2CLIM_ORIGCODE Allow NULL? 
22CODETEXT_ORIGDescription of Code (Source)nvarchar2550(N'')YesN2CLIM_ORIGCODE_TEXT Allow NULL? 
23UNIT_ORIGUnit of Source (as Text)nvarchar2550(N'')YesN2CLIM_UNIT_ORIG Allow NULL? 
24VALUE_ORIGMeasurement of Source (as Text)ntext10737418230YesN2CLIM_VALUE_ORIG
25NORMAL_ORIGNormal Range (Normal Value) of Measurement (Source)nvarchar2550(N'')YesN2CLIM_NORMAL_ORIG Allow NULL? 
26ABNORM_ORIGAbnormality Indicator (Source)nvarchar2550(N'')YesN2CLIM_ABNORM_ORIG Allow NULL? 
27PLDTIMESTAMPGenerated Planned Time (YYYYMMDDhhmmss)decimal150DEC((0))YesN2CLIM_PLTIMESTAMP
28PLDIDKey of Definite Planned Measurement (GUID)nvarchar320CHAR(N' ')YesN2CLIM_PLDID Allow NULL? 
29ERDATIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
30ERTIMIS-H: Time Record Creatednvarchar60TIMS(N'000000')YesRI_ERTIM Allow NULL? 
31ERUSRIS-H: Name of Employee who Created Recordnvarchar120CHAR(N' ')YesRI_ERNAM Allow NULL? 
32UPDATIS-H: Date of Last Changenvarchar80DATS(N'00000000')YesRI_UPDAT Allow NULL? 
33UPTIMIS-H: Time of Last Changenvarchar60TIMS(N'000000')YesRI_UPTIM Allow NULL? 
34UPUSRIS-H: Name of Person who Last Changed Datanvarchar120CHAR(N' ')YesRI_UPNAM Allow NULL? 
35STORNIS-H: Cancellation Indicatorchar10CHAR(N' ')YesRI_STORN Allow NULL? 
36STOIDReason for Canceling Medical Objectnvarchar30CHAR(N' ')Yes*N1STOID Allow NULL? 
37STDATDate of Cancellationnvarchar80DATS(N'00000000')YesSTORN_DAT Allow NULL? 
38STTIMIS-H: Cancellation Timenvarchar60TIMS(N'000000')YesSTORN_TIM Allow NULL? 
39STUSRIS-H: Name of User who Canceled Data Recordnvarchar120CHAR(N' ')YesSTORN_USER Allow NULL? 
40REASON_NMEAReason for "Not Measured"nvarchar30CHAR(N' ')Yes*N1NGOID Allow NULL? 
41NORMAL_LOWNormal Range Lower Valuedecimal313QUAN((0))YesN2CLIM_NORMAL_LOW
42NORMAL_HIGHNormal Range Upper Valuedecimal313QUAN((0))YesN2CLIM_NORMAL_HIGH
43WARNING_LOWWarning Range Lower Valuedecimal313QUAN((0))YesN2CLIM_WARNING_LOW
44WARNING_HIGHWarning Range Upper Valuedecimal313QUAN((0))YesN2CLIM_WARNING_HIGH
45ALARM_LOWExtreme/Alarm Range Lower Valuedecimal313QUAN((0))YesN2CLIM_ALARM_LOW
46ALARM_HIGHExtreme/Alarm Range Upper Valuedecimal313QUAN((0))YesN2CLIM_ALARM_HIGH
47DISPLAY_LOWDisplay Range Lower Valuedecimal313QUAN((0))YesN2CLIM_DISPLAY_LOW
48DISPLAY_HIGHDisplay Range Upper Valuedecimal313QUAN((0))YesN2CLIM_DISPLAY_HIGH
NamePrimaryUniqueTypeColumns
N2CLIM_VALVS~0YesYesCLUSTEREDVALID_VERS, VALID, MANDT
N2CLIM_VALVS~001NoNoNONCLUSTEREDOBSID_VERS, OBSID, MANDT
N2CLIM_VALVS~002NoNoNONCLUSTEREDSTORN, BCPID, BCHID, MANDT
N2CLIM_VALVS~003NoNoNONCLUSTEREDBCPID, OBSID, MANDT