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

163 columns | Print definition?ERP 6.0  | RCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IXOS/DCCMIDXSTASDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
2/OPT/X169AP Personnel for Parked Invoice Workflow2RCODEPayee code for invoice processingnvarchar120
3/OPT/Y169AP Personnel for Parked Invoice Workflow2RCODEPayee code for invoice processingnvarchar120
4/OPT/Z169AP Personnel for Parked Invoice Workflow2RCODEPayee code for invoice processingnvarchar120
5BBP_IDXSTASDOK: Status Table for Indexing Documents8RCODEReturn codenvarchar40
6CMPHRECash Management: Status Table for Indexing Documents7RCODEReturn codenvarchar40
7FARRPHRESDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
8FARR_ATTAHPHRESDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
9FUCNPHRESDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
10FUCN_PHRESDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
11J_1I_EXIMNPHREEXIM Notes : Status Table for Indexing Documents7RCODEReturn codenvarchar40
12J_1I_EXIMPHREEXIM:: Status Table for Indexing Documents7RCODEReturn codenvarchar40
13TWFNSWorkflow: control table status transfers (next status)4RCODEWorkflow: Return code of process FM for selecting new statenvarchar50
14ZIDIDXST01SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
15PIQIDXST01Campus Mgmt: Status Table for Indexing Documents8RCODEReturn codenvarchar40
16PIQIDXST02Campus Mgmt: Status Table for Indexing Documents7RCODEReturn codenvarchar40
17PIQIDXST03Campus Mgmt: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPAuthoring Tools
18QMM_IDXSTAQMM: Status Table for Indexing Info Objects7RCODEReturn codenvarchar40
TOPBank Accounting
19TCCRCPayment Cards: Check Results3RCODEPayment Cards: Result of Checknvarchar40
20TCCRCTPayment cards: Results of checks (texts)4RCODEPayment Cards: Result of Checknvarchar40
TOPBasic Functions
21UDMIDXST01Dispute Management: Status Table for Indexing Documents8RCODEReturn codenvarchar40
22UDMIDXST02Dispute Management: Status Table for Indexing Documents7RCODEReturn codenvarchar40
TOPBudgeting
23BTXIDXST01Budge_text: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPBusiness Document Service
24KWBIDXSTAKW BDS Demo:: Status Table for Document Indexing7RCODEReturn codenvarchar40
TOPBusiness Information Collection
25UIDCIDXSTAUI Documents: Status Table for Indexing of Documents7RCODEReturn codenvarchar40
TOPBusiness Package for Manager Self-Service FI
26FPB_EXPPHRESDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
TOPCase Management
27SCMGIDXST01Case: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPClaims Management
28ICLPARTSPParticipant: Vendor9RCODEExternal Services Management: Reason for Manual Entrynvarchar20
29ICSPARTSPClaim Participant: Vendor9RCODEExternal Services Management: Reason for Manual Entrynvarchar20
30TICL086Vendor Assignment: Reason for Manual Entry2RCODEExternal Services Management: Reason for Manual Entrynvarchar20
31TICL086TVendor Assignment: Reason for Manual Entry: Text3RCODEExternal Services Management: Reason for Manual Entrynvarchar20
TOPClinical System
32TN1RCINDTMedication: Reason Code (Institution-Independent) Texts4RCODEMedication: Reason Codenvarchar100
33TN1RCODETMedication: Reason Key - Texts5RCODEMedication: Reason Codenvarchar100
TOPCollaboration Folders
34CFF_ADD_IDXSTASDOK: Status Table for Indexing Documents8RCODEReturn codenvarchar40
35CFF_IDXSTACollaboration Folders - PHIO: Instances Physical Info: Sta8RCODEReturn codenvarchar40
TOPControlling
36FCOMTS_CR_PHRESDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
TOPCross-Application Components
37/IXOS/RMIDXSTA/IXOS/:: Status Table for Indexing Documents7RCODEReturn codenvarchar40
38/PTGWFI/F_PIRAPCAP Personnel for Parked Invoice Workflow2RCODEPayee code for invoice processingnvarchar120
TOPCross-System Tools
39CMPWLIMPCustomizing Comparison: Worklist Imports5RCODEReturn Codeint100
TOPCustomizing Project Management IMG
40SPROIDXSTAProject documentation: Document index status table7RCODEReturn codenvarchar40
TOPDocument Management Framework
41FSYSIDXSTASDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
42KDP_IDXSTASDOK: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
43KWMIDXSTAKW Media Demo: Status Table for Indexing Documents7RCODEReturn codenvarchar40
44KWTIDXSTASKWF Test: Status Table for Indexing Documents7RCODEReturn codenvarchar40
TOPDocument Management Services
45IWB0IDXSTASDOK: Status Table for Indexing Documents: IWB07RCODEReturn codenvarchar40
46IWB1IDXSTASDOK: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
47IWB2IDXSTASDOK: Status Table for Indexing Documents: IWB27RCODEReturn codenvarchar40
48KDM_IDXSTAKPro Demo: Status Table for Indexing Documents8RCODEReturn codenvarchar40
49KPROIDXSTAKPRO: Status table for indexing documents7RCODEReturn codenvarchar40
50SDOKIDXSTASDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
51SDOLIDXSTASDOK: Status Table for Indexing Lang. Del.-Relevant PHIOs7RCODEReturn codenvarchar40
52SMAIIDXSTAIndexing Status Language-Indepdt Doc. for mySAP App. Server7RCODEReturn codenvarchar40
53SMASIDXSTASDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
54TESTDIDSTASDOK: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPDocument Management System
55DMS1DIDSTASDOK: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPEmployee Interaction Center
56THREICPHREKnowledge Search: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPExpenditure Certification
57FMEUFOPHDefine Operation Header19RCODERegional Codenvarchar100
58FMEUFRCODERegional Code2RCODERegional Codenvarchar100
59FMEUFRCODETRegional Code - Text Table2RCODERegional Codenvarchar100
TOPFloorplan Manager Web Dynpro ABAP
60FPMATTACHPHRESDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
61FPMNOTES1PHRESDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
TOPGeneric Applications
62BSSP_ATMN_PHREAttachments: Status Table for Indexing Documents8RCODEReturn codenvarchar40
63BSSP_NOTE_PHRENotes: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPGRC Access Control Plug-In
64/VIRSA/ZFFRCDReason Codes2RCODEReason Codenvarchar300
65/VIRSA/ZFFRCDTReason Code Text2RCODEReason Codenvarchar300
TOPHR Administrative Services
66ASRIDXST03ASR: Status Table for Indexing Documents8RCODEReturn codenvarchar40
67T5ASR01PHREContainer HR Admin: Status Table for Indexation of Documents8RCODEReturn codenvarchar40
68T5ASR02PHREAttachments HR Admin: Status Table for Indexation of Documts8RCODEReturn codenvarchar40
TOPImplementation Guide
69CTIMPORTLogical customizing transports: Imports performed7RCODEReturn Codeint100
TOPInformation System
70REISCNIDXST01Contract: Status Table for Indexing Documents8RCODEReturn codenvarchar40
71REISROIDXST01Rental Object: Status Table for Indexing of Documents8RCODEReturn codenvarchar40
TOPInterface to SAP record feedback
72BCOS_PROTCreate Messages: Log File6RCODEReturn Codeint100
TOPKnowledge Warehouse
73CUSTIDXSTASDOK: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
74IWB5IDXSTASDOK: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
75IWB7IDXSTASDOK: Status Table for Document Indexing: IWB17RCODEReturn codenvarchar40
76KWNIDXSTASDOK: Status Table for Indexing Documents: IWB27RCODEReturn codenvarchar40
77TXDPIDXSTASDOK: Status Table for Document Indexing: IWB17RCODEReturn codenvarchar40
78TXMLIDXSTASDOK: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
TOPMaterials Management
79/PSPRO/IDXST01Cust.: Status Table for Indexing Documents8RCODEReturn codenvarchar40
80/PSPRO/IDXST02Cust.: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPMetadata Repository
81BDSIDXSTA10SDOK: Status Table for Indexing Documents7RCODEReturn codenvarchar40
82BDSIDXSTA8BW:: Status Table for Indexing Documents7RCODEReturn codenvarchar40
83RSODIDXSTAMABW Master Data: Status Table for Indexing Documents7RCODEReturn codenvarchar40
84RSODIDXSTATMrsod: Status Table for Indexing Documents7RCODEReturn codenvarchar40
TOPOffice Suite Program
85/OSP/OIDXST01OSP: Status Table for Document Indexing8RCODEReturn codenvarchar40
86/OSP/OIDXST02OSP: Status Table for Document Indexing8RCODEReturn codenvarchar40
87/OSP/OIDXST03OSP: Status Table for Document Indexing8RCODEReturn codenvarchar40
TOPOracle Database Monitors
88DB02_COLL_LOGOracle monitoring: DB02 collector log7RCODEOracle monitoring: total return codenvarchar20
TOPOrganizational Management
89T777RRequest - Server - Table4RCODERequest Codenvarchar40
90T77S1Menu: Functions3RCODERequest Codenvarchar40
91T77S5Menu: Dynamic Menu Functions11RCODERequest Codenvarchar40
TOPPayroll
92T7UAF230Form 23 rows4RCODERow codenvarchar100
93T7UAF230TForm 23 rows texts5RCODERow codenvarchar100
94T7UAF231Form 23 rows4RCODERow codenvarchar100
95T7UAF232Form 23 rows4RCODERow codenvarchar100
TOPPerformance Assessment Workbench
96KWPWIDXSTASDOK: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
TOPPeriodical Sales and Distribution
97JFRPIS-M/SD: Billing Document - Item Data127RCODEIS-M/SD: Rate Codenvarchar40
98JKKDSales Order: Business Data35RCODEIS-M/SD: Rate Codenvarchar40
99JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet17RCODEIS-M/SD: Rate Codenvarchar40
100TJKRRCIS-M/SD: Rate code2RCODEIS-M/SD: Rate Codenvarchar40
101TJKRRCTIS-M/SD: Rate Code: Texts3RCODEIS-M/SD: Rate Codenvarchar40
102TJKWWW_FIXIS-M/SD: WWW, Combinations of Fixed Order Values17RCODEIS-M/SD: Rate Codenvarchar40
TOPProduction Orders
103COCF_SR_K_IDXSTAShift Report: Status Table for Indexing of Documents8RCODEReturn codenvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
104DFMCA_NOTE_ATTNote Attributes for Process Objects5RCODEProcessing Reasonnvarchar100
105TFMCA_ACT_FPFAssign Amendment Action to Form Bundle Process4RCODEProcessing Reasonnvarchar100
106TFMCA_ACT_RCAssign Reason Code to Amendment Actions in FPF5RCODEProcessing Reasonnvarchar100
107TFMCA_FPF_RCODEFPF: Connections between Reason Code and Form Bundle Types3RCODEProcessing Reasonnvarchar100
108TFMCA_RC2REVReason Code Link <--> Revenue Types2RCODEProcessing Reasonnvarchar100
109TFMCA_RCODECustomizing Table for Reason Code2RCODEProcessing Reasonnvarchar100
110TFMCA_RCODETCustomizing Table for Texts for Reason Code3RCODEProcessing Reasonnvarchar100
TOPRecords and Case Management
111RENIDXST01Rendering: Status Table for Indexing Documents8RCODEReturn codenvarchar40
112RPDIDXST01DMWB: Status Table for Indexing Documents8RCODEReturn codenvarchar40
113RPDIDXST02DMWB: Status Table for Indexing Documents8RCODEReturn codenvarchar40
114RPDIDXST03DMWB: Status Table for Indexing Documents8RCODEReturn codenvarchar40
115RPDIDXST04DMWB: Status Table for Indexing Documents8RCODEReturn codenvarchar40
116RPDIDXST05DMWB: Status Table for Indexing Documents8RCODEReturn codenvarchar40
117RPDIDXST06DMWB: Status Table for Indexing Documents8RCODEReturn codenvarchar40
118RPRIDXST01PRO: Status Table for Indexing Documents8RCODEReturn codenvarchar40
119RPRIDXST02PRO: Status Table for Indexing Documents8RCODEReturn codenvarchar40
120RPRIDXST03PRO: Status Table for Indexing Documents8RCODEReturn codenvarchar40
121RPRIDXST04PRO: Status Table for Indexing Documents8RCODEReturn codenvarchar40
122RPRIDXST05Gen. Search: Status Table for Indexing Documents8RCODEReturn codenvarchar40
123RPRIDXST06DOMEA: Status Table for Indexing Documents8RCODEReturn codenvarchar40
124RPRIDXST08PRO: Status Table for Indexing Documents8RCODEReturn codenvarchar40
125RPRIDXST09DMWB: Status Table for Indexing Documents8RCODEReturn codenvarchar40
126RPSIDXST01DOMEA: Status Table for Indexing Documents8RCODEReturn codenvarchar40
127RPSIDXST02DOMEA: Status Table for Indexing Documents8RCODEReturn codenvarchar40
128RPSIDXST03DOMEA: Status Table for Indexing Documents7RCODEReturn codenvarchar40
129RPSIDXST04DOMEA: Status Table for Indexing Documents7RCODEReturn codenvarchar40
130RPSIDXST05DOMEA: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPReporting
131T5N5LText: Calculation Methods (NL)3RCODERoutine Indicatornvarchar30
132T5N5MCalculation Methods for Pensions (NL)2RCODERoutine Indicatornvarchar30
133T5N5QCalculation Table for Pensions (NL)48RCODERoutine Indicatornvarchar30
TOPReusable Components of Business Suite Foundation
134/BOBF/D_IDXSTASDOK: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPSAP Expert Finder
135T7KWIDXSTAT7KW: Status Table for Document Indexing8RCODEReturn codenvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
136/ISHFR/TN290_CODIS-H FR: Receipt Codes2RCODEIS-H FR: Code Receivednvarchar100
TOPSAP Media
137ISM_DM_IDXSTAIS-M DM: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPSAP Records Management
138SRMIDXSP00SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
139SRMIDXSP02SRM Model: Status Table for Indexing Documents7RCODEReturn codenvarchar40
140SRMIDXST01SRM Demo Rec: Status Table for Indexing Documents7RCODEReturn codenvarchar40
141SRMIDXST03SRM Records: Status Table for Indexing Documents7RCODEReturn codenvarchar40
142SRMIDXST04SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
143SRMIDXST05SRM Demo Doc: Status Table for Indexing Documents7RCODEReturn codenvarchar40
144SRMIDXST06SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
145SRMIDXST07SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
146SRMIDXST08SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
147SRMIDXST09SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
148ZRMIDXST05SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
149ZRMIDXST06SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
150ZRMIDXST07SRM Records: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPService
151DVS1IDXSTASDOK: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
TOPSolution Manager Implementation
152IWB4IDXSTAASAP:: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
153SA01IDXSTASOLAR: Status Table for Indexing Documents: IWB17RCODEReturn codenvarchar40
TOPStakeholder Relationship Management
154USC_IDXSTAUSC Documents:: Status Table for Indexing of Documents7RCODEReturn codenvarchar40
155USSDIDXSTAUSS Documents: Status Table for Indexing of Documents7RCODEReturn codenvarchar40
TOPTalent Management
156T77TMCKWDOPHREHCM: DOC: Status Table for Indexing of Documents7RCODEReturn codenvarchar40
157T77TMCKWGRPHREHCM: GRID Icon: Status Table for Indexing of Documents7RCODEReturn codenvarchar40
158T77TMCKWTXPHREHCM: TXT: Status Table for Indexing Documents7RCODEReturn codenvarchar40
TOPText Retrieval and Information Extraction
159SRETDIDSTAStatus Table for Indexing: Non-KPRO Applications7RCODEReturn codenvarchar40
160SRETIDXSTAStatus Table for Indexing: Non-KPRO Applications6RCODEReturn codenvarchar40
TOPTranslation Tools
161LXE_PHRELXE: Status Table for Indexing of Documents: IWB17RCODEReturn codenvarchar40
TOPWeb Channel Framework
162COM_WECWCMPHRECOM_WECWCM: Status Table for Indexing Documents8RCODEReturn codenvarchar40
TOPWorkbench Tools Editors, Painters, Modelers
163SMIMIDXSTAMIME Repository: Status Table for Indexing Documents7RCODEReturn codenvarchar40