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  | NFAL
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 :: Patient Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0NFAL879IS-H: CasesPatient Management
SQL:  selectupdate insert create

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

SELECT MANDT, EINRI, FALNR, FALAR, PATNR, BEKAT, ABRKZ, SICHV, EINZG, KZTXT, KUALF, BEWLF, DGNLF, PGRLF, INFKZ, STATU, FZIFF, NOTAN, KRZAN, ENDAT, ENTIM, FGTYP, KZKOM, KOMTX, KOLTX, ARBUN, ENDDT, FSPER, ERDAT, ERUSR, UPDAT, UPUSR, STORN, STUSR, STDAT, VORPT, BEGDT, STASP, KV_KZ, EAUFN, KVUEB, VORGR, OBJNR, RESID, CHILD, FOREI, FATYP, EMTYP, KTTAR, KTABK, GSTA1, GSTA2, ANZSC, ANZTD, ANZAB, LGBIS, FPEDT, APSTATE, FACHR, ENDTYP, DOCTY, DOCNR, WKAT, DOCW, PATW, PATGEW, GWEIN, PATGRO, GREIN, RESPI, FEXNR, TIMESTAMP, TOB, ISTAT_RES, ASL_RES, EXTBUD, DELGW, PLSNR, INV_COPY, SAPS_C, PIM2_C, CRIB_C, NEMS_C, MHLS, READM, LMPER, CONSENT FROM NFAL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2EINRIInstitutionnvarchar40CHAR(N' ')NoTN01EINRI Allow NULL? 
3FALNRIS-H: Case Numbernvarchar100CHAR(N' ')NoFALNR Allow NULL? 
4FALARIS-H: Case Typechar10CHAR(N' ')YesFALLART Allow NULL? 
5PATNRIS-H: Patient Numbernvarchar100CHAR(N' ')YesNPATPATNR Allow NULL? 
6BEKATTreatment Categorynvarchar60CHAR(N' ')YesTN24BEKAT Allow NULL? 
7ABRKZIS-H: Billing Indicator for Casechar10CHAR(N' ')YesABRKZ_FALL Allow NULL? 
8SICHVIS-H: Indicator for Restricted Patientchar10CHAR(N' ')YesSICHV Allow NULL? 
9EINZGIS-H: Geographical Areanvarchar90CHAR(N' ')YesEINZGEBIET Allow NULL? 
10KZTXTIS-H: Comment on Casenvarchar300CHAR(N' ')YesTEXT_NFAL Allow NULL? 
11KUALFIS-H: Last IV Request Number Assignednvarchar100CHAR(N' ')YesLLFDKUA Allow NULL? 
12BEWLFIS-H: Last Movement Number Assignednvarchar50NUMC(N'00000')Yes*LLFDBEW Allow NULL? 
13DGNLFIS-H: Obsoletenvarchar30NUMC(N'000')YesLLFDDIA Allow NULL? 
14PGRLFIS-H: Last Sequence Number for Patient Group (NPGF)nvarchar30NUMC(N'000')YesLLFDPGF Allow NULL? 
15INFKZInfection Indicatorchar10CHAR(N' ')YesINFKZ Allow NULL? 
16STATUIS-H: Case Statuschar10CHAR(N' ')YesFALLSTATUS Allow NULL? 
17FZIFFCheck Digit for Casechar10CHAR(N' ')YesPZIFF_FALL Allow NULL? 
18NOTANIS-H: Emergency Admission Indicatorchar10CHAR(N' ')YesNOTAUF Allow NULL? 
19KRZANIS-H: Quick Admission Indicatorchar10CHAR(N' ')YesKURZAUF Allow NULL? 
20ENDATIS-H: Date of Deliverynvarchar80DATS(N'00000000')YesENTDAT Allow NULL? 
21ENTIMIS-H: Time of Deliverynvarchar60TIMS(N'000000')YesENTZEIT Allow NULL? 
22FGTYPDelivery Categorychar10CHAR(N' ')YesTN15FGEBTYP Allow NULL? 
23KZKOMIS-H: Indicator that Complications Arosechar10CHAR(N' ')YesISH_KZKOM Allow NULL? 
24KOMTXIS-H: Comment on Deliverynvarchar500CHAR(N' ')YesTEXT_ENTB Allow NULL? 
25KOLTXIndicator that Long Text Existschar10CHAR(N' ')YesRI_LGTXT Allow NULL? 
26ARBUNIS-H: Work Incapacity To-Datenvarchar80DATS(N'00000000')YesARBUN Allow NULL? 
27ENDDTIS-H: End Date of Casenvarchar80DATS(N'00000000')YesENDDT_FAL Allow NULL? 
28FSPERIS-H: Billing Block for Casechar10CHAR(N' ')YesFSPER Allow NULL? 
29ERDATIS-H: Date when Record Creatednvarchar80DATS(N'00000000')YesRI_ERDAT Allow NULL? 
30ERUSRIS-H: Name of Employee who Created Recordnvarchar120CHAR(N' ')YesRI_ERNAM Allow NULL? 
31UPDATIS-H: Date of Last Changenvarchar80DATS(N'00000000')YesRI_UPDAT Allow NULL? 
32UPUSRIS-H: Name of Person who Last Changed Datanvarchar120CHAR(N' ')YesRI_UPNAM Allow NULL? 
33STORNIS-H: Cancellation Indicatorchar10CHAR(N' ')YesRI_STORN Allow NULL? 
34STUSRIS-H: Name of User who Canceled Data Recordnvarchar120CHAR(N' ')YesSTORN_USER Allow NULL? 
35STDATDate of Cancellationnvarchar80DATS(N'00000000')YesSTORN_DAT Allow NULL? 
36VORPTIS-H: Number of Days of Previous Treatmt in Calendar Yearnvarchar30NUMC(N'000')YesISH_VORPT Allow NULL? 
37BEGDTIS-H: Start Date of Casenvarchar80DATS(N'00000000')YesBEGDT_FAL Allow NULL? 
38STASPIS-H: Indicator for Admission Type "Statistics Block"char10CHAR(N' ')YesISH_STASP Allow NULL? 
39KV_KZIS-H: Relevant for Panel Physician Association Billingchar10CHAR(N' ')YesISH_KV_KZ Allow NULL? 
40EAUFNIS-HCO: Receiver (Order)nvarchar120CHAR(N' ')Yes*ISH_EAUFN Allow NULL? 
41KVUEBIS-H: Status of PPA Billing Casechar10CHAR(N' ')YesISH_KVUEB Allow NULL? 
42VORGRIS-H: Previous Days to Be Deducted from Max. Length of Staynvarchar30NUMC(N'000')YesVOR_GRVER Allow NULL? 
43OBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
44RESIDIndicator That Patient Is Non-Residentchar10CHAR(N' ')YesISH_RESID Allow NULL? 
45CHILDIS-H: Number of Childrennvarchar20CHAR(N' ')YesISH_CHILD Allow NULL? 
46FOREIIS-H: Foreign Casechar10CHAR(N' ')YesISH_FOREIG Allow NULL? 
47FATYPCase Categorynvarchar20CHAR(N' ')YesTN15CISH_CASETYPE Allow NULL? 
48EMTYPIS-H: Employee Typenvarchar20CHAR(N' ')YesTN15GISH_EMTYPE Allow NULL? 
49KTTARIS-H CH: Canton Tariffnvarchar30CHAR(N' ')YesTNCH12NCH_TARCDE Allow NULL? 
50KTABKIS-H CH: Convention (Hospital <-> Canton)nvarchar30CHAR(N' ')YesTNCH13NCH_AGREEMENT Allow NULL? 
51GSTA1IS-H CH: Gestational Age 1nvarchar30NUMC(N'000')YesNCH_GESTA1 Allow NULL? 
52GSTA2IS-H CH: Gestational Age 2nvarchar30NUMC(N'000')YesNCH_GESTA2 Allow NULL? 
53ANZSCIS-H CH: Number of Previous Pregnanciesnvarchar20NUMC(N'00')YesNCH_ANZSCH Allow NULL? 
54ANZTDIS-H CH: Number of Previous Miscarriages or Stillbirthsnvarchar20NUMC(N'00')YesNCH_ANZTOT Allow NULL? 
55ANZABIS-H CH: Number of Previous Terminations of Pregnancynvarchar20NUMC(N'00')YesNCH_ANZABB Allow NULL? 
56LGBISIS-H CH: Service Generation Date tonvarchar80DATS(N'00000000')YesNWCH_GENBIS Allow NULL? 
57FPEDTIS-H: Date of Wound Healingnvarchar80DATS(N'00000000')YesISH_FPEDT Allow NULL? 
58APSTATEIS-H: Application Statusnvarchar20CHAR(N' ')YesTNC301SAISH_APSTATE Allow NULL? 
59FACHRSpecialty for Organizational Unitnvarchar40CHAR(N' ')YesTNKFAFACHRTY7 Allow NULL? 
60ENDTYPIS-H: Type of Case Endnvarchar20CHAR(N' ')YesTN15DISH_CASEEND Allow NULL? 
61DOCTYIS-H: Subvention Document Type (Long)nvarchar20CHAR(N' ')YesTN17DISH_LPASSTY Allow NULL? 
62DOCNRIS-H: Subvention Document Number (Long)nvarchar300CHAR(N' ')YesISH_LPASSNR Allow NULL? 
63WKATIS-H: Choice of Ward Classchar10CHAR(N' ')YesTN15HISH_WKAT Allow NULL? 
64DOCWIS-H: Named Referral Indicatorchar10CHAR(N' ')YesISH_DOCWKZ Allow NULL? 
65PATWIS-H: Patient Requested Referral Indicatorchar10CHAR(N' ')YesISH_PATWKZ Allow NULL? 
66PATGEWIS-H: Weight of Patient at Admissiondecimal73QUAN((0))YesISH_PATGEW
67GWEINIS-H: Unit of Measurement for Patient Weightnvarchar30UNIT(N' ')YesT006ISH_EINGEW Allow NULL? 
68PATGROIS-H: Height of Patient at Admissiondecimal52QUAN((0))YesISH_PATGRO
69GREINIS-H: Unit of Measurement for Patient Sizenvarchar30UNIT(N' ')YesT006ISH_EINGRO Allow NULL? 
70RESPIIS-H: Duration of Mechanical Ventilation in Hoursnvarchar50NUMC(N'00000')YesISH_RESPIRATION Allow NULL? 
71FEXNRIS-H: External Case Identificationnvarchar200CHAR(N' ')YesISH_EXTNR_FAL Allow NULL? 
72TIMESTAMPTimestamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesISH_TIMESTAMP
73TOBIS-H: Days Without Calculationnvarchar30NUMC(N'000')YesISH_TOB Allow NULL? 
74ISTAT_RESISTAT Codenvarchar60CHAR(N' ')YesISH_ISTAT Allow NULL? 
75ASL_RESASL as Insurance Providernvarchar100CHAR(N' ')Yes*ISH_ASL_KOSTR Allow NULL? 
76EXTBUDExtra-Budget Treatmentnvarchar20CHAR(N' ')YesISH_EXTBUD Allow NULL? 
77DELGWnvarchar20(N'00')Yes Allow NULL? 
78PLSNRIS-H: PRS Numbernvarchar200CHAR(N' ')YesISH_EXTNR_PLS Allow NULL? 
79INV_COPYchar10(N' ')Yes Allow NULL? 
80SAPS_Cnvarchar30(N'000')Yes Allow NULL? 
81PIM2_Cnvarchar30(N'000')Yes Allow NULL? 
82CRIB_Cnvarchar30(N'000')Yes Allow NULL? 
83NEMS_Cnvarchar60(N'000000')Yes Allow NULL? 
84MHLSMental Health Legal Statuschar10CHAR(N' ')YesISH_MHLS Allow NULL? 
85READMIndicator for Possible Readmission Casechar10CHAR(N' ')YesISH_READM Allow NULL? 
86LMPERDate of Last Menstrual Cyclenvarchar80DATS(N'00000000')YesISH_LMPER Allow NULL? 
87CONSENTchar10(N' ')Yes Allow NULL? 
NamePrimaryUniqueTypeColumns
NFAL~0YesYesCLUSTEREDFALNR, EINRI, MANDT
NFAL~1NoNoNONCLUSTEREDEINRI, PATNR
NFAL~2NoNoNONCLUSTEREDEINRI, FALAR
NFAL~3NoNoNONCLUSTEREDEINRI, ENDAT
NFAL~4NoNoNONCLUSTEREDEINRI, ABRKZ
NFAL~5NoNoNONCLUSTEREDEINRI, EAUFN
NFAL~6NoNoNONCLUSTEREDFEXNR, MANDT
NFAL~7NoNoNONCLUSTEREDTIMESTAMP, MANDT
NFAL~8NoNoNONCLUSTEREDEINRI, PLSNR, 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