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

73 columns | Print definition?ERP 6.0  | OBJCT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/UST12Copy of table UST12 (used in Security Optimization Services)3OBJCTAuthorization Objectnvarchar100
2/SMD/MD_____00MZSID-Tabelle fuer Authorization object3OBJCTAuthorization Objectnvarchar100
3/SMD/MD_____00R1SID-Tabelle fuer Authorization object3OBJCTAuthorization Objectnvarchar100
4T090WShort Texts for Depreciation Trace3OBJCTText object for depreciation tracenvarchar300
5TCA13Layouts of object overview versions3OBJCTObject of a task listnvarchar10
6TCA18Objects in routings2OBJCTObject of a task listnvarchar10
7TCA19Language-dependent texts for TCA18: Objects for routings3OBJCTObject of a task listnvarchar10
8TCA33Verification / input facility in task lists2OBJCTObject of a task listnvarchar10
9TFAVFI: Worklists2OBJCTObject for Worklistnvarchar50
10TFAVTWorklist Names3OBJCTObject for Worklistnvarchar50
11TFAVWFI: Work list values2OBJCTObject for Worklistnvarchar50
12TKEB3CO-PA: Table for managing segment authorizations5OBJCTAuthorization Objectnvarchar100
13TOBJCClass assignment of authorization objects1OBJCTAuthorization Objectnvarchar100
14TPR_EXCLBerechtigungsobjektausschlusstabelle für generierte Rollen2OBJCTBerechtigungsobjektnvarchar100
15TR01Archiving basis table3OBJCTArchiving Objectnvarchar100
16TR01TBase Table Reorganization: Texts4OBJCTArchiving Objectnvarchar100
TOPABAP Authorization and Role Management
17TOBJVORSAP_NEW Release-Dependent Data for Authorization Objects1OBJCTAuthorization Objectnvarchar100
18TOBJVORDATField Values for SAP_NEW Authorization Objects1OBJCTAuthorization Objectnvarchar100
19TOBJVORFLGFlags for Authorization Objects1OBJCTAuthorization Objectnvarchar100
20TOBJ_CDObjects that were disabled4OBJCTAuthorization Objectnvarchar100
21TOBJ_OFFObjects that were disabled2OBJCTAuthorization Objectnvarchar100
22TOBJ_SAVObjects that were disabled2OBJCTAuthorization Objectnvarchar100
23TOBJ_TPLAuthorization objects for a global template2OBJCTAuthorization Objectnvarchar100
TOPABAP Runtime Environment
24TSTCAValues for transaction code authorizations2OBJCTAuthorization Objectnvarchar100
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
25CRM_CATLCATT: Log Process Data9OBJCTObject for functionnvarchar300
TOPAuthorizations and Access Control Context
26/PLMB/AUTH_BO_AOAuthority objects for BOs which are used in PLM CORE3OBJCTAuthorization Objectnvarchar100
TOPAuto-ID Backend Integration
27AIDARCIObsolete: Auto-ID Infrastructure Archiving Items4OBJCTAuto-ID Infrastructure Objectnvarchar360
TOPBasic Data
28TNOBJIS-H: Objects for Client Reset Program1OBJCTIS-H: Use of Table Entrynvarchar60
TOPBusiness Package for Manager Self-Service FI
29FPB_AUTHSAuthorizations for FG FPB_Berechtigungen4OBJCTAuthorization Objectnvarchar100
30FPB_GEN_PROF_LOGLog Entries for Generating Authorizations2OBJCTAuthorization Objectnvarchar100
31FPB_VALUESAuthorizations for FG FPB_Berechtigungen2OBJCTAuthorization Objectnvarchar100
TOPCATT Computer Aided Test Tool
32CATLCATT: Log Process Data8OBJCTObject for functionnvarchar300
TOPFinancial Accounting
33TFAVAFI: Details of Automatically Generated Worklists2OBJCTObject for Worklistnvarchar50
TOPMobile Applications
34/ISDFPS/MECAA010Local Authorization (Item) for Logging8OBJCTAuthorization Objectnvarchar100
TOPNetWeaver Enterprise Search
35ESH_AU_AUTH_DATAESH Authorization: User authorization data3OBJCTAuthorization Objectnvarchar100
36ESH_AU_USR_AUTHESH Authorization: Authorizations for backend user4OBJCTAuthorization Objectnvarchar100
TOPOLAP Technology
37RSEC_ODYNBuffer for Migration Data: Authorization Objects1OBJCTAuthorization Objectnvarchar100
38RSEC_OMIGIntermediate Storage for Migration: User1OBJCTAuthorization Objectnvarchar100
39RSSTOBJDIRManagement Table for Authorization Objects2OBJCTAuthorization Objectnvarchar100
TOPPatient Accounting
40NICPIS-H: Surgical Procedure Codes Performed24OBJCTIS-H: Object that Created the Procedurenvarchar100
41NICP2IS-H: INACTIVE since 4.71 - DO NOT USE !24OBJCTIS-H: Object that Created the Procedurenvarchar100
TOPPatient Management
42NLEIIS-H: Services Performed70OBJCTIS-H: Object that generated servicesnvarchar100
TOPPayroll General Parts
43PA0128HR Master Record: Infotype 0128 (Notifications)25OBJCTTexts: Application Objectnvarchar100
TOPProduction ResourcesTools
44AFFHPRT assignment data for the work order16OBJCTObject of a task listnvarchar10
TOPRemaining Beverage - Obsolete Objects
45/BEV3/CHCHECKPNTCheck Points for Authorization Check4OBJCTAuthorization Objectnvarchar100
TOPRouting
46PLFHTask list - production resources/tools17OBJCTObject of a task listnvarchar10
47TCA71Task lists: Verification of function modules1OBJCTObject of a task listnvarchar10
48TCA72Task lists: Verification level of the function modules2OBJCTObject of a task listnvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
49NLDBC_005NL-DBC: DBC Tabelle44OBJCTIS-H NL: Object waardoor DBC's zijn gegenereerdnvarchar100
50NLDBC_005_LOGNL-DBC: DBC log Tabelle32OBJCTIS-H NL: Object waardoor DBC's zijn gegenereerdnvarchar100
51NLDBC_006_LOGDBC Beziehung log Tabelle12OBJCTIS-H NL: Objekt, durch das DBC's erzeugt wurdennvarchar100
52NLGGZ_CARE_LOGDBC Beziehung log Tabelle13OBJCTIS-H NL: Objekt, durch das DBC's erzeugt wurdennvarchar100
53NLGGZ_CODEGeisteskrankheit DBC kode34OBJCTIS-H NL: Objekt, durch das DBC's erzeugt wurdennvarchar100
54NLGGZ_CODE_DIAGNGeisteskranheit GGZ zusatz diagnose15OBJCTIS-H NL: Objekt, durch das DBC's erzeugt wurdennvarchar100
55NLGGZ_CODE_LOGGeisteskrankheit DBC protokoltabelle34OBJCTIS-H NL: Objekt, durch das DBC's erzeugt wurdennvarchar100
56NLGGZ_DIAG_LOGGeisteskrankheit DBC zusatz diagnosen protkoltabelle15OBJCTIS-H NL: Objekt, durch das DBC's erzeugt wurdennvarchar100
57NLGGZ_DISGeisteskrankheit DIS protokolle16OBJCTIS-H NL: Objekt, durch das DBC's erzeugt wurdennvarchar100
58NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)105OBJCTIS-H: oggetto che ha creato le prestazioninvarchar100
TOPSets
59SETUSE_BERSet Use in Authorizations (Area of Responsibility)3OBJCTAuthorization Objectnvarchar100
TOPSimulation
60VSAFFH_CNVersion: PRT allocation to work order17OBJCTObject of a task listnvarchar10
TOPTask Resource Management
61LRTQAResource type and resource element qualifications4OBJCTObject IDnvarchar200
62LXRFNRequest cross-reference3OBJCTObject Identifiernvarchar220
TOPUser and Authorization Management
63TOBJAuthorization Objects1OBJCTAuthorization Objectnvarchar100
64TSTCA_CValues for Transaction Code Authorizations2OBJCTAuthorization Objectnvarchar100
65USCRAUTHAuthorization Data for Critical Authorizations4OBJCTAuthorization Objectnvarchar100
66USH12Change history for authorization values2OBJCTAuthorization Objectnvarchar100
67USH12_ARC_TMPChange History for Authorizations: Last Archive Entries2OBJCTAuthorization Objectnvarchar100
68USR07Object/values of last authorization check that failed4OBJCTAuthorization Objectnvarchar100
69USR12User Master Authorization Values2OBJCTAuthorization Objectnvarchar100
70USR13Short Texts for Authorizations3OBJCTAuthorization Objectnvarchar100
71USRBF2User buffer content for fast RFC logon - new3OBJCTAuthorization Objectnvarchar100
72UST10SUser master: Single profiles4OBJCTAuthorization Objectnvarchar100
73UST12User master: Authorizations2OBJCTAuthorization Objectnvarchar100