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

44 columns | Print definition?ERP 6.0  | SOURCE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SYCLO/PSH00Push Scenario Definition4SOURCE_TYPEPush Scenario Source Typenvarchar100
2/SYCLO/PSH01Syclo Push Register6SOURCE_TYPEPush Scenario Source Typenvarchar100
3CNVTDMSBW_DTMARTTable storing data Mart Mappings4SOURCE_TYPEObject Typenvarchar40
4EDOCOMPANYACTIVeDocument: Activation of Source Types per Company Code3SOURCE_TYPEeDocument Source Typenvarchar100
5EDOCUMENTeDocument6SOURCE_TYPEeDocument Source Typenvarchar100
6EDOCUMENTHISTORYeDocument: History6SOURCE_TYPEeDocument Source Typenvarchar100
7EDOMAPCLASSDETeDocument Mapping Class determination6SOURCE_TYPEeDocument Source Typenvarchar100
8EDOPROCSPINTDETeDocument Process Step Interface determination6SOURCE_TYPEeDocument Source Typenvarchar100
9EDOPROCSTEPDETeDocument Process Step determination6SOURCE_TYPEeDocument Source Typenvarchar100
10EDOSRCTYPEeDocument: Source Type1SOURCE_TYPEeDocument Source Typenvarchar100
11EDOSRCTYPETeDocument: Source Type Description2SOURCE_TYPEeDocument Source Typenvarchar100
12FDT_DDBV_0000BRFplus: Dynamic Database View - Source Assignment7SOURCE_TYPEnvarchar160
13FDT_DDBV_0000ABRFplus: Dynamic Database View - Source Assignment7SOURCE_TYPEnvarchar160
14FDT_DDBV_0000SBRFplus: Dynamic Database View - Source Assignment6SOURCE_TYPEnvarchar160
15FDT_DDBV_0000TBRFplus: Dynamic Database View - Source Assignment6SOURCE_TYPEnvarchar160
16HRP5058DB Table for Infotype 505823SOURCE_TYPEObject Typenvarchar20
17PIQC_PREP_FLD_CDefine Customer-Specific Sources5SOURCE_TYPEPricing Prepare: Source Type for KOMK/KOMP Fieldsnvarchar10
18PIQC_PREP_FLD_SPricing prepare: Sources for KOMK/KOMP fields (SAP delivery)5SOURCE_TYPEPricing Prepare: Source Type for KOMK/KOMP Fieldsnvarchar10
19PIQC_PREP_KEY_CPricing prepare: Keys for KOMK/KOMP fields (Customer)5SOURCE_TYPEPricing Preparation: Source Type for DB Key Fieldsnvarchar10
20PIQC_PREP_KEY_SPricing prepare: Keys for KOMK/KOMP fields (SAP delivery)5SOURCE_TYPEPricing Preparation: Source Type for DB Key Fieldsnvarchar10
21SIMDQ_SOURCE_TYPIM in HANA source type values1SOURCE_TYPEIM in HANA source typenvarchar150
22VMP_PLSCP_TYPETable for Standard Planning Scope Scenarios2SOURCE_TYPEPlanning scope source typenvarchar20
TOPBack Office
23TRST_SEC_ACC_FLDField Status for Securities Account Master Data3SOURCE_TYPEOrigin Type of Field Contentnvarchar20
TOPClassification Toolset
24CLS_SOURCE_TYPESource types1SOURCE_TYPETemplate Typenvarchar400
25CLS_SOURCE_TYPETTemplate descriptions2SOURCE_TYPETemplate Typenvarchar400
TOPData Warehousing Workbench
26RSIWADFLOWLINKSLinks in Data Flow3SOURCE_TYPEData Target Typenvarchar60
TOPFast Search Infrastructure
27SFSRFW_ALIAS_HReplication Framework - Aliases3SOURCE_TYPEReplication Framework - Selection Type (T: Table, A: Node)nvarchar10
TOPFSCM In-House Cash
28IHC_TAB_GUI_MAPIHC: Mapping Table for GUI4SOURCE_TYPEIHC: Type of Source Fieldnvarchar150
TOPIntegration Builder - Configuration
29SXI_LINKReference Between XI Objects5SOURCE_TYPEType of XI Objectnvarchar160
TOPLogistics - General
30EPM_CODEKey Management for KPI Values4SOURCE_TYPEType of Source System for KPI Valuenvarchar30
31EPM_KPI_CATALOGKPIs Available in Company Catalog5SOURCE_TYPEType of Source System for KPI Valuenvarchar30
32EPM_KPI_CATALOGHHistory of KPIs in KPI Catalog6SOURCE_TYPEType of Source System for KPI Valuenvarchar30
TOPMaintenance Orders
33/MRSS/C_SQE_RSADMRS system table: info fields in results list3SOURCE_TYPEResults-list field: origin typenvarchar100
34/MRSS/D_RES_INFOResource information in addition to WFM data3SOURCE_TYPEInternal / External Resourcenvarchar10
TOPMaintenance Processing
35/MRSS/D_BAS_RESResource Master Data13SOURCE_TYPEInternal / External Resourcenvarchar10
TOPOLAP Technology
36RSR_TS_HEADERTransient Sources for BEx1SOURCE_TYPESource Type Name of a transient provider enginenvarchar300
37RSR_TS_HEADERTTexts for Transient Source Engines2SOURCE_TYPESource Type Name of a transient provider enginenvarchar300
TOPPatient Management
38NSHIFTIS-H: Results of Case Revision8SOURCE_TYPEIS-H: Case Revision - Object Typenvarchar100
TOPProduction Allocation
39GHO_MRH_RULE_IMeasurement Retrieval Hierarchy Rules Item4SOURCE_TYPESource Type for MRH Rulesnvarchar80
TOPRemaining Beverage - Obsolete Objects
40/BEV3/CHCDPBKCDP: Purchase Control Results3SOURCE_TYPECH: Indicator of Update Typenvarchar10
41/BEV3/CHCDPSALESCDP: Contract Sales (Detailed)7SOURCE_TYPECH: Indicator of Update Typenvarchar10
TOPService Implementation Workbench
42TSIW_SXF_TYPESignature Exchange Format - Type20SOURCE_TYPEAssociated Type of an Interface Parameternvarchar1320
TOPTools
43HRPYO_D_DEPCYSchedule Dependency3SOURCE_TYPEEntity Typenvarchar20
TOPWeb Service and SOAP - ABAP
44SRT_WSDL_DIRWSDL Upload: Directory table7SOURCE_TYPEWSDL upload: Source typenvarchar50