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

61 columns | Print definition?ERP 6.0  | KNTTP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/SH_ASCATTable for ERP Search Help Account Assignmen Category4KNTTPAccount Assignment Categorynvarchar10
2CNVA_PCREA_GRIROGR/IR Items - Results (Level 2)28KNTTPAccount Assignment Categorynvarchar10
3T162KField Selection, Account Assignment Fields, Purchasing2KNTTPAccount Assignment Categorynvarchar10
4T163ACheck Item Category/Account Assignment Category3KNTTPAccount Assignment Categorynvarchar10
5WRRP_KNTP_SBKZRRP: Relevant KNNTP/SOBKZ for Rapid Replenishment2KNTTPAccount Assignment Categorynvarchar10
6ZEIM_AFPOOrder item24KNTTPAccount Assignment Categorynvarchar10
7ZEIM_LIPSSD document: Delivery: Item data115KNTTPAccount Assignment Categorynvarchar10
8ZEIM_VBAPSales Document: Item Data140KNTTPAccount Assignment Categorynvarchar10
TOPAccounting Interface
9GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)388KNTTPAccount Assignment Categorynvarchar10
10GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)388KNTTPAccount Assignment Categorynvarchar10
TOPBasic Functions
11TVEPSales Document: Schedule Line Categories18KNTTPAccount Assignment Categorynvarchar10
12VBBESales Requirements: Individual Records31KNTTPAccount Assignment Categorynvarchar10
TOPControlling
13IAOM_OM_CSCControlling Scenario for Determination in OM7KNTTPAccount Assignment Categorynvarchar10
TOPCross-Application Components
14VVBAPSales Document: Item Data140KNTTPAccount Assignment Categorynvarchar10
TOPData Retention Tool
15TXW_S_EKPORetrieve EKPO from archive10KNTTPAccount Assignment Categorynvarchar10
TOPDefense Forces and Public Security
16/ISDFPS/ZEBANCopy of EBAN36KNTTPAccount Assignment Categorynvarchar10
TOPDemand Management
17PBIDPlanned independent requirements index: MRP area28KNTTPAccount Assignment Categorynvarchar10
18PBIMIndependent Requirements for Material26KNTTPAccount Assignment Categorynvarchar10
19T459KControl table for customer requirements7KNTTPAccount Assignment Categorynvarchar10
TOPExternal Services
20ESSRService Entry Sheet Header Data37KNTTPAccount Assignment Categorynvarchar10
21TMP_SPECModel Service Specifications20KNTTPAccount Assignment Categorynvarchar10
TOPFreight Processing
22TVFTShipment Cost Item Categories8KNTTPAccount Assignment Categorynvarchar10
23VFKPShipment Costs: Item Data33KNTTPAccount Assignment Categorynvarchar10
TOPFunctions for U.S. Federal Government
24FMFG_VEKPOJFMIP: Pending PO Line Item Changes Table10KNTTPAccount Assignment Categorynvarchar10
25TFMFG_MM_AACTDocument Type for Account Assignment Category2KNTTPAccount Assignment Categorynvarchar10
TOPFunds Management
26FMFGAPAACAccount Assignment Categories for Acc. Property2KNTTPAccount Assignment Categorynvarchar10
TOPInventory Management
27MWZDM07M1ZDM07M154KNTTPAccount Assignment Categorynvarchar10
28RESBReservation/dependent requirements94KNTTPAccount Assignment Categorynvarchar10
TOPInvoice Verification
29RBDRSEGBatch IV: Invoice Document Items26KNTTPAccount Assignment Categorynvarchar10
30RSEGDocument Item: Incoming Invoice25KNTTPAccount Assignment Categorynvarchar10
TOPKANBAN
31TPK02Key for Controlling Control Cycle: External Replenishment20KNTTPCost Center Account Assignment Categorynvarchar10
TOPLogistics - General
32TB2BJTrading Contract: Item Categories19KNTTPAccount Assignment Categorynvarchar10
TOPMaster Data
33MDSMSimulative dependent requirements87KNTTPAccount Assignment Categorynvarchar10
34PLAFPlanned Order21KNTTPAccount Assignment Categorynvarchar10
35PSPLIndex project -> planned order4KNTTPAccount Assignment Categorynvarchar10
36T460COrder/Purchase order types for planned order7KNTTPAccount Assignment Categorynvarchar10
TOPMaterials Management
37/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions41KNTTPAccount Assignment Categorynvarchar10
TOPPOS Interface
38WVFBDRS Interface, Intermediate Buffer, Order Item FM37KNTTPAccount Assignment Categorynvarchar10
TOPProduction Orders
39AFPOOrder item24KNTTPAccount Assignment Categorynvarchar10
TOPPurchasing
40EBANPurchase Requisition36KNTTPAccount Assignment Categorynvarchar10
41EKCPHPurchasing Contract Commitment Plan Header Information8KNTTPAccount Assignment Categorynvarchar10
42EKPOPurchasing Document Item51KNTTPAccount Assignment Categorynvarchar10
43MEREQXPurchase Requisition Change Parameter36KNTTPUpdated information in related user data fieldnvarchar10
44T163ITexts for Account Assignment Categories3KNTTPAccount Assignment Categorynvarchar10
45T163KAccount Assignment Categories in Purchasing Document2KNTTPAccount Assignment Categorynvarchar10
46T163KSAssignment of Tax Indicator to Account Assignment Category2KNTTPAccount Assignment Categorynvarchar10
47WDFR_DISPPerishables Planning Header109KNTTPAccount Assignment Categorynvarchar10
48WDFR_POSPerishables Planninng Item86KNTTPAccount Assignment Categorynvarchar10
TOPQuality Inspection
49QALSInspection lot record180KNTTPAccount Assignment Categorynvarchar10
TOPRemaining Beverage - Obsolete Objects
50/BEV1/RBVBAPSales Document: Item Data140KNTTPAccount Assignment Categorynvarchar10
TOPRouting
51PLMZAllocation of bill of material items to operations43KNTTPAccount Assignment Categorynvarchar10
TOPSales
52VBAPSales Document: Item Data140KNTTPAccount Assignment Categorynvarchar10
TOPSelf-Service Procurement
53/SRMERP/D_SC_ITMShopping Cart Item35KNTTPAccount Assignment Categorynvarchar10
TOPShipping
54LIPSSD document: Delivery: Item data115KNTTPAccount Assignment Categorynvarchar10
TOPSimulation
55VSAFPO_CNVersion: Order items in PP orders25KNTTPAccount Assignment Categorynvarchar10
56VSEBAN_CNVersion: Purchase requisition37KNTTPAccount Assignment Categorynvarchar10
57VSPLAF_CNVersion: Planned order22KNTTPAccount Assignment Categorynvarchar10
58VSRESB_CNVersion: Reservation/Dependent requirements95KNTTPAccount Assignment Categorynvarchar10
59VSVBAP_CNVersion: Sales document: Item data141KNTTPAccount Assignment Categorynvarchar10
TOPTraders and Schedulers Workbench
60OIJ_RU_SERVGROUPCarrier Service Groups4KNTTPAccount Assignment Categorynvarchar10
TOPWaste Management
61EHSWAC_ENTAMBWParameters for Purchasing Management6KNTTPAccount Assignment Categorynvarchar10