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_1IEXCHDR
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Localization
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0J_1IEXCHDR816Excise invoice header detailLocalization
SQL:  selectupdate insert create

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

SELECT MANDT, TRNTYP, DOCYR, DOCNO, BUKRS, WERKS, EXGRP, SRGRP, STRTYP, EXNUM, EXDAT, EXYEAR, REMTIME, LIFNR, SHIPFROM, RCWRK, EXCUR, EXBED, EXSED, EXAED, CESS, REFDOC, RDOC, RYEAR, RIND, KUNAG, KUNWE, GSBER, EXCCD, EXCRN, EXCRG, EXCDI, EXCCO, CSTNO, LSTNO, PANNO, PREPRN, RTDAT, CVDIND, EXPIND, STATUS, CENSTAT, REJ_CODE, MRPIND, USNAM, CPUDT, CPUTM, AENAM, AEDAT, BUDAT, ADDLDATA1, ADDLDATA2, ADDLDATA3, ADDLDATA4, ADDLVAL, RULES, TCODE, REJ_ACC_DOCNO, REJ_ACC_DOCTYP, REJ_ACC_YEAR, PRECUSDAT, ACKCUSDAT, RECPTDAT, EXCSUBDAT, POEXPDAT, AMENDIND, BONDNO, BONDYR, BOAMTBAL, AMENDED_BALANCE, AMENDED_ON, EXC_ADDRESS_NO, CUS_ADDRESS_NO, INTEREST_VALUE, NCCD, ECS, EXADDTAX1, EXADDTAX2, EXADDTAX3, BELNR, GJAHR FROM J_1IEXCHDR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2TRNTYPExcise Transaction Typenvarchar40CHAR(N' ')NoJ_1ITRANJ_1ITRNTYP Allow NULL? 
3DOCYRYearnvarchar40NUMC(N'0000')NoJ_1IDOCUYR Allow NULL? 
4DOCNOInternal Excise Document Numbernvarchar100NUMC(N'0000000000')NoJ_1IDOCNO Allow NULL? 
5BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
6WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
7EXGRPExcise Groupnvarchar20CHAR(N' ')YesJ_1IEXGRPSJ_1IEXCGRP Allow NULL? 
8SRGRPExcise Document Series Groupnvarchar30CHAR(N' ')YesJ_1ISRGRPSJ_1ISERGRP Allow NULL? 
9STRTYPSub Transaction Typenvarchar20CHAR(N' ')YesJ_1ISTRTYP Allow NULL? 
10EXNUMOfficial Excise Document Numbernvarchar100CHAR(N' ')YesJ_1IEXCNUM Allow NULL? 
11EXDATExcise Document Datenvarchar80DATS(N'00000000')YesJ_1IEXCDAT Allow NULL? 
12EXYEARExcise Yearnvarchar40NUMC(N'0000')YesJ_1IEXYEAR Allow NULL? 
13REMTIMETime of Removalnvarchar60TIMS(N'000000')YesJ_1IREMTIM Allow NULL? 
14LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')YesLFA1LIFNR Allow NULL? 
15SHIPFROMAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
16RCWRKReceiving/Issuing Plantnvarchar40CHAR(N' ')YesT001WUMWRK Allow NULL? 
17EXCURCurrencynvarchar50CUKY(N' ')YesTCURCJ_1IEXCCUR Allow NULL? 
18EXBEDBasic Excise Dutydecimal132CURR((0))YesJ_1IEXCBED
19EXSEDSpecial Excise Dutydecimal132CURR((0))YesJ_1IEXCSED
20EXAEDAdditional Excise Dutydecimal132CURR((0))YesJ_1IEXCAED
21CESSCess amountdecimal132CURR((0))YesJ_1IEXCESS
22REFDOCInternal reference documentnvarchar100CHAR(N' ')YesJ_1IINTREF Allow NULL? 
23RDOCReference Document 1nvarchar100CHAR(N' ')YesJ_1IRDOC1 Allow NULL? 
24RYEARReference year 1nvarchar40CHAR(N' ')YesJ_1IRYEAR1 Allow NULL? 
25RINDReference Document Type 1char10CHAR(N' ')YesJ_1IRIND1 Allow NULL? 
26KUNAGSold-to partynvarchar100CHAR(N' ')YesKNA1KUNAG Allow NULL? 
27KUNWEShip-to partynvarchar100CHAR(N' ')YesKNA1KUNWE Allow NULL? 
28GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
29EXCCDECC Numbernvarchar400CHAR(N' ')YesJ_1IEXCD Allow NULL? 
30EXCRNExcise Registration Numbernvarchar400CHAR(N' ')YesJ_1IEXRN Allow NULL? 
31EXCRGExcise Rangenvarchar600CHAR(N' ')YesJ_1IEXRG Allow NULL? 
32EXCDIExcise Divisionnvarchar600CHAR(N' ')YesJ_1IEXDI Allow NULL? 
33EXCCOExcise Commissioneratenvarchar600CHAR(N' ')YesJ_1IEXCO Allow NULL? 
34CSTNOCentral Sales Tax Numbernvarchar400CHAR(N' ')YesJ_1ICSTNO Allow NULL? 
35LSTNOLocal Sales Tax Numbernvarchar400CHAR(N' ')YesJ_1ILSTNO Allow NULL? 
36PANNOPermanent Account Numbernvarchar400CHAR(N' ')YesJ_1IPANNO Allow NULL? 
37PREPRNPreprinted Serial Numbernvarchar100CHAR(N' ')YesJ_1IPREPRN Allow NULL? 
38RTDATReturn Datenvarchar80DATS(N'00000000')YesJ_1IRTDAT Allow NULL? 
39CVDINDCVD indicationchar10CHAR(N' ')YesJ_1ICVDIND Allow NULL? 
40EXPINDExport Typechar10CHAR(N' ')YesJ_1IINDEXP Allow NULL? 
41STATUSExcise Document Statuschar10CHAR(N' ')YesJ_1ISTATUS Allow NULL? 
42CENSTATCENVAT Utilization statuschar10CHAR(N' ')YesJ_1ICENST Allow NULL? 
43REJ_CODERejection Codenvarchar30CHAR(N' ')YesJ_1IREJMASJ_1IREJCODE Allow NULL? 
44MRPINDMaximum Retail Pricechar10CHAR(N' ')YesJ_1IMRPIND Allow NULL? 
45USNAMCreated Bynvarchar120CHAR(N' ')YesJ_1IUSNAM Allow NULL? 
46CPUDTExcise Document Entry Datenvarchar80DATS(N'00000000')YesJ_1ICPUDT Allow NULL? 
47CPUTMTime of Entrynvarchar60TIMS(N'000000')YesCPUTM Allow NULL? 
48AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
49AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
50BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
51ADDLDATA1Additional Datanvarchar600CHAR(N' ')YesJ_1IADDATA Allow NULL? 
52ADDLDATA2Additional Datanvarchar600CHAR(N' ')YesJ_1IADDATA Allow NULL? 
53ADDLDATA3Additional Datanvarchar600CHAR(N' ')YesJ_1IADDATA Allow NULL? 
54ADDLDATA4Additional Datanvarchar600CHAR(N' ')YesJ_1IADDATA Allow NULL? 
55ADDLVALAdditional Valuedecimal172CURR((0))YesJ_1IADDVAL
56RULESRule/Sectionnvarchar100CHAR(N' ')Yes*J_2IRULE Allow NULL? 
57TCODETransaction codenvarchar200CHAR(N' ')Yes*J_1ITCODE Allow NULL? 
58REJ_ACC_DOCNOAccounting Documentnvarchar100CHAR(N' ')YesJ_1IFAWREF Allow NULL? 
59REJ_ACC_DOCTYPObject type of calling application (FI)nvarchar50CHAR(N' ')Yes*J_1IFAWTYP Allow NULL? 
60REJ_ACC_YEARFinancial posting yearnvarchar40NUMC(N'0000')YesJ_1IFAYEAR Allow NULL? 
61PRECUSDATArrived at Customsnvarchar80DATS(N'00000000')YesJ_1IPRECUSDAT Allow NULL? 
62ACKCUSDATCountersignednvarchar80DATS(N'00000000')YesJ_1IACKCUSDAT Allow NULL? 
63RECPTDATArrived Backnvarchar80DATS(N'00000000')YesJ_1IRECPTDAT Allow NULL? 
64EXCSUBDATSent to Excise Departmentnvarchar80DATS(N'00000000')YesJ_1IEXCSUBDAT Allow NULL? 
65POEXPDATExport Confirmednvarchar80DATS(N'00000000')YesJ_1IPOEXPDAT Allow NULL? 
66AMENDINDchar10(N' ')Yes Allow NULL? 
67BONDNOInternal Bond Numbernvarchar100NUMC(N'0000000000')YesJ_1IBONDNO Allow NULL? 
68BONDYRFiscal Yearnvarchar40NUMC(N'0000')YesJ_1IBONDYR Allow NULL? 
69BOAMTBALBond Balancedecimal132CURR((0))YesJ_1IBOCURBAL
70AMENDED_BALANCEBED After Amendmentdecimal132CURR((0))YesJ_1IAMD_BAL
71AMENDED_ONExc Bonding: Date of Amendmentnvarchar80DATS(N'00000000')YesJ_1IAMD_DAT Allow NULL? 
72EXC_ADDRESS_NOAddressnvarchar30NUMC(N'000')YesJ_1IEDADDR_NO Allow NULL? 
73CUS_ADDRESS_NOAddressnvarchar30NUMC(N'000')YesJ_1IEDADDR_NO Allow NULL? 
74INTEREST_VALUEInterest Amountdecimal132CURR((0))YesJ_1IINTVAL
75NCCDNCCD Valuedecimal132CURR((0))YesJ_1IEXNCCD
76ECSECS Valuedecimal132CURR((0))YesJ_1IEXECS
77EXADDTAX1Additional Tax1 valuedecimal132CURR((0))YesJ_1IEXADDTAX1
78EXADDTAX2Additional Tax2 valuedecimal132CURR((0))YesJ_1IEXADDTAX2
79EXADDTAX3Additional Tax3 valuedecimal132CURR((0))YesJ_1IEXADDTAX3
80BELNRAccounting Documentnvarchar100CHAR(N' ')YesJ_1IFAWREF Allow NULL? 
81GJAHRFinancial posting yearnvarchar40NUMC(N'0000')YesJ_1IFAYEAR Allow NULL? 
NamePrimaryUniqueTypeColumns
J_1IEXCHDR~0YesYesCLUSTEREDDOCNO, DOCYR, TRNTYP, MANDT
J_1IEXCHDR~001NoNoNONCLUSTEREDLIFNR, EXDAT, EXNUM, EXGRP
J_1IEXCHDR~002NoNoNONCLUSTEREDRIND, RYEAR, RDOC, MANDT
J_1IEXCHDR~003NoNoNONCLUSTEREDDOCNO, DOCYR, MANDT
J_1IEXCHDR~004NoNoNONCLUSTEREDLIFNR, EXYEAR, EXNUM, MANDT
J_1IEXCHDR~005NoNoNONCLUSTEREDLIFNR, EXYEAR, EXNUM, TRNTYP, 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