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_1UF_TAX_MAIN
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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
1ERP EHP76.0J_1UF_TAX_MAIN261Tax Declaration and Clarification Declaration
SQL:  selectupdate insert create

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

SELECT MANDT, ID, COMPANY_CODE, TAX_GROUP, BUSINESS_AREA, PROFIT_CENTER, FISCAL_YEAR, FISCAL_PERIOD, RETURN_TYPE, CLAR_YEAR, CLAR_PERIOD, RUN_ID, RUN_DATE, REPORT_DOC_NUM, PERIOD_DOC_NUM, SUBMISSION_DATE, IN_DECL_FLAG, AMOUNT_23_1, PENALTY_AMOUNT, CLAR_TYPE, MARK_ERROR_CORR, COPY_OF_REGISTRY, MARK_QUAL_CALC, ANNEX_INFREEFORM, ANNEX_INFREETEXT, NO_ORIGCUSTDECL FROM J_1UF_TAX_MAIN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2IDTax Return Maintenance IDnvarchar100NUMC(N'0000000000')NoJ_1UF_TAX21_ID Allow NULL? 
3COMPANY_CODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
4TAX_GROUPSales/Purchases Tax Groupnvarchar40CHAR(N' ')Yes*UMKRS Allow NULL? 
5BUSINESS_AREABusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
6PROFIT_CENTERProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
7FISCAL_YEARFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
8FISCAL_PERIODFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
9RETURN_TYPEVAT Return Typenvarchar30CHAR(N' ')YesJ_1UD011012 Allow NULL? 
10CLAR_YEARClarification Yearnvarchar40NUMC(N'0000')YesJ_1UF_TAX21_CLAR_YEAR Allow NULL? 
11CLAR_PERIODClarification Periodnvarchar20NUMC(N'00')YesJ_1UF_TAX21_CLAR_PERIOD Allow NULL? 
12RUN_IDAdditional Identificationnvarchar60CHAR(N' ')YesLAUFI Allow NULL? 
13RUN_DATEDate on Which the Program Is to Be Runnvarchar80DATS(N'00000000')YesLAUFD Allow NULL? 
14REPORT_DOC_NUMIdentical Document Numbernvarchar20NUMC(N'00')YesJ_1UF_IDENT_DOCNUM Allow NULL? 
15PERIOD_DOC_NUMCorrection Document Numbernvarchar70NUMC(N'0000000')YesJ_1UF_CORR_DOC_NUM Allow NULL? 
16SUBMISSION_DATEDate of Tax Return Submissionnvarchar80DATS(N'00000000')YesJ_1UF_TAX21_SUBMISSION_DATE Allow NULL? 
17IN_DECL_FLAGTransfer of Remaining Clarification Amountchar10CHAR(N' ')YesJ_1UF_TAX21_DECL_FLAG Allow NULL? 
18AMOUNT_23_1Amount of Refund to Payer's Account (Line 23.1)decimal132CURR((0))YesJ_1UF_TAX21_AMOUNT_23_1
19PENALTY_AMOUNTTax Return Clarification Penalty (Line 26)decimal132CURR((0))YesJ_1UF_TAX21_PENALTY_AMOUNT
20CLAR_TYPEClarification Typechar10CHAR(N' ')YesJ_1UF_TAX21_CLAR_TYPE Allow NULL? 
21MARK_ERROR_CORRMark Error Correctionchar10CHAR(N' ')YesJ_1UFERRCORR Allow NULL? 
22COPY_OF_REGISTRYCopy of Registry in Electronic Formchar10CHAR(N' ')YesJ_1UFCOPYREG Allow NULL? 
23MARK_QUAL_CALCMark Qualifying Calculationschar10CHAR(N' ')YesJ_1UFQUALCALC Allow NULL? 
24ANNEX_INFREEFORMAnnex in Free Formchar10CHAR(N' ')YesJ_1UFFREEANNEX Allow NULL? 
25ANNEX_INFREETEXTFreeform Text for Annexnvarchar700CHAR(N' ')YesJ_1UFTAX21_HJAR Allow NULL? 
26NO_ORIGCUSTDECLNo. of Original Customs Declaration (Page 5)nvarchar50NUMC(N'00000')YesJ_1UFCUSTDECLPAGE5 Allow NULL? 
NamePrimaryUniqueTypeColumns
J_1UF_TAX_MAIN~0YesYesCLUSTEREDID, 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