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
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

156 columns | Print definition?ERP 6.0  | ORGID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/NRNRSNAssignment of numbering schemes to attributes (long number)3ORGIDID for Organizational Structurenvarchar200
2/SAPPSSRM/ORCODOrder Codes as Part of the Organization ID for long numbers3ORGIDID for Organizational Structurenvarchar200
3/SAPPSSRM/ORGIDID for Organizational Structure in Smart Number2ORGIDID for Organizational Structurenvarchar200
4/SAPPSSRM/ORGIDTDescription of ID for Organization in Smart Number3ORGIDID for Organizational Structurenvarchar200
5EHPRCD_ADRDCP: expanded data for business partner6ORGIDOrganizational Unitnvarchar90
6EHPRCD_EXIMDSAvailable Search Criteria6ORGIDReceiving Organization IDnvarchar90
7EHPRCD_ORGIDSOrganisation2ORGIDOrganizational Unitnvarchar90
8EHPRCD_ORGPERContact2ORGIDOrganizational Unitnvarchar90
9N1CORDFVCORD: Initiator4ORGIDCORD: Initiating OUnvarchar80
10PA0899HR Master Record: Infotype 089926ORGIDOrganization Codenvarchar60
11T5PPBS0PHR-PT-PS: OBSOLETE7ORGIDOrganization Codenvarchar60
12T5PPBS7OOrganizations2ORGIDOrganization Codenvarchar60
13T5PPBS7OTOrganizations3ORGIDOrganization Codenvarchar60
14T5PPBS9GSPortugal Public Sector - BDAP - Service Codes2ORGIDOrganization Codenvarchar60
15T5PPBS9GSTPortugal Public Sector - BDAP - Service Codes Texts3ORGIDOrganization Codenvarchar60
16T5PPBS9GWPortugal Public Sector - BDAP - Workplace Codes2ORGIDOrganization Codenvarchar60
17T5PPBS9GWTPortugal Public Sector - BDAP - Workplace Codes Texts3ORGIDOrganization Codenvarchar60
18T5PPBSIOESIOE: Organization code6ORGIDOrganization Codenvarchar60
19TN23OEBSDE: Outpatient P301 Billing: OU-POWN Assignment3ORGIDIdentification Key of Organizational Unitnvarchar80
20ZSUPM_BR_IMTable for IM - Brazil Scenario2ORGIDnvarchar80
21ZSUPM_IMSuPM Table for IM2ORGIDnvarchar80
TOPBasic Data
22NBAKIS-H: Index Building Unit Identifier ---> Org. Unit3ORGIDIdentification Key of Organizational Unitnvarchar80
23NORGIS-H: Organizational Units2ORGIDIdentification Key of Organizational Unitnvarchar80
24NUMKIS-H: Map Org. Unit Identifier to Org. Unit Ident. Key15ORGIDIdentification Key of Organizational Unitnvarchar80
25NUMOIS-H: Map Org. Unit Ident. Key to Org. Unit Identifier3ORGIDIdentification Key of Organizational Unitnvarchar80
26TN11OIS-H: Assign Building Units to Org. Units3ORGIDIdentification Key of Organizational Unitnvarchar80
27TN120IS-H: Responsibility for Position3ORGIDIdentification Key of Organizational Unitnvarchar80
28TN128IS-H: Assignment Position/Org. Unit/Institution3ORGIDIdentification Key of Organizational Unitnvarchar80
29TN40AIS-H: Text for Scheduling Type4ORGIDIdentification Key of Organizational Unitnvarchar80
30TN40BIS-H: Scheduling Types3ORGIDIdentification Key of Organizational Unitnvarchar80
31TNCO2IS-HCM Dispatch Control with Org. Unit Dependency5ORGIDIS-HCM: Organizational unit affected by an eventnvarchar80
32TNF10IS-H: Techn. Work Organizer - Org. Unit Assignment3ORGIDIS-H: Org. Unit for Work Organizer Assignmentnvarchar80
33TNKFOIS-H: Specialty-to-Organizational Unit Assignment2ORGIDIdentification Key of Organizational Unitnvarchar80
34TNT1IS-H: Specialty-Related Service Catalogs3ORGIDIdentification Key of Organizational Unitnvarchar80
TOPBusiness Configuration Sets
35SCPRATTRBC Set: Attributes12ORGIDCompany short namenvarchar100
36SCPRSATTRSwitch BC Set: Attributes12ORGIDCompany short namenvarchar100
TOPCentral Part of Product Master
37COMM_PME_CAT_MAPMapping of a Category or Product to PME Classes13ORGIDOrganizational Unitnvarchar300
38COMM_PME_PRD_MAPMapping of CRM Products for PME Classes13ORGIDOrganizational Unitnvarchar300
39COMM_PME_SET_MAPMapping Set Types for PME Classes13ORGIDOrganizational Unitnvarchar300
TOPClinical System
40N1ANFTYPIS-H*MED: Request Type4ORGIDIdentification Key of Organizational Unitnvarchar80
41N1ATKIS-H*MED: VBUND: Anfotypverwendung Kommunikationspartner3ORGIDIS-H: Identifikation der Organisationseinheitnvarchar80
42N1BCH2OUOBSOLETE5ORGIDIdentification Key of Organizational Unitnvarchar80
43N1BCRC2BCSMCBasic Cat.: Display Config. - Main Catalog Assignment7ORGIDIdentification Key of Organizational Unitnvarchar80
44N1BCSPEC2OUBasic Cat.: Range to OU Assignment6ORGIDIdentification Key of Organizational Unitnvarchar80
45N1BEZYIS-H*MED: Cycles with NLEI reference4ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80
46N1DCSGETMELSFORIS-H*MED: DCS: (DIACOS) Determine MISs for OUs3ORGIDIS-H: Organizational Unit that Performs the Servicenvarchar80
47N1DCS_DAUERTHEIS-H*MED: DCS: Quick Entry Long-Term Therapies4ORGIDIdentification Key of Organizational Unitnvarchar80
48N1DCS_OUIS-H*med: DCS: OU-Related Quick Entry Control3ORGIDIdentification Key of Organizational Unitnvarchar80
49N1DOKEMPFIS-H*MED: Recipient of the Documents26ORGIDIdentification Key of Organizational Unitnvarchar80
50N1GUISTATUSIS-H*MED: User-Dependant GUI-Status4ORGIDOrg. Unit of Usernvarchar80
51N1KPOIS-H*MED: VBUND: Zordnung OE - Kommunikationspartner3ORGIDIS-H: Identifikation der Organisationseinheitnvarchar80
52N1MEOEZIS-H*MED: Medication - OU Assignment5ORGIDIdentification Key of Organizational Unitnvarchar80
53N1MLZUOIS-H*MED: Service-related material proposal4ORGIDIdentification Key of Organizational Unitnvarchar80
54N1OUTIMESi.s.h.med: Standard Times for Organizational Units4ORGIDIdentification Key of Organizational Unitnvarchar80
55N1PLATHIS-H*MED: Day-Related Planning Authority6ORGIDPlanning Organizational Unitsnvarchar80
56N1PLSTISHMED: Position5ORGIDIdentification Key of Organizational Unitnvarchar80
57N1PRANFIS-H*MED: PATREG: Anforderungen4ORGIDIS-H: Organizasyon birimi taniticisinvarchar80
58N1PRLEMIS-H*MED: PATREG: Leistungen4ORGIDIS-H: Org.birimi (yalniz OB iliskili hizmet girisinde)nvarchar80
59N1PRVKGIS-H*MED: PATREG: Vormerkungen5ORGIDKlnSprs/ÖnKyt: Tedavi eden organizasyon biriminvarchar80
60N1SOLLBETTIS-H*MED:Number of planned beds for A2, A3 patient for OU2ORGIDIdentification Key of Organizational Unitnvarchar80
61N1STZYOEIS-H*MED: Cycle Prioritization as a Function of the OU3ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80
62N1TMSTPDURDEFi.s.h.med: Duration Definition of Time Stamps5ORGIDIdentification Key of Organizational Unitnvarchar80
63N1TPGOIS-H*MED: Day program: Assign OU time segments6ORGIDPlanning Organizational Unitsnvarchar80
64N1TPGOUAi.s.h.med: Medication OU Template Group Assignment4ORGIDIdentification Key of Organizational Unitnvarchar80
65N1TPOUAMedication: OBSOLETE - Replaced by N1TPGOUA3ORGIDIdentification Key of Organizational Unitnvarchar80
66N1VMKIS-H*MED: Table for preselections in the service hit list3ORGIDIdentification Key of Organizational Unitnvarchar80
67N1XLEIISHMED: Service Range5ORGIDIdentification Key of Organizational Unitnvarchar80
68N1YLEIIS-H*MED: Requestable services3ORGIDIS-H: Organizational Unit that Performs the Servicenvarchar80
69N2BKOEIS-H*MED: Assignment of authorization category to OU4ORGIDIdentification Key of Organizational Unitnvarchar80
70N2DLV_RECEIVERi.s.h.med: Dispatch - Recipient23ORGIDIdentification Key of Organizational Unitnvarchar80
71N2DOIS-H*MED: Table of doc. category to org. unit assignments3ORGIDIdentification Key of Organizational Unitnvarchar80
72N2DO1IS-H*MED: Table of doc. category to org. unit assignments3ORGIDIdentification Key of Organizational Unitnvarchar80
73N2GL_ACTpathways Activity7ORGIDpathways Organizational Unitnvarchar80
74N2GL_BASE_REQIS-H*MED: Base Item Request4ORGIDIdentification Key of Organizational Unitnvarchar80
75N2HLIS-H*MED: OU-related hit list for diagnoses3ORGIDIdentification Key of Organizational Unitnvarchar80
76N2MV_DISREQDispatch Request Data Table12ORGIDIdentification Key of Organizational Unitnvarchar80
77N2MV_VSDATRecipient Data Table11ORGIDIdentification Key of Organizational Unitnvarchar80
78N2MV_VSVORPresetting Control Table11ORGIDIdentification Key of Organizational Unitnvarchar80
79TN1AETITLEIS-H*MED RAD: Assignment of RAD and PACS Resources5ORGIDIdentification Key of Organizational Unitnvarchar80
80TN1MECHTYPEi.s.h.med: Medication Check Type4ORGIDIdentification Key of Organizational Unitnvarchar80
81TN1RADACTIS-H*MED: Actions of the RAD Module2ORGIDIdentification Key of Organizational Unitnvarchar80
82TN26GIS-H*MED: OU-Related Keyword Catalog3ORGIDIdentification Key of Organizational Unitnvarchar80
83TN2PDCS2OEIPPD: Assignments: SET - OU - Occupational Group4ORGIDIdentification Key of Organizational Unitnvarchar80
84TN2STAMPORGIS-H*MED: Preferred Stamp of Employee in Surgery6ORGIDIdentification Key of Organizational Unitnvarchar80
TOPData Warehousing Workbench
85RSGMDDMODIDSNode IDs in the Data Models6ORGIDInternal Node ID of a Node in the Data Modelint100
TOPDocuments
86TN1IM_CFGConfiguration Settings for Image System, General4ORGIDIdentification Key of Organizational Unitnvarchar80
87TN1IM_IMAGIC_CFGConfiguration Settings for Imagic Client4ORGIDIdentification Key of Organizational Unitnvarchar80
TOPE-Recruiting
88HRP5125DB Table for Infotype 512522ORGIDOrganizational Unitnvarchar80
TOPEnvironment, Health and Safety
89/TDAG/CPT_ADRDCP: expanded data for business partner6ORGIDOrganizational Unitnvarchar90
90/TDAG/CPT_EXIMDSAvailable Search Criteria6ORGIDReceiving Organization IDnvarchar90
91/TDAG/CPT_EXUPLCP: Application Table für IMDS Uplolad6ORGIDReceiving Organization IDnvarchar90
92/TDAG/CPT_ORGIDSIMDS Organisation2ORGIDOrganizational Unitnvarchar90
93/TDAG/CPT_ORGPERIMDS Contact2ORGIDOrganizational Unitnvarchar90
TOPFrance
94HRP1690DB Table for Infotype 169022ORGIDTNM: Org. unit IDnvarchar80
TOPMaintenance Orders
95CNOCI_ORGUOCI Interface: Control Parameter Network6ORGIDOCI: Identification for the organizationnvarchar400
96IOCI_ORGUOCI Interface: Control Parameter PM/CS Order6ORGIDOCI: Identification for the organizationnvarchar400
97IOCI_ORGU_TLOCI Interface: Control Parameter Task List6ORGIDOCI: Identification for the organizationnvarchar400
TOPNursing
98N1SNPH2OUStnd Nrs. Plan: Standard Nursing Plan to OU Assignment5ORGIDIdentification Key of Organizational Unitnvarchar80
TOPPatient Accounting
99NGLTIS-H: Intermediate table for service statistics9ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80
100NKONVIS-H: Direct patient billing pat-related/admin. costs12ORGIDID of Billing Organizational Unitnvarchar80
101NLCOIS-HCO: Transfer information10ORGIDIdentification Key of Organizational Unitnvarchar80
102NLEQIS-H: Dummy, Lock Management OU-Rel. Svces from Prel. Entry3ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80
103NLEVIS-H: Preliminary entered services63ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80
104NMHITIS-H MM: Material-OU hit list5ORGIDIdentification Key of Organizational Unitnvarchar80
105NMKAOIS-H MM: Assignment of Material Catalog to OU2ORGIDIdentification Key of Organizational Unitnvarchar80
106NMSEOIS-H MM: Assignment of Material Catalog to OU2ORGIDIdentification Key of Organizational Unitnvarchar80
107NMSTORIS-H MM: Closet4ORGIDIdentification Key of Organizational Unitnvarchar80
108NSL2IS-H: Online error records of service statistics9ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80
109NSLFIS-H: Error records of service statistics9ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80
110NVBRKIS-H: Billing document header data58ORGIDIdentification Key of Organizational Unitnvarchar80
111NVBRPIS-H: Billing document item data55ORGIDID of Billing Organizational Unitnvarchar80
112TN23BIS-H: Workers' Comp. Fund Billing - OU-to-Person Assignment3ORGIDIdentification Key of Organizational Unitnvarchar80
113TN23VIS-H: Fixed Values for BDT Format (OU-Related)3ORGIDIdentification Key of Organizational Unitnvarchar80
114TNM03IS-H MM: Procurement Type Determination3ORGIDIdentification Key of Organizational Unitnvarchar80
115TNM04IS-H MM: Determine Materials for CO Reposting3ORGIDIdentification Key of Organizational Unitnvarchar80
TOPPatient Management
116N1ANFIS-H*MED: Request4ORGIDIdentification Key of Organizational Unitnvarchar80
117N1CORDTAVIS-H: Assignment of Possible Placers to an Order Type5ORGIDIS-H: Initiating Organizational Unitnvarchar80
118N1CORDTTRIS-H: Order Filler-to-Order Type Assignment4ORGIDIS-H: CORD/PREG: Filling OUnvarchar80
119N1ORGPAROU-related Customizing3ORGIDIdentification Key of Organizational Unitnvarchar80
120N1VKGIS-H: Item of Clinical Order (Preregistration)4ORGIDTreatment Unit in Preregistrationnvarchar80
121NATMIS-H/IS-H*MED: Time Slot Modification5ORGIDIS-H: Planned Organizational Unitnvarchar80
122NLEIIS-H: Services Performed4ORGIDIS-H: Org. Unit (for OU-Related Service Entry Only)nvarchar80
123NPOBIS-H: Planning Objects for Outpatient Clinic Scheduling3ORGIDIdentification Key of Organizational Unitnvarchar80
124NTPGPIS-H: Day program items (possible appointments)10ORGIDOrganizational Unit Assigned to Casenvarchar80
125TN40CIS-H: Alternative Scheduling Types3ORGIDIdentification Key of Organizational Unitnvarchar80
126TNKAVIS-H: Medical Record Management Parameters3ORGIDIdentification Key of Organizational Unitnvarchar80
127TNKAV1IS-H: Medical Records to Be Borrowed3ORGIDIdentification Key of Organizational Unitnvarchar80
TOPPayroll
128T7ROG1EE register - ER history24ORGIDVersion Number Componentnvarchar20
129T7ROG5EE register - ER history13ORGIDnvarchar480
TOPPerformance Assessment Workbench
130SLS_PARTICPAW - Participants9ORGIDPAW - Organizational assignment numbernvarchar450
TOPPlanning
131N1APPLANIS-H*MED: Plan5ORGIDIdentification Key of Organizational Unitnvarchar80
132N1WPLACE_PG_USZIS-H*MED: Display Variant - User Assignment9ORGIDIdentification Key of Organizational Unitnvarchar80
133N1WVIEW_PG_CLIS-H*MED: Planning Grid Settings of Planning Objects6ORGIDIdentification Key of Organizational Unitnvarchar80
134N1WVIEW_PG_DT_OUIS-H*MED: PG Org. Unit Setting for DT and PO View Type5ORGIDIdentification Key of Organizational Unitnvarchar80
135N1WVIEW_PG_OUIS-H*MED: Planning Grid Tab Page for OU View Type4ORGIDIdentification Key of Organizational Unitnvarchar80
136RN1SCHED_RESOURCIS-H*MED Resource Table3ORGIDIdentification Key of Organizational Unitnvarchar80
TOPPortfolio Management
137RPM_FIDATAFinancial Information21ORGIDRPM Organisation ID at Backend Systemnvarchar60
138RPM_PROJECT_COControlling Information about a project18ORGIDnvarchar60
TOPProcess Monitoring Infrastructure
139SSPIPDSPI: Process Definition for Business Process Tracking6ORGIDSPI: Process Type IDnvarchar320
140SSPIPVDSPI: Process Variant - Definition5ORGIDSPI: Process Type IDnvarchar320
141SSPISGDSPI: Signature Definition5ORGIDGlobal SPI: Agent Signaturenvarchar320
142SSPISGFLDSPI: Signature Payload Attributes5ORGIDGlobal SPI: Agent Signaturenvarchar320
TOPProduct Configurator
143COMM_CFGKBRuntime Version of SCE Knowledge Base21ORGIDOrganisation IDnvarchar320
TOPRadiology
144N1AETOUAi.s.h.med: RAD - Modality OU Assignment3ORGIDIdentification Key of Organizational Unitnvarchar80
TOPResourcen Management
145RMXTT_TRIAL_HDTrial: Header Data12ORGIDObject Typenvarchar20
TOPSAP Ambulatory Care Management
146TN1BFB_ORGIDBFB: Org.mittel-OE-Zuordnung4ORGIDIS-H: Org.einheit für Org.mittel-Zuordnungnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
147N2DWSWL_SUGGESTCriteria for Situation Template Proposal5ORGIDIdentification Key of Organizational Unitnvarchar80
148N2DWSWL_SUGGEST1Criteria for Proposal of Situation Template / Changes5ORGIDIdentification Key of Organizational Unitnvarchar80
149NORG_SPRTIS-H CH: Zuo Organisationseinheit => Sparte (TARMED)2ORGIDIS-H: identificatore dell'unità organizzativanvarchar80
150NWCHDIGAAVIS-H CH: Dignität - Arzt-Arzt-Vertretung3ORGIDIS-H: identificatore dell'unità organizzativanvarchar80
151NWCHLCOEAIS-HCO: Überleitungsinformationen11ORGIDIS-H: identificatore dell'unità organizzativanvarchar80
152NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)147ORGIDIS-H: unità organizzativa; solo per scopi interninvarchar80
153TNLMR2IS-H NL: LMR Afdelingscodes / LAZR Polikliniek- of locatie3ORGIDIS-H: Identificatie van de organisatorische eenheidnvarchar80
154TNWATOEARZTIS-H AT: Arztzuordnung zu OE2ORGIDIS-H: Identifikation der Organisationseinheitnvarchar80
155TNWCHDIOEGPIS-H CH: Zuordnung OE - Arzt für qual. / quant. Dignität3ORGIDIS-H: identificatore dell'unità organizzativanvarchar80
TOPVital Signs
156N1VPPOEZVital Signs OU Assignment3ORGIDIdentification Key of Organizational Unitnvarchar80