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  | N2DOCFAL
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.0N2DOCFAL691IS-H*MED: Case Data for Archived DocumentsClinical System
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 FROM N2DOCFAL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2EINRIInstitutionnvarchar40CHAR(N' ')No*EINRI Allow NULL? 
3FALNRIS-H: Case Numbernvarchar100CHAR(N' ')No*FALNR Allow NULL? 
4FALARIS-H: Case Typechar10CHAR(N' ')YesFALLART Allow NULL? 
5PATNRIS-H: Patient Numbernvarchar100CHAR(N' ')Yes*PATNR Allow NULL? 
6BEKATTreatment Categorynvarchar60CHAR(N' ')Yes*BEKAT 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' ')Yes*GEBTYP 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' ')Yes*ISH_CASETYPE Allow NULL? 
48EMTYPIS-H: Employee Typenvarchar20CHAR(N' ')Yes*ISH_EMTYPE Allow NULL? 
49KTTARIS-H CH: Canton Tariffnvarchar30CHAR(N' ')Yes*NCH_TARCDE Allow NULL? 
50KTABKIS-H CH: Convention (Hospital <-> Canton)nvarchar30CHAR(N' ')Yes*NCH_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' ')Yes*ISH_APSTATE Allow NULL? 
59FACHRSpecialty for Organizational Unitnvarchar40CHAR(N' ')Yes*FACHRTY7 Allow NULL? 
60ENDTYPIS-H: Type of Case Endnvarchar20CHAR(N' ')Yes*ISH_CASEEND Allow NULL? 
61DOCTYType of Identification Documentnvarchar20CHAR(N' ')Yes*ISH_PASSTY Allow NULL? 
62DOCNRIS-H: Subvention Document Number (Long)nvarchar300CHAR(N' ')YesISH_LPASSNR Allow NULL? 
63WKATIS-H: Choice of Ward Classchar10CHAR(N' ')Yes*ISH_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' ')Yes*ISH_EINGEW Allow NULL? 
68PATGROIS-H: Height of Patient at Admissiondecimal52QUAN((0))YesISH_PATGRO
69GREINIS-H: Unit of Measurement for Patient Sizenvarchar30UNIT(N' ')Yes*ISH_EINGRO Allow NULL? 
NamePrimaryUniqueTypeColumns
N2DOCFAL~0YesYesCLUSTEREDFALNR, EINRI, 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