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

179 columns | Print definition?ERP 6.0  | FILE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/NLG_FILESGBA NL: Values of Importing/Exporting Reports7FILE_TYPELocation of GBA File (Presentation/Application Server)nvarchar10
2/IXOS/DCCMPHFSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
3/PLMB/EXP_LAYOUTDownload Data: Selection Layout7FILE_TYPEFormat of Downloaded Filenvarchar300
4/SAPSRM/CAT_FILEFTP File Information for Contract-to-Catalog Upload2FILE_TYPEFile Type for Contract- to-Catalog Uploadnvarchar400
5AUDCHKOAudit: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
6BBP_PHFSDOK: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
7BDSPHF19BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
8CDESK_SRV_TEMPCDESK: Temporary table to store file upload information29FILE_TYPEType of data transfernvarchar10
9CMCHKOCash Management: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
10CNVMBTDEXFILESDMIS PCL Data Extract Files2FILE_TYPEDMIS PCL Data Extract File typenvarchar10
11CNVMBTDEXFILSTATDMIS PCL Status of Data Extract Files2FILE_TYPEDMIS PCL Data Extract File typenvarchar10
12CNVMBTDEXTYPEDEFDMIS PCL Data Extract Types - Definition of elements5FILE_TYPEDMIS PCL Data Extract File typenvarchar10
13EDOCUMENTFILEeDocument: File5FILE_TYPEeDocument: File Typenvarchar100
14EDOFILETYPEeDocument: File Types per Country2FILE_TYPEeDocument: File Typenvarchar100
15EDOFILETYPETeDocument File Type Description3FILE_TYPEeDocument: File Typenvarchar100
16FARRCHKOSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
17FARR_ATTAHCHKOSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
18FIEUC_SBXML_PATHSAFT: Destination for storing XML files for SAF-T reporting5FILE_TYPESAF:T : Type of filenvarchar20
19FUCNCHKOSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
20FUCN_CHKOSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
21GRFNCCIFILEPATHLogical File Path7FILE_TYPEFile Typenvarchar120
22J_1I_EXIMCHKOEXIM:: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
23J_1I_EXIMNCHKOEXIM Notes : Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
24SMDPHFPhysical Info Object file table10FILE_TYPEType of data transfernvarchar10
25TLRT_TARO_DOCTrade Repository: Documents11FILE_TYPEType of file attached to TAROnvarchar10
26ZIDPHF01SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
27PIQPHF01Campus Mgmt: Files of Physical Info Objects10FILE_TYPEType of data transfernvarchar10
28PIQPHF02Campus Mgmt: Files of Physical Info Objects9FILE_TYPEType of data transfernvarchar10
29PIQPHF03Campus Mgmt: Files of Physical Info Objects10FILE_TYPEType of data transfernvarchar10
TOPAuthoring Tools
30QMM_PHFQMM: Files of Physical Info Objects9FILE_TYPEType of data transfernvarchar10
TOPBasic Functions
31UDMPHF01Dispute Management: Files for Physical Information Objects10FILE_TYPEType of data transfernvarchar10
32UDMPHF02Dispute Management: Files for Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPBudgeting
33BTXPHF01Budge_text: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPBusiness Document Service
34BDSPHF2BDS: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
35BDSPHF6BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
36BDSPHF7BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
37BDS_PHFBDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
38KWBPHFKW BDS Demo:: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
TOPBusiness Information Collection
39BDSPHF13BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
40UIDCPHFUI Documents: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPBusiness Package for Manager Self-Service FI
41FPB_EXPCHKOSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPBusiness Planning and Simulation
42BDSPHF12BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
43BDSPHF31BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPCase Management
44SCMGPHF01Case: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPCollaboration Folders
45CFF_ADD_PHFSDOK: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
46CFF_PHFCollaboration Folders - PHIO: Instances Physical Info: Dat10FILE_TYPEType of data transfernvarchar10
TOPCollaborative Cross Applications
47/POA/D_CLM_ATCHPackage Attachments8FILE_TYPEStringntext10737418230
TOPCommunication Services Mail, Fax, SMS, Telephony
48SBCMPHFBCOM MIME: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPControlling
49BDSPHF24BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
50FCOMTS_CR_CHKOSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPCorporate Performance Monitor
51BDSPHF15BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
52BDSPHF17BDS: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
53UMC_FILE_CACHECache for Generated Files6FILE_TYPEHTML content typenvarchar1280
TOPCost Center Accounting
54KPP1PHFKPP: Files for logical info objects10FILE_TYPEType of data transfernvarchar10
TOPCross-Application Components
55/IXOS/RMPHF/IXOS/:: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
56ZGADGETS_FILESGadget file database3FILE_TYPEMime type of filentext10737418230
TOPCustomizing Project Management IMG
57SPROPHFProject documentation: Physical info object files9FILE_TYPEType of data transfernvarchar10
TOPDocument Management Framework
58FSYSPHFSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
59KDP_PHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
60KWMPHFKW Media Demo: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
61KWTPHFSKWF Test: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPDocument Management Services
62KDM_PHFKPro Demo: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
63KPROPHFKPRO: Files of physical information objects9FILE_TYPEType of data transfernvarchar10
64KPROPHFCDKPRO: CD: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
65SDOKPHFSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
66SDOKPHFCDSDOK: Files of Physical Information Objects, Client-Specific10FILE_TYPEType of data transfernvarchar10
67SDOLPHFSDOK: Components of Language Delivery-Relevant PHIOs10FILE_TYPEType of data transfernvarchar10
68SMAIPHFFiles Lang.-Independent Physical Doc. for mySAP App. Server10FILE_TYPEType of data transfernvarchar10
69SMASPHFSDOK: Files of Physical Information Objects11FILE_TYPEType of data transfernvarchar10
TOPDocument Management System
70DMS_PHF_CD1DVS: PHIOS Components of main originals (conv. document)10FILE_TYPEType of data transfernvarchar10
71DMS_PHF_HD1DVS: PHIOS Components of additional files (help document)10FILE_TYPEType of data transfernvarchar10
TOPeCATT Extended Computer Aided Test Tool
72ECLOG_EXTTable of Test Tool Log of Script Line7FILE_TYPE3-Byte fieldnvarchar30
TOPECM ABAP Stack
73NWECM_T_CMISConfiguration for CMIS Connector5FILE_TYPEnvarchar1200
74NWECM_T_CMIS_CFGECMI: CMIS Repository Configuration5FILE_TYPECMIS Typenvarchar2000
TOPEmployee Interaction Center
75THREICCHKOKnowledge Search: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPEnd User Technology
76BDSPHF11BDS: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPFloorplan Manager Web Dynpro ABAP
77FPMATTACHCHKOSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
78FPMNOTES1CHKOSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPFlow Manufacturing
79TLDPS_PHFProcess Sheet: Physical info object files10FILE_TYPEType of data transfernvarchar10
80TLDPS_PHF_SProcess Sheet: Physical info object files9FILE_TYPEType of data transfernvarchar10
TOPGeneric Applications
81BSSP_ATMN_CHKOAttachments: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
82BSSP_NOTE_CHKONotes: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPGlobal Trade Services
83/SAPSLL/CORPHFLLS: Files of Physical Information Objects (KPRO)10FILE_TYPEType of data transfernvarchar10
TOPGovernance, Risk and Compliance
84GRFNCHKOFOPC:: Files for Physical Information Objects10FILE_TYPEType of data transfernvarchar10
85GRPCCHKOGRC: Files for Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPHR Administrative Services
86ASRPHF03ASR: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
87T5ASR01CHKOContainer HR Admin: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
88T5ASR02CHKOAttachments HR Admin: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPInformation System
89REISCNPHF01Contract: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
90REISROPHF01Rental Object: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPKnowledge Warehouse
91CUSTPHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
92IWB0PHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
93IWB1PHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
94IWB2PHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
95IWB5PHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
96IWB7PHFSAP KW: Physical Info Object Files9FILE_TYPEType of data transfernvarchar10
97KWNPHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
98TXDPPHFSAP KW: Physical Info Object Files9FILE_TYPEType of data transfernvarchar10
99TXMLPHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
TOPLaunchpad
100BDSPHF24ABDS: Files of physical Info Objects10FILE_TYPEType of data transfernvarchar10
TOPManagement of Internal Controls
101FOPCPHFFOPC:: Files for Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPMaterials Management
102/PSPRO/PHF01Cust.: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
103/PSPRO/PHF02Cust.: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPMetadata Repository
104BDSPHF10SDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
105BDSPHF8BW: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
106RSODPHFMABW Master Data: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
107RSODPHFTMrsod: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPOffice Suite Program
108/OSP/OPHF01OSP: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
109/OSP/OPHF02OSP: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
110/OSP/OPHF03OSP: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPOracle Database Monitors
111ORA_STT_DATADBACockpit: Data table for RSORASTT2FILE_TYPEOracle: File extensionnvarchar30
TOPPayment Transactions
112FIEBPHFFIEB: Physical document files10FILE_TYPEType of data transfernvarchar10
TOPPayroll General Parts
113DSYS_PHFILE_CCD2DSYS2: Files of Physical Information Objects12FILE_TYPEType of data transfernvarchar10
114DSYS_PHFILE_C_CDDSYS: Physical information object files10FILE_TYPEType of data transfernvarchar10
115DSYS_PHFILE_ECD2DSYS2: Files of Physical Information Objects12FILE_TYPEType of data transfernvarchar10
116DSYS_PHFILE_ECI2DSYS2: Files of Physical Information Objects11FILE_TYPEType of data transfernvarchar10
117DSYS_PHFILE_E_CDDSYS: Physical information object files10FILE_TYPEType of data transfernvarchar10
118DSYS_PHFILE_E_CIDSYS: Physical information object files9FILE_TYPEType of data transfernvarchar10
TOPPerformance Assessment Workbench
119KWPWPHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
TOPProcess Management
120BDSPHF25BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPProduction Orders
121COCF_SR_K_PHFShift Report: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPReal Estate Management
122BDSPHF26BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPRecords and Case Management
123RENPHF01Rendering: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
124RPDPHF01DMWB: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
125RPDPHF02DMWB: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
126RPDPHF03DMWB: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
127RPDPHF04DMWB: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
128RPDPHF05DMWB: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
129RPDPHF06DMWB: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
130RPRPHF01PRO: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
131RPRPHF02PRO: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
132RPRPHF03PRO: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
133RPRPHF04PRO: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
134RPRPHF05Gen. Search: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
135RPRPHF06DOMEA: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
136RPRPHF08PRO: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
137RPRPHF09DMWB: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
138RPSPHF01DOMEA: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
139RPSPHF02DOMEA: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
140RPSPHF03DOMEA: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
141RPSPHF04DOMEA: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
142RPSPHF05DOMEA: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPReusable Components of Business Suite Foundation
143/BOBF/D_PHFSDOK: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPSAP Business Workflow
144BDSPHF20BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
145SWUOPHFSWUO: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
146SWU_PHFSDOK: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPSAP Expert Finder
147T7KWPHFT7KW: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPSAP GUI for Windows Controls
148BDSPHF14BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPSAP List Viewer
149BDSPHF16BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPSAP Media
150ISM_DM_PHFIS-M DM: Files for Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPSAP Records Management
151SRMPHF01SRM Demo Rec: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
152SRMPHF03SRM Records: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
153SRMPHF04SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
154SRMPHF05SRM Demo Doc: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
155SRMPHF06SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
156SRMPHF07SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
157SRMPHF08SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
158SRMPHF09SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
159SRMPHFP00SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
160SRMPHFP02SRM Model: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
161ZRMPHF05SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
162ZRMPHF06SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
163ZRMPHF07SRM Records: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPSAPscript
164BDSPHF3BDS: Files of physical information objects9FILE_TYPEType of data transfernvarchar10
TOPService
165DVS1PHFKW: Physical Information Object Files9FILE_TYPEType of data transfernvarchar10
TOPSolution Manager Implementation
166IWB4PHFASAP: Files of Physical Info Objects9FILE_TYPEType of data transfernvarchar10
167SA01PHFSOLAR: Physical Info Object Files9FILE_TYPEType of data transfernvarchar10
TOPStakeholder Relationship Management
168BDSPHF28BDS: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
169USC_PHFUSC Documents:: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
170USSDPHFUSS Documents: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPTalent Management
171T77TMCKWDOCHKOHCM: DOC: Files Physical Information Objects9FILE_TYPEType of data transfernvarchar10
172T77TMCKWGRCHKOHCM: GRID Icon: Files Physical Information Objects9FILE_TYPEType of data transfernvarchar10
173T77TMCKWTXCHKOHCM: TXT: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPTransaction Variant and Table Control Settings
174BDSPHF21BDS: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPTranslation Tools
175LXE_CHKOLXE: Files of Physical Information Objects9FILE_TYPEType of data transfernvarchar10
TOPTreasury
176TRCUT_FILE_DATATable with data from calendar upload file10FILE_TYPEFile Typenvarchar20
TOPUse Subcomponents
177SOFFPHFSOFF: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPWeb Channel Framework
178COM_WECWCMCHKOCOM_WECWCM: Files of Physical Information Objects10FILE_TYPEType of data transfernvarchar10
TOPWorkbench Tools Editors, Painters, Modelers
179SMIMPHFMIME Repository: Files for Physical Information Objects11FILE_TYPEType of data transfernvarchar10