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

33 columns | Print definition?ERP 6.0  | VERSION_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_PFP_PVPlan Version4VERSION_IDPlan Version IDnvarchar280
2/XFT/SRMDOCTT002Document Template Content Versions by Language5VERSION_IDText (10 Characters)nvarchar100
3BBPC_CF_VER_TI_TText Table for Version Description4VERSION_IDnvarchar400
TOPCollaboration Folders
4CFX_VERSION_LOCKVersions Locked Against Changes2VERSION_IDGUID in 'CHAR' Format in Uppercasenvarchar320
5CFX_VER_CHECKOUTCFX: Local File Path2VERSION_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPIntegration Builder - Configuration
6TRD_COBJPREFIXPrefix-Namespace Assignment for Context Objects2VERSION_IDComponent IDvarbinary160
7TRD_COBJXPATHXPaths in Context Objects2VERSION_IDComponent IDvarbinary160
TOPInventory Accounting
8UAIQSVERSIONQuantity Structure: Version2VERSION_IDQuantity Structure: Versionnvarchar40
9UAIQSVERSIONTText for Quantity Structure Version2VERSION_IDQuantity Structure: Versionnvarchar40
10UAIQS_BALANCEQuantity Structure: Beginning/Ending Inventories and Values3VERSION_IDQuantity Structure: Versionnvarchar40
11UAIQS_SNDRCVQuantity Structure: Valuated Quantity Structure3VERSION_IDQuantity Structure: Versionnvarchar40
TOPMapping
12SMPPMAPMapping Runtime: Mapping2VERSION_IDXI Version IDvarbinary160
13SMPPMAP3Mapping Runtime: Mapping3VERSION_IDXI Version IDvarbinary160
14SMPPPARMapping Runtime: Parameterization2VERSION_IDXI Version IDvarbinary160
15SMPPSPLITXI Mapping: Merge and Split3VERSION_IDXI Version IDvarbinary160
16SMPPSTEPMapping Runtime: Mapping Step3VERSION_IDXI Version IDvarbinary160
TOPNetWeaver Enterprise Search
17ESH_CO_VERSIONEnterprise Search Version2VERSION_IDEnterprise Search Version IDnvarchar320
18ESH_OM_SYSRELProduct Versions9VERSION_IDUnique Model Version IDnvarchar400
19ESH_OM_SYSRELMSoftware Components: Mapping Appliance <-> Backend4VERSION_IDUnique Model Version IDnvarchar400
20ESH_TAU_CL_PClassification Test: Property3VERSION_IDVersion IDnvarchar100
21ESH_TAU_CL_PDTClassification Test: Prop. Datatype3VERSION_IDVersion IDnvarchar100
22ESH_TST_DATATYPEES Test Object Data Type3VERSION_IDVersion IDnvarchar100
TOPOffice Suite Program
23/OSP/T_RAUI_VERTable to maintain the versions2VERSION_IDVersion IDnvarchar80
TOPPortfolio Management
24/RPM/BK_VER_CTRLBucket Version Controller Data4VERSION_IDVersion Information IDnvarchar240
25/RPM/IT_VER_CTRLItem Version Controller Table5VERSION_IDVersion Information IDnvarchar240
26RPM_PROJECT_VERSProject Versions4VERSION_IDVersion IDnvarchar40
TOPProcess Management
27CMX_XSR_DB_VERSStandard Execution Step Repository: Versions2VERSION_IDXSteps: Unique ID of a Nodenvarchar220
28CMX_XSR_DS_METAMetadata Table for Digital Signature for SXS Versions6VERSION_IDXSteps: Unique ID of a Nodenvarchar220
29CMX_XSR_VER_SIGNMetadata Table for Digital Signatures for SXS Versions4VERSION_IDXSteps: Unique ID of a Nodenvarchar220
TOPProxy Generation
30SPROXHDRProxy Header Data (substitution table)31VERSION_IDVersion GUIDnvarchar320
TOPStatus and Action Management
31SAMDT_ELEMENTSS&AM Elements2VERSION_IDNumeric Character Field, Length 10nvarchar100
32SAMDT_RELATIONSS&AM DT Relation2VERSION_IDNumeric Character Field, Length 10nvarchar100
33SAMDT_SCHEMASS&AM Schemas2VERSION_IDNumeric Character Field, Length 10nvarchar100