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

60 columns | Print definition?ERP 6.0  | ORDER_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_PORD_HDRProduction Order for Tracking17ORDER_TYPEOrder Typenvarchar40
2/MRSS/C_PLANSTATDetermination of 'Planned Status' of a demand'2ORDER_TYPEType of underlying order or operationnvarchar40
3/MRSS/C_TOBJ_INTCustomizing Table for Technical Object Integration2ORDER_TYPEType of underlying order or operationnvarchar40
4/MRSS/M_PREV_DELMirror for Prevent Deletion of Operations6ORDER_TYPEOrder Typenvarchar40
5/MRSS/M_R3_AFDMirror for Assignment follows Demand (ERP Addon)4ORDER_TYPEOrder Typenvarchar40
6/MRSS/M_RSG_AAMirror for Allow Abstract Assignment5ORDER_TYPEOrder Typenvarchar40
7/MRSS/M_RSG_DEASControl: Mirror for one own demand for each assignment4ORDER_TYPEOrder Typenvarchar40
8/MRSS/M_RSG_OITGMirror for Control of PM/CS Order Integration4ORDER_TYPEOrder Typenvarchar40
9/MRSS/M_RSG_SAMirror for extended assignments5ORDER_TYPEOrder Typenvarchar40
10/MRSS/M_RSG_STEFControl Keys for Production Resources/Tools in Resource Plng5ORDER_TYPEOrder Typenvarchar40
11/MRSS/M_RSG_ST_VMirror for Control-Key Default Values for PRT4ORDER_TYPEOrder Typenvarchar40
12/MRSS/M_SUPERVSRMirror for Site Supervisor Indicator4ORDER_TYPEOrder Typenvarchar40
13/MRSS/M_TRV_TIMEMirror for Customizing for travel times6ORDER_TYPEOrder Typenvarchar40
14/OEE/C_PRDMODEOTProduction Mode Associated Order Type3ORDER_TYPEOrder Typenvarchar40
15FIKZD_MAT_MOVECustomizing table for material movements12ORDER_TYPEOrder categorynvarchar20
16GHO_WELLCLASSWellclass table8ORDER_TYPEOrder Type for Maintenance Ordersnvarchar40
17ZCSM_SRVC_CATLOGcatalog for facility services10ORDER_TYPEOrder Typenvarchar40
TOPBrowser-Based PI Sheet Cockpit
18POC_DB_ARC_CONNOptical Archiving: Link Data (ArchiveLink)12ORDER_TYPEOrder categorynvarchar20
TOPCapacity and Resource Planning
19/MRSS/C_MOB_STATAssignment of Abstract Status to Plants (Mobile Integration)4ORDER_TYPEOrder Typenvarchar40
20/MRSS/C_RCT_NPRVDetermination of MRS relevance4ORDER_TYPEOrder Typenvarchar40
21/MRSS/C_SUPERVSRSite Supervisor Indicator2ORDER_TYPEOrder Typenvarchar40
22/MRSS/C_TRV_TIMECustomizing for travel times4ORDER_TYPEOrder Typenvarchar40
TOPCross-Application Components
23ALM_ME_ORDERTDEFMAM 1.0 Obsolete3ORDER_TYPEnvarchar40
24ALM_ME_PMILADEFMAM 1.0 Obsolete3ORDER_TYPEnvarchar40
25ALM_ME_STDEF1MAM 1.0 Obsolete3ORDER_TYPEnvarchar40
26ALM_ME_STDEF3MAM 1.0 Obsolete3ORDER_TYPEnvarchar40
TOPDocument Management Framework
27SKWF_APPLSKW Framework: Application Table2ORDER_TYPEKW Framework: Sort Sequencenvarchar10
28SKWF_PKGKW Framework: Packages16ORDER_TYPEKW Framework: Sort Sequencenvarchar10
TOPExcise Duty
29/BEV2/CS_C_ORDEROrder Types for EMCS Control2ORDER_TYPESales Document Typenvarchar40
TOPIntegration with Manufacturing Execution Systems
30TCOPODISTControl of Distribution of Production Orders to an MES3ORDER_TYPEOrder Type for Production Ordersnvarchar40
TOPMaintenance Orders
31/MRSS/C_FCHG_OBJObjects for Checking Field Changes3ORDER_TYPEDemand Categorynvarchar40
32/MRSS/C_NW_ABS_AExtended/Abstract assignments(Netweaver)2ORDER_TYPEType of underlying order or operationnvarchar40
33/MRSS/C_NW_AFDAssignment follows Demand (NW Addon)2ORDER_TYPEType of underlying order or operationnvarchar40
34/MRSS/C_NW_STR_AExtended/Stretched assignments(Netweaver)2ORDER_TYPEType of underlying order or operationnvarchar40
35/MRSS/C_NW_SUPVISite Supervisor Indicator(Netweaver)2ORDER_TYPEType of underlying order or operationnvarchar40
36/MRSS/C_NW_TRV_TCustomizing for travel times(Netweaver)3ORDER_TYPEType of underlying order or operationnvarchar40
37/MRSS/C_PREV_DELPrevent Deletion of Operations4ORDER_TYPEOrder Typenvarchar40
38/MRSS/C_R3_AFDAssignment follows Demand (ERP Addon)2ORDER_TYPEOrder Typenvarchar40
39/MRSS/C_RSG_AAAllow Abstract Assignment3ORDER_TYPEOrder Typenvarchar40
40/MRSS/C_RSG_DEASControl: one own demand for each assignment2ORDER_TYPEOrder Typenvarchar40
41/MRSS/C_RSG_OITGControl of PM/CS Order Integration2ORDER_TYPEOrder Typenvarchar40
42/MRSS/C_RSG_SAExtended assignments3ORDER_TYPEOrder Typenvarchar40
43/MRSS/C_RSG_STEFControl Keys for Production Resources/Tools in Resource Plng3ORDER_TYPEOrder Typenvarchar40
44/MRSS/C_RSG_ST_VControl-Key Default Values for Production Resources & Tools2ORDER_TYPEOrder Typenvarchar40
45/MRSS/C_SGU_SRTPFeatures of sort groups4ORDER_TYPEType of underlying order or operationnvarchar40
TOPMaintenance Processing
46ALM_ME_C012DEFDefine Order Type Profile3ORDER_TYPEOrder Type for Maintenance Ordersnvarchar40
47ALM_ORD_TYP_SDOrder Type Maintenance for Server Driven push of orders2ORDER_TYPEOrder Type for Maintenance Ordersnvarchar40
48MSAM_CORTYPDEFDetails for Order Type Profile3ORDER_TYPEOrder Type for Maintenance Ordersnvarchar40
TOPMaterials Management
49/ISDFPS/CRBAPRIOPriority Control for PM Order2ORDER_TYPEOrder Typenvarchar40
TOPMedia Product Sales and Distribution
50JKSENIPIS-M: Shipping Schedule12ORDER_TYPEIS-M: Sales Document Typenvarchar40
51TJORDERGENIS-M: Controls for Use of Copying Control3ORDER_TYPEOrder Sales Document Typenvarchar40
52TJSEORDERDESTIS-M: Control Table for Order Generation3ORDER_TYPESales Document Typenvarchar40
TOPPeriodical Sales and Distribution
53JVSOHIS-M/SD Shipping Order Header15ORDER_TYPEIS-M/SD: Sales Document Typesnvarchar40
54JVTMCP_HEADERIS-M: TMCP Issue11ORDER_TYPEIS-M/SD: Sales Document Typesnvarchar40
TOPProduction Orders
55COMPFOCM: Names of compared fields7ORDER_TYPEOrder categorynvarchar20
TOPSAP Multiresource Scheduling
56/MRSS/C_APPT_TYPAppointment booking type for PM/CS/CRM Order Types2ORDER_TYPEType of underlying order or operationnvarchar40
TOPStock Visibility
57/DSD/SV_RLD_ORDDSD SV: Reload Order Type Determination3ORDER_TYPESales Document Typenvarchar40
TOPTariffs, Duties and Permits
58OIH_J1B_SALBrazil: Check table for tax codes in sales process13ORDER_TYPESales Document Typenvarchar40
59OIH_J1B_SAL_2Brazil: ICMS Deferment10ORDER_TYPESales Document Typenvarchar40
TOPWaste Management
60EWA_ORDER_OBJECTItem Table for Waste Disposal Order41ORDER_TYPEProcessing of Waste Disposal Ordernvarchar20