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

32 columns | Print definition?ERP 6.0  | XMBEZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TDO6TText table for land registry indicator5XMBEZDescription of land register typenvarchar300
2TDO7TText table for administration cost elements5XMBEZNormal name (30 characters)nvarchar300
3TDZWTIS-IS: Payment terms with adjustment days4XMBEZNormal name (30 characters)nvarchar300
4TIV0ARU Usage type ID's4XMBEZDescription of external usage type of rental unitnvarchar300
5TIV10Bus. entity location3XMBEZDescription of location of business entitynvarchar300
6TIV15Regional management - no longer used3XMBEZNormal name (30 characters)nvarchar300
7TIV16Maintenance district3XMBEZDescription of maintenance districtnvarchar300
8TIV22Representative list of rents location classes4XMBEZDescription of location class for rep.list of rentsnvarchar300
9TIV28Corporate group type - Table no longer used4XMBEZNormal name (30 characters)nvarchar300
10TIV30Tenant service in a company4XMBEZNormal name (30 characters)nvarchar300
11TIV5BCost elements text table TIV515XMBEZNormal name (30 characters)nvarchar300
12TIV5DAccountancy firms fuel types - Texts5XMBEZNormal name (30 characters)nvarchar300
13TIV5ETexts for fuel types (Darwin)4XMBEZNormal name (30 characters)nvarchar300
14TIV5TClassification of real estate objects (Text for TIV5A)5XMBEZDescription of object typenvarchar300
15TIV6ANames of institutions supplying credit information5XMBEZNormal name (30 characters)nvarchar300
16TIV6BCredit standing of real estate applicant - Texts5XMBEZDescription of credit standing of applicationnvarchar300
17TZK0GTexts for condition type-dependent detailed description7XMBEZNormal name (30 characters)nvarchar300
TOPFlexible Real Estate Management
18TIVPRHSPTGitterpositionstexte5XMBEZNormal Bezeichnung (char 30)nvarchar300
19TIVPRHSVTGitterpositionstexte4XMBEZNormal Bezeichnung (char 30)nvarchar300
TOPLoans Management
20TD16TTexts for borrower's note loan securities5XMBEZNormal name (30 characters)nvarchar300
TOPReal Estate Management
21S407Rental agreements115XMBEZReason for rent reductionnvarchar300
22TIV1RLanguage table for security deposit types view5XMBEZDescription of type of rental collateralnvarchar300
23TIV2BLocation classes of representative list of rents - texts5XMBEZDescription of location class acc.to rep.list of rentsnvarchar300
24TIV2FText table for Real Estate Contract Type (table TIV26)4XMBEZDescription of type of RE contract typenvarchar300
25TIV2GText Table for Lease-Out Adjustment Type (TIV27)4XMBEZDescription of LO adjustment typenvarchar300
26TIV50Heating Costs / Heating Systems Settlement Company3XMBEZNorm.desc. of heating costs/heating systems accountancy firmnvarchar300
27TIVBCUsage type per development plan (texts)4XMBEZDescription of usage type according to development plannvarchar300
28TIVCAApplication: Processing indicator (text table)4XMBEZNormal name (30 characters)nvarchar300
29TIVCBApplication: Preselection indicator (text table)4XMBEZNormal name (30 characters)nvarchar300
30TIVCCApplication: Preselection indicator (text table)4XMBEZNormal name (30 characters)nvarchar300
31TIVCDUsage type acc. to area usage plan (text)4XMBEZDescription of usage type of property acc. to land use mapnvarchar600
32VIRPS407Rental agreements115XMBEZReason for rent reductionnvarchar300