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  | TTEPD3_USITEM
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
Application Platform :: Transaction Tax Engine
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TTEPD3_USITEM941Persistency TTE Document UsItemTransaction Tax Engine
SQL:  selectupdate insert create

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

SELECT CLIENT, TTEDOCUMENTID, ITEMID, COMP_CODE, DIVISION, COUNTRY, DOC_NUMBER, POS_NO, ACCNT_NO, ACCNT_CLS, TAX_DATE, REP_DATE, TXJCD_ST, TXJCD_SF, TXJCD_POA, TXJCD_POO, TXJCD_IND, PTP_IND, APAR_IND, TXJCD_L1, TXJCD_L2, TXJCD_L3, TXJCD_L4, TAX_TYPE, MATNR, PROD_CODE, QUANTITY, UNIT, AMOUNT, CURRENCY, CURR_DEC, FREIGHT_AM, EXEMPT_AMT, EXEMPT_IND, CREDIT_IND, UPDATE_IND, OVWRT_IND, TAXPCT0, TAXPCT1, TAXPCT2, TAXPCT3, TAXPCT4, TAXPCT5, TAXPCT6, TAXPCT7, TAXPCT8, TAXPCT9, TAXPCOV, TAXAMT0, TAXAMT1, TAXAMT2, TAXAMT3, TAXAMT4, TAXAMT5, TAXAMT6, TAXAMT7, TAXAMT8, TAXAMT9, TAXAMOV, TAXBAS0, TAXBAS1, TAXBAS2, TAXBAS3, TAXBAS4, TAXBAS5, TAXBAS6, TAXBAS7, TAXBAS8, TAXBAS9, EXMATFLG, EXCUSFLG, EXAMT0, EXAMT1, EXAMT2, EXAMT3, EXAMT4, EXAMT5, EXAMT6, EXAMT7, EXAMT8, EXAMT9, EXCODE0, EXCODE1, EXCODE2, EXCODE3, EXCODE4, EXCODE5, EXCODE6, EXCODE7, EXCODE8, EXCODE9, EXCERTIF, EXREASON, USER_DATA FROM TTEPD3_USITEM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2TTEDOCUMENTIDTTE Document IDvarbinary160RAWNoTTET_TTEDOCUMENTID_PD
3ITEMIDItem Identifiernvarchar320CHAR(N' ')NoTTET_ITEMID_COM_PD Allow NULL? 
4COMP_CODECompany Codenvarchar40CHAR(N' ')YesTTET_USBUKRS_COM Allow NULL? 
5DIVISIONBusiness Area/Division Codenvarchar40CHAR(N' ')YesTTET_USDIVISION_COM Allow NULL? 
6COUNTRYTax Departure Countrynvarchar30CHAR(N' ')YesTTET_USLANDTX_COM Allow NULL? 
7DOC_NUMBERDocument No.nvarchar100CHAR(N' ')YesTTET_USBELNR_D_COM Allow NULL? 
8POS_NOTax document item numbernvarchar60NUMC(N'000000')YesTTET_USTAXPOSNR_COM Allow NULL? 
9ACCNT_NOExternal Partner Numbernvarchar160CHAR(N' ')YesTTET_USTAX_XACCNT_COM Allow NULL? 
10ACCNT_CLSTaxable Partner Classificationnvarchar100CHAR(N' ')YesTTET_USTAX_XACCNTCLS_COM Allow NULL? 
11TAX_DATEDate of Tax Calculationnvarchar80CHAR(N' ')YesTTET_USTAX_XDATE_COM Allow NULL? 
12REP_DATEDate for Tax Reportingnvarchar80CHAR(N' ')YesTTET_USTAX_XREPDAT_COM Allow NULL? 
13TXJCD_STJurisdiction codenvarchar150CHAR(N' ')YesTTET_USTXJCD_COM Allow NULL? 
14TXJCD_SFJurisdiction codenvarchar150CHAR(N' ')YesTTET_USTXJCD_COM Allow NULL? 
15TXJCD_POAJurisdiction codenvarchar150CHAR(N' ')YesTTET_USTXJCD_COM Allow NULL? 
16TXJCD_POOJurisdiction codenvarchar150CHAR(N' ')YesTTET_USTXJCD_COM Allow NULL? 
17TXJCD_INDIndicator: Tax Jurisdictionchar10CHAR(N' ')YesTTET_USTAX_XTXJCDIND_COM Allow NULL? 
18PTP_INDIndicator: Space for Title Transferchar10CHAR(N' ')YesTTET_USTAX_XPTPIND_COM Allow NULL? 
19APAR_INDInd.: Transaction on Debit/Credit Sidechar10CHAR(N' ')YesTTET_USTAX_XAPARIND_COM Allow NULL? 
20TXJCD_L1Two digit numbernvarchar20NUMC(N'00')YesTTET_USNUMC2_COM Allow NULL? 
21TXJCD_L2Two digit numbernvarchar20NUMC(N'00')YesTTET_USNUMC2_COM Allow NULL? 
22TXJCD_L3Two digit numbernvarchar20NUMC(N'00')YesTTET_USNUMC2_COM Allow NULL? 
23TXJCD_L4Two digit numbernvarchar20NUMC(N'00')YesTTET_USNUMC2_COM Allow NULL? 
24TAX_TYPEIndicator: Tax Category (Sales/Rental/Use/Lease)char10CHAR(N' ')YesTTET_USTAX_XTYPE_COM Allow NULL? 
25MATNRCalling System Material Numbernvarchar180CHAR(N' ')YesTTET_USTAX_XMATNR_COM Allow NULL? 
26PROD_CODETaxable Product Classificationnvarchar100CHAR(N' ')YesTTET_USTAX_XPRODCODE_COM Allow NULL? 
27QUANTITYTaxable Quantitynvarchar130CHAR(N' ')YesTTET_USTAX_XQUANTITY_COM Allow NULL? 
28UNITTax Base Unit of Measurenvarchar30CHAR(N' ')YesTTET_USTAX_XUNIT_COM Allow NULL? 
29AMOUNTTax Base Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XBASE_COM Allow NULL? 
30CURRENCYTax currencynvarchar50CHAR(N' ')YesTTET_USTAX_XCURR_COM Allow NULL? 
31CURR_DECNo. of Decimal Places for Tax Reporting Currencynvarchar30CHAR(N' ')YesTTET_USTAX_XCURRDEC_COM Allow NULL? 
32FREIGHT_AMFreight Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XFRAMOUNT_COM Allow NULL? 
33EXEMPT_AMTTax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
34EXEMPT_INDIndicator: Tax Exemptionchar10CHAR(N' ')YesTTET_USTAX_XEXEMPTFLG_COM Allow NULL? 
35CREDIT_INDIndicator: Tax Credit Memochar10CHAR(N' ')YesTTET_USTAX_XCREDFLG_COM Allow NULL? 
36UPDATE_INDIndicator: Update Calling Systemchar10CHAR(N' ')YesTTET_USTAX_XUPDFLG_COM Allow NULL? 
37OVWRT_INDIndicator: Overwriting A Calling Systemchar10CHAR(N' ')YesTTET_USTAX_XOVRFLG_COM Allow NULL? 
38TAXPCT0Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
39TAXPCT1Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
40TAXPCT2Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
41TAXPCT3Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
42TAXPCT4Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
43TAXPCT5Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
44TAXPCT6Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
45TAXPCT7Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
46TAXPCT8Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
47TAXPCT9Tax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
48TAXPCOVTax Percentage Ratenvarchar150CHAR(N' ')YesTTET_USTAX_XPERCENT_COM Allow NULL? 
49TAXAMT0Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
50TAXAMT1Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
51TAXAMT2Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
52TAXAMT3Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
53TAXAMT4Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
54TAXAMT5Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
55TAXAMT6Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
56TAXAMT7Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
57TAXAMT8Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
58TAXAMT9Tax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
59TAXAMOVTax Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XAMOUNT_COM Allow NULL? 
60TAXBAS0Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
61TAXBAS1Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
62TAXBAS2Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
63TAXBAS3Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
64TAXBAS4Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
65TAXBAS5Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
66TAXBAS6Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
67TAXBAS7Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
68TAXBAS8Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
69TAXBAS9Tax Base Amount From Calling Systemnvarchar150CHAR(N' ')YesTTET_USTAX_XBASAMT_COM Allow NULL? 
70EXMATFLGTax Exemption Code Materialnvarchar20CHAR(N' ')YesTTET_USTAX_XEXMAT_COM Allow NULL? 
71EXCUSFLGTax Exemption Code Business partnernvarchar20CHAR(N' ')YesTTET_USTAX_XEXCUS_COM Allow NULL? 
72EXAMT0Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
73EXAMT1Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
74EXAMT2Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
75EXAMT3Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
76EXAMT4Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
77EXAMT5Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
78EXAMT6Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
79EXAMT7Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
80EXAMT8Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
81EXAMT9Tax Exemption Amountnvarchar150CHAR(N' ')YesTTET_USTAX_XEXAMOUNT_COM Allow NULL? 
82EXCODE0Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
83EXCODE1Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
84EXCODE2Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
85EXCODE3Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
86EXCODE4Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
87EXCODE5Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
88EXCODE6Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
89EXCODE7Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
90EXCODE8Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
91EXCODE9Code for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
92EXCERTIFTax Exemption Certificatenvarchar250CHAR(N' ')YesTTET_USTAX_XEXCERT_COM Allow NULL? 
93EXREASONCode for Tax Exemptionnvarchar20CHAR(N' ')YesTTET_USTAX_XEXCODE_COM Allow NULL? 
94USER_DATAUser-Specific Datanvarchar500CHAR(N' ')YesTTET_USTAX_XUSERDAT_COM Allow NULL? 
NamePrimaryUniqueTypeColumns
TTEPD3_USITEM~0YesYesCLUSTEREDCLIENT, TTEDOCUMENTID, ITEMID

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