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

30 columns | Print definition?ERP 6.0  | DEFLT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T7AE15Default in Country of Issue for Doc. Type It 01853DEFLTDefault Country Of Issue IT 0185nvarchar10
2T7QA09Default in Country of Issue for Documents Infotype 0185 (QA)3DEFLTQatar as Default Country Of Issuenvarchar10
3T7SA24Default in Country of Issue for Doc. Type It 01853DEFLTDefault Country Of Issue IT 0185nvarchar10
TOPBasic Data
4TNP00IS-H: Controlling the Customizing of Parameter Tables4DEFLTIS-H: Default value for parameter maintenancenvarchar100
TOPBenefits
5T5UBPBenefits investment/investment group assignment5DEFLTBenefit indicator default investment for savings plansnvarchar10
TOPBusiness Consolidation
6UCT4000Target Account Assignment: Characteristics6DEFLTUse Assignment as the Defaultnvarchar10
TOPCAD Integration
7TCIUCAD Field Parameters for Upload6DEFLTDefault value for CAD transfer fieldnvarchar700
TOPClinical System
8TN2BABKIS-H*MED: Reason Category for Treatment Contract4DEFLTDefault Valuenvarchar10
9TN2DTFORMATSCRFormat-Dependent Screen Configuration4DEFLTDefault Valuenvarchar10
TOPClosing Operations
10FBRC1110Contact Persons8DEFLTGeneral Indicatornvarchar10
TOPConsolidation
11TF011Generate Request Screen: Formating Instructions7DEFLTRequest screen: Default entrynvarchar80
12TF141Selected FS Items11DEFLTGeneral indicator, SAP Consolidationnvarchar10
13TF411Translation Methods: Entries for Subassignments10DEFLTUse assignment as the defaultnvarchar10
14TF515Journal Entry Layout: Field Names3DEFLTUse journal entry layout as defaultnvarchar10
TOPContract Accounts Receivable and Payable
15TFKBBOL_DEFLTBoleto: default instruction keys7DEFLTBoleto: Default Instruction Keynvarchar10
TOPFrance
16T77TNM_STTable Training Needs Status5DEFLTDefault Entry Checkboxnvarchar10
TOPFunds Management
17FMRESFIELDSControllable Fields Earmarked Funds4DEFLTIndicator for field status in funds reservationnvarchar10
TOPIncentive and Commission Management ICM
18TCACS_WFMGCSMessage Group in Commission Case Processing10DEFLTFlag: Defaultnvarchar10
TOPPersonnel Administration
19T752BDefault Values for the SAP-Resumix Interface3DEFLTDefault Values for the SAP-Resumix Interfacenvarchar720
TOPProduct Catalog
20TWIC8003IACs Retail: Selection of countries for customer address6DEFLTSAP Retail Store: Default Input for Dropdown Boxnvarchar10
TOPProgress Analysis
21EVCEProgress: Cost Element Assignments4DEFLTDefault cost element for earned valuenvarchar10
TOPReuse Services for Country Development
22T5F99P8Link Between Offense and Disciplinary Measure11DEFLTDefault Entry Checkboxnvarchar10
TOPTime Sheet
23TCATX_COMPONENTSCATX: Task Components10DEFLTDefault Valuedecimal83
24TCATX_COMP_DTLCATX: Component Details9DEFLTDefault Valuedecimal83
TOPTravel Expenses
25T706ZSingle Field Control for Dialog7DEFLTDefault value for field controlnvarchar200
26T706Z1Single Field Control for Dialog10DEFLTDefault value for field controlnvarchar200
TOPUSA
27BRCDTABSI-TAX 4.0 BRCDTA6DEFLTBSI40: DEFLTnvarchar10
28BRCGDTABSI-TAX 4.0 BRCGDTA6DEFLTBSI40: DEFLTnvarchar10
TOPUse Subcomponents
29TSOTDValid Object Types2DEFLTDocument class is preset in the Business Workplacenvarchar10
TOPWork Center
30KAPECapacity unit of measure allocation8DEFLTGeneral Flagnvarchar10