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

127 columns | Print definition?ERP 6.0  | SKOART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RDPT_CONDITIONCondition within Redemption Schedule6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
2TDP4Alloc. of activity type and flow category to condition type4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
3TZK0ACondition type texts (Table TZK01)4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
4TZK0GTexts for condition type-dependent detailed description4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
5TZKM1Event-controlled modification of condition items4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
6VDMSG_FOR_CONDMessage type for different condition types2SKOARTCondition Type for Table VDMSG_FOR_CONDnvarchar40
7VDREF_INTCustomizing table for Reference Interest Rate4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
8VDSEPA_MND_USGOverview of mandates used in Loans Management10SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPAccounting
9TDIOA_BAL_CONDAssignment Condition Type to Flow Type Grouping - IOA Calc.5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
10VDIOA_CALC_DETProgress (Interest) of Model Account IOA Calculation20SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPAssetLiability Management
11TTD_COND_MAPTime Deposit Conditions to Treasury Conditions5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPBack Office
12TRSC_CONDITIONTreasury: Update Types for Condition Type3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
13TRSC_CONDITION_PUpdate Types for Condition Type (Passive Positions)3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
14TRST_CLASFLOCFM: Class Flows in Securities Account99SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
15TRST_CLASFLO_REVCFM: Reversed Class Flows in Securities Account99SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPBank Components
16JBACDPERTYPermitted Condition Types for List Types3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
17JBAFOKOPOCondition Items5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
18JBASAKOKOCollective Conditions, Condition Header4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
19JBASTCPStandard Conditions: Condition Item6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPFlexible Real Estate Management
20VIAKHO13WEG-Verwaltung: Umlage Eigentümerabrechnung22SKOARTKonditionsart (feinste Unterteilung der Konditionssätze)nvarchar40
21VIAKHO20WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung12SKOARTKonditionsart (feinste Unterteilung der Konditionssätze)nvarchar40
TOPLoans Management
22TDBO_CONDNStandard Conditions6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
23TDCOND_PROPCurrency-Dependent Default Setting of Conditions3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
24TDFFB_CFHEXEPT_OException Table for Controlling Outflow Behavior4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
25TDLOANFKOCondition Types per Application Partial Function Loans5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
26TDP0Selection, Modification- and Reference Fields9SKOARTGeneral parameters for logical fieldnvarchar40
27TDREPAY_CFHANDLECash Flow Behavior in the Payoff3SKOARTCondition Type for Partial Waivernvarchar40
28TDREPAY_PRCONDCondition Type Determination for the Payoff5SKOARTCondition Type for Partial Waivernvarchar40
29TDRP_COND_TYPERepayment schedule: relevant condition types5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
30TRDC_RECSummarization of Loan Document Items: Carryforward Records14SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
31TTONFTVVZZKOPOTest neue Fima: VVZZKOPO6SKOARTKonditionsart (feinste Unterteilung der Konditionssätze)nvarchar40
32TTONFTVZZBEPPTest neue FIMA: VZZBEPP175SKOARTKonditionsart (feinste Unterteilung der Konditionssätze)nvarchar40
33VDARC_DOC_RECCarryforward Records for Reorganization of Loan Doc. Items15SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
34VDBEPIPosted line items for document header68SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
35VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)68SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
36VDBEPPFlow Data - Planned Item102SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
37VDBOBEPPBusiness Operation: Entered and Activated Flow Data102SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
38VDCFWAREHOUSECash Flow Management19SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
39VDKOPO_EUCondition Item Data Before EURO Conversion (Loans)9SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
40VDREPAYMENTPayoff Master Data53SKOARTPartial Payoff: Condition Type for Repayment ChangeCnvarchar40
41VDVORTRLoan carry-forward totals6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
42VZFZE_VDBEPPCentral Entry Table for Release Procedure105SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPMaster Data
43TDMODEL_FIELDTXTField Texts for Consumer Loans4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
44VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items4SKOARTPayment Type (Condition Type)nvarchar40
TOPMigration
45TIG09Immobilien gew.: zulässige Konditionsarten je Flächenart3SKOARTEhtolaji (ehtotietueiden tarkin jako alaluokkiin)nvarchar40
46TIVMISETCDSRAssignment of Sales-Based Rent Conditions2SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
47VIGWFLBWImmobilien gew.: Flächen-Bewertungen (zeitabh.)4SKOARTEhtolaji (ehtotietueiden tarkin jako alaluokkiin)nvarchar40
48VIGWFLBW_FImmobilien gew.: Flächen-Bewertungen Stammdaten4SKOARTEhtolaji (ehtotietueiden tarkin jako alaluokkiin)nvarchar40
49VIGWFLBW_MImmobilien gew.: Flächen-Bewertungen (zeitabh.)4SKOARTEhtolaji (ehtotietueiden tarkin jako alaluokkiin)nvarchar40
50VIGWVOBWImmobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G7SKOARTEhtolaji (ehtotietueiden tarkin jako alaluokkiin)nvarchar40
51VIGWVOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.7SKOARTEhtolaji (ehtotietueiden tarkin jako alaluokkiin)nvarchar40
52VIGW_VOBWCRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR7SKOARTEhtolaji (ehtotietueiden tarkin jako alaluokkiin)nvarchar40
53VIGW_VOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.7SKOARTEhtolaji (ehtotietueiden tarkin jako alaluokkiin)nvarchar40
TOPPortfolio
54VDARL_PAYM_PLANReferences from Premium Plans to Relevant Objects6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
55VDCOT_VER_CONConditions in the Condition Table5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPReal Estate Management
56IVBPLine Item (Settlement: Service Charge Collector) (Obsolete)30SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
57S406Rental units59SKOARTCondition: Typenvarchar40
58S407Rental agreements98SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
59TIANPMinimum amounts for adjustment of advance pmnts/flat-rates3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
60TIK01Condition types additional data for DARWIN Real Estate3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
61TIK03Condition type - Condition category allocation2SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
62TIK05Alternative reference areas for condition types3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
63TIPARRent Adjustment: Rounding Parameters4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
64TIV48Allocation of condition types to settlement factors3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
65TIV86Allocation of periodic fee types to condition types4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
66TIV90Default-condition types for adjustment type3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
67TIVM3RA: Permitted Condition Types for Each Adjustment Method3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
68TIVN2Defaults for Settlement Participation of Condition Type4SKOARTCondition: Typenvarchar40
69TIVWB08Wirtschaftlichkeitsber.: Konditionsarten für Mietanpassung2SKOARTKonditionsart für Berechnung Erlöse WiBenvarchar40
70TIVWB51WB: Gruppen für Aufwandsarten4SKOARTKonditionsart (feinste Unterteilung der Konditionssätze)nvarchar40
71TZK01Condition types3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
72TZK02Condition group, condition group - condition type allocation4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
73TZK09Relationship between condition types3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
74VIAK02Settlement Participation for Service Charge Settlement10SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
75VIAK13Apportionment Result for List Evaluation (SCSettlement)21SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
76VIAK14RA credit memo/receivable:now only used as structure!11SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
77VIAK20RA credit memo/receivable (incid.exp.sttlmnt created)11SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
78VIAKUVSales settlement histories3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
79VIBEPPFlow data - Planned items for real estate management66SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
80VICNSCSReal Estate Contract: Service Charge Key6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
81VICNSCSPPReal Estate Contract: Liability Reserves3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
82VIMI09Graded Lease-Out6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
83VIMI16RE: Records of a Rent Adjustment Run6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
84VIMI17RE: Adjustment Run Header31SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
85VIMI18Rent Adjustment History for Lease-Out7SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
86VIMI25Sales reports6SKOARTCondition: Typenvarchar40
87VIMI28Sales settlement histories8SKOARTCondition: Typenvarchar40
88VIMI45OLD, replaced by VIMI55 for 3.03SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
89VIMI46OLD, replaced by VIMI56 for 3.03SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
90VIMI54Real Estate: Time-dependent adjustment data6SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
91VIMI55Index Data for Lease-Out (Time-Dependent)3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
92VIMI56LO: Adjustment Block for Condition Types3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
93VIMIUHSales-Based LO: Contractual Sales Lease-Outs Header3SKOARTCondition: Typenvarchar40
94VIMIUISales-Based Grading Lease-Out Items3SKOARTCondition: Typenvarchar40
95VIRPS406Rental units59SKOARTCondition: Typenvarchar40
96VIRPS407Rental agreements98SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
97VZZKOPO_DMAmount fields for VZZKOPO in original currency9SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPSingle Transaction Costing
98JBDZZTKStandard Customizing for Condition Field Selection3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPTransaction Data Pool
99JBDKKOFFixing Table for Variable Transactions4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
100JBDKKOF_BACKUPBackup Table for the Conversion of JBDKKOF4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
101JBDKKOF_NNew Fixing Table for Variable Transactions5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
102JBDKOPOCondition Items7SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
103JBDTZK01Condition Types for Variable Transactions3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
104JBDVTCPVariable Transaction - Condition Items5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPTransaction Management
105TCHT_HD_CONDInstrument Conditions4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
106VTBMDMAPKONDCFM: Mirror Transaction - Map Conditions4SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPTransaction Manager
107AT11Allocation of Condition Types to Transaction Types5SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
108AT20Supplements to Condition Types3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
109BCKVZZKOPOBACKUP: Condition Item Table9SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
110OTC_CONV_FHAPOBackup Table for Financial Transaction Flows24SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
111OTC_CONV_FINKOBackup Table for Financial Transaction Conditions19SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
112OTC_CONV_IFHAPOBackup Table for Underlying Transaction Flows22SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
113OTC_CONV_IFINKOBackup Table for Financial Transaction Underlying Conditions18SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
114TRDT_SEC_FLOWPersistent distributor flows: Part for BEPP adaptor9SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
115VTBFHAPOTransaction Flow24SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
116VTBFHAPO_MIGRMigrated Financial Flows24SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
117VTBFHAPO_UNFIXEDNon-Fixed Financial Transaction Flows24SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
118VTBFINKOTransaction Condition19SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
119VTBPFHAPOTreasury: Flow Shells23SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
120VTIFHAPOUnderlying transaction flows22SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
121VTIFINKOUnderlying transaction conditions18SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
122VWBEPITreasury Securities: Actual Flows - Item57SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
123VWBEPPTreasury Securities: Planned Flows102SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
TOPTreasury
124TZK07Condition type-dependent detailed description skopo3SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
125VZZKOPAAlternative condition item - conditions9SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
126VZZKOPOTable condition items9SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40
127VZZUSPPayment splitting14SKOARTCondition Type (Smallest Subdivision of Condition Records)nvarchar40