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

90 columns | Print definition?ERP 6.0  | WERK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/TT_DATATest Data for SRM Test Tool10WERKPlantnvarchar40
2/SMERP/STG_PM001Data staging - Equipment complex table51WERKPlantnvarchar40
3/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab51WERKPlantnvarchar40
4CCGLT_PR_HDR_UT2EHS: Print Request Header Table Test Data for Unit Test35WERKPlant or Shipping Pointnvarchar40
5TMS_C_STOHOLSTO: Handover Loc depending on supply. plant & receiv. plant3WERKPlantnvarchar40
6YMESSMesswerte3WERKWerknvarchar40
7ZAC99000Senderstruktur AC990006WERKnvarchar40
8ZDG30SD data generation table8WERKPlantnvarchar40
9ZDG40Table for Data Generation (Repetitive Manufacturing)9WERKPlantnvarchar40
10ZID_KREDICATTBasis Data for CATT zid_apowe2WERKPlantnvarchar40
11ZMAPPSD-Material Table for Data Generation7WERKPlantnvarchar40
12ZPH_RESS_STATUSStatus table for resources (Logbook)3WERKPlantnvarchar40
13ZPR11MM Organization Profile5WERKPlantnvarchar40
TOPABAP List-Based PI Sheet
14COCHPPI sheet: Control Recipe Header3WERKPlantnvarchar40
15COMHPPI Sheet: Message Header3WERKPlantnvarchar40
16COVLPPI Sheet: Current Variable Values12WERKPlantnvarchar40
TOPBasic Data
17TQREOQM: Archiving Parameter2WERKPlantnvarchar40
TOPBasic Functions
18T313YILN for SSCC Generation at Storage Location Level2WERKPlantnvarchar40
TOPConstruction Equipment Management
19J_3GEIVERSOwner/Administrator Master Record13WERKPlantnvarchar40
TOPData Collection
20S068ES068 - Structural Information6WERKPlantnvarchar40
21S069Material Statistics10WERKPlantnvarchar40
22S069ES069 - Structural Information5WERKPlantnvarchar40
23S072Individual Records for Inspection Lot15WERKPlantnvarchar40
24S104Customer Statistics11WERKPlantnvarchar40
25S104ES104 - Structural Information6WERKPlantnvarchar40
26S161Inspection Results: General15WERKPlantnvarchar40
27S162Quantitative Inspection Results15WERKPlantnvarchar40
28S163Quantitative Inspection Result: Vendor16WERKPlantnvarchar40
29S164Quantitative Inspection Result: Vendor16WERKPlantnvarchar40
30S165Inspection Results (General): Customers16WERKPlantnvarchar40
31S166Quantitative Inspection Results: Customer16WERKPlantnvarchar40
TOPEquipment
32EQUIEquipment master data46WERKPlantnvarchar40
TOPInformation System
33S068Vendor statistics11WERKPlantnvarchar40
34S161ES161 - Structural information10WERKPlantnvarchar40
35S162ES162 - Structural information10WERKPlantnvarchar40
36S163ES163 - Structural information11WERKPlantnvarchar40
37S164ES164 - Structural information11WERKPlantnvarchar40
38S165ES165 - Structural information11WERKPlantnvarchar40
39S166ES166 - Structural information11WERKPlantnvarchar40
TOPIntegrated Product and Process Engineering
40PROFILCUST01iPPE: Profile for PS iPPE Interface4WERKPlantnvarchar40
TOPLogistics - General
41CHALCCustomizing table for Swiss alcohol processing2WERKPlantnvarchar40
42OIJTSTransport system (IS-Oil TSW standard/core object )14WERKTransport system In-transit Plantnvarchar40
TOPMain Process
43/VSO/M_MSG_STATAssignment Message to Status for VSO2WERKPlantnvarchar40
44/VSO/M_PROF_W_SAssignment VSO Profile to Plant and Shipment Type2WERKPlantnvarchar40
TOPMedia Product Sales and Distribution
45JVSDSPLITIS-M: Media Issue Mix6WERKPlantnvarchar40
46JVSDSPLITPLANIS-M: Issue Split (Planned)6WERKPlantnvarchar40
47JVSDSPLITSUBIS-M: Issue Split for Lower Level Issues7WERKPlantnvarchar40
48JVTPACKGROUPIS-M: Common Odd Bundle Group4WERKPlantnvarchar40
TOPMobile Applications
49/ISDFPS/LOADOBJ2Storage Types per Plant for Mobile Application3WERKPlantnvarchar40
TOPPeriodical Sales and Distribution
50JRENQABLGIS7WERKPlantnvarchar40
51JVTANN00IS-M: Technical Order Deadline Limit6WERKPlantnvarchar40
52JVTANNSTATIS-M/SD: Status Table for Order Finalization Deadline6WERKPlantnvarchar40
53JVTASTAT01IS-M/SD: Supplements to Shipping Status6WERKPlantnvarchar40
54JVTFRGLARTIS-M/SD: Determination of Postal Packing Rule3WERKPlantnvarchar40
55JVTPACKGROUPFILTIS-M: Common Odd Bundle Group (Allowed Plants/Del. Types)3WERKPlantnvarchar40
56JVTPSHFINDIS-M/SD: Production Procedure Determination2WERKPlantnvarchar40
57JVTVERVARIIS-M/SD: Variant for Shipping Schedule3WERKPlantnvarchar40
58TJD53IS-M/SD: Bundling Group3WERKPlantnvarchar40
59TJD54IS-M/SD: Edition Bundling Group (Texts)4WERKPlantnvarchar40
60TJVTMCIIS-M: Customizing of Shipping Orders for TMCI2WERKPlantnvarchar40
TOPProcess Management
61COCHProcess Management: Control Recipe Header3WERKPlantnvarchar40
62COMHPP-PI: Header Data for Process Messages3WERKPlantnvarchar40
63COMHRProcess Message Record: Message Header Data3WERKPlantnvarchar40
64COREProcess Mgmt.: Display Characteristics of the Eval. Version2WERKPlantnvarchar40
65CORPProcess Management: Evaluation Versions2WERKPlantnvarchar40
66TC52ACustomizing of Process Instruction Positions in PI Sheet2WERKPlantnvarchar40
TOPProduct Cost Planning
67TCK29Partner Versions for Group Costing5WERKPartner Plantnvarchar10
TOPProfit Center Accounting
68PATNPartner number/organizational unit4WERKPlantnvarchar40
TOPQM Control in Procurement
69QINFQM-info record for material and vendor9WERKPlantnvarchar40
TOPQuality Inspection
70QALSInspection lot record3WERKPlantnvarchar40
TOPResults Recording
71TQ86AAssignment report category for work center2WERKPlantnvarchar40
72TQEC30Settings for Copy Inspection Results Function/Operation UD3WERKPlantnvarchar40
TOPSample Management
73TQREOSQM: Archiving Parameter(s) for Physical Samples2WERKPlantnvarchar40
TOPSamples and SPC
74QASHQuality control chart5WERKPlantnvarchar40
TOPSCM Basis
75CIFBALSELApplication Log: CIF Extension for Log Selection8WERKPlantnvarchar40
TOPSerial Numbers
76EQSESerial Number Records11WERKPlantnvarchar40
77SER03Document Header for Serial Numbers for Goods Movements16WERKPlantnvarchar40
78SER07Document Header for Serial Numbers in Physical Inventory7WERKPlantnvarchar40
79SER08Document Header for Purchase Order Item Serial Numbers10WERKPlantnvarchar40
80SER09Doc. Header for Serial Numbers for Purchase Requisition Item9WERKPlantnvarchar40
81SERISerial Numbers10WERKPlantnvarchar40
TOPTraders and Schedulers Workbench
82OIJBERMATAssignment of material to berths4WERKPlantnvarchar40
83OIJNOMHNomination Header65WERKTransport system In-transit Plantnvarchar40
84OIJNOMHVERSNomination Header Version Table58WERKTransport system In-transit Plantnvarchar40
85OIJRRAOIL-TSW: Partner roles4WERKPlantnvarchar40
86OIJ_RU_RRAPartners Master Data (Russia)4WERKPlantnvarchar40
TOPTransformation
87RMXMC_T17Assignment: Control Recipe Destination to Resource2WERKPlantnvarchar40
TOPWaste Management
88EHSWAT002MD (BDT): Waste Generation/Disposal/Transport30WERKPlant for Storage Locationnvarchar40
89EWA_CCOC_ASS_REAllocate CO and Container (Rent)4WERKMaintenance plantnvarchar40
90EWA_ORDER_HEADHeader Table for Waste Disposal Order38WERKPlantnvarchar40