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

77 columns | Print definition?ERP 6.0  | AUTHGRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CIDEON/AUTHGRPCIDEON Berechtigungsgruppen3AUTHGRPCIDEON Berechtigungsgruppenvarchar200
2/CIDEON/AUTHGRPTTexttabelle zu Berechtigungsgruppen4AUTHGRPCIDEON Berechtigungsgruppenvarchar200
3/CIDEON/MOVE_SCUmzugsmanagement: Umzugsszenarien12AUTHGRPCIDEON Berechtigungsgruppenvarchar200
4/PLMB/RCP_BB_SPEDefault Specifications for Building Block Creation6AUTHGRPAuthorization Groupnvarchar100
5/PLMB/RCP_SPECPODefaults for Primary Output Specification Creation5AUTHGRPAuthorization Groupnvarchar100
6DMS_TBL_LOCKEDMaintain Lock Field Status9AUTHGRPAuthorization Groupnvarchar10
7EHPRCC_CDCSPCComplince Data Category to Spec. Type6AUTHGRPAuthorization Groupnvarchar100
8IWP_HDB_RPILM Reporting Package/Perspective10AUTHGRPAuthorization Groupnvarchar40
9VIXCITCADAOTemporary architectural object data18AUTHGRPAuthorization Groupnvarchar400
10VIXCITCADROTemporary rental object data20AUTHGRPAuthorization Groupnvarchar400
TOPAccounting - General
11TFC_INST_HDRHeader Information on Status Admin for Fast Close15AUTHGRPAuthorization Group for Closing Cockpitnvarchar120
12TFC_TEMPL_HDRHeader Information on Status Admin for Fast Close15AUTHGRPAuthorization Group for Closing Cockpitnvarchar120
TOPBasic Data
13VIBDAOArchitectural Object14AUTHGRPAuthorization Groupnvarchar400
14VIBDBEBusiness Entity18AUTHGRPAuthorization Groupnvarchar400
15VIBDBUBuilding19AUTHGRPAuthorization Groupnvarchar400
16VIBDPRLand19AUTHGRPAuthorization Groupnvarchar400
17VIBDRORental Object19AUTHGRPAuthorization Groupnvarchar400
TOPBudgeting
18FMCECVGRPCover Groups19AUTHGRPAuthorization Group for Cover Groupsnvarchar100
19FMHIEIDSHierarchy IDs9AUTHGRPAuthorization Group of the Hierarchy IDnvarchar100
TOPClaims Management
20ICLACTIVITYTasks in Claim36AUTHGRPAuthorization Groupnvarchar40
21ICLEACTIVITYTasks in Claim Bundle36AUTHGRPAuthorization Groupnvarchar40
22ICLNOTEClaim Note21AUTHGRPAuthorization Group for Displaying/Changing a Notenvarchar40
23ICSACTIVITYActivity in the Claim36AUTHGRPAuthorization Groupnvarchar40
24ICSEACTIVITYTask in Claim Bundle Shadow Table36AUTHGRPAuthorization Groupnvarchar40
25ICSNOTENote21AUTHGRPAuthorization Group for Displaying/Changing a Notenvarchar40
26TICL110Amount Authorizations for Payments/Reserves3AUTHGRPAuthorization Groupnvarchar40
27TICL110_RESTYPAmount Authorizations Reserves (per Reserve Type)3AUTHGRPAuthorization Groupnvarchar40
28TICL111Authorization Groups2AUTHGRPAuthorization Groupnvarchar40
29TICL111TUser Groups for Authorizations3AUTHGRPAuthorization Groupnvarchar40
TOPCompliance Check
30EHSBT_RC_ESTRHSHEHS: Table f. Storing Substs w. Constraints in Shared Memory23AUTHGRPAuthorization Groupnvarchar100
TOPData Retention Tool
31TXW_C_V0Data view: Header4AUTHGRPAuthorization Groupnvarchar40
32TXX_C_V0View: Header Area4AUTHGRPAuthorization Groupnvarchar40
TOPEnvironment, Health and Safety
33/TDAG/CPC_SPTYPEImport material type3AUTHGRPAuthorization Groupnvarchar100
34TCG36EHS: Specification Authorization Object2AUTHGRPAuthorization Groupnvarchar100
35TCGC3EHS: Exchange profile9AUTHGRPAuthorization Groupnvarchar100
TOPFlexible Real Estate Management
36TIVCAAUTHGRPAuthorization Group3AUTHGRPAuthorization Groupnvarchar400
37TIVCAAUTHGRPTAuthorization Group (Text)4AUTHGRPAuthorization Groupnvarchar400
38VIITTCCorrection Object16AUTHGRPAuthorization Groupnvarchar400
39VILUERLUM: Baulastenverzeichnis9AUTHGRPBerechtigungsgruppenvarchar400
TOPFunds Management
40FMBUDGETPDFM: Budget Period Master Data7AUTHGRPFM: Budget Period authorization groupnvarchar100
TOPIncentive and Commission Management ICM
41TCACS_REGINCLIncludes for Modified, Generated Maintenance Dialogs3AUTHGRPAuthorization Groupnvarchar40
TOPIndustrial Hygiene and Safety
42CCIHC_WA11EHS: Authorization Groups for Work Areas2AUTHGRPAuthorization Group for Work Area or Patternnvarchar100
43CCIHC_WA12EHS: Language-Dependent Name for Auth. Groups in Work Area3AUTHGRPAuthorization Group for Work Area or Patternnvarchar100
44CCIHT_WAHEHS: Work Area - Header22AUTHGRPAuthorization Group for Work Area or Patternnvarchar100
TOPLand Use Management
45VILMJLJoint Liability16AUTHGRPAuthorization Groupnvarchar400
46VILMLRLand Register18AUTHGRPAuthorization Groupnvarchar400
47VILMNANotice of Assessment16AUTHGRPAuthorization Groupnvarchar400
48VILMPEOther Public Register16AUTHGRPAuthorization Groupnvarchar400
49VILMPLParcel of Land18AUTHGRPAuthorization Groupnvarchar400
50VILMRCParcel Update18AUTHGRPAuthorization Groupnvarchar400
TOPMaster Data
51FMMEASUREFM Funded Program Master Data7AUTHGRPFM: Funded Program Authorization Groupnvarchar100
TOPOffer and Rental Request
52VIOROFContract Offer16AUTHGRPAuthorization Groupnvarchar400
53VIOROOOffered Object16AUTHGRPAuthorization Groupnvarchar400
54VIORRRRental Request16AUTHGRPAuthorization Groupnvarchar400
TOPOverhead Cost Controlling
55TFKBFunctional areas3AUTHGRPFM: Authorization Group of Functional Areanvarchar100
TOPProduct Safety
56ESTRHEHS: Specification Header20AUTHGRPAuthorization Groupnvarchar100
57TCG36OBJEHS: Authorization Group - Specification Category Assignment2AUTHGRPAuthorization Groupnvarchar100
58TCG37EHS: Language-Dependent Desc. for Spec. Authorization Object3AUTHGRPAuthorization Groupnvarchar100
59TCGHITPOSEHS: Set of hit items5AUTHGRPAuthorization Groupnvarchar100
TOPReal Estate Contract
60VICNCNReal Estate Contract18AUTHGRPAuthorization Groupnvarchar400
TOPReal Estate Management
61VIAR02RE: REse@rch - RE Requests54AUTHGRPAuthorization groupnvarchar400
TOPRecipe Development
62/PLMB/RCP_RECIPERecipes27AUTHGRPAuthorization Group for Recipesnvarchar100
63/PLMB/RCP_SPECDefaults for Property Specification5AUTHGRPAuthorization Groupnvarchar100
TOPRemaining Beverage - Obsolete Objects
64/BEV3/CHAUTHGRPAuthorization Group Contract Handling2AUTHGRPAuthorization groupnvarchar100
65/BEV3/CHAUTHGRPTAuthorization Group Contract Handling Texts2AUTHGRPAuthorization groupnvarchar100
66/BEV3/CHBKOMTRAgreement Communication37AUTHGRPAuthorization groupnvarchar100
67/BEV3/CHWDContract Handling Document6AUTHGRPAuthorization groupnvarchar100
TOPRent Adjustment
68VIAJATAdjustment Measure16AUTHGRPAuthorization Groupnvarchar400
69VIAJCOMPGRPComparative Group of Apartments20AUTHGRPAuthorization Groupnvarchar400
TOPResourcen Management
70RMSLA_HDHTime-Dependent Header Data of Label Set15AUTHGRPAuthorization Group for Labelsnvarchar100
71RMXTT_TRIAL_HDTrial: Header Data35AUTHGRPAuthorization Group for Trialnvarchar100
TOPRetention Warehouse
72IWP_WPAudit Packages11AUTHGRPAuthorization Groupnvarchar40
TOPRoom Reservations and Seating Arrangements
73VIORMPMove Plan - Header Data25AUTHGRPAuthorization Groupnvarchar400
TOPService Charge Settlement
74VISCPGParticipation Group12AUTHGRPAuthorization Groupnvarchar400
75VISCSUSettlement unit20AUTHGRPAuthorization Groupnvarchar400
TOPSpecification
76/PLMI/SPC_DEFINIDefault Values for Specification and FES Initial Screens4AUTHGRPAuthorization Groupnvarchar100
TOPThird Party ManagementCOA
77VIMMMNMandate16AUTHGRPAuthorization Groupnvarchar400