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

59 columns | Print definition?ERP 6.0  | ACT_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/D_ACT_ROOTRoot7ACT_TYPEActivity Typenvarchar30
2CNVIMGIMG activities6ACT_TYPEType of activitynvarchar10
3EENRGY_CR_BRBrazil: Energy Credits Account7ACT_TYPEBrazil: Activity Typenvarchar20
4HRP5146Database Table for Infotype 514622ACT_TYPEActivity Typenvarchar40
5IDOM_CC_COMB_ACTAllowed activities for Forms-Final Tax Statemenet (Oman)3ACT_TYPEActivity Typenvarchar30
6IDTDOM_CC_ACTCompany code activities (Oman)4ACT_TYPEActivity Typenvarchar30
7IDTDOM_CC_ACTTCompany code activities description (Oman)4ACT_TYPEActivity Typenvarchar30
8PA0906HR Master Record: Infotype 090635ACT_TYPEHR IN PS: Proposed Action Typenvarchar20
9T77RCF_ACT_DEPTable for Dependency Between Activities2ACT_TYPEActivity Typenvarchar40
TOPBusiness Configuration Sets
10SCPRACPPBC Sets: Activation Logs (BC Set Names)7ACT_TYPENumbering for internal purposesint100
TOPClinical System
11N2DWSWL_ACTActivity9ACT_TYPEType of Activitynvarchar60
12N2GL_ACTpathways Activity11ACT_TYPEpathways Activity Typenvarchar60
13TN2GL_ACT_CUSTPathways: Settings for Activities2ACT_TYPEpathways Activity Typenvarchar60
TOPContract Billing
14BREBI_BILLP_T005Auto-Patch Configuration4ACT_TYPEActivity Categorynvarchar10
TOPControlling
15DPR_RATES_CALCCustomizing: Mapping of Cost/Revenue Rates for Roles14ACT_TYPEActivity Typenvarchar60
TOPE-Recruiting
16HRP5135DB Table for Infotype 513518ACT_TYPEActivity Typenvarchar40
17HRP5136DB Table for Infotype 513618ACT_TYPEActivity Typenvarchar40
18HRP5137DB Table for Infotype 513718ACT_TYPEActivity Typenvarchar40
19HRP5138DB Table for Infotype 513818ACT_TYPEActivity Typenvarchar40
20HRP5139DB Table for Infotype 513918ACT_TYPEActivity Typenvarchar40
21HRP5140DB Table for Infotype 514018ACT_TYPEActivity Typenvarchar40
22HRP5141DB Table for Infotype 514118ACT_TYPEActivity Typenvarchar40
23HRP5142DB Table for Infotype 514218ACT_TYPEActivity Typenvarchar40
24HRP5143Database Table for Infotype 514318ACT_TYPEActivity Typenvarchar40
25HRP5144Database Table for Infotype 514418ACT_TYPEActivity Typenvarchar40
26HRP5145Database Table for Infotype 514518ACT_TYPEActivity Typenvarchar40
27T77RCF_ACT2ANASMSemantic Meaning of Activities2ACT_TYPEActivity Typenvarchar40
28T77RCF_ACT2CRSNAssignment of Activities to Confirmations and Reasons2ACT_TYPEActivity Typenvarchar40
29T77RCF_ACT2OTYPEAssignment of Activity Type to HR Object Types2ACT_TYPEActivity Typenvarchar40
30T77RCF_ACT2PROCAssignment of Activity Types to Processes4ACT_TYPEActivity Typenvarchar40
31T77RCF_ACT2STATAssignment Activity Type Object Status2ACT_TYPEActivity Typenvarchar40
32T77RCF_ACTDEF_PLDefault Values for Activity Types2ACT_TYPEActivity Typenvarchar40
33T77RCF_ACTION_PLAssignment of Activities to Processes4ACT_TYPEActivity Typenvarchar40
34T77RCF_ACTTY2RPAssignment of Activities to Process Templates4ACT_TYPEActivity Typenvarchar40
35T77RCF_ACT_PROCOBSOLETE!!4ACT_TYPEnvarchar40
36T77RCF_ACT_TYPEActivity Types2ACT_TYPEActivity Typenvarchar40
37T77RCF_ACT_TYPETActivity Types3ACT_TYPEActivity Typenvarchar40
38T77RCF_COMM2ACTAssignment of Activity Type to Scenario3ACT_TYPEActivity Typenvarchar40
39T77RCF_QACAT2ACTAssignment of Qualification Category to Activity Type2ACT_TYPEActivity Typenvarchar40
40T77RCF_VNDR2ACTAssignment of Service Providers to Activity Types2ACT_TYPEActivity Typenvarchar40
41T77RCF_WL_ACTIDXIndex Table for Activities4ACT_TYPEActivity Typenvarchar40
TOPImplementation Guide
42CUSAHIMG attribute table: SAP data10ACT_TYPEType of activitynvarchar10
43CUS_ACTHCustomizing Activity - Header Data2ACT_TYPESingle-Character Indicatornvarchar10
TOPMaintenance Orders
44/MRSS/C_RMI_PSProject System data required for creating Request3ACT_TYPEProcess variantnvarchar10
TOPPersonal Object Worklist
45POWL_ACLPOWL Authorization table7ACT_TYPEActivity typetinyint30
TOPRecords and Case Management
46RMPSDISPOSITIONCharacteristics of Case Circulars4ACT_TYPEActivity typenvarchar10
47RMPSPATHORGTYPECustomizing of Object Types Addressed in Process Route4ACT_TYPEActivity Typenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
48N2BIEVENTBase Items: Customizing for Event Processing6ACT_TYPEType of Activitynvarchar60
49TN2EVACTEventing: Event and Possible Follow-Up Activity4ACT_TYPEType of Activitynvarchar60
50TNLGGZ_ACT_CODEGeisteskrankheit activität kode8ACT_TYPEGeisteskrankheit activität typenvarchar200
TOPSAP Records Management
51SRMACTIVTYActivities6ACT_TYPETask Typenvarchar10
52SRMPATHORGOrg. Objects that Can Be Addressed in Process Route4ACT_TYPETask Typenvarchar10
TOPStatistics
53TE789Trans. Stats Categories1ACT_TYPETransaction statistics categorynvarchar30
54TE789CControl for Updating Transaction Stats2ACT_TYPETransaction statistics categorynvarchar30
55TE789TTexts for Transaction Statistics Categs2ACT_TYPETransaction statistics categorynvarchar30
TOPStructures
56PSACL_TABTable for PS ACL Integration9ACT_TYPEPS ACL Authorization Typetinyint30
57PSHLP_NETWWL_DBNetwork ACL Worklist9ACT_TYPEPS ACL Authorization Typetinyint30
58PSHLP_PROJWL_DBProject Definition ACL Worklist9ACT_TYPEPS ACL Authorization Typetinyint30
59PSHLP_WBSWL_DBWBS Elements ACL Worklist9ACT_TYPEPS ACL Authorization Typetinyint30