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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

50 columns | Print definition?ERP 6.0  | EXTNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NNL_ZH308_V9_R04ZH308 V09 Record04 Soll Daten19EXTNRnvarchar60
2NNL_ZH308_V9_R06ZH308 V09 Record06 Soll Daten18EXTNRnvarchar60
3NNL_ZH308_V9_R16ZH308 V09 Record16 Soll Daten18EXTNRnvarchar60
4TNNL_CBVCARETYPECBV Sorgetyp3EXTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
5TNNL_CBVCLINDAYSCBV Pflegetage3EXTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
6TNNL_CBV_AGECBV Alter3EXTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
7TNNL_CBV_CONTACTCBV Kontakt Typ3EXTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
8TNNL_CBV_GENDERCBV Geschlecht3EXTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
9TNNL_CBV_MAINACTCBV Hauptaktivität3EXTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
10TNNL_CBV_SPEMCBV Spezialgebiet3EXTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
11TNNL_CBV_TYP_ACTCBV Leistungs Typ Gruppe3EXTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
12TNRT3Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields3EXTNRNumber range numbernvarchar20
13TNRT6Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields3EXTNRNumber range numbernvarchar20
14TNRT8Test no.ranges:with subobject;dep.group;2 no.range fields4EXTNRNumber range numbernvarchar20
15TNRT8ATest no.ranges:with subobject;dep.group;2 no.range fields4EXTNRNumber range numbernvarchar20
16VIXCESM180DECModelo 180 - Witholding Tax Declarer Line 0118EXTNRExternal ID Number of Tax Returnnvarchar130
17PIQDBAGM_EXTTransfer Regulations: External Acad. Achievements3EXTNRSequence Number of External Academic Achievementnvarchar30
TOPBasic Data
18NC301IS-HCM: Order Table Data Transmission for EDI30EXTNRIS-H: External Patient Identificationnvarchar200
19NC301SIS-HCM: EDI Status Management46EXTNRIS-H: External Patient Identificationnvarchar200
20NC301TIS-H EDI Temporary Storage for Old EDI Msg. Status Records46EXTNRIS-H: External Patient Identificationnvarchar200
TOPClinical System
21N1PRPATIS-H*MED: PATREG: Patientenstammdatentabelle51EXTNRIS-H: Harici hasta taniticisinvarchar200
22N1PRTMPPATIS-H*MED: PATREG: Temporäre Patientenstammdatentabelle52EXTNRIS-H: Harici hasta taniticisinvarchar200
23N1PRTMPPATLOCIS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal52EXTNRIS-H: Harici hasta taniticisinvarchar200
24NDOCAIS-H*MED: Document Management Data for Archived Documents49EXTNRIS-H: External Medical Record/Document IDnvarchar150
25NDOCSTORNOIS-H*MED: Canceled Documents50EXTNRIS-H: External Medical Record/Document IDnvarchar150
TOPDefault Risk and Limit System
26KLZUEXTOBJAssignment of External Administration Key to Object Number4EXTNRExternal Administration Numbernvarchar400
TOPDistributor-Reseller-Management
27/SAPHT/DRMCSADRVDRM: Sales Area derivation3EXTNRAdditional data, e.g. ILN or D&B no.nvarchar700
TOPOverhead Cost Controlling
28CSKRResource master record11EXTNRBase Planning Object (External Number)nvarchar180
TOPOverhead Cost Orders
29COBRBDistribution Rules Settlement Rule Order Settlement56EXTNRDistribution Rule Numbernvarchar30
TOPPatient Accounting
30NEHC_PATIS-H: Health Insurance Card (Patient Data)51EXTNRIS-H: External Patient Identificationnvarchar200
31NTPKIS-H: Header Data of Service Item7EXTNRIS-H: Alternative Identification of Service Catalog Itemnvarchar120
32NTPVIS-H: Assign Service to Base Planning Object8EXTNRBase Planning Object (External Number)nvarchar180
TOPPatient Management
33NDOCIS-H: Assignment of IS-H Objects to Documents in DMS49EXTNRIS-H: External Medical Record/Document IDnvarchar150
34NPAPIS-H: Provisional Patient Master Data15EXTNRIS-H: External Patient Identificationnvarchar200
35NPATIS-H: Patient Master Data (General)42EXTNRIS-H: External Patient Identificationnvarchar200
36NTMNIS-H: Patient-Specific Appointments (Header Table for NAPP)6EXTNRIS-H: External Patient Identificationnvarchar200
37NWANIS-H: Bad Debt Parties27EXTNRIS-H: External Patient Identificationnvarchar200
TOPProduct Cost Planning
38CKBSBase Planning Object - Unit Costing3EXTNRBase Planning Object (External Number)nvarchar180
39CKBTTexts for CKBS3EXTNRBase Planning Object (External Number)nvarchar180
40CKHSHeader: Unit Costing (Control + Totals)61EXTNRBase Planning Object (External Number)nvarchar180
41CKISItems Unit Costing/Itemization Product Costing27EXTNRBase Planning Object (External Number)nvarchar180
42CKPSUnit Costing Items19EXTNRBase Planning Object (External Number)nvarchar180
TOPPurchasing
43EREVVersion in Purchasing17EXTNRExternal Change Number of Versionnvarchar200
TOPSAP Healthcare - Industry-Specific Components for Hospitals
44ISH_HCF_HEADERHeader for Index Table8EXTNRIS-H: External Patient Identificationnvarchar200
45ISH_IDX_HEADERHeader for Index Table9EXTNRIS-H: External Patient Identificationnvarchar200
46NLDBC_TRJ_LEISTIS-H NL: Traject Leistungen3EXTNRVerrichting binnen een verrichtingencatalogusnvarchar100
47NLDBC_ZW_SPECIS-H NL: DBC leistungs gewicht kategorie pro fachrichtung3EXTNRVerrichting binnen een verrichtingencatalogusnvarchar100
48NTPKCHIS-H CH: Zusatzfelder Leistungsstamm Schweiz (TARMED)37EXTNRIS-H CH: codice prestazione est. (MEDIDATA)nvarchar200
TOPTariffs, Duties and Permits
49OIH30HTracking header12EXTNRExternal tracking numbernvarchar180
TOPWaste Management
50EWA_WA_WEIGHOFFLOffline Weighing4EXTNRExternal Number for Offline Weighingnvarchar200