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  | RESWK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)22RESWKnvarchar40
2/BIC/B0000188000PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header)23RESWKnvarchar40
3/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line22RESWKnvarchar40
4/GBT/O_PURO_HDRPurchasing Document19RESWKSupplying (Issuing) Plant in Case of Stock Transport Ordernvarchar100
5SGT_SEGVALSegmentation Value for Supplying Plants5RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
6SGT_SEGVAL_PRSegmentation Value for Supplying Plants4RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
7T161VShipping-Specific Data for Stock Tfr. for Purch. Doc. Type4RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
8TMKSUCalculation Schema: Purchasing: for Stock Transfer4RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
9TMS_C_STOHOLSTO: Handover Loc depending on supply. plant & receiv. plant2RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPAdvanced Returns Management
10MSR_D_EXECUTEDAdvanced Returns Management # Tracking of Executed Steps23RESWKPlantnvarchar40
11MSR_D_PLANNEDAdvanced Returns Management - Next Sequences8RESWKPlantnvarchar40
TOPBasic Functions
12VETVGDelivery Due Index for Stock Transfer25RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPConditions
13A518Limit value determination for stock transport order4RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPConsumption-Based Planning See Also PP-MRP
14WDRDDelivery Relationships: Recipients per Plant and Material2RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
15WDRD_EXTWGDelivery Relationships: Recipients per Plant and Material2RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPCross-Application Components
16EEORDPurchasing Source List14RESWKPlant from Which Material is Procurednvarchar40
TOPData Collection
17S270Do not use!40RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
18S270BIW1Do not use!40RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
19S270BIW2Do not use!40RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
20S271Do not use!30RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
21S271BIW1Do not use!30RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
22S271BIW2Do not use!30RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
23S275Transfer BW: Einkaufsdaten38RESWKLeverende vestiging bij transportbestellingnvarchar40
24S275BIW1S275BIW1 * Transfer to BW: Purchasing Data38RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
25S275BIW2S275BIW2 * Transfer to BW: Purchasing Data38RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPData Retention Tool
26TXW_S_EKKORetrieve EKKO from archive13RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPDefense Forces and Public Security
27/ISDFPS/ZEBANCopy of EBAN24RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPInventory Management
28MWZDM07M2ZDM07M234RESWKPlantnvarchar40
TOPLogistics - General
29WBHDTrading Contract: Commercial Data65RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPMaterials Management
30/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions29RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPPOS Interface
31WVFBDRS Interface, Intermediate Buffer, Order Item FM18RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPPurchasing
32EBANPurchase Requisition24RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
33EBUBIndex for Stock Transport Requisitions for Material3RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
34EKKIPurchasing Condition Index5RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
35EKKOPurchasing Document Header45RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
36EKUBIndex for Stock Transport Orders for Material3RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
37EORDPurchasing Source List14RESWKPlant from Which Material is Procurednvarchar40
38MEREQXPurchase Requisition Change Parameter24RESWKUpdated information in related user data fieldnvarchar10
39T024W_CCPPlant/Supplying Plant Assignment for Extended Source Determ.4RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
40T161VNShipping-Rel. Data f. Stck Transfer f. PO Doc.Type f. St.Loc4RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
41T161WOrder Types for Stock Transfer2RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPRemote Logistics Management
42OIO_CM_OPLNTPlants relevant to RLM4RESWKDefault supplying plantnvarchar40
TOPSelf-Service Procurement
43/SRMERP/D_SC_ITMShopping Cart Item63RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPSimulation
44VSEBAN_CNVersion: Purchase requisition25RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPTariffs, Duties and Permits
45A444Two-step transfer with tracking sign5RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
46OIH09Excise duty defaults for Stock Transfers7RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
47OIH30HTracking header7RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
TOPTraders and Schedulers Workbench
48OIJ_EL_DOC_I_REFDocument item reference to nomination23RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
49S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object34RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40
50TOI0_REL_MMRelevance customizing for MM Documents24RESWKSupplying (Issuing) Plant in Stock Transport Ordernvarchar40