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  | NLEI
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: SAP Healthcare - Industry-Specific Components for Hospitals :: Patient Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0NLEI1449IS-H: Services PerformedPatient Management
SQL:  selectupdate insert create

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

SELECT MANDT, EINRI, FALNR, ORGID, LEIST, LNRLS, LFDBEW, REFBEW, ERBTY, ANFOE, ANMAN, ERBOE, ERMAN, HAUST, PREIS, MATNR, ABRKZ, STALS, IMENG, IBGDT, IENDT, IBZT, IEZT, PMENG, PBGDT, PENDT, PBZT, PEZT, TARIF, TARLS, TARSP, TARAS, TLMEN, LEINH, LEITX, ERDAT, ERUSR, UPDAT, UPUSR, STORN, STUSR, REFLNR, ZEITR, BEGTX, WNDNR, REMRK, REFNR, KZBCP, BILLP, ANPOE, APMAN, REMKZ, ICPMK, ICPML, ICPHC, BEGKZ, HCOKZ, ANART, OTYPL, UBVON, UBBIS, UBLKZ, UMENG, UAEKZ, NUBKZ, ENTKY, ENZKY, ENTG2, EVENT, OBJCT, KALKZ, EVTUP, OBJUP, ABTYP, TCODE, ABRMA, EAUFN, BZLST, KTRKZ, BFORM, ENTGA, NBGDT, NBGZT, ZOTYP, PZAHL, REFKY, EXCAT, USER0, USER1, USERDATE1, USERDATE2, USERTIME1, USERTIME2, USERPRICE1, USERAMOUNT1, USERUNIT1, USERSIGN1, USERSIGN2, SEQUE, USER2, USERTEXT1, VIEWTYPE, FORMNAME, FORMBELNR, NLSLOK, MDIND, BGMAN, EDMAN, BEWMAN, TIMESTAMP, DBCNR, CONVSIGN, WISSCD, MEDUNIT, LNRLM, /ISHFR/AKTIV, /ISHFR/PHASE, /ISHFR/MOD_CD1, /ISHFR/MOD_CD2, /ISHFR/MOD_CD3, /ISHFR/MOD_CD4, /ISHFR/KOE_SV, /ISHFR/PRSC_DT, /ISHFR/ASS_CD, /ISHFR/PUR_PR, /ISHFR/EXO_CP, /ISHFR/NABM_CO, /ISHFR/HOPRICE, /ISHFR/PSCRV, NLKZA, TAMAN, HIC_FREE, DEVNR, ORDNR, LABTYP, BEAG, DCODE, CONSVA, LAAMB, LSCHL, ABRTX, ENTGAMB, THERGROUP, ET_LNRIC FROM NLEI
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2EINRIInstitutionnvarchar40 Allow NULL? 
3FALNRIS-H: Case Numbernvarchar100 Allow NULL? 
4ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80 Allow NULL? 
5LEISTService in Service Catalognvarchar100 Allow NULL? 
6LNRLSIS-H: Service Sequence Numbernvarchar100 Allow NULL? 
7LFDBEWIS-H: Sequence Number of Movementnvarchar50 Allow NULL? 
8REFBEWIS-H: Movement which Caused Service Splitnvarchar50 Allow NULL? 
9ERBTYType of Service Performancechar10 Allow NULL? 
10ANFOEDepartmental Organizational Unit That Requests the Servicenvarchar80 Allow NULL? 
11ANMANIS-H: Default Value Changed Manuallychar10 Allow NULL? 
12ERBOEIS-H: Organizational Unit that Performs the Servicenvarchar80 Allow NULL? 
13ERMANIS-H: Default Value Changed Manuallychar10 Allow NULL? 
14HAUSTIS-H: Service Catalog Identification Keynvarchar20 Allow NULL? 
15PREISIS-H: Indiv. Price of Service Different from Service Masterdecimal112
16MATNRIS-H: Material Number of Servicenvarchar180 Allow NULL? 
17ABRKZService Can Be Billed Forchar10 Allow NULL? 
18STALSIS-H: Service Status (Planned/Performed)char10 Allow NULL? 
19IMENGService Quantitynvarchar40 Allow NULL? 
20IBGDTIS-H: Date when Service Performance Starts (Actual)nvarchar80 Allow NULL? 
21IENDTIS-H: Date when Service Performance Ends (Actual)nvarchar80 Allow NULL? 
22IBZTIS-H: Time when Service Performance Starts (Actual)nvarchar60 Allow NULL? 
23IEZTIS-H: Time Service Performance Ends (Actual)nvarchar60 Allow NULL? 
24PMENGIS-H: Service Quantity (Planned)nvarchar40 Allow NULL? 
25PBGDTIS-H: Start Date of Service Performance (PLANNED)nvarchar80 Allow NULL? 
26PENDTIS-H: Date Service Performance Ends (PLANNED)nvarchar80 Allow NULL? 
27PBZTIS-H: Time Service Performance Starts (PLANNED)nvarchar60 Allow NULL? 
28PEZTIS-H: Time Service Performance Ends (PLANNED)nvarchar60 Allow NULL? 
29TARIFIS-H: Service Catalog Identification Keynvarchar20 Allow NULL? 
30TARLSService in Service Catalognvarchar100 Allow NULL? 
31TARSPIS-H: Column in Service Catalognvarchar20 Allow NULL? 
32TARASIS-H: Multiplication Factordecimal63
33TLMENIS-H: Partial Delivery Quantity of Servicenvarchar40 Allow NULL? 
34LEINHIS-H: Unit of Measure for Servicenvarchar30 Allow NULL? 
35LEITXIS-H: Service Short Text (May Differ from Service Master)nvarchar400 Allow NULL? 
36ERDATIS-H: Date when Record Creatednvarchar80 Allow NULL? 
37ERUSRIS-H: Name of Employee who Created Recordnvarchar120 Allow NULL? 
38UPDATIS-H: Date of Last Changenvarchar80 Allow NULL? 
39UPUSRIS-H: Name of Person who Last Changed Datanvarchar120 Allow NULL? 
40STORNIS-H: Cancellation Indicatorchar10 Allow NULL? 
41STUSRIS-H: Name of User who Canceled Data Recordnvarchar120 Allow NULL? 
42REFLNRIS-H: Sequence Number per Service (Time-Dependent)nvarchar100 Allow NULL? 
43ZEITRIS-H: Indicator for Extended Servicechar10 Allow NULL? 
44BEGTXIS-H: Reason for Multiplication Factornvarchar400 Allow NULL? 
45WNDNRIS-H: Wound Numbernvarchar100 Allow NULL? 
46REMRKIS-H: User's Comment on Servicenvarchar400 Allow NULL? 
47REFNR_nvarchar100 Allow NULL? 
48KZBCP_char10 Allow NULL? 
49BILLPIS-H NL: Invoicing Party (Hospital or Physician)char10 Allow NULL? 
50ANPOEIS-H: Nursing Organizational Unit Requesting the Servicenvarchar80 Allow NULL? 
51APMANIS-H: Default Value Changed Manuallychar10 Allow NULL? 
52REMKZLanguage Keychar10 Allow NULL? 
53ICPMKIS-H: Identification of Surgical Procedure Coding Catalognvarchar20 Allow NULL? 
54ICPMLIS-H: Surgical Procedure Code (Service)nvarchar100 Allow NULL? 
55ICPHCIS-H: Main Surgical Procedure Codechar10 Allow NULL? 
56BEGKZLanguage Keychar10 Allow NULL? 
57HCOKZIS-H: Service Relevant for COchar10 Allow NULL? 
58ANARTIS-H: Analysis Type for Service (DKG-NT Germany)char10 Allow NULL? 
59OTYPLObject Type of Servicechar10 Allow NULL? 
60UBVONIS-HCO: Start of Transfernvarchar80 Allow NULL? 
61UBBISIS-HCO: End of Transfernvarchar80 Allow NULL? 
62UBLKZIS-HCO: Transfer Indicator for Service/Materialchar10 Allow NULL? 
63UMENGIS-HCO: Transferred Service Quantitynvarchar40 Allow NULL? 
64UAEKZIS-HCO: Service/Material Was Changed after Transfer into COchar10 Allow NULL? 
65NUBKZIS-HCO: Ind. that service is permanently not transferablechar10 Allow NULL? 
66ENTKYCharge Key for Paragraph 301/DALE-UVnvarchar20 Allow NULL? 
67ENZKYIS-H: Add. Key for Charge Type for FR/Case, Proc.Surchargeschar10 Allow NULL? 
68ENTG2IS-H: Charge Type According to ยง301nvarchar50 Allow NULL? 
69EVENTIS-H: Event that generates servicesnvarchar20 Allow NULL? 
70OBJCTIS-H: Object that generated servicesnvarchar100 Allow NULL? 
71KALKZIS-H: For Internal Purposes Only, DB Contents Irrelevantchar10 Allow NULL? 
72EVTUPIS-H: Event that Changed Servicesnvarchar20 Allow NULL? 
73OBJUPIS-H: Object that changed servicesnvarchar100 Allow NULL? 
74ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40 Allow NULL? 
75TCODEIS-H: Report Control: Transaction Code for Applicationnvarchar200 Allow NULL? 
76ABRMAIS-H: Default Value Changed Manuallychar10 Allow NULL? 
77EAUFNIS-HCO: Cost Object (Order)nvarchar120 Allow NULL? 
78BZLSTSequence Number of Reference Servicenvarchar100 Allow NULL? 
79KTRKZIS-H: Service is Cost Objectchar10 Allow NULL? 
80BFORMIS-H: Valuation Formula for Extended Servicesnvarchar20 Allow NULL? 
81ENTGAIS-H: Charge Type for Servicenvarchar20 Allow NULL? 
82NBGDTIS-H: Date of Next Extended Servicenvarchar80 Allow NULL? 
83NBGZTIS-H: Start Time of Subsequent Extended Servicenvarchar60 Allow NULL? 
84ZOTYPIS-H: Type of Service Assignmentnvarchar30 Allow NULL? 
85PZAHLIS-H: Charge Factordecimal112
86REFKYReference Code for Service from External Systemnvarchar200 Allow NULL? 
87EXCATIS-H: Classification for External Communicationnvarchar200 Allow NULL? 
88USER0IS-H: Customer-Specific Field 1nvarchar200 Allow NULL? 
89USER1IS-H: Customer-Specific Field 2nvarchar200 Allow NULL? 
90USERDATE1IS-H: Customer-Specific Field for Start Datenvarchar80 Allow NULL? 
91USERDATE2IS-H: Customer-Specific Field for End Datenvarchar80 Allow NULL? 
92USERTIME1IS-H: Customer-Specific Field for Start Timenvarchar60 Allow NULL? 
93USERTIME2Customer-Specific Field for End Timenvarchar60 Allow NULL? 
94USERPRICE1IS-H: Customer-Specific Field for Amountdecimal112
95USERAMOUNT1IS-H: Customer-Specific Field for Quantitydecimal133
96USERUNIT1IS-H: Customer-Specific Field for Unitnvarchar30 Allow NULL? 
97USERSIGN1Customer-Specific Field for Indicator 1char10 Allow NULL? 
98USERSIGN2Customer-Specific Field for Indicator 2char10 Allow NULL? 
99SEQUEIS-H: Entry Sequence for Objectnvarchar100 Allow NULL? 
100USER2IS-H: Customer-Specific Field 3nvarchar200 Allow NULL? 
101USERTEXT1IS-H: Customer-Specific Field for Free Textnvarchar800 Allow NULL? 
102VIEWTYPEView Typenvarchar30 Allow NULL? 
103FORMNAMEIS-H: Form Name for Service Entrynvarchar150 Allow NULL? 
104FORMBELNRIS-H: Document Number of Service Formnvarchar20 Allow NULL? 
105NLSLOKIS-H: Localization of Servicenvarchar20 Allow NULL? 
106MDINDIS-H: Service for Medical Indicationchar10 Allow NULL? 
107BGMANIS-H: Manually Set Service Startchar10 Allow NULL? 
108EDMANIS-H: Manually Set Service Endchar10 Allow NULL? 
109BEWMANIS-H: Movement Assignment Set Manuallychar10 Allow NULL? 
110TIMESTAMPTimestamp in Short Form (YYYYMMDDhhmmss)decimal150
111DBCNRnvarchar100 Allow NULL? 
112CONVSIGNIS-H: Indicator that Service Generated by Remappingchar10 Allow NULL? 
113WISSCDIS-H: EO Research Code for Servicenvarchar20 Allow NULL? 
114MEDUNITnvarchar30 Allow NULL? 
115LNRLMIS-H MM: Sequence Number of Material Consumptionnvarchar100 Allow NULL? 
116/ISHFR/AKTIVIS-H FR: Activitychar10 Allow NULL? 
117/ISHFR/PHASEIS-H FR: Phasechar10 Allow NULL? 
118/ISHFR/MOD_CD1IS-H FR: Modification Codechar10 Allow NULL? 
119/ISHFR/MOD_CD2IS-H FR: Modification Codechar10 Allow NULL? 
120/ISHFR/MOD_CD3IS-H FR: Modification Codechar10 Allow NULL? 
121/ISHFR/MOD_CD4IS-H FR: Modification Codechar10 Allow NULL? 
122/ISHFR/KOE_SVIS-H FR: Cost Reimbursement by Social Insurancechar10 Allow NULL? 
123/ISHFR/PRSC_DTIS-H FR: Prescription Datenvarchar80 Allow NULL? 
124/ISHFR/ASS_CDIS-H FR: Association Codechar10 Allow NULL? 
125/ISHFR/PUR_PRIS-H FR: Purchase Pricedecimal112
126/ISHFR/EXO_CPIS-H FR: Service-Related Patient Contribution Exemptionchar10 Allow NULL? 
127/ISHFR/NABM_COIS-H FR: Coefficientdecimal62
128/ISHFR/HOPRICEIS-H FR: Price for Fee Surchargedecimal112
129/ISHFR/PSCRVDrug Order Confirmedchar10 Allow NULL? 
130NLKZAIS-H: Indicator for Automatic Assgmt to Certificate (NLKZ)char10 Allow NULL? 
131TAMANMultiplication Factor Specified Manuallychar10 Allow NULL? 
132HIC_FREEIndicator for Noncovered Servicechar10 Allow NULL? 
133DEVNRDevice Numbernvarchar200 Allow NULL? 
134ORDNRnvarchar200 Allow NULL? 
135LABTYPchar10 Allow NULL? 
136BEAGchar10 Allow NULL? 
137DCODETooth Numbernvarchar20 Allow NULL? 
138CONSVARoute of Administration of Drugsnvarchar50 Allow NULL? 
139LAAMBService Type P301 Outpatientnvarchar20 Allow NULL? 
140LSCHLService Code P301 Outpatientnvarchar200 Allow NULL? 
141ABRTXIS-H: Billing Reasonnvarchar700 Allow NULL? 
142ENTGAMBCharge Type P301 for Outpatient Institutionsnvarchar80 Allow NULL? 
143THERGROUPSize of Therapy Group in Psychiatry/Psychosomaticstinyint30
144ET_LNRICIS-H: Sequence Number of Surgical Procedure Codenvarchar100 Allow NULL? 
NamePrimaryUniqueTypeColumns
NLEI~0YesYesCLUSTEREDLNRLS, LEIST, ORGID, FALNR, EINRI, MANDT
NLEI~1NoNoNONCLUSTEREDLNRLS, ORGID, STORN, HCOKZ, UAEKZ, EINRI, NUBKZ, UBLKZ, FALNR, MANDT
NLEI~2NoYesNONCLUSTEREDLNRLS, MANDT
NLEI~3NoNoNONCLUSTEREDEINRI, ERBOE, IENDT, MANDT
NLEI~4NoNoNONCLUSTEREDEAUFN, MANDT
NLEI~5NoNoNONCLUSTEREDORGID, IBGDT, MANDT
NLEI~6NoNoNONCLUSTEREDORGID, PBGDT, MANDT
NLEI~7NoNoNONCLUSTEREDLNRLS, FALNR, STORN, HCOKZ, UAEKZ, EINRI, NUBKZ, UBLKZ, ORGID, MANDT
NLEI~8NoNoNONCLUSTEREDTIMESTAMP, 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