SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
8FMARCPAR4Parallelization of FMARC_BATCH
9CEKRS5Movement type parameters for automatic ERS
10/1RA/0SD010MI170Items for Class SD01 - Raw Data

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3ORCT154Incoming Payment
4OVPM154Outgoing Payments
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

170 columns | Print definition?ERP 6.0  | FILENAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FHEADFile header data4FILENAMEStandard Interface File Namenvarchar2550
2/AIF/LFA_DATAFile data for Lean File Adapter3FILENAMEStandard Interface File Namenvarchar2550
3/BSNAGT/FILE_INFFile Status Information5FILENAMEFile Name in the File Systemnvarchar2550
4/DSCSAG/PR_DNCDNC - Protocol Table11FILENAMEOriginal of documentnvarchar2550
5/OTEI/DU_WD_TICDTicket details table11FILENAMEFilenamenvarchar2550
6/OTEI/FU_WD_BUFFile upload buffer6FILENAMEFilenamenvarchar2550
7/OTTM/BL_T_ERBE-Receipt repository12FILENAMEFilenamenvarchar1280
8/SLOAP/DOWNUPLOGDownload / upload log12FILENAMELocal file for upload/downloadnvarchar1280
9BBP_TRANSXSTRINGBBP: Transient Content Storage of xstrings7FILENAMERelative storage location of physical documentnvarchar2550
10CDESK_SRV_TEMPCDESK: Temporary table to store file upload information18FILENAMEOriginal of documentnvarchar2550
11CNVCMIS_A_ARCHCMIS table for storing info. about active archive objects9FILENAMEFile name of archive filenvarchar2550
12CNVCMIS_A_OPFILEOptical Archiving file10FILENAMEFile name of archive filenvarchar2550
13CNVC_SCNG_EXTRExtracts3FILENAMEFilenamenvarchar640
14CNVC_SCWB_FILEFile storage3FILENAMEFilenamenvarchar1280
15CNVC_SCWB_FILE1File length2FILENAMEFilenamenvarchar1280
16CNVC_SCWB_SPRFSpreadsheets filesnames4FILENAMEFilenamenvarchar1280
17CNVHCM_COMPARLOGTDMS4HCM: Protocoll information for payroll compare4FILENAMEFile namenvarchar320
18CNVHCM_COMPARL_TTDMS4HCM: Protocoll information for payroll compare4FILENAMEFile namenvarchar320
19CNVMBTDEXFILESDMIS PCL Data Extract Files4FILENAMELogical file namenvarchar600
20CNV_CMIS_A_ARCHCMIS table for storing info. about active archive objects9FILENAMEFile name of archive filenvarchar2550
21CNV_DOWNUP_LOGDownload / upload log12FILENAMELocal file for upload/downloadnvarchar1280
22CNV_MAPPING_HISTHistory of the mapping downloads6FILENAMELocal file for upload/downloadnvarchar1280
23DMC_FILE_LISTMWB: File List5FILENAMEMWB: File/Directory Namenvarchar2550
24DOCM_STG_DATADBOSC-CM: Staging Data2FILENAMEnvarchar320
25DOCM_STG_HEADERDBOSC-CM: Staging Directory8FILENAMEDBOSC-CM: Filenamenvarchar1280
26DOCM_STG_HISTORYDBOSC-CM: Content Activation History10FILENAMEDBOSC-CM: Filenamenvarchar1280
27FIKZ_FILE_TBLFiles for invoice journal record23FILENAMEFile Name (Electronic Documents Exchange)nvarchar2000
28GRFNFDSSTFMETAFlexible Data Store - Storage Type - File, Meta Data14FILENAMERelative storage location of physical documentnvarchar2550
29IUUC_TRACK_HDRIUUC: Tracking for Delta Replay12FILENAMEMWB: File Namenvarchar2550
30J_1UFDI_FILE_TBLFiles for tax document register record17FILENAMEFilenamenvarchar2000
31J_3RFDI_ARCTable for archiving and logging digital invoices26FILENAMEFile Name (Electronic Documents Exchange)nvarchar2000
32J_3RF_RGTORG_IFSIndex Electronic Documents File Storage24FILENAMEFile Name (Electronic Documents Exchange)nvarchar2000
33LAW2D_ATTACHMENTLAW 2.0 Attachement table4FILENAMEnvarchar10000
34NWS_EXT_PROTSData Transport Management Tool Log Statistics9FILENAMEDataset Namenvarchar1100
35NWS_EXT_TCData Transport Management Tool - Transport Cluster18FILENAMEFile Namenvarchar520
36P05TPRNL_PR_OUTPension Return: PR - Output Data11FILENAMEOutput File Namenvarchar2550
37P05TPRNL_PR_RSPPension Return: PR - Output Data - Response Data7FILENAMEResponse Message File Namenvarchar2550
38RSAUFILESList of Created Audit Log Files5FILENAMEnvarchar10240
39RSBPCR_FILE_UPLDBPC: Upload files2FILENAMEBPC: Field Valuenvarchar600
40RSCRMREPTABRSCRM: Report Table Catalog12FILENAMEFile Namenvarchar600
41SSF_PSE_HISTPSE History1FILENAMEPSE file namenvarchar1000
42SSF_PSE_LConfiguration Table for PSE File Mode3FILENAMEPSE file namenvarchar1000
43SUPGERRORUprade Tools Error Messages3FILENAMEFile Namenvarchar320
44T258ETable for managing external data transfer4FILENAMEName of file on which the external data set is storednvarchar600
45TATRADT_SQLTRACESQL Trace/ABAP Trace2FILENAMEnvarchar400
46TATRAPI_FILES2Trace Files2FILENAMEnvarchar400
47TILM_STORILM DB Store: Root Table / Mapping URI HANDLE9FILENAMEILM DB Store: File Name in File Systemnvarchar10240
48TILM_STOR_RTMILM DB Store: Runtime Management4FILENAMEILM DB Store: File Name in File Systemnvarchar10240
49TMETAObsolete: METAL File Management1FILENAMEVersion of the entry (not used)nvarchar40
50TOAATTable to store the File attributes3FILENAMEnvarchar2550
51VERMODVeris : PureCoverage Info auf Modulebene5FILENAMEVerifikation : Physical Filenamenvarchar2550
52ZFILEDETERMINEApplication file prefix4FILENAMELocal file for upload/downloadnvarchar1280
53PIQDB_NL_CRIHOCRIHO Changes40FILENAMEFilenamenvarchar170
TOPAccounting Interface
54GLE_ECS_DI_ADM0Management of ECS Direct Input5FILENAMEFile Namenvarchar1280
55GLE_RUNADM_IDERP Run Administration24FILENAMEFile Namenvarchar1280
TOPALE Integration Technology
56EDFILEDI: Last processed document in file2FILENAMEFile namenvarchar300
TOPArchive Development Kit
57ADMI_FILESArchive Files of Archive Sessions7FILENAMEFile name of archive filenvarchar2550
58ARCH_ROUT_RULEArchive Routing: Header Per Archiving Object6FILENAMELogical file namenvarchar600
59ARCH_USRCustomizing Table for Archiving2FILENAMELogical file namenvarchar600
60ARCH_XHOMECustomizing of Home Paths2FILENAMELogical Home Pathnvarchar600
TOPBusiness Consolidation
61UCFT002Data Transfer: Flexible Upload6FILENAMEFile Namenvarchar1280
62UCFTL12Data Collection: Hidden Lines in Web Dynpro13FILENAMEFile Namenvarchar1280
63UCL202CLog: Object Number4FILENAMEFile Namenvarchar1280
64UCL205CLog: Object Number5FILENAMEFile Namenvarchar1280
TOPBW Service API
65ROVERTABLETables for Verification Scenarios4FILENAMELocal file for upload/downloadnvarchar1280
66RSAOLTP_DSWRITEGenerated Reports for File Output2FILENAMEFile Name (with path specification)nvarchar2550
TOPCCMS Database Monitors for Oracle
67DBMSGORADatabase Check: Messages11FILENAMEName of Check Filenvarchar2550
TOPClaims Management
68TICL863IBNR Driver4FILENAMEHist. Rec. Data Setnvarchar400
TOPClinical System
69N1BCEXPBasic Cat.: Export11FILENAMEFile Name (255 Characters, with Small Letters)nvarchar2550
70N1BCIMPBasic Cat.: Import7FILENAMEFile Name (255 Characters, with Small Letters)nvarchar2550
71N1MEIMPORTDTi.s.h.med: Medication; Detail Information on Import Packages2FILENAMEMedication: Import File Namenvarchar2550
TOPContract Billing
72EUPDLOGHDISU: Header Data of Update Log for Rate Transport13FILENAMEExplanatory short textnvarchar600
TOPCross-Application Components
73/IXOS/DC_TBCDOCLink table for changeable word documents14FILENAMEFilenamenvarchar2550
74FRE_ORD_FILE_OUTFilenames of saved files from Outbound3FILENAME30 Charactersnvarchar300
75J_8A3T0004store filename and username with reserves fields4FILENAMEfilenamenvarchar2550
76LWM_CC_BRNDTBranding images for citizen connect6FILENAMEFile Namenvarchar500
TOPData Conversion
77DMC_FDESCDMC: Description of Data to Be Imported10FILENAMEDMC: File Name/File Pathnvarchar1280
78DMC_XMLDDMC: Administration of XML Descriptions9FILENAMEDMC: File Name/File Pathnvarchar1280
TOPData Mining
79RSDMTC_PMMLTable for Storing Model PMMLs in String Format5FILENAMEntext10737418230
80RSDMTD_PMMLTable for Storing Model PMMLs in String Format5FILENAMEntext10737418230
TOPData Staging
81RSARCHIPROBW Archiving: General Archiving Properties6FILENAMELogical file namenvarchar600
82RSDADAPBW: Data Archiving Process Header Data22FILENAMELogical file namenvarchar600
83RSFILENAMEDONEFile Names Calculated in Routine2FILENAMEFile Name for External Datanvarchar1280
84RSLDPSELSelection table for fields scheduler33FILENAMEFile Name for External Datanvarchar1280
85RSLDPSELHISTSelection Table for Fields of Scheduler - Changes/History34FILENAMEFile Name for External Datanvarchar1280
86RSLDPSELSHSelection table for fields scheduler32FILENAMEFile Name for External Datanvarchar1280
87RSSELDONEMonitor: Selections for executed request32FILENAMEFile Name for External Datanvarchar1280
TOPData Transfer
88KCDEFILEFlexible Excel Upload: File Name - File_id5FILENAMEGeneric file namenvarchar600
TOPData Transfer Workbench
89DXFILEFiles for Mass Data Transfer to R/33FILENAMEFile namenvarchar1280
90DXFILENOKPossible Corrupt Error Files in Data Transfer2FILENAMEPhysical file namenvarchar1280
91DXFILETRANSPContainer for Transporting Data Information10FILENAMEFile namenvarchar1280
92SXDA1SAPDXfer: Data Transfer Objects and Sub-Category7FILENAMELogical file namenvarchar600
TOPDenmark
93T5M7VForm Entries for PBS File2FILENAMEName of PBS file to which the entries are written.nvarchar80
94T5M7WFile Entries Assignment from T5M7V2FILENAMEName of PBS file to which the entries are written.nvarchar80
95T5M8GMatchcode W Specifically for Payroll Step (DK)13FILENAMEName of PBS file to which the entries are written.nvarchar80
96T5M8JFile entries for PBS file2FILENAMEName of PBS file to which the entries are written.nvarchar80
TOPDirect Bank Communication
97LWM_D_INV_ATTCHMFinancial Payment Approval - Pattern for Invoice File Names2FILENAMEPattern for file names of invoice attachmentsnvarchar1000
TOPDocument Builder
98/IPRO/TATTACHDocument Builder Attachments7FILENAMEntext10737418230
99/IPRO/TOUTPUTFurther defines output in Document Builder7FILENAMEFile Name for Output Typenvarchar2550
TOPDocument Management System
100DMS_DOC_FILESDMS: File Names for Documents8FILENAMEnvarchar2000
101DMS_FILE_CPDMS: Change Documents for Originals in KPRO5FILENAMEOriginal of documentnvarchar2550
102DMS_PHIO2FILEDMS: File Name for Phios3FILENAMEOriginal of documentnvarchar2550
TOPElectronic Bank Statement
103FEBKO_TRANSFERTransferred Bank Statements4FILENAMEPhysical File Namenvarchar5120
104FEB_FILEPATHClient-Dependent Definition of Logical File Paths5FILENAMEPhysical File Namenvarchar5120
TOPEnd User Technology
105RSFECBW Frontend Check4FILENAMEFile date for BW Frontend checknvarchar200
TOPEnvironment, Health and Safety
106/TDAG/CPT_TASKDCP: Dokumente zu Aufgabenpositionen10FILENAMEFile Namenvarchar1320
107/TDAG/CPT_TASKDACP: Dokumente zu Aufgabenpositionen / Archiv10FILENAMEFile Namenvarchar1320
108/TDAG/CPT_TASKICP: Positionsdaten für Aufgaben15FILENAMEFile Namenvarchar1320
109/TDAG/CPT_TASKIACP: Positionsdaten für Aufgaben / Archiv15FILENAMEFile Namenvarchar1320
110/TDAG/CPT_TRCKIObsolete - CP: Tracker - Positionsdaten14FILENAMEFile Namenvarchar1320
111/TDAG/CPT_TRCKIAObsolete - CP: Tracker - Positionsdaten / Archiv14FILENAMEFile Namenvarchar1320
TOPGlobal Trade Services
112/SAPSLL/CORULOBJSLL: Overview of Upload Objects11FILENAMEText of length 255nvarchar2550
TOPGraphical User Interface
113CNTLSTRASCAdministration of components, A-LOBS (Ascii Large OBjectS)1FILENAMECharacter field of length 40nvarchar400
114CNTLSTREAMAdministration of components, BLOBS (Binary Large OBjectS)1FILENAMECharacter field of length 40nvarchar400
115CNTLSTRINFAttributes of a stream1FILENAMECharacter field of length 40nvarchar400
116CNTLSTRLISControl stream list4FILENAMECharacter field of length 40nvarchar400
117FVERSIONDBCache for file information2FILENAMECharacter field of length 40nvarchar400
TOPHelp Infrastructure for ABAP
118HCSKW_TEST_FILETest Data Repository (File)2FILENAMEFile Name for Test Casesnvarchar1000
TOPI18N Unicode
119UMGXMLFILESSUMG: R3load log names1FILENAMEFile namenvarchar1000
TOPIncentive and Commission Management ICM
120TCACS_INDDICFile Names of Dictionary Information Files4FILENAMEFile Name of Dictionary Information File for EDTnvarchar500
TOPInformation Retention Manager
121LRM_BS_RTP_RULESIRM: Rules for Business Suite and Retention Periods19FILENAMELogical file namenvarchar600
TOPInformation system
122FMFINSTATAngaben für den Datenträgeraustausch4FILENAMEPfad und Dateiname für den Datenträgeraustauschnvarchar1280
TOPInternationalization I18N
123CFONT_TEMP_FILEI18N:cascading font, temp uploaded file2FILENAMEnvarchar2000
TOPJob Pricing
124T71JPR06Survey Header Data10FILENAMEPhysical file namenvarchar600
TOPKnowledge Warehouse
125IWSTDGRAFKEn: Standard Graphics3FILENAMEChar255nvarchar2550
TOPLean Staffing
126TSAWE_TRANSFORMStaff Assignment Definition for Transformation4FILENAMEName of a Local Filenvarchar1320
TOPLegacy System Migration Workbench
127/SAPDMC/LSGUSDFILSMW Files Used1FILENAMEFile name (with directory) shortened for lockabilitynvarchar740
128/SAPDMC/LSOFISFile Names per R/3 System7FILENAMEFile Name (with Directory)nvarchar1200
129/SAPDMC/LSOINPLegacy Data: Files6FILENAMEFile Name (with Directory)nvarchar1200
TOPMaintenance Orders
130/MRSS/D_MRS_LOGLog Protocols8FILENAMEChar255nvarchar2550
TOPMass Load
131MDGD_FILE_STATUSMDG Data Load File Processing Status5FILENAMEFile namenvarchar1000
TOPNetWeaver Enterprise Search
132ESH_TAU_UPL_IMGUpload Image via Web Service2FILENAMEChar255nvarchar2550
TOPNon Profit Organizations
133T7UNCMT_LOADSCMT Deliveries Loads Executed6FILENAMEnvarchar2500
TOPOLAP Technology
134RSADMINCCustomizing Table General BW50FILENAMEFlat File Namenvarchar600
TOPOrganizational Flexibility
135/ISDFPS/SV_RUNGenerated Checklists21FILENAMEFilenvarchar2550
TOPPayroll
136T5TPFConfiguration table for medium of pension funds7FILENAMELocal file for upload/downloadnvarchar1280
137T5TZPKonfiguracní tabulka pro médium zivotního pojistení10FILENAMELokální soubor pro upload, resp.downloadnvarchar1280
TOPPension fund Netherlands
138T5NKSActuarial File: Actuarieel bestand2FILENAMEActuarieel bestandnvarchar50
139T5NKSTActuarial File: Omschrijving actuarieel bestand3FILENAMEActuarieel bestandnvarchar50
140T5NKT1Actuarial File: Actuarieel bestand kolomwaarde Actua 12FILENAMEActuarieel bestandnvarchar50
141T5NKT2Actuarial File: Actuarieel bestand kolomwaarde Actua 22FILENAMEActuarieel bestandnvarchar50
TOPPlatform-Independent File Names
142FILETEXTFile Name Description4FILENAMEShort description of logical file namenvarchar600
143FILETEXTCIFile Name Description3FILENAMEShort description of logical file namenvarchar600
TOPProduct Cost Planning
144CKHSHeader: Unit Costing (Control + Totals)78FILENAMEFile or Macro Name for Communication with MS Excelnvarchar120
TOPProduction Orders
145COCF_SRShift Reports in PDF Format2FILENAMEShift Report: File Namenvarchar700
146COCF_SR_DSIGMETASignature Tool: Metadata for Shift Report3FILENAMEShift Report: File Namenvarchar700
TOPReal Estate Management
147VIMIMEHEADRE: Header Data for MIME Object18FILENAMERE: Name of Source File of MIME Objectnvarchar800
TOPReporting
148P05T_RESPONSEWage Return: Table for Response Messages10FILENAMEResponse Message File Namenvarchar2550
TOPRetention Warehouse
149IWP_WPAudit Packages13FILENAMEPath to Filentext10737418230
TOPSAP Business Workflow
150SBF_RU_USAGE_XMLBuffer for Report SBF_RU_USAGE_XML_FILE_EVAL - obsolete4FILENAMEntext10737418230
TOPSAP Healthcare - Industry-Specific Components for Hospitals
151NCD2D_RIS-H: D2D-Kommunikation empfangene Nachrichten (DALE)5FILENAMEISH: Name der Quittungsdatei (DALE-UV)nvarchar1280
152NNLZKIS-H NL: LAZR Kopgegevens LAZR-interface7FILENAMELokaal bestand voor upload/downloadnvarchar1280
TOPSAP NetWeaver Mobile - Use subcomponents
153MICONFIGINFOMI Client Configuration Files3FILENAMECharacter field of length 40nvarchar400
TOPSecure Store and Forward
154SSF_PSE_HSSF: Personel Security Environment12FILENAMEPSE file namenvarchar1000
TOPService Data Download
155/SDF/DBMSGORATable for messages from DB system check11FILENAMEnvarchar2550
TOPSwitch Framework Tools
156SFW_LOGFILELog Files for BC Set Activation7FILENAMEFile Including Pathnvarchar2550
TOPSyntax, Compiler, Runtime
157TPDATRACEADMINTPDA: ABAP Trace Verwaltung7FILENAMETPDA: Dateinamenvarchar700
TOPSystem Landscape DirectoryComponent Repository
158AII_PROFILESAII: Profile Files2FILENAMEPhysical file namenvarchar600
TOPTakeoverHandover of Technical Objects
159PHINHHeader Table for Take Over13FILENAMETakeover / Handover: File Namenvarchar400
TOPTime Sheet
160CATS_MY_DOCUCATS notebook: Create and Distribute HTML Documentation7FILENAMELogical file namenvarchar600
TOPTransaction Manager
161TCORIT_FILESTreasury: Uploaded files3FILENAMEName of the filenvarchar600
TOPTranslation Tools
162LXE_OBJ_EXP_OBJObject export header (objects)11FILENAMEFile Namenvarchar640
163TTRALLock table - objects for SE63 translation tool locked5FILENAMECHAR08nvarchar80
TOPTransport Management System
164CMSSACTFILESCMS: Active Files for Steering SDM3FILENAMEText, 255 Charactersnvarchar2550
TOPTransport Organizer
165CTS_FILELOCKECTS: File Locking for Upload2FILENAMEFile Including Pathnvarchar2550
TOPTreasury
166VTB_MDTABKALIndividual Settings: Spreadsheet2FILENAMELocal file for upload/downloadnvarchar1280
TOPUpstream Graphics
167OIUGT_ICONUpstream Graphics Icons and Reporting Flash Forms1FILENAMELocal file for upload/downloadnvarchar1280
TOPValuation
168OIUVL_DD_MASTERMaster DD list4FILENAMELocal file for upload/downloadnvarchar1280
TOPWeb Dynpro ABAP
169WDG_GEN_LOGWeb Dynpro Generation Log7FILENAMEnvarchar600
TOPWeb Service and SOAP - ABAP
170SRT_TRC_FILESlist of all trace file names3FILENAMEnvarchar640