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

34 columns | Print definition?ERP 6.0  | ENTITY_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBO_ESSB: OData Entity Sets5ENTITY_TYPEService Builder: Node UUIDvarbinary160
2/IWFND/I_MED_ADFAnnotation definition5ENTITY_TYPEmeta model entity typenvarchar10
3/IWFND/I_MED_TGSemantic Tags for entities3ENTITY_TYPEmeta model entity typenvarchar10
4/IWFND/I_MED_VEHversionable entity headtable for meta model4ENTITY_TYPEmeta model entity typenvarchar10
5/IWFND/L_MET_COLMetering Data Collector9ENTITY_TYPEname of an external modelnvarchar600
6CLB2C_ENT_TYPECollaboration: Entity Types of Service Provider1ENTITY_TYPECollaboration: Entity Typenvarchar10
7CLB2C_ENT_TYPE_TCollaboration: Entity Types of Service Provider2ENTITY_TYPECollaboration: Entity Typenvarchar10
8CLB2D_BO_ENTITYCollaboration: Business Object - Entity Assignment4ENTITY_TYPECollaboration: Entity Typenvarchar10
9CLBC_ENTITY_TYPECollaboration: Entity Types of Service Provider1ENTITY_TYPECollaboration: Entity Typenvarchar10
10CLBC_ENTITY_TYPTCollaboration: Entity Types of Service Provider2ENTITY_TYPECollaboration: Entity Typenvarchar10
11PSSCC_DBA_ETTDecision Basis: Entity Type1ENTITY_TYPEDecision Basis Entity Typenvarchar100
12PSSCC_DBA_ETT_TDecision Basis: Entity Type Text Table1ENTITY_TYPEDecision Basis Entity Typenvarchar100
13PSSCC_DBA_MDL_ETDecision Basis: Assignment of Entity Type to DBA Model3ENTITY_TYPEDecision Basis Entity Typenvarchar100
14SADL_GTK_LOGLogging table for SADL Generation Toolkit12ENTITY_TYPEBusiness Entity Sourcenvarchar2550
15SMI_ENTITY_TYPESList of Entity Types for Sentiment Analysis2ENTITY_TYPEEntity typenvarchar750
16SMI_ENTITY_TYPETEntity Type Texts3ENTITY_TYPEEntity typenvarchar750
17SMI_ETYPES_E_ENTList of Entitys to be excluded by Sententiment Assignment2ENTITY_TYPEEntity typenvarchar750
18SMI_VOICE_CUSTAssignment of Sentiment to an Entity on Post Level4ENTITY_TYPEEntity typenvarchar750
19SRAL_ELOGErrors and Warnings for RAL25ENTITY_TYPERAL: Type of an entity in the administrative lognvarchar10
20USMD1222Change request change list3ENTITY_TYPEEntity Typenvarchar90
TOPDocuments
21DPR_COLL_LINKDPR Application Object Link - Collaboration3ENTITY_TYPEObject Type in Project Planningnvarchar30
22DPR_DOCUMENTProject Management Application Object Link - EDMS Document4ENTITY_TYPEObject Type in Project Planningnvarchar30
TOPPortfolio Management
23/RPM/DOCUMENTRPM Application Object Link - EDMS Document4ENTITY_TYPEObject Type in Project Planningnvarchar30
24RPM_DOCUMENT_CDDocument - Pseudo table for change documents4ENTITY_TYPEObject Type in Project Planningnvarchar30
TOPResources
25DPR_BUPA_FAVOList of Favorites (Business Partner)7ENTITY_TYPEObject Type in Project Planningnvarchar30
26DPR_ENTITY_LINKRole Assignments9ENTITY_TYPEObject Type in Project Planningnvarchar30
27DPR_SKILLQualification Requirements7ENTITY_TYPEObject Type in Project Planningnvarchar30
TOPStreamWork ABAP Library
28STWD_BO_ENTITYCollaboration: Business Object - Entity Assignment4ENTITY_TYPECollaboration: Entity Typenvarchar10
TOPWeb Service and SOAP - ABAP
29SRT_CFG_LOG_ITEMSRT Logging: Item Table6ENTITY_TYPESRT Log Entity Typenvarchar300
30SRT_CNTRL_TASKSSOAManager Central Configuration: Tasks9ENTITY_TYPEType of the entity which is distributednvarchar100
31SRT_ENTITYSOAP Runtime: SOAP Applications2ENTITY_TYPESRT: Entity Type (SOAP Application, Transport Binding, ...)nvarchar100
32SRT_WSDL_ENTITYWSDL Upload: Entities table3ENTITY_TYPEWSDL Upload: Entity typenvarchar120
TOPWeb Services Tool
33BSDM_ATTRIBUTESBol: Service Data Manager : Mapping table3ENTITY_TYPEBOL Service Data Manager: Mapping Typenvarchar10
34BSDM_INFOBol: Service Data Manager : Mapping table3ENTITY_TYPEBOL Service Data Manager: Mapping IDnvarchar10