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

88 columns | Print definition?ERP 6.0  | CHTIM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BKK_OPD_IT_EXTExternal Item Selection Table - Outgoing Payment Dispatcher51CHTIMTime at Which Object was Last Changednvarchar60
2CNVMBTCLUSTTABCluster tables DDIC for de-clustered systems5CHTIMSystem Timenvarchar60
3DFKKPARTADJTrigger for Adjustment of Partner Billable Items14CHTIMTime at Which the Object Was Last Changednvarchar60
4P05EIR_MTY_STATElectronic Illness Reporting: Status Table9CHTIMTimenvarchar60
TOPAccount Management
5BKK42_NTCMaster Data for Notice and Allowances21CHTIMTime at Which Object was Last Changednvarchar60
6BKKNTCNotice: Partial Amount and Full Amount Notice22CHTIMTime at Which Object was Last Changednvarchar60
TOPAddress ManagementBusiness Address
7SADRAddress Management: Company Data45CHTIMAddresses: Changed atnvarchar60
8SADRPAddress Management: Personal Data15CHTIMAddresses: Changed atnvarchar60
TOPALE Integration Technology
9BDEOIO_INEOIO: Queue Management in IDoc Inbound Processing7CHTIMTimenvarchar60
10BDEOIO_OUTEOIO: Queue Management in IDoc Outbound Processing9CHTIMTimenvarchar60
11BDRGINALE: Inbound Channel Registry8CHTIMTimenvarchar60
12BDRGOUTALE: Outbound Channel Registry8CHTIMTimenvarchar60
TOPAnalyzer
13AFWCH_FCAT_SAMPAFW: Sample Customizing Characteristics50CHTIMTime of Changenvarchar60
TOPApplication-Specific Upgrade
14/ASU/HEADERASU Version Header10CHTIMField of type TIMSnvarchar60
TOPBank Customer Accounts
15BKKCORRITEMAuxiliary Table: Payment Items for Adjustments96CHTIMTime at Which Object was Last Changednvarchar60
16BKKSOBCA: Standing Orders41CHTIMTime at Which Object was Last Changednvarchar60
17BKK_PRENOTEPrenotes42CHTIMTime at Which Object was Last Changednvarchar60
18NIHC_DB_PO_PNTASource Document for Incoming Payment Orders47CHTIMTime when the object was created or changednvarchar60
19TBKKCORRBCA: Table showing if Correspondence is Active8CHTIMTime at Which Object was Last Changednvarchar60
TOPBasic Functions
20T853Company status39CHTIMSystem Timenvarchar60
TOPBusiness Partner
21BPOBTABPartner-Object Relationship18CHTIMTime at which object was last changednvarchar60
TOPBusiness Planning
22UPBXPlanning Applications: Generic Data Container7CHTIMTIME Data Element for SYSTnvarchar60
TOPConsolidation
23TF90FActive Field Catalog, Consolidation50CHTIMTime of Changenvarchar60
24TF90SBasis Field Catalog Consolidation (Fixed Fields)50CHTIMTime of Changenvarchar60
25TF91FField Catalog, Consolidation50CHTIMTime of Changenvarchar60
TOPContract Accounts Receivable and Payable
26DFKK_BL_BPLocked Business Partners from GTS7CHTIMTime at which object was last changednvarchar60
27DFKK_EMBARGOEmbargo Countries from GTS5CHTIMTime at which object was last changednvarchar60
28DFKK_EMBARGO2Embargo Countries From - To from GTS6CHTIMTime at which object was last changednvarchar60
TOPData Collection
29TKAFField catalog for Accounting51CHTIMTime of Changenvarchar60
30TKCFSAP-EIS Field Catalog50CHTIMTime of Changenvarchar60
31TKCHHSAP-EIS: Hierarchy header8CHTIMTime of Changenvarchar60
32TKCKKey figures15CHTIMTime of Changenvarchar60
33TKCSBasic field catalog SAP-EIS (fixed fields)50CHTIMTime of Changenvarchar60
TOPFinancials Basis
34UGCMBACKData Model Synchronization: Backup for Conversion6CHTIMTIME Data Element for SYSTnvarchar60
TOPFSCM In-House Cash
35IHC_DB_PNSource Document for Incoming Payment Orders93CHTIMChanged Atnvarchar60
TOPGL transfer
36BKKC01Gen.Ledger: Reconciliation Key Accounting Documents14CHTIMTime at Which Object was Last Changednvarchar60
37BKKCNOITGLTable of Items not Updated on the Account44CHTIMTime at Which Object was Last Changednvarchar60
38BKKCVAAdministration Table Individual Value Adjustment15CHTIMTime at Which Object was Last Changednvarchar60
TOPIncentive and Commission Management ICM
39TCACSFCommissions: Field Catalog Search51CHTIMTime of Changenvarchar60
TOPInformation System
40TKAF_USER_APPD_KField Catalog for Customer Key Figures19CHTIMTime of Changenvarchar60
41TKAF_USER_APPD_MField Catalog for Customer Characteristics24CHTIMTime of Changenvarchar60
TOPInvestment Programs
42TAIFIM Drilldown: Characteristic Catalog51CHTIMTime of Changenvarchar60
TOPMaster Data
43BCA_US_HLD2RELHold Records which have not been released - Dual Control28CHTIMTime at Which Object was Last Changednvarchar60
44BCA_US_HOLDHold Amounts Which Affect Available Balance27CHTIMTime at Which Object was Last Changednvarchar60
TOPMaster data
45PACKKPPacking Object Header37CHTIMTime last change was madenvarchar60
TOPNetherlands
46P05EIR_MSG_STATElectronic Illness Reporting : Status (Obsolete)8CHTIMTimenvarchar60
TOPOrganizational Management
47HRMDRGINHR Master Data: Registry for Serialization in ALE Inbound8CHTIMTimenvarchar60
48HRMDRGOUTHR Master Data: Registry for Serialization in ALE Outbound8CHTIMTimenvarchar60
TOPPayment Item
49BKKITPayment Item96CHTIMTime at Which Object was Last Changednvarchar60
50BKKITAIInfo Items for Interest Penalty at Balancing29CHTIMTime at Which Object was Last Changednvarchar60
51BKKITENQBlocked Payment Items96CHTIMTime at Which Object was Last Changednvarchar60
52BKKITRELPayment Item96CHTIMTime at Which Object was Last Changednvarchar60
53BKKITTMPPlanned Payment Items97CHTIMTime at Which Object was Last Changednvarchar60
54BKKITTMP_DELPlanned Payment Items - Completed97CHTIMTime at Which Object was Last Changednvarchar60
TOPPayment Order
55BKKPOHDPayment Order, Header Data35CHTIMTime at Which Object was Last Changednvarchar60
56BKKPOHD_TMPPlanned Payment Order, Header Data36CHTIMTime at Which Object was Last Changednvarchar60
57BKKPOHD_TMP_DELPlanned Payment Order, Header Data36CHTIMTime at Which Object was Last Changednvarchar60
TOPProfitability Analysis
58TJBFField Catalog IS-B-PA50CHTIMTime of Changenvarchar60
59TJBSBase Field Catalog IS-B-PA (Fixed Fields)50CHTIMTime of Changenvarchar60
60TKEFCO-PA field catalog50CHTIMTime of Changenvarchar60
61TKESCO-PA Basis Field Catalog (fixed fields)50CHTIMTime of Changenvarchar60
TOPProgress Tracking
62TSTNTExpediting Status Information13CHTIMTimenvarchar60
TOPReal Estate Management
63BPOBIMMOBusiness Partner - Object Relationship: Real Estate29CHTIMTime at which object was last changednvarchar60
TOPRecycling Administration Core Functions
64J_7LSADRAddress Management: Company Data45CHTIMAddresses: Changed atnvarchar60
TOPRisk Analysis
65JBRRMTKEFRM: Copy of CO-PA Field Catalog50CHTIMTime of Changenvarchar60
66JBRRMTKESRM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures50CHTIMTime of Changenvarchar60
TOPStakeholder Relationship Management
67USC_CONTACTSRM Contact: Central Storage of Contacts19CHTIMTime at which object was last changednvarchar60
68USC_CONT_DOCSRM Contact: Documents13CHTIMTime at which object was last changednvarchar60
69USC_CONT_KWDSRM Contact: Keywords10CHTIMTime at which object was last changednvarchar60
70USC_CONT_RELSRM Contact: Related Contacts10CHTIMTime at which object was last changednvarchar60
71USC_CONT_STHSRM Contact: Stakeholders16CHTIMTime at which object was last changednvarchar60
72USS_STAKEHOLDERSEM-SRM: Specific Master Data of Stakeholder14CHTIMTime at which object was last changednvarchar60
73USS_STH_COVERSEM-SRM: Relationship Stakeholder and Coverage10CHTIMTime at which object was last changednvarchar60
74USS_STH_EXPECTSEM-SRM: Expectations of Stakeholders20CHTIMTime at which object was last changednvarchar60
75USS_STH_INFLSEM-SRM: Influence of Stakeholders15CHTIMTime at which object was last changednvarchar60
76USS_STH_SHARESEM-SRM: Shares of Stakeholders14CHTIMTime at which object was last changednvarchar60
77USS_STH_STH_GRPSEM-SRM: Group of Stakeholders13CHTIMTime at which object was last changednvarchar60
TOPTreasury
78TTMRFField catalog for Risk Management50CHTIMTime of Changenvarchar60
79TTMRSBasis field catalog Risk Management (fixed fields)50CHTIMTime of Changenvarchar60
TOPUse AP-MD-BP Components
80BUT000BP: General data I81CHTIMTime at which object was last changednvarchar60
81BUT000_TDBP: General Data I, Shadow Table Time Dependency82CHTIMTime at which object was last changednvarchar60
82BUT000_TDSBP: General Data I, Shadow Table Time Dependency83CHTIMTime at which object was last changednvarchar60
83BUT050BP relationships/role definitions: General data17CHTIMTime at which object was last changednvarchar60
84BUT050SBP Relationships/Role Definitions: General Data18CHTIMTime at which object was last changednvarchar60
TOPUse Subcomponents
85SOFDSAPoffice: Object Definition21CHTIMTime of Last Changenvarchar60
86SOODSAPoffice: Object definition24CHTIMTime of Last Changenvarchar60
87SORFSAPoffice: Replication Table21CHTIMTime of Last Changenvarchar60
88SOUDSAPoffice: user definition16CHTIMTime of Last Changenvarchar60