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

85 columns | Print definition?ERP 6.0  | RELTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPD_OR_INVHUBObject Link: Invoice/Invoice Template to Reference Document3RELTYPERelationship typenvarchar100
2BBPD_OR_PCOObject Link: Purchase Order/Order Confirmation3RELTYPERelationship typenvarchar100
3BBPD_OR_SUSPCOObject Link: SUS Purchase Order/Order Confirmation3RELTYPERelationship typenvarchar100
4BBPD_OVE_OBRELObject Linkage Purch. Doc. / Online Vendor Evaln3RELTYPERelationship typenvarchar100
5BTP_DL_UCRELBTP Use Case Relationships2RELTYPEBTP Relationship Types for Use Casesnvarchar40
6TER17Additional info2RELTYPESingle-Character Indicatornvarchar10
7TERMC1Terminology entries, definitions5RELTYPESingle-Character Indicatornvarchar10
8TERMC3Terminology entries, cross-references4RELTYPESingle-Character Indicatornvarchar10
TOPALE Integration Technology
9TEDNOLINKSIDoc: Negative List for IDoc/Application Object Link2RELTYPERelationship typenvarchar40
10TEDNOLINKSHISTIDoc: History of Changes in TEDNOLINKS2RELTYPERelationship typenvarchar40
TOPApplication Framework
11USMD0023Data Model: Relationships of Entity Types8RELTYPERelationship Typenvarchar10
TOPAudit Management
12PLMM_ACT_BRELRelationships in GOS Environment3RELTYPERelationship typenvarchar100
TOPBasic functions
13COMC_IL_UICustomizing Table for Relationship Type Interface1RELTYPERelationship Typenvarchar60
14COMC_LINK_PART01General Settings for Time-Dependent Relationship to Partner5RELTYPERelationship Typenvarchar60
15COMM_IL_PRDBPMaster Data of Relationship Type Partner5RELTYPERelationship Typenvarchar60
16COMM_IL_PRDBP_HHistorical Data for Relationship Type Partner6RELTYPERelationship Typenvarchar60
TOPCAD Integration
17CDESK_IPPE_RTYPECAD-Specific Relationship Type4RELTYPESort Stringnvarchar100
TOPCentral Part of Product Master
18COMC_PRWB_ILProduct Workbench: Assignment of Relship Type to Object Type3RELTYPERelationship Typenvarchar60
19COMM_IL_ACCESSMaster Data of Relationship Type Accessories5RELTYPERelationship Typenvarchar60
20COMM_IL_ACCESS_HHistorical Data of Relationship Type Accessories6RELTYPERelationship Typenvarchar60
21COMM_IL_COMPETAssignment of Own Products to Competitor Products5RELTYPERelationship Typenvarchar60
22COMM_IL_PRDCPNMaster Data of Relationship Type Customers5RELTYPERelationship Typenvarchar60
23COMM_IL_PRDCPN_HHistorical Data of Relationship Type Customers6RELTYPERelationship Typenvarchar60
24COMM_IL_PRDCTPMaster Data of Relationship Type Content Provider5RELTYPERelationship Typenvarchar60
25COMM_IL_PRDCTP_HHistorical Data of Relationship Type Content Provider6RELTYPERelationship Typenvarchar60
26COMM_IL_PRDMPNMaster Data of Relationship Type Manufacturer5RELTYPERelationship Typenvarchar60
27COMM_IL_PRDMPN_HHistorical Data of Relationship Type Manufacturer6RELTYPERelationship Typenvarchar60
28COMM_IL_PRDMRKMarketing Material5RELTYPERelationship Typenvarchar60
29COMM_IL_PRDMRK_HMarketing Material History6RELTYPERelationship Typenvarchar60
30COMM_IL_PRDVNDMaster Data of Relationship Type Vendors5RELTYPERelationship Typenvarchar60
31COMM_IL_PRDVND_HHistorical Data of Relationship Type Vendors6RELTYPERelationship Typenvarchar60
32COMM_IL_PROREFMaster Data of Relationship Type Reference Product5RELTYPERelationship Typenvarchar60
33COMM_IL_PROREF_HHistorical Data of Relationship Type Reference Product6RELTYPERelationship Typenvarchar60
34COMM_IL_SERVIMaster Data of Relationship Type Services5RELTYPERelationship Typenvarchar60
35COMM_IL_SERVI_HHistorical Data of Relationship Type Services6RELTYPERelationship Typenvarchar60
36COMM_IL_SPAREMaster Data of Relationship Type Spare Parts5RELTYPERelationship Typenvarchar60
37COMM_IL_SPARE_HHistorical Data of Relationship Type Spare Parts6RELTYPERelationship Typenvarchar60
38COMM_PRWBIL_USERUser Settings for Interlinkages in the Product Workbench4RELTYPERelationship Typenvarchar60
TOPClaims Management
39ICLPARTParticipants12RELTYPEType of Relationship to Policyholdernvarchar10
40ICSPARTParticipant in Claim12RELTYPEType of Relationship to Policyholdernvarchar10
41TICL014Type of Relationship to Policyholder2RELTYPEType of Relationship to Policyholdernvarchar10
42TICL014TType of Relationship to Policyholder Text3RELTYPEType of Relationship to Policyholdernvarchar10
TOPClass Builder
43SEOMETARELMeta relationship9RELTYPERelationship type between classesnvarchar10
TOPClassification System New
44COMM_IL_DSCOPEDefinition Scope5RELTYPERelationship Typenvarchar60
45COMM_IL_DSCOPE_HChange Graph for History Table6RELTYPERelationship Typenvarchar60
46COMM_IL_DTYPEEngineering Change Management: Change Graph5RELTYPERelationship Typenvarchar60
47COMM_IL_DTYPE_HChange Graph for History Table6RELTYPERelationship Typenvarchar60
48COMM_IL_SCPCHRDefinition Scope -> Characteristic5RELTYPERelationship Typenvarchar60
49COMM_IL_SCPCHR_HChange Graph for History Table6RELTYPERelationship Typenvarchar60
TOPCommunication Services Mail, Fax, SMS, Telephony
50SRBCSBRELRelationships in GOS Environment3RELTYPERelationship typenvarchar100
TOPCustomer Contact
51BCONTORObject Roles for Business Partner Contact4RELTYPERelationship Category for Relationship with BP Contactnvarchar40
TOPData Conversion
52DMC_RSRELDMC: Relations Between Sender/Recipient Structures15RELTYPEDMC: Sort of Relation Typenvarchar10
TOPDocument Management Framework
53SKWG_BRELTable for WCM Object Link Service3RELTYPERelationship typenvarchar100
TOPEngineering Change Management
54COMM_IL_ECMCHGEngineering Change Management: Change Graph5RELTYPERelationship Typenvarchar60
55COMM_IL_ECMCHG_HChange Graph for History Table6RELTYPERelationship Typenvarchar60
TOPEngineering Desktop
56EDESK_C_RELTYPECustomizing for Relationship Types in Engineering Desktop4RELTYPEType of Relationship Between CAD Documents (Sort Field)nvarchar100
TOPGeneral Object Relations
57MDOBLACLARelationship Types Used in Archiving Objects/Classes1RELTYPERelationship typenvarchar100
58MDOBLAOBJRelationship Types Used in Archiving Objects/Classes1RELTYPERelationship typenvarchar100
59MDOBLPROPModel Data: Attribute for Relationship Types1RELTYPERelationship typenvarchar100
60MDOBLRELModel Data: Relationship Types1RELTYPERelationship typenvarchar100
61MTOBLRELModel Data: Text for Relationship Types1RELTYPERelationship typenvarchar100
62ORBRELTYPObject relationship binary link type1RELTYPERelationship typenvarchar40
63ORTBRELTYPObject relationship of binary link types text1RELTYPERelationship typenvarchar40
64SFLIBRELDefault Table for Object Relationship Service3RELTYPERelationship typenvarchar100
65SROBLBRELDefault Table for Object Relationship Service3RELTYPERelationship typenvarchar100
TOPGeneric Object Services
66SRGBTBRELRelationships in GOS Environment3RELTYPERelationship typenvarchar100
TOPMaster Data Framework
67DML_RELTYPEMDF: Properties of Relationship Types2RELTYPERelationship Typenvarchar60
TOPMaterials Management
68/SAPPSPRO/RMOBRLObjekt Links in GOS Environmen forRecords Management3RELTYPERelationship typenvarchar100
69/SAPPSPRO/RMRLRelationships to records in Records Management3RELTYPERelationship typenvarchar100
TOPMedia Product
70JPTTITLERELObject Relationship Service: Title Relationships3RELTYPERelationship typenvarchar100
TOPProcess Monitoring Infrastructure
71SSPIPSRSPI: Process Step Relations6RELTYPESPI: Relationship Type IDnvarchar320
72SSPIRDSPI: Relation Definition1RELTYPESPI: Relationship Type IDnvarchar320
73SSPIRD_TSPI: Text Relation Definition1RELTYPESPI: Relationship Type IDnvarchar320
TOPRecipe Development
74/PLMB/RCP_RECRELDefault Table for Object Relationship Service3RELTYPERelationship typenvarchar100
75/PLMB/RCP_WBSRELDefault Table for Object Relationship Service3RELTYPERelationship typenvarchar100
TOPRelationships Between Objects with GUID Identification
76COMC_IL_ENQUEUELock Arguments for Objects in Interlinkages2RELTYPERelationship Typenvarchar60
77COMC_IL_STRUCStructures and Table Types of Relationship Types1RELTYPERelationship Typenvarchar60
78COMC_IL_TYPEDefinition of Relationship Types for Object Relationships1RELTYPERelationship Typenvarchar60
79COMC_IL_TYPE_SFWDefinition of Switch per Relationship Type and Product Type1RELTYPERelationship Typenvarchar60
80COMC_IL_TYPE_TRelationship Type Description1RELTYPERelationship Typenvarchar60
81COMC_IL_TYPE_TXTRelationship Type Description3RELTYPERelationship Typenvarchar60
TOPShared Service Center Framework
82SSCDOCSRRELRelationships in GOS Link to Service Request3RELTYPERelationship typenvarchar100
TOPTable Maintenance Tool
83SDMEDPDADME: Dialog Pool Component 'Dialog' (Area)10RELTYPEDME: Relationships in the Viewnvarchar10
84SDMEDPVODME: Dialog Pool Component 'View' (Objects)7RELTYPEDME: Relationships in the Viewnvarchar10
TOPWeb Service and SOAP - ABAP
85SPROXMSGRELLink Table XI Message-> Application Object3RELTYPERelationship typenvarchar100