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

Home | ERP 6.0  | J_1IEXCDEF
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Localization
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0J_1IEXCDEF331Tax default informationsLocalization
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, J_1ITAXCAL, J_1ICVDTYP, J_1ITXCODE, J_1ITXJCD, J_1ICBEDAP, J_1ICSEDAP, J_1ICAEDAP, J_1ICBEDAR, J_1ICSEDAR, J_1ICAEDAR, J_1ICCESAR, J_1ICBEDP, J_1ICAEDP, J_1ICSEDP, J_1ICCESP, J_1ICNCCDAP, J_1ICNCCDAR, J_1ICNEDP, J_1ICECSAP, J_1ICECSAR, J_1ICECSP, J_1IECVDTP, J_1ICADCAP, J_1ICAT1AP, J_1ICAT1AR, J_1ICAT1P, J_1ICAT2AP, J_1ICAT2AR, J_1ICAT2P, J_1ICAT3AP, J_1ICAT3AR, J_1ICAT3P FROM J_1IEXCDEF
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2J_1ITAXCALTax procedurenvarchar60CHAR(N' ')No*J_1ITAXCAL Allow NULL? 
3J_1ICVDTYPCVD Condition Type A/Pnvarchar40CHAR(N' ')Yes*J_1ICCTYPP Allow NULL? 
4J_1ITXCODEExport tax codenvarchar20CHAR(N' ')Yes*J_1ITXCODE Allow NULL? 
5J_1ITXJCDExport tax jurisdiction code (Dummy)nvarchar150CHAR(N' ')Yes*J_1ITXJCD Allow NULL? 
6J_1ICBEDAPAccount payable BED condition typenvarchar40CHAR(N' ')Yes*J_1ICBEDAP Allow NULL? 
7J_1ICSEDAPAccount payable SED condition typenvarchar40CHAR(N' ')Yes*J_1ICSEDAP Allow NULL? 
8J_1ICAEDAPAccount payable AED condition typenvarchar40CHAR(N' ')Yes*J_1ICAEDAP Allow NULL? 
9J_1ICBEDARAccount receivable BED condition typenvarchar40CHAR(N' ')Yes*J_1ICBEDAR Allow NULL? 
10J_1ICSEDARAccount receivable SED condition typenvarchar40CHAR(N' ')Yes*J_1ICSEDAR Allow NULL? 
11J_1ICAEDARAccount receivable AED condition typenvarchar40CHAR(N' ')Yes*J_1ICAEDAR Allow NULL? 
12J_1ICCESARAccount receivable CESS condition typenvarchar40CHAR(N' ')Yes*J_1ICCESAR Allow NULL? 
13J_1ICBEDPBED Percentage conditionnvarchar40CHAR(N' ')Yes*J_1ICBEDP Allow NULL? 
14J_1ICAEDPAED Percentage conditionnvarchar40CHAR(N' ')Yes*J_1ICAEDP Allow NULL? 
15J_1ICSEDPSED Percentage conditionnvarchar40CHAR(N' ')Yes*J_1ICSEDP Allow NULL? 
16J_1ICCESPCess Percentage conditionnvarchar40CHAR(N' ')Yes*J_1ICCESP Allow NULL? 
17J_1ICNCCDAPNCCD Condition type APnvarchar40CHAR(N' ')Yes*J_1ICNCCDAP Allow NULL? 
18J_1ICNCCDARNCCD Condition type ARnvarchar40CHAR(N' ')Yes*J_1ICNCCDAR Allow NULL? 
19J_1ICNEDPNCCD Percnvarchar40CHAR(N' ')Yes*J_1ICNEDP Allow NULL? 
20J_1ICECSAPECS Condition type APnvarchar40CHAR(N' ')Yes*J_1ICECSAP Allow NULL? 
21J_1ICECSARECS Condition type ARnvarchar40CHAR(N' ')Yes*J_1ICECSAR Allow NULL? 
22J_1ICECSPECS Percentage conditionnvarchar40CHAR(N' ')Yes*J_1ICECSP Allow NULL? 
23J_1IECVDTPECS Condition Type A/P Importsnvarchar40CHAR(N' ')Yes*J_1ICETYPP Allow NULL? 
24J_1ICADCAPADC Condition Type A/Pnvarchar40CHAR(N' ')Yes*J_1ICADCAP Allow NULL? 
25J_1ICAT1APAT1 Condition type APnvarchar40CHAR(N' ')Yes*J_1ICAT1AP Allow NULL? 
26J_1ICAT1ARAT1 Condition type ARnvarchar40CHAR(N' ')Yes*J_1ICAT1AR Allow NULL? 
27J_1ICAT1PAT1 Percentage conditionnvarchar40CHAR(N' ')Yes*J_1ICAT1P Allow NULL? 
28J_1ICAT2APAT2 Condition type APnvarchar40CHAR(N' ')Yes*J_1ICAT2AP Allow NULL? 
29J_1ICAT2ARAT2 Condition type ARnvarchar40CHAR(N' ')Yes*J_1ICAT2AR Allow NULL? 
30J_1ICAT2PAT2 Percentage conditionnvarchar40CHAR(N' ')Yes*J_1ICAT2P Allow NULL? 
31J_1ICAT3APAT3 Condition type APnvarchar40CHAR(N' ')Yes*J_1ICAT3AP Allow NULL? 
32J_1ICAT3ARAT3 Condition type ARnvarchar40CHAR(N' ')Yes*J_1ICAT3AR Allow NULL? 
33J_1ICAT3PAT3 Percentage conditionnvarchar40CHAR(N' ')Yes*J_1ICAT3P Allow NULL? 
NamePrimaryUniqueTypeColumns
J_1IEXCDEF~0YesYesCLUSTEREDJ_1ITAXCAL, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy