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

50 columns | Print definition?ERP 6.0  | ZZUSERFLD3

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_PCACCProcurement Card: Accounting Data42ZZUSERFLD3Veinnvarchar220
2BBP_PCMODProcurement Card: Modified Statement Data44ZZUSERFLD3Veinnvarchar220
3BSEGAccounting Document Segment28ZZUSERFLD3Veinnvarchar220
4GLPOS_C_CTFI Document: Entry View387ZZUSERFLD3Veinnvarchar220
5GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items381ZZUSERFLD3Veinnvarchar220
6GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items381ZZUSERFLD3Veinnvarchar220
7GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items381ZZUSERFLD3Veinnvarchar220
8GLPOS_N_CTNew General Ledger: Line Item with Currency Type396ZZUSERFLD3Veinnvarchar220
9GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type390ZZUSERFLD3Veinnvarchar220
TOPAccounting Interface
10GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)369ZZUSERFLD3Veinnvarchar220
11GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)369ZZUSERFLD3Veinnvarchar220
TOPActual CostingMaterial Ledger
12MLCOMaterial valuation document account assignment information43ZZUSERFLD3Veinnvarchar220
TOPControlling
13COPPP_ITMCO Postprocessing List - Items95ZZUSERFLD3Veinnvarchar220
TOPElectronic Bank Statement
14FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)77ZZUSERFLD3Veinnvarchar220
15FEB_ACTAcct Assignment Templates77ZZUSERFLD3Veinnvarchar220
TOPExternal Services
16ESKNAccount Assignment in Service Package44ZZUSERFLD3Veinnvarchar220
TOPFinancial Accounting
17ACCRFIAccruals/Deferrals Master Data FI/CO Account Assignment23ZZUSERFLD3Veinnvarchar220
18ACCTITCompressed Data from FI/CO Document130ZZUSERFLD3Veinnvarchar220
19KMZEIFI: Account Assignment Model Item Information76ZZUSERFLD3Veinnvarchar220
20KOMUAccount Assignment Templates for G/L Account Items76ZZUSERFLD3Veinnvarchar220
21VBSEGADocument Segment for Document Parking - Asset Database82ZZUSERFLD3Veinnvarchar220
22VBSEGSDocument Segment for Document Parking - G/L Account Database133ZZUSERFLD3Veinnvarchar220
TOPFunds Management
23FMFG_SAV_FACTS1ASaved FACTS1A data for docs excluded from SL Repost for 60074ZZUSERFLD3Veinnvarchar220
24FMFG_SAV_FACTS2ASaved FACTS2A data for docs excluded from SL Repost for 60072ZZUSERFLD3Veinnvarchar220
25FMIAActual Line Item Table for Funds Management62ZZUSERFLD3Veinnvarchar220
26FMIFIITFI Line Item Table in Funds Management45ZZUSERFLD3Veinnvarchar220
27FMIOICommitment Documents Funds Management51ZZUSERFLD3Veinnvarchar220
28FMUSFGFACTS1A4Actual line item table74ZZUSERFLD3Veinnvarchar220
29FMUSFGFACTS2AActual line item table72ZZUSERFLD3Veinnvarchar220
30KBLPDocument Item: Manual Document Entry55ZZUSERFLD3Veinnvarchar220
TOPFunds Management-Specific Postings
31PSOSEGSRecurring Request Document Segment, G/L Accounts126ZZUSERFLD3Veinnvarchar220
TOPGeneral Ledger Accounting
32BSEG_ADDEntry View of Accounting Document for Additional Ledgers91ZZUSERFLD3Veinnvarchar220
33FAGL_SPLINFOSplittling Information of Open Items48ZZUSERFLD3Veinnvarchar220
TOPGL Account Posting
34TCJ_POSITIONSCash Journal Document Items84ZZUSERFLD3Veinnvarchar220
TOPGrantee Management
35GMIAActual Line Item Table86ZZUSERFLD3Veinnvarchar220
TOPInventory Management
36MSEGDocument Segment: Material134ZZUSERFLD3Veinnvarchar220
37MWXMSEGZMSEG: Interface for Posting of Value134ZZUSERFLD3Veinnvarchar220
38MWZMSEGZMSEG:Interface for Posting of Value134ZZUSERFLD3Veinnvarchar220
39RKPFDocument Header: Reservation45ZZUSERFLD3Veinnvarchar220
TOPInvoice Verification
40RBCODocument Item, Incoming Invoice, Account Assignment41ZZUSERFLD3Veinnvarchar220
TOPOverhead Cost Controlling
41COEPCO Object: Line Items (by Period)89ZZUSERFLD3Veinnvarchar220
42COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis91ZZUSERFLD3Veinnvarchar220
TOPPayment Transactions
43CRACCPayment Cards: Account Assignments in Card Master Record41ZZUSERFLD3Veinnvarchar220
44CRNUMPayment cards: Card master record62ZZUSERFLD3Veinnvarchar220
TOPProfitability Analysis
45CECOEPCO-PA Account Based Line Items91ZZUSERFLD3Veinnvarchar220
TOPPurchasing
46EBKNPurchase Requisition Account Assignment46ZZUSERFLD3Veinnvarchar220
47EKKNAccount Assignment in Purchasing Document49ZZUSERFLD3Veinnvarchar220
TOPReal Estate Management
48VIAKBSEGDocument Line Item from SCS for Interface15ZZUSERFLD3Veinnvarchar220
TOPRepetitive Manufacturing
49COMPMOVEGoods Movement of Components147ZZUSERFLD3Veinnvarchar220
TOPSimulation
50VSEBKN_CNVersion: Purchase requisition account assignment50ZZUSERFLD3Veinnvarchar220