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

84 columns | Print definition?ERP 6.0  | OUTPUTLEN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMFND/GS001AGeospatial service - Service Provider Attributes Meta Info16OUTPUTLENOutput Lengthnvarchar60
2/SYCLO/CA003DMDO DOF Table Rule - Meta Data13OUTPUTLENOutput Lengthnvarchar60
3BBP_DYNAT_DOM2Possible Types in Definition of Dynamic Attributes3OUTPUTLENOutput Lengthnvarchar60
4BBP_DYNAT_DOMMASPossible Types in Definition of Dynamic Attributes3OUTPUTLENOutput Lengthnvarchar60
5CNVCMIS_A_1_DOMASelection of Object Type Master information9OUTPUTLENOutput Lengthnvarchar60
6CNVCMIS_A_1_DTELSelection of Object Type Master information35OUTPUTLENOutput Lengthnvarchar60
7CNVMBTTABSTRUCField list of tables for file transfer16OUTPUTLENOutput Lengthnvarchar60
8COSFD_RSPROF02Customizing Dispatching Profile Parameters7OUTPUTLENColumn Widthnvarchar20
9COSFD_WLPROF02Worklist Profile Parameters7OUTPUTLENColumn Widthnvarchar20
10IUUC_RL_TABSTRstructural historical information for tables(Transp,Cluster)10OUTPUTLENOutput Lengthnvarchar60
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
11DD01LDomains6OUTPUTLENOutput Lengthnvarchar60
12DD04LData elements27OUTPUTLENOutput Lengthnvarchar60
TOPAdvertising Management
13TJHVPLTIS-M/AM: Field Selection For Display Variants List Tool7OUTPUTLENOutput Lengthnvarchar60
TOPApplication Framework
14MDG_MDF2005Properties of Master Data Fields23OUTPUTLENOutput Lengthnvarchar60
TOPApplication-Specific Upgrade
15/ASU/ATTRIB_CUSTASU Attribute Customizing6OUTPUTLENALV control: Column width in charactersnvarchar60
TOPBank Customer Accounts
16TBKK11BCA Lists: Field Catalog for List Tool (KKBLO_FIELDCAT)20OUTPUTLENOutput lengthnvarchar60
TOPBusiness Configuration Sets
17SCPRDATABC Set: Values9OUTPUTLENBC Set: Value lengthsmallint50
18SCPRDATACBC Set: Values7OUTPUTLENBC Set: Value lengthsmallint50
TOPBusiness Planning and Simulation
19UPC_CHAPROProperties of a Characteristic9OUTPUTLENOutput Lengthnvarchar60
20UPC_KYFPROProperties of a Characteristic9OUTPUTLENOutput Lengthnvarchar60
TOPCapacity Evaluations
21TCYFProfile detailed list: Displayed fields6OUTPUTLENOutput Lengthnvarchar60
TOPCapacity Leveling
22TCY39_SSelected fields for a layout key8OUTPUTLENOutput Lengthnvarchar60
TOPCATT Computer Aided Test Tool
23CAT_FINFOGeneral Control field info9OUTPUTLENNatural Numberint100
TOPChange Documents
24CDSOLMIG_DDChange Document Objects to be Migrated17OUTPUTLENOutput Lengthnvarchar60
TOPClinical System
25N2DEIS-H*MED: Table of documentation elements30OUTPUTLENOutput Lengthnvarchar60
26N2ETIS-H*MED: Table of docElement to DocCategory assignments47OUTPUTLENOutput Lengthnvarchar60
27N2LAIS-H*MED: List display variant per user (Field list)9OUTPUTLENOutput Lengthnvarchar60
TOPCondition Technique
28/SAPCND/T688CFields from Condition Tables Sorted Acc. To Dependency21OUTPUTLENOutput Lengthnvarchar60
TOPCross-Application Components
29/IXOS/DC_TACAAdministrator maintenance for Editing14OUTPUTLENOutput Lengthnvarchar60
30/IXOS/DC_TADAAdministrator maintenance for Details13OUTPUTLENOutput Lengthnvarchar60
31/IXOS/DC_TADUDetail user maintenance13OUTPUTLENOutput Lengthnvarchar60
32/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)11OUTPUTLENOutput Lengthnvarchar60
33/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)13OUTPUTLENOutput Lengthnvarchar60
34/IXOS/DC_TAIAAdministrator maintenance for Creating17OUTPUTLENOutput Lengthnvarchar60
35/IXOS/DC_TAIUCapture user maintenance - not used12OUTPUTLENOutput Lengthnvarchar60
36/IXOS/DC_TAMAGeneral Doculink administraton data for data source12OUTPUTLENOutput Lengthnvarchar60
TOPData Basis
37RSBFILEMAPMapping of Fields of an InfoSpoke on a DB Table5OUTPUTLENOutput Lengthnvarchar60
38RSBOHFIELDSFields of the Open Hub Destination10OUTPUTLENOutput Lengthnvarchar60
TOPData Conversion
39DMC_FIELDDMC: Data Field of a Structure18OUTPUTLENOutput Lengthnvarchar60
TOPData Staging
40RSDSSEGFDDataSource - Segment Fields20OUTPUTLENOutput Lengthnvarchar60
41RSDSSEGFDSHDataSource in BW - Shadow Table Fields20OUTPUTLENOutput Lengthnvarchar60
TOPFast Search Infrastructure
42SFSRFW_IDX_IFDReplication Framework - Definition of Index Fields11OUTPUTLENOutput Lengthnvarchar60
43SFSRFW_IDX_KEY_DReplication Framework - Doc. ID Description of an Index10OUTPUTLENOutput Lengthnvarchar60
44SFSRFW_REQ_OBJSReplication Framework Requested Tables13OUTPUTLENOutput Lengthnvarchar60
TOPFinancials Basis
45UGMD2005FIN Master Data: Field Properties24OUTPUTLENOutput Lengthnvarchar60
46UGMD2040FIN Master Data: Definition of BW Info Objects31OUTPUTLENOutput Lengthnvarchar60
47UGMD2050FIN Master Data: Active Definition of BW Info Objects30OUTPUTLENOutput Lengthnvarchar60
48UGMD2060FIN Master Data: Properties Valid During Generation7OUTPUTLENOutput Lengthnvarchar60
49UGMD2140FIN Master Data: (Role-independent) Definition of Fields18OUTPUTLENOutput Lengthnvarchar60
50UGMD2150FIN Master Data: Active (Role-Indep.) Definition of Fields17OUTPUTLENOutput Lengthnvarchar60
TOPFSCM In-House Cash
51IHC_TAB_GUI_WLIHC: Setting for Browser Worklist6OUTPUTLENALV control: Column width in charactersnvarchar60
TOPInformation System
52TCNFProject Information System: Displayed Fields9OUTPUTLENOutput Lengthnvarchar60
TOPJust-In-Time Processing
53JITTC3Layout of Detail Display9OUTPUTLENOutput Lengthnvarchar60
TOPLegacy System Migration Workbench
54/SAPDMC/LSGBDCBI Name: "Code"21OUTPUTLENOutput Lengthnvarchar60
TOPMetadata Repository
55RSDCHABASBasic characteristics (for chars, XXL, time-chars and units)6OUTPUTLENOutput Lengthnvarchar60
56RSDDPAData package characteristics8OUTPUTLENOutput Lengthnvarchar60
TOPNetWeaver Enterprise Search
57ESH_OM_ADATATYData Types13OUTPUTLENOutput Lengthnvarchar60
58ESH_OM_CDATATYData Types13OUTPUTLENOutput Lengthnvarchar60
59ESH_OM_IDATATYData Types13OUTPUTLENOutput Lengthnvarchar60
60ESH_OM_SDATATYData Types13OUTPUTLENOutput Lengthnvarchar60
TOPOrganizational Management
61T77OMATTRGeneral Attribute Maintenance: Definition of Attributes14OUTPUTLENOutput Lengthnvarchar60
TOPPerformance Monitors TCC
62SAPWLT000SAP workload: statistics data78OUTPUTLENSAP Workload: Workload: integer without a leading signdecimal100
TOPPersonal Object Worklist
63POWL_SELCRIT_CCust table for powl selcrit15OUTPUTLENnvarchar60
TOPPlanning
64T8PL01DDFI Planning: Dimensions Table Index - Dictionary Information10OUTPUTLENOutput Lengthnvarchar60
65T8PLUATTRFI-Planning: Key Figures for Planning12OUTPUTLENOutput Lengthnvarchar60
TOPProduct Safety
66TCG11_VAIEHS: Table-Based Value Assignment of Specifications10OUTPUTLENColumn Width in Charactersnvarchar60
TOPProduct Structure Browser
67USRLISTPROFILEVariable List Definition in PDM Environment10OUTPUTLENOutput Lengthnvarchar60
TOPProduction Orders
68TCOAOBProfile order progress report: Displayed fields objects6OUTPUTLENOutput Lengthnvarchar60
69TCOFFProfile for Missing Parts Info System: Displayed Fields6OUTPUTLENOutput Lengthnvarchar60
70TCOPSField selection profile7OUTPUTLENOutput Lengthnvarchar60
TOPProfitability Analysis
71TKEPPLLOGFCATField Catalog for Displaying Logs in Application Log6OUTPUTLENALV control: Column width in charactersnvarchar60
TOPRegulatory reporting for insurance companies
72TISSR_TP_ALVGRIDISSR: Einstellung ALV-Grid Umbuchung Meldedaten16OUTPUTLENALV-Control: Spaltenbreite in Characternvarchar60
TOPRemaining Beverage - Obsolete Objects
73/BEV3/CHCKAFIELDCustomizing Table for List Viewer Reports (Evaluations)7OUTPUTLENOutput Lengthnvarchar60
74/BEV3/CHCLISTFLDCustomizing Table for List Viewer Reports (Evaluations)6OUTPUTLENOutput Lengthnvarchar60
75/BEV3/CHREPFLDCH: Field Control for Report Outputs Using ALV (CDP)4OUTPUTLENOutput Lengthnvarchar60
TOPSCM Basis
76CIFALOGCNFConfiguration of the CIF Application Log8OUTPUTLENLength (No. of Characters)nvarchar60
TOPService Data Download
77/BDL/IFFIELD/BDL/SDCC: fiels, dataelements and domains of table15OUTPUTLENnvarchar60
78BDLIFFIELDBDL SDCC: Table's Fields, Data Elements, Domains15OUTPUTLENnvarchar60
TOPShift Planning for Public Sector
79PSPP_INFO_COLTable for Info Columns Associated with a Variant6OUTPUTLENNatural Numberint100
TOPTreasury
80CML_MIG_BUFFERTable DDIC buffering (migration)13OUTPUTLENOutput Lengthnvarchar60
TOPUser and Authorization Management
81AUTH_FLDINFO_TMPAuthorization fields: technical info from dictionary9OUTPUTLENOutput Lengthnvarchar60
TOPWarranty Claim Processing
82WTY_FIELD_ATTR1Setting Fields for ALV Warranty Check8OUTPUTLENALV control: Column width in charactersnvarchar60
TOPWorkbench Utilities
83SPAR_NTDBParameter Storage: Persistent Nametab Container16OUTPUTLENOutput Lengthnvarchar60
TOPWorkforce Planning
84TCYMPPCustomizing Settings for Workforce Planning12OUTPUTLENWidth of planning periodsnvarchar60