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

47 columns | Print definition?ERP 6.0  | CONDITION_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010COItems for Class SD01 - Raw Data8CONDITION_TYPECondition typenvarchar40
2/1RA/0SD012COItems for Class SD01 - Processable8CONDITION_TYPECondition typenvarchar40
3/1RA/0SD014COItems for Class SD01 - Processed7CONDITION_TYPECondition typenvarchar40
4/1RA/0SD020COItems for Class SD02 - Raw Data8CONDITION_TYPECondition typenvarchar40
5/1RA/0SD022COItems for Class SD02 - Processable8CONDITION_TYPECondition typenvarchar40
6/1RA/0SD024COItems for Class SD02 - Processed7CONDITION_TYPECondition typenvarchar40
7/1RA/0SD030COItems for Class SD03 - Raw Data8CONDITION_TYPECondition typenvarchar40
8/1RA/0SD032COItems for Class SD03 - Processable8CONDITION_TYPECondition typenvarchar40
9/1RA/0SD034COItems for Class SD03 - Processed7CONDITION_TYPECondition typenvarchar40
10/XLSO/PRICE_CONDMaintain pricing tables for XLSO.2CONDITION_TYPECondition type XLSOnvarchar40
11CONDITION_TABLECondition Table2CONDITION_TYPEField of length 16nvarchar160
12FARR_D_DEFITEMDeferral item table4CONDITION_TYPECondition typenvarchar40
13FARR_D_DELDEFITMDeletion update for Deferral Item(memorized for BI)5CONDITION_TYPECondition typenvarchar40
14FARR_D_LEGACYCLegacy data for initial load of conditions for rev.acc.it.7CONDITION_TYPECondition typenvarchar40
15FARR_D_POSTINGPosting table6CONDITION_TYPECondition typenvarchar40
16FARR_D_RAI_CHChange Sequence of Changed Items10CONDITION_TYPECondition Typenvarchar40
17L2TC_ADJUST_CONDCondition type - Commodity ID Mapping Items3CONDITION_TYPECondition Typenvarchar40
18PARAM_F4_FBF$ Help Modules for Condition Editor Parameter Names2CONDITION_TYPEField of length 16nvarchar160
19TEXT_CTY_EXPOSCommodity Price Exposure87CONDITION_TYPECondition Typenvarchar40
20TWCBCRITICALCCritical Condition Changes4CONDITION_TYPECondition Typenvarchar40
TOPBRFplus - ABAP-Based Business Rules
21FDT_EXPR_9003FDT: Expression - Loop (implicit ranges for Conditions)5CONDITION_TYPEFDT: Type of Condition (Exit/Continue in Loop)nvarchar10
22FDT_EXPR_9003AFDT: Expression - Loop (implicit ranges for Conditions)5CONDITION_TYPEFDT: Type of Condition (Exit/Continue in Loop)nvarchar10
23FDT_EXPR_9003SFDT: Expression - Loop (implicit ranges for Conditions)4CONDITION_TYPEFDT: Type of Condition (Exit/Continue in Loop)nvarchar10
24FDT_EXPR_9003TFDT: Expression - Loop (implicit ranges for Conditions)4CONDITION_TYPEFDT: Type of Condition (Exit/Continue in Loop)nvarchar10
TOPBusiness Consolidation
25UCF4000Reclassification: Definitions per Step13CONDITION_TYPEDefinition of Conditionnvarchar10
TOPInformation Consistency
26SIC_NORM_CONDRUConditional Rules3CONDITION_TYPECondition Typenvarchar300
27SIC_NORM_CONDTITDescriptions for Interface Variables for Condition Types2CONDITION_TYPECondition Typenvarchar300
28SIC_NORM_CONDTYCondition Types2CONDITION_TYPECondition Typenvarchar300
29SIC_NORM_CONDTYIInterface Variables for Condition Types2CONDITION_TYPECondition Typenvarchar300
30SIC_NORM_CONDTYTDescriptions for Condition Types2CONDITION_TYPECondition Typenvarchar300
31SIC_NORM_FORMCConditions for Condition Types using Formula Editor2CONDITION_TYPECondition Typenvarchar300
32SIC_NORM_FORMCCOConstants for Condition Types2CONDITION_TYPECondition Typenvarchar300
33SIC_NORM_FORMCCVValues of Constants for Conditions2CONDITION_TYPECondition Typenvarchar300
34SIC_NORM_FORMCTDescriptions for Conditions2CONDITION_TYPECondition Typenvarchar300
35SIC_NORM_FORMCTYCondition Types using Formula Editor2CONDITION_TYPECondition Typenvarchar300
TOPLoans Management
36TDBO_CFEXC_INException Table for Inflow Behavior4CONDITION_TYPECondition Type (Smallest Subdivision of Condition Records)nvarchar40
37TDBO_CFEXC_OUTException Table for Outflow Behavior4CONDITION_TYPECondition Type (Smallest Subdivision of Condition Records)nvarchar40
38TDBO_CFHEAD_INHeader Entry for Control of Inflow Behavior4CONDITION_TYPECondition Type (Smallest Subdivision of Condition Records)nvarchar40
39TDBO_CFHEAD_OUTHeader Entry for Control of Outflow Behavior4CONDITION_TYPECondition Type (Smallest Subdivision of Condition Records)nvarchar40
40TDLOS_MAP_CONDLoan Origination: Assignment of Conditions6CONDITION_TYPECondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPLocalization
41J_1A_WS_COND_MAPAR WS: Mapping of pricing conditions with material code2CONDITION_TYPECondition Typenvarchar40
TOPSAP NetWeaver Mobile - Use subcomponents
42MEMGMT_CONDITIONAssignment Condition of a Device Configuration3CONDITION_TYPECondition for Device Configurationnvarchar200
43MEMGMT_COND_TYPETypes for Device Configuration1CONDITION_TYPECondition for Device Configurationnvarchar200
44MEMGMT_PARA_PROPDevice Configuration: Properties of a Parameter2CONDITION_TYPECondition for Device Configurationnvarchar200
45MEMGMT_TYPE_VALTypes for Device Configuration1CONDITION_TYPECondition for Device Configurationnvarchar200
TOPTransaction Manager
46TEXT_REXP_ITEMRaw Exposure Item33CONDITION_TYPECondition Typenvarchar40
TOPTreasury and Risk Management Integration
47L2TC_CONDICOMMCondition type - Commodity ID Mapping3CONDITION_TYPECondition Typenvarchar40