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

157 columns | Print definition?ERP 6.0  | PROCESS_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000207POC_D_PRC_IN5PROCESS_IDnvarchar320
2/1CADMC/00001438POC_D_PRC_BIND6PROCESS_IDnvarchar320
3/1CADMC/00001439POC_D_PRC_IN5PROCESS_IDnvarchar320
4/OPT/CT_IDH_HEADInbound Document Handler: Registration table with header inf25PROCESS_IDProcess ID of incoming document processingnvarchar100
5/OPT/VT_DOC_HEA1Document Header - copy of /opt/vt_doc_head27PROCESS_IDTerms of Payment Keynvarchar40
6/OPT/VT_DOC_HEADDocument Header27PROCESS_IDTerms of Payment Keynvarchar40
7/OPT/VT_WORKITE1Work Item Header Table - Copy of /opt/vt_workitem14PROCESS_IDnvarchar30
8/OPT/VT_WORKITEMWork Item Header Table14PROCESS_IDnvarchar30
9/SAPSRM/D_WF_003Table for persistent class /SAPSRM/CL_WF_PROCESS_LEVEL18PROCESS_IDGlobally Unique Identifiervarbinary160
10/SAPSRM/D_WF_008Table for persistent class /SAPSRM/CL_WF_RECORD4PROCESS_IDGlobally Unique Identifiervarbinary160
11/SAPSRM/D_WF_018Table for persistent class /SAPSRM/CL_WF_RUNTIME4PROCESS_IDGlobally Unique Identifiervarbinary160
12/SLOAP/OUT_COMMSLOAS - Output Processing Commands3PROCESS_IDint100
13/SLOAP/OUT_COMMTTransport Tables for /SLOAS/OUT_COMM5PROCESS_IDint100
14/SYCLO/MDW04Syclo middleware process log4PROCESS_IDSyclo middleware process idnvarchar500
15/XFT/CM_100_AContract: Order table autom. sending of notification (arch.)19PROCESS_IDProcess IDnvarchar320
16/XFT/DIOBPMMAINDIO: BPM5PROCESS_IDProcess IDnvarchar340
17/XFT/EPA_TPROTLog4PROCESS_IDProcess IDnvarchar320
18/XFT/SRM_REC33Process instance: Header3PROCESS_IDProcess IDnvarchar320
19/XFT/SRM_REC34Process instance: Node3PROCESS_IDProcess IDnvarchar320
20/XFT/SRM_REC35Process instance: Messages3PROCESS_IDProcess IDnvarchar320
21/XFT/SRM_REC36Process instance: Short description3PROCESS_IDProcess IDnvarchar320
22/XFT/SRM_REC37Process instance: Agent3PROCESS_IDProcess IDnvarchar320
23BBP_WFL_TRACEBBP_WFL_TRACE11PROCESS_IDProcess Identificationnvarchar80
24BKK_PE_DB_ITEMStore Asynchronous Posting Response for Items10PROCESS_IDProcess IDvarbinary160
25GRACMWCNFNAPRVMSMP Stage Task Configuration Values for RAR Function Workfl3PROCESS_IDProcess IDnvarchar300
26GRACMWCNRKMNTVMSMP Stage Task Configuration Values for RAR Risk Maint WF3PROCESS_IDProcess IDnvarchar300
27GRACMWCNRKRVWVMSMP Stage Task Configuration Values for SOD Risk Review3PROCESS_IDProcess IDnvarchar300
28GRACMWCNSACRQVMSMP Stage Task Configuration Values for Access Request3PROCESS_IDProcess IDnvarchar300
29GRACMWCNSAURWVMSMP Stage Task Configuration Values for SPM3PROCESS_IDProcess IDnvarchar300
30GRACMWCNSMITCCVMSMP Stage Task Configuraiton Values for Mitigation Control3PROCESS_IDProcess IDnvarchar300
31GRACMWCNSRLAPVMSMP Stage Task Configuration Values for Role Approval3PROCESS_IDProcess IDnvarchar300
32GRACMWCNSUARVMSMP Stage Task Configuration Values for Access Request3PROCESS_IDProcess IDnvarchar300
33GRFNMWCNDEBUGMSMP Runtime - Process Debug Settings2PROCESS_IDProcess IDnvarchar300
34GRFNMWCNESCCONDMSMP Process Escape Confitions2PROCESS_IDProcess IDnvarchar300
35GRFNMWCNESCCONDTMSMP Process Escape Confitions Texts3PROCESS_IDProcess IDnvarchar300
36GRFNMWCNESCTYPEMSMP Escalation Type2PROCESS_IDProcess IDnvarchar300
37GRFNMWCNESCTYPTMSMP Escalation Type Text3PROCESS_IDProcess IDnvarchar300
38GRFNMWCNGLBESRMSMP Process Global Settings - Escape Paths2PROCESS_IDProcess IDnvarchar300
39GRFNMWCNGLBESRVMSMP Process Global Settings - Escape Paths - Versions3PROCESS_IDProcess IDnvarchar300
40GRFNMWCNGLBNOTMSMP Global Settings - Process Level Notifications2PROCESS_IDProcess IDnvarchar300
41GRFNMWCNGLBSETMSMP Global Settings per Process2PROCESS_IDProcess IDnvarchar300
42GRFNMWCNMSGLGMSMP Message Log Categories for Debugging2PROCESS_IDProcess IDnvarchar300
43GRFNMWCNPATHMSMP Path2PROCESS_IDProcess IDnvarchar300
44GRFNMWCNPATHTMSMP Path Description3PROCESS_IDProcess IDnvarchar300
45GRFNMWCNPATHVMSMP Path : Versions3PROCESS_IDProcess IDnvarchar300
46GRFNMWCNPRCSMSMP Process2PROCESS_IDProcess IDnvarchar300
47GRFNMWCNPRCSTMSMP Process Description3PROCESS_IDProcess IDnvarchar300
48GRFNMWCNPRINIMSMP Process Initiator2PROCESS_IDProcess IDnvarchar300
49GRFNMWCNPRINIVMSMP Process Initiator : Version3PROCESS_IDProcess IDnvarchar300
50GRFNMWCNROUTEMSMP Route Mapping2PROCESS_IDProcess IDnvarchar300
51GRFNMWCNROUTEVMSMP Routing Rules : Versions3PROCESS_IDProcess IDnvarchar300
52GRFNMWCNSDEFVMSMP Stage Definitions - Versions3PROCESS_IDProcess IDnvarchar300
53GRFNMWCNSTGMSMP Stage2PROCESS_IDProcess IDnvarchar300
54GRFNMWCNSTGTMSMP Stage Description3PROCESS_IDProcess IDnvarchar300
55GRFNMWCNSTGVMSMP Stage Version3PROCESS_IDProcess IDnvarchar300
56GRFNMWCNVERAMSMP Versions2PROCESS_IDProcess IDnvarchar300
57GRFNMWCNVERAXMLMSMP Versions (XML serialized - for backup purposes)2PROCESS_IDProcess IDnvarchar300
58GRFNMWNOTIFRECPTMSMP Stage Notification Recipents2PROCESS_IDProcess IDnvarchar300
59GRFNMWNOTIFRECPVMSMP Stage Notification Recipents - Versions3PROCESS_IDProcess IDnvarchar300
60GRFNMWRTARCHCONFMSMP Instance Configurations - for Archiving3PROCESS_IDProcess IDnvarchar300
61GRFNMWRTINSTMSMP Runtime - Instance Header Info6PROCESS_IDProcess IDnvarchar300
62GRFNMWRTINSTWIMSMP Runtime - Work Item execution context cache6PROCESS_IDProcess IDnvarchar300
63GRFNMWTASKVTEMPLDO NOT USE - Template for GRC FN MSMP Task Versions Table3PROCESS_IDProcess IDnvarchar300
64N1MCI_MSGMessage Log3PROCESS_IDCommunication Process Identificationnvarchar320
65REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)62PROCESS_IDLine already processednvarchar10
66RSPMDATATARGETRSPM Process Variants2PROCESS_IDRSPM Process IDnvarchar400
67RSPMPROCESSRSPM Process Directory3PROCESS_IDRSPM Process IDnvarchar400
68RSPMVARIANTRSPM Process Variants2PROCESS_IDRSPM Process IDnvarchar400
69T7SAPSHCMPFHHCMPF add-on data header2PROCESS_IDProcess Namenvarchar320
70WRRP_CTRLRRP: Control parameters for Rapid Replenishment Planning2PROCESS_IDRRP: Process ID for Rapid Requirement Calculationnvarchar110
71WRRP_DOC_TYPERRP: Relevant Document Types for Rapid Replenishment2PROCESS_IDRRP: Process ID for Rapid Requirement Calculationnvarchar110
72WRRP_PARAMSETRRP: Control Parameters2PROCESS_IDRRP: Process ID for Rapid Requirement Calculationnvarchar110
TOPBases
73T77OMAHQ_GARBAGETable with Selections/Queries to be Deleted1PROCESS_IDnvarchar400
TOPBasis Components
74/XFT/INV_QInvoice receipt queue: Header2PROCESS_IDProcess IDnvarchar340
75/XFT/INV_Q_1Invoice receipt queue: Items2PROCESS_IDProcess IDnvarchar340
76/XFT/INV_Q_10Material data2PROCESS_IDProcess IDnvarchar340
77/XFT/INV_Q_10_SMaterial data2PROCESS_IDProcess IDnvarchar340
78/XFT/INV_Q_11Account assignment data2PROCESS_IDProcess IDnvarchar340
79/XFT/INV_Q_11_SAccount assignment data2PROCESS_IDProcess IDnvarchar340
80/XFT/INV_Q_12Document aspect for process2PROCESS_IDProcess IDnvarchar340
81/XFT/INV_Q_12_SDocument aspect for process2PROCESS_IDProcess IDnvarchar340
82/XFT/INV_Q_13Relations Process Types2PROCESS_IDProcess IDnvarchar340
83/XFT/INV_Q_13_SRelationes Process Types (Shadow Table)2PROCESS_IDProcess IDnvarchar340
84/XFT/INV_Q_14Cycle3PROCESS_IDProcess IDnvarchar340
85/XFT/INV_Q_1_SInvoice receipt queue: Items2PROCESS_IDProcess IDnvarchar340
86/XFT/INV_Q_5Table of invoice documents (R/3) for a process2PROCESS_IDProcess IDnvarchar340
87/XFT/INV_Q_5_STable of invoice documents (R/3) for a process2PROCESS_IDProcess IDnvarchar340
88/XFT/INV_Q_6PO details (header) for an invoice receipt process2PROCESS_IDProcess IDnvarchar340
89/XFT/INV_Q_6_SPO details (header) for an invoice receipt process2PROCESS_IDProcess IDnvarchar340
90/XFT/INV_Q_7Tax data2PROCESS_IDProcess IDnvarchar340
91/XFT/INV_Q_7_STax data2PROCESS_IDProcess IDnvarchar340
92/XFT/INV_Q_9Workflow work item process ID assignment2PROCESS_IDProcess IDnvarchar340
93/XFT/INV_Q_9_SWorkflow work item process ID assignment2PROCESS_IDProcess IDnvarchar340
94/XFT/INV_Q_SInvoice receipt queue: Header2PROCESS_IDProcess IDnvarchar340
TOPBatch-Oriented Parallel Processing of Mass Data
95BANK_PP_STEPDATAData for Processing Steps of a Parallel Mass Run8PROCESS_IDProcess IDvarbinary160
TOPBatches
96TCUDB_APPL_PROCDocumentary Batch - Application: Supported Processed2PROCESS_IDDefinable Processes for Documentary Batchesnvarchar20
97TCUDB_PROCESSDocumentary Batch Settings - Manaual Process Steps2PROCESS_IDDefinable Processes for Documentary Batchesnvarchar20
TOPBusiness Configuration Tools Runtime
98CC2S_CONSTRAINTSC2-Server: Constraints9PROCESS_IDGUID for C2 servernvarchar320
99CC2S_CUSMDATAC2 Server: Constraints for Central Customizing Objects9PROCESS_IDGUID for C2 servernvarchar320
TOPChange Pointer Service
100CNS_CPCNS: Change Pointer17PROCESS_IDBusiness Process IDnvarchar320
TOPClassification Toolset
101CLS_RUNRun directory11PROCESS_IDJob IDnvarchar80
TOPClient Copy
102CCSELTABParallel Client Copy Worklist: Objects12PROCESS_IDProcess ID for parallel client copy processsnvarchar250
TOPCollaboration Folders
103CFX_SYNCSynchronization of Background Processes2PROCESS_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPControl Plan
104DPR_CTRLPLAN_IControl Plan: Characteristics Within Control Plan6PROCESS_IDProcess ID in Control Plan (Predefined in Customizing)nvarchar150
TOPE-Recruiting
105T77RCF_CDCYLISTData Saving for Requisition Assignment List36PROCESS_IDProcessnvarchar20
TOPFinancial Accounting
106/OPT/VIM_CHNLMaintain Channel8PROCESS_IDProcess ID of incoming document processingnvarchar100
107/OPT/VT_WORKWork Item Header Table - Real Time14PROCESS_IDnvarchar30
TOPFinancial Services
108PSJ_D_STEPPSJ: Journal Entries3PROCESS_IDBusiness Process IDnvarchar320
TOPGRC Risk Management
109GRRMCACTPROCLNKLink between Activity Categories and Processes3PROCESS_IDObject IDnvarchar80
TOPGuided Procedure
110EUP_BSP_CFG_PROPStores the configuration properties for the input value ctx.1PROCESS_IDGUID in 'CHAR' Format in Uppercasenvarchar320
111EUP_BSP_IV_CTXTemp table to hold the input value context.1PROCESS_IDGUID in 'CHAR' Format in Uppercasenvarchar320
112EUP_BSP_OV_CTXTable for bsp co output data. Used by j2ee to get the output1PROCESS_IDGUID in 'CHAR' Format in Uppercasenvarchar320
113EUP_BSP_RSL_STSThe result states associated with the bsp output context.1PROCESS_IDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPIncentive and Commission Management ICM
114CACSCP_RCP_WL_INRCP: Information on Worklist5PROCESS_IDProcess Identificationnvarchar80
115YSVMA_RCP_WL_INRCP: Information on Worklist5PROCESS_IDProcess Identificationnvarchar80
116YTEL05_RCP_WL_INRCP: Information on Worklist5PROCESS_IDProcess Identificationnvarchar80
TOPIndustry Solution Oil
117OI0_PROPT_OBDETOutbound notif pgm run3PROCESS_IDProcess Type for Price Optimizernvarchar20
TOPliveCache Applications
118/SAPAPO/OMTSGUIDManage Counter for Descriptive GUIDs for Types1PROCESS_IDVersion Number Componentnvarchar20
TOPMaterial Master
119WGDS_PROC_APP_CApplication used in a process2PROCESS_IDProcess identifiernvarchar320
120WGDS_PROC_EVT_CRule engine's Events called during a process4PROCESS_IDProcess identifiernvarchar320
TOPMonitoring
121SCMC_CACHE_PRCSynchronization Table for the Cache Update Processes1PROCESS_IDKey for Cache Entriesvarbinary160
TOPObjective Setting and Appraisals
122T77HAP_VH_DISTAppraisal Process: Performance Goal Distribution2PROCESS_IDPMP: Process IDnvarchar80
123T77HAP_WIZ_CONFStorage of Configuration Settings in XML3PROCESS_IDProcess IDnvarchar40
TOPOffice Suite Program
124/OSP/T_JOBINFOOSP Report Schedule Jobs information5PROCESS_IDUnique Process IDnvarchar320
TOPPeople Centric UI Framework Customizing
125CRMC_BSP_PROCProcess1PROCESS_IDProcess IDnvarchar200
126CRMC_BSP_PROCCProcess (Cust.)2PROCESS_IDProcess IDnvarchar200
127CRMC_BSP_PROCEEntity Process1PROCESS_IDProcess IDnvarchar200
128CRMC_BSP_PROC_TText Table for Process2PROCESS_IDProcess IDnvarchar200
129CRMC_VSETGRCView Set Group (Cust.)6PROCESS_IDProcess IDnvarchar200
130CRMC_VSETGRPViewset Group5PROCESS_IDProcess IDnvarchar200
TOPPrice Planning Workbench
131WRF_PPW_PPDARTPPD Material Item16PROCESS_IDBudget IDnvarchar20
132WRF_PPW_PPDBGPPD Budgets5PROCESS_IDBudget IDnvarchar20
133WRF_PPW_PPDBGPAPPD Budget Set5PROCESS_IDBudget IDnvarchar20
TOPProcess Controls
134HRP5310DB Table for Infotype 531019PROCESS_IDSubprocess IDnvarchar80
TOPProcess Orchestration for Built-In Processes
135POC_D_KPI_ACTTask Log KPI Values2PROCESS_IDProcess IDnvarchar320
136POC_D_KPI_LOGTask Log KPI Values2PROCESS_IDProcess IDnvarchar320
137POC_D_PRC_BINDTask Log Process Binding3PROCESS_IDProcess IDnvarchar320
138POC_D_PRC_INTask Log Process Instance2PROCESS_IDProcess IDnvarchar320
139POC_D_PRC_STP_INTask Log Activity Instances4PROCESS_IDProcess IDnvarchar320
140POC_D_PRE_BATask Log Previous Task3PROCESS_IDProcess IDnvarchar320
141POC_D_TRACK_THRThreshold Tracking table2PROCESS_IDProcess IDnvarchar320
TOPPurchasing
142WRFT_BUDG_KSSet of Key Figures4PROCESS_IDBudget IDnvarchar20
TOPSAP Business Workflow
143SWFREXTPROCWorkflow: Relation Between Work Item and External Process3PROCESS_IDWorkflow: ID of an External Processnvarchar500
TOPSelf-Service Procurement
144/SRMERP/D_WF_003Table for persistent class /SRMERP/CL_WF_PROCESS_LEVEL18PROCESS_IDGlobally Unique Identifiervarbinary160
145/SRMERP/D_WF_008Table for persistent class /SRMERP/CL_WF_RECORD4PROCESS_IDGlobally Unique Identifiervarbinary160
146/SRMERP/D_WF_018Table for persistent class /SRMERP/CL_WF_RUNTIME4PROCESS_IDGlobally Unique Identifiervarbinary160
TOPTalent Management
147T77TMCDELEMPRCAssignments of Dyn. Elements of Templates to Processes5PROCESS_IDProcess IDnvarchar40
148T77TMCELEMPRCAssignments of Elements of Templates to Processes5PROCESS_IDProcess IDnvarchar40
149T77TMCPRCProcesses2PROCESS_IDProcess IDnvarchar40
150T77TMCPRCTDescriptions for Processes3PROCESS_IDProcess IDnvarchar40
151T77TMCPROCEntity Table for Processes2PROCESS_IDProcess IDnvarchar40
152T77TMC_PRC_TMLTimeline Flow of Process2PROCESS_IDProcess IDnvarchar40
153T77TMC_PRC_TMPL(Obsolete) Assignment of Templates to Processes2PROCESS_IDProcess IDnvarchar40
154T77TMC_PRC_VAL(Obsolete) Process Period and Grouping2PROCESS_IDProcess IDnvarchar40
155T77TMC_PROC_TAssignment of Generic Templates to Processes2PROCESS_IDProcess IDnvarchar40
156T77TMC_P_TAssignment of Templates to Processes2PROCESS_IDProcess IDnvarchar40
157T77TMC_P_VProcess Period and Grouping2PROCESS_IDProcess IDnvarchar40