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

55 columns | Print definition?ERP 6.0  | TRANSACTION_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/ACCOUNTTYPEaccount's type SAP forTax authority uniform reporting5TRANSACTION_TYPEtransaction type for uniform files-field 1258 in the filenvarchar150
2/SAPPSSRM/LPNEXCTransaction Types excluded from LPN2TRANSACTION_TYPEProcess Typenvarchar40
3CIAP_C_ACCOUNTDefine CIAP related financial account information3TRANSACTION_TYPEAsset Transaction Typenvarchar30
4EPIC_EBOE_HISTTable of EBoE History13TRANSACTION_TYPEnvarchar300
5TLRC_THM_PROD_IGAssign Products to Instrument Groups5TRANSACTION_TYPEFinancial Transaction Typenvarchar30
6TLRT_RISKM_DERDerivation for Risk Mitigation Indicator5TRANSACTION_TYPEFinancial Transaction Typenvarchar30
7TREAT_CLEAR_ASGTreasury: Central Clearing Assignement4TRANSACTION_TYPEFinancial Transaction Typenvarchar30
8TRGC_FICLASS_PTClassification of Product and Transaction Types4TRANSACTION_TYPEFinancial Transaction Typenvarchar30
9/BOBF/D_CC_LOG_HBOPF Contract Compliance Check Log header22TRANSACTION_TYPEcorresponds to APESICC_TRANSACTION_TYPEnvarchar40
TOPBack Office
10TRSC_LEND_TRANSUpdate Types for Securities Account Transfer for Sec.Lending3TRANSACTION_TYPEFinancial Transaction Typenvarchar30
TOPBank Customer Accounts
11TBKKIHB7Assignment BTC <-> Posting Category IHC2TRANSACTION_TYPETransaction typenvarchar80
TOPCross-Application Components
12/MRSS/C_APP_NOTETime Constraint2TRANSACTION_TYPEBusiness Transaction Typenvarchar40
13/MRSS/C_PREF_TECPreferred technician partner function for second visit2TRANSACTION_TYPEType of underlying order or operationnvarchar40
14/MRSS/C_SPAREPRTMaintain the Item Category for Spare Part2TRANSACTION_TYPEBusiness Transaction Typenvarchar40
TOPFinancial Accounting
15BWPOSIValuations for Open Items20TRANSACTION_TYPETransaction Type Follow-On Actionnvarchar30
TOPFSCM In-House Cash
16IHC_TAB_DUAL_CTRIHC: Principle of Dual Control5TRANSACTION_TYPETransaction Typenvarchar60
17IHC_TAB_DUCTR_BPTO BE DELETED --- IHC: Principle of Dual Control4TRANSACTION_TYPETransaction Typenvarchar60
18IHC_TAB_GUI_FLDIHC: Container Field in GUI3TRANSACTION_TYPETransaction Typenvarchar60
19IHC_TAB_GUI_TRNSIHC: Transaction Type - Default Setting for Transactions4TRANSACTION_TYPETransaction Typenvarchar60
20IHC_TAB_TRANSIHC: Transaction Types2TRANSACTION_TYPETransaction Typenvarchar60
21IHC_TAB_TRANSTIHC: Transaction Type Names2TRANSACTION_TYPETransaction Typenvarchar60
22IHC_TAB_TRN_ATTRIHC: Processing of Transaction Types in Bank Area3TRANSACTION_TYPETransaction Typenvarchar60
23IHC_TAB_XBS_TTIHC: Transaction Type External Inbound Payment3TRANSACTION_TYPETransaction typenvarchar80
TOPLocalization
24MXTVOMexico:Customizing table: Transaction, Version, Order2TRANSACTION_TYPETransaction Typenvarchar20
TOPMaintenance Orders
25/MRSS/C_APP_HOLDStatus Customizing for Remote Service Area2TRANSACTION_TYPEType of underlying order or operationnvarchar40
TOPManagement of Internal Controls
26HRP1819DB Table for Infotype 181918TRANSACTION_TYPETransaction Type IDnvarchar100
TOPProcess Controls
27HRP5319DB Table for Infotype 531918TRANSACTION_TYPETransaction Type IDnvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
28DFMCA_RETURNData Table for Tax Returns51TRANSACTION_TYPETransaction Type for Tax Processingnvarchar80
29DFMCA_RETURN_OData Table for Tax Returns54TRANSACTION_TYPETransaction Type for Tax Processingnvarchar80
30TFMCA_FPF_FBTTRATransaction type for form bundles3TRANSACTION_TYPETransaction Type for Tax Processingnvarchar80
31TFMCA_FPF_TRANTTransaction Type2TRANSACTION_TYPETransaction Type for Tax Processingnvarchar80
32TFMCA_FPF_TRANTTText of Transaction Types3TRANSACTION_TYPETransaction Type for Tax Processingnvarchar80
33TFMCA_TRANSTYPESTransaction Type for Tax Processing3TRANSACTION_TYPETransaction Type for Tax Processingnvarchar80
34TFMCA_TRANSTYPETCustomizing Table for Texts for Transaction Types3TRANSACTION_TYPETransaction Type for Tax Processingnvarchar80
TOPTraders and Schedulers Workbench
35OIJRELCRITERIATo define criteria for relevancy types5TRANSACTION_TYPETransaction Typenvarchar50
TOPTransaction Manager
36ATDEALDFTUpdate Types for Position Update3TRANSACTION_TYPEFinancial Transaction Typenvarchar30
37IDCFMBRSE_PSTCustomizing for creation of sales transactions for tax pmnts11TRANSACTION_TYPEFinancial Transaction Typenvarchar30
38IDCFM_FRAM_DICRIAssignment of Alternative Position Management Procedure7TRANSACTION_TYPEFinancial Transaction Typenvarchar30
39SLDT_FLOWSubledger Distributor Transactions11TRANSACTION_TYPEFinancial Transaction Typenvarchar30
40TCORC_ALOWED_BPG(Obsolete)Allowed BP Groups for Deal Corr.activities5TRANSACTION_TYPEFinancial Transaction Typenvarchar30
41TCORC_DEAL_ACTVTCorrespondence Deal's activity assignment5TRANSACTION_TYPEFinancial Transaction Typenvarchar30
42TCORT_CODMDDeal: Main Data21TRANSACTION_TYPEFinancial Transaction Typenvarchar30
43TCORT_CODULDeal: Underlying10TRANSACTION_TYPEUnderlying Transaction Typenvarchar30
44TCORT_CODUL2Deal: 2nd Underlying11TRANSACTION_TYPEUnderlying Transaction Typenvarchar30
45TCORT_EXT_ASSIGNAssignments of Profiles & BP groups to external recipients9TRANSACTION_TYPEFinancial Transaction Typenvarchar30
46TCORT_INB_ASSIGNBP group assignment for Inbound Correspondence7TRANSACTION_TYPEFinancial Transaction Typenvarchar30
47TCORT_INT_ASSIGNAssignments of Profiles & BP groups to internal recipients9TRANSACTION_TYPEFinancial Transaction Typenvarchar30
48TRDT_FLOWPersistent distributor flows9TRANSACTION_TYPEFinancial Transaction Typenvarchar30
49TRGC_CVC1Assignment of Product Cat. and Trans. Cat. to GVC Group4TRANSACTION_TYPEFinancial Transaction Typenvarchar30
50TRGC_PM_PROC_ASSAssignment of Position Management Procedure7TRANSACTION_TYPEFinancial Transaction Typenvarchar30
51TRQT_FLOWTreasury: Flow Data Quantity Ledger6TRANSACTION_TYPEFinancial Transaction Typenvarchar30
52TRTFC_DFTASSUpdate Types for Transfer Posting3TRANSACTION_TYPEFinancial Transaction Typenvarchar30
TOPTreasury and Risk Management
53TREAC_CLEAR_OPTTreasury: Cent.Clearing Option per Comp.Code/Prod.Tp/TransTp4TRANSACTION_TYPEFinancial Transaction Typenvarchar30
54ZTR_EXPOTRANCONFMaintain attributes for Exposure creation/change events11TRANSACTION_TYPEFinancial Transaction Typenvarchar30
TOPWorkforce Management Core
55WFDSD_DEMANDWork Force Deployment Demand14TRANSACTION_TYPEBusiness Transaction Typenvarchar40