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

64 columns | Print definition?ERP 6.0  | ITEMTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_STG_POTable: Staging data - Purchase Orders & Deliveries for ICC7ITEMTYPEItem Typenvarchar10
2/OPT/VIM_STG_POITable: PO Item staging data for Download Infrastructure5ITEMTYPEItem Typenvarchar10
3BKKI6Totals Records from Payment Transactions10ITEMTYPEType of Payment Itemnvarchar20
4TE2608IS-U Invg: Integr. CI - Assignment Line Item Type/Item Type2ITEMTYPEType of Invoicing Itemnvarchar80
TOPBank Customer Accounts
5BKKCORRITEMAuxiliary Table: Payment Items for Adjustments45ITEMTYPEType of Payment Itemnvarchar20
TOPBilling in Contract Accounts Receivable and Payable
6TFK8102BAssign Item Types to Subprocesses4ITEMTYPEType of Billing Itemnvarchar80
TOPClaims Management
7ICLITEMClaim Item10ITEMTYPEClaim Item Object Typenvarchar30
8ICSITEMClaim Item10ITEMTYPEClaim Item Object Typenvarchar30
9TICL076Internal Claim Type: Permitted Object Type7ITEMTYPEClaim Item Object Typenvarchar30
10TICL164Benefit Type Tree: Permitted Object Type6ITEMTYPEClaim Item Object Typenvarchar30
TOPClinical System
11N2GL_ITEMPathways: Item of Treatment Pathway8ITEMTYPEItem Typenvarchar20
12N2GL_TM_STEPpathways Step of Patient Pathway17ITEMTYPEItem Typenvarchar20
13N2VDITEMSIS-H*MED PD: Typed Entries (Cluster)6ITEMTYPEPD: Item Typenvarchar30
TOPCross-System Tools
14CMPOBJCustomizing Comparison: Object Description5ITEMTYPEObject typenvarchar10
TOPEmployee Interaction Center
15THREIC_IBCATEIC Inbox Categories2ITEMTYPEItem Type for EIC Inboxnvarchar120
16THREIC_IBPRIOMAPEIC Assignment: Item Type Priority to Inbox Item Priority2ITEMTYPEItem Type for EIC Inboxnvarchar120
17THREIC_IBSTATMAPEIC Assignment: Item Type Status to Inbox Item Status2ITEMTYPEItem Type for EIC Inboxnvarchar120
TOPEnd User Technology
18RSZTREESTRUCTURETable with Example Description of a Tree Structure4ITEMTYPEItem typenvarchar10
19RSZWMDITEMBW Web Metadata: Template Item ( Dataprovider, Item, ... ).6ITEMTYPEBW Metadata: Item Typenvarchar20
20RSZWOBJXREFStructure of the BW Objects in a Template5ITEMTYPEType of an Itemnvarchar20
TOPInvoicing in Contract Accounts Receivable and Payable
21DFKKINVBILL_IBilling Document Items5ITEMTYPEType of Billing Itemnvarchar80
22DFKKINVDOC_IItems of Invoicing Document4ITEMTYPEType of Invoicing Itemnvarchar80
23TFK2608Invoicing Item Types2ITEMTYPEType of Invoicing Itemnvarchar80
24TFK2608TInvoicing Item Types3ITEMTYPEType of Invoicing Itemnvarchar80
25TFK2617Charges/Discounts9ITEMTYPEType of Invoicing Itemnvarchar80
TOPJoint Venture und Production Sharing Accounting
26T8J0GBilling Method Posting Rule Detail5ITEMTYPEJV Function itemnvarchar20
27T8J0JJV Function Items3ITEMTYPEJV Function itemnvarchar20
28T8J0KJV Function Items Text4ITEMTYPEJV Function itemnvarchar20
29T8JDQJV EDI Inbound: Account Transaction Mapping Table5ITEMTYPEJV Function itemnvarchar20
30T8JDRJV EDI Inbound: 819 Account Transaction Mapping (Class)6ITEMTYPEJV Function itemnvarchar20
31T8JDSJV EDI Inbound: 819 Account Transaction Mapping (Class+Subc)7ITEMTYPEJV Function itemnvarchar20
32T8JDVJV EDI Inbound: 810 Account Transaction Mapping (Serv.Code)6ITEMTYPEJV Function itemnvarchar20
33T8JHLConfiguration for JV AM/MM Transfers14ITEMTYPEJV Function itemnvarchar20
TOPLoans Management
34LOANREF_ORecords of Loan Reference Unit for Open Items12ITEMTYPEObject type of loan unitnvarchar10
35LOANREF_OSSaved Ref. Records Open Items per Business Operation No.12ITEMTYPEObject type of loan unitnvarchar10
TOPMarketing, Accounting and Pricing
36OIC_FO_ITM_MIGRFormula Structure Pattern - Term Item Pattern6ITEMTYPEFormula term typenvarchar10
TOPPayment Item
37BKKI5Totals Records from Payment Transactions5ITEMTYPEType of Payment Itemnvarchar20
38BKKITPayment Item45ITEMTYPEType of Payment Itemnvarchar20
39BKKITENQBlocked Payment Items45ITEMTYPEType of Payment Itemnvarchar20
40BKKITPREParked Payment Items7ITEMTYPEType of Payment Itemnvarchar20
41BKKITRELPayment Item45ITEMTYPEType of Payment Itemnvarchar20
42BKKITTMPPlanned Payment Items46ITEMTYPEType of Payment Itemnvarchar20
43BKKITTMP_DELPlanned Payment Items - Completed46ITEMTYPEType of Payment Itemnvarchar20
44BKKPAYMIN_ITTable of Imported Items36ITEMTYPEType of Payment Itemnvarchar20
45TBKKG3_TERMTransaction Type Customizing for Term Objects4ITEMTYPEType of Payment Itemnvarchar20
TOPPerformance Assessment Workbench
46SLS_PRESPAW - Person Results Structure37ITEMTYPEPAW - Item Type Namenvarchar240
TOPPeriodical Sales and Distribution
47TJI15IS-M/SD: Basic Audit Report Category Default - Per.SD ABC3ITEMTYPEInternal Item Type for Sales Ordernvarchar20
TOPPlanning
48RSISISVITServices: Texts for Subobjects of the Services4ITEMTYPEService: Element Typenvarchar50
TOPRental Accounting
49VIRADOCITEMRE Document Item6ITEMTYPEItem Categorynvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
50N2BASEITEMBase Items: Base Item6ITEMTYPEBase Items: Base Item Typenvarchar100
51N2BIGROUPABase Items: Base Item Groups Assignment2ITEMTYPEBase Items: Base Item Typenvarchar100
52TN2BIACTBase Items: Base Item Type Actions1ITEMTYPEBase Items: Base Item Typenvarchar100
53TN2BIACTTBase Items: Base Item Type Actions Texts1ITEMTYPEBase Items: Base Item Typenvarchar100
54TN2BIGROUPBase Items: Base Item - Groups3ITEMTYPEBase Items: Base Item Typenvarchar100
55TN2BIPROPSBase Items: Base Item Type - Supported Functions1ITEMTYPEBase Items: Base Item Typenvarchar100
56TN2BITYPBase Items: Base Item Types1ITEMTYPEBase Items: Base Item Typenvarchar100
57TN2BITYPEFBase Items: Base Item Types - Filter Values1ITEMTYPEBase Items: Base Item Typenvarchar100
58TN2BITYPEFTBase Items: Base Item Types - Filter Values, Texts1ITEMTYPEBase Items: Base Item Typenvarchar100
59TN2BITYPTBase Items: Base Item Types - Texts1ITEMTYPEBase Items: Base Item Typenvarchar100
60TN2BITYPUSEBase Items: Base Item Type Application Area1ITEMTYPEBase Items: Base Item Typenvarchar100
TOPService Station Retailing
61OIRESETT_ITEMPayment Cards: Settlement Run Log4ITEMTYPEDocument type of reference documentnvarchar10
TOPTraining Management
62LSOTACITEMobsolete in LSO200: Item6ITEMTYPEItem Typenvarchar20
63LSOTACITEM200Item and Item Attributes4ITEMTYPEItem Typenvarchar20
64LSOTACLRNITRESPerformance of Assessment - Item Results7ITEMTYPEItem Typenvarchar20