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

47 columns | Print definition?ERP 6.0  | PATHID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVLTHCM_STATUSStatus of Path Determination3PATHIDPathnvarchar150
2CNV_10020_ACTOCActions for offset determination via value search8PATHIDPathnvarchar150
3CNV_10020_ACTODActions for offset determination via determination8PATHIDPathnvarchar150
4CNV_10020_ACTOMActions for offset determination via domain search8PATHIDPathnvarchar150
5CNV_10020_ADTFLDAnalysis results for filling percentage of determin. field10PATHIDPathnvarchar150
6CNV_10020_ADTMISAnalysis: Filled fields for conv. with empty determin. obj10PATHIDPathnvarchar150
7CNV_10020_CARDRequired cardinality per path4PATHIDPathnvarchar150
8CNV_10020_CLUCluster for saving object relationships4PATHIDPathnvarchar150
9CNV_10020_CONDDDConditions for comparison of determination and determ.9PATHIDPathnvarchar150
10CNV_10020_CONDDVConditions for comparison of determation and values9PATHIDPathnvarchar150
11CNV_10020_CONDFDConditions for comparison of field and determination13PATHIDPathnvarchar150
12CNV_10020_DPPATHPath dependencies3PATHIDPathnvarchar150
13CNV_10020_DTDEFDetermination definition of elementary relationships3PATHIDPathnvarchar150
14CNV_10020_DTDEFSSpecial determination definitions3PATHIDPathnvarchar150
15CNV_10020_DTFLDAssignment of determination to tables and fields12PATHIDPathnvarchar150
16CNV_10020_EMEMPaths without calculation of memory requirements3PATHIDPathnvarchar150
17CNV_10020_EPATHPaths that should not be suggested4PATHIDPathnvarchar150
18CNV_10020_LPATHPaths to be loaded irrespective of DTFLD entries3PATHIDPathnvarchar150
19CNV_10020_MEMPMemory requirements per table and determination paths4PATHIDPathnvarchar150
20CNV_10020_PARAMPPath parameters3PATHIDPathnvarchar150
21CNV_10020_PATHDetermination paths: Header data3PATHIDPathnvarchar150
22CNV_10020_PATHTDetermination paths: Descriptions4PATHIDPathnvarchar150
23CNV_10020_PATH_CConverter paths - item data3PATHIDPathnvarchar150
24CNV_10020_PATH_MMultiple paths: Item data3PATHIDPathnvarchar150
25CNV_10020_PATH_SSingle paths: Item data3PATHIDPathnvarchar150
26CNV_10020_PLTPTable-dependent overriding of the path parameters (part.ld4PATHIDPathnvarchar150
27CNV_10020_SCANBlock limits for partial loading3PATHIDPathnvarchar150
28CNV_10020_STATEStatus of the determination programs3PATHIDPathnvarchar150
29CNV_10020_STATEHStatus of the determination programs - History3PATHIDPathnvarchar150
30CNV_10020_TRACKStatistics for executed determinations7PATHIDPathnvarchar150
31CNV_10020_TRCPLHHistory of executed accesses during partial loading7PATHIDPathnvarchar150
32CNV_10020_TRCPLSStatistics for executed accesses during partial loading6PATHIDPathnvarchar150
33CNV_10996_DTFLDMapping determination - header tables11PATHIDDetermination pathnvarchar150
34CNV_10996_ORGPTHPossible paths for ORG determination3PATHIDDetermination pathnvarchar150
TOPRecords and Case Management
35RMPSGENSPHISTHistory Table for Generic SP Objects8PATHIDProcess Route IDnvarchar120
36RMPSPATHFIELDSProcess Route Fields for Public Services3PATHIDProcess Route IDnvarchar120
TOPRetention Warehouse
37IWP_WP_PATHPaths of an Audit Package3PATHIDPath Identifiernvarchar60
38IWP_WP_PTH_STRCStructures of the Pathes of an Audit Package3PATHIDPath Identifiernvarchar60
39IWP_WP_URIAudit Package URI3PATHIDPath Identifiernvarchar60
TOPSAP Records Management
40SRMDPDISPCircular4PATHIDProcess Route IDnvarchar120
41SRMWFPATHWorkflow Process Route3PATHIDProcess Route IDnvarchar120
42SRMWFPATHAGTOther People Involved in Process Route3PATHIDProcess Route IDnvarchar120
43SRMWFPATHGROUPAssignment Table of Process Route Models for Groups3PATHIDProcess Route IDnvarchar120
44SRMWFPATHTText Table for Process Route Header3PATHIDProcess Route IDnvarchar120
45SRMWFPTHFIELDSAdditional Customer-Specific Fields in Process Route3PATHIDProcess Route IDnvarchar120
46SRMWFPTHPSProcess Route Item for Workflow3PATHIDProcess Route IDnvarchar120
47SRMWFPTRELPredecessor-Successor Relations of Process Route Items3PATHIDProcess Route IDnvarchar120