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

51 columns | Print definition?ERP 6.0  | HIDDEN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/UIF/LREPDCONTLRep content table7HIDDENData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
2/UIF/LREPDCONTCDLRep content table - client-dependent8HIDDENData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
3/UIF/LREPDCONTULRep content table - user-dependent9HIDDENData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
4BTP_DL_OBJECTBTP Object8HIDDENBTP Object Flag 'Hidden'nvarchar10
5CNVMBTIFPARAMPIFD Parameters contained in an Interface5HIDDENHidden Flagnvarchar10
6CNVMBTITEMSCheck items7HIDDENFlag (X or Blank)nvarchar10
7CNVMBTVARPARAMPIFD Parameters contained in an Interface5HIDDENHidden Flagnvarchar10
8GRFNREPFILTERCReport: Filter - customer9HIDDENReport: Flag for hidden columnnvarchar10
9HRP5349DB Table for Infotype 534921HIDDENReport: Flag for hidden columnnvarchar10
10sap_tr2_dirs2HIDDENchar10
11T5UPBS01FAVORITENature of Actions Favorites Tree10HIDDENFlag (X or Blank)nvarchar10
12T5UPBS01TREEPersonnel Actions Tree10HIDDENFlag (X or Blank)nvarchar10
13TEWA_EL_OBJBHUIFBehavioral Control User Interface Fields8HIDDENBehavioral Control "Hidden" Propertynvarchar10
TOPBusiness Package for Manager Self-Service HR
14TWPC_ACOLColumns in a Column Group7HIDDENColumn is Hiddennvarchar10
15TWPC_ACOL_CColumns in a Structure - Customer7HIDDENColumn is Hiddennvarchar10
TOPBusiness Planning and Simulation
16UPX_KFS_COMMONKey Figure Schemes for Planning Layouts: General Fields4HIDDENKey Figure Hiddennvarchar10
TOPCase Management
17SCMGATTRPROFACase: Profile Attributes8HIDDENCase: Flag Invisible for Attributenvarchar10
TOPClinical System
18N2DSDADRTYPi.s.h.med: Dispatch - Address Types5HIDDENRecipient Hidden Indicatornvarchar10
19TN2DLV_ADTYPi.s.h.med: Dispatch - Address Types5HIDDENRecipient Hidden Indicatornvarchar10
TOPEasy Enhancement Workbench
20WCF_BSP_BUTTONStandard WCF BSP Button16HIDDENBooleannvarchar10
TOPEnd User Technology
21RSZELTATTRAttribute selection per dimension element7HIDDENStrMember: Member will not be displayednvarchar10
22RSZELTPROPElement properties (settings)69HIDDENDo Not Display Elementnvarchar10
23RSZTREESTRUCTURETable with Example Description of a Tree Structure6HIDDENBooleannvarchar10
TOPForce Element
24/ISDFPS/WFCUTREECustomizing Table for Workflow Customizing Tree6HIDDENSingle-Character Indicatornvarchar10
TOPGeneral Application Functions
25BAMUIDTLCApplication Analysis: UI: Detail Lists: Columns13HIDDENApplication analysis: UI: Detail lists: Column invisible?nvarchar10
TOPGovernance, Risk and Compliance
26GRFNREPFILTERReport: Filter8HIDDENReport: Flag for hidden columnnvarchar10
TOPHR Administrative Services
27T5ASRDABFOLDERSSequence of Nodes in Infotype Browser4HIDDENHidenvarchar10
TOPIncentive and Commission Management ICM
28TCACS_NDPROCustomizing Table for Tree Profiles18HIDDENFlag (X or Blank)nvarchar10
TOPIntegration of FPM and Persistency Frameworks like BOPF
29/BOFU/IPBI_POWLSPOWL: Selection Parameters11HIDDENPOWL: Hiddennvarchar10
TOPMaxDB
30SDBTREEDEFSAP DB: CCMS Navigation Trees - Node Definition5HIDDENFlag (X or Blank)nvarchar10
TOPMonitoring
31SAPWLTREEGSAP Workload: Nodes for ST03G Tree Controls6HIDDENFlag (X or Blank)nvarchar10
TOPOrganizational Management
32T77ACOLCColumn Framework: Columns in a Column Group8HIDDENColumn Framework: Column Hidden by Defaultnvarchar10
33T77ACOLINIIntial Settings for Array Type Column4HIDDENColumn Framework: Column Hidden by Defaultnvarchar10
TOPPersonal Object Worklist
34POWL_SELCRIT_CCust table for powl selcrit10HIDDENX-Flagnvarchar10
TOPProfitability Analysis
35TKEMDMTable for Jump to CO-PA Master Data Maintenance6HIDDENFlag: Hide fixed / referenced characteristicnvarchar10
36TKEMDM_CCustomer Table for Jump to CO-PA Master Data Maintenance6HIDDENFlag: Hide fixed / referenced characteristicnvarchar10
TOPRegulatory reporting for insurance companies
37TISSR_TP_ALVNODEISSR: Einstellung ALV-Tree-Modell Knotenstrukturen12HIDDENFlag (X oder Blank)nvarchar10
TOPSAP Utilities
38ISU_BOLTREE_HIERUtilities BOL Tree: Define Tree Hierarchy7HIDDENHiddennvarchar10
39ISU_BOLTREE_PCOLUtilities BOL Tree: Column Definition5HIDDENUtilities BOL Tree: Column is hiddennvarchar10
TOPSpecification 2
40SPCM_DISP_MENUAction table for A&D Displaytool (menu)10HIDDENFlag indicating function is activenvarchar10
TOPTag Library
41CRMD_FLEX_COLROWdescription for Flex table row or column10HIDDENnvarchar10
TOPTransaction Manager
42TCORFTS_CONFIGConfiguration Control7HIDDENConfiguration table not to be displayednvarchar10
TOPUI Configuration Design Layer
43BSPC_DL_FIELDUSEField Property table7HIDDENData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
44BSP_DLC_DESIGNDesign layer: Design5HIDDENHidden Fieldnvarchar10
45BSP_DLC_SDESIGNDesign layer: Design4HIDDENHidden Fieldnvarchar10
TOPUse Subcomponents
46SIN_T_LINKNavigation Area of SAPBPT Workplace6HIDDENFlag (X or Blank)nvarchar10
TOPWeb Services Tool
47CRMC_WST_DESIGNOpen Services Tool: Design5HIDDENHidden Fieldnvarchar10
TOPWebClient UI
48WCF_MLC_OBJ_FLDSFields for UI Object types5HIDDENCheckboxnvarchar10
49WCF_ML_OBJ_FLDSFields for UI Object types4HIDDENCheckboxnvarchar10
TOPWithout Description
50RSRBATRAttribute table for print settings7HIDDENStrMember: Member will not be displayednvarchar10
51RSRBMEMAttribute table for print settings7HIDDENStrMember: Member will not be displayednvarchar10