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

23 columns | Print definition?ERP 6.0  | REF_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBO_ASOSB: OData Associations11REF_KEYText element key (number/selection name)nvarchar80
2/IWBEP/I_SBO_ATSB: OData Association Sets10REF_KEYText element key (number/selection name)nvarchar80
3/IWBEP/I_SBO_CTSB: OData Complex Types9REF_KEYText element key (number/selection name)nvarchar80
4/IWBEP/I_SBO_ESSB: OData Entity Sets17REF_KEYText element key (number/selection name)nvarchar80
5/IWBEP/I_SBO_ETSB: OData Entity Type13REF_KEYText element key (number/selection name)nvarchar80
6/IWBEP/I_SBO_FISB: OData Function Imports14REF_KEYText element key (number/selection name)nvarchar80
7/IWBEP/I_SBO_FPSB: Function Import Parameters19REF_KEYText element key (number/selection name)nvarchar80
8/IWBEP/I_SBO_NPSB: OData Navigation Property10REF_KEYText element key (number/selection name)nvarchar80
9/IWBEP/I_SBO_PRSB: OData Properties30REF_KEYText element key (number/selection name)nvarchar80
10/IWBEP/I_SBO_RCSB: OData Referential Constraints11REF_KEYText element key (number/selection name)nvarchar80
11DFKKDPR_BP_ROLEIndex Table Business Partner Roles in Transaction Data5REF_KEYIdentifier of Reference Object for BP Roles in Trans. Datanvarchar420
12ITMF_D_NF_TEXTNota Fiscal Text2REF_KEYNota Fiscal IDnvarchar60
TOPAccrual Engine
13ACEOBJAccrual Objects5REF_KEYUnique External Reference for Accrual Objectnvarchar320
TOPActual Update and Commitment Update
14GMA_ACE_OBJECTSGM Accruals: Accrual Objects3REF_KEYUnique External Reference for Accrual Objectnvarchar320
TOPBusiness Objects, Common Components
15EHDMOD_ADR_PHONEAddress - Contacts10REF_KEYNodeIDvarbinary160
TOPCollateral Management System
16TCMS_CD_BUSINFOClassification of a change to a business object - internal3REF_KEYKey Identifier for the Cause of the Changenvarchar700
TOPCRM Accruals
17CRM_ACE_OH_DATACRM Accruals: Object Header5REF_KEYUnique External Reference for Accrual Objectnvarchar320
18CRM_ACE_REFKEYCRM Accruals: REFKEY Decryption6REF_KEYUnique External Reference for Accrual Objectnvarchar320
TOPManual Accruals
19ACAC_OBJECTSManual Accruals: Accrual Objects7REF_KEYUnique External Reference for Accrual Objectnvarchar320
TOPPrice Planning Workbench
20WRF_PPW_PPDOSPPD Organization Set - Header5REF_KEYValue of Organization Set Reference Typenvarchar120
TOPProvisions for Awards
21ACE_SOP_REFKEYDecoding of Accrual Engine RefKey6REF_KEYUnique External Reference for Accrual Objectnvarchar320
TOPSelf-Service Procurement
22/SRMERP/D_DSS_IRDocument Item Reference5REF_KEYNodeIDvarbinary160
23/SRMERP/D_DSS_RTDocument Subset Root5REF_KEYNodeIDvarbinary160