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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

61 columns | Print definition?ERP 6.0  | PROFIL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPD_LA_AUCPROMPMap auction profile details to auction3PROFILEncoded data of the auction profilenvarchar2550
2TBP1ABudget/Plan Profile2PROFILProfilenvarchar60
3TBP1BBudget / Plan Profile Texts3PROFILProfilenvarchar60
4TBPFCAvailability Control: Tolerance Limits2PROFILProfilenvarchar60
5TOACUSAP ArchiveLink Customizing table36PROFILConsideration of Front.ininvarchar10
TOPBudgeting and Availability Control
6FMFCTRMVStore Bgt vals. returned before moving funds ctr.10PROFILProfilenvarchar60
TOPClasses
7CLPROFClassification: Parameters for Settings4PROFILProfile namenvarchar120
TOPClient Copy
8CCCFLOWClient Copy Control Flow22PROFILProfile name for client copynvarchar80
9CCPROFClient copy profiles1PROFILProfile name for client copynvarchar80
10CCPROFSRSource entries for profiles1PROFILProfile name for client copynvarchar80
11CCPROFTClient Copy Profile Texts2PROFILProfile name for client copynvarchar80
TOPCompletion Confirmations
12TCMFULScreen Layout for Completion Confirmations2PROFILConfirmation Profilenvarchar80
TOPContract Accounts Receivable and Payable
13TFKCRM_INFO_PROFFCC: Additional Information per Profile2PROFILCRM Profile Name for OI Selection for Acct Balance Displaynvarchar100
TOPCustomer Scheduling Agreement
14ESD_TOPRMaintenance of Tolerance Profiles2PROFILTolerance Profilenvarchar100
TOPDates
15TCXPSControl parameters for WBS scheduling2PROFILProfile for WBS schedulingnvarchar120
TOPElectronic Data Interchange
16PRICAT_K001PRICAT: Catalog header14PROFILPRICAT: Requirements profilenvarchar40
17PRICAT_PROPRICAT Outbound: Requirements Profile (Customizing)2PROFILPRICAT: Requirements profilenvarchar40
18PRICAT_PRO_TPRICAT outbound: Requirements profile (Customizing) texts3PROFILPRICAT: Requirements profilenvarchar40
TOPEmployee Interaction Center
19THREIC_IBPROF_TEIC Inbox: Profiles Text3PROFILEIC: Inbox Profilenvarchar100
TOPEngineering Change Management
20AEZUECH: Assign Material to Effectivity Profile3PROFILEffectivity profilenvarchar80
21TCC08Engineering Change Management: Control Data26PROFILEffectivity profilenvarchar80
22TCC15ECM profile2PROFILProfile identification for creating a change master recordnvarchar80
23TCC16Profile description3PROFILProfile identification for creating a change master recordnvarchar80
24TCC22ECH: Effectivity Profile2PROFILEffectivity profilenvarchar80
25TCC22TECM: Descriptions for Effectivity Profile2PROFILEffectivity profilenvarchar80
TOPFunds Management
26BPGVPrel.entry, overall15PROFILProfilenvarchar60
27BPJVPrel.entry - annual values16PROFILProfilenvarchar60
28FMFINCODEFIFM: Financing code10PROFILBudget profile for fundnvarchar60
29FMUP00Update Control (Not Value Type Dependent)1PROFILFM update profilenvarchar60
30FMUP00TUpdate Profiles2PROFILFM update profilenvarchar60
31FMUP01Update Control with Value Type Dependency1PROFILFM update profilenvarchar60
32FMUP02Customizbare Felder zum Fortschreibungsprofil2PROFILFM update profilenvarchar60
33FMUP03Customization control data for activating FM view2PROFILFM update profilenvarchar60
34TBP1CBudget/Plan Profile2PROFILProfilenvarchar60
35TBP1TBudget / Plan Profile Texts3PROFILProfilenvarchar60
36TBPFDCost Budget Availability Control: Tolerance Limits5PROFILProfilenvarchar60
37TBPFEFM Availability Control: Tolerance Limits4PROFILProfilenvarchar60
38TBPFMFM Active Availability Control7PROFILBudget Profilenvarchar60
39TBPFMXActive availability control on commitment budget8PROFILBudget Profilenvarchar60
40TBPFPCommitment Type Profile2PROFILProfile of Commitment Typesnvarchar60
41TBPFPTCommitment Type Profile Texts3PROFILProfile of Commitment Typesnvarchar60
42TBPFPVCommitment Types: Control2PROFILProfile of Commitment Typesnvarchar60
TOPInvestment Programs
43TAI05CI Program Types3PROFILBudget Profilenvarchar60
TOPJust-In-Time Processing
44CJIT13SumJC: JIT Customer Dependent Profile Settings2PROFILControl Profile for Summarized JIT Calls (SumJC)nvarchar120
45CJIT13TLanguage-Dependent Text Table for CJIT133PROFILControl Profile for Summarized JIT Calls (SumJC)nvarchar120
TOPMaintenance Orders
46TPEXTProfile for external procurement2PROFILExternal procurement profilenvarchar70
47TPEXT_TText tables for profiles (external procurement)3PROFILExternal procurement profilenvarchar70
48TPMUSPM/SM - User default values62PROFILConfirmation Profilenvarchar80
TOPReal Estate Management
49S402Business entities62PROFILPlanning profile for Real Estate objectsnvarchar70
50TIV98Default values for business entities2PROFILPlanning profile for Real Estate objectsnvarchar70
51TIV9HDefault Value Texts for Business Entities3PROFILPlanning profile for Real Estate objectsnvarchar70
52VIOB01Business entities43PROFILPlanning profile for Real Estate objectsnvarchar70
TOPResourcen Management
53RMSAC_PPDEFRMS-ATL: Definition of Process Parameters2PROFILProcess Parameter Profilenvarchar300
TOPTakeoverHandover of Technical Objects
54PHINHHeader Table for Take Over12PROFILTakeover / Handover Profile: Unique IDnvarchar20
TOPTest Organizer
55TNODE02ATest Organizer, Test Catalog, Plan, Package Attributes38PROFILProfile Weighting Test Statusnvarchar200
TOPTime Sheet
56TCATSDLISTCATS: Profile for Reporting (List Display)2PROFILList Profilenvarchar80
57TCATX_GRIDCATX: Column Assignment for Data Entry Table2PROFILData Entry Profilenvarchar80
TOPTravel Planning
58PA0469HR master record for infotype 046924PROFILTravel Profilenvarchar80
59PA0470HR master record infotype 0470 (travel profiles)24PROFILPersonal travel profilenvarchar80
TOPTreasury
60ATVO4Volatilities - Master Data3PROFILVolatility Pofilenvarchar150
61ATVO5Volatilities - Flow Data5PROFILVolatility Pofilenvarchar150