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

55 columns | Print definition?ERP 6.0  | ESRNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)59ESRNRISR Subscriber Numbernvarchar110
2/OPT/VIM_STG_LIFTable: Staging data - Vendor master for ICC20ESRNRISR Subscriber Numbernvarchar110
3BBP_PDIGPBusiness Transaction Item-Purchasing Information110ESRNRISR Subscriber Numbernvarchar110
4BBP_RBKPDocument Header: Invoice Receipt52ESRNRISR Subscriber Numbernvarchar110
5BSEGAccounting Document Segment160ESRNRISR Subscriber Numbernvarchar110
6BSSEGAccounting Document Segment149ESRNRISR Subscriber Numbernvarchar110
7FUDT_VDOCBSEGVerification Document Item with Additional Info149ESRNRISR Subscriber Numbernvarchar110
8FUDT_VDOCBSEGEVVerification Document Item in the Entry View149ESRNRISR Subscriber Numbernvarchar110
9FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)149ESRNRISR Subscriber Numbernvarchar110
10GLPOS_C_CTFI Document: Entry View104ESRNRISR Subscriber Numbernvarchar110
11GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items104ESRNRISR Subscriber Numbernvarchar110
12GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items104ESRNRISR Subscriber Numbernvarchar110
13GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items104ESRNRISR Subscriber Numbernvarchar110
14GLPOS_N_CTNew General Ledger: Line Item with Currency Type106ESRNRISR Subscriber Numbernvarchar110
15GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type106ESRNRISR Subscriber Numbernvarchar110
16P2RH_HU_MEMBP21MB23ESRNRISR Subscriber Numbernvarchar110
17P2RX_BTPayroll Results: Bank Transfers28ESRNRISR Subscriber Numbernvarchar110
18P2RX_BT_PERSONPayment-Related Information (Person)30ESRNRISR Subscriber Numbernvarchar110
19REGUPProcessed items from payment program72ESRNRISR Subscriber Numbernvarchar110
20T77PAYKZBTBank Transfer Table Image (BTKZ)45ESRNRISR Subscriber Numbernvarchar110
TOPAccounting Interface
21GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)231ESRNRISR Subscriber Numbernvarchar110
22GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)231ESRNRISR Subscriber Numbernvarchar110
TOPBusiness Partner
23TIVBPVENDORGENVendor Preassignment (General Data)15ESRNRISR Subscriber Numbernvarchar110
TOPCollectionsDisbursements
24VVSCPOSESRPayment Plan Item: ISR Attachment6ESRNRISR Subscriber Numbernvarchar110
TOPContract Accounts Receivable and Payable
25DFKKESRPOR Payment Supplement4ESRNRISR Subscriber Numbernvarchar110
26DPAY_CHEZAGZTF Switzerland: Assignment of POR Number to Document Number9ESRNRCharacter field of 9 digitsnvarchar90
TOPFinancial Accounting
27LFA1Vendor Master (General Section)32ESRNRISR Subscriber Numbernvarchar110
28VBSEGKDocument Segment for Vendor Document Parking88ESRNRISR Subscriber Numbernvarchar110
TOPFunds Management-Specific Postings
29PSOSEGKRecurring Request Document Segment, Vendors89ESRNRISR Subscriber Numbernvarchar110
TOPInformation System
30DKKOSBalance Audit Trail57ESRNRISR Subscriber Numbernvarchar110
31DKOKSOpen Item Account Balance Audit Trail Master Record60ESRNRISR Subscriber Numbernvarchar110
TOPInvoice Verification
32RBKPDocument Header: Invoice Receipt52ESRNRISR Subscriber Numbernvarchar110
33RBKPBInvoice Document Header (Batch Invoice Verification)47ESRNRObsolete: ISR subscriber number: do NOT usenvarchar110
TOPPayment Transactions
34FPRL_ITEMItem Data48ESRNRISR Subscriber Numbernvarchar110
35REGUP_COREProcessed Items from Payment Program31ESRNRISR Subscriber Numbernvarchar110
TOPPayroll
36T5T1LBank accounts of authorities (tax,insurance)12ESRNRISR Subscriber Numbernvarchar110
37T5TA1External transfers37ESRNRISR Subscriber Numbernvarchar110
38T5TPS1LBank accounts of authorities (tax,insurance)14ESRNRISR Subscriber Numbernvarchar110
39T5TSPOTable for convert bank accounts (Ceska Sporitelna)9ESRNRISR Subscriber Numbernvarchar110
40T7SI1LBank accounts of authorities (tax,insurance)9ESRNRISR Subscriber Numbernvarchar110
41T7SIA6Bank transfer - interface table21ESRNRISR Subscriber Numbernvarchar110
42T7SIBTVirman configuration (WT->Accounts)17ESRNRISR Subscriber Numbernvarchar110
43T7SIBUBank Units Slovenia8ESRNRPNR številka udeležencanvarchar110
44T7SK1LBank accounts of authorities (tax,insurance)15ESRNRISR Subscriber Numbernvarchar110
45T7SKA1External transfers37ESRNRISR Subscriber Numbernvarchar110
46T7SKEC0009Logovacia tabulka pre EURO konverziu - IT 000948ESRNRCíslo úcastníka PPRCnvarchar110
47T7SKEC0011Logovacia tabulka pre EURO konverziu - IT 001153ESRNRCíslo úcastníka PPRCnvarchar110
TOPPersonnel Administration
48PA0009HR Master Record: Infotype 0009 (Bank Details)45ESRNRISR Subscriber Numbernvarchar110
49PA0011HR Master Record: Infotype 0011 (Ext.Bank Transfers)50ESRNRISR Subscriber Numbernvarchar110
50PA0057HR Master Record: Infotype 0057 (Membership Fees)40ESRNRISR Subscriber Numbernvarchar110
51T521BPayee Keys22ESRNRISR Subscriber Numbernvarchar110
TOPRecruitment
52PB0009HR Master Record: Infotype 0009 (Bank Details)45ESRNRISR Subscriber Numbernvarchar110
TOPRemaining Beverage - Obsolete Objects
53/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1151ESRNRISR Subscriber Numbernvarchar110
TOPRussia
54T7RU1BPayee Keys of receiving orders (Russia standard)26ESRNRISR Subscriber Numbernvarchar110
TOPSAP Healthcare - Industry-Specific Components for Hospitals
55NWCH80IS-H CH: ELACH Datenempfang; Ablage Nachrichten feldweise16ESRNRIS-H CH: numero OPRnvarchar270