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 :: SAP Healthcare - Industry-Specific Components for Hospitals
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0NAPX_DRG301IS-H: Appendix DRG TableSAP Healthcare - Industry-Specific Components for Hospitals
SQL:  selectupdate insert create

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

SELECT MANDT, APXNR, DRG_SEQNO, DRG_CODE, MDC_CODE, DRG_CAT, SOI, ROM, DRG_COMMENT, DRG_REGROUP, DRG_CREAT_DATE, DRG_CREAT_TIME, GROUPING_USER, CREATION_DATE, CREATION_TIME, CREATION_USER, UPDATE_DATE, UPDATE_TIME, UPDATE_USER, CANCEL_DATE, CANCEL_TIME, CANCEL_USER, CANCEL_REASON, CANCEL_FLAG, MDC_CAT, COST_WEIGHT, TIMESTAMP, COSTW_TYPE, SPLG_CODE, SPLG_CAT FROM NAPX_DRG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2APXNRnvarchar100(N' ')Yes Allow NULL? 
3DRG_SEQNOSequence Number of a Case-Related DRGnvarchar30NUMC(N'000')NoISH_DRG_SEQ_NB Allow NULL? 
4DRG_CODEIS-H: DRG Codenvarchar100CHAR(N' ')Yes*ISH_DRG_CODE Allow NULL? 
5MDC_CODEIS-H: Code of Major Diagnostic Category (MDC)nvarchar300CHAR(N' ')YesISH_MDC_CODE Allow NULL? 
6DRG_CATIS-H: DRG Catalog Used for Codingnvarchar20CHAR(N' ')Yes*ISH_DRG_CAT Allow NULL? 
7SOIIS-H: Severity of Illness (for DRG Purposes)char10CHAR(N' ')Yes*ISH_DRG_SOI Allow NULL? 
8ROMIS-H: Risk of Mortality (for DRG Purposes)char10CHAR(N' ')Yes*ISH_DRG_ROM Allow NULL? 
9DRG_COMMENTIS-H: Comment on DRGnvarchar500CHAR(N' ')YesISH_DRG_COMMENT Allow NULL? 
10DRG_REGROUPIS-H: Regrouping Advisedchar10CHAR(N' ')YesISH_DRG_REGROUP_ADVISE Allow NULL? 
11DRG_CREAT_DATEDate when DRG Was Determinednvarchar80DATS(N'00000000')YesISH_DRG_DATE Allow NULL? 
12DRG_CREAT_TIMETime when DRG Was Determinednvarchar60TIMS(N'000000')YesISH_DRG_TIME Allow NULL? 
13GROUPING_USERIS-H: Information on Operation of DRG Systemnvarchar500CHAR(N' ')YesISH_GROUPING_USER Allow NULL? 
14CREATION_DATEIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
15CREATION_TIMEIS-H: Time when Data Record Creatednvarchar60TIMS(N'000000')YesISH_ERTIM Allow NULL? 
16CREATION_USERIS-H: Name of Employee who Created Recordnvarchar120CHAR(N' ')YesRI_ERNAM Allow NULL? 
17UPDATE_DATEIS-H: Date of Last Changenvarchar80DATS(N'00000000')YesRI_UPDAT Allow NULL? 
18UPDATE_TIMEIS-H: Time Data Record was Last Changednvarchar60TIMS(N'000000')YesISH_UPTIM Allow NULL? 
19UPDATE_USERIS-H: Name of Person who Last Changed Datanvarchar120CHAR(N' ')YesRI_UPNAM Allow NULL? 
20CANCEL_DATEIS-H: Cancellation Datenvarchar80DATS(N'00000000')YesSTORNO_DAT Allow NULL? 
21CANCEL_TIMEIS-H: Time Data Record Cancelednvarchar60TIMS(N'000000')YesISH_CANTIM Allow NULL? 
22CANCEL_USERIS-H: Name of User who Canceled Data Recordnvarchar120CHAR(N' ')YesSTORN_USER Allow NULL? 
23CANCEL_REASONIS-H: Reason for Cancellationnvarchar20CHAR(N' ')YesISH_CANREASON Allow NULL? 
24CANCEL_FLAGIS-H: Cancellation Indicatorchar10CHAR(N' ')YesRI_STORN Allow NULL? 
25MDC_CATIS-H: Catalog for Major Diagnostic Category (MDC)nvarchar20CHAR(N' ')YesISH_MDC_CAT Allow NULL? 
26COST_WEIGHTIS-H: Cost Weight for DRGsdecimal95DEC((0))YesISH_COST_WEIGHT
27TIMESTAMPTimestamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesISH_TIMESTAMP
28COSTW_TYPECategory for Calculating Effective Cost Weightnvarchar20NUMC(N'00')YesISH_COSTW_TYPE Allow NULL? 
29SPLG_CODECode of a Hospital Planning Service Group (HPSG)nvarchar300CHAR(N' ')YesISH_SPLG_CODE Allow NULL? 
30SPLG_CATCatalog of a Hospital Planning Service Groupnvarchar20CHAR(N' ')YesISH_SPLG_CAT Allow NULL? 
NamePrimaryUniqueTypeColumns
NAPX_DRG~0YesYesCLUSTEREDDRG_SEQNO, APXNR, MANDT