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

55 columns | Print definition?ERP 6.0  | LANDL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_RBKPDocument Header: Invoice Receipt59LANDLSupplying Countrynvarchar30
2BSAD_BAKAccounting: Secondary index for customers (cleared items)123LANDLSupplying Countrynvarchar30
3BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)63LANDLSupplying Countrynvarchar30
4BSEGAccounting Document Segment138LANDLSupplying Countrynvarchar30
5BSID_BAKAccounting: Secondary Index for Customers123LANDLSupplying Countrynvarchar30
6BSIK_BAKAccounting: Secondary index for vendors63LANDLSupplying Countrynvarchar30
7BSSEGAccounting Document Segment127LANDLSupplying Countrynvarchar30
8FUDT_VDOCBSEGVerification Document Item with Additional Info127LANDLSupplying Countrynvarchar30
9FUDT_VDOCBSEGEVVerification Document Item in the Entry View127LANDLSupplying Countrynvarchar30
10FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)127LANDLSupplying Countrynvarchar30
11GLPOS_C_CTFI Document: Entry View159LANDLSupplying Countrynvarchar30
12GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items159LANDLSupplying Countrynvarchar30
13GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items159LANDLSupplying Countrynvarchar30
14GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items159LANDLSupplying Countrynvarchar30
15GLPOS_N_CTNew General Ledger: Line Item with Currency Type161LANDLSupplying Countrynvarchar30
16GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type161LANDLSupplying Countrynvarchar30
17REGUPProcessed items from payment program66LANDLSupplying Countrynvarchar30
18TREAT_FLOW_PMTreasury: TREA Flow Payment Details16LANDLSupplying Countrynvarchar30
TOPAccounting Interface
19GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)128LANDLSupplying Countrynvarchar30
20GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)128LANDLSupplying Countrynvarchar30
TOPAgency Business Global Trade
21WBRKAgency business: Header73LANDLSupplying Countrynvarchar30
TOPAutomatic Payments
22PAYRQPayment Requests51LANDLSupplying Countrynvarchar30
TOPContract Accounts Receivable and Payable
23DFKKMOPItems in contract account document118LANDLCountry Supplied (for Tax Notifications)nvarchar30
24DFKKOPItems in contract account document118LANDLCountry Supplied (for Tax Notifications)nvarchar30
25DFKKOP_REPOpen Items from FPO4123LANDLCountry Supplied (for Tax Notifications)nvarchar30
26DPAYPPayment program - data on paid item53LANDLSupplying Countrynvarchar30
27FKKVKPContract Account Partner-Specific73LANDLCountry Supplied (for Tax Notifications)nvarchar30
TOPCross-Application Components
28BBSIDAccounting: Secondary index for customers123LANDLSupplying Countrynvarchar30
TOPData Retention Tool
29TXW_S_BSEGRetrieve BSEG from archive61LANDLSupplying Countrynvarchar30
TOPFinancial Accounting
30BSADAccounting: Secondary Index for Customers (Cleared Items)123LANDLSupplying Countrynvarchar30
31BSAKAccounting: Secondary Index for Vendors (Cleared Items)63LANDLSupplying Countrynvarchar30
32BSIDAccounting: Secondary Index for Customers123LANDLSupplying Countrynvarchar30
33BSIKAccounting: Secondary Index for Vendors63LANDLSupplying Countrynvarchar30
34VBSEGDDocument Segment for Customer Document Parking70LANDLSupplying Countrynvarchar30
35VBSEGKDocument Segment for Vendor Document Parking78LANDLSupplying Countrynvarchar30
36VBSEGSDocument Segment for Document Parking - G/L Account Database47LANDLSupplying Countrynvarchar30
TOPFunds Management-Specific Postings
37PSOSEGDDocument Segment: Recurring Request, Customer71LANDLSupplying Countrynvarchar30
38PSOSEGKRecurring Request Document Segment, Vendors79LANDLSupplying Countrynvarchar30
TOPGL Account Posting
39TCJ_DOCUMENTSCash Journal Documents (Header Data)37LANDLSupplying Countrynvarchar30
TOPInvoice Verification
40RBKPDocument Header: Invoice Receipt59LANDLSupplying Countrynvarchar30
41RBKPBInvoice Document Header (Batch Invoice Verification)54LANDLObsolete: supplying country: do NOT use!nvarchar30
TOPPayment Transactions
42FPRL_ITEMItem Data56LANDLSupplying Countrynvarchar30
43REGUPOLine item status before the 'n'th change15LANDLSupplying Countrynvarchar30
44REGUP_COREProcessed Items from Payment Program28LANDLSupplying Countrynvarchar30
TOPPublic Sector Contract Accounts Receivable and Payable
45TFICA_DEFSamples for Contract Account Types48LANDLCountry Supplied (for Tax Notifications)nvarchar30
TOPReal Estate Management
46VIAKBSEGDocument Line Item from SCS for Interface146LANDLSupplying Countrynvarchar30
TOPRemaining Beverage - Obsolete Objects
47/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1129LANDLSupplying Countrynvarchar30
TOPTransaction Manager
48OTC_CONV_FHAPOBackup Table for Financial Transaction Flows132LANDLSupplying Countrynvarchar30
49SLDT_FLOWSubledger Distributor Transactions75LANDLSupplying Countrynvarchar30
50TRDT_FLOWPersistent distributor flows73LANDLSupplying Countrynvarchar30
51VTBFHAPOTransaction Flow132LANDLSupplying Countrynvarchar30
52VTBFHAPO_MIGRMigrated Financial Flows132LANDLSupplying Countrynvarchar30
53VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows132LANDLSupplying Countrynvarchar30
54VTBZVPayment Details for Transaction29LANDLSupplying Countrynvarchar30
TOPTransfer to Financial Accounting
55TRACT_ACCITEMAccounting Items34LANDLSupplying Countrynvarchar30