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

77 columns | Print definition?ERP 6.0  | EVENT_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD020MIItems for Class SD02 - Raw Data19EVENT_TYPEFulfillment Event Typenvarchar20
2/1RA/0SD022MIItems for Class SD02 - Processable20EVENT_TYPEFulfillment Event Typenvarchar20
3/1RA/0SD024MIItems for Class SD02 - Processed22EVENT_TYPEFulfillment Event Typenvarchar20
4/GBTINT/EVCONGBT: Connectors per Event2EVENT_TYPEObject Type for Eventsnvarchar30
5/GBTINT/EVENTGBT: Collection of Tracking Events for GBT2EVENT_TYPEObject Type for Eventsnvarchar30
6/GBTINT/EVHUSGBT: Handling Units related to MDoc / WM TO2EVENT_TYPEObject Type for Eventsnvarchar30
7/SDF/IVISEVTMAINEvents persistency7EVENT_TYPEnvarchar600
8BBP_PDSDLNBusiness Transaction Item - Schedule Line11EVENT_TYPEDate Typenvarchar120
9DYNABAPHDRHeader Table for Dynamic ABAP Coding7EVENT_TYPEEvent Type for Dynamic ABAP Codingnvarchar20
10FARR_C_EVNT_TYCustomizing of Event Type2EVENT_TYPEFulfillment Event Typenvarchar20
11FARR_C_EVNT_TY_TText Table of Event Type3EVENT_TYPEFulfillment Event Typenvarchar20
12FARR_C_POB_TYPEConfiguration of Performance Obligation Types5EVENT_TYPEFulfillment Event Typenvarchar20
13FARR_D_DEFERRALDeferrals8EVENT_TYPEFulfillment Event Typenvarchar20
14FARR_D_DEFITEMDeferral item table7EVENT_TYPEFulfillment Event Typenvarchar20
15FARR_D_FULFILLMTFulfillment Entries11EVENT_TYPEFulfillment Event Typenvarchar20
16FARR_D_LEGACYLegacy data for initial load of revenue accounting items13EVENT_TYPEFulfillment Event Typenvarchar20
17FARR_D_POBPerformance Obligation19EVENT_TYPEFulfillment Event Typenvarchar20
18GHO_DM_EVENTDeferment Event Data9EVENT_TYPEDeferment Event Typenvarchar10
19GHO_EVT_SRC_DATATable to store deferment events souce data used in alloc run16EVENT_TYPEDeferment Event Typenvarchar10
20GRFNEVENTEvent3EVENT_TYPEEvent Typenvarchar400
21GRFNEVENTTYPETEvent Type Text2EVENT_TYPEEvent Typenvarchar400
22GRFNEVTFIELDEvent Fields2EVENT_TYPEEvent Typenvarchar400
23GRFNEVTFIELDTEvent field description2EVENT_TYPEEvent Typenvarchar400
24GRFNEVTMETAEvent Type Metadata2EVENT_TYPEEvent Typenvarchar400
25GRFNEVTMETATEvent definition text2EVENT_TYPEEvent Typenvarchar400
26PYD_D_DAE_EREGPYDS: Scheduling Event Registry3EVENT_TYPEPayroll Data Source Framework: Scheduling Event Typenvarchar300
27PYD_D_DAE_ETPYDS: Scheduling Use Case Event Type2EVENT_TYPEPayroll Data Source Framework: Scheduling Event Typenvarchar300
28PYD_D_DAE_ETPPYDS: Scheduling Use Case Event Type Parameter Type2EVENT_TYPEPayroll Data Source Framework: Scheduling Event Typenvarchar300
29PYD_D_DAE_ETTPYDS: Scheduling Use Case Event Type Text3EVENT_TYPEPayroll Data Source Framework: Scheduling Event Typenvarchar300
30PYD_D_DAE_REGPYDS: Scheduling Use Case Registry5EVENT_TYPEPayroll Data Source Framework: Scheduling Event Typenvarchar300
31PYD_D_DAE_UCDPYDS: Scheduling Use Case Definition6EVENT_TYPEPayroll Data Source Framework: Scheduling Event Typenvarchar300
32T7BREFDMEVENTSCode mapping for EFD2EVENT_TYPEeSocial event typenvarchar40
33T7BREFDMEVENTTText for code mapping for EFD3EVENT_TYPEeSocial event typenvarchar40
34T7BREFD_EVENTEvents3EVENT_TYPEeSocial event typenvarchar40
35T7BREFD_EVTOGENControl table of events to be generated3EVENT_TYPEeSocial event typenvarchar40
36T7BREFD_EVTYPEEvent types2EVENT_TYPEeSocial event typenvarchar40
37T7BREFD_EVTYPETEvent type text table3EVENT_TYPEeSocial event typenvarchar40
38T7BREFD_EVTY_CEvent types2EVENT_TYPEeSocial event typenvarchar40
39T7BREFD_ITEVTRIGFields of infotypes relevant for event generation5EVENT_TYPEeSocial event typenvarchar40
TOPALE Integration Technology
40TBD52Function modules for inbound ALE-EDI5EVENT_TYPEIndividual input event for further processingnvarchar320
TOPBasic Data
41NCEM_REG_EVENTSaves Events in Relation to Event Handler7EVENT_TYPEIS-H: Event Type for Object in ISH-CM Event Frameworknvarchar320
42TNCEM_ORDDetermines Event Sequence Relation4EVENT_TYPEIS-H: Event Type for Object in ISH-CM Event Frameworknvarchar320
43TNCEM_SUBSCRIPTListener Subscription Data for Event Manager5EVENT_TYPEIS-H: Event Type for Object in ISH-CM Event Frameworknvarchar320
TOPBasic Functions
44UKM_ACT_EV_CTRLSAP Credit Management: Control Activity -> Event2EVENT_TYPEType of Eventnvarchar20
45UKM_BL_REASONSAP Credit Management: Reason for Locks in Credit Management3EVENT_TYPEType of Eventnvarchar20
46UKM_EVENT_TYPESSAP Credit Management: Events3EVENT_TYPEType of Eventnvarchar20
47UKM_EV_PR_CTRLSAP Credit Management: Control Event -> Follow-On Process1EVENT_TYPEType of Eventnvarchar20
48UKM_PROCESSESSAP Credit Management: Processes2EVENT_TYPEType of Eventnvarchar20
TOPBatch-Oriented Parallel Processing of Mass Data
49PPF_TST_HISTORYHistory Data for Mass Runs8EVENT_TYPEType of a Process Stepnvarchar100
TOPBrowser-Based PI Sheet Cockpit
50POC_DB_C_TRIGGERDomain Model: Trigger Collection11EVENT_TYPEType of Event in the PI Sheet (Global (MDA) / Local)nvarchar300
TOPEasy Enhancement Workbench
51AXT_RUN_RULERule Runtime7EVENT_TYPEEvent Type for Rule Executionnvarchar60
TOPEnd User Technology
52RSRD_REGISTRATNRegistration of Settings to Events (Broadcasting)3EVENT_TYPEEvent Type in Broadcasting Frameworknvarchar20
53RSRD_REGISTR_USRPermitted User for Registering Settings for Events3EVENT_TYPEEvent Type in Broadcasting Frameworknvarchar20
TOPEquipment
54IEQT_WL_ITEMSInterim Statuses - Items6EVENT_TYPEType of Eventnvarchar10
55IEQT_WL_ITM_BACInterim Statuses - Items (Backup)7EVENT_TYPEType of Eventnvarchar10
TOPOffice Suite Program
56/OSP/T_RAUI_LREFOSP Last Refreshed Date Table3EVENT_TYPEEvent Typenvarchar20
TOPPersonnel Time Management
57TPT_EVENTATTRPair Formation: Characteristics of Time Event Types1EVENT_TYPETime Event Typenvarchar30
TOPProcess Controls
58GRPCEVENT1Event log3EVENT_TYPEEvent Typenvarchar400
59GRPCEVENTMAPEvent Monitoring : Event to Control Rule mapping4EVENT_TYPEEvent Typenvarchar400
60GRPCEVENTTYPEEvent Type2EVENT_TYPEEvent Typenvarchar400
61GRPCEVENTTYPETEvent Type Texts3EVENT_TYPEEvent Typenvarchar400
62GRPCEVTPARTNREvent Monitoring: Partner relationship3EVENT_TYPEEvent Typenvarchar400
63GRPCVIOLATIONEvent Monitoring: Violations3EVENT_TYPEEvent Typenvarchar400
64GRPC_BW_EVT_LOCPC Events: BI Location Id -> Region/Country/... mapping4EVENT_TYPEPC Event Typenvarchar600
TOPRecords and Case Management
65RMPSDOD_EVNTTYPEDisposal Events2EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
66RMPSDOD_EVNTTYPTText Table Event Types for Disposal3EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
67RMPSDOD_RULEBASEDisposal Rulebase3EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
68RMPSPRO_EVNTTYPEDisposal Events2EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
69RMPSPRO_EVNTTYPTText Table Event Types for Disposal3EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
70RMPSPRO_MULTISTGMultistage Disposal4EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
71RMPSPRO_RULEBASEDisposal Rulebase3EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
72RMPSTNA_EVNTTYPEDisposal Events2EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
73RMPSTNA_EVNTTYPTText Table Event Types for Disposal3EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
74RMPSTNA_RULEBASETNA: Schedules for the Disposal According to PRO Standard3EVENT_TYPETriggering Event of a Disposal Periodnvarchar50
TOPUnique Identification
75IUID_MAN_DATAManually Maintained Values for IUID Messages19EVENT_TYPELife-Cycle Eventnvarchar400
76IUID_PEDIGREEUII IDoc Message Data for Supporting Supplier Collaboration19EVENT_TYPELife-Cycle Eventnvarchar400
TOPWeb Screen Tools - ABAP
77WDY_UI_EVENT_DEFWeb Dynpro: Event Definitions4EVENT_TYPEEnumnvarchar20