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

66 columns | Print definition?ERP 6.0  | RELAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XLSO/MANDT_WITMWork item for mandatory trainings5RELATRelationship Between Objectsnvarchar30
2CNVHCM_I_OBJRELE-recruiting S-table - Object Relationships3RELATRelationship Between Objectsnvarchar30
3CNVHCM_I_RELMAPE-recruiting S-table - Object Relationships mapping table4RELATRelationship Between Objectsnvarchar30
4GRPC_UPG_HRP1001Backup Data6RELATRelationship Between Objectsnvarchar30
5T512VRPDSYS00 - Cross References11RELATRelationship Between Objectsnvarchar30
6T513KRPDSYS00 - Relations2RELATRelationship Between Objectsnvarchar30
7ZRP1001Infotype 1001 DB Table6RELATRelationship Between Objectsnvarchar30
8PIQDBAGR_ASSIGNMAppraisal: Appraised Object8RELATRelationship Between Objectsnvarchar30
9T7PIQFEETRIGInternal Fee Calculation Trigger3RELATRelationship Between Objectsnvarchar30
TOPBusiness Partner Enhancements for Financial Services
10BP2000BP: Business Partner - Business Partner - Relationship8RELATRelationship Typenvarchar40
11TPZ11BP: Business Partner - Relationship Type2RELATRelationship Typenvarchar40
12TPZ11TBP: Business Partner - Name of Relationship Type3RELATRelationship Typenvarchar40
TOPCommand and Support Relationships
13/ISDFPS/CORCustomizing: Relationship Types3RELATRelationship Between Objectsnvarchar30
14/ISDFPS/CORTCustomizing: Text Table for Basic Type4RELATRelationship Between Objectsnvarchar30
15/ISDFPS/FORCMDAttributes of Task Organization18RELATRelationship Between Objectsnvarchar30
16/ISDFPS/FORMNTAttributes of Maintenance Relationships18RELATRelationship Between Objectsnvarchar30
17/ISDFPS/FOROTHAttributes of Additional Relationships18RELATRelationship Between Objectsnvarchar30
18/ISDFPS/FORSUPAttributes of Supply Relationships18RELATRelationship Between Objectsnvarchar30
19/ISDFPS/ORCMDTask Organizations7RELATRelationship Between Objectsnvarchar30
20/ISDFPS/ORMNTMaintenance Relationships7RELATRelationship Between Objectsnvarchar30
21/ISDFPS/OROTHAdditional Relationships7RELATRelationship Between Objectsnvarchar30
22/ISDFPS/ORSUPSupply Relationships7RELATRelationship Between Objectsnvarchar30
23/ISDFPS/ORTOBTechnical Object Relationships (Maintenance)7RELATRelationship Between Objectsnvarchar30
TOPConsolidation
24TF374Fields Used in Validation Rules9RELATComparison operator for validationsnvarchar20
TOPDay-to-Day Activities
25LSOCRPNOTIFGRPCKNotification Groups: Allowed Activities4RELATRelationship Between Objectsnvarchar30
TOPForce Element
26/ISDFPS/CCTYPERCustomizing Table for Links3RELATRelationship Between Objectsnvarchar30
27/ISDFPS/FORTOBAttributes of Relationship to Technical Objects18RELATRelationship Between Objectsnvarchar30
TOPForms
28T59_PROTLRPDSYS-SE61 Conversion: Log Table Reference13RELATRelationship Between Objectsnvarchar30
TOPHR Administrative Services
29T5ASRFSCNPDRELPD object relations7RELATRelationship Between Objectsnvarchar30
TOPHR Information Systems
30HRSEL_TABFIELDSTable Name and Field Name of Selection13RELATRelationship Between Objectsnvarchar30
TOPKorea
31PA0557HR Master Record: Infotype 055726RELATRelationship with national contributornvarchar20
TOPLogistics - General
32CHBSRLNPossible relations for affected buildings2RELATRelationship Between Affected Buildingsnvarchar20
33CHBSRLNTText table for HBSRLN3RELATRelationship Between Affected Buildingsnvarchar20
34HBSRLSAffected Building List7RELATRelationship Between Affected Buildingsnvarchar20
TOPOrganizational Management
35HRP1001Infotype 1001 DB Table6RELATRelationship Between Objectsnvarchar30
36HRP1001_ARCHInfotype 1001: Inverse Relationship After Archiving6RELATRelationship Between Objectsnvarchar30
37HRS1200Standard Infotype 1200 (SAP) Rule Assignment for Task3RELATRelationship Type Between Standard Objectsnvarchar30
38T777BIRTHExrend relationship maintenance until birthday4RELATRelationship Between Objectsnvarchar30
39T777EAllowed Relationships3RELATRelationship Between Objectsnvarchar30
40T777VRelationship Texts3RELATRelationship Between Objectsnvarchar30
41T778VRelationships2RELATRelationship Between Objectsnvarchar30
42T77ALECOMBHR: Distributable Relationship Between Orig. and Replication2RELATRelationship Between Objectsnvarchar30
43T77ALERELAHR: Distributable Relationship Direction2RELATRelationship Between Objectsnvarchar30
44T77ARAdditional Data on Relationships2RELATRelationship Between Objectsnvarchar30
45T77AWDefinition of Evaluation Paths6RELATRelationship Between Objectsnvarchar30
46T77EVExternal Relationships4RELATRelationship Between Objectsnvarchar30
47T77SOStructurally-Dependent Object Types4RELATRelationship Between Objectsnvarchar30
48T77VARelationship Characteristics3RELATRelationship Between Objectsnvarchar30
49T787VText Table: Relationships for Standard Objects2RELATRelationship Type Between Standard Objectsnvarchar30
50T788ECheck Table for Allowed Standard Relationships2RELATRelationship Type Between Standard Objectsnvarchar30
51T788VCheck Table for Standard Relationships1RELATRelationship Type Between Standard Objectsnvarchar30
TOPPersonnel Administration
52T513VRPDSYS00 - Cross References12RELATRelationship Between Objectsnvarchar30
TOPPersonnel Categories
53/ISDFPS/USAGE_EVEvaluation of Organizational Structure by Usage Type6RELATRelationship Between Objectsnvarchar30
TOPRoom Reservation Management
54T77R4Check Path Individual Attendee - Attendee5RELATRelationship Between Objectsnvarchar30
TOPStaffing
55T777ACTIONActivities for special personnel actions3RELATRelationship Between Objectsnvarchar30
TOPStructures Workbench
56/ISDFPS/CFDPDA03Detail Area - Customizing of Generic Relationships Screen5RELATRelationship Between Objectsnvarchar30
57/ISDFPS/CFDPDA5Customizing of Title Element for Support Relationships4RELATRelationship Between Objectsnvarchar30
58/ISDFPS/CFDPDA5TText Table for Customizing Relationship Types5RELATRelationship Between Objectsnvarchar30
59/ISDFPS/CFDPSC3Relationship Group Assignment4RELATRelationship Between Objectsnvarchar30
60/ISDFPS/CFDPSC3TText Table Relationship Group Assignment4RELATRelationship Between Objectsnvarchar30
TOPTask Resource Management
61LETYHEntity hierarchy in the priority model1RELATEntity Relationshipnvarchar30
62LETYMEntity hierarchy: modes/weighting factor3RELATEntity Relationshipnvarchar30
TOPTraining and Event Management
63HRP1023Infotype 1023 DB table25RELATRelationship for instance object typenvarchar30
TOPTraining Management
64LSOLEARNCOMPLE-Signature of Learner7RELATRelationship Between Objectsnvarchar30
65LSOLEARNESIGNE-Signature of Learner7RELATRelationship Between Objectsnvarchar30
TOPTreasury
66TZV11Relationship category of partner-partner relationship5RELATRelationship Typenvarchar40