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

73 columns | Print definition?ERP 6.0  | COND_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GRCPI/GRIA_VCNDConditions for non-organizational elements8COND_TYPECondition typenvarchar10
2/OPT/CT_IDX_CONDCustomizing table for Conditions3COND_TYPECondition Typenvarchar40
3/OPT/VIM_1ITEM_SDocument Item16COND_TYPECondition Typenvarchar40
4/OPT/VIM_ADC_CONCustomizing Table for Conditions3COND_TYPECondition Typenvarchar40
5/OPT/VIM_TITEMDocument Item16COND_TYPECondition Typenvarchar40
6BBP_CT_SLSCNDControl Condition Buffer for Sell Side Import4COND_TYPECondition Typenvarchar40
7CPEC_CONDTYPECPE Condition Type - CPE extensions3COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
8CPED_EXTENSIONCPE Extension Data3COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
9FARR_C_COND_MODEDefine Condition Type for SSP and RoR2COND_TYPECondition typenvarchar40
10FARR_C_COND_TYPECondition Types Excluded From Price Allocation2COND_TYPECondition typenvarchar40
11FARR_D_MANL_CHNGManual Change Table3COND_TYPECondition typenvarchar40
12J1IEX_LICUTL_LOGEXIM : License Detail10COND_TYPECondition Typenvarchar40
13SRT_CONDITIONSSRT: Conditions7COND_TYPESRT: Condition Typenvarchar20
14VFPRCC_COND2VIEWPricing Condition Type to View Mapping4COND_TYPECondition Typenvarchar40
15VFPRCC_PRCE2VIEWPricing Elements to View Mapping6COND_TYPECondition Typenvarchar40
16YVIM_1ITEMDocument Item16COND_TYPECondition Typenvarchar40
TOPBasis Components
17/XFT/INV_Q_1Invoice receipt queue: Items20COND_TYPECondition Typenvarchar40
18/XFT/INV_Q_1_SInvoice receipt queue: Items20COND_TYPECondition Typenvarchar40
TOPChargeback
19TWCBCHAINCOCKEAssgnmt o. Chck Classes f. Cust. Chcks on Cust. Flds in Chns6COND_TYPECondition Typenvarchar40
20TWCBGENCOCHKEAssignmnt of Check Classes f. Customer Check on Cndtn Fields7COND_TYPECondition Typenvarchar40
TOPCommodity Pricing Engine
21CPEC_FORMCONVCPE Formula - Input for Conversion4COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
22CPEC_FORMROUNDCPE Formula - Input for Rounding4COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
23CPEC_FORMULACPE Formula4COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
24CPEC_FORMULA_TCPE Formula - Description5COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
25CPEC_TERMCPE Term4COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
26CPEC_TERMCONVCPE Term - Conversion4COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
27CPEC_TERMGRPCPE Term - Grouping of Terms4COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
28CPEC_TERMROUNDCPE Term - Rounding4COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
29CPEC_TERM_TCPE Term - Description5COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
30CPED_DEFFORMDOCCPE Formula - Default in Document3COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
31CPED_FORMDOCCPE Formula - Grouping and General Result3COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
32CPED_TERMOUTCPE Term - General Result3COND_TYPECPE: Condition Type for Commodity Pricingnvarchar40
TOPConditions
33COND_POWL_HEADObject Types for Conditions@POWL: Header4COND_TYPECondition Typenvarchar40
TOPCorporate Performance Monitor
34UMC_UN100Notification11COND_TYPECondition Typenvarchar100
TOPCPE in MM
35CPEC_MM_VALFORMArea of Validity for Commodity Pricing Formula in MM4COND_TYPECondition Typenvarchar40
36CPEC_MM_VALTERMArea of Validity for Commodity Pricing Term in MM4COND_TYPECondition Typenvarchar40
TOPCPE in SD
37CPEC_SD_VALFORMArea of Validity for Commodity Pricing Formula in SD4COND_TYPECondition Typenvarchar40
38CPEC_SD_VALTERMArea of Validity for Commodity Pricing Term in SD4COND_TYPECondition Typenvarchar40
TOPDistributor-Reseller-Management
39/SAPHT/DRMCWLCNDCustomizing table for Agreement Conditiion type determinat5COND_TYPECondition typenvarchar40
TOPDSD Connector
40/DSD/ME_CND_TYPECondition types manual discount5COND_TYPECondition Typenvarchar40
41/DSD/ME_CND_T_TCondition types manual discount5COND_TYPECondition Typenvarchar40
42/DSD/ME_DEL_CNDPricing: Manual discount condition for deliveries7COND_TYPECondition Typenvarchar40
43/DSD/ME_ORD_CNDPricing: Manual discount condition for orders7COND_TYPECondition Typenvarchar40
44/DSD/ME_ORD_ITMDSD Connector: Order Items24COND_TYPEDSD Connector: Condition Typenvarchar40
TOPElectronic Data Interchange
45PRICAT_K008PRICAT: Catalog item prices / conditions / taxes7COND_TYPECondition typenvarchar40
46PRICAT_K008CPRICAT: Catalog Item Prices/Conditions/Taxes per Customer8COND_TYPECondition typenvarchar40
47PRICAT_K009PRICAT: Catalog Item Scales for Condition7COND_TYPECondition typenvarchar40
48PRICAT_K009CPRICAT: Catalog Item Scales for Condition for Customer8COND_TYPECondition typenvarchar40
49WRF_PRICAT_TAXPrice Catalog Conversion Percent -> Classification4COND_TYPEPrice Catalog: External Condition Keynvarchar40
TOPEvent Management
50/SAPTRX/CONDDATACondition data table2COND_TYPECondition Typenvarchar10
51/SAPTRX/CONDIDCondition ID table2COND_TYPECondition Typenvarchar10
52/SAPTRX/CONDIDTCondition ID text table3COND_TYPECondition Typenvarchar10
53/SAPTRX/SCCNDMAPScenario Condition Mapping Table2COND_TYPECondition Typenvarchar10
TOPFinancial Accounting
54/OPT/VIM_1ITEMDocument Item16COND_TYPECondition Typenvarchar40
TOPFSCM In-House Cash
55IHC_TAB_GUI_MAPIHC: Mapping Table for GUI6COND_TYPEIHC: Type of Structure in Conditionnvarchar150
TOPGeneric Contract Accounts Receivable and Payable
56BCA_DIM_CALCDETCalculation details for billing items7COND_TYPECondition Typenvarchar60
TOPGlobal Trade
57WB2_C_COND_CALLAssignment of a class per condition type4COND_TYPECondition Typenvarchar40
58WB2_C_PRpricing aspect6COND_TYPECondition Typenvarchar40
59WB2_D_PRASPTrading Contract: pricing aspects11COND_TYPECondition Typenvarchar40
TOPIntercompany Data Exchange
60ECOMCONTROLSPCommunication Control Based on Service Providers4COND_TYPECondition Type for Commmunication Controlnvarchar20
61ECONDTYPECondition Types2COND_TYPECondition Type for Commmunication Controlnvarchar20
62ECONDTYPETComunication Control Condition Type Text3COND_TYPECondition Type for Commmunication Controlnvarchar20
TOPInvoice Forecasting
63IFW_C_COND_TYPECondition type for invoice forecasting worklist4COND_TYPECondition Type for Invoice Forecasting Worklistnvarchar40
TOPLease Accounting
64/LSIERP/COND_MAPAssign FI-CA Transactions to CRM Conditions5COND_TYPECondition Typenvarchar40
65/LSIERP/TQ_P_DETPayment Details and Test Results for Cost Estimate5COND_TYPECondition Typenvarchar40
TOPMarketing, Accounting and Pricing
66OIC_FORM_ATTRIBAttributes of Business Context for F&A Formula14COND_TYPECondition typenvarchar40
TOPSAP NetWeaver Mobile - Use subcomponents
67MICOND_TYPEMI-MSD: Valid Values for Dependency Types3COND_TYPEMobile Component Descriptor Dependency Namenvarchar200
68MICOND_VALUEMI-MSD: Valid Values for Dependency Types3COND_TYPEMobile Component Descriptor Dependency Namenvarchar200
TOPSAP Retail Store
69TWIC0515In-Store MIM: Customizing for SO condition types7COND_TYPECondition Typenvarchar40
TOPSupply Chain Management
70TCM_C_COND_MAPMapping Transportation Charges Elements - Conditions7COND_TYPECondition Typenvarchar40
71TCM_TC_COND_MAPMapping Transportation Charges Elements - Conditions7COND_TYPECondition Typenvarchar40
TOPTraders and Schedulers Workbench
72OIJ_EL_CP_LAYTCharter party and laytime and demurrage agreement53COND_TYPEDemurrage rate condition typenvarchar40
TOPTransaction Tax Engine
73TTEC_PRELEM_TYPPricing Element2COND_TYPECondition Type for Pricing Elementnvarchar40