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

36 columns | Print definition?ERP 6.0  | DOC_STATUS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/C_PRK_HLTable to hold the status of the Doc to be created in backend4DOC_STATUSDocument Typenvarchar50
2/SAPSRM/SOCO_ITTable for storing workarea items for requirement updates4DOC_STATUSSingle-Character Indicatornvarchar10
3FIKZDUSEPERMITInvoice Journal: Entry protection3DOC_STATUSElectronic Invoice Document Statusnvarchar20
4FIKZD_DEADJRNLInvoice Journal Deadlines (Electronic Invoices)3DOC_STATUSElectronic Invoice Document Statusnvarchar20
5FIKZD_REGINV_INIncoming Invoice Registration Journal58DOC_STATUSElectronic Invoice Document Statusnvarchar20
6FIKZD_REGINV_OUTOutgoing Invoice Registration Journal57DOC_STATUSElectronic Invoice Document Statusnvarchar20
7FIKZ_REGINV_LOGInvoice Journal (Kazakhstan): History of Statuses9DOC_STATUSElectronic Invoice Document Statusnvarchar20
8J_1UFDI_LOGUA E-Invoices: History of Statuses10DOC_STATUSDocument Statusnvarchar20
9J_1UF_REP_XMLXML table for J_1UF_REP38DOC_STATUSDocument Statusnvarchar20
10J_1UF_REP_XML_AXML table for J_1UF_REEI with User39DOC_STATUSDocument Statusnvarchar20
11J_1UF_RES_XMLXML table for J_1UF_RES36DOC_STATUSDocument Statusnvarchar20
12J_1UF_TP_MAINMain Information of Notification22DOC_STATUSDocument Statusnvarchar10
13J_3RFDI_DEADJRNLInvoice Journal Deadlines (Electronic Invoices)3DOC_STATUSElectronic Invoice Document Statusnvarchar20
14J_3RFDI_DEADTRGDelivery and Acceptance Documents Deadlines3DOC_STATUSDocument Statusnvarchar20
15J_3RFREGCUSEDIVAT Invoice Journal: Entry Protection3DOC_STATUSElectronic Invoice Document Statusnvarchar20
16J_3RFTGCUSEDIDelivery and Acceptance Documents: Entry Protection3DOC_STATUSDocument Statusnvarchar20
17J_3RF_REGINV_INIncoming Invoice Registration Journal37DOC_STATUSElectronic Invoice Document Statusnvarchar20
18J_3RF_REGINV_LOGInvoice Journal (Russia): History of Statuses14DOC_STATUSElectronic Invoice Document Statusnvarchar20
19J_3RF_REGINV_OUTOutgoing Invoice Registration Journal36DOC_STATUSElectronic Invoice Document Statusnvarchar20
20J_3RF_RGTORG_INIncoming Journal of Acceptance Documents25DOC_STATUSDocument Statusnvarchar20
21J_3RF_RGTORG_OUTOutgoing Journal of Acceptance Documents20DOC_STATUSDocument Statusnvarchar20
22J_3RF_TGXML_LOGTORG Journal (Russia): History of Statuses12DOC_STATUSDocument Statusnvarchar20
23TLRT_TARO_DOCTrade Repository: Documents6DOC_STATUSDocument Statusnvarchar20
24WSPT_LIKPDocuments For Portugal Webservice11DOC_STATUSDocument Status for PT Websevicenvarchar10
25WSPT_LIKP_REJRejected documents for Portugal Webservice7DOC_STATUSDocument Status for PT Websevicenvarchar10
TOPAccounts Receivable Accounting Process Integration
26TEBPPEXTSTATUSExternal description of the invoice2DOC_STATUSPayer Direct Document Statusnvarchar10
27TEBPPEXTSTATUSTText table for TEBPPEXTSTATUS3DOC_STATUSPayer Direct Document Statusnvarchar10
TOPAdvanced Returns Management
28MSR_D_EXECUTEDAdvanced Returns Management # Tracking of Executed Steps9DOC_STATUSStatus of Document Itemnvarchar10
TOPArchiveLink
29TOAPISAP ArchiveLink interface24DOC_STATUSSingle-Character Indicatornvarchar10
TOPBusiness Application Support
30CNV_00001_PARAMSParameter table10DOC_STATUSIcon in text fields (substitute display, alias)nvarchar40
TOPManagement of Global Employees
31PA0702HR Master Record: Infotype 070230DOC_STATUSDocument Statusnvarchar20
32PA0703HR Master Record: Infotype 070331DOC_STATUSDocument Statusnvarchar20
33T76MGE_DSTDocument Status2DOC_STATUSDocument Statusnvarchar20
34T76MGE_DTTText Table for Document Status3DOC_STATUSDocument Statusnvarchar20
TOPSAP Records Management
35SRM_GSP_TAGGINGUnique Document IDs of Documents to be Archived5DOC_STATUSState of the Document During Archivingnvarchar10
TOPValuation
36OIURV_DOC_HDRValuation Document Header8DOC_STATUSValuation Document Statusnvarchar20