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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

78 columns | Print definition?ERP 6.0  | KURSF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_RBKPDocument Header: Invoice Receipt16KURSFExchange ratedecimal95
2CE1PR22Périm. résultat IDES24KURSFCours de changedecimal95
3FIAPSAD_ORDR_HDOrder Number Header KSA22KURSFExchange ratedecimal95
4FIEUD_FIDOC_HSAFT: FI Transaction Document Header44KURSFExchange ratedecimal95
5FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items57KURSFExchange ratedecimal95
6FIEUD_MMINVTAXSAFT:MM: TAX Information for E-XML MM invoice for LU18KURSFExchange ratedecimal95
7FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice24KURSFExchange ratedecimal95
8FUDT_VDOCBKPFVerification Document Header23KURSFExchange ratedecimal95
9FUDT_VDOCBKPFHVerification Document Header(History)23KURSFExchange ratedecimal95
10GLPOS_C_CTFI Document: Entry View155KURSFExchange ratedecimal95
11GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items155KURSFExchange ratedecimal95
12GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items155KURSFExchange ratedecimal95
13GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items155KURSFExchange ratedecimal95
14GLPOS_N_CTNew General Ledger: Line Item with Currency Type157KURSFExchange ratedecimal95
15GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type157KURSFExchange ratedecimal95
16J_3RFRNDRATE_CLCRounded documents for cancellations5KURSFExchange ratedecimal95
17MEV_D_AD_ITEM_MMPeriod-End Valuation: Accruals Document Item MM25KURSFExchange ratedecimal95
18MEV_D_AD_ROOTPeriod-End Valuation: Accruals Document Root22KURSFExchange ratedecimal95
19MEV_D_WL_MMPeriod-end valuation: Worklist - Materials Management Data25KURSFExchange ratedecimal95
20VIXCESM180RECModelo 180 - Witholding Tax Recipients DMEE Line 0211KURSFExchange ratedecimal95
TOPAccounting Interface
21GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)455KURSFExchange ratedecimal95
22GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)455KURSFExchange ratedecimal95
TOPActual Payments and Forecast
23COFPDocument Lines (project cash management)40KURSFExchange ratedecimal95
TOPBasic Functions
24FEBEPElectronic Bank Statement Line Items64KURSFExchange rate (different from local currency)decimal95
TOPBasis Components
25ZDS400_BKPFBelegkopf für Buchhaltung23KURSFUmrechnungskursdecimal95
TOPCollectionsDisbursements
26VVKKCFRECCash Receipts to be Transferred to Claims System21KURSFExchange ratedecimal95
TOPContract Accounts Receivable and Payable
27DFKKMOPItems in contract account document40KURSFExchange ratedecimal95
28DFKKMOPKItems in contract account document19KURSFExchange ratedecimal95
29DFKKOPItems in contract account document40KURSFExchange ratedecimal95
30DFKKOPKItems in contract account document19KURSFExchange ratedecimal95
31DFKKOP_REPOpen Items from FPO444KURSFExchange ratedecimal95
32DFKKORDERPOSRequests: Items24KURSFExchange ratedecimal95
33DFKKORDERPOS_SRequest Templates: Items23KURSFExchange ratedecimal95
34DFKKRKReturns lot: Header data15KURSFExchange ratedecimal95
35DFKKRPReturns lot: Data for payment29KURSFExchange ratedecimal95
36DFKKRP3Returns: Manual Posting Specifications21KURSFExchange ratedecimal95
37DFKKRP3HReturns: History for Manual Posting Items17KURSFExchange ratedecimal95
38DFKKZKPayment lot: Header data13KURSFExchange ratedecimal95
39DFKKZPPayment lot: Data for payment23KURSFExchange ratedecimal95
40FKKBEPElectronic Bank Statement Line Items64KURSFExchange rate (different from local currency)decimal95
TOPCross-Application Components
41BKKPFAccounting document header23KURSFExchange ratedecimal95
TOPData Retention Tool
42TXW_S_BKPFRetrieve BKPF from archive18KURSFExchange ratenvarchar120
TOPFinancial Accounting
43ACCTCRCompressed Data from FI/CO Document - Currencies9KURSFExchange ratedecimal95
44AVIKPayment Advice Header43KURSFExchange rate (different from local currency)decimal95
45BKPFAccounting Document Header23KURSFExchange ratedecimal95
46EBKPFFin.Accntng Doc.Header (of Docs from Extern.Systems)24KURSFExchange ratedecimal95
47VBKPFDocument Header for Document Parking30KURSFExchange ratedecimal95
TOPFunds Management
48KBLKDocument Header: Manual Document Entry23KURSFExchange ratedecimal95
49KBLPSEarmarked Funds: Value Adjustment Documents22KURSFExchange ratedecimal95
TOPFunds Management-Specific Postings
50PSOKPFRecurring Request Document Header31KURSFExchange ratedecimal95
TOPGeneral Ledger Accounting
51BKPF_ADDAccounting Document Header23KURSFExchange ratedecimal95
TOPInformation System
52QSTREFI/HR Withholding Tax Report for Spain37KURSFExchange ratedecimal95
TOPInvoice Verification
53RBKPDocument Header: Invoice Receipt16KURSFExchange ratedecimal95
TOPInvoicing
54DEABPSCustomer change table: Logical view of BB amounts35KURSFExchange ratedecimal95
TOPLease Accounting
55FILA_GF_ITEMDATAProcess Data43KURSFExchange ratedecimal95
TOPLocalization
56IDEU_VATEU VAT Posting26KURSFExchange ratedecimal95
57J_3RF_REGINV_DEOutgoing invoice journal transp tab for IBOOK ver 220KURSFExchange ratedecimal95
58J_3RF_REGINV_KIncoming invoice journal transp tab for IBOOK15KURSFExchange ratedecimal95
TOPMulti Currency Accounting
59GLE_MCA_MI_RATESManual input exchanges rates6KURSFExchange ratedecimal95
TOPPayment Transactions
60REGUHSettlement data from payment program86KURSFExchange ratedecimal95
TOPPeriodical Sales and Distribution
61JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS40KURSFExchange ratedecimal95
TOPProfitability Analysis
62CE1850024KURSFExchange ratedecimal95
63CE1BGISErgebnisbereich für24KURSFUmrechnungskursdecimal95
64CE1E_B1Model Bank24KURSFExchange ratedecimal95
65CE1IDEAOp. Concern BR World24KURSFExchange ratedecimal95
66CE1IDEBErgebnisbereich IDES24KURSFUmrechnungskursdecimal95
67CE1IDESErgebnisbereich IDES24KURSFUmrechnungskursdecimal95
68CE1INT1Ergebnisbereich IDES24KURSFUmrechnungskursdecimal95
69CE1OC01Bike International24KURSFExchange ratedecimal95
70CE1R300Operating Concern IDES24KURSFExchange ratedecimal95
71CE1S001Sample operating concern24KURSFExchange ratedecimal95
72CE1S300Operating Concern IDES24KURSFExchange ratedecimal95
73CE1S_ALAirline Route Profit24KURSFExchange ratedecimal95
74CE1S_CPTemplate for Consumer Goods Industry24KURSFExchange ratedecimal95
75CE1S_GOQuickstart Template24KURSFExchange ratedecimal95
TOPReal Estate Management
76VIAKBKPFDocument Header from Service Charge Settlement for Interface11KURSFExchange ratedecimal95
TOPRecycling Administration Core Functions
77J_7LV1KREA Document: Header Data27KURSFExchange ratedecimal95
TOPRemaining Beverage - Obsolete Objects
78/BEV3/CH1030BKPFHeader Data for CH Event Ledger 0000103025KURSFExchange ratedecimal95