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

54 columns | Print definition?ERP 6.0  | TEXT50

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CEERE/KOSVOBSIMTax exemption codes from Ministry of Finance web8TEXT50Description of Tax Exemptionnvarchar500
2DVKTXR/2-R/3 Link: Delivery texts R2 -> R357TEXT50Text R/2-R/3 Linknvarchar720
3FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields57TEXT50Item Textnvarchar500
TOPBasic Functions
4UKM_LIMIT_RULE0TSAP Credit Mgt: Rule for Calc. Score and Cr. Limit (Texts)4TEXT50Text Fieldnvarchar500
TOPBilling
5J_1ATXRELTTexts for tax relevant classification4TEXT50Text Fieldnvarchar500
TOPBudgeting
6FMBHFunds management budget header (entry documents)16TEXT50Header Text for Budget Entry Documentnvarchar500
7FMBLFunds management budget document lines (entry documents)57TEXT50Item Textnvarchar500
8FMHBHFunds management budget header (held documents)13TEXT50Header Text for Budget Entry Documentnvarchar500
9FMHBLFunds management budget document lines (held documents)57TEXT50Item Textnvarchar500
10FMLATTexts for Layout Variants4TEXT50Text Fieldnvarchar500
11FMPEP_VARIANTHSession variants (header part) for transaction FMPEP13TEXT50Header Text for Budget Entry Documentnvarchar500
12FMPEP_VARIANTLSession variants (line part) for transaction FMPEP23TEXT50Item Textnvarchar500
13FMSTATDEFTTexts for Budgeting Status6TEXT50Status long text (50)nvarchar500
TOPClient Copy
14CCCINFOClient Copy Control: Info on Table CCCEXIT Entries6TEXT50Text Fieldnvarchar500
15CCOPTTClient Copy Option Texts3TEXT50Text Fieldnvarchar500
16CCPROFTClient Copy Profile Texts3TEXT50Text Fieldnvarchar500
TOPContract Accounts Receivable and Payable
17TE097ATAccount Determ. IDs - Texts4TEXT50Text Fieldnvarchar500
18TFK001STTexts for reasons for processing block4TEXT50Text Fieldnvarchar500
19TFK007FKTTax Item Categories for Other Tax Code6TEXT50Text Fieldnvarchar500
20TFK020BShort Account Assignments for Transfer Postings to Cash Desk9TEXT50Text Fieldnvarchar500
21TFK020CShort Acct Assignments for Write-Offs from Clarif. Worklist9TEXT50Text Fieldnvarchar500
22TFK020KShort Account Assignments for Transfer Postings11TEXT50Text Fieldnvarchar500
23TFKBWD01TText Table for TFKBWD3TEXT50Text Fieldnvarchar500
24TFKBWDTText Table for TFKBWD4TEXT50Text Fieldnvarchar500
25TFKBWT01DTFICA to BW - Intervals4TEXT50Text Fieldnvarchar500
26TFKK_CORRM_TMPLTText table for correspondence template definition4TEXT50Text Fieldnvarchar500
27TFKOPBWDTText Table for TFKOPBWD3TEXT50Text Fieldnvarchar500
TOPContract Billing
28ISU_CAUSESTCheck Table of Error Causes (Texts)4TEXT50Text Fieldnvarchar500
29ISU_SOLUTIONSTCheck Table of Solutions (Text)4TEXT50Text Fieldnvarchar500
30TE301TBackbilling Groups (Texts)4TEXT50Text Fieldnvarchar500
31TE543TTime slice generator4TEXT50Text Fieldnvarchar500
32TE659TDynamic backbilling groups4TEXT50Text Fieldnvarchar500
33TE661TReasons for proration (texts)4TEXT50Text Fieldnvarchar500
TOPFunds Management-Specific Postings
34PSO15Area (Texts)4TEXT50Text Fieldnvarchar500
35PSO17Use (Texts)4TEXT50Text Fieldnvarchar500
36PSO20Text Table PSO194TEXT50Text Fieldnvarchar500
37PSO30Object class (texts)4TEXT50Text Fieldnvarchar500
TOPGeneric Contract Accounts Receivable and Payable
38TFSC01TAccount Determination ID Texts4TEXT50Text Fieldnvarchar500
39TFSCKTOKLTAccount Class Texts4TEXT50Text Fieldnvarchar500
TOPLocalization
40J_3RKAIDActivate Automatic Offsetting Account Determination5TEXT50Text Fieldnvarchar500
TOPMaster Data
41TE097TAccount Determ. IDs - Texts6TEXT50Text Fieldnvarchar500
42TE643TProcessing Status Texts4TEXT50Text Fieldnvarchar500
43TECAMIOVARASTIS-U: Permitted Contract Models (Text Table)5TEXT50Text Fieldnvarchar500
TOPMove-InOut
44TE960TText for table TE90: reasons for contract change4TEXT50Text Fieldnvarchar500
45TE970ATText for Processing Variants for Move-In/Out (te970a)4TEXT50Text Fieldnvarchar500
46TE990TReason for customer change4TEXT50Text Fieldnvarchar500
47TECAMIOVARAMTIS-U: Permitted Master Data Templates (Text Tables)6TEXT50Text Fieldnvarchar500
48TECAMIOVARAPTIS-U: Permitted Contract Models (Text Table)6TEXT50Text Fieldnvarchar500
49TECAMIOVARTIS-U: Pre-entry Variants (Text Table)4TEXT50Text Fieldnvarchar500
TOPReal Estate Localization Czech Republic
50/CEERE/KOSVOB_MFTax exemption codes from Ministry of Finance web8TEXT50Description of Tax Exemptionnvarchar500
TOPSingle Transaction Costing
51JBTVERTCosting Procedure Texts3TEXT50Text Fieldnvarchar500
TOPStatistics
52TE789TTexts for Transaction Statistics Categs3TEXT50Text Fieldnvarchar500
53TE790TTexts for Transaction Statistics Categs3TEXT50Text Fieldnvarchar500
TOPTransaction Manager
54THMEXT_TRANSE-HA: Transactions5TEXT50Description of the Exposure Transactionnvarchar500