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

57 columns | Print definition?ERP 6.0  | ISSUER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/STLCERTFNGPInformationen zu Zertifikaten5ISSUERnvarchar2550
2SAML2_USED_ASSRTStorage Table for SAML2 Assertions6ISSUERSAML2 Assertion Identifierntext10737418230
3STRUSTCRLCRLs4ISSUERIssuer of CRLntext10737418230
4STRUSTCRRRevoked Certificates (Minimum Age)5ISSUERCertificate Issuer Namentext10737418230
5STRUSTCRSList of sources for issuers in each CRL profile4ISSUERIssuer Name (With Change Document)ntext10737418230
6STRUSTCRTCertificates table with certificate status5ISSUERCertificate Issuer Namentext10737418230
TOPAuthentication and SSO
7USRCERTMAPCertificate Mapping6ISSUERIssuerntext10737418230
TOPBRFplus - ABAP-Based Business Rules
8FDT_ADMN_0031OBSOLETE - DO NOT USE3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
9FDT_ADMN_0031SOBSOLETE - DO NOT USE2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
10FDT_ADMN_0031TOBSOLETE - DO NOT USE2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
11FDT_ADMN_0730OBSOLETE - DO NOT USE4ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
12FDT_ADMN_0730SOBSOLETE - DO NOT USE3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
13FDT_ADMN_0730TOBSOLETE - DO NOT USE3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
14FDT_ADMN_E0031FDT: Enhancement - Last Update Timestamp3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
15FDT_ADMN_E0031SFDT: Enhancement - Header of transported data2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
16FDT_ADMN_E0031TFDT: Enhancement - Last Update Timestamp2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
17FDT_ADMN_E0070FDT: Enhancement Category for Issuer3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
18FDT_ADMN_E0070SFDT: Enhancement Category for Issuer2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
19FDT_ADMN_E0070TFDT: Enhancement Category for Issuer2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
20FDT_ADMN_L0070FDT: Issuer specific write to transport version information4ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
21FDT_ADMN_L0070SFDT: Local Table for Enhancement Data Exports3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
22FDT_ADMN_L0070TFDT: Local Table for Enhancement Data Exports3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
23FDT_ADMN_L0730FDT: Issuer Versions (Local)4ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
24FDT_ADMN_L0730SFDT: Issuer specific Version Information (Local)3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
25FDT_ADMN_L0730TFDT: Issuer Versions (Local)3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
26FDT_CTLG_E0000FDT: Enhancement - Catalog Structure3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
27FDT_CTLG_E0000SFDT: Enhancement - Catalog Structure2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
28FDT_CTLG_E0000TFDT: Enhancement - Catalog Structure2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
29FDT_CTLG_E0200FDT: Enhancement - Catalog Link3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
30FDT_CTLG_E0200SFDT: Enhancement - Catalog Link2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
31FDT_CTLG_E0200TFDT: Enhancement - Catalog Link2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
32FDT_CTLG_E0300FDT: Enhancement - Catalog Leaf3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
33FDT_CTLG_E0300SFDT: Enhancement - Catalog Leaf2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
34FDT_CTLG_E0300TFDT: Enhancement - Catalog Leaf2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
35FDT_CTLG_E0500FDT: Enhancement - Catalog Attribute Values3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
36FDT_CTLG_E0500SFDT: Enhancement - Catalog Attribute Values2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
37FDT_CTLG_E0500TFDT: Enhancement - Catalog Attribute Values2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
38FDT_CTLG_E0600FDT: Enhancement - Catalog Node Name3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
39FDT_CTLG_E0600SFDT: Enhancement - Catalog Node Name2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
40FDT_CTLG_E0600TFDT: Enhancement - Catalog Node Name2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
41FDT_EXPR_E0242FDT: Enhancement for Decision Table - Cell data3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
42FDT_EXPR_E0242SFDT: Enhancement for Decision Table - Cell data2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
43FDT_EXPR_E0242TFDT: Enhancement for Decision Table - Cell data2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
44FDT_EXPR_L0242FDT: Enhancment Decision Table - Issuer Index3ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
45FDT_EXPR_L0242SFDT: Enhancment Decision Table - Issuer Index2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
46FDT_EXPR_L0242TFDT: Enhancment Decision Table - Issuer Index2ISSUERFDT: Universal Unique Identifierr Soft Linknvarchar320
TOPContent Management Service
47CREP_FNGPInformation on Certificates4ISSUERnvarchar2550
TOPE-Recruiting
48HRP5111DB Table for Infotype 511119ISSUERLicense / Certificate Issued bynvarchar800
TOPMarket Risk Analyzer
49TCCT_CCURVE_MASTCommodity Curve Master Data16ISSUERIssuer of the Commoditynvarchar100
TOPPayment Cards
50PCA_MASTERPayment Card Master: General Data8ISSUERPayment cards: Issuing banknvarchar400
TOPRecords and Case Management
51RMPS_OCSP_ITEMDigital Signature Item: Signatory Details for Each Ver. Run10ISSUERntext10737418230
TOPSecure Network Communications
52USREXTID_IDMTable for Provisioning USREXTID Data from IDM4ISSUERIssuernvarchar2550
TOPSecurity
53STRUSTCABCentral Address Book4ISSUERntext10737418230
54USRCERTRULEMIGMigration table for rule based certificate mapping5ISSUERIssuerntext10737418230
TOPService Station Retailing
55OIREUPLKXXXXSSR PC: Template for generated DTF tables (header)38ISSUERSSR PC: EC card issuernvarchar20
TOPTransaction Manager
56TRCOT_CTY_EXCHNGCommodity Exchange relevant data10ISSUERIssuer of the Commoditynvarchar100
TOPTransfer to Financial Accounting
57TRACT_ACCITEMAccounting Items42ISSUERIssuer Identity Keynvarchar100