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

35 columns | Print definition?ERP 6.0  | DATBIS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FMPEP_ADM_SVSession Variants administration7DATBISValid to datenvarchar80
2TIV21Building age classes5DATBISValid to datenvarchar80
TOPAdvertising Management
3JJTPRDH_PRFAGIS-M/AM Prd.Hier.(S&P): Product/External Agency Assignment8DATBISEnd Datenvarchar80
4JJTPRDH_PRODIS-M/AM: Products (S&P Product Hierarchy)6DATBISEnd Datenvarchar80
5JJTPRDH_VKTABIS-M/AM Product Hierarchy (S&P): Link Table9DATBISEnd Datenvarchar80
TOPConstruction Equipment Management
6J_3GSTLAKTActivation File/Buffer for BOMs5DATBISValid To Datenvarchar80
7J_3GSTLPOSItem Data for Equipment BOMs15DATBISValid To Datenvarchar80
TOPFunds Management
8CTRUNICLASis being deleted4DATBISValid To Datenvarchar80
9FM01Financial Management Areas20DATBISFM: Valid to datenvarchar80
10FMAPSTATFIFM: System Status for FIFM Acct Asst Objects8DATBISFM: Valid to datenvarchar80
11FMBUDGETPDFM: Budget Period Master Data4DATBISFM: Budget Period Valid To datenvarchar80
12FMCICommitment items master data37DATBISFM: Valid to datenvarchar80
13FMDECKHKCAssignment of FM Account Assignment to Cover Pool9DATBISNumber that clearly identifies the line key in databasenvarchar160
14FMEINDECKCAssign FM Acct Assgt Requir.Cover to One Authoriz.to Give It12DATBISNumber that clearly identifies the line key in databasenvarchar160
15FMFCTRFunds Center Master Record4DATBISFM: Valid to datenvarchar80
16FMFCTRTFunds Center Text5DATBISFM: Valid to datenvarchar80
17FMFINCODEFIFM: Financing code14DATBISFM: Valid to datenvarchar80
18FMFPOFIFM: Commitment Item4DATBISFM: Valid to datenvarchar80
19FMFPOTTexts for a Financia Management Item5DATBISFM: Valid to datenvarchar80
20FMFUSEFIFM: Application of Funds from Secondary Sources5DATBISFM: Valid to datenvarchar80
21FMSNRULECChange Documents for Collective Budget Rules8DATBISNumber that clearly identifies the line key in databasenvarchar160
22FMUDPOOLCAssignment of Cover Pool to Rev. Increasing FM Acct Assgmt9DATBISNumber that clearly identifies the line key in databasenvarchar160
23FMUDRELCAssignment of Expenditure Objs.to Revenue Objs Incr.Budget13DATBISNumber that clearly identifies the line key in databasenvarchar160
24FMUDRULECRules for Revenues Increasing the Budget8DATBISNumber that clearly identifies the line key in databasenvarchar160
TOPOverhead Cost Controlling
25TFKBFunctional areas15DATBISFM: Valid to datenvarchar80
TOPPendulum List Indirect Sales
26/BEV4/PLDANFABHSales Request History10DATBISValid-To Datenvarchar80
27/BEV4/PLDANFABSSales Request - Header9DATBISValid-To Datenvarchar80
TOPReal Estate Management
28VIOB37Relationship between real estate objects and SAP-FI-AA8DATBISDate up to when the assignment is validnvarchar80
29VIOBOVAssignment Table for Real Estate to Standard Objects5DATBISDate up to when the assignment is validnvarchar80
TOPRegulatory reporting for insurance companies
30VBUSTINTERIntervall BUST-Meldung6DATBISDatum gültig bisnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
31TNAKRF1IS-H: KRARAF Data Carrier, Function Codes/Dept5DATBISValid to datenvarchar80
32TNWCH94LCFees: Assignment of Breakdown Code to Limit Level6DATBISIS-H: Valid-To Date of Recordnvarchar80
33TNWCH94LDFees: Validity of Limitation5DATBISIS-H: Valid-To Date of Recordnvarchar80
34TNWCH98SFees: Limit Levels for Breakdown Codes6DATBISIS-H: Valid-To Date of Recordnvarchar80
35TNWCHHONPOS98SFee Item Data for Codes - Limit Levels7DATBISIS-H: Valid-To Date of Recordnvarchar80