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

188 columns | Print definition?ERP 6.0  | DOCID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/BAPIRET2Table to log ICC <-> SAP process errors2DOCIDDocument Ledger Numbernvarchar120
2/OPT/CT_LG_ERRORLog error trace2DOCIDDocument Ledger Numbernvarchar120
3/OPT/CT_LG_EXCLog event history - Exception detail dimension2DOCIDDocument Ledger Numbernvarchar120
4/OPT/CT_LG_HISTLog event history2DOCIDDocument Ledger Numbernvarchar120
5/OPT/CT_PMC_RG00VIM WP registration: Process key info for a WI9DOCIDDocument Ledger Numbernvarchar120
6/OPT/CT_PMC_RG01VIM WP registration: Inbox items4DOCIDDocument Ledger Numbernvarchar120
7/OPT/CT_PMC_RG02VIM WP registration: Pending processes3DOCIDDocument Ledger Numbernvarchar120
8/OPT/CT_PMC_RG03VIM WP registration: Completed processes3DOCIDDocument Ledger Numbernvarchar120
9/OPT/CT_PMC_RGBSVIM WP registration: Smart selection criteria/ restrictions2DOCIDDocument Ledger Numbernvarchar120
10/OPT/DT_BP_1BRBest Practice Framework - One time Business Rules2DOCIDDocument Ledger Numbernvarchar120
11/OPT/DT_BR_WAITProcess Types with Wait / Rerun indicator2DOCIDDocument Ledger Numbernvarchar120
12/OPT/LIAP_MATXLine Item Approval Matrix Table3DOCIDReference Keynvarchar200
13/OPT/VIM_1ATM_HStatus table for automation report (document headers)2DOCIDDocument Ledger Numbernvarchar120
14/OPT/VIM_1CLEAR/OPT/VIM_1HEAD Extension with Clearing Documents (BSAK)3DOCIDDocument Ledger Numbernvarchar120
15/OPT/VIM_1EXT_HTable: OCR Exported data after extraction/recognition2DOCIDDocument Ledger Numbernvarchar120
16/OPT/VIM_1ITEM_SDocument Item2DOCIDDocument Ledger Numbernvarchar120
17/OPT/VIM_1PO_DNPO Number and DN List for VIM Documents2DOCIDDocument Ledger Numbernvarchar120
18/OPT/VIM_1PROCWorkflow Information for VIM Processes4DOCIDDocument Ledger Numbernvarchar120
19/OPT/VIM_1REVISNRevision Numbers / Dates for Russion Invoices2DOCIDDocument Ledger Numbernvarchar120
20/OPT/VIM_2HEADAdditional Fields for Table /OPT/VIM_1HEAD2DOCIDDocument Ledger Numbernvarchar120
21/OPT/VIM_CUSTOMSCustoms data for imported goods2DOCIDDocument Ledger Numbernvarchar120
22/OPT/VIM_CWHTAXClassic Withholding tax data for document2DOCIDDocument Ledger Numbernvarchar120
23/OPT/VIM_DOC_URLTable: XML Document URL(of DP document)2DOCIDDocument Ledger Numbernvarchar120
24/OPT/VIM_DP_SYNCVIM DP Trigger Program Sync Table2DOCIDDocument Ledger Numbernvarchar120
25/OPT/VIM_IMG_URLTable: Image URL of DP Document2DOCIDDocument Ledger Numbernvarchar120
26/OPT/VIM_LIC_IDCollect Docids ICC5DOCIDDocument Ledger Numbernvarchar120
27/OPT/VIM_LIC_VDCollect Docids VIM5DOCIDDocument Ledger Numbernvarchar120
28/OPT/VIM_MSG_TTable to store messages2DOCIDDocument Ledger Numbernvarchar120
29/OPT/VIM_T125Bypass/Simulate Business Rules2DOCIDDocument Ledger Numbernvarchar120
30/OPT/VIM_TITEMDocument Item2DOCIDDocument Ledger Numbernvarchar120
31/OPT/VIM_VAL_AGTTable: DP documents and correspnding VALIDATORs2DOCIDDocument Ledger Numbernvarchar120
32/OPT/VIM_WHTAXWithholding tax data for document2DOCIDDocument Ledger Numbernvarchar120
33/OPT/VT_ATM_SRCSource Table for the Aggregations of the ATM report3DOCIDDocument Ledger Numbernvarchar120
34/OPT/VT_DOC_HReporting table: Document header3DOCIDDocument Ledger Numbernvarchar120
35/OPT/VT_DOC_HEA1Document Header - copy of /opt/vt_doc_head3DOCIDDocument Ledger Numbernvarchar120
36/OPT/VT_DOC_HEADDocument Header3DOCIDDocument Ledger Numbernvarchar120
37/OPT/VT_KPI_SRCSource Table for the Aggregations of the KPI Dashboard3DOCIDDocument Ledger Numbernvarchar120
38/OPT/VT_KPI_SRCEContains All Occured Exceptions during the whole process2DOCIDDocument Ledger Numbernvarchar120
39/OPT/VT_LATE_DPTable to store late DPs2DOCIDDocument Ledger Numbernvarchar120
40/OPT/VT_WIReporting table: Workitems4DOCIDDocument Ledger Numbernvarchar120
41/OPT/VT_WORKITE1Work Item Header Table - Copy of /opt/vt_workitem5DOCIDDocument Ledger Numbernvarchar120
42/OPT/VT_WORKITEMWork Item Header Table5DOCIDDocument Ledger Numbernvarchar120
43/OPT/WI_UPGDWorkflow ID Conversion status table2DOCIDDocument Ledger Numbernvarchar120
44/OPT/WT_3SSupplier Self Service Data3DOCIDDocument Ledger Numbernvarchar120
45/OPT/WT_3S_PYMNTSupplier Self Service Payment Information3DOCIDDocument Ledger Numbernvarchar120
46/OPT/WT_3S_VALUESupplier Self Service - Field Value Table for PO/DN3DOCIDDocument Ledger Numbernvarchar120
47/ORS/PS_ITEMProfitability Segment Fields and Values2DOCIDDocument Ledger Numbernvarchar120
48/XFT/MIG_TCRCONNLocation3DOCIDEMC Docidnvarchar700
49/XFT/MIG_TDOCDocument head3DOCIDEMC Docidnvarchar700
50/XFT/MIG_TDOCPOSDocument head3DOCIDEMC Docidnvarchar700
51/XFT/MIG_TEMCCONLocation EMC Centera Documents3DOCIDEMC Docidnvarchar700
52BBPD_CMS_DOCCMS Documents41DOCIDKM Document IDnvarchar1220
53BBPD_CMS_DOC_INTCMS Documents - Internal Versions5DOCIDKM Document IDnvarchar1220
54CNVTDMSSCM_DOCIdentification of Delivery in EWM4DOCIDGUID for CNVTDMSCRM_*varbinary160
55EHPRCC_DOCGADocument group - Document assignment3DOCIDDocument IDnvarchar100
56EHPRCC_DOCGA_TDocument group - Document assignment Description4DOCIDDocument IDnvarchar100
57EHPRCD_DOCGADocument group - Document assignment3DOCIDDocument IDnvarchar100
58ICL_CPROCDOCInternal Claim Type: Manual Claim Document per CIG Category7DOCIDClaim Documentnvarchar40
59J_1ILOCDOCTCEXIM: LC Documents & Terms and Conditions9DOCIDID for documents and relationsnvarchar320
60J_1I_PMLICUTILEXIM : License Utilization10DOCIDDocument IDnvarchar40
61T578AMedical Doctors3DOCIDDoctor keynvarchar40
62T77WWW_CLDCLTXTReimbursement Type Declaration Text(Dialog Text)9DOCIDDocument ID to hold the Dialog Textnvarchar600
63T7RU2NDFL2-NDFL catalogue11DOCIDDocument ID of Form 2-NDFLnvarchar80
64TMAS_D_DDDocument data1DOCIDDocument idnvarchar160
65TMAS_D_DFPDocuments for processing1DOCIDDocument idnvarchar160
66TMAS_D_DFP7Documents for processing by Trados 20071DOCIDDocument idnvarchar160
67TMAS_D_DIPDocuments in process1DOCIDDocument idnvarchar160
68TMAS_D_DIP7Documents in process by Trados 20071DOCIDDocument idnvarchar160
69TMAS_D_RERRAnalysis result error table1DOCIDDocument idnvarchar160
70TMAS_D_RHDAnalysis result header data1DOCIDDocument idnvarchar160
71TMAS_D_RT2007Trados 2007 analysis results1DOCIDDocument idnvarchar160
72TMAS_D_UDSDUser-defined string document data1DOCIDDocument idnvarchar160
73TMAS_D_UDXDUser-defined xstring document data1DOCIDDocument idnvarchar160
74YVIM_1ITEMDocument Item2DOCIDDocument Ledger Numbernvarchar120
75PIQDBAGR_LOGActivity Document: Appraisal Change2DOCIDActivity Document Identification Keynvarchar320
76PIQPROC_ADM_DTActivity Document: Admission Detailed Data2DOCIDActivity Document Identification Keynvarchar320
77PIQPROC_AUD1Obsolete as of 4.72: Activity Documents: Audit Detailed Data2DOCIDActivity Document Identification Keynvarchar320
78PIQPROC_AWCDActivity Docs: Activity/Change Document and Module Booking2DOCIDActivity Document Identification Keynvarchar320
79PIQPROC_AWCTActivity Docs: Academic Work Context Data2DOCIDActivity Document Identification Keynvarchar320
80PIQPROC_CDActivity Documents: Activity Doc./Change Doc. Assignment2DOCIDActivity Document Identification Keynvarchar320
81PIQPROC_DHActivity Documents: Document Header2DOCIDActivity Document Identification Keynvarchar320
82PIQPROC_ED_EXT_WED Activity Document: External Work of Equivalency2DOCIDActivity Document Identification Keynvarchar320
83PIQPROC_ED_GRPED Activity Document: Transferred Work Grouping2DOCIDActivity Document Identification Keynvarchar320
84PIQPROC_ED_HED Activity Document: Header Data2DOCIDActivity Document Identification Keynvarchar320
85PIQPROC_ED_INT_WED Activity Document: Transferred Internal Academic Work2DOCIDActivity Document Identification Keynvarchar320
86PIQPROC_PG_DTActivity Document: Progression Details2DOCIDActivity Document Identification Keynvarchar320
87PIQPROC_PG_LIActivity Document: Academic Performance Index2DOCIDActivity Document Identification Keynvarchar320
88PIQPROC_PG_MBActivity Document: Module Booking2DOCIDActivity Document Identification Keynvarchar320
89PIQPROC_PG_RTActivity Document: Reset Progression Results2DOCIDActivity Document Identification Keynvarchar320
TOPAccounting Interface
90GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)15DOCIDDocument typenvarchar100
91GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)15DOCIDDocument typenvarchar100
TOPAccounts Receivable Accounting Process Integration
92EBPP_ORDER_ITMPayment Orders via Biller Direct: Items7DOCIDCharacter field length 24nvarchar240
TOPArchiveLink
93TOACACache for frontend files3DOCIDSAP ArchiveLink: Document IDnvarchar400
TOPAustria
94T5A5KForms for domestic sickness certificates4DOCIDDoctor keynvarchar40
95T5A5ZSystem Responses for Master Data Maintenance4DOCIDDoctor keynvarchar40
TOPBalanced Scorecard
96UMB_OFL_STATUSDownload Process Status15DOCIDBusiness Document Service: Document IDnvarchar420
TOPBenefits
97T74HLBenefit forms6DOCIDBusiness Document Service: Document IDnvarchar420
TOPBrowser-Based PI Sheet Cockpit
98POC_DB_C_TRIGGERDomain Model: Trigger Collection12DOCIDDomain Model: Document Identifiernvarchar180
99POC_DB_DEV_SIGNSignature Key: Metadata Signature Process Step3DOCIDDomain Model: Document Identifiernvarchar180
100POC_DB_EVT_SIGNSignature Keys: Metadata for Event Log3DOCIDDomain Model: Document Identifiernvarchar180
101POC_DB_STEP_SIGNSignature Key: Metadata Signature Process Step3DOCIDDomain Model: Document Identifiernvarchar180
TOPBudget Management
102HRP1517DB-Table for Infotype 151718DOCIDHR-FPM: Document ID for Excel Help Filenvarchar420
TOPBusiness Information Collection
103UIDOCResults Document of a Research Run (SEM-BIC)2DOCIDDocument IDnvarchar420
TOPClaims Management
104ICLDOCDocument to be Sent in Claim9DOCIDClaim Documentnvarchar40
105ICL_ACTN_3000BRFplus : Document Proposal (Customizing)5DOCIDClaim Documentnvarchar40
106ICL_ACTN_3000ABRFplus : Document Proposal (Application)5DOCIDClaim Documentnvarchar40
107ICL_ACTN_3000SBRFplus: Document Proposal (System)4DOCIDClaim Documentnvarchar40
108ICL_CPCFDOCTYPEAssignment Category per Document2DOCIDClaim Documentnvarchar40
109ICL_CPCFICT2DOCPermitted Internal Claim Types for Documents2DOCIDClaim Documentnvarchar40
110ICSDOCDocument in Claim9DOCIDClaim Documentnvarchar40
111TICL031Claim Document2DOCIDClaim Documentnvarchar40
112TICL031TClaim Document - Text3DOCIDClaim Documentnvarchar40
113TICL032Roles of Permitted Recipients for Claim Documents2DOCIDClaim Documentnvarchar40
114TICL038Claims Management - Activity6DOCIDClaim Documentnvarchar40
115TICL046Internal Claim Type: Permitted Manual Claim Document6DOCIDClaim Documentnvarchar40
116TICL349Claim Documents: Assignment of Text Objects and Text ID2DOCIDClaim Documentnvarchar40
117TICL933For BRF: Documents7DOCIDClaim Documentnvarchar40
TOPClaims Processing Asia
118T7XASDDoctors details3DOCIDDoctor IDnvarchar40
119T7XASFGrouping of Doctors to Panel4DOCIDDoctor IDnvarchar40
120T7XASTClaims processing transaction table13DOCIDDoctor IDnvarchar40
TOPCollaboration Folders
121CFX_ECN_OBJApplication table to store objects linked to an ECN.3DOCIDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPCross-Application Components
122/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices2DOCIDDocument Ledger Numbernvarchar120
123/OPT/VIM_HD_NPOVIM IE Monitor: Header Data for Parked NPO Invoices19DOCIDDocument Ledger Numbernvarchar120
124/OPT/VIM_HD_POVIM IE Monitor: Header Data for Parked PO Invoices22DOCIDDocument Ledger Numbernvarchar120
TOPDocument Management Services
125SDOKIOCHNGSDOK: Delta Recording of KPro Objects on Upgrade1DOCIDID for documents and relationsnvarchar320
126SDOKIOCHNG2Like SDOKIOCHNG, empty only for encapsulation of lock manag.1DOCIDID for documents and relationsnvarchar320
TOPDocumentation Tools
127DOKSHDocumentation Statistics History5DOCIDDocument classnvarchar20
128DOKSIDocumentation Statistics History Index3DOCIDDocument classnvarchar20
129DOSSHDocumentation: Short Text Statistics History5DOCIDDocument classnvarchar20
130DOSSIDocumentation: Short Text Statistics History Index3DOCIDDocument classnvarchar20
131DOSSODocumentation: Short Text Statistics - Object-Specific4DOCIDDocument classnvarchar20
TOPE-Recruiting
132T77RCF_DOCIDDocument Types4DOCIDKW Document IDnvarchar200
TOPEngineering Documents
133EDMS_AT01EDMS: Documents - GUID7DOCIDEDMS: Document IDnvarchar320
TOPEnvironment, Health and Safety
134/TDAG/RCSA_DOCGADocument group - Document assignment2DOCIDDocument IDnvarchar100
135/TDAG/RCSC_DOCGADocument group - Document assignment3DOCIDDocument IDnvarchar100
TOPExcise Duty
136/BEV2/EDARCDOCIDIndex Table for Archive Documents9DOCIDNatural Numberint100
TOPFinancial Accounting
137/OPT/VIM_1BDCLOGBDC Log2DOCIDDocument Ledger Numbernvarchar120
138/OPT/VIM_1HEADDocument Header2DOCIDDocument Ledger Numbernvarchar120
139/OPT/VIM_1ITEMDocument Item2DOCIDDocument Ledger Numbernvarchar120
140/OPT/VIM_1LOGDocument Log2DOCIDDocument Ledger Numbernvarchar120
141/OPT/VIM_1OCRLOGDocument Processing - OCR Log Data2DOCIDDocument Ledger Numbernvarchar120
142/OPT/VT_WORKWork Item Header Table - Real Time5DOCIDDocument Ledger Numbernvarchar120
143/OPT/VW_PROC_CHKTable to check Process Type for DP document2DOCIDDocument Ledger Numbernvarchar120
TOPIntegrated Product and Process Engineering
144PNRESiPPE Resource Node: Attributes10DOCIDInternal Document Key for iPPEnvarchar330
145PVCMPDPVS Variant (CMP): Basic Data8DOCIDInternal Document Key for iPPEnvarchar330
146PVCONiPPE Concept8DOCIDInternal Document Key for iPPEnvarchar330
TOPProcess Management
147POC_DB_APPL_STEPDomain Model: Application Steps2DOCIDDomain Model: Document Identifiernvarchar180
148POC_DB_COMMANDDomain Model: Table for Step Commands6DOCIDDomain Model: Document Identifiernvarchar180
149POC_DB_CONF_REQDomain Model: Table for Signature Requests10DOCIDDomain Model: Document Identifiernvarchar180
150POC_DB_C_COMMANDDomain Model: Command Collection4DOCIDDomain Model: Document Identifiernvarchar180
151POC_DB_C_COMMENTDomain Model: Comment Collection8DOCIDDomain Model: Document Identifiernvarchar180
152POC_DB_C_DEVIATDomain Model: Deviation Collection10DOCIDDomain Model: Document Identifiernvarchar180
153POC_DB_C_DEVVARDomain model: Collection for variable setting (deviation)6DOCIDDomain Model: Document Identifiernvarchar180
154POC_DB_C_METADATDomain Model: Local Value Collection8DOCIDDomain Model: Document Identifiernvarchar180
155POC_DB_C_OPERDomain Model: Operation Collection10DOCIDDomain Model: Document Identifiernvarchar180
156POC_DB_C_PARTITDomain Model: Partition Element Collection5DOCIDDomain Model: Document Identifiernvarchar180
157POC_DB_C_PREDECDomain Model: Predecessor Table5DOCIDDomain Model: Document Identifiernvarchar180
158POC_DB_C_SERVICEDomain Model: Service Operation Collection6DOCIDDomain Model: Document Identifiernvarchar180
159POC_DB_C_STEPDomain Model: Step Collection6DOCIDDomain Model: Document Identifiernvarchar180
160POC_DB_C_VALUEDomain Model: Value Container Collection6DOCIDDomain Model: Document Identifiernvarchar180
161POC_DB_DATA_REQDomain Model: Table for Data Requests12DOCIDDomain Model: Document Identifiernvarchar180
162POC_DB_DOMAINDomain Model: Database Table for Domains4DOCIDDomain Model: Document Identifiernvarchar180
163POC_DB_EXEC_REQDomain Model: Table for Execution Request7DOCIDDomain Model: Document Identifiernvarchar180
164POC_DB_EXEC_STRADomain Model: Table for Execution Strategies5DOCIDDomain Model: Document Identifiernvarchar180
165POC_DB_MESS_REQDomain Model: Table for Message Requests7DOCIDDomain Model: Document Identifiernvarchar180
166POC_DB_OPERATIONDomain Model: Table for Operations8DOCIDDomain Model: Document Identifiernvarchar180
167POC_DB_PARTITIONDomain Model: Partition6DOCIDDomain Model: Document Identifiernvarchar180
168POC_DB_PROC_STEPDomain Model: Table for Process Steps9DOCIDDomain Model: Document Identifiernvarchar180
169POC_DB_SIGNATUREDomain Model: Signature5DOCIDDomain Model: Document Identifiernvarchar180
170POC_DB_SIG_HANDLDomain Model: Signature Handler9DOCIDDomain Model: Document Identifiernvarchar180
171POC_DB_STEPDomain Model: Table for Step Basic Data14DOCIDDomain Model: Document Identifiernvarchar180
172POC_DB_VALUEDomain Model: DB Table for Value Container13DOCIDDomain Model: Document Identifiernvarchar180
TOPRussia
173PA0298HR Master Record: Infotype 029835DOCIDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPSAP Utilities
174ECUST_DOC_INStore the reference of the documents provided by customer7DOCIDDocument Idnvarchar40
175ECUST_DOC_TYPDocuments assigned to document category5DOCIDDocument Idnvarchar40
176ECUST_DOC_TYPTXTDocuments assigned to document category5DOCIDDocument Idnvarchar40
177ECUST_DOC_TYP_INDocuments assigned to document category5DOCIDDocument Idnvarchar40
178EDOC_ID_INList of Documents2DOCIDDocument Idnvarchar40
179EDOC_ID_INTXTList of Documents2DOCIDDocument Idnvarchar40
TOPSAPscript
180STXBITMAPSSAPscript Graphics Management5DOCIDBusiness Document Service: Document IDnvarchar420
TOPSocial Services and Social Security
181PSSCC_SWITCHSocial Services Switches3DOCIDSwitch Documentation IDnvarchar40
TOPTalent Management
182T77TMC_GRID_REPGrid Repository2DOCIDID for documents and relationsnvarchar320
TOPText Retrieval and Information Extraction
183SRETDIDJOBJob Table for Indexing Non-KPRO Applications3DOCIDDocument IDnvarchar640
184SRETDIDSTAStatus Table for Indexing: Non-KPRO Applications3DOCIDDocument IDnvarchar640
185SRETIDXJOBJob Table Indexing of Non-KPRO Applications Cross-Client2DOCIDDocument IDnvarchar640
186SRETIDXSTAStatus Table for Indexing: Non-KPRO Applications2DOCIDDocument IDnvarchar640
TOPTraining and Event Management
187HRT1062Table Section Infotype 10625DOCIDID for Documents and Relationshipsnvarchar320
TOPUSA
188PA0106HR Master Record: Infotype 0106 (Related Persons NA)40DOCIDBenefit Physician IDnvarchar200