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  | SIGN_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/D_DSIG_ACTDigital Signature for Activity2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
2/IAM/D_DSIG_ISSDigital Signature for Issue2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
3/XFT/SRMCYCLE30Cycle: Signature Metadata Table2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
4DRAW_DSDigital Signature for Document Info Records2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
5FIGEKWC_ROLESEQAssign Form Signatures to Roles4SIGN_IDSignature ID for Legal Formsnvarchar100
6FILFGNC_ROLESEQAssign Form Signatures to Roles4SIGN_IDSIgnature ID for FI legal formsnvarchar100
7ZPHT_IDES_RECORDMeta Data Table for IDES Pharma Demo (Regulatory Submission)2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPAudit Management
8PLM_AUDIT_DSDigital Signature for Audit Management Objects2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPBrowser-Based PI Sheet Cockpit
9POC_DB_DEV_SIGNSignature Key: Metadata Signature Process Step2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
10POC_DB_EVT_SIGNSignature Keys: Metadata for Event Log2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
11POC_DB_STEP_SIGNSignature Key: Metadata Signature Process Step2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPDigital Signature
12DSIG_META_EXSignature Tool: Sample Database Table for Metadata2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
13SIGNDODigital Signature: Documents to Sign2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
14SIGNHDigital Signature: Header Data2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
15SIGNSTransaction Data for Digital Signatures2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPEngineering Change Record
16/PLMB/ER_DS_METAEngineering Record - Digital Signature Meta Data table2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPFinancial Supply Chain Management
17BNK_META_LOGMeta Table: Logs for Signature Bank Communication2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPGovernance, Risk and Compliance
18GRFN_ESIG_TAB2master data table for grc pc fda e-sig, v32SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPLogbook
19DIACL_DIS_SIGDS : Order operation within Logbook (For Distribution)2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
20DIACL_DSLogbook digital signatures2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPMaintenance History
21AFVC_DIS_SIGDigital Signature of Order Operation for Distribution2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
22AFVC_DSDigital signatures for Order Operation2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPProcess Controls
23GRPC_ESIG_TABmaster data table for grc pc fda e-sig2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
24GRPC_T_FDA_ESIGDB meta data table for GRC FDA E-Sig2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPProcess Management
25CMX_XSR_DS_METAMetadata Table for Digital Signature for SXS Versions2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
26CMX_XSR_VER_SIGNMetadata Table for Digital Signatures for SXS Versions2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPProduction Orders
27COCF_SR_DSIGMETASignature Tool: Metadata for Shift Report2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPQuality Inspection
28QLOT_DSDigital Signature for Inspection Lots2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPQuality Management
29QNOTIF_HEADER_DSDigital Signature for Notifications - Header Level2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
30QNOTIF_TASK_DSDigital Signature for Notifications - Task Level2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
31ZQMEL_EVT_SIGNPH: Event log table for digital signature extensions2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220
TOPResults Recording
32QAMRCharacteristic results during inspection processing84SIGN_IDDigital Signature for Processnvarchar220
33QASRSample results for inspection characteristics80SIGN_IDDigital Signature for Processnvarchar220
TOPSample Management
34QSAMPLE_DSDigital Signature for Samples2SIGN_IDDigital Signature: Signature Number as GUID with 22 Chars.nvarchar220