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

56 columns | Print definition?ERP 6.0  | COND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20308_CONDConditions for Data Download6CONDLine of a WHERE Conditionnvarchar720
2CNV_20308_DLCONDConditions for Download7CONDLine of a WHERE Conditionnvarchar720
3CNV_20551_AN_TXTAnalyis of intransp. fields: Text4CONDnvarchar720
4CNV_20551_D_CHKIntransparent fields: Check tables for CNV_20551_DATA_CHEC8CONDAdditional WHERE conditionnvarchar600
5CNV_INTR_FLD_ANTAnalyis of intransp. fields: Text4CONDPAW - Character field length 72nvarchar720
6CNV_INTR_FLD_CHKIntransparent fields: Table for check program8CONDAdditional WHERE conditionnvarchar600
7FAGL_SLL_ACTVITYActivity Model2CONDPermitted Status Values for Switch Projectnvarchar20
8NWS_EXT_KRData Transport Management Tool Key - Relationships7CONDCondition Transport Data Management Toolnvarchar710
9TREB_CUST_MAP_IMBilling Doc. Determination f. Rebate: Cust.-Specific Mapping9CONDCommentnvarchar500
10TREB_DEF_MAP_IMBilling Document Determination Rebate: Mapping9CONDCommentnvarchar500
11ZSA_D_KRxSA Key - Relationships8CONDxSA Conditionnvarchar400
12PIQDBCOREQ_CONDTable for Corequisite booking check conditions2CONDConditionnvarchar40
13T7PIQRLCONDConditions1CONDConditionnvarchar40
14T7PIQRLCONDTConditions (Text Table)1CONDConditionnvarchar40
15T7PIQRLCOND_DEFAssign Conditions to Subrequirements3CONDConditionnvarchar40
16T7PIQRLCOND_PAAssign Parameters to Conditions1CONDConditionnvarchar40
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
17DD14SR/3 DD: components of SAP objects7CONDFlag for a conditional relationshipnvarchar10
TOPAlert Framework
18SALRTCATUSFixed Alert Recipients4CONDGUID in 'CHAR' Format in Uppercasenvarchar320
19SALRTTROLEAlert Recipients Via User Roles4CONDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPBelgium
20T5BALActivation allowances associated with SI deductions3CONDForms: Conditionsnvarchar40
TOPClassification System New
21CME_ST_REFCharacteristic: Data Reference12CONDCharacteristic: Condition Referencenvarchar2540
22CME_ST_REFHCharacteristic: Data Reference12CONDCharacteristic: Condition Referencenvarchar2540
TOPClinical System
23N2DPREFETCHIS-H*MED RAD: Prefetch rule6CONDCondition of a prefetch rulenvarchar2540
TOPCondition
24BKK81Bank Condition3CONDCondition IDnvarchar100
25BKK81TTexts for Bank Conditon4CONDCondition IDnvarchar100
26BKK82Bank Condition Item3CONDCondition IDnvarchar100
27BKK83Bank Condition Determination6CONDCondition IDnvarchar100
28BKK84Bank Account - Individual Condition4CONDCondition IDnvarchar100
29BKK84TTexts for Bank Account Individual Condition5CONDCondition IDnvarchar100
30BKK85Bank Account - Individual Condition Position4CONDCondition IDnvarchar100
31BKK8RKStandard Conditions: Retroactive Condition Changes6CONDCondition IDnvarchar100
TOPDownloadUpload
32/DSD/HH_RADELCDDSD Route Settlement: Delivery Execution Conditions6CONDCondition Typenvarchar40
33/DSD/HH_RADELCNDDSD Route Settlement: Delivery Execution Conditions6CONDCondition Typenvarchar40
34/DSD/HH_RAERRIDXDSD - RA: Error Index Table8CONDCondition Typenvarchar40
35/DSD/HH_RAIVCDDSD Route Settlement: HH Invoice Header Conditions5CONDCondition Typenvarchar40
36/DSD/HH_RAIVCNDDSD Route Settlement: HH Invoice Header Conditions5CONDCondition Typenvarchar40
TOPFrance
37T5F1CSI contributions:rates and wage types24CONDCondition typenvarchar40
38T5F1C4Contributions conditions2CONDCondition typenvarchar40
39T5F1C5Contributions conditions2CONDCondition typenvarchar40
40T5F1C5TDescriptions of the contributions conditions3CONDCondition typenvarchar40
TOPInformation Consistency
41SIC_NORM_CONDRURConditional Rules3CONDConditionnvarchar300
42SIC_NORM_CONDRUVVariables Assignment of Conditional Rules3CONDConditionnvarchar300
43SIC_NORM_FORMCConditions for Condition Types using Formula Editor3CONDConditionnvarchar300
44SIC_NORM_FORMCCVValues of Constants for Conditions3CONDConditionnvarchar300
45SIC_NORM_FORMCTDescriptions for Conditions3CONDConditionnvarchar300
TOPLogbook
46DIACL_CLISTDI CLIST: Component data10CONDInventory Group ID (Rotable Control)nvarchar20
TOPMedia Product Sales and Distribution
47TJKSDSALESQUANRDefinition of Sales Indicator6CONDConditionnvarchar20
48TJSEORDERTYPEIS-M: Determination of Order Type/Item Category7CONDIS-M: Name of Function Module for Conditionnvarchar300
TOPProfitability Analysis
49TKEEXCOND01CO-PA: CRM Conditions2CONDExternal Conditionnvarchar40
50TKEEXCOND01TCO-PA: CRM Conditions - Text Table3CONDExternal Conditionnvarchar40
51TKEEXCOND02CO-PA: Assignment of CRM Conditions to Value Fields3CONDExternal Conditionnvarchar40
TOPSpecification 2
52SPCMGLOACASPEC2000M Translation COND-ACA3CONDCondition type (coded)nvarchar40
TOPTransaction Manager
53TCORFTS_MAP_CONDMapping Condition1CONDCondition of a Mapping Operationnvarchar150
54TCORFTS_MAP_RULEMapping Rules10CONDCondition of a Mapping Operationnvarchar150
55TCORITS_CHK_CONDCheck Framework: Rule conditions1CONDCondition IDnvarchar150
56TCORITS_CHK_RULECheck Framework: Validation rules4CONDCondition of the validation rulenvarchar150