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  | NBEW
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OINM101Whse Journal
Industry Specific :: SAP Healthcare - Industry-Specific Components for Hospitals :: Patient Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0NBEW1129IS-H: Movements for CasePatient Management
SQL:  selectupdate insert create

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

SELECT MANDT, EINRI, FALNR, LFDNR, BEWTY, BWART, BWIDT, BWIZT, PLANB, STATU, BWPDT, BWPZT, BWEDT, BWEZT, PLANE, LFDREF, TELNR, TVKZ, KZTXT, LGTXT, NOTKZ, UNFKZ, UNFNR, UNFOR, UNFZT, UNFDT, UNFTX, UNLTX, WLPRI, AUFDS, ORGFA, ORGPF, ZIMMR, BETT, PLANR, DAUER, EXTKH, ORGAU, EZUST, TODUR, ARBUN, ABWGN, ERDAT, ERUSR, UPDAT, UPUSR, STORN, STUSR, STDAT, UNFRN, BEKAT, NFGREF, VGNREF, AUFRF, MEDTX, MELTX, BWPRIO, STOID, DSPTY, VISTY, BWGR1, BWGR2, TPART, UNFVS, INSEV, OPART, CLASS, RFSRC, FACHR, UNFRT, UNFAV, WLTYP, WLRDT, WLRRN, WLSTA, WLHSP, WLADT, BCODE, ERTIM, NWATARBU, NWATNOTF, NWATBEGUT, NWATMUTT, NWATSPENDE, NWATMETHOD, NWATTRUNK, NWATSUCHT, NWATRAUF, NWATRZB, NWATVPNR, NWATBEFRGR, BEXNR, WPLID, FACHS, WPLTY, APCNID, NWATSSW, NWATBEHAND, NWATZUGART, NWATABGART, NWATZUGVA, NWATAUFART, NWATEREFCD, NWATEREFNO, NWATEREFID, SAPS, /ISHFR/PAL, /ISHFR/RDTYPE, /ISHFR/TYDOS, /ISHFR/NOOFBEAMS, EXTKH_NAME2, EXTKH_NAME3 FROM NBEW
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EINRIInstitutionnvarchar40CHAR(N' ')NoTN01EINRI Allow NULL? 
3FALNRIS-H: Case Numbernvarchar100CHAR(N' ')NoNFALFALNR Allow NULL? 
4LFDNRIS-H: Sequence Number of Movementnvarchar50NUMC(N'00000')NoLFDBEW Allow NULL? 
5BEWTYMovement Categorychar10CHAR(N' ')YesBEWTY Allow NULL? 
6BWARTIS-H: Movement Typenvarchar20CHAR(N' ')YesTN14BRI_BWART Allow NULL? 
7BWIDTIS-H: Date of Movementnvarchar80DATS(N'00000000')YesBWIDT Allow NULL? 
8BWIZTIS-H: Time of Movementnvarchar60TIMS(N'000000')YesBWIZT Allow NULL? 
9PLANBIS-H: Planned Indicator for Date of Movementchar10CHAR(N' ')YesPLANB Allow NULL? 
10STATUIS-H: Internal Status of Outpatient Visitnvarchar20CHAR(N' ')YesISH_ABSTIN Allow NULL? 
11BWPDTIS-H: Planned Date of Movementnvarchar80DATS(N'00000000')YesBWPDT Allow NULL? 
12BWPZTIS-H: Planned Time of Movementnvarchar60TIMS(N'000000')YesBWPZT Allow NULL? 
13BWEDTIS-H: Movement End Date, Start Date of Subsequent Movementnvarchar80DATS(N'00000000')YesBWEDT Allow NULL? 
14BWEZTIS-H: Movement End Time, Start Time of Subsequent Movementnvarchar60TIMS(N'000000')YesBWEZT Allow NULL? 
15PLANEIS-H: Planned Indicator for End Date of Movementchar10CHAR(N' ')YesPLANE Allow NULL? 
16LFDREFIS-H: Sequence Number of Subsequent Movementnvarchar50NUMC(N'00000')Yes*LFDREF Allow NULL? 
17TELNRIS-H: Telephone Number of Patient in Institutionnvarchar160CHAR(N' ')YesTELF_INT Allow NULL? 
18TVKZIS-H: TV Indicatorchar10CHAR(N' ')YesTVKZ Allow NULL? 
19KZTXTComment on Case Movementnvarchar500CHAR(N' ')YesTEXT_BEW Allow NULL? 
20LGTXTIndicator that Long Text Existschar10CHAR(N' ')YesRI_LGTXT Allow NULL? 
21NOTKZIS-H: Emergency Case Indicatorchar10CHAR(N' ')YesRI_NOTKZ Allow NULL? 
22UNFKZIS-H: Accident Typenvarchar30CHAR(N' ')YesTN14CUNFART Allow NULL? 
23UNFNRIS-H: File Number / Processing Number for Accidentnvarchar120CHAR(N' ')YesUNFNR Allow NULL? 
24UNFORIS-H: Accident Locationnvarchar250CHAR(N' ')YesORT01_UNF Allow NULL? 
25UNFZTIS-H: Time of Accidentnvarchar60TIMS(N'000000')YesUNFZT Allow NULL? 
26UNFDTAccident Datenvarchar80DATS(N'00000000')YesUNFDT Allow NULL? 
27UNFTXIS-H: Comment on Accidentnvarchar500CHAR(N' ')YesTEXT_UNF Allow NULL? 
28UNLTXIndicator that Long Text Existschar10CHAR(N' ')YesRI_LGTXT Allow NULL? 
29WLPRIIS-H: Priority for Preregistration/Waiting List Managementnvarchar20CHAR(N' ')YesTN14PWLPRI Allow NULL? 
30AUFDSIS-H: Latest Admission Datenvarchar80DATS(N'00000000')YesAUFDT_LAST Allow NULL? 
31ORGFAIS-H: OU with Departmental Responsibility for Casenvarchar80CHAR(N' ')YesNORGNZUWFA Allow NULL? 
32ORGPFOrganizational Unit Assigned to Casenvarchar80CHAR(N' ')YesNORGNZUWPF Allow NULL? 
33ZIMMRIS-H: Building ID of Roomnvarchar80CHAR(N' ')YesNBAUISH_ZIMMID Allow NULL? 
34BETTIS-H: Building ID of Bed Locationnvarchar80CHAR(N' ')YesNBAUBETTID Allow NULL? 
35PLANRIS-H: Planned Indicator for Room Assignmentchar10CHAR(N' ')YesISH_PLANR Allow NULL? 
36DAUERIS-H: Estimated Length of Stay or Treatmentnvarchar50NUMC(N'00000')YesISH_DAUER Allow NULL? 
37EXTKHIS-H: Identification of an External Hospitalnvarchar100CHAR(N' ')YesNGPAEXTKH Allow NULL? 
38ORGAUIS-H: Org. ID of Admitting Facilitynvarchar80CHAR(N' ')YesNORGORGAU Allow NULL? 
39EZUSTDisposition of Patient at Time of Dischargenvarchar20CHAR(N' ')YesTN14DEZUST Allow NULL? 
40TODURIS-H: Cause of Deathnvarchar30CHAR(N' ')Yes*TODUR Allow NULL? 
41ARBUNIS-H: Work Incapacity To-Datenvarchar80DATS(N'00000000')YesARBUN Allow NULL? 
42ABWGNIS-H: Indicator Whether Absence is Approved ('X')char10CHAR(N' ')YesISH_ABWGN Allow NULL? 
43ERDATIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
44ERUSRIS-H: Name of Employee who Created Recordnvarchar120CHAR(N' ')YesRI_ERNAM Allow NULL? 
45UPDATIS-H: Date of Last Changenvarchar80DATS(N'00000000')YesRI_UPDAT Allow NULL? 
46UPUSRIS-H: Name of Person who Last Changed Datanvarchar120CHAR(N' ')YesRI_UPNAM Allow NULL? 
47STORNIS-H: Cancellation Indicatorchar10CHAR(N' ')YesRI_STORN Allow NULL? 
48STUSRIS-H: Name of User who Canceled Data Recordnvarchar120CHAR(N' ')YesSTORN_USER Allow NULL? 
49STDATDate of Cancellationnvarchar80DATS(N'00000000')YesSTORN_DAT Allow NULL? 
50UNFRNIS-H: Number of the Emergency Service for Accidentnvarchar150CHAR(N' ')YesISH_RETTNR Allow NULL? 
51BEKATTreatment Categorynvarchar60CHAR(N' ')YesTN24BEKAT Allow NULL? 
52NFGREFReference to Subsequent Movementnvarchar50NUMC(N'00000')YesNBEWN1NFGREF Allow NULL? 
53VGNREFReference to Prior Movementnvarchar50NUMC(N'00000')YesNBEWN1VGNREF Allow NULL? 
54AUFRFNumber of Callsnvarchar20NUMC(N'00')YesN1AUFRF Allow NULL? 
55MEDTXMedical Textnvarchar500CHAR(N' ')YesN1MEDTX Allow NULL? 
56MELTXLong Text Indicatorchar10CHAR(N' ')YesN1MELTX Allow NULL? 
57BWPRIOPrioritization for Request/Movement (Internal)nvarchar30NUMC(N'000')YesN1APRI_D Allow NULL? 
58STOIDIS-H: Reason for Canceling Movementnvarchar30CHAR(N' ')YesN1STGRN1BSTOID Allow NULL? 
59DSPTYIS-H: Scheduling Type for Visit Schedulingnvarchar80CHAR(N' ')YesTN40BISH_DSPT Allow NULL? 
60VISTYIS-H: Code of Visit Category for Visit Schedulingchar10CHAR(N' ')YesISH_BT Allow NULL? 
61BWGR1Movement Reason - 1st and 2nd Positionsnvarchar20CHAR(N' ')YesTN14GISH_BWGR1 Allow NULL? 
62BWGR2Movement Reason - 3rd and 4th Positionsnvarchar20CHAR(N' ')YesTN14GISH_BWGR2 Allow NULL? 
63TPARTTransport Typenvarchar20CHAR(N' ')YesN1TAN1TPAE Allow NULL? 
64UNFVSIS-H: Third-Party Responsibilitychar10CHAR(N' ')YesN1FVS Allow NULL? 
65INSEVEvent which Created the Movementnvarchar40CHAR(N' ')YesISH_BEW_EV Allow NULL? 
66OPARTIS-H: Type of Surgerynvarchar20CHAR(N' ')YesTN14OISH_OPART Allow NULL? 
67CLASSIS-H: Patient Classnvarchar40CHAR(N' ')YesTNP01ISH_PAYCL Allow NULL? 
68RFSRCIS-H: Referral, Postdischarge Treatment Typenvarchar20CHAR(N' ')YesTN14HISH_REFSRC Allow NULL? 
69FACHRSpecialty for Physiciansnvarchar40CHAR(N' ')YesTNKFAFACHRTY5 Allow NULL? 
70UNFRTIS-H: Emergency Servicesnvarchar40CHAR(N' ')YesTN14IISH_RESCTY Allow NULL? 
71UNFAVIS-H: Mode of Arrivalnvarchar20CHAR(N' ')YesTN14KISH_ARRIVE Allow NULL? 
72WLTYPIS-H: Waiting Listnvarchar60CHAR(N' ')YesTN42AISH_WLTYPE Allow NULL? 
73WLRDTIS-H: Date when Movement Removed From Waiting Listnvarchar80DATS(N'00000000')YesISH_WLRDAT Allow NULL? 
74WLRRNIS-H: Reason for Removal from Waiting Listnvarchar30CHAR(N' ')YesTN42BISH_WLRRSN Allow NULL? 
75WLSTAIS-H: Preregistration/Waiting List Statusnvarchar20CHAR(N' ')YesTN42CISH_WLSTATUS Allow NULL? 
76WLHSPIS-H: Waiting List Postdischarge Hospitalnvarchar100CHAR(N' ')YesNGPAISH_WLHOSP Allow NULL? 
77WLADTIS-H: Date when Patient Added to Waiting Listnvarchar80DATS(N'00000000')YesISH_WLADAT Allow NULL? 
78BCODEIS-H: Treatment Programchar10CHAR(N' ')YesTN14MISH_BCODE Allow NULL? 
79ERTIMIS-H: Time Record Creatednvarchar60TIMS(N'000000')YesRI_ERTIM Allow NULL? 
80NWATARBUchar10(N' ')Yes Allow NULL? 
81NWATNOTFchar10(N' ')Yes Allow NULL? 
82NWATBEGUTchar10(N' ')Yes Allow NULL? 
83NWATMUTTchar10(N' ')Yes Allow NULL? 
84NWATSPENDEchar10(N' ')Yes Allow NULL? 
85NWATMETHODchar10(N' ')Yes Allow NULL? 
86NWATTRUNKchar10(N' ')Yes Allow NULL? 
87NWATSUCHTchar10(N' ')Yes Allow NULL? 
88NWATRAUFchar10(N' ')Yes Allow NULL? 
89NWATRZBchar10(N' ')Yes Allow NULL? 
90NWATVPNRnvarchar100(N' ')Yes Allow NULL? 
91NWATBEFRGRnvarchar20(N' ')Yes Allow NULL? 
92BEXNRIS-H: External Movement Identificationnvarchar200CHAR(N' ')YesISH_EXTNR_BEW Allow NULL? 
93WPLIDIdentification of the Work Environmentnvarchar400CHAR(N' ')YesNWPLACENWPLACEID Allow NULL? 
94FACHSIS-H: Occupancy Characteristicnvarchar80CHAR(N' ')YesTNPC1ISH_PLANCHARAC Allow NULL? 
95WPLTYType of the Work Environmentnvarchar30CHAR(N' ')YesNWPLACETYPE Allow NULL? 
96APCNIDIS-H: Identification of an Appointment Templatenvarchar320CHAR(N' ')YesN1APCNID Allow NULL? 
97NWATSSWnvarchar20(N'00')Yes Allow NULL? 
98NWATBEHANDnvarchar20(N' ')Yes Allow NULL? 
99NWATZUGARTchar10(N' ')Yes Allow NULL? 
100NWATABGARTchar10(N' ')Yes Allow NULL? 
101NWATZUGVAnvarchar100(N' ')Yes Allow NULL? 
102NWATAUFARTchar10(N' ')Yes Allow NULL? 
103NWATEREFCDnvarchar50(N' ')Yes Allow NULL? 
104NWATEREFNOnvarchar200(N' ')Yes Allow NULL? 
105NWATEREFIDint100((0))Yes Allow NULL? 
106SAPSnvarchar30(N'000')Yes Allow NULL? 
107/ISHFR/PALIS-H FR: Palliative Indicatorchar10CHAR(N' ')Yes/ISHFR/ISH_PAL Allow NULL? 
108/ISHFR/RDTYPEDevice Typechar10NUMC(N'0')Yes/ISHFR/ISH_RDTYPE Allow NULL? 
109/ISHFR/TYDOSType of Dosimetrychar10NUMC(N'0')Yes/ISHFR/ISH_TYDOS Allow NULL? 
110/ISHFR/NOOFBEAMSNumber of Radiation Fieldschar10NUMC(N'0')Yes/ISHFR/ISH_NOOFBEAMS Allow NULL? 
111EXTKH_NAME22nd Name/Name Affix for External Hospitalnvarchar350CHAR(N' ')YesISH_EXTHOSP_NAME2 Allow NULL? 
112EXTKH_NAME33rd Name/Name Affix for External Hospitalnvarchar350CHAR(N' ')YesISH_EXTHOSP_NAME3 Allow NULL? 
NamePrimaryUniqueTypeColumns
NBEW~0YesYesCLUSTEREDLFDNR, FALNR, EINRI, MANDT
NBEW~1NoNoNONCLUSTEREDEINRI, PLANE, STORN, BEWTY, BWIDT, BWEDT, ORGPF
NBEW~2NoNoNONCLUSTEREDEINRI, FALNR
NBEW~3NoNoNONCLUSTEREDBWIDT, BWEDT, EINRI, BETT
NBEW~4NoNoNONCLUSTEREDBWEDT, BWIDT, STORN, BEWTY, EINRI, ORGFA
NBEW~5NoNoNONCLUSTEREDSTATU, BEWTY, STORN, EINRI, BWIDT
NBEW~7NoNoNONCLUSTEREDPLANE, BWEDT, BWIDT, STORN, EINRI
NBEW~8NoNoNONCLUSTEREDWLSTA, EINRI
NBEW~9NoNoNONCLUSTEREDBEXNR, 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