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

119 tablesERP 6.0 

Project System :: Structures
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CNLDST_APPL21Applications for Activating Language-Dependent Short TextsStructures
2ERP EHP76.0CNLDST_APPLT51Application NamesStructures
3ERP EHP76.0CNLDST_OBJ61Objects for Activating Language-Dependent Short TextsStructures
4ERP EHP76.0CNLDST_OBJS51Appl.and Obj. with Activated Language-Dependent Short TextsStructures
5ERP EHP76.0CNLDST_OBJT61Object Type NamesStructures
6ERP EHP76.0CNLDST_SHORTTX152Table of Language-Dependent Short TextsStructures
7ERP EHP76.0PSACL_FLAGS_TAB41PS Project and Network ACL FlagsStructures
8ERP EHP76.0PSACL_TAB112Table for PS ACL IntegrationStructures
9ERP EHP76.0PSHLP_ACT_PM_DT41Table for tracking whether acty dates are determined by pmcsStructures
10ERP EHP76.0PSHLP_CUST_DPROF231Data Selection ProfileStructures
11ERP EHP76.0PSHLP_CUST_PROFT41Test table for displaying different languagesStructures
12ERP EHP76.0PSHLP_DATASET_DB141To store the user specific datasets chosenStructures
13ERP EHP76.0PSHLP_FILTER_DB61Project Worklist - User Specific Filter TableStructures
14ERP EHP76.0PSHLP_NETWWL_DB91Network ACL WorklistStructures
15ERP EHP76.0PSHLP_PROJWL_DB91Project Definition ACL WorklistStructures
16ERP EHP76.0PSHLP_WBSWL_DB91WBS Elements ACL WorklistStructures
17ERP EHP76.0PSHMEM_CLUS_TAB61Clustered Table for Shared MemoryStructures
18ERP EHP76.0PSLA_CONFIG_TBL51Configuration of Commercial Project InceptionStructures
19ERP EHP76.0PSPR_GRP_IND31Purchase requisitaion grouping indicators in PSStructures
20ERP EHP76.0PSPR_GRP_IND_PR81Grouping Indicators and purchase requisition numbersStructures
21ERP EHP76.0PSPR_GR_IND_REL81Assignment of group indicator dataStructures
22ERP EHP76.0PSSKF_DEFAU_TAB111Default SKF for the the Project ParametersStructures
23ERP EHP76.0PSSKF_ENABLE_TAB51activate deactivate SKF tab in the Project BuilderStructures
24ERP EHP76.0PSSKF_RATES_TAB131Save the SKF rates for the calculation of the work duration.Structures
Project System :: Structures :: Interface to External Project Software
ProductVersionTableColumnsIndexesDescriptionModule
25ERP EHP76.0NPGUID93GUIDs for Network HeaderInterface to External Project Software
26ERP EHP76.0NVGUID113GUIDs for Network ActivityInterface to External Project Software
27ERP EHP76.0PDGUID93GUIDs for Project DefinitionInterface to External Project Software
28ERP EHP76.0PRGUID93GUIDs for WBS ElementInterface to External Project Software
29ERP EHP76.0PSGUID104GUIDs for Project DefinitionInterface to External Project Software
30ERP EHP76.0RIASSIGNMENTS133Assignment Table of Replication cProject PSInterface to External Project Software
31ERP EHP76.0RIPROFILES61Profiles for the Replication cProject PSInterface to External Project Software
32ERP EHP76.0RIPROFILEST41Language-Dependent Texts for Project ScenarioInterface to External Project Software
Project System :: Structures :: Operative Structures
ProductVersionTableColumnsIndexesDescriptionModule
33ERP EHP76.0CNSOI_NEW_LOGIC21"New Logic" Used for PS TextsOperative Structures
34ERP EHP76.0NHAUFK42Number history of network reorganizationOperative Structures
35ERP EHP76.0NHPROJ53Number history - Project definitionOperative Structures
36ERP EHP76.0NHPRPS63Number history for reorganization of WBS elementsOperative Structures
37ERP EHP76.0NPTX52PS Texts (Network)Operative Structures
38ERP EHP76.0PLTX92PS Texts (Library Network)Operative Structures
39ERP EHP76.0PRHI72Work Breakdown Structure, Edges (Hierarchy Pointer)Operative Structures
40ERP EHP76.0PROJ955Project definitionOperative Structures
41ERP EHP76.0PRPS1217WBS (Work Breakdown Structure) Element Master DataOperative Structures
42ERP EHP76.0PRTP31SubprojectsOperative Structures
43ERP EHP76.0PRTX42PS Texts (WBS)Operative Structures
44ERP EHP76.0PSTT41PS texts (description)Operative Structures
45ERP EHP76.0PSTX93PS Texts (Header)Operative Structures
46ERP EHP76.0PSTXB91SAPscript: Texts in non-SAPscript formatOperative Structures
47ERP EHP76.0PSTXH312PTXD PS Text File HeaderOperative Structures
48ERP EHP76.0TCJ01151Project Management Control ParametersOperative Structures
49ERP EHP76.0TCJ0441Person in Responsible for ProjectOperative Structures
50ERP EHP76.0TCJ0531Project applicantOperative Structures
51ERP EHP76.0TCJ121"Project Types"Operative Structures
52ERP EHP76.0TCJ1T41"Project Types"Operative Structures
53ERP EHP76.0TCJ41991Default Values for Work Breakdown StructureOperative Structures
54ERP EHP76.0TCJ4T41Supplies Texts for Project ProfilesOperative Structures
55ERP EHP76.0TCJED51Table for Project Number EditingOperative Structures
56ERP EHP76.0TCJET41Texts for Project Number EditingOperative Structures
57ERP EHP76.0TCN0051Key Word ID for PS User FieldsOperative Structures
58ERP EHP76.0TCN01161Key Word Text for PS User FieldsOperative Structures
59ERP EHP76.0TCN0331PS Text TypesOperative Structures
60ERP EHP76.0TCN0451PS Text TypesOperative Structures
61ERP EHP76.0TCN0721PriorityOperative Structures
62ERP EHP76.0TCN7T41Text table for priorities (TCN07)Operative Structures
63ERP EHP76.0TTXPSFORMAT41PS Text FormatOperative Structures
64ERP EHP76.0TTXPSFORMATT51PS Text FormatOperative Structures
Project System :: Structures :: Templates
ProductVersionTableColumnsIndexesDescriptionModule
65ERP EHP76.0PRHIS72Standard WBS, Edges (Hierarchy pointers)Templates
66ERP EHP76.0PROJS843Standard project definitionTemplates
67ERP EHP76.0PRPSS925Standard WBS Element (WBS element) - Master DataTemplates
68ERP EHP76.0PRTXS41PS texts (standard WBS)Templates
Project System :: Structures :: Operative Structures :: Network and Activity
ProductVersionTableColumnsIndexesDescriptionModule
69ERP EHP76.0AFAB315Network - RelationshipsNetwork and Activity
70ERP EHP76.0MLST1095MilestoneNetwork and Activity
71ERP EHP76.0MLTX62Milestone DescriptionNetwork and Activity
72ERP EHP76.0MSET71Standard milestone setNetwork and Activity
73ERP EHP76.0PLAB302RelationshipsNetwork and Activity
74ERP EHP76.0SMGT51Milestone group descriptionNetwork and Activity
75ERP EHP76.0SMLG31Standard milestone groupNetwork and Activity
76ERP EHP76.0SMLS772Standard milestoneNetwork and Activity
77ERP EHP76.0T43361Milestone IndicatorNetwork and Activity
78ERP EHP76.0T433T41Milestone textsNetwork and Activity
79ERP EHP76.0TABLO81Assignment table-orders to activitiesNetwork and Activity
80ERP EHP76.0TCN0621Activity status that can trigger a workflow processNetwork and Activity
81ERP EHP76.0TCN41781Network DefaultsNetwork and Activity
82ERP EHP76.0TCN4T51Language-dependent Texts for TCN41: Network ProfilesNetwork and Activity
83ERP EHP76.0TCN51231Version profile for PS versionsNetwork and Activity
84ERP EHP76.0TCN5T41Language-dependent texts for TCN51: Version profilesNetwork and Activity
85ERP EHP76.0TCN61141Parameter: Create network from sales orderNetwork and Activity
86ERP EHP76.0TCNPRRL41Assignment of Users to Roles for Monitoring DatesNetwork and Activity
87ERP EHP76.0TCNROLE21Roles in Monitoring DatesNetwork and Activity
88ERP EHP76.0TCNTM0121Date typeNetwork and Activity
89ERP EHP76.0TCNTM01F91Reference Dates for Date Types of an EventNetwork and Activity
90ERP EHP76.0TCNTM01T41Language dependent description of date typesNetwork and Activity
91ERP EHP76.0TCNTM0251Group for monitoring datesNetwork and Activity
92ERP EHP76.0TCNTM0381Assignment of date type/milestone to groupNetwork and Activity
93ERP EHP76.0TCNTM0431Status of Event in Monitoring DatesNetwork and Activity
94ERP EHP76.0TCNTM04T41Language Dependent Description of StatusNetwork and Activity
95ERP EHP76.0TCNTM0551Assignment Components to GroupsNetwork and Activity
96ERP EHP76.0TCNTM06101Dates for Components, Events and Date TypeNetwork and Activity
97ERP EHP76.0TCNTM0761Status of a Date Type for a ComponentNetwork and Activity
98ERP EHP76.0TCNTMPR171Profile for Monitoring DatesNetwork and Activity
99ERP EHP76.0TCNTMPRT41Language Dependent Description of the ProfileNetwork and Activity
100ERP EHP76.0TCNTMSCHD61Suggestions for Scheduling EventsNetwork and Activity
101ERP EHP76.0TCNTMSPR21Scenarios for Scheduling in Monitoring DatesNetwork and Activity
102ERP EHP76.0TCNTMSPRT41Language Dependent Description of the Scheduling ProfileNetwork and Activity
103ERP EHP76.0TCNTS31Permissible subscrrens per objectNetwork and Activity
104ERP EHP76.0TCOFP101FORM subscreen for functions in milestone/trigger pointNetwork and Activity
Project System :: Structures :: Operative Structures :: Orders for Projects
ProductVersionTableColumnsIndexesDescriptionModule
105ERP EHP76.0COSPP1451Transfer of the Order in the COSP Table to the ProjectOrders for Projects
106ERP EHP76.0COSSP1611Transfer of the Order COSS Table to the ProjectOrders for Projects
107ERP EHP76.0FMSP462Copy FMSU table order to projectOrders for Projects
Project System :: Structures :: Operative Structures :: Project Builder
ProductVersionTableColumnsIndexesDescriptionModule
108ERP EHP76.0CNPB_INDX61Preview for Project BuilderProject Builder
Project System :: Structures :: Operative Structures :: Project Planning Board
ProductVersionTableColumnsIndexesDescriptionModule
109ERP EHP76.0PSPPT_INDX131System table INDXProject Planning Board
110ERP EHP76.0TBALK51Screen sequence control: paths between processing locationsProject Planning Board
111ERP EHP76.0TCBP631Gantt chart settingsProject Planning Board
112ERP EHP76.0TCBPF251Field Assignment PPB Structure -> DB StructureProject Planning Board
113ERP EHP76.0TCBPT41Text for settings in Gantt chartProject Planning Board
114ERP EHP76.0TCTH121Settings for hierarchy graphic (schedule maint.)Project Planning Board
115ERP EHP76.0TCTHT41Texts for settings in hierarchy graphic (schedule maint.)Project Planning Board
116ERP EHP76.0TFELD71Assignment of Table Fields to Field SelectionProject Planning Board
Project System :: Structures :: Templates :: Standard Network
ProductVersionTableColumnsIndexesDescriptionModule
117ERP EHP76.0SMLT61Standard milestone descriptionStandard Network
118ERP EHP76.0TCA41661Default values for standard networks and profilesStandard Network
119ERP EHP76.0TCA4T51Lang-dep. text table for profile table TCA41Standard Network