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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

35 columns | Print definition?ERP 6.0  | DOCUMENT_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/EPA_DELDECLRejected Documents3DOCUMENT_IDDocument IDnvarchar400
2/XFT/EPA_DELMDATManually Set Deletion Date3DOCUMENT_IDDocument IDnvarchar400
3/XFT/EPA_DELRUNNRunning Deletion Processes3DOCUMENT_IDDocument IDnvarchar400
4/XFT/EPA_RECPOSProperty extension: File nodes ArchiveLink documents5DOCUMENT_IDDocument IDnvarchar400
5/XFT/EPA_TPROTLog10DOCUMENT_IDSAP ArchiveLink: Document IDnvarchar400
6/XFT/MIG_DOCSDokumente in Migration3DOCUMENT_IDDokument Id Quellenvarchar400
7ABAP_ONLINE_COMABAP Online Community: Data exchange3DOCUMENT_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
8BBP_WFL_TRACEBBP_WFL_TRACE3DOCUMENT_IDTransaction Numbernvarchar100
9CNVCMIS_A_ARCHCMIS table for storing info. about active archive objects5DOCUMENT_IDArchiving Session Numbernvarchar60
10CNV_CMIS_A_ARCHCMIS table for storing info. about active archive objects5DOCUMENT_IDArchiving Session Numbernvarchar60
11CNV_LM_DDIC_COConsequences of DDIC Changes3DOCUMENT_IDDocumentation Objectnvarchar600
12T7BR_DOCUMENTSTable to store XML sent for the government2DOCUMENT_IDDocument unique identifiernvarchar320
TOPAccounting - General
13TFC_INST_ITEMAdministration of a Job (Report/Transaction or Workflow)27DOCUMENT_IDBusiness Document Service: Document IDnvarchar420
14TFC_TEMPL_ITEMAdministration of a Job (Report/Transaction or Workflow)27DOCUMENT_IDBusiness Document Service: Document IDnvarchar420
TOPApplication-Specific Upgrade
15/ASU/SSMOFFICEASU Simple Schedule Manager: Office Integration6DOCUMENT_IDBusiness Document Service: Document IDnvarchar420
TOPBasic Functions
16PAYSP_HLPayment Service Provider Data2DOCUMENT_IDSales and Distribution Document Numbernvarchar100
TOPBRFplus - ABAP-Based Business Rules
17FDT_ADMN_0111OBSOLETE - DO NOT USE5DOCUMENT_IDFDT: Document IDnvarchar320
18FDT_ADMN_0111SOBSOLETE - DO NOT USE4DOCUMENT_IDFDT: Document IDnvarchar320
19FDT_ADMN_0111TOBSOLETE - DO NOT USE4DOCUMENT_IDFDT: Document IDnvarchar320
TOPJob Scheduling and Monitoring
20/JCS/FCC_ACTIONSFCc: Notification actions to perform13DOCUMENT_IDDescriptionnvarchar1000
TOPManagement of Global Employees
21T76MGE_FORMSETUPGlobal employee: Form Setup6DOCUMENT_IDBusiness Document Service: Document IDnvarchar420
TOPPricing
22PRCD_SIM_ATTRPricing Document Attributes (Simulation)2DOCUMENT_IDPricing Document GUIDvarbinary160
23PRCD_SIM_HEADPricing Document Header (Simulation)2DOCUMENT_IDPricing Document GUIDvarbinary160
24PRCD_SIM_ITEMPricing Document Item (Simulation)2DOCUMENT_IDPricing Document GUIDvarbinary160
TOPPublic Sector Contract Accounts Receivable and Payable
25DFMCA_FORM_CONTSData Table for Data Container Key5DOCUMENT_IDGUIDnvarchar320
26DFMCA_NOTE_ATTNote Attributes for Process Objects16DOCUMENT_IDTechnical Case Key (Case GUID)nvarchar320
TOPSAP Records Management
27SRM_GSP_TAGGINGUnique Document IDs of Documents to be Archived3DOCUMENT_IDID for documents and relationsnvarchar320
TOPSchedule Manager
28SCMAOFFICESchedule Manager: Office Integration5DOCUMENT_IDBusiness Document Service: Document IDnvarchar420
TOPTalent Management
29HRT7402Internal Work Experience5DOCUMENT_IDID for documents and relationsnvarchar320
30HRT7403External Work Experience5DOCUMENT_IDID for documents and relationsnvarchar320
31HRT7404Education/Training5DOCUMENT_IDID for documents and relationsnvarchar320
32HRT7405Accomplishments5DOCUMENT_IDID for documents and relationsnvarchar320
33HRT7420Table Section Infotype 74205DOCUMENT_IDID for documents and relationsnvarchar320
34HRT7434Talent Review Meeting Agenda Topics (Table Section)6DOCUMENT_IDID for documents and relationsnvarchar320
35HRT7435Documents (Table Section)4DOCUMENT_IDID for documents and relationsnvarchar320