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  | TAXGROUP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TIVXCITCRMEMOTax group for credit memo over one year4TAXGROUPTax Groupnvarchar200
2VIYCADVPAYAdvance Payments69TAXGROUPTax Groupnvarchar200
3VIYCRECEIVABLEReceivables from Settlement13TAXGROUPTax Groupnvarchar200
TOPClaims Management
4TICL556Tax Group2TAXGROUPTax Groupnvarchar100
5TICL556TLong Text Tax Group3TAXGROUPTax Groupnvarchar100
6TICL557Combination of Tax Role and Participant2TAXGROUPTax Groupnvarchar100
7TICL558OBSOLETE - Do not use2TAXGROUPTax Groupnvarchar100
TOPConditions
8A602Condition Table for Pricing A6029TAXGROUPTax Group for Dynamic Tax Exceptionsnvarchar20
TOPContract Billing
9DBERCHZ4Individual line items (rarely used fields)30TAXGROUPCategorize Amounts for Tax Determinationnvarchar40
10DBERCHZ8Document line items (rarely used fields, unimportant)30TAXGROUPCategorize Amounts for Tax Determinationnvarchar40
11ERCHZ_SHORTBilling Document Individual Lines Extract76TAXGROUPCategorize Amounts for Tax Determinationnvarchar40
12ESCHSBilling Schema Steps18TAXGROUPCategorize Amounts for Tax Determinationnvarchar40
TOPFinancial Accounting
13J_1UFTASSGROUPDefinition of Tax Groups for Assets5TAXGROUPTax Group for Assetsnvarchar20
TOPFlexible Real Estate Management
14TIVITTCTXCDMAPObsolete4TAXGROUPTax Groupnvarchar200
15TIVRATAXBOLLOSteuergruppe2TAXGROUPSteuergruppenvarchar200
16TIVRATAXBOLLOTSteuergruppe (Text)3TAXGROUPSteuergruppenvarchar200
17TIVXCFCSCKEYPROPService Charge Key: Properties for Fuel Management8TAXGROUPTax Groupnvarchar200
18TIVXCOTCONDCOA, Tax Information for Condition Type4TAXGROUPTax Groupnvarchar200
19TIVXCOTPARAMParameter for VAT on Expense for Service Charge Key4TAXGROUPTax Groupnvarchar200
20VISCS_RECEIVEOBSOLETE: Receivables (Replaced by VISCRECEIVABLE)11TAXGROUPTax Groupnvarchar200
21VIXCOTDSCOA, Distribution of VAT12TAXGROUPTax Groupnvarchar200
TOPInput Tax Treatment
22VIITTAXDSBASETax Document Item to Be Broken Down (VIITTAXDSBASE)20TAXGROUPTax Groupnvarchar200
TOPLocalization
23A346Land/Dyn.Schlüssel1/Dyn.Schlüssel2/Dyn.Schlüssel3/St.-Grp.8TAXGROUPSteuergruppe für Dynamische Steuer-Ausnahmennvarchar20
24A347Land/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp.10TAXGROUPSteuergruppe für Dynamische Steuer-Ausnahmennvarchar20
25A348Land/SF/ST/XSUBT/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp.11TAXGROUPSteuergruppe für Dynamische Steuer-Ausnahmennvarchar20
26A382Land/Belegart/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp11TAXGROUPSteuergruppe für Dynamische Steuer-Ausnahmennvarchar20
27VIXCJPFXDUNPRICEFixed Unit Prices for Service Charge Settlement18TAXGROUPTax Groupnvarchar200
28VIXCJPSCCOSTSEXTCosts per Object - Legacy Data Transfer9TAXGROUPTax Groupnvarchar200
TOPReal Estate Contract
29TIVCNCCTADDAttribute for Contract17TAXGROUPDefault Value for Tax Groupnvarchar200
30VICDCFOBJObject-Related Cash Flow65TAXGROUPTax Groupnvarchar200
31VICDCFPAYPayment-Related Cash Flow65TAXGROUPTax Groupnvarchar200
TOPRental Accounting
32TIVEXFITAXMAPTax Code Assignment per RE Tax Type/Group4TAXGROUPTax Groupnvarchar200
33TIVEXTAXCODEMAPAssignment of RE Tax Type/Group per Tax Code7TAXGROUPTax Groupnvarchar200
34TIVRAALTAXAssignment of Accrual Type to Tax Code4TAXGROUPTax Groupnvarchar200
35TIVRATAXGROUPTax Group2TAXGROUPTax Groupnvarchar200
36TIVRATAXGROUPTTax Group (Text)3TAXGROUPTax Groupnvarchar200
37VIRAADVPAYOBSOLETE: Advance Payment14TAXGROUPTax Groupnvarchar200
38VIRAADVPAYEXTAdvance Payment - Legacy Data Transfer14TAXGROUPTax Groupnvarchar200
39VIRAADVPAYPROCAdvance Payments per Settlement21TAXGROUPTax Groupnvarchar200
40VIRAADVPAYSPLITSplit Advance Payments20TAXGROUPTax Groupnvarchar200
41VIRADOCITEMRE Document Item53TAXGROUPTax Groupnvarchar200
42VIRAINVITEMRE Invoice Item18TAXGROUPTax Groupnvarchar200
43VITMPYTerm: Posting Rule20TAXGROUPTax Groupnvarchar200
TOPSales-Based Rent and Settlement
44VISRCALCCTFCAmounts in Foreign Currency8TAXGROUPTax Groupnvarchar200
45VISRCALCDETAILResults of Sales Grading Calculation17TAXGROUPTax Groupnvarchar200
46VISRCALCSBInterim Result15TAXGROUPTax Groupnvarchar200
47VISRCALCSUMCalculation Results per Sales Rule19TAXGROUPTax Groupnvarchar200
48VISRCRSPLITSplit Receivable10TAXGROUPTax Groupnvarchar200
49VISRMODIRESULTChanged Sales-Based Settlement Results6TAXGROUPTax Groupnvarchar200
50VISRMOSPLITSplit Receivable10TAXGROUPTax Groupnvarchar200
TOPService Charge Settlement
51TIVSCCHRGCNCalculation of Surcharges Dependent on Contract8TAXGROUPTax Groupnvarchar200
52TIVSCEXTRACHRGSurcharge Schema for Surcharges in SCS12TAXGROUPTax Groupnvarchar200
53VISCCOSTSEXTCosts per Object - Legacy Data Transfer9TAXGROUPTax Groupnvarchar200
54VISCCRSPLITSplit Receivable10TAXGROUPTax Groupnvarchar200
55VISCRECEIVABLEReceivables from Settlement14TAXGROUPTax Groupnvarchar200
56VISCSCOSTSDetermined Costs8TAXGROUPTax Groupnvarchar200