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.0N1DCS_ALLG561IS-H*med: DCS: Quick Entry: General SettingsClinical System
SQL:  selectupdate insert create

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

SELECT MANDT, EINRI, SPC_FIELD_OE, CATS_ISH_RESET, RELEASE_PVW, SCORING, SCORE_CUSTOMER1, SVC_DCS_ISH, SVC_EX_CHECK, MEL_MED_SVC, STD_SVC_COLLECT, STD_DIA_SUMMARY, STD_DIA_SUMMULT, TREAT_DURATION, CLASS_GET, CLASS_DIA_GET, CLASS_AO_CODE, CLASS_KIKA_CODE, CLASS_QUADR_CODE, CLASS_USER_CODE, CLASS_ICD10AMB_C, KAL_GET, DIA_DETAIL_GET, SVC_PERFORM, STD_DIA_USR_EXIT, REFRESH_BUTTON, DIA_STU_SPC_HAND, PATIENT_HISTORY, DOCU_LIST_CASE, DOCU_LIST_PAT, SVC_DCS_START, SVC_TYPE_CHECK, SVC_F4_HITLIST, SVC_FROM_HL_SAVE, SVC_ERBOE_INPUT, SVC_SRC_IDENTNR, SVC_SRC_ICPM, ONLY_MEL_BUTTON, STD_SVC_USR_EXIT, RELEASE_463B, SVC_MIN_ER_OFF, SVC_PFL_NOT_SHOW, SVC_LAB_NOT_SHOW, SVC_ERBOE_CHECK, SVC_SRC_MEL, SVC_STORN_ALL, SVC_SHOW_TAGRU, SVC_ERBOE_FILTER, SVC_FILTER_CHBOX, SVC_POP_ERBOE_IP, DAUER_DIA_THE, NO_TNM_GET, SVC_HITLIST_MED, SVC_OU_OEE_USR05, SVC_OU_OWRT_VIST, DIACOS_NO_FTEXT FROM N1DCS_ALLG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EINRIInstitutionnvarchar40CHAR(N' ')No*EINRI Allow NULL? 
3SPC_FIELD_OEDCS:Flg: Department (Special Field) DIACOS from OUchar10CHAR(N' ')YesN1DCSSPC_FIELD_OE Allow NULL? 
4CATS_ISH_RESETDCS: Reset Diagnosis Catalog to ISH Catalogchar10CHAR(N' ')YesN1DCSCATS_ISH_RESET Allow NULL? 
5RELEASE_PVWDCS: Display Button for PVW Releasechar10CHAR(N' ')YesN1DCSRELEASE_PVW Allow NULL? 
6SCORINGDCS: Display Button for Scoringchar10CHAR(N' ')YesN1DCSBUTTON_SCORING Allow NULL? 
7SCORE_CUSTOMER1DCS: Scoring if Active - Customer-Specific Vers.1char10CHAR(N' ')YesN1DCSSCORE_CUST1_SPECIFIC Allow NULL? 
8SVC_DCS_ISHDCS: Services Entered in DIACOS: ISH Serviceschar10CHAR(N' ')YesN1DCSSVC_FROM_DIACOS_ISH Allow NULL? 
9SVC_EX_CHECKDCS: Extended Check for Services (Range)char10CHAR(N' ')YesN1DCSSVC_EXTENDED_CHECK Allow NULL? 
10MEL_MED_SVCDCS: Save MISs as ISHMED Serviceschar10CHAR(N' ')YesN1DCSMEL_AS_MED_SERVICE Allow NULL? 
11STD_SVC_COLLECTDCS: Standard Service Entry - Display Buttonchar10CHAR(N' ')YesN1DCSBUTTON_STD_SVC_COLLECT Allow NULL? 
12STD_DIA_SUMMARYDCS: Display Standard Diagnosis Overview Buttonchar10CHAR(N' ')YesN1DCSBUTTON_STD_DIA_SUMMARY Allow NULL? 
13STD_DIA_SUMMULTDCS: Std Diag. Entry: Deactivate Multiple Transferchar10CHAR(N' ')YesN1DCSBUTTON_STD_SUMMULT Allow NULL? 
14TREAT_DURATIONDCS: Display Treatment Duration Fieldchar10CHAR(N' ')YesN1DCSTREATMENT_DURATION Allow NULL? 
15CLASS_GETDCS: Get and Save Classifications from DIACOSchar10CHAR(N' ')YesN1DCSCLASSIFICATIONS_GET Allow NULL? 
16CLASS_DIA_GETDCS: Also Determine Classifications for Diagnoseschar10CHAR(N' ')YesN1DCSCLASS_DIAGN_ALWAYS_GET Allow NULL? 
17CLASS_AO_CODEDCS: Also Determine AO Classificationchar10CHAR(N' ')YesN1DCSCLASS_AO_CODE_ADD_GET Allow NULL? 
18CLASS_KIKA_CODEDCS: Determine and Save KIKA Classificationchar10CHAR(N' ')YesN1DCSCLASS_KIKA_CODE_ADD_GET Allow NULL? 
19CLASS_QUADR_CODEDCS: Determine and Save Quadra Classificationchar10CHAR(N' ')YesN1DCSCLASS_QUADR_CODE_ADD_GET Allow NULL? 
20CLASS_USER_CODEDCS: Determine and Save USER Classificationchar10CHAR(N' ')YesN1DCSCLASS_USER_CODE_ADD_GET Allow NULL? 
21CLASS_ICD10AMB_CDCS: Determine and Save ICD10AMB Classificationschar10CHAR(N' ')YesN1DCSCLASS_ICD10A_CODE_ADD_GET Allow NULL? 
22KAL_GETDCS: Determine KAL Services for ICPMs 'X' = Yeschar10CHAR(N' ')YesN1DCSCLASS_KAL_CODE_ADD_GET Allow NULL? 
23DIA_DETAIL_GETDCS: Display Detail Button for Diagnoseschar10CHAR(N' ')YesN1DCSDIA_DETAIL_GET Allow NULL? 
24SVC_PERFORMDCS: Perform Services - Display Buttonchar10CHAR(N' ')YesN1DCSBUTTON_SERVICES_PERFORM Allow NULL? 
25STD_DIA_USR_EXITDCS: Run Standard Diagnoses User Exitchar10CHAR(N' ')YesN1DCSSTD_USR_EXIT Allow NULL? 
26REFRESH_BUTTONDiaCoS: Show Refresh Buttonchar10CHAR(N' ')YesN1DCSSHOW_REFRESH_BUTTON Allow NULL? 
27DIA_STU_SPC_HANDDCS: STU Diagnoses Special Handlingchar10CHAR(N' ')YesN1DCSDIA_STU_SPC_HANDLE Allow NULL? 
28PATIENT_HISTORYDCS: Display Patient History Button Y/Nchar10CHAR(N' ')YesN1DCSBUTTON_PAT_HISTORY_SHOW Allow NULL? 
29DOCU_LIST_CASEDCS: Display Document List for Case Button Y/Nchar10CHAR(N' ')YesN1DCSBUTTON_DOC_LIST_CASE Allow NULL? 
30DOCU_LIST_PATDCS: Display Patient Document List Buttonchar10CHAR(N' ')YesN1DCSBUTTON_DOC_LIST_PATIENT Allow NULL? 
31SVC_DCS_STARTDCS: Start DIACOS for Service on Releasenvarchar100CHAR(N' ')Yes*N1DCSSERVICE_DCS_START Allow NULL? 
32SVC_TYPE_CHECKDCS: Service Category Checks for MIS,ICPM Recognitionchar10CHAR(N' ')YesN1DCSSERVICE_TYPE_CHECK Allow NULL? 
33SVC_F4_HITLISTDCS: Use Service Hit List as F4 Help (Multiple)char10CHAR(N' ')YesN1DCSSERVICE_F4_HITLIST Allow NULL? 
34SVC_FROM_HL_SAVEDCS: Transfer Services from Hit List Immediatelychar10CHAR(N' ')YesN1DCSSERVICE_FROM_HL_SAVE Allow NULL? 
35SVC_ERBOE_INPUTDCS: Performing OU Ready for Input + Check for Serviceschar10CHAR(N' ')YesN1DCSSERVICE_ERBOE_INPUT Allow NULL? 
36SVC_SRC_IDENTNRDCS: Search According to ID Number Possible for Svceschar10CHAR(N' ')YesN1DCSSERVICE_SEARCH_IDENTNR Allow NULL? 
37SVC_SRC_ICPMDCS: Search by ICPM Possible for Serviceschar10CHAR(N' ')YesN1DCSSERCICE_SEARCH_ICPM Allow NULL? 
38ONLY_MEL_BUTTONDCS: Toggle Between MIS and All Services - Display Buttonchar10CHAR(N' ')YesN1DCSBUTTON_ONLY_MEL_SHOW Allow NULL? 
39STD_SVC_USR_EXITDCS: Run Standard Service User Exitchar10CHAR(N' ')YesN1DCSSTD_SVC_USER_EXIT Allow NULL? 
40RELEASE_463BDCS: Special Handling for Release 4.63Bchar10CHAR(N' ')YesN1DCSHANDLING_RELEASE_463B Allow NULL? 
41SVC_MIN_ER_OFFDCS: 'X' Status Irrelevant, ' ' Svce at Least Perfchar10CHAR(N' ')YesN1DCSSERVICE_STATE_MIN_ER_OFF Allow NULL? 
42SVC_PFL_NOT_SHOWDCS: Do Not Display Nursing Serviceschar10CHAR(N' ')YesN1DCSSERVICE_PFL_NOT_SHOW Allow NULL? 
43SVC_LAB_NOT_SHOWDCS: Do Not Display Laboratory Servicesnvarchar100CHAR(N' ')Yes*N1DCSSERVICE_LAB_NOT_SHOW Allow NULL? 
44SVC_ERBOE_CHECKDCS: Check ERBOE Using Table ZNWAT_NERBOEchar10CHAR(N' ')YesN1DCSSERVICE_ERBOE_CHECK Allow NULL? 
45SVC_SRC_MELDCS: MEL Search Possible for Serviceschar10CHAR(N' ')YesN1DCSSERVICE_SEARCH_MEL Allow NULL? 
46SVC_STORN_ALLDCS: Also Cancel Superordinate Serviceschar10CHAR(N' ')YesN1DCSSERVICE_STORN_ALL Allow NULL? 
47SVC_SHOW_TAGRUDisplay Svce Category (Svce Group)char10CHAR(N' ')YesN1DCSSERVICE_SHOW_SERVICETYPE Allow NULL? 
48SVC_ERBOE_FILTERDCS: Save Filter Settings for Performing OUchar10CHAR(N' ')YesN1DCSSERVICE_ERBOE_FILTER Allow NULL? 
49SVC_FILTER_CHBOXDCS: Filter Settings Checkbox Instead of Radio Buttonchar10CHAR(N' ')YesN1DCSSERVICE_FILTER_CHBOX Allow NULL? 
50SVC_POP_ERBOE_IPDCS: ERBOE Ready for Input in Svce Presett. Dialog Boxchar10CHAR(N' ')YesN1DCSSERVICE_POPUP_ERBOE_INPUT Allow NULL? 
51DAUER_DIA_THEDCS: Manage Continuous Diagnoses/Therapieschar10CHAR(N' ')YesN1DIS_DAUER_DIA_THE Allow NULL? 
52NO_TNM_GETDCS: Do not Determine TNM Classification (NDIA)char10CHAR(N' ')YesN1DCSNO_TUMOUR_DATAS_GET Allow NULL? 
53SVC_HITLIST_MEDDCS: Service Hit List: Display Med. Services Onlychar10CHAR(N' ')YesN1DCS_SERVICE_HITLIST_MED Allow NULL? 
54SVC_OU_OEE_USR05DCS: Read OU for Services OEE Parameter from Usr05char10CHAR(N' ')YesN1DCS_SVC_OU_OEE_FROM_USR05 Allow NULL? 
55SVC_OU_OWRT_VISTDCS: Overwrite Dept. OU for Visitchar10CHAR(N' ')YesN1DCS_SVC_OU_OWRT_VIST Allow NULL? 
56DIACOS_NO_FTEXTDo not overwrite diagnosis free text with Diacos?char10CHAR(N' ')YesN1DCSDIA_DIACOS_NO_FTEXT Allow NULL? 
NamePrimaryUniqueTypeColumns
N1DCS_ALLG~0YesYesCLUSTEREDEINRI, MANDT