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

151 columns | Print definition?ERP 6.0  | SPERR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/NAKISA/C1_DBSTGDashboard Analytics staged data6SPERRCHAR01 data element for SYSTnvarchar10
2/NAKISA/C2_IMPDashboard analytics import parameters temporary table6SPERRCHAR01 data element for SYSTnvarchar10
3/SMERP/STG_MM002Data staging - Material storage location view complex table205SPERRPhysical Inventory Blocking Indicatornvarchar10
4/XLSO/FAVORITESFavorites6SPERRCHAR01 data element for SYSTnvarchar10
5BBP_AGENT_TEMPTemporary Storage of Search Results (INDX Structure)6SPERRCHAR01 data element for SYSTnvarchar10
6CNVCMIS_A_30_SELCMIS table to store export and Import data6SPERRCHAR01 data element for SYSTnvarchar10
7CNV_10993_PDFCLUTable for PDF strings6SPERRCHAR01 data element for SYSTnvarchar10
8FIBKRUD_ACCOUNTSAccount profiles21SPERRCentral posting blocknvarchar10
9INDXNClike INDX, w/o CLIENT5SPERRCHAR01-Datenelement fuer SYSTnvarchar10
10J_1I_INDXIndia System Table INDX for Octroi in PO6SPERRCHAR01 data element for SYSTnvarchar10
11SCI_INDX_COPYSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
12SHDB_CLUSTERINDX type cluster table for access via cl_lib_cluster6SPERRCHAR01-Datenelement fuer SYSTnvarchar10
13T159BParameters for Batch Inputs in Inventory Management8SPERRPhysical Inventory Blocking Indicatornvarchar10
14ZLCRT_INDXAI LCR: Buffer Table7SPERRCHAR01 data element for SYSTnvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
15PROC_VERSIONSSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPAccounting - General
16TCC_INDXClosing Cockpit: System Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPAdditional Material Functions
17WSD_INDXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPAddress ManagementBusiness Address
18ADQUINDXINDX-type table for quarterly adjustment addresses6SPERRCHAR01 data element for SYSTnvarchar10
TOPAdvertising Management
19TJHAKIS-M/AM: Order-Publishing-Media: Sales Document Type16SPERRSales document blocknvarchar10
TOPAllocation
20AUBSIWorklist for PO (Follow-on Document Generation)30SPERRBlocking flag, plantnvarchar10
21AUFGAllocation Table Sub-Item, Store Group17SPERRBlocking flag: plant groupnvarchar10
22AUFIAllocation Table, Document Sub-item, Stores50SPERRBlocking flag, plantnvarchar10
23AUKAIWorklist for Sales Orders (FBG)22SPERRBlocking flag, plantnvarchar10
24AUKOAllocation Table Document Header9SPERRBlocking flag: allocation tablenvarchar10
25AUPOAllocation Table Document Item7SPERRBlocking flag: itemnvarchar10
26AUUMIWorklist for Stock Transport Orders (Follow-on Doc. Gen.)29SPERRBlocking flag, plantnvarchar10
27AUVDIWorklist for Deliveries (Follow-on Doc. Generation)37SPERRBlocking flag, plantnvarchar10
28AUVZDistribution Center35SPERRBlocking flag, plantnvarchar10
29T629Allocation Table Rejection Reasons2SPERRBlocking reason for allocation tablenvarchar10
30T629TAlloc Tbl: Blocking Reasons: Texts3SPERRBlocking reason for allocation tablenvarchar10
TOPAustria
31PA0979HR Master Record for Infotype 097924SPERRLock Indicator for Subsequent Activitiesnvarchar10
TOPAvailability Check
32ATP_INDXATP_INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPBalanced Scorecard
33UMB_MC104Scorecard: Graphic - BLOBs (Obsolete from SEM 3.5)6SPERRCHAR01 data element for SYSTnvarchar10
34UMB_SC144Scorecard: BLOB for Cause-Effect Chain (OBSOLETE)6SPERRCHAR01 data element for SYSTnvarchar10
TOPBasic Data
35NORGIS-H: Organizational Units22SPERRBlocking Indicatornvarchar10
36TN11PIS-H: Planning Characteristics of Building Unit9SPERRBlocking Indicatornvarchar10
37TNF10IS-H: Techn. Work Organizer - Org. Unit Assignment5SPERRBlocking Indicatornvarchar10
38TNF30IS-H: Work Organizers Without Selection Conditions5SPERRBlocking Indicatornvarchar10
39TNF31IS-H: Work Organizers with Ins. Prov. Conditions7SPERRBlocking Indicatornvarchar10
40TNF32IS-H: Work Organizers with Billing Type and Ins. Prov. Cond.7SPERRBlocking Indicatornvarchar10
TOPBasic Functions
41EMMA_JOBRUNIDMSGMonitoring Mass Run: Buffer for Messages (INDX)6SPERRCHAR01 data element for SYSTnvarchar10
42RFRRAccounting data - A/R and A/P information system6SPERRCHAR01 data element for SYSTnvarchar10
43TVAKSales Document Types40SPERRSales document blocknvarchar10
TOPBatch-Oriented Parallel Processing of Mass Data
44BANK_PP_SRV_PCKAssignment Server -> Package Area6SPERRCHAR01 data element for SYSTnvarchar10
TOPBusiness Accounting
45UREXECTRCTrace Option for Realignment Runs8SPERRCHAR01 data element for SYSTnvarchar10
TOPBusiness Analytics
46UABSURINDXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPBusiness Context Viewer
47/BCV/D_INDXINDX table for shared memory6SPERRCHAR01 data element for SYSTnvarchar10
TOPBusiness Partner
48TIVBPVENDORCMPVendor Preassignment (CoCd Data)6SPERRPosting block for company codenvarchar10
49TIVBPVENDORGENVendor Preassignment (General Data)21SPERRCentral posting blocknvarchar10
TOPBusiness Planning
50UPB_CMI_110Graphic - BLOBs6SPERRCHAR01 data element for SYSTnvarchar10
TOPBusiness Process Engine
51SWFDXMPINDXXML Message Proxy: INDX table5SPERRCHAR01 data element for SYSTnvarchar10
TOPClaims Management
52TICL105Storage of Picture Files in Data Clusters (see INDX)6SPERRCHAR01 data element for SYSTnvarchar10
TOPClasses
53CLBUFCluster Table for Classes and Variants6SPERRCHAR01 data element for SYSTnvarchar10
TOPClinical System
54N1EMPFTYPIS-H*MED: Recipient type7SPERRRecipient Type Lock Indicatornvarchar10
55N1VORBDOKELIS-H*MED: Defaults for the doc. elements13SPERRBlocking Indicatornvarchar10
56N2TRANSPORTBCSETIS-H*MED: Structured Cluster Table for N2TRANSPORT5SPERRCHAR01 data element for SYSTnvarchar10
57N2TRANSPORTCLUSTIS-H*MED: Cluster Structure for N2TRANSPORT5SPERRCHAR01 data element for SYSTnvarchar10
TOPCollectionsDisbursements
58CDTESTDATACluster Table for Correspondence Data5SPERRCHAR01 data element for SYSTnvarchar10
TOPCompany Pension Scheme Germany
59P01CSTStatus Information CPS8SPERRLock for Actionnvarchar10
TOPConstruction Equipment Management
60/SAPCEM/INDXStorage for CEM Similar to INDX Table (Note 3992)6SPERRCHAR01 data element for SYSTnvarchar10
TOPContract Accounts Receivable and Payable
61DFKKUMBINDXCluster for Variant Storage in Transaction FPU26SPERRCHAR01 data element for SYSTnvarchar10
TOPCorporate Performance Monitor
62UMC_STD_BLOBSStandard - Graphic - BLOBs (Obsolete from SEM 3.5)6SPERRCHAR01 data element for SYSTnvarchar10
63UMR_RI130OBSOLETE RMS: Graphic - BLOBs6SPERRCHAR01 data element for SYSTnvarchar10
64UMV_TR122Value Driver Tree: Graphic - BLOBs (Obsolete from SEM 3.5)6SPERRCHAR01 data element for SYSTnvarchar10
TOPCorrespondence Tool
65DFKKCORRRFDTCluster Table for Correspondence Data6SPERRCHAR01 data element for SYSTnvarchar10
TOPCross-Application Components
66/IXOS/DCRSA_OUTSystem table INDX6SPERRCHAR01 data element for SYSTnvarchar10
67/IXOS/RS_T_CLUSTSystem table INDX6SPERRCHAR01 data element for SYSTnvarchar10
68BC490KKNA1General data in customer master51SPERRCentral posting blocknvarchar10
69KKNA1General Data in Customer Master51SPERRCentral posting blocknvarchar10
70SKNA1Customer Master table for BC417 Course51SPERRCentral posting blocknvarchar10
TOPCross-Application Mass Maintenance
71MASSVARDATData for Variants6SPERRCHAR01 data element for SYSTnvarchar10
72MASSVARTRMass Maintenance Variants in Transportable Form16SPERRCHAR01 data element for SYSTnvarchar10
TOPCustomer Master
73KNA1General Data in Customer Master51SPERRCentral posting blocknvarchar10
TOPData Conversion
74DMC_PROTDMC: Logs and Tables for Backwards Navigation6SPERRCHAR01 data element for SYSTnvarchar10
TOPDB-Independent Database Interface
75SQLT_INDXSystem table INDX (shared buffer) for ST05 initial screen5SPERRCHAR01 data element for SYSTnvarchar10
TOPFinancial Accounting
76KNB1Customer Master (Company Code)7SPERRPosting block for company codenvarchar10
77LFA1Vendor Master (General Section)38SPERRCentral posting blocknvarchar10
78LFB1Vendor Master (Company Code)7SPERRPosting block for company codenvarchar10
79RFDTAccounting Data (INDX Structure)6SPERRCHAR01 data element for SYSTnvarchar10
TOPFinancials Basis
80UBC_CL_BIBatch Input Sessions (INDX-Structure)6SPERRCHAR01 data element for SYSTnvarchar10
81UBC_CL_INVBill Data (INDX-Structure)6SPERRCHAR01 data element for SYSTnvarchar10
TOPFund Accounting
82FMCCAVC_PRLCluster table for different purposes6SPERRCHAR01 data element for SYSTnvarchar10
TOPFunds Management
83FMFGRCN_SAVSaved reconciliation report results6SPERRCHAR01 data element for SYSTnvarchar10
TOPGeneral Application Functions
84TABADRXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPImplementation Guide
85TVARINDSave screen variants5SPERRCHAR01 data element for SYSTnvarchar10
86VORINDXProcedure model data buffer5SPERRCHAR01 data element for SYSTnvarchar10
TOPIncentive and Commission Management ICM
87CACS_OAINDXFOA: Storage of Structured Data6SPERRCHAR01 data element for SYSTnvarchar10
88CACS_TGMEMTarget Agreements: Table for Shared Memory (Internal)6SPERRCHAR01 data element for SYSTnvarchar10
89CACS_TXTCLSTICM: Cluster Table for Text Strings6SPERRCHAR01 data element for SYSTnvarchar10
TOPInformation System
90PSINFO_INDXSystem Table INDEX: Project Information System6SPERRCHAR01 data element for SYSTnvarchar10
TOPIntegrated Product and Process Engineering
91CPPE_CULLINDXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
92PPEXPL_RTO_INDXSystem table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPIntegration of Catalogs, Partner Directories OCI, OPI
93WSI_OCI_BGSEARCHTemporary Storage of Search Results (INDX Structure)6SPERRCHAR01 data element for SYSTnvarchar10
TOPInventory Accounting
94UAIDETAILDATATrace Option for Realignment Runs6SPERRCHAR01 data element for SYSTnvarchar10
TOPInventory Management
95IKPFHeader: Physical Inventory Document14SPERRPosting block due to physical inventorynvarchar10
96T159ITest Data for Batch Input in Inventory Management (Phys.Inv)20SPERRPhysical Inventory Blocking Indicatornvarchar10
TOPKnowledge Warehouse
97IWEXINDXKEn: Html Export Analysis Data (INDX)5SPERRCHAR01 data element for SYSTnvarchar10
TOPliveCache Applications
98/SAPAPO/OMTSINDXSystem Table INDX for SAPTS Test Framework6SPERRCHAR01 data element for SYSTnvarchar10
TOPLocalization
99J_1BEFD_INDXJ_1BEFD_INDX - Serialization of the obj. in Ato Cotepe 826SPERRCHAR01 data element for SYSTnvarchar10
TOPLogical Database Builder
100RSDSQOBJSelection views5SPERRCHAR01 data element for SYSTnvarchar10
TOPLogistics Information System LIS
101MCEXHASHLO Extraction - Memory Tabele for Hash Values6SPERRCHAR01 data element for SYSTnvarchar10
TOPManagement Cockpit
102UMM_FR106Frames : Graphic - BLOB (Obsolete from SEM 3.5)6SPERRCHAR01 data element for SYSTnvarchar10
TOPMaterial Master
103MARDStorage Location Data for Material9SPERRPhysical Inventory Blocking Indicatornvarchar10
104MARD_TMPFile for Incorrect Data in Direct Input12SPERRPhysical Inventory Blocking Indicatornvarchar10
105MVRDStorage Location Data for Material9SPERRPhysical Inventory Blocking Indicatornvarchar10
TOPMobile Applications
106/ISDFPS/ME_INDXCluster Tables (INDX) for Temporary Storage6SPERRCHAR01 data element for SYSTnvarchar10
TOPMonitoring
107CSMBK_CLClass Definitions in CCMS Repository9SPERRCHAR01 data element for SYSTnvarchar10
108CSMBK_CL2Class Definitions in CCMS Repository10SPERRCHAR01 data element for SYSTnvarchar10
109CSMBK_TKToken Definition in CCMS Repository10SPERRCHAR01 data element for SYSTnvarchar10
110CSMBK_TK2Token Definition in CCMS Repository9SPERRCHAR01 data element for SYSTnvarchar10
111CSM_EXTVALExtended Keys for SCR Objects7SPERRCHAR01 data element for SYSTnvarchar10
TOPOrganization and Planning
112INDX_ESSEmployee Self-Service (ESS) Settings6SPERRCHAR01 data element for SYSTnvarchar10
TOPOwnership
113OIUOW_ORP_TWBORP test workbench comparison history7SPERRCHAR01 data element for SYSTnvarchar10
TOPPatient Management
114NDIAIS-H: Diagnoses26SPERRBlocking Indicatornvarchar10
TOPPeople Centric UI Framework
115CRM_BSP_SYSINDXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPPeriodical Sales and Distribution
116TJAKIS-M/SD: Sales Document Type22SPERRSales document blocknvarchar10
TOPProduction and Revenue Accounting
117OIUT2_CLUSTERSystem table INDX8SPERRCHAR01 data element for SYSTnvarchar10
TOPProfitability Analysis
118TKEDRXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPProject Planning Board
119PSPPT_INDXSystem table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPProject System
120PLM_PS_INDXSystem table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPProxy Generation
121SPROXINDXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPRetail Information System RIS
122MCWPSFile for storing results of function group MCWPS11SPERRCHAR01 data element for SYSTnvarchar10
TOPRevenue
123OIUH_REP_HISTReporting History old Razorfish6SPERRCHAR01 data element for SYSTnvarchar10
TOPRFC
124QUEUESTATE_INDXINDX Table for qRFC Data5SPERRCHAR01 data element for SYSTnvarchar10
TOPRoyalty Reporting
125OIUREP_REG_HISTReporting history (System table INDX)6SPERRCHAR01 data element for SYSTnvarchar10
TOPRuntime Analysis
126SATR_TABABAP Traces (INDX)6SPERRCHAR01 data element for SYSTnvarchar10
TOPSAP Business Workflow
127SWWINDXObsolete 6.1/ INDX Table for SWW Internal Runtime Constructs6SPERRCHAR01 data element for SYSTnvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
128ISH_IDX_LOGGINGIndex Table for Logging Communication Data6SPERRCHAR01 data element for SYSTnvarchar10
TOPSAP Query
129AGDBABAP/4 Generation Tool: Pattern database6SPERRCHAR01 data element for SYSTnvarchar10
130AQDBSAP Query: Tables and Data6SPERRCHAR01 data element for SYSTnvarchar10
131TAQTSSAP Query: Transprt of Queries, Functn. Areas and User Grps5SPERRCHAR01 data element for SYSTnvarchar10
TOPSAP Records Management
132SRM_INDX1Table for Queue Elements17SPERRCHAR01 data element for SYSTnvarchar10
133SRM_INDX3Table for Deleted Queue Elements17SPERRCHAR01 data element for SYSTnvarchar10
TOPSAP Utilities
134ESMON_MARUNIDMSGMonitoring Mass Run: Buffer for Messages (INDX)6SPERRCHAR01 data element for SYSTnvarchar10
TOPService Station Retailing
135OIRC_PASSFuels pricing pass prices export table6SPERRCHAR01 data element for SYSTnvarchar10
TOPSets
136SETSSets - Contents (before Release 2.2)6SPERRCHAR01 data element for SYSTnvarchar10
TOPSyntax, Compiler, Runtime
137INDXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
138TPDAINDXTPDA: Cluster für den neuen Debugger6SPERRCHAR01-Datenelement fuer SYSTnvarchar10
139VER_SEC_INDXData-Cluster6SPERRCHAR01-Datenelement fuer SYSTnvarchar10
TOPSystem Landscape DirectoryComponent Repository
140LCRT_INDXAI LCR: Buffer Table6SPERRCHAR01 data element for SYSTnvarchar10
TOPTag Library
141CRMD_UIF_SYSINDXSystem Table INDX for CRM UI Framework6SPERRCHAR01 data element for SYSTnvarchar10
TOPTerminologyGlossary
142GLOSSARYGlossary Table5SPERRCHAR01 data element for SYSTnvarchar10
143STERM_INDXINDX-Style Tables for Saving Possible Entry Tables5SPERRCHAR01 data element for SYSTnvarchar10
144TERMTerminology Table5SPERRCHAR01 data element for SYSTnvarchar10
TOPTraders and Schedulers Workbench
145OIJ02_DS_INDXSystem Table INDX6SPERRCHAR01 data element for SYSTnvarchar10
TOPTreasury
146VZKNA1Collector for batch input KNA1 from RF-VV46SPERRCentral posting blocknvarchar10
147VZKNB1Collector for batch input KNB1 from RF-VV42SPERRPosting block for company codenvarchar10
TOPUI Framework Service Provider Infrastructure
148/PLMB/FRW_BUFFERFramework buffer6SPERRCHAR01 data element for SYSTnvarchar10
TOPUpstream Graphics
149OIUGT_BASECONFIGUpstream Graphics Base Configuration5SPERRCHAR01 data element for SYSTnvarchar10
150OIUGT_INDXUpstream Graphics INDX Table6SPERRCHAR01 data element for SYSTnvarchar10
TOPWeb Service and SOAP - ABAP
151SRT_WSIL_TMPWSIL Buffer Table7SPERRCHAR01 data element for SYSTnvarchar10