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

25 columns | Print definition?ERP 6.0  | RETPO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1SGT_SEGVAL_STGSegment Value Storage4RETPOReturns Itemnvarchar10
TOPAdditionals Management
2TWTCTRLControl table for procedures for additionals10RETPOReturns Itemnvarchar10
TOPAllocation
3AUBSIWorklist for PO (Follow-on Document Generation)36RETPOReturns Itemnvarchar10
4AUKAIWorklist for Sales Orders (FBG)28RETPOReturns Itemnvarchar10
5AUPOAllocation Table Document Item62RETPOReturns Itemnvarchar10
6AUUMIWorklist for Stock Transport Orders (Follow-on Doc. Gen.)34RETPOReturns Itemnvarchar10
7AUVDIWorklist for Deliveries (Follow-on Doc. Generation)48RETPOReturns Itemnvarchar10
8T620Allocation Table Document Types25RETPOReturns Itemnvarchar10
TOPBasic Functions
9T161SNAssignment of Serial Number Profile to Item Category6RETPOValidity for Returns Item (No, Yes, Both)nvarchar10
TOPCross-Application Components
10FRE_OP_ITEM_INF&R CON R/3 - Order Proposal Inbound Item Buffer15RETPOReturns Itemnvarchar10
11FRE_OP_PO_KEYKey-Completion F&R Order Proposal <-> R/3 Purchase Order10RETPOReturns Itemnvarchar10
TOPData Collection
12S270Do not use!49RETPOReturns Itemnvarchar10
13S270BIW1Do not use!49RETPOReturns Itemnvarchar10
14S270BIW2Do not use!49RETPOReturns Itemnvarchar10
TOPEmpties Management When Extension EA-CP Is Active
15/BEV1/NEINVITMEmpties Quantities and Values from Invoice Receipt24RETPOReturns Itemnvarchar10
TOPInventory Management
16MWXVM07MFields: Update Control of Module Pool SAPMM07M147RETPOReturns Itemnvarchar10
17MWZVM07MFields: Update Control of Module Pool SAPMM07M147RETPOReturns Itemnvarchar10
TOPInvoice Verification
18RBDRSEGBatch IV: Invoice Document Items38RETPOReturns Itemnvarchar10
19RBVDInvoice Document - Aggregation Data9RETPOReturns Itemnvarchar10
20RBVDMATInvoice Verification - Aggregation Data, Material6RETPOReturns Itemnvarchar10
TOPLogistics - General
21TB2BJTrading Contract: Item Categories5RETPOReturns Itemnvarchar10
TOPMedia Product Sales and Distribution
22TJKSDPORDERPOSItem Categories for Purchase Order5RETPOReturns Itemnvarchar10
TOPPOS Interface
23WVFBDRS Interface, Intermediate Buffer, Order Item FM61RETPOReturns Itemnvarchar10
TOPPurchasing
24EKPOPurchasing Document Item164RETPOReturns Itemnvarchar10
TOPVendor Evaluation
25ABS_IV_KEYFI_ITMAbsolute Key Figures at Item Level23RETPOReturns Itemnvarchar10