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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

88 columns | Print definition?ERP 6.0  | PID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FLBOOK_IDXStandard index table31PIDIntegration Engine: Pipeline IDnvarchar400
2/AIF/MIDX_TEMPLTemplate for a multi index table32PIDIntegration Engine: Pipeline IDnvarchar400
3/AIF/QRFC_S_IDXqRFC Standard index table31PIDIntegration Engine: Pipeline IDnvarchar400
4/AIF/Q_STD_IDX_TqRFC Standard index table31PIDIntegration Engine: Pipeline IDnvarchar400
5/AIF/STD_IDX_TBLStandard index table31PIDIntegration Engine: Pipeline IDnvarchar400
6/AIF/TEST_BP_IDXStandard index table31PIDIntegration Engine: Pipeline IDnvarchar400
7/AIF/TRFC_S_IDXtRFC Standard index table31PIDIntegration Engine: Pipeline IDnvarchar400
8/AIF/T_CIFPP_IDXStandard Index Table for CIF Postprocessing31PIDIntegration Engine: Pipeline IDnvarchar400
9/AIF/T_STD_IDX_TtRFC Standard index table31PIDIntegration Engine: Pipeline IDnvarchar400
10/AIFX/ECH_STD_TBStandard ECH key fields table46PIDIntegration Engine: Pipeline IDnvarchar400
11/CFMFND/VWB_M2PVisual Workbench: Zuordnung Modul zu Perspektive2PIDVisual Workbench: ID einer Ansichtnvarchar150
12/CFMFND/VWB_PERSVisual Workbench: Perspectives2PIDVisual Workbench: ID of a work areanvarchar150
13/CFMFND/VWB_PERTVisual Workbench: Text zu Perspektiven3PIDVisual Workbench: ID einer Ansichtnvarchar150
14/SDF/IVISXIPNDGPending ALE messages for IDOC adapter3PIDnvarchar400
15/SSF/ATABService Software Framework:Binary Analysis data for Download2PIDnvarchar30
16/SSF/BTABService Software Framework: Binary packed data table (BTAB)2PIDnvarchar30
17/XFT/QMPPAPT001QM Sampling Header Table3PIDSampling Numbernvarchar640
18BBP_PIDDATPID entries for each node in PID tree4PIDSet/Get parameter IDnvarchar200
19PROGRAMSTabelle der program Einträge für Transaktion SVPQ4PIDVerifikation : Process IDint100
20SXMS_QERRORQueue Error3PIDIntegration Engine: Pipeline IDnvarchar400
21SXMS_QERROR_SQueue Error Alert3PIDIntegration Engine: Pipeline IDnvarchar400
22UPGSQLUpgrade SQL Statements for processing7PIDint100
23ZAIF_D01_SIDX_01Single index table for DEMO BUPA_IN31PIDIntegration Engine: Pipeline IDnvarchar400
TOPBasic Data and Tools
24RMWBA_80RMS-WB: Structure for Favorites4PIDDatabase Object Key for Favoritesnvarchar100
TOPBasis Components
25/SSF/DTABService Software Framework:Packed analysis data for Download2PIDnvarchar30
26/SSF/PTABService Software Framework: Packed data table (PTAB)2PIDnvarchar30
TOPBatch-Oriented Parallel Processing of Mass Data
27BANK_PROCFL_PROCTemporary Process Data24PIDProcess Identificationnvarchar80
TOPChange Transport System
28TPLOGLogging of tp Calls2PIDProcess Identificationnvarchar80
29TRBAT2tp/R3trans Communication Table for Transport Control13PIDProcess IDnvarchar110
TOPCustomer Interaction Center
30CDESTPIDOnline BDC parameter-id preset destination4PIDSet/Get parameter IDnvarchar200
31COMAPOnline BDC output mapping from message table to container5PIDSet/Get parameter IDnvarchar200
TOPDB2 Universal Database for UNIX NT
32DB6CSTRACEDB6: Results Table for DB6 CS Trace (Cumulative DBSL Trace)1PIDint100
TOPIncentive and Commission Management ICM
33CACS_RI_HDRun Administration Header7PIDIdentification of Parallel Processing Runnvarchar220
34FPP_RUNSRun Data for Parallel Processing2PIDIdentification of Parallel Runnvarchar220
35FPP_RUN_INTERVALStatus of Intervals for a Run2PIDIdentification of Parallel Runnvarchar220
TOPInformix
36INFREQ4USParallel Upd. Stat. Request Table (sapdbainf <-> child4us)14PIDint100
TOPIntegration Engine
37SXMSCLUPXMB: Property Cluster4PIDIntegration Engine: Pipeline IDnvarchar400
38SXMSCLUP2XMB: Property Cluster (Switch Table)4PIDIntegration Engine: Pipeline IDnvarchar400
39SXMSCLURXMB: Resources Cluster4PIDIntegration Engine: Pipeline IDnvarchar400
40SXMSCLUR2XMB: Resources Cluster (Switch Table)4PIDIntegration Engine: Pipeline IDnvarchar400
41SXMSINTFXMB: Container for Application Monitoring (Template)2PIDIntegration Engine: Pipeline IDnvarchar400
42SXMSINTFTSender/Receiver Interfaces2PIDIntegration Engine: Pipeline IDnvarchar400
43SXMSMSGREFMessage Reference Storage5PIDIntegration Engine: Pipeline IDnvarchar400
44SXMSPADMXMS Pipeline: Execution Settings1PIDIntegration Engine: Pipeline IDnvarchar400
45SXMSPCONFXMB: Administrative Data for Pipeline Configuration1PIDIntegration Engine: Pipeline IDnvarchar400
46SXMSPDATAArchive for Message Extract3PIDIntegration Engine: Pipeline IDnvarchar400
47SXMSPEMASIntegration Engine: Enhanced Message Queue (Master)3PIDIntegration Engine: Pipeline IDnvarchar400
48SXMSPEMAS2Integration Engine: Extended Message Queue (Switch Table)3PIDIntegration Engine: Pipeline IDnvarchar400
49SXMSPERFTXMS: Monitor Table for Runtime Measurement2PIDIntegration Engine: Pipeline IDnvarchar400
50SXMSPERRO2XMB: Message Queue (Entries with Errors) (Switch Table)3PIDIntegration Engine: Pipeline IDnvarchar400
51SXMSPERRORXML Message Broker: Message Queue (Incorrect Entries)3PIDIntegration Engine: Pipeline IDnvarchar400
52SXMSPHISTXML Message Broker: History3PIDIntegration Engine: Pipeline IDnvarchar400
53SXMSPHIST2XML Message Broker: History (Switch Table)3PIDIntegration Engine: Pipeline IDnvarchar400
54SXMSPIPEXML Message Server: Pipeline Definition1PIDIntegration Engine: Pipeline IDnvarchar400
55SXMSPIPEELPipeline Element Definition1PIDIntegration Engine: Pipeline IDnvarchar400
56SXMSPIPETXMS: Pipeline Description2PIDIntegration Engine: Pipeline IDnvarchar400
57SXMSPLELTXMS: Description of Pipeline Elements2PIDIntegration Engine: Pipeline IDnvarchar400
58SXMSPMASTIntegration Engine: Message Queue (Master)3PIDIntegration Engine: Pipeline IDnvarchar400
59SXMSPMAST2XML Message Broker: Message Queue (Master) (Switch Table)3PIDIntegration Engine: Pipeline IDnvarchar400
60SXMSPVERSIntegration Engine: Message Version3PIDIntegration Engine: Pipeline IDnvarchar400
61SXMSPVERS2Integration Engine: Message Version (Switch Table)3PIDIntegration Engine: Pipeline IDnvarchar400
62SXMSRECVTTechnical Receiver2PIDIntegration Engine: Pipeline IDnvarchar400
63SXMSTRANS_MSGBody Table for Message Transfer4PIDIntegration Engine: Pipeline IDnvarchar400
64SXMSTRC_DATXMS: Trace Data15PIDIntegration Engine: Pipeline IDnvarchar400
65SXMSTRC_SELXMS: Selection Conditions for Trace Start10PIDIntegration Engine: Pipeline IDnvarchar400
66SXMS_MULTIM_REFLink Table Leading Message - Submessages3PIDIntegration Engine: Pipeline IDnvarchar400
67SXMS_SCOPYWS/XI Log Table for System Copy3PIDIntegration Engine: Pipeline IDnvarchar400
68SXMS_VIOL_LOGException Handling in EOIO Processing3PIDIntegration Engine: Pipeline IDnvarchar400
TOPliveCache Applications
69/SAPAPO/OMTSPROCDP Test Framework: Master/Slave Communication Process Table5PIDProcess Identificationnvarchar80
TOPOLAP Technology
70RSECLOGStorage for Authorizations Logs xml1PIDUUID in character formnvarchar320
71RSECLOPDLOGCStore for LOPD Logs1PIDUUID in character formnvarchar320
TOPOracle Database Monitors
72GVD_MANGD_STANBYcopy of GV$MANAGED_STANDBY (currently not provided w. snaps)4PIDOracle monitoring: PIDdecimal220
TOPPerformance Assessment Workbench
73SLS_PRESPAW - Person Results Structure3PIDParticipant IDnvarchar450
74SLS_QLOGPAW - Qualification Generation Log4PIDParticipant IDnvarchar450
TOPPerformance Monitors TCC
75GVD_LATCHHOLDERCopy of GV$LATCHHOLDER (currently not provided with snapsh)3PIDOracle monitoring: PIDdecimal220
76GVD_PROCESSCopy of GV$PROCESS4PIDOracle monitoring: PIDdecimal220
TOPReal Estate Management
77VIDOCSReference Table for Real Estate Documents5PIDPosting run number in fiscal yearnvarchar80
TOPRuntime WorkbenchMonitoring
78SXMSAGGRAWSAP XI Status Overview: Integration Engine Raw Data3PIDIntegration Engine: Pipeline IDnvarchar400
79SXMSMSGINDLOGSAP XI: Indexing Log of Messages3PIDIntegration Engine: Pipeline IDnvarchar400
TOPSAP Business Workflow
80SWLWPSSIGWorkflow: Parameters for External Services3PIDParameter ID for WebFlow Servicenvarchar320
81SWLWPSSIGTWorkflow: Parameters for External Services: Texts3PIDParameter ID for WebFlow Servicenvarchar320
TOPSAP Healthcare - Industry-Specific Components for Hospitals
82N2PRZ_HIT_KATIS-H*MED: SPC Hit Lists Entries Hierarchical Classification10PIDIS-H*MED: Key of Procedure IDnvarchar100
83N2PRZ_OPS_KATIS-H*MED: SPC Catalog in Hierarchical Structure8PIDIS-H*MED: Key of Procedure IDnvarchar100
84NWCHLS_NFALIS-H CH: ALIS-Fehlerhandlung - Falldaten (für Fall-API)5PIDIS-H CH: gestione errori ALIS - ID paziente esternonvarchar200
TOPSyntax, Compiler, Runtime
85D1GENImport Status for APG (Anticipatory Program Generation)2PIDProcess IDnvarchar110
TOPTransport Organizer
86TLOCKCIOLock Table for CheckOut-CheckIn6PIDnvarchar400
87TRBAT3Communication Table for R3trans Parallelization9PIDProcess IDnvarchar110
TOPWeb Service and SOAP - ABAP
88SRT_UTIL_PERFSRT Utilities: Performance Trace Data16PIDnvarchar320