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

177 columns | Print definition?ERP 6.0  | PRIO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/M_AUT_ASGNMirror for Control table for automatic assignment creation10PRIOStatus Sequencenvarchar10
2/SLOAP/IMP_LOGImprovement message log4PRIOImprovment message priorisationnvarchar100
3/XLSO/ATTEND_DETAtendee Details.6PRIOnvarchar150
4/XPPM/EVA_C_KPIPPM CS EVA: KPI Customizing3PRIOKPI Prioritytinyint30
5BBP_CT_SLSCNDControl Condition Buffer for Sell Side Import3PRIOItem Numbernvarchar30
6CCGLC_TRCHKEHS: Rules for Print Requests of Process Orders5PRIORule Prioritynvarchar30
7CNVPERFDATATable for database performance46PRIO2 byte integer (signed)smallint50
8CNV_20100_IC_ACCAccounts per CoA and (I)tem (C)ategory assignment11PRIOControl which account/cost element has prioritynvarchar10
9CNV_20317_DATBIDetermination for date dependent tables14PRIOPriority Flagnvarchar10
10EHPRCC_ADRPFTCP: Contact function priority3PRIOPriority of the Corresponding Compositionnvarchar40
11EHPRCC_ADRPVWCP: Adress partner function priority3PRIOPriority of the Corresponding Compositionnvarchar40
12EHPRCC_EXPL_PCP: BOS-Explosion configuration composition priorities3PRIOPriority of the Corresponding Compositionnvarchar40
13N1CORDFCORD: Order Filler6PRIOPrioritydecimal30
14N1CORDFVCORD: Initiator5PRIOPrioritydecimal30
15ZSKCOUCATTCATTs for training7PRIOnvarchar20
16ZSKCOUCUSTCUSTOMINZING/ TRANSPORTS FOR training courses5PRIOAbhängigkeit Frontendnvarchar10
17T7PIQRULEMODULERule Modules5PRIOPrioritizationnvarchar40
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
18CRMPRIOCLOBSOLETE1PRIOCheck Results Management: Check Message Prioritynvarchar10
19CRMPRIOSOBSOLETE1PRIOCheck Results Management: Check Message Prioritynvarchar10
TOPASAP AcceleratedSAP
20SPERSQADBPersonalization Table for Review Question Filter Values5PRIOPrioritynvarchar10
21SQADB01REVAdditional Attributes for SAP Review Program Questions3PRIOPrioritynvarchar10
TOPBalanced Scorecard
22UMB_SC180Scorecard: Initiatives6PRIOPriority of Initiativenvarchar10
TOPBasic Functions
23BIW_EMMA_CASEDelta Queue for Process Statistics for Clarification Cases12PRIOClarification Case Prioritynvarchar10
24EMMAC_CCAT_CNDConditions for Case Determination or Priority3PRIOClarification Case Prioritynvarchar10
25EMMAC_CCAT_HDRClarification Case Categories10PRIOClarification Case Prioritynvarchar10
26EMMAC_CCAT_PRIExtended Case Determination and Priority3PRIOClarification Case Prioritynvarchar10
27EMMA_CASEClarification Case12PRIOClarification Case Prioritynvarchar10
TOPBasic Market Data
28/BA1/TF4_SEQUCEDefinition of Read Sequence4PRIOPrioritynvarchar40
TOPBasis Technology R3
29/ISDFPS/WF_RECEIWorkflow Recipient6PRIOPriority of a Work Itemnvarchar10
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
30TBEPRIPriority for Additional Components8PRIOPriority for Additional Componentstinyint30
TOPBelgium
31T5BRCDSRD - Conditions to assign Nature Day Code4PRIOPriority of a conditionnvarchar30
TOPBusiness Application Support
32CNVPERFDEMANDTable of performance requirements by scenario18PRIOFlag for specifying generator scenariosnvarchar10
TOPBusiness Information Collection
33UIORDResearch Request (SEM Business Information Collection)8PRIOPriority of a Research Request (SEM-BIC)nvarchar20
TOPCapacity Leveling
34TCY46Graphical object type selection: Decision steps4PRIODecision sequence in an E-statusnvarchar20
35TCY47Object display selection5PRIODecision sequence in an E-statusnvarchar20
36TCY61Line representation selection in table section4PRIODecision sequence in an E-statusnvarchar20
37TCY63Axis representation selection4PRIODecision sequence in an E-statusnvarchar20
38TCY65Curve representation selection4PRIODecision sequence in an E-statusnvarchar20
TOPClaims Management
39ICLDIPLDistribution Plan13PRIOPriority of Distribution Plannvarchar20
40ICLNOTEClaim Note22PRIOPriority of a Notenvarchar10
41ICL_BENSPLIT_ITMBenefit Split Item (One-Time)10PRIOPriority of Benefit Splitnvarchar30
42ICL_BENSPPER_ITMBenefit Split Item (Periodic)10PRIOPriority of Benefit Splitnvarchar30
43ICSDIPLDistribution Plan (Shadow Table)13PRIOPriority of Distribution Plannvarchar20
44ICSNOTENote22PRIOPriority of a Notenvarchar10
45ICS_BENSPLIT_ITMBenefit Split Item (Shadow Table)10PRIOPriority of Benefit Splitnvarchar30
46ICS_BENSPPER_ITMBenefit Split Item (Shadow Table)10PRIOPriority of Benefit Splitnvarchar30
TOPClinical System
47N1AUFGAIS-H*MED: Task3PRIOPrioritydecimal30
48N1CORDTSIS-H: Service Hit List Clin.Ord.Type - Order Filler Assgmt9PRIOPriority Service Hit List COrd Type - Admiss. Assignmentdecimal30
49N1CYGROUPi.s.h.med: Group Determination for Cycles3PRIOPrioritynvarchar30
50N1FATTRIS-H*MED: Clinical Order: Field Attributes9PRIOCount parametersnvarchar40
51N1KPLIS-H*MED: VBUND: Leistungsangebot Kommunikationspartner7PRIOPrioritätdecimal30
52N1KPOIS-H*MED: VBUND: Zordnung OE - Kommunikationspartner8PRIOPrioritätdecimal30
53N1LAGRGIS-H*MED: Position types12PRIOPrioritydecimal30
54N1MEDS_USRFAVMedication: User Favorites6PRIOPrioritydecimal30
55N1MEOEZIS-H*MED: Medication - OU Assignment8PRIOPriority for Medicationnvarchar30
56N1YLEIIS-H*MED: Requestable services9PRIOPrioritydecimal30
57N2DOIS-H*MED: Table of doc. category to org. unit assignments19PRIOSequence of Doc. Category in Assignment (Profile)nvarchar20
58N2MV_CONVTFormat Conversions4PRIOPriority of Converter BAdInvarchar20
59NWPLACE_DTM_POIS-H*Med: Aspects in Patient Organizer7PRIOPriority of Work Environmentnvarchar30
60TN1SIGNSi.s.h.med: Patient Record, Indicators14PRIOi.s.h.med: Patient Record, Prioritynvarchar30
TOPCommunication Services Mail, Fax, SMS, Telephony
61SPH_USTOATSAPphone: Assign address data areas to user3PRIOSAPphone: Priority for table searchnvarchar10
62SRIRSCENATBCOM Internal Router: Scenario Attributes6PRIORouting: Priority of a Routing Attributenvarchar20
63SRSATTRIBRouting Server: Attribute Table4PRIORouting: Priority of a Routing Attributenvarchar20
64SRSATTRIBTRouting Server: Attribute Table Temp4PRIORouting: Priority of a Routing Attributenvarchar20
TOPCustomizing Tools Techniques
65TCTM_AT_PRContext Object Type Attribute Prorities3PRIOPrioritynvarchar30
66TCTM_AV_PRContext Management Attribute Valuee Priorities4PRIOPrioritynvarchar30
67TCTM_LCVALValidity Limits and Component Priorities8PRIOPrioritynvarchar30
68TCTM_LPVALValidity Limits and Product Priorities6PRIOPrioritynvarchar30
TOPEnergy Data Management
69EFORMULASTATUSEDM Status for Status Group (DB Table)4PRIOPriority of status in status groupnvarchar10
70ERTPIFACECOMPComponents for RTP Interface5PRIOPriority of RTP componentnvarchar20
71TEDM_STAT_CUST_1Priority for Value-Related Status for Longer Interval Lngths3PRIOStatus Priority When Converting Interval Lengthsnvarchar20
72TEDM_STAT_CUST_2Priority for Cond.-Related Status for Longer Interval Lngths3PRIOStatus Priority When Converting Interval Lengthsnvarchar20
73TEDM_STAT_CUST_3Priority for User Status for Longer Interval Lengths3PRIOStatus Priority When Converting Interval Lengthsnvarchar20
TOPEngineering Change Management
74ECM_REQData for Engineering Change Request13PRIOPriority of Changenvarchar120
TOPEnvironment, Health and Safety
75/TDAG/CPC_ADRPFTCP: Contact function priority3PRIOPriority of the Corresponding Compositionnvarchar40
76/TDAG/CPC_ADRPVWCP: Adress partner function priority3PRIOPriority of the Corresponding Compositionnvarchar40
77/TDAG/CPC_EXPL_PCP: BOS-Explosion configuration composition priorities3PRIOPriority of the Corresponding Compositionnvarchar40
78/TDAG/CPC_REA02CP: Response Code/ Result Determination - Priority3PRIOnvarchar20
79/TDAG/CPT_TASKHHeader data for tasks18PRIOTask Prioritynvarchar10
80/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv18PRIOTask Prioritynvarchar10
81/TDAG/CPT_TASKICP: Positionsdaten für Aufgaben6PRIOTask Prioritynvarchar10
82/TDAG/CPT_TASKIACP: Positionsdaten für Aufgaben / Archiv6PRIOTask Prioritynvarchar10
83/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten15PRIOTask Prioritynvarchar10
84/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv15PRIOTask Prioritynvarchar10
85/TDAG/CPT_TRCKIObsolete - CP: Tracker - Positionsdaten6PRIOTask Prioritynvarchar10
86/TDAG/CPT_TRCKIAObsolete - CP: Tracker - Positionsdaten / Archiv6PRIOTask Prioritynvarchar10
TOPForce Element
87/ISDFPS/CPRIOOrganizational Priorities (Obsolete --> New Table: PORG)2PRIOOrganizational Priority (Obsolete)nvarchar10
88/ISDFPS/CPRIOTOrg. Priorities - Txt Tab. (Obsolete --> New Table PORGTX_T)3PRIOOrganizational Priority (Obsolete)nvarchar10
89/ISDFPS/FORCEForce Element (Database)24PRIOOrganizational Prioritynvarchar10
TOPGraphic
90TGPMGraphic control: Platform-specific product control3PRIOPriority for product selectionnvarchar30
91TGPMTProduct management for graphic control: Name4PRIOPriority for product selectionnvarchar30
92TGPNGraphic control: Platform-specific product control3PRIOPriority for product selectionnvarchar30
93TGPNTName in product management for graphic control4PRIOPriority for product selectionnvarchar30
TOPHazardous Substance Management
94HSMC_021EHS: Customizing Priority of Validity Area per Cntry/Region5PRIOPriority for Hazardous Substance Fillingnvarchar20
TOPIncentive and Commission Management ICM
95TCACS_PATCH_INFODelivered Versions and Patches (Info Documents)3PRIOSequential Numbernvarchar40
96TCACS_PATCH_INFTDelivered Versions and Patches (Info Documents)3PRIOSequential Numbernvarchar40
TOPIndustry Solution Catch Weight Management
97CON_FIN_WQ_HDRHeader Table for Transactions in Work Queue13PRIOPrioritynvarchar10
TOPIntegrated Product and Process Engineering
98PAMODDDuration of an Activity-Resource Relationship14PRIOPriority for Mode Selectionnvarchar10
99PVCMPRPVS Variant (CMP): Supplement to the Selection Criteria6PRIOPriority of Object Dependenciesnvarchar20
100PVCOLPVS Variant (COL): Color Attributes7PRIOPriority of Object Dependenciesnvarchar20
TOPIntegration Builder - Configuration
101SXI_SWCV_LAYERLayer of Software Component Versions3PRIOPriorityint100
TOPKnowledge Warehouse
102IWEXDONEKEn: Html Export History20PRIOPrioritynvarchar10
103IWEXRULESKEn: Html Export Dispatching Rules10PRIOPrioritynvarchar10
104IWEXTODOKEn: Html Export Request List20PRIOPrioritynvarchar10
TOPLine Maintenance
105/ISDFPS/CLMSTICCustomizing Table for Assigning Icons to the User Status6PRIOIcon Priorityint100
106/ISDFPS/LMEQEXTEnhancements to the Equipment Tables for Line Maintenance8PRIOUsage Preference Prioritynvarchar10
TOPMain Process
107/VSO/M_I_STACKInput Data: Overstackability (Vehicle Space Optimization)5PRIOPriority of Overstackability (VSO)nvarchar10
108/VSO/M_STACKDEFOverstackability Def. Package Type for VSO5PRIOPriority of Overstackability (VSO)nvarchar10
TOPMaintenance Orders
109/MRSS/C_AUT_ASGNControl table for automatic assignment creation8PRIOStatus Sequencenvarchar10
TOPManagement of Internal Controls
110FOPCSIGNOFF_ISDeactivate Issue Types for Sign-Off5PRIOIssue Prioritynvarchar10
TOPMaster Data
111ENOTEAllocation of Object to Note for Field Service12PRIOPriority of note to field servicenvarchar10
TOPMaterials Management
112/ISDFPS/HSMC_HSLPrioritization of Ratings (Hazardous Substance List)2PRIOPrioritynvarchar20
113/ISDFPS/PREQRequirement Priorities (Obsolete --> New Table: PREQ)4PRIOOrganizational Priority (Obsolete)nvarchar10
114/ISDFPS/PRILOCPrioritization of StorLocs (Obsolete --> New Table: PRILOC)4PRIOOrganizational Priority (Obsolete)nvarchar10
TOPMedia Sales and Distribution
115/NAM/JKDISPATCHDispatching object23PRIODispatching Prioritynvarchar10
116/NAM/JKDISPVERSDispatching Object version7PRIODispatching Prioritynvarchar10
117/NAM/TJKDISPPRDispatching priority2PRIODispatching Prioritynvarchar10
118/NAM/TJKDISPPRTDispatching priority description3PRIODispatching Prioritynvarchar10
TOPMerchandise and Assortment Planning
119TWISPC_FBATTRBRetail Planning: Function Module for Reading Attributes2PRIORetail Planung: Prioritynvarchar10
120TWISPC_FBMDHIEFunction Module for Creating Master Data Hierarchy2PRIORetail Planung: Prioritynvarchar10
TOPMeter Reading
121TE580NDynamic Notes to Field Service5PRIOPriority of note to field servicenvarchar10
TOPMonitoring
122ALPFASSIGNAlert: Assignment of Reorg/Coll Schema to MTE (New Version)10PRIOAlert: integer used in performance DBint100
TOPNetWeaver Enterprise Search
123ESH_RL_SYS_VERVerification of System Releases4PRIOPrionvarchar40
TOPNew Zealand
124PA0310Superannuation NZ49PRIOSalary Sacrifice Prioritytinyint30
TOPObject Dependencies
125CURSPATPMS Master Data: Patterns (of End Points)9PRIOPriority in the PMSsmallint50
TOPOverhead Cost Orders
126TKB10SLBStrategy Sequences for Automatic Generation of SETC - Detail4PRIOStrategy prioritynvarchar20
TOPPatient Management
127N1CORDTAVIS-H: Assignment of Possible Placers to an Order Type9PRIOIs-H: CORD/PREG: Priority of CORD Type-to-Initiator Asgmtdecimal30
128NPRTLIS-H*MED: Preregistration Type - Service Hit List9PRIOPrioritydecimal30
129NPRTVIS-H: Preregistration Type Available for Initiating OUs6PRIOIS-H: Prereg.- Priority of Prereg. Type for Initiating OUdecimal30
130NWPUSZWork Environment-to-User (Role) Assignment6PRIOPriority of Work Environmentnvarchar30
131TN2FLAGIs-H*MED: Flags (special indicators) for documents9PRIOPriority Sequence Order - 3 Figurenvarchar30
TOPPayroll
132T5HPBS64Controlling leave quotas15PRIODeduction sequence of leave quotanvarchar20
TOPPayroll General Parts
133T51P6Characteristics of WTypes for Arrears Processing6PRIOPriority for deductions during arrears processingnvarchar10
TOPPlanning
134RN1SCHED_APPOINTIS-H*MED Appointment Table9PRIOPrioritynvarchar30
135RN1SCHED_PATTIS-H*MED: Pattern for Planning Grid (No Use!!!)4PRIOPrioritynvarchar30
136RN1SCHED_SPECTIMIS-H*MED Special Time Table7PRIOPrioritynvarchar30
TOPPlant Maintenance
137EAMS_CVBSYSSTATSystem Status and Icon Combination of Objects6PRIOPrioritize Status of an Objectint100
138EAMS_CVBSYSTSSystem Status and Priority Combination of Objects4PRIOPrioritize Status of an Objectint100
139EAMS_CVBUSSTSUser Status and Icon Combination of Objects8PRIOPrioritize Status of an Objectint100
TOPPrint and Output Management
140TSP0LSpool events22PRIOPriority of a request as NUMCnvarchar20
TOPProcess Controls
141GRPCSIGNOFF_ISDeactivate Issue Types for Sign-Off5PRIOIssue Prioritynvarchar10
TOPProduct Configurator
142COMM_CFGDEPBasic Data for Dependencies (including Nets)10PRIOPriorityint100
143COMM_CFGDEPPATPattern10PRIOPriorityint100
TOPProduct Safety
144CCRCC_CDEHS: Rules for Country Determination4PRIORule Priority for SVT Country Determinationnvarchar40
145CVCHSEHS: Assignment table for shipping elements7PRIOPartial key: sort sequence of objectsnvarchar40
146CVCRCEHS: Assignment table for communication5PRIOPartial key: sort sequence of objectsnvarchar40
147ESTLUEHS: Report Variant Rating17PRIORating Prioritynvarchar40
148TCGREL01EHS: Worklist for Inheritance Background Process4PRIOInteger1 - Field (Internal Use)tinyint30
TOPPurchasing
149WRFT_BUDG_TYPEBudget Type15PRIOPrioritization of Budget Value Cannot Be Uniquely Determinednvarchar20
TOPQuality Management
150ZPH_REQAnforderungen8PRIOAnforderungen Prioritätnvarchar50
TOPRemaining Beverage - Obsolete Objects
151/BEV1/TSSDBTPRCategory Reference for Main Table Statistics Telephone Sales12PRIOPriority for Line Categoriesnvarchar30
152/BEV1/TSZTYMAVTTypes/Material Allocation Sales Area7PRIOPriority for Line Categoriesnvarchar30
TOPReuse Services for Country Development
153T799L13Day Type and Priority for Adjustment in Divisor 308PRIOPriority of Day Type in Divisor 30nvarchar30
TOPSales and Distribution
154SCEDEPPATPattern of Dependency8PRIO2-byte integersmallint50
TOPSAP Ambulatory Care Management
155TNHCO_COLORDHCO: Definition Coll. Orders for Outpat.Case-Based Orders4PRIOPriority Collective Orders for Outpatient Case-Based Ordersnvarchar50
TOPSAP Business Workflow
156SWFSLSDEADLDeadline Service: Deadline Table7PRIOSLS: Priority of Deadlinenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
157TNWCHFACHIS-H CH: ANALYSE Fachbereiche - Codes6PRIOIS-H CH: Priorität der zugeordneten Fachabteilungnvarchar20
TOPSAP Utilities
158TEAMI_OPSTATEOperational State of Advanced Meter11PRIOPriority of Operational State Request for Advanced Meternvarchar10
159TEAMI_OPSTATE_PRPriority of Operational State Request of Advanced Meter3PRIOPriority of Operational State Request for Advanced Meternvarchar10
TOPStructures Workbench
160/ISDFPS/FDPWFSTWorkflow Status for Cross-System Material Planning3PRIOPriority for Workflow Status (Cross-System Material Plng)nvarchar20
TOPTraining Management
161HRP5045DB Table for Infotype 504526PRIOSort Sequencetinyint30
162HRP5046DB Table for Infotype 504630PRIOSort Sequencetinyint30
TOPTransaction Manager
163TCORITS_CHK_FLDCheck Framework: Fields5PRIOPriority of a checknvarchar10
164TCORITS_CHK_RULECheck Framework: Validation rules3PRIOPriority of a checknvarchar10
165TCORITS_CHK_SEQCheck Framework: Sequences3PRIOPriority of a checknvarchar10
TOPTranslation Tools
166LANGGRUTranslation Object Groups3PRIOTranslation environment 2-digit numbernvarchar20
167LXE_CSNObject Lists4PRIOSingle-Character Indicatornvarchar10
168LXE_CSN_HDNotes18PRIOPriority of an SAP Notenvarchar20
169LXE_LGRUTranslation Object Groups3PRIOLXE 2-Digit Numericalnvarchar20
TOPTravel Planning
170TA22RSASTART: Train Attributes4PRIOMessage priority (general)smallint50
TOPTREX Search Engine Service
171T002_SUBSTITUTEPreferred Language Sequence for Presentation of Objects2PRIOPriority in Preferred Language Sequencenvarchar30
TOPVariant Configuration
172CUCOAdditional Data for Configurable Objects113PRIOConfiguration profile prioritynvarchar20
TOPVisual Enterprise Generator
173VEG_JOBLOGJob Ids of business objects with status12PRIOPriority for Executionnvarchar20
174VEG_REGRegistration entries for conversion4PRIOPriority for Executionnvarchar20
TOPWorkforce Management Core
175/SAPAPO/LRPRTSATAttributes for a Requirement's Time Data15PRIONatural Numberint100
176/SAPAPO/LRPSTSATAttributes for Resource's Time Data15PRIONatural Numberint100
177/SAPAPO/LRPTSATTObsolete: Attributes for Time Data15PRIONatural Numberint100