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

64 columns | Print definition?ERP 6.0  | SNKSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item52SNKSLService Charge Keynvarchar40
2/OPT/VIM_TITEMDocument Item52SNKSLService Charge Keynvarchar40
3YVIM_1ITEMDocument Item52SNKSLService Charge Keynvarchar40
TOPFinancial Accounting
4/OPT/VIM_1ITEMDocument Item52SNKSLService Charge Keynvarchar40
5KMZEIFI: Account Assignment Model Item Information84SNKSLService Charge Keynvarchar40
6KOMUAccount Assignment Templates for G/L Account Items84SNKSLService Charge Keynvarchar40
TOPFlexible Real Estate Management
7TIVHOSUPREinmalige Buchungen: Vorschlag Nebenkostenschlüssel3SNKSLNebenkostenschlüsselnvarchar40
8TIVSCSCKATTROBSOLETE: Service Charge Key Attributes2SNKSLService Charge Keynvarchar40
9TIVXCFCSCKEYPROPService Charge Key: Properties for Fuel Management2SNKSLService Charge Keynvarchar40
10TIVXCOTPARAMParameter for VAT on Expense for Service Charge Key2SNKSLService Charge Keynvarchar40
11VIAKHO20WEG-Verwaltung: Guthaben/Forderungen Eigentümerabrechnung9SNKSLNebenkostenschlüsselnvarchar40
12VIAKHO21Mandatsverwaltung: Gesplittete Abrechnungsgrößen4SNKSLNebenkostenschlüsselnvarchar40
13VICAINTRENOAssignment of INTRENO / OBJNR / IMKEY15SNKSLService Charge Keynvarchar40
14VIXCSCCHTAPEHeader Data for External Heating Expenses Settlement8SNKSLService Charge Keynvarchar40
15VIXCSCCHTPSHARDistribution for External Heating Expenses Settlement5SNKSLService Charge Keynvarchar40
TOPLocalization
16TIVXCJPFLWTYPFlow Type Defined for Service Charge Keys3SNKSLService Charge Keynvarchar40
17VIXCJPFXDUNPRICEFixed Unit Prices for Service Charge Settlement3SNKSLService Charge Keynvarchar40
TOPMigration
18TIVMISETMEASConversion of Area Type and Apportionment Unit to Meas.Type27SNKSLService Charge Keynvarchar40
19TIVMISETSCKEYMapping of Service Charge Keys2SNKSLService Charge Keynvarchar40
TOPProfit Center Accounting
20KE1_WU_IM_ITEMPCA Where-Used List: Itemization for Real Estate19SNKSLService Charge Keynvarchar40
TOPReal Estate Management
21IVBPLine Item (Settlement: Service Charge Collector) (Obsolete)17SNKSLService Charge Keynvarchar40
22ONRIACalculation unit object number index5SNKSLService Charge Keynvarchar40
23TIK01Condition types additional data for DARWIN Real Estate4SNKSLService Charge Keynvarchar40
24TIV05Definition of Service Charge Keys2SNKSLService Charge Keynvarchar40
25TIV06Service Charge Key Attributes for each Tenancy Law3SNKSLService Charge Keynvarchar40
26TIV52Key conversion accountancy firm <-> partner cost elements4SNKSLService Charge Keynvarchar40
27TIV54Fuel type + incidental expenses key as well (internal)3SNKSLService Charge Keynvarchar40
28TIV67Flow Types for Service Charge Key2SNKSLService Charge Keynvarchar40
29TIV68Flow types/SCKey for vacancy with tenant serv. charge sett.2SNKSLService Charge Keynvarchar40
30TIVN1Defaults for Settlement Participation of Service Charge Key4SNKSLService Charge Keynvarchar40
31TIVT5Incidental expenses key text3SNKSLService Charge Keynvarchar40
32VIAK01History of acct settlement runs4SNKSLService Charge Keynvarchar40
33VIAK02Settlement Participation for Service Charge Settlement6SNKSLService Charge Keynvarchar40
34VIAK03Settlement Unit Master Record4SNKSLService Charge Keynvarchar40
35VIAK04Allocation of Settlement Variants to Settlement Unit4SNKSLService Charge Keynvarchar40
36VIAK05Allocation of rental units to calculation unit4SNKSLService Charge Keynvarchar40
37VIAK06Calculation unit relations3SNKSLService Charge Keynvarchar40
38VIAK07Calculation unit option rate4SNKSLService Charge Keynvarchar40
39VIAK08DME Settlement Units Master Data25SNKSLService Charge Keynvarchar40
40VIAK09Assignment of Heating Systems to Calculation Units4SNKSLService Charge Keynvarchar40
41VIAK14RA credit memo/receivable:now only used as structure!9SNKSLService Charge Keynvarchar40
42VIAK19Costs Directly Assigned to Lease-Out13SNKSLService Charge Keynvarchar40
43VIAK20RA credit memo/receivable (incid.exp.sttlmnt created)9SNKSLService Charge Keynvarchar40
44VIAK21Split settlement factors for settlement variant4SNKSLService Charge Keynvarchar40
45VIAK22Heat.oil supply4SNKSLService Charge Keynvarchar40
46VIAK22THeat.oil supply texts4SNKSLService Charge Keynvarchar40
47VIAK25Cost collector for SU (per settlement period)4SNKSLService Charge Keynvarchar40
48VIAK26Master Settlement Unit: Participating Settlement Units4SNKSLService Charge Keynvarchar40
49VIAKBSEGDocument Line Item from SCS for Interface102SNKSLService Charge Keynvarchar40
50VIAKT5Rental units allocation ID5SNKSLService Charge Keynvarchar40
51VIAROBJArchived real estate objects17SNKSLService Charge Keynvarchar40
52VICNSCSReal Estate Contract: Service Charge Key4SNKSLService Charge Keynvarchar40
53VICNSCSPPReal Estate Contract: Liability Reserves5SNKSLService Charge Keynvarchar40
54VICNSCSRPReal Estate Contract: Service Charge Settlement Item5SNKSLService Charge Keynvarchar40
55VIZNRNAssignment: Real Estate numbers <-> IMKEY <-> INTRENO11SNKSLService Charge Keynvarchar40
TOPService Charge Settlement
56TIVSCAJSCKATTRAttributes of Adjustment of SCS Advance Pmnt per SC Key2SNKSLService Charge Keynvarchar40
57TIVSCCONDSCKAssignment of Condition Type to Service Charge Key3SNKSLService Charge Keynvarchar40
58TIVSCDEFCONDAssignment of Service Charge Key to Condition Type2SNKSLService Charge Keynvarchar40
59TIVSCSCK2ACCPROPAssignment of SC Key to Account Property3SNKSLService Charge Keynvarchar40
60TIVSCSCKEYService Charge Keys2SNKSLService Charge Keynvarchar40
61TIVSCSCKEYSESettings per Settlement Purpose2SNKSLService Charge Keynvarchar40
62TIVSCSCKEYTService Charge Key (Text)3SNKSLService Charge Keynvarchar40
63TIVSCSUDEFAULTDefaults for Creating SU per SC Key2SNKSLService Charge Keynvarchar40
64VISCSUSettlement unit5SNKSLService Charge Keynvarchar40