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

39 columns | Print definition?ERP 6.0  | ESRPZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)61ESRPZISR Check Digitnvarchar20
2BBP_PDIGPBusiness Transaction Item-Purchasing Information109ESRPZISR Check Digitnvarchar20
3BBP_RBKPDocument Header: Invoice Receipt53ESRPZISR Check Digitnvarchar20
4BSEGAccounting Document Segment162ESRPZISR Check Digitnvarchar20
5BSSEGAccounting Document Segment151ESRPZISR Check Digitnvarchar20
6FUDT_VDOCBSEGVerification Document Item with Additional Info151ESRPZISR Check Digitnvarchar20
7FUDT_VDOCBSEGEVVerification Document Item in the Entry View151ESRPZISR Check Digitnvarchar20
8FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)151ESRPZISR Check Digitnvarchar20
9GLPOS_C_CTFI Document: Entry View105ESRPZISR Check Digitnvarchar20
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items105ESRPZISR Check Digitnvarchar20
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items105ESRPZISR Check Digitnvarchar20
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items105ESRPZISR Check Digitnvarchar20
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type107ESRPZISR Check Digitnvarchar20
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type107ESRPZISR Check Digitnvarchar20
15P2RH_HU_MEMBP21MB25ESRPZISR Check Digitnvarchar20
16P2RX_BTPayroll Results: Bank Transfers30ESRPZISR Check Digitnvarchar20
17P2RX_BT_PERSONPayment-Related Information (Person)32ESRPZISR Check Digitnvarchar20
18REGUPProcessed items from payment program74ESRPZISR Check Digitnvarchar20
19T77PAYKZBTBank Transfer Table Image (BTKZ)47ESRPZISR Check Digitnvarchar20
TOPAccounting Interface
20GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)232ESRPZISR Check Digitnvarchar20
21GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)232ESRPZISR Check Digitnvarchar20
TOPCollectionsDisbursements
22VVSCPOSESRPayment Plan Item: ISR Attachment8ESRPZISR Check Digitnvarchar20
TOPContract Accounts Receivable and Payable
23DFKKESRPOR Payment Supplement6ESRPZISR Check Digitnvarchar20
TOPFinancial Accounting
24VBSEGKDocument Segment for Vendor Document Parking90ESRPZISR Check Digitnvarchar20
TOPFunds Management-Specific Postings
25PSOSEGKRecurring Request Document Segment, Vendors91ESRPZISR Check Digitnvarchar20
TOPInvoice Verification
26RBKPDocument Header: Invoice Receipt53ESRPZISR Check Digitnvarchar20
27RBKPBInvoice Document Header (Batch Invoice Verification)48ESRPZObsolete: ISR check digit: do NOT usenvarchar20
TOPPayment Transactions
28FPRL_ITEMItem Data50ESRPZISR Check Digitnvarchar20
29REGUP_COREProcessed Items from Payment Program33ESRPZISR Check Digitnvarchar20
TOPPayroll
30T7BGA2Changes of external transfers (IT11)3ESRPZISR Check Digitnvarchar20
31T7ROA5Changes of external transfers (IT11)3ESRPZISR Check Digitnvarchar20
32T7SIA5History of repayments4ESRPZISR Check Digitnvarchar20
33T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000950ESRPZKontr.cís.ESRnvarchar20
34T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001155ESRPZKontr.cís.ESRnvarchar20
TOPPersonnel Administration
35PA0009HR Master Record: Infotype 0009 (Bank Details)47ESRPZISR Check Digitnvarchar20
36PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)52ESRPZISR Check Digitnvarchar20
37PA0057HR Master Record: Infotype 0057 (Membership Fees)42ESRPZISR Check Digitnvarchar20
TOPRecruitment
38PB0009HR Master Record: Infotype 0009 (Bank Details)47ESRPZISR Check Digitnvarchar20
TOPRemaining Beverage - Obsolete Objects
39/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1153ESRPZISR Check Digitnvarchar20