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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

33 columns | Print definition?ERP 6.0  | POS_MAN_PROC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TRLC_DFT_ASSGN_PAssignment: Update Types for P/L due to payment4POS_MAN_PROCPosition Management Procedurenvarchar40
TOPBack Office
2TRLC_PMC_TRADINGAssignment of Pos. Mgmt Procedures for Trading Positions2POS_MAN_PROCPosition Management Procedurenvarchar40
TOPTransaction Manager
3IDCFM_FRAM_DICRIAssignment of Alternative Position Management Procedure11POS_MAN_PROCPosition Management Procedurenvarchar40
4IDCFM_FRCR_DFT_BAssignment: Update Types to Position Change Category B2POS_MAN_PROCPosition Management Procedurenvarchar40
5IDCFM_FRIM_DATAImpairment Main Data110POS_MAN_PROCPosition Management Procedurenvarchar40
6TRDTT_POS_SECPosition Information for Securities11POS_MAN_PROCPosition Management Procedurenvarchar40
7TRGC_MIG_PMP_OTCConversion: Assignment of OTC Position Management Procedures6POS_MAN_PROCPosition Management Procedurenvarchar40
8TRGC_PM_PROCTreasury: Position Management Procedure2POS_MAN_PROCPosition Management Procedurenvarchar40
9TRGC_PM_PROC_ASSAssignment of Position Management Procedure11POS_MAN_PROCPosition Management Procedurenvarchar40
10TRGC_PM_PROC_TTreasury: Position Management Procedure Texts2POS_MAN_PROCPosition Management Procedurenvarchar40
11TRGT_MIGR_PMPConversion: Assign to Parallel Position Mangmnt Procedures8POS_MAN_PROCPosition Management Procedurenvarchar40
12TRLIC_ADTR: Customizing: Accrual/Deferral7POS_MAN_PROCPosition Management Procedurenvarchar40
13TRLIC_AD_EX1TR: Accrual/Deferral: Further Update Types7POS_MAN_PROCPosition Management Procedurenvarchar40
14TRLIC_AD_HEADCustomizing Accrual/Deferral: Differentiation7POS_MAN_PROCPosition Management Procedurenvarchar40
TOPTransfer to Financial Accounting
15TLVC_DFT_ASSGNAssign Update Types for Valuation2POS_MAN_PROCPosition Management Procedurenvarchar40
16TRILC_DFT_ASSGNAssignment of Update Types for Hedge Accounting2POS_MAN_PROCPosition Management Procedurenvarchar40
17TRLC_DFT_ASSGN_AAssignment: Update Types to Position Change Category A2POS_MAN_PROCPosition Management Procedurenvarchar40
18TRLC_DFT_ASSGN_BAssignment: Update Types to Position Change Category B2POS_MAN_PROCPosition Management Procedurenvarchar40
19TRLC_DFT_ASSGN_CAssignment: Update Types to Position Change Category C2POS_MAN_PROCPosition Management Procedurenvarchar40
20TRLC_DFT_ASSGN_DAssignment: Update Types to Position Change Category D2POS_MAN_PROCPosition Management Procedurenvarchar40
21TRLC_DFT_ASSGN_EAssignment: Update Types to Position Change Category E2POS_MAN_PROCPosition Management Procedurenvarchar40
22TRLC_DFT_ASSGN_FAssignment: Update Types to Position Change Category F2POS_MAN_PROCPosition Management Procedurenvarchar40
23TRLC_DFT_ASSGN_GAssignment: Update Types to Position Change Category G2POS_MAN_PROCPosition Management Procedurenvarchar40
24TRLC_DFT_ASSGN_HAssignment: Update Types to Position Man. Procedure Cat. H2POS_MAN_PROCPosition Management Procedurenvarchar40
25TRLC_DFT_ASSGN_JAssign Update Types to Position Management Category J2POS_MAN_PROCPosition Management Procedurenvarchar40
26TRLC_DFT_ASSGN_KAssignment: Update Types for Position Change Category K2POS_MAN_PROCPosition Management Procedurenvarchar40
27TRLC_DFT_ASSGN_LAssignment: Update Types for Position Change Category L2POS_MAN_PROCPosition Management Procedurenvarchar40
28TRLC_DFT_ASSGN_MAssignment: Update Types for Position Change Category M2POS_MAN_PROCPosition Management Procedurenvarchar40
29TRLC_DFT_ASSGN_VAssignment: Update Types to Position Management Category V2POS_MAN_PROCPosition Management Procedurenvarchar40
30TRLT_BACKUPVORABBackup Flow Table from Preliminary Solution - Pos. Mgmt Sol.34POS_MAN_PROCPosition Management Procedurenvarchar40
31TRLT_DERIVFLOWSTreasury: Flows for Derived Business Transactions7POS_MAN_PROCPosition Management Procedurenvarchar40
32TRLT_POSITIONTreasury Ledger Position3POS_MAN_PROCPosition Management Procedurenvarchar40
33TRL_C_FT_REPLACEReplacement of Update Types2POS_MAN_PROCPosition Management Procedurenvarchar40