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

61 columns | Print definition?ERP 6.0  | CONDTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/T_FMAPCONDField condition mapping9CONDTYPECondition Typenvarchar10
2/AIF/T_FMAPCONDVField condition mapping variant12CONDTYPECondition Typenvarchar10
3CNV_10020_CONDConditions - Header data4CONDTYPECondition typenvarchar20
4CNV_10020_CONDCCConditions complex6CONDTYPECondition typenvarchar20
5CNV_10020_CONDTConditions - Descriptions5CONDTYPECondition typenvarchar20
6CNV_10020_RULEPRules for components of non-transp. fields/determ. objects8CONDTYPECondition typenvarchar20
7TIVXCITIREFTMapping of IRE Status to Contract-Flow type-Taxcode8CONDTYPEIRE Condition Type for Payback Postingsnvarchar40
8TIVXCITSDINTSettings of Italian Security Deposit Interest Calculation3CONDTYPECondition Typenvarchar40
9TIVYCCOND2EXPAdvance Payment Condition to Expence Types3CONDTYPECondition Typenvarchar40
10VIYCADVPAYAdvance Payments83CONDTYPECondition Typenvarchar40
11VIYCRECEIVABLEReceivables from Settlement7CONDTYPECondition Typenvarchar40
12YTIVCDCONDTYPEFAS13 Conditon types2CONDTYPECondition Typenvarchar40
13CMACDB_ITEMRESFee Calculation Line Results8CONDTYPECondition Typenvarchar40
TOPClinical System
14N2DPREFETCHIS-H*MED RAD: Prefetch rule5CONDTYPECondition type of a prefetch rulenvarchar20
TOPDocument Management System
15EDMS_CONDITIONFilter Conditions in Easy Document Management (Logically Or)6CONDTYPEKind of Filter Condition in Easy Document Managementnvarchar60
TOPDSD Connector
16/DSD/ME_DEL_ITMDSD CN: Delivery Items30CONDTYPEDSD Connector: Condition Typenvarchar40
17/DSD/ME_INV_ITMDSD CN: Billing Doc. Items26CONDTYPEDSD Connector: Condition Typenvarchar40
TOPFlexible Real Estate Management
18TIVXCMSSPOSCEItem in Schema: Assignment to Cost Element9CONDTYPECondition Typenvarchar40
19TIVXCOTCONDCOA, Tax Information for Condition Type2CONDTYPECondition Typenvarchar40
20VISCS_RECEIVEOBSOLETE: Receivables (Replaced by VISCRECEIVABLE)22CONDTYPECondition Typenvarchar40
21VIXCRAESRREFIAssignment of ISR Ref./Cash Flow Plan (Item)5CONDTYPECondition Typenvarchar40
TOPFunds Management
22FMFG_RE_PPA_EXRECN Condition: PPA Exclude Flag4CONDTYPECondition Typenvarchar40
TOPInformation System
23TIVISPFCONDRELReport Profile for Conditions: Properties6CONDTYPECondition Typenvarchar40
TOPLocalization
24TIVXCFRCONDTYPCondition types relevant for EO specific AP calculation2CONDTYPECondition Typenvarchar40
25TIVXCNLSUBSICONDDefine Condition Types for Subsidized Rent3CONDTYPECondition Typenvarchar40
TOPPost Processing Framework
26PPFTBADICOPPF: Management Table for Method Conditions (BADI)3CONDTYPEType of Parameter Conditionnvarchar20
TOPPublic Sector Contract Accounts Receivable and Payable
27TFMCA_PT_TAXCONDCustomizing for Tax Conditions (Property Tax)2CONDTYPECondition Typenvarchar40
28TIVXACDREVTYPRELAssign Revenue Type to Condition Type2CONDTYPECondition Typenvarchar40
29TIVXACDRVTYPRELAssign Revenue Type to Condition Type2CONDTYPECondition Typenvarchar40
TOPReal Estate Contract
30TIVCDCHGREASReason for Change2CONDTYPECondition Typenvarchar40
31TIVCDCHGREASTReason for Change (Text)3CONDTYPECondition Typenvarchar40
32TIVCDCONDDEFDefault Condition4CONDTYPECondition Typenvarchar40
33TIVCDCONDRELCondition Type per Condition Group3CONDTYPECondition Typenvarchar40
34TIVCDCONDTYPECondition Type2CONDTYPECondition Typenvarchar40
35TIVCDCONDTYPETCondition Type (Text)3CONDTYPECondition Typenvarchar40
36VICDCFOBJObject-Related Cash Flow78CONDTYPECondition Typenvarchar40
37VICDCFPAYPayment-Related Cash Flow79CONDTYPECondition Typenvarchar40
38VICDCONDCondition33CONDTYPECondition Typenvarchar40
39VICDCONDCALCConditions - Calculation Factors and Condition Amounts6CONDTYPECondition Typenvarchar40
40VICDCONDDISTConditions - Distribution Factors and Transfer Amounts6CONDTYPECondition Typenvarchar40
TOPRent Adjustment
41TIVAJEXPGRPCDCondition Type for Expense Item Group3CONDTYPECondition Typenvarchar40
42TIVAJRULECONDComputability Provisions per Adjust.Rule and Condition Type4CONDTYPECondition Typenvarchar40
43VIAJCEAPRESTGPrestage Adjustment Record22CONDTYPECondition Typenvarchar40
TOPRental Accounting
44VIRAADVPAYOBSOLETE: Advance Payment4CONDTYPECondition Typenvarchar40
45VIRAADVPAYEXTAdvance Payment - Legacy Data Transfer5CONDTYPECondition Typenvarchar40
46VIRAADVPAYPROCAdvance Payments per Settlement13CONDTYPECondition Typenvarchar40
47VIRAADVPAYSPLITSplit Advance Payments10CONDTYPECondition Typenvarchar40
48VIRADOCITEMRE Document Item21CONDTYPECondition Typenvarchar40
49VIRAINVITEMRE Invoice Item7CONDTYPECondition Typenvarchar40
TOPRoom Reservations and Seating Arrangements
50VIORRSCOSTReservation - Costs10CONDTYPECondition Typenvarchar40
TOPSales-Based Rent and Settlement
51VISRCALCADVPAYReference to Advance Payment Used6CONDTYPECondition Typenvarchar40
52VISRCALCSUMCalculation Results per Sales Rule13CONDTYPECondition Typenvarchar40
TOPSAP Business Workflow
53SWDSCONDEFWF Definition: Conditions5CONDTYPEWF: Type of conditionnvarchar20
54SWD_CONDEFWF Definition/Runtime: Conditions6CONDTYPEWF: Type of conditionnvarchar20
55SWJPHEADHeader Table for Parameter Condition3CONDTYPEType of Parameter Conditionnvarchar20
TOPService Charge Settlement
56TIVSCCONDSCKAssignment of Condition Type to Service Charge Key2CONDTYPECondition Typenvarchar40
57TIVSCDEFCONDAssignment of Service Charge Key to Condition Type3CONDTYPECondition Typenvarchar40
58TIVSCMEAS2CONDAssignment of Measurement Type to Condition Type3CONDTYPECondition Typenvarchar40
59VISCCNPARTSettlement Participation for Service Charge Settlement9CONDTYPECondition Typenvarchar40
60VISCRECEIVABLEReceivables from Settlement4CONDTYPECondition Typenvarchar40
61VISCS_RO_CNCosts and Measurement Amounts for REC + RO (Lease-Out View)14CONDTYPECondition Typenvarchar40