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

57 columns | Print definition?ERP 6.0  | ORGPF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1N1CORDFCORD: Order Filler4ORGPFCORD: Nursing Organizational Unit (OU) Order Fillernvarchar80
2N1CORDFAVPCORD: Favorites - Item7ORGPFIdentification Key of Organizational Unitnvarchar80
3N1CORDFTCORD: Order Fller Texts5ORGPFCORD: Nursing Organizational Unit (OU) Order Fillernvarchar80
4TN2CHART_LOUT_OUChart: Customizing Standard Layout per Departmental OU3ORGPFOrganizational Unit Assigned to Casenvarchar80
5TNC301LIS-H: Standortbezogene Übermittlungsmerkmale (§301)5ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
6TNWAT_FREQULeistungsgenerierung für ambulante Besuche7ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
TOPBasic Data
7NOEKIS-H: Assign Org. Unit to Cost Center3ORGPFRequesting Nursing Organizational Unitnvarchar80
8TN10BIS-H: Statistical Bed Count of Organizational Units3ORGPFOrganizational Unit with Nursing Assignment Authoritynvarchar80
9TNCD1IS-HCM Dispatch Control for Direct Communication6ORGPFIS-HCM: Nursing Organizational Unit Affected by Eventnvarchar80
TOPClinical System
10N1MEORDERIS-H*MED: Medication, Medication Order10ORGPFMedication: Order - Ordering Organizational Unitnvarchar80
11N1PRBEWIS-H*MED: PATREG: Bewegungen13ORGPFIS-H: Olguya tayin edilen organizasyon biriminvarchar80
12N1SRVServices: Service Data12ORGPFServices: Treatment Organizational Unitnvarchar80
13N2CLIM_OBSVSVital Signs: Examination16ORGPFOrganizational Unit Assigned to Casenvarchar80
14N2DWSWL_TASKDProvisional Task34ORGPFOrganizational Unit Assigned to Casenvarchar80
15N2DWSWL_USINGOUPreset Situation Template for Organizational Units7ORGPFNursing Organizational Unitnvarchar80
16N2DWSWL_USINGOU1Preset Situation Template for Organizational Units7ORGPFNursing Organizational Unitnvarchar80
17N2GL_BASE_DOCIS-H*MED: Base Item Document7ORGPFOrganizational Unit Assigned to Casenvarchar80
18N2INPA_SUGGESTProposal Criteria Ward DWS Assignment6ORGPFOrganizational Unit Assigned to Casenvarchar80
19N2INPA_SUGGEST1Proposal Criteria Ward DWS Assignment (Processing)6ORGPFOrganizational Unit Assigned to Casenvarchar80
20NDOCAIS-H*MED: Document Management Data for Archived Documents13ORGPFOrganizational Unit Assigned to Casenvarchar80
21NDOCSTORNOIS-H*MED: Canceled Documents14ORGPFOrganizational Unit Assigned to Casenvarchar80
22TN1MECCTSi.s.h.med: Medication Time Spans4ORGPFMedication: Order - Ordering Organizational Unitnvarchar80
23TN2CLIM_COMP_OUCLIM: Measurement - Entry Element Assignment for OU4ORGPFNursing Organizational Unitnvarchar80
24TN2CLIM_OUVSVital Signs: Customizing per OU4ORGPFNursing Organizational Unitnvarchar80
25TN2CLIM_SPECIFYCLIM: Specify Measurement4ORGPFNursing Organizational Unitnvarchar80
26TN2CLIM_SPEC_POSCLIM: Specialize Items for Measurement4ORGPFNursing Organizational Unitnvarchar80
TOPNursing
27N1NRSPENursing Plan: Entry16ORGPFNursing Plan: Nursing Org. Unit of an Entrynvarchar80
28N1NRSPHNursing Plan: Header Data7ORGPFNursing Plan: Nursing Organizational Unitnvarchar80
TOPPatient Accounting
29NICPIS-H: Surgical Procedure Codes Performed30ORGPFIS-H: Date when Surgical Procedure Code Was Completednvarchar80
30NICP2IS-H: INACTIVE since 4.71 - DO NOT USE !30ORGPFIS-H: Date when Surgical Procedure Code Was Completednvarchar80
31TN19DProposal of Treatment Certificates7ORGPFOrganizational Unit Assigned to Casenvarchar80
32TNIEBILLIS-H: Internet-Enabled Estimated Invoice - Not Supported Now20ORGPFOrganizational Unit Assigned to Casenvarchar80
TOPPatient Management
33NAPPIS-H: Provisional Appointments for Visit Scheduling12ORGPFOrganizational Unit Assigned to Casenvarchar80
34NBEWIS-H: Movements for Case32ORGPFOrganizational Unit Assigned to Casenvarchar80
35NDOCIS-H: Assignment of IS-H Objects to Documents in DMS13ORGPFOrganizational Unit Assigned to Casenvarchar80
36NLOCIS-H: Time Slot Substitutions for Visit Scheduling2ORGPFOrganizational Unit Assigned to Casenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
37/ISHFR/TNWFR_F10IS-H FR: Per Diem Fee9ORGPFOrganizational Unit Assigned to Casenvarchar80
38N1FAPFTable for dept'l nursing OUS4ORGPFOU with Nursing Responsibility for Casenvarchar80
39N2DWSWL_PATTTask Template27ORGPFOrganizational Unit Assigned to Casenvarchar80
40N2DWSWL_PATT1Task Template / Changes27ORGPFOrganizational Unit Assigned to Casenvarchar80
41N2DWSWL_TASKTask34ORGPFOrganizational Unit Assigned to Casenvarchar80
42N2PRZ_HIT_HEADIS-H*MED: Names of Individual SPC Hit Lists6ORGPFIdentification Key of Organizational Unitnvarchar80
43NEACIS-H: Estimated Amount for Accommod. in Local Currency5ORGPFOrganizational Unit Assigned to Casenvarchar80
44NLWARTE_003NL - Warteliste extra felder fur10ORGPFISH_NL: Org. eenheid die aan aan een ZGV wordt toegewezennvarchar10
45NWATFAPFIS-H AT: Tabelle für fachlich pflegerische OEs4ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
46TNABETTENIS-H AT: Bettenanzahl pro Station3ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
47TNAFDIS-H: Outpatient Admission Fee Determination6ORGPFOrganizational Unit Assigned to Casenvarchar80
48TNAKRF1IS-H: KRARAF Data Carrier, Function Codes/Dept2ORGPFOrganizational Unit Assigned to Casenvarchar80
49TNSEL_INTERDEPTChoice of System Behavior for Interdep. Bed Assignment3ORGPFIdentification Key of Organizational Unitnvarchar80
50TNWATBETTENIS-H AT: Bettenanzahl pro Abteilung und Station4ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
51TNWATKBGENIS-H AT: Leistungsgenerierung13ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
52TNWAT_BETRIS-H AT: Ermittlung Betreuungsschein6ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
53TNWAT_DEKADE_HIS-H AT: Customizingtabelle für Dekaden (Kopfdaten)4ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
54TNWAT_DEKADE_PIS-H AT: Customizingtabelle für Dekaden (Positionsdaten)4ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
55TNWAT_EURSIS-H AT: Ermittlung Ursache der Behandlung6ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
56TNWAT_OE_ABBEXCIS-H AT: Ambulanzbehandlungsarten für Ambulanzgebühren3ORGPFIS-H: OrgEinheit, die einem Fall zugewiesen wirdnvarchar80
57TNWAT_OE_VPNRIS-H AT: Vertragspartnernummern für Ambulanzen3ORGPFIS-H: behandelnde OrgEinheitnvarchar80