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

133 columns | Print definition?ERP 6.0  | KIND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CIDEON/PRDTable8KINDLicense kindnvarchar10
2/OTX/AL_STORECTRCustomizing table for AL attributes storages5KINDTable kindnvarchar10
3AMDP_IDAdministration Table for ADMP Number Ranges1KINDNumber Range Name for AMDPsnvarchar40
4BBPD_OBJECTSBusiness Transaction - Component Type3KINDObject Typenvarchar10
5BBP_PD_INITCHECKDescription of the PD Sets by Object Type4KINDObject Typenvarchar10
6CNVHCM_RSPARAMSTDMS4HCM: Selection Set for Transfer Program5KINDABAP: Type of selectionnvarchar10
7CNVMBTACTPARAMSParameters for Activities7KINDSelection category ( P - Parameter / S - Select Option)nvarchar20
8CNVMBTACTPARLOGMBT PCL - Activity execution log9KINDSelection category ( P - Parameter / S - Select Option)nvarchar20
9CNVMBTACTSCREENSel. Screen parameters of activites and ref. to interfaces4KINDSelection category ( P - Parameter / S - Select Option)nvarchar20
10CNVMBTPEBPARAMSParameters for process execution blocks8KINDSelection category ( P - Parameter / S - Select Option)nvarchar20
11CNVMBTSUBPARAMSParameters for Subactivities9KINDABAP: Type of selectionnvarchar10
12CNV_10940_CONVSTVariant conversion status8KINDABAP: Type of selectionnvarchar10
13CNV_10940_VARDETStoring values of variants14KINDABAP: Type of selectionnvarchar10
14DDREPLICNVDATADD: Information on Metadata Transfer: Fields - Data Convers.6KINDDD: Describes how a field is to be handlednvarchar100
15DDREPLICREFDD: Information on Metadata Transfer: Fields6KINDDD: Describes how a field is to be handlednvarchar100
16DDREPLINDATADD: Information on Metadata Transfer: New Fields6KINDDD: Describes how a field is to be handlednvarchar100
17DOCRP_FLDBMPDBOS Cockpit: CRP: Source Field7KINDnvarchar100
18DOCRP_SOURCEDBOSC: CBR: CIM Data Source6KINDCharacter field, 8 characters longnvarchar80
19DOCRP_SRCBMPDBOSC: CBR: CIM Data Source8KINDCharacter field, 8 characters longnvarchar80
20DODP_FIELDDBOSC-DP: Data Provider Field8KINDnvarchar80
21DOOD_PROPERTYDBOSC-DP: Data Provider Field7KINDnvarchar10
22DORAN_FIELDDBOSC-RAN: Data Source Field6KINDnvarchar10
23DORAN_SOURCEDBOSC-RAN: Request Processor for All - Native9KINDnvarchar80
24DORDS_FIELDDBOSC-RDS: Reques Process DB SQL Data Source Field7KINDCharacter field, 8 characters longnvarchar80
25DORDS_PARAMETERDBOSC-RDS: Request Process DB SQL Parameter8KINDCharacter field, 8 characters longnvarchar80
26DORDS_SOURCEDBOSC-RDS: Reques Processor DB SQL Data Source8KINDCharacter field, 8 characters longnvarchar80
27DORQ_FIELDDBOSC-RQ: Request Fields7KINDnvarchar10
28DORQ_REQUESTDBOSC-RQ: Request8KINDnvarchar10
29DOST_CASE_HEADERDBOSC-ST: Test Case Header2KINDnvarchar300
30DOUI_MAP_FIELDDBOS Cockpit: Mapping Between UI and Request7KINDnvarchar10
31GRFNPSCOPOWL Selection Criteria Override3KINDABAP: Type of selectionnvarchar10
32IDREPFW_SELPAR_ARep. Framework: Data Storage - Selection Parameters5KINDABAP: Type of selectionnvarchar10
33PYD_D_INSTPPayroll Data Source Instance Input Parameter5KINDABAP: Type of selectionnvarchar10
34PYD_D_RESPPayroll Data Source Result Input Parameter6KINDABAP: Type of selectionnvarchar10
35PYD_D_UVDPayroll Data Source Framework: User Variant Details6KINDABAP: Type of selectionnvarchar10
36SATC_WL_OBJSET"Worklist": Object 2 set assignment (transactional data)3KINDObject set kindtinyint30
37SATC_WL_RAW_SET"Worklist": Raw set pending for merge (transactional data)3KINDObject set kindtinyint30
38SCIREST_PS_BUFCode Inspector: Results Table13KINDCode Inspector: Message Type (Info, Warning, ...))nvarchar10
39SEPM_OIA_SMOKE_IEPM OIA: System Smoke Test Result Items6KINDEPM OIA: Kind of Failure in System Smoke Testnvarchar10
40SQLMZASQL Monitor: Configuration of Time Series1KINDnvarchar10
41SQLMZMSQL Monitor: Measurements2KINDType of the measurmentnvarchar10
42SWLT_STATIC_C_DCache for static check data20KINDCode Inspector: Message Type (Info, Warning, ...))nvarchar10
43TEWA_EL_OBJBHBehavioral Control (Behavior)1KINDBehavioral Control Typenvarchar20
44TEWA_EL_OBJBHABehavioral Control Assignment1KINDBehavioral Control Typenvarchar20
45TEWA_EL_OBJBHFPKField Transport Data Provider - Key Assignment1KINDBehavioral Control Typenvarchar20
46TEWA_EL_OBJBHTTexts for Behavioral Control1KINDBehavioral Control Typenvarchar20
47TEWA_EL_OBJBHUIFBehavioral Control User Interface Fields1KINDBehavioral Control Typenvarchar20
48TREAT_MLM_RESULTTreasury: Margin Limit Result Entity5KINDKind of Margin Limit Result Entitynvarchar30
49UCONHTTPCUSTPAGEHTTP Customizing Error Pages9KINDHTTP Error: 'X'=>Redirect , ' '=>Expl. Response Pagenvarchar10
50UCONPROFPAGEUCON: Profile Error Pages9KINDHTTP Error: 'X'=>Redirect , ' '=>Expl. Response Pagenvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
51SATC_AC_RESULTHTransaction data: 'Display Load' header17KINDKind of result - 'Aspect' vs 'Module'nvarchar10
52SATC_AC_VERDCT_BTransaction data: 'Finding (Verdict) Set' data > 510 bytes12KINDKind of verdict: 'Passed' , 'Not Passed', 'Inconclusive'nvarchar10
53SATC_AC_VERDCT_STransaction data: 'Finding (Verdict) Set' data <= 510 bytes12KINDKind of verdict: 'Passed' , 'Not Passed', 'Inconclusive'nvarchar10
54SATC_AC_VRDCT_BOBSOLETE: 'Finding Set' data > 510 bytes; aspect format8KINDnvarchar10
55SATC_AC_VRDCT_SOBSOLETE: 'Finding Set' data > 510 bytes; aspect format8KINDnvarchar10
56SATC_MD_DIRTransaction dats: Directory of (volatile) repository content3KINDMeta data: Kind (e.g. "Project") of data record on databasenvarchar30
57SATC_RT_RUN_KEYMovement data (runtime repository) - Entity keys7KINDGeneral Flagnvarchar10
58SCIREST_PSCode Inspector: Results Table13KINDCode Inspector: Message Type (Info, Warning, ...))nvarchar10
59SCI_OCSLINESSCI: Row of an Object Classification Schema4KINDSCI: Change for Message Type (Increase, Decrease, New Value)nvarchar10
TOPAccounting - General
60TFC_INST_ITEMAdministration of a Job (Report/Transaction or Workflow)9KINDTask Type (Report, Workflow, Transaction, Note)nvarchar10
61TFC_TEMPL_ITEMAdministration of a Job (Report/Transaction or Workflow)9KINDTask Type (Report, Workflow, Transaction, Note)nvarchar10
TOPAccounting Interface
62GLE_ECS_VARIANTPVariants: Parameter Data8KINDABAP: Type of selectionnvarchar10
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
63DD29LSelection Condition for Views and MC IDs5KINDAggregate Typenvarchar10
64DD43LSecondary Key for Table Types6KINDDefinition of Secondary Keynvarchar10
TOPALE Integration Technology
65TBDMO_DETALE/ CCMS Monitoring Connection: Group Definition Details5KINDABAP: Type of selectionnvarchar10
TOPApplication Framework
66MDG_GN_TGOBJCatalog of Generated Objects1KINDObject Type (Generator)nvarchar40
67MDG_GN_TGOBJTSTime Stamp of the Generated Objects1KINDObject Type (Generator)nvarchar40
TOPArchive Development Kit
68ADMI_VARIAContents of the Variant for the Archiving Program4KINDABAP: Type of selectionnvarchar10
TOPArchiveLink
69TOADL_PARTSub-object of stored print list5KINDSAP ArchiveLink: Status fieldnvarchar10
70TOAOSLogical mapping to implementation method6KINDSAP ArchiveLink:OLE type (method,set property,get property)nvarchar10
TOPASAP AcceleratedSAP
71TCUSTEMPCustomizing templates entity table12KINDType of Templatenvarchar10
TOPBasic Functions
72T800HISTPLog Tables for Program Runs in FI-GL or FI-SL: Items5KINDABAP: Type of selectionnvarchar10
TOPBatch-Oriented Parallel Processing of Mass Data
73BANK_REP_PARAMSCurrent Selection Values for Report4KINDABAP: Type of selectionnvarchar10
TOPCalculations
74CMS_BCM_CGP_ADMAdmin data of covarage gap monitoring report5KINDABAP: Type of selectionnvarchar10
TOPClaims Management
75TIGN221Settings for Search Criteria in a Search8KINDSAP Query (S): Type of selectionnvarchar10
TOPClassification Toolset
76CLS_ATTRIBUTEAttribute3KINDType of valuesnvarchar10
TOPConsolidation
77TF011Generate Request Screen: Formating Instructions5KINDFormatting command on selection screen of a report programnvarchar20
TOPControlling
78TSVARFBTable Search: Function Modules of Application1KINDTable Search: Possible Events for Application Modulesnvarchar40
79TSVARFBTTable Search: Function Modules of Application, Texts2KINDTable Search: Possible Events for Application Modulesnvarchar40
TOPCross-Application Components
80TASUVAR1ASU Variants: Fieldinformations for reports with variant2KINDABAP: Type of selectionnvarchar10
81TASUVSVOASU: Variants: transparent saved object information5KINDABAP: Type of selectionnvarchar10
TOPCross-System Tools
82CMPWLHCustomizing Comparison: Worklist Header2KINDComparison/Adjustment Worklist Creation Typenvarchar10
TOPData Retention Tool
83TXW_VARIAContents of Variant of TXW-archive retrieval5KINDABAP: Type of selectionnvarchar10
84TXX_ADMI_PARDART-Administration ---Segment-Management---4KINDSingle-Character Indicatornvarchar10
TOPData Staging
85RSDELDONEBW: Selection Table for Deletion with Full Update Scheduler10KINDType of Requested Data - Also New DS Typesnvarchar10
86RSLDPDELBW: Selection Table for Deleting with Full Update Scheduler11KINDType of Requested Data - Also New DS Typesnvarchar10
87RSLDPDELSHBW: Selection Table for Deletion with Full Update Scheduler10KINDType of Requested Data - Also New DS Typesnvarchar10
88RSLDPSELSelection table for fields scheduler10KINDType of Requested Data - Also New DS Typesnvarchar10
89RSLDPSELHISTSelection Table for Fields of Scheduler - Changes/History11KINDType of Requested Data - Also New DS Typesnvarchar10
90RSLDPSELSHSelection table for fields scheduler9KINDType of Requested Data - Also New DS Typesnvarchar10
91RSTRANSTEPROUTRule Type: Routine6KINDRoutine Variantnvarchar70
TOPFinancials Basis
92FINB_GN_TGOBJCatalog of Generated Objects1KINDObject Type (Generator)nvarchar40
93FINB_GN_TGOBJTSTime Stamp of the Generated Objects1KINDObject Type (Generator)nvarchar40
TOPFlexible Real Estate Management
94VICARANGEValues per Selection Screen Parameter5KINDType of Report Parameternvarchar10
TOPFreight Processing
95V54IV_SELOPTIncoming Invoice: Selection Transportation Service Provider6KINDABAP: Type of selectionnvarchar10
TOPFunction Builder
96FUNCTFunction Module Short Texts4KINDTypenvarchar10
TOPGlobal Performance Analysis Transaction ST3
97SMEC_CRITMEC Check criteria3KINDMEC item Status Kindnvarchar30
98SMEC_METAMEC check related metadata2KINDMEC item Status Kindnvarchar30
99SMEC_PROFMEC profile param metadata2KINDMEC item Status Kindnvarchar30
TOPHR Administrative Services
100T5ASRSELFLDReport Selection Fields for LPA8KINDABAP: Type of selectionnvarchar10
101T5ASRSELFLDSFSpecify Report Selection Fields for Reports: Stat.Field Sel.7KINDABAP: Type of selectionnvarchar10
TOPIntegrated Product and Process Engineering
102PPEFILTATTRSELField Catalog Attributes5KINDABAP: Type of selectionnvarchar10
TOPIntegration of FPM and Persistency Frameworks like BOPF
103/BOFU/IPBI_POWLSPOWL: Selection Parameters5KINDParameter (single) or Sel. option (multi val., intervals)nvarchar10
TOPInternationalization I18N
104TCPSEGList of Code Page Segments2KINDType of Code Page Segmentnvarchar10
TOPMaster Data
105EPDPRODAIS-U Master Data Generator: Attribute28KINDParameter Typenvarchar10
TOPMaterial Groups
106WTREEVersion Management for Reclassification Trees25KINDText type (Space = Text, 'I' = 'Icon', 'S' = Symbol)nvarchar10
TOPMaterial Master
107WER_ACT_PARAM_AAction method call parameters (Customers)6KINDParameter Type (importing, exporting, changing, returning)nvarchar10
108WER_ACT_PARAM_SAction method call parameters5KINDParameter Type (importing, exporting, changing, returning)nvarchar10
109WER_EXP_PARAM_AExpression method call parameters (Customers)6KINDParameter Type (importing, exporting, changing, returning)nvarchar10
110WER_EXP_PARAM_SExpression method call parameters5KINDParameter Type (importing, exporting, changing, returning)nvarchar10
TOPMedia Product Sales and Distribution
111JSDVARIANTPARAMSIS-M Selection Variants - Parameters7KINDABAP: Type of selectionnvarchar10
112JVSDPLANADCALLIS-M: Temporary Storage of Parameters4KINDABAP: Type of selectionnvarchar10
TOPMulti Currency Accounting
113GLE_MCA_TPARAMSGLE MCA Selection Screen Parameters Table6KINDABAP: Type of selectionnvarchar10
TOPNet Worth Tax
114IDFIAA_JP_COND1Selection Criteria for Stored Reports8KINDABAP: Type of selectionnvarchar10
TOPOLAP Technology
115RSBBSCUBEMAPPINGFixed Mapping for BW-R/RI10KINDSelection Typenvarchar10
116RSBBSQRYMAPPINGFixed Mapping for BW-R/RI11KINDSelection Typenvarchar10
TOPPackage Tools
117AKB_SCRIPTObsolete: BCB Scripts6KINDABAP: Type of selectionnvarchar10
TOPPersonal Object Worklist
118POWL_SELCRIT_CCust table for powl selcrit4KINDParameter (single) or Sel. option (multi val., intervals)nvarchar10
TOPQuantity optimizing
119WLC_PRESEL_CRITLoad Control/Ext. Paral. Proc.: Preselection Criteria5KINDLoad Control/Ext. Paral. Proc.: Selection Typenvarchar10
TOPRecycling Administration Core Functions
120J_7LV1SREA Document: Selection Criteria Log5KINDABAP: Type of selectionnvarchar10
TOPRemaining Beverage - Obsolete Objects
121/BEV3/CHCTS02Selection Table + Selection Fields9KINDRestricted to Visible Fieldsnvarchar10
TOPRFC
122LDQ_PROGRESSPointer Table of Local Data Queue (Start, Progress, End)4KINDLDQ Type of Counter (T = TOP; R = Read; L = Last)nvarchar10
TOPRisk Analysis
123JBRNODETXTAll Information for Display of Hierarchies21KINDText type (Space = Text, 'I' = 'Icon', 'S' = Symbol)nvarchar10
TOPService Implementation Workbench
124TSIW_SXF_FIELDSignature Exchange Format - Field9KINDSXF Field Typenvarchar10
TOPServices
125UATSVARFBTable Search: Possible Exit Times1KINDTable Search: Possible Times for Application Modulesnvarchar40
126UATSVARFBTTable Search: Possible Exit Times2KINDTable Search: Possible Times for Application Modulesnvarchar40
TOPSupply Chain Management
127TCM_D_IV_SELOPTIV: Selection TM Transportation Service Provider6KINDABAP: Type of selectionnvarchar10
TOPSyntax, Compiler, Runtime
128SNAPTTREXException Table for Translation4KINDCHAR01 data element for SYSTnvarchar10
129TODOSTODO: Exclude programs from individual SLIN checks8KINDnvarchar40
130TPDASESSIONBP6KINDNatural Numberint100
TOPVirtual Machine Container
131SVMCRT_RESOURCESVMC Runtime: Resources4KINDType of Resourcesmallint50
132SVMCRT_RES_TRANSVMC Runtime: Transport Table for Resources4KINDType of Resourcesmallint50
TOPWeb Service Tools - ABAP
133VEPELEMTYPEVirtual Interface: Elementary Data Type4KINDVEP Type of an Elementary Typesnvarchar40