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

76 columns | Print definition?ERP 6.0  | PROPERTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBO_RMSB: OData Record Expression Mapping9PROPERTYService Builder: Node UUIDvarbinary160
2/OPT/WT_3S_TEXTSupplier Self Service - Output Texts2PROPERTYText Data Element for Supplier Self Service Outputnvarchar400
3/OPT/WT_3S_TEXTTSupplier Self Service - Output Text Table2PROPERTYText Data Element for Supplier Self Service Outputnvarchar400
4/PERSONAS/C_PROPPersonas system table to store available editproperties.1PROPERTYFlavor Screen Property Namenvarchar640
5/SDF/E2E_TA_CONFConfiguration data for E2E Trace1PROPERTYPropertynvarchar1000
6/SDF/SQLCUSTSQL Monitor History - Customizing1PROPERTYnvarchar300
7DOT_OS_WSC_LP_PDBOS Cockpit: WS Connector: Connection Properties2PROPERTYnvarchar2560
8FIBKRUC_PSOURCESource data for account number part5PROPERTYLink to Data Sourcenvarchar300
9HRP5058DB Table for Infotype 505819PROPERTYObjective propertynvarchar150
10VIXCCHOBJRELLocalization Switzerland: Object Relation Property / Land Re2PROPERTYInternal Key of Real Estate Objectnvarchar130
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
11DDPROFDD: Settings for DDIC programs4PROPERTYChar 20nvarchar200
TOPBasic Data and Tools
12EHFNDC_CI_IPCHARconfiguration of characteristics for integration point3PROPERTYValue Assignment Typenvarchar300
TOPBasis Components
13/XFT/INV_VIEW_C1Customizing for Invoice Viewer2PROPERTYPropertynvarchar100
TOPBilling in Contract Accounts Receivable and Payable
14TFK8044Technical Properties of Billing Rules4PROPERTYName of Technical Attribute of Billing Rulenvarchar320
15TFK8045Properties of Technical Properties of Billing Rules2PROPERTYName of Technical Attribute of Billing Rulenvarchar320
TOPCheck Write
16OIUCW_PROP_DOIProperty/DOI List for Payment Run4PROPERTYPropertynvarchar80
TOPClaims Management
17ICLDAMOBJDamaged Object13PROPERTYInsurable Objectnvarchar90
18ICLPOLOInsured Object in Policy Snapshot10PROPERTYInsurable Objectnvarchar90
19ICSDAMOBJDamaged Object13PROPERTYInsurable Objectnvarchar90
20ICSPOLOInsured Object in Policy Snapshot10PROPERTYInsurable Objectnvarchar90
TOPCollaboration Folders
21CFX_BOM_PDX_FLDPDX IPC-2571: CFX FieldAssignt to Attributes of XML Elements6PROPERTYXML-Attribute: Property in Accordance with IPC-2571nvarchar90
22CFX_ID_NSAssignment of (ID, Namespace) to Internal ID6PROPERTYCharacter String for Collaboration Foldersntext10737418230
23CFX_PDX_ATTRXML Attributes in Accordance with IPC-2571 Standard5PROPERTYXML-Attribute: Property in Accordance with IPC-2571nvarchar90
TOPControl Plan
24DPR_CP_ITEMMaster Data Table for Control Plan Characteristics5PROPERTYCategory/Rating of Control Plan Characteristicnvarchar200
TOPCross-Application Components
25/XFT/INV_WF_C1Customizing for WF2PROPERTYName of propertynvarchar100
TOPData Collection
26TKED2Data mining display object9PROPERTYPropertynvarchar10
TOPEngineering Desktop
27EDESK_C_COMMCustomzing for CAD IntegrationCommuication in Eng. Desktop5PROPERTYSOAP Property Namenvarchar500
TOPFinancials Basis
28UGCM0500FIN Change Management: Registered Properties3PROPERTYFIN Change Management: Property of Itemnvarchar100
29UGCM0501FIN Change Management: Texts for Registered Properties4PROPERTYFIN Change Management: Property of Itemnvarchar100
30UGCM0502FIN Change Management: Texts for Registered Properties4PROPERTYFIN Change Management: Property of Itemnvarchar100
TOPHierarchy Storage
31TRTYPEHList of valid link types3PROPERTYAttribute of a link typenvarchar10
TOPInformation Consistency
32SIC_NODE_FIELDSDefinition of Fields per Node15PROPERTYField Propertynvarchar10
TOPJoint Venture und Production Sharing Accounting
33T8JVJoint Venture34PROPERTYJV Property IDnvarchar240
TOPMaintenance Orders
34/MRSS/C_DSG_CLRHold the color details of the properties of the graph2PROPERTYProperties of chart enginenvarchar20
TOPMaster Data
35EPROPOwner Allocation2PROPERTYPropertynvarchar100
36EPROPHAllocation of Inst. to Ownership5PROPERTYPropertynvarchar100
TOPMetadata Repository
37RSOPROPERTIESBW Repository: Properties Per User2PROPERTYBW Repository: Propertynvarchar320
38RSOPROPERTIESTABBW Repository: Data for Properties With More Than One Value2PROPERTYBW Repository: Propertynvarchar320
TOPMonitoring
39CSMCLDISPTDisplay Properties for SCR Classes3PROPERTYProperty of CCMS Repository classnvarchar400
40CSMCLGUID2Mapping Table: GUIDs/SCR Classes and Properties5PROPERTYProperty of CCMS Repository classnvarchar400
41CSMCLSGUIDMapping Table: GUIDs/SCR Classes and Properties4PROPERTYProperty of CCMS Repository classnvarchar400
42CSM_ABOSCRSubscription to Intrinsic Events in CCMS SCR4PROPERTYObject name in CCMS Repositorynvarchar400
43CSM_EXTVALExtended Keys for SCR Objects3PROPERTYProperty of CCMS Repository classnvarchar400
44CSM_PRPINHMapping Table: Property Inheritance of CCMS SCR Classes3PROPERTYProperty of CCMS Repository classnvarchar400
45CSM_TEXTSTranslation Table for SCR Classes and Other Texts4PROPERTYProperty of CCMS Repository classnvarchar400
TOPProcess Management
46CMX_XS_DB_ARPXSteps: Fields for Property Index of the Applications3PROPERTYXSteps: Propertynvarchar300
TOPRoyalty Reporting
47OIUREPP_PRPAYXRFMMS-2014 - Property / Payor XRef PPA3PROPERTYMMS-2014 - Venturenvarchar60
48OIUREP_PROWNERSMMS-2014 - Property w/ Multiple Owners?3PROPERTYMMS-2014 - Venturenvarchar60
49OIUREP_PRPAYXREFMMS-2014 - Property / Payor XRef3PROPERTYMMS-2014 - Venturenvarchar60
TOPSAP NetWeaver Mobile - Use subcomponents
50MEREP_TEST_ENVMI Testtool - Synchronization-properties3PROPERTYMI:Properties for the testcasesnvarchar500
51MEREP_TEST_PROPMI:Testtool Synchronization - properties3PROPERTYMI:Properties for the testcasesnvarchar500
52MEREP_TEST_SEQMI:Testtool Synchronization - properties3PROPERTYMI:Properties for the testcasesnvarchar500
TOPSAP Records Management
53SRMCMSEPREAttributes with Removed Inheritance Relationship6PROPERTYnvarchar300
TOPStatus and Action Management
54/PLMB/SAM_FCPLM Status Management - OType, Status, Struc, Field, Propert6PROPERTYField Property Optionnvarchar10
TOPSupply Chain Management
55/SDF/WS_MON_CONFConfiguration for WS Monitoring2PROPERTYCharacter field, length 32nvarchar320
TOPTax Reporting
56OIUX4_BALANCETaxes Payable Balance6PROPERTYProperty / DOInvarchar80
57OIUX4_BALANCE_HTaxes Payable Balance History6PROPERTYProperty / DOInvarchar80
58OIUX4_BAL_CTGZNTaxes Payable Balance Categorization6PROPERTYProperty / DOInvarchar80
59OIUX4_COMMENTSTaxes Payable Comments6PROPERTYProperty / DOInvarchar80
TOPTerminologyGlossary
60STERM_SYSDistributed Terminology Maintenance:2PROPERTYnvarchar400
TOPTravel Planning
61FTPT_HOTELTravel Request Item - Hotel Service10PROPERTYHotel Code (Key for an Individual Hotel)nvarchar60
62FTPT_HOTEL_COORDHotel Coordinates5PROPERTYHotel Code (Key for an Individual Hotel)nvarchar60
63FTPT_HOTEL_DATAHotel Data5PROPERTYHotel Code (Key for an Individual Hotel)nvarchar60
64TA20BHDisplayable Hotel Rates of User Groups5PROPERTYHotel Code (Key for an Individual Hotel)nvarchar60
65TA20NHNegotiated hotel rates (corporate nego rates)5PROPERTYIdentification of individual hotelnvarchar60
66TA20NH1Negotiated hotel rates (language-dependent)6PROPERTYIdentification of individual hotelnvarchar60
67TA20NHCNegotiated Hotel Rates5PROPERTYIdentification of individual hotelnvarchar60
68TA20NHC1Negotiated Hotel Rates (Language-Dependent)6PROPERTYIdentification of individual hotelnvarchar60
69TA20NRHDiscount Agreement for Hotel Accommodations6PROPERTYHotel Code (Key for an Individual Hotel)nvarchar60
70TA21PHCustomer-Specific Hotel Catalog5PROPERTYHotel Code (Key for an Individual Hotel)nvarchar60
71TA21PHCHotel Codes of a Catalog Hotel in Reservation System4PROPERTYHotel Code (Key for an Individual Hotel)nvarchar60
72TA23HOTELSHotel Data5PROPERTYHotel Code (Key for an Individual Hotel)nvarchar60
TOPWeb Service and SOAP - ABAP
73SRT_LP_FEATLogical Port Feature7PROPERTYAny URInvarchar2550
74SRT_LP_OP_FEATLogical Port Feature (Operation-Dependent)10PROPERTYAny URInvarchar2550
75SRT_REG_ADRMAPSRT: Local System Table for Mapping Virtual Host and Address3PROPERTYnvarchar320
76SRT_REG_CONFIGSRT Registry: Web Service Configuration Runtime6PROPERTYAny URInvarchar2550