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

44 columns | Print definition?ERP 6.0  | ESRRE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)60ESRREISR Reference Numbernvarchar270
2BBP_PDIGPBusiness Transaction Item-Purchasing Information111ESRREISR Reference Numbernvarchar270
3BBP_RBKPDocument Header: Invoice Receipt54ESRREISR Reference Numbernvarchar270
4BSEGAccounting Document Segment161ESRREISR Reference Numbernvarchar270
5BSSEGAccounting Document Segment150ESRREISR Reference Numbernvarchar270
6FUDT_VDOCBSEGVerification Document Item with Additional Info150ESRREISR Reference Numbernvarchar270
7FUDT_VDOCBSEGEVVerification Document Item in the Entry View150ESRREISR Reference Numbernvarchar270
8FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)150ESRREISR Reference Numbernvarchar270
9GLPOS_C_CTFI Document: Entry View106ESRREISR Reference Numbernvarchar270
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items106ESRREISR Reference Numbernvarchar270
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items106ESRREISR Reference Numbernvarchar270
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items106ESRREISR Reference Numbernvarchar270
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type108ESRREISR Reference Numbernvarchar270
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type108ESRREISR Reference Numbernvarchar270
15P2RH_HU_MEMBP21MB24ESRREISR Reference Numbernvarchar270
16P2RX_BTPayroll Results: Bank Transfers29ESRREISR Reference Numbernvarchar270
17P2RX_BT_PERSONPayment-Related Information (Person)31ESRREISR Reference Numbernvarchar270
18REGUPProcessed items from payment program73ESRREISR Reference Numbernvarchar270
19T77PAYKZBTBank Transfer Table Image (BTKZ)46ESRREISR Reference Numbernvarchar270
TOPAccounting Interface
20GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)233ESRREISR Reference Numbernvarchar270
21GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)233ESRREISR Reference Numbernvarchar270
TOPCollectionsDisbursements
22VVSCPOSESRPayment Plan Item: ISR Attachment7ESRREISR Reference Numbernvarchar270
TOPContract Accounts Receivable and Payable
23DFKKESRPOR Payment Supplement5ESRREISR Reference Numbernvarchar270
TOPFinancial Accounting
24VBSEGKDocument Segment for Vendor Document Parking89ESRREISR Reference Numbernvarchar270
TOPFunds Management-Specific Postings
25PSOSEGKRecurring Request Document Segment, Vendors90ESRREISR Reference Numbernvarchar270
TOPInvoice Verification
26RBKPDocument Header: Invoice Receipt54ESRREISR Reference Numbernvarchar270
27RBKPBInvoice Document Header (Batch Invoice Verification)49ESRREObsolete: ISR reference number: do NOT usenvarchar270
TOPPayment Transactions
28FPRL_ITEMItem Data49ESRREISR Reference Numbernvarchar270
29REGUP_COREProcessed Items from Payment Program32ESRREISR Reference Numbernvarchar270
TOPPayroll
30T5T1LBank accounts of authorities (tax,insurance)13ESRREISR Reference Numbernvarchar270
31T5TA1External transfers38ESRREISR Reference Numbernvarchar270
32T5TPS1LBank accounts of authorities (tax,insurance)15ESRREISR Reference Numbernvarchar270
33T5TSPOTable for convert bank accounts (Ceska Sporitelna)5ESRREISR Reference Numbernvarchar270
34T7SI1LBank accounts of authorities (tax,insurance)11ESRREPOR reference numbernvarchar270
35T7SIA6Bank transfer - interface table34ESRREISR Reference Numbernvarchar270
36T7SK1LBank accounts of authorities (tax,insurance)16ESRREISR Reference Numbernvarchar270
37T7SKA1External transfers38ESRREISR Reference Numbernvarchar270
38T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000949ESRREReferencné cís.ESRnvarchar270
39T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001154ESRREReferencné cís.ESRnvarchar270
TOPPersonnel Administration
40PA0009HR Master Record: Infotype 0009 (Bank Details)46ESRREISR Reference Numbernvarchar270
41PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)51ESRREISR Reference Numbernvarchar270
42PA0057HR Master Record: Infotype 0057 (Membership Fees)41ESRREISR Reference Numbernvarchar270
TOPRecruitment
43PB0009HR Master Record: Infotype 0009 (Bank Details)46ESRREISR Reference Numbernvarchar270
TOPRemaining Beverage - Obsolete Objects
44/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1152ESRREISR Reference Numbernvarchar270