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

67 columns | Print definition?ERP 6.0  | BATCH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/FLDQ/AD_HNAPROC`3BATCHnvarchar10
2BWSD_CONFH19BATCHnvarchar10
3BWSD_LOGHHeader Data of Transfer Log19BATCHSingle-Character Indicatornvarchar10
4CNVA_00555_ANAAnalysis details for Run Time Estimation15BATCHNumber of Active Background Work Processesint100
5CNVC_BASLOGCNVC_BASLOG7BATCHBackground Processing Activenvarchar10
6CNVPERFDATATable for database performance27BATCH2 byte integer (signed)smallint50
7FMBASOBJNR_TRACETrace for table FMBASOBJNR21BATCHBackground Processing Activenvarchar10
8FMFGT_SS04_EXCPayment Statistical Sampling - Lot Certification Exceptions3BATCHLot Number for Documentsnvarchar100
9FUDT_VDOCBKPFVerification Document Header102BATCHLot Number for Documentsnvarchar100
10FUDT_VDOCBKPFHVerification Document Header(History)102BATCHLot Number for Documentsnvarchar100
11GLPOS_C_CTFI Document: Entry View332BATCHLot Number for Documentsnvarchar100
12GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items326BATCHLot Number for Documentsnvarchar100
13GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items326BATCHLot Number for Documentsnvarchar100
14GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items326BATCHLot Number for Documentsnvarchar100
15GLPOS_N_CTNew General Ledger: Line Item with Currency Type341BATCHLot Number for Documentsnvarchar100
16GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type335BATCHLot Number for Documentsnvarchar100
17REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)48BATCHBatch Numbernvarchar100
18SWF_UNIT_MONWorkflow: Unit Monitoring13BATCHBackground Processing Activenvarchar10
19TZTXTS01Word processing: Form letters10BATCHIs the document created in the background (not online) ?nvarchar10
20WGDS_TI_ITEMPricat Storage for TI related Simple Attributes21BATCHBatch Numbernvarchar100
21ZPHTRIALTABIBS Pharma: Randomization table for clinical trials6BATCHBatch Numbernvarchar100
22ZPH_RESS_STATUSStatus table for resources (Logbook)8BATCHPrepack numbernvarchar180
23/BOBF/D_CC_LOG_HBOPF Contract Compliance Check Log header12BATCHBackground Processing Activenvarchar10
TOPAccounting Interface
24GLE_RUNADM_IDERP Run Administration12BATCHBackground Processing Activenvarchar10
TOPAdvertising Management
25JHAGAPIS-M/AM: Sales Agent Determination Log11BATCHBackground Processing Activenvarchar10
26JHTAKIS-M/AM: Settlement Run Sales Document Header23BATCHIS-M: Batch Indicatornvarchar10
TOPBasic Data
27TNCDF3IS-H: DRG Coding and Grouping System User Customizing Table5BATCHIS-H: Indicator that Entry is Relevant for Background Proc.nvarchar10
TOPBasic Functions
28FEBEPElectronic Bank Statement Line Items62BATCHBatch number (bundle number)nvarchar30
29T800HISTHLog Tables for Program Runs in FI-GL or FI-SL: Header8BATCHBackground Processing Activenvarchar10
30VBSKCollective Processing for a Sales Document Header18BATCHIndicator: Processing in backgroundnvarchar10
TOPBrowser-Based PI Sheet Cockpit
31POC_DB_ARC_CONNOptical Archiving: Link Data (ArchiveLink)18BATCHBatch Numbernvarchar100
TOPCATT Computer Aided Test Tool
32CATACATT: General Test Procedure Data17BATCHCATT - Background flagnvarchar10
TOPConfiguration management
33IBSPCMIB: Config.Mang.: Specialization15BATCHBatch Numbernvarchar100
TOPContract Accounts Receivable and Payable
34FKKBEPElectronic Bank Statement Line Items62BATCHBatch number (bundle number)nvarchar30
TOPData Staging
35RSMONRQTABMonitor table for request IDocs3BATCHIndicates whether used in the backgroundnvarchar10
TOPDSD Connector
36/DSD/ME_COCI_ITMDSD CN: Check-Out Check-In Items12BATCHBatch Numbernvarchar100
37/DSD/ME_DEL_ITMDSD CN: Delivery Items37BATCHBatch Numbernvarchar100
TOPFinancial Accounting
38BKPFAccounting Document Header104BATCHLot Number for Documentsnvarchar100
TOPFunds Management
39FMFGT_SS01Payment Statistical Sampling Process Activation table3BATCHLot Number for Documentsnvarchar100
TOPGlobal Trade
40WB2_D_COMSUBTrading Contract: commodity sub items28BATCHBatch Numbernvarchar100
41WB2_D_SHD_ITEMShadow Items18BATCHBatch Numbernvarchar100
TOPInstalled Base
42IBSPIB: Installed Base Component - Enhancement/Specialization15BATCHBatch Numbernvarchar100
TOPInventory Accounting
43UAINVDEBCRHDocument for Revaluation Through Material Debit/Credit8BATCHBackground Processing Activenvarchar10
44UAINVREVALHDocument for INV Price Change and Inventory Revaluation10BATCHBackground Processing Activenvarchar10
TOPJoint Venture und Production Sharing Accounting
45T8J4ACash Call Header table3BATCHJV Cash Call Batch Numbernvarchar100
46T8J4BJV Cash Call Batch table3BATCHJV Cash Call Batch Numbernvarchar100
TOPLegacy System Migration Workbench
47/SAPDMC/LSGUSDFILSMW Files Used11BATCHBackground Processing Activenvarchar10
TOPliveCache
48LCINIT_LOGLog Entries: Start/Stop/Init of Prep./Postprocessing Reports4BATCHliveCache flagnvarchar10
TOPliveCache Applications
49LCA_WARNINGSWarnings in the "liveCache Applications" Area13BATCHBackground Processing Activenvarchar10
TOPMaterials Management
50/ISDFPS/REO_PLANPlanned Transfer Postings for Reorganizations9BATCHBatch Numbernvarchar100
TOPPeriodical Sales and Distribution
51JFSKIS-M/SD: Sales Document - Collective Processing for Header9BATCHBATCH Runnvarchar10
TOPProfit Center Accounting
52KE1_WU_RUNIDPCA Where-Used List: Runs13BATCHBackground Processingnvarchar10
TOPRemaining Beverage - Obsolete Objects
53/BEV3/CHANCHTARTContract Statement Message Types10BATCHBulk and Background Processing Modenvarchar10
54/BEV3/CHASTEUERControl Data for Each Message18BATCHBulk and Background Processing Modenvarchar10
55/BEV3/CHCIVBSKSales Document Collective Run Header CH Billing Documents18BATCHIndicator: Processing in backgroundnvarchar10
TOPResourcen Management
56RMXTT_TRIAL_HDTrial: Header Data9BATCHBatch Numbernvarchar100
TOPSales Plan
57LISRPlanning Object Index for Forecast11BATCHSingle-Character Indicatornvarchar10
TOPSAP Business Workflow
58SWZAIENTRYObject Table for Work Queues (Entries)6BATCHFlag whether line in work queue can run in backgroundnvarchar10
59WFERRWorkflow: Error in processes12BATCHBackground Processing Activenvarchar10
TOPSAP Retail Store
60WGMP_SRSItems for SRS PDC Goodsmovement13BATCHBatch Numbernvarchar100
TOPStructures Workbench
61/ISDFPS/FDP_WFSTWorkflow Status for Cross-System Material Requisitions26BATCHBatch Numbernvarchar100
62/ISDFPS/MATSPPLNMaterials Planned for Force Element16BATCHBatch Numbernvarchar100
63/ISDFPS/PSPMATWBS Materials to Be Excluded from Authorized/Actl Comparison4BATCHBatch Numbernvarchar100
64/ISDFPS/STOCK_MVBackground Relocation Stocks to Be Transferred6BATCHBatch Numbernvarchar100
TOPTask Resource Management
65LGTKATask actual execution data log14BATCHBatch numbernvarchar100
TOPUS Prompt Payment Act
66FMFGT_SS04Payment Statistical Sampling Proc. Batch/certify Dates3BATCHLot Number for Documentsnvarchar100
TOPWorkbench Tools Editors, Painters, Modelers
67DELWBCROSSFind Type Group Deletion8BATCHBackground Processing Activenvarchar10