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

110 columns | Print definition?ERP 6.0  | SUBTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/DSCSAG/RIPTable for RIP documents10SUBTYPECDESK: Subdivision of Document Typenvarchar100
2/GEOE/CONFIG_19Geo-enabled Characteristics (LAM)5SUBTYPESubtypenvarchar400
3/GEOE/CONFIG_21GIS Service Mapping4SUBTYPESubtypenvarchar400
4/GEOE/CONFIG_22GIS Field Mapping4SUBTYPESubtypenvarchar400
5/GEOE/GISMSGMessage Table8SUBTYPESubtypenvarchar400
6/GEOE/GISMSGARCMessage Table - Archive: succesfully processed commands8SUBTYPESubtypenvarchar400
7/GEOE/MODEConfiguration for geo-tabs4SUBTYPESubtypenvarchar400
8/IAM/I_SUBTYPESubtype Table3SUBTYPEObject Subtypenvarchar30
9/IAM/I_SUBTYPE_TText table - Subtype4SUBTYPEObject Subtypenvarchar30
10/SAPPSSRM/SOSIndex-Table con. 'Governm. Proc.'-specific sources of supply6SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
11/WSOPT/HR_SUBTYDefinition of active subtypes for infotype 00282SUBTYPESubtypenvarchar40
12/XFT/EPA_CDTALDocument types: Alias/visibility13SUBTYPESubtypenvarchar40
13/XFT/EPA_T0005Visibility of Document Types by Infotype7SUBTYPESubtypenvarchar40
14/XFT/EPA_T0017Visibility file info types6SUBTYPESubtypenvarchar40
15/XFT/EPA_T0018Visibility folder for info type7SUBTYPESubtypenvarchar40
16BBPC_META_ITMMeta Data for Items Types3SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
17BBPC_PROC_TYPEBusiness Transaction Types10SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
18BBPC_TEXT_VALUESFixed Values for Texts from SRM Documents6SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
19BBPC_TXT_VAL_TFixed Values for Texts from SRM Documents6SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
20BBPD_CTR_NOV_LOGNovation Protocol6SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
21BBPD_PD_INDEXIndex Table for Fast Access to Contracts and AVLs6SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
22BBPD_PD_INDEX_HIndex Table for a Selective First Access in GetList6SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
23BBPD_TREX_INDEXBBP TREX Indexes: Assign Business Object -> TREX Indexes5SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
24BBP_PDHGPBusiness Transaction Purchasing Information40SUBTYPESpecification of a Purchasing Doc.(e.g. Credit Memo/Invoice)nvarchar20
25BBP_PDIGPBusiness Transaction Item-Purchasing Information68SUBTYPESpecification Purchase Item (e.g. Direct Material/Hierarch.)nvarchar20
26DMC_CONNECTIONMWB: Connection definition table3SUBTYPEMWB: Connection Subtypenvarchar100
27DMC_CONN_ARCHIVEMWB: Connection definition table3SUBTYPEMWB: Connection Subtypenvarchar100
28DMC_CONN_BW_PSAMWB: Connection to BW systems3SUBTYPEMWB: Connection Subtypenvarchar100
29DMC_CONN_FUBAMWB: Connection definition table3SUBTYPEMWB: Connection Subtypenvarchar100
30DMC_CONN_ODQMWB: Connection to ODQ system3SUBTYPEMWB: Connection Subtypenvarchar100
31DMC_CONN_SRVCIFDefinition of Service Interface Connection3SUBTYPEMWB: Connection Subtypenvarchar100
32DMC_CONN_SRVCPRXDefinition of Service Proxy Connection3SUBTYPEMWB: Connection Subtypenvarchar100
33GRFNFLDHRHR Configurable Fields4SUBTYPESubtypenvarchar40
34ICLBPBUNDLEArchived ICLCCEVENTB Entries per Business Partner6SUBTYPESubtype of Claim Bundle Typenvarchar20
35REQLINEAdministrative Line Data: Requirement Coverage Request38SUBTYPESpecification Purchase Item (e.g. Direct Material/Hierarch.)nvarchar20
36REQLINEMATemporary Line Data: Requirement Coverage Request(MRO Lines)92SUBTYPESpecification Purchase Item (e.g. Direct Material/Hierarch.)nvarchar20
37REQLINESRTemporary Line Data: Requirement Coverage Request (Services)98SUBTYPESpecification Purchase Item (e.g. Direct Material/Hierarch.)nvarchar20
38SRMSOCO_DRFT_ITMDraft Items for FIORI SOCO28SUBTYPESpecification Purchase Item (e.g. Direct Material/Hierarch.)nvarchar20
39SUSAGEUsage in ABAP4SUBTYPEnvarchar300
40T77PAO_DRPAITPA Infotype Fields for Data Retrieval4SUBTYPESubtypenvarchar40
41T7CNRMP_CUST_PDConfiguration Table for Fields in Organization Management4SUBTYPESubtypenvarchar40
42T7CNRMP_DETITMDetermining Factor Item11SUBTYPESubtypenvarchar40
43T7CNRMP_RPTGRPGrouping Dimension for Report13SUBTYPESubtypenvarchar40
44T7CNRMP_RPTSTAStatistical Dimension for Report26SUBTYPESubtypenvarchar40
45T7CNRMP_VALUEITMValue Item of Statistical Item with Value Reading Type12SUBTYPESubtypenvarchar40
46TICL002_MCScreen Selection for Multiple Contract Handling3SUBTYPESubtype of Claim Bundle Typenvarchar20
TOPAlternative Valuation Run
47CKMLRUNWRuns for Weekly Actual Costing in Material Ledger11SUBTYPERun Subtypenvarchar10
TOPCAD Integration
48CDESK_DRAWCDESK: Additional Data for Documents in CAD Desktop6SUBTYPECDESK: Subdivision of Document Typenvarchar100
TOPClaims Management
49ICLCCEVENTClaim Bundle10SUBTYPESubtype of Claim Bundle Typenvarchar20
50ICLEBULKSBRColl.Subro/Recovery Settlement8SUBTYPESubtype Settlement Collective Subrogation/Recoverynvarchar20
51ICSCCEVENTShadow Table Claim Bundle10SUBTYPESubtype of Claim Bundle Typenvarchar20
52ICSEBULKSBRShadow Table Collective Subrogation/Recovery Settlement8SUBTYPESubtype Settlement Collective Subrogation/Recoverynvarchar20
53TICL002Subtypes of Claim Bundle Types3SUBTYPESubtype of Claim Bundle Typenvarchar20
54TICL002TSubtypes of Claim Bundle Types - Text4SUBTYPESubtype of Claim Bundle Typenvarchar20
55TICL102Claim Bundle Type: Permitted Manual Task3SUBTYPESubtype of Claim Bundle Typenvarchar20
56TICL177Subrogation Claim Type in Subrogation3SUBTYPESubtype of Claim Bundle Typenvarchar20
57TICL177TSubrogation Claim Type in Subrogation (Text)4SUBTYPESubtype of Claim Bundle Typenvarchar20
TOPCommon Parts
58T7XSSPERSUBTYPEInfotypes and Subtypes for ESS PersInfo4SUBTYPESubtypenvarchar40
TOPContract Accounts Receivable and Payable
59TFKK_INT_HIST##Customizing table for interaction history3SUBTYPEInteraction history sub typenvarchar200
60TFKK_INT_HISTT##Text table for interaction history customizing4SUBTYPEInteraction history sub typenvarchar200
TOPCorrespondence
61VICPDOCOutput Document5SUBTYPECorrespondence-Dep. Identification for Output Activitynvarchar320
TOPCross-Application Components
62TWPPSVLSVWorkplace PI: Allocation of Physical to Logical Services2SUBTYPEWorkplace Plug-In: Sub-Service Typenvarchar200
63TWPPSVLSVCWorkplace PI: Phys. Allocation to Log. Services - Customer2SUBTYPEWorkplace Plug-In: Sub-Service Typenvarchar200
64TWPSRVSSRVWorkplace Plug-In: Service Types and Sub-Service Types2SUBTYPEWorkplace Plug-In: Sub-Service Typenvarchar200
65TWPSRVTABWorkplace Plug-In: Physical and Logical Services2SUBTYPEWorkplace Plug-In: Sub-Service Typenvarchar200
TOPCustomer Enhancements
66ENHCONTRACTTOOLTable of Contract Tools5SUBTYPEVersion Management: Object Typenvarchar40
67ENHCONTRACTTYPEnhancement Contract Type2SUBTYPEVersion Management: Object Typenvarchar40
TOPData Basis
68RSBOHDESTDirectory of Open Hub Destinations23SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
69RSLPO_DFG_GENTGTPseudo Table for Lock Requests at Target TLOGO3SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
TOPData Staging
70RSTRANIFTable for Source/Target Interface2SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
TOPDocument Management Framework
71SKWS_EVENTStatus Management: Events5SUBTYPEStatus Management: Event Subtypenvarchar20
TOPE-Recruiting
72T77RCF_ATTTYPE_UUse of Attachment Types (Object Type/Subtype)3SUBTYPESubtypenvarchar40
TOPEnd User Technology
73RSAOOBJXREFAnalysis Office: Dependent TLOGO Objects8SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
74RSERERPTXREFDependent TLogo Objects7SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
75RSXCLSXREFReference objects (Dependent) of Xcelsius6SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
76RSZWBITMXREFBI Template Cross references to TLOGO Objects6SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
77RSZWBTMPXREFBI Template Cross references to TLOGO Objects6SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
78RSZWTEMPLATEXREFBI Template Cross references to TLOGO Objects6SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
TOPFunds Management
79TBUDVGIS-PS Budget Types for Payment/Commitment Budget9SUBTYPEBudget subtypes allowednvarchar10
TOPGRC Access Control Plug-In
80/VIRSA/FLDMAPHR Triggers - Field Mapping5SUBTYPESubtypenvarchar40
TOPI18N Unicode
81UM4EXCEPSPUMG: Exception table to UMGCCTL2SUBTYPEnvarchar100
82UMGEXCEPSPUMG: Exception table to UMGCCTL2SUBTYPEnvarchar100
TOPIncident Recording
83EHHSSD_INC_RESDUIncident Restricted Duty database table12SUBTYPERestricted Duty Typenvarchar210
TOPJapan
84T7JPBP_CALDECDecision Factor5SUBTYPESubtypenvarchar40
85T7JPBP_PNTTYPRetirement Benefit Point Type5SUBTYPESubtypenvarchar40
86T7JPCP_CBDECDecision Factors for Re-assessment Rate5SUBTYPESubtypenvarchar40
87T7JPCP_CLBSDASCalculation Basis Parameter Basic Pay Data Source6SUBTYPESubtypenvarchar40
88T7JPCP_CLDECFCDecision Factor5SUBTYPESubtypenvarchar40
89T7JPCP_PRDECFCDecision Factors for Premium Rate/Amount5SUBTYPESubtypenvarchar40
TOPLoans Management
90VDDD_HEADERLoans: Header Data - Lines Layout3SUBTYPEHeader Subtypenvarchar20
TOPLOGFAS
91/ISDFPS/RICReportable Item Code8SUBTYPESubtypenvarchar10
TOPMaintenance Orders
92/MRSS/C_SQP_HRTYMapping of subtype for HR infotype 0105 (webuser)2SUBTYPESubtypenvarchar40
TOPMetadata Repository
93RSOOBJXREFTLOGO Framework, Where-Used Lists7SUBTYPEBW Metadata Repository: Subtype of TLOGO Typenvarchar40
TOPMonitoring
94ALXMBEMAILCCMS: Registration of E-Mail Recipients for Alerts3SUBTYPEInformation Subtype for Monitoring Datanvarchar400
95CSMBKFact Table for CCMS System Repository16SUBTYPEProperty type in CCMS Repositorynvarchar40
96CSMBK_OBJObject Repository in CCMS System Repository18SUBTYPEProperty type in CCMS Repositorynvarchar40
TOPPersonnel Management
97/OTEI/PF_TASREIMConnection of HCM PF and EFM documents7SUBTYPEInfotype sub typenvarchar40
TOPRapid Applications
98AXT_EMBEDDABLERepository of embeddable views3SUBTYPENamenvarchar300
TOPRepository Browser
99EUOBJEDITWorkbench: Assignment Development Object Type -> Editor14SUBTYPEWB Request: (Internal) Type of an ABAP Workbench Objectnvarchar30
TOPSAP Retail Store
100WSMAN_PT_BUFFERStore Manager Portal: Buffer for Availability Display14SUBTYPESubtypenvarchar40
TOPService Data Download
101/SDF/RBE_CS3_AAttributes for SQL Check Steps in SDA Analysis3SUBTYPERBE SQL Check Step Subtypenvarchar10
TOPSingapore
102T5RTEXT_KEYMapping table for subtype of infotype 741 to the keyfields2SUBTYPESubtypenvarchar40
TOPTranslation Tools
103LSELCONDSSelection conditions for translation (by type)2SUBTYPETranslation subtypenvarchar40
104LTYPESTECHTechnical data for object types (translation)2SUBTYPETranslation subtypenvarchar40
TOPTransport Organizer
105VERSSUBOBJTable structures for a versionable object5SUBTYPECHAR05 data element for SYSTnvarchar50
TOPUser and Authorization Management
106USOTTRelation transaction > authorization object4SUBTYPEReport typenvarchar20
TOPWeb Services Tool
107CRMD_WS_ARIS_MAPMapping of ARIS objects to UI objects with subtypes3SUBTYPEObject Subtypenvarchar200
TOPWorkbench Tools Editors, Painters, Modelers
108RIS_DATA_MODELRepository Information System: Data Model Registration2SUBTYPEWB Request: (Internal) Type of an ABAP Workbench Objectnvarchar30
109WBREGISTRY_PPlug-in Tools for ABAP Workbench (WBREGISTRY)2SUBTYPEWB Request: (Internal) Type of an ABAP Workbench Objectnvarchar30
110WBREGISTRY_PTText Table for WBREGISTRY_P with the Object Type Names2SUBTYPEWB Request: (Internal) Type of an ABAP Workbench Objectnvarchar30