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

72 columns | Print definition?ERP 6.0  | COMPCODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FTBB_YC_REF_ENTAttributes of Reference Entity4COMPCODECompany Code as Reference Entitynvarchar40
TOPCATT Computer Aided Test Tool
2CATCUCATT integration of external test tool6COMPCODEnvarchar20
TOPClaims Management
3ICLALAERESCurrent Reserves (Settlement Expenses (ALAE) and Losses)4COMPCODECompany Code for Reservesnvarchar40
4ICLCLAIMDATASuppl. Reserves: Claim File2COMPCODECompany Code for Reservesnvarchar40
5ICLCLAIMDATA_OUTSuppl. Res.: Reserving Results at Indicative Level3COMPCODECompany Code for Reservesnvarchar40
6ICLDRIVER1Example 1 for IBNR Driver Table2COMPCODECompany Code for Reservesnvarchar40
7ICLDRIVER2Example 2 for IBNR Driver Table2COMPCODECompany Code for Reservesnvarchar40
8ICLHISTDATASuppl. Reserves: History Data4COMPCODECompany Code for Reservesnvarchar40
9ICLIBNRQUARTIBNR: Reserves Table6COMPCODECompany Code for Reservesnvarchar40
10ICLINDRESIClaim-Independent Reserve6COMPCODECompany Code for Reservesnvarchar40
11ICLULAEACCRESAdditional Reserve Amounts at Claim Year and Coverage Level4COMPCODECompany Code for Reservesnvarchar40
12ICLULAECCCDERESSpecified CDE Reserves at Company Code Level4COMPCODECompany Code for Reservesnvarchar40
13ICLULAECFFACTORSpecified CDE Reserves at Company Code Level4COMPCODECompany Code for Reservesnvarchar40
14ICLULAECOVRESDetermined Additional Reserve Amounts at Coverage Level4COMPCODECompany Code for Reservesnvarchar40
15ICLULAEDRIVER1Reported Distribution Key 14COMPCODECompany Code for Reservesnvarchar40
16ICLULAEDRIVER2Reported Distribution Key 24COMPCODECompany Code for Reservesnvarchar40
17ICLULAEPERCENTDetermined Percentage and Additional Reserve Amounts4COMPCODECompany Code for Reservesnvarchar40
18ICLULAEREPPAYReported Settlement Expenses4COMPCODECompany Code for Reservesnvarchar40
19ICLULAERESCurrent Reassigned Reserves (ULAE)4COMPCODECompany Code for Reservesnvarchar40
20ICL_IBNR_RESULTIBNR Reserves19COMPCODECompany Code for Reservesnvarchar40
21TICL825Entity Table: Company Code2COMPCODECompany Code for Reservesnvarchar40
22TICL825TText Table: Suppl. Reserves Company Code3COMPCODECompany Code for Reservesnvarchar40
23TICL827CoCde/Ins.Line/RegOff/State: Permitted Combinations2COMPCODECompany Code for Reservesnvarchar40
24TICL832Entity Table: G/L Account (Chart of Accts and Coll.Account)3COMPCODECompany Code for Reservesnvarchar40
25TICL834CoCde/State/LineProd/Coverage: Permitted Combinations2COMPCODECompany Code for Reservesnvarchar40
26TICL848IBNR: Loss/Expense Percentages2COMPCODECompany Code for Reservesnvarchar40
27TICL849IBNR: Loss/Expense Percentages2COMPCODECompany Code for Reservesnvarchar40
28TICL850IBNR: Loss/Expense Percentage Rate2COMPCODECompany Code for Reservesnvarchar40
TOPCollectionsDisbursements
29IBROSTMCFClarif. Cases from Broker Report15COMPCODECompany Codenvarchar40
30IBROSTMHISCD: Broker Report - Header Data21COMPCODECompany Codenvarchar40
31IBROSTMPISCD: Broker Report - Item Data30COMPCODECompany Codenvarchar40
32IBROSTMSUMBroker Summary Postings - Restart Information7COMPCODECompany Codenvarchar40
33ITAGCYCDMODEMode Within Cash Desk6COMPCODESelection Company Code in Containernvarchar40
34ITAGCYCFCash Desk Carryforward9COMPCODECompany Codenvarchar40
35ITAGCYCLEARSUMItalian Agency Collections: Clearing Account Totals5COMPCODECompany Codenvarchar40
36ITAGCYCOLLTRTransfer Information8COMPCODECompany Codenvarchar40
37ITAGCYCOMMCLEARTriggerTab Commission to Subagent from Internal Agencies5COMPCODECompany Codenvarchar40
38ITAGCYCONTHHeader Data for Cash Desk Container31COMPCODESelection Company Code in Containernvarchar40
39ITAGCYINSCOMPSHAgency Collections: Shares to Be Transferred to Insurance7COMPCODECompany Codenvarchar40
40ITAGCYPAYPayment Information14COMPCODECompany Codenvarchar40
41ITAGCYSUBCOMMTRGTrigger Table for Posting and Transferring Subcommission7COMPCODECompany Codenvarchar40
42TKKVPYCORRCustomizing for Insufficient Deposit Coverage Correspondence2COMPCODECompany Code Groupnvarchar40
TOPIncentive and Commission Management ICM
43CACS00_DOCFI_HData Transfer: FI Documents (Header Data)4COMPCODECompany Codenvarchar40
44CACS00_DOCFI_PData Transfer: FI Documents (Items)5COMPCODECompany Codenvarchar40
45CACSFI_ACSFIAccount Assignment of Stt.Types for FI Settlement System5COMPCODECompany Codenvarchar40
46YCRM01_ACCASAccount Assignment Type/Cost Information for Remuneration10COMPCODECompany Codenvarchar40
47YCRM01_ACCSTAccount Assignment Type/Cost Info for Settlement Types12COMPCODECompany Codenvarchar40
48YCRM01_DOCFI_HData Transfer: FI Documents Header Data6COMPCODECompany Codenvarchar40
49YCRM01_DOCFI_PData Transfer: FI Documents Item7COMPCODECompany Codenvarchar40
50YHITEC_ACCASAccount Assignment Type/Cost Information for Remuneration5COMPCODECompany Codenvarchar40
51YHITEC_ACCSTAccount Assignment Type/Cost Info for Settlement Types5COMPCODECompany Codenvarchar40
52YHITEC_DOCFI_HData Transfer: FI Documents Header Data4COMPCODECompany Codenvarchar40
53YHITEC_DOCFI_PData Transfer: FI Documents Item5COMPCODECompany Codenvarchar40
54YSVMA_ACCASAccount Assignment Type/Cost Information for Remuneration13COMPCODECompany Codenvarchar40
55YSVMA_ACCSTAccount Assignment Type/Cost Info for Settlement Types8COMPCODECompany Codenvarchar40
56YSVMA_DOCFI_HData Transfer: FI Documents (Header Data)4COMPCODECompany Codenvarchar40
57YSVMA_DOCFI_PData Transfer: FI Documents (Items)5COMPCODECompany Codenvarchar40
58YTEL01_ACCASAccount Assignment Type/Cost Information for Remuneration16COMPCODECompany Codenvarchar40
59YTEL01_ACCSTAccount Assignment Type/Cost Info for Settlement Types10COMPCODECompany Codenvarchar40
60YTEL01_DOCFI_HData Transfer: FI Documents Header Data4COMPCODECompany Codenvarchar40
61YTEL01_DOCFI_PData Transfer: FI Documents Item5COMPCODECompany Codenvarchar40
62YTEL05_ACCASAccount Assignment Type/Cost Information for Remuneration9COMPCODECompany Codenvarchar40
63YTEL05_ACCSTAccount Assignment Type/Cost Info for Settlement Types12COMPCODECompany Codenvarchar40
64YTEL05_DOCFI_HData Transfer: FI Documents (Header Data)4COMPCODECompany Codenvarchar40
65YTEL05_DOCFI_PData Transfer: FI Documents (Items)5COMPCODECompany Codenvarchar40
66ZICMAG_ACCASAccount Assignment Type/Cost Information for Remuneration8COMPCODECompany Codenvarchar40
67ZICMAG_ACCSTAccount Assignment Type/Cost Info for Settlement Types8COMPCODECompany Codenvarchar40
68ZICMAG_DOCFI_HData Transfer: FI Documents (Header Data)4COMPCODECompany Codenvarchar40
69ZICMAG_DOCFI_PData Transfer: FI Documents (Items)5COMPCODECompany Codenvarchar40
TOPPosition Budgeting and Control
70T77HRFPM_CLOSINGSettings for Period Closing with Commitment Creation2COMPCODECompany Codenvarchar40
TOPThird Party Remittance
71T51RHHR payee derived link to FI vendor8COMPCODECompany Codenvarchar40
TOPTravel Expenses
72PTRV_CCCError Receipts for Credit Card Clearing31COMPCODECompany ID for Credit Card Clearingnvarchar100