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

30 columns | Print definition?ERP 6.0  | RSIGN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XLSO/MANDT_WITMWork item for mandatory trainings4RSIGNRelationship Specificationnvarchar10
2CNV_10020_VLISTPValue lists5RSIGNABAP: ID: I/E (include/exclude values)nvarchar10
3GRPC_UPG_HRP1001Backup Data5RSIGNRelationship Specificationnvarchar10
4ZRP1001Infotype 1001 DB Table5RSIGNRelationship Specificationnvarchar10
5PIQDBAGR_ASSIGNMAppraisal: Appraised Object7RSIGNRelationship Specificationnvarchar10
TOPCommand and Support Relationships
6/ISDFPS/ORCMDTask Organizations6RSIGNRelationship Specificationnvarchar10
7/ISDFPS/ORMNTMaintenance Relationships6RSIGNRelationship Specificationnvarchar10
8/ISDFPS/OROTHAdditional Relationships6RSIGNRelationship Specificationnvarchar10
9/ISDFPS/ORSUPSupply Relationships6RSIGNRelationship Specificationnvarchar10
10/ISDFPS/ORTOBTechnical Object Relationships (Maintenance)6RSIGNRelationship Specificationnvarchar10
TOPHR Administrative Services
11T5ASRFSCNPDRELPD object relations6RSIGNRelationship Specificationnvarchar10
TOPHR Information Systems
12HRSEL_TABFIELDSTable Name and Field Name of Selection12RSIGNRelationship Specificationnvarchar10
TOPOrganizational Management
13HRP1001Infotype 1001 DB Table5RSIGNRelationship Specificationnvarchar10
14HRP1001_ARCHInfotype 1001: Inverse Relationship After Archiving5RSIGNRelationship Specificationnvarchar10
15T777BIRTHExrend relationship maintenance until birthday3RSIGNRelationship Specificationnvarchar10
16T777EAllowed Relationships5RSIGNRelationship Specificationnvarchar10
17T77AWDefinition of Evaluation Paths5RSIGNRelationship Specificationnvarchar10
18T77EVExternal Relationships3RSIGNRelationship Specificationnvarchar10
19T77SOStructurally-Dependent Object Types3RSIGNRelationship Specificationnvarchar10
20T77VARelationship Characteristics2RSIGNRelationship Specificationnvarchar10
TOPPayroll
21PA0935HR Master Record: Infotype 093565RSIGNNAP Registered date of signaturenvarchar80
22PB0935Applicant data infotype 0935 (model)65RSIGNNAP Registered date of signaturenvarchar80
TOPPersonnel Administration
23T7PL04Rules of wage types generation for reporting FUPLREP11RSIGNDebit/Credit Sign (+/-)nvarchar10
TOPPersonnel Categories
24/ISDFPS/USAGE_EVEvaluation of Organizational Structure by Usage Type7RSIGNRelationship Specificationnvarchar10
TOPRoom Reservation Management
25T77R4Check Path Individual Attendee - Attendee4RSIGNRelationship Specificationnvarchar10
TOPStaffing
26T777ACTIONActivities for special personnel actions2RSIGNType of Relationship (A or B)nvarchar10
TOPStructures Workbench
27/ISDFPS/CFDPDA03Detail Area - Customizing of Generic Relationships Screen4RSIGNRelationship Specificationnvarchar10
28/ISDFPS/CFDPDA5Customizing of Title Element for Support Relationships5RSIGNRelationship Specificationnvarchar10
29/ISDFPS/CFDPDA5TText Table for Customizing Relationship Types6RSIGNRelationship Specificationnvarchar10
TOPTraining and Event Management
30HRP1023Infotype 1023 DB table24RSIGNRelationship direction of instance object typenvarchar10