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  | FIKZD_TRTAX
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
1ERP EHP76.0FIKZD_TRTAX471Transport tax Kazakstan
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, ANLN1, ANLN2, GJAHR, REG_DATE, TTAX_TYPE, LAUFI, CANC_DATE, CTYPV, POWER, UNITP, KOEFU, THRES, TAXVL, CORCOFF, FULLT, ADVP, TAX_TO_PAY, EXCEEDRATE, EXCEEDBASE, EXCEEDTAX, WAERS, TXT50, LICENSE_NUM, FLEET_VIN, CONSTR_DATE, CNOTX, CPRTX, DTBRA, DTBRB, ANLKL, KOSTL, WERKS, STORT, CAUFN, PERNR, OKATO, REGION, DISTRICT, ITEM_DECL, INVNR, LIFNR, DEPONUSLF, MONTX, LIGHT, ERRCM FROM FIKZD_TRTAX
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3ANLN1Main Asset Numbernvarchar120CHAR(N' ')NoANLHANLN1 Allow NULL? 
4ANLN2Asset Subnumbernvarchar40CHAR(N' ')NoANLAANLN2 Allow NULL? 
5GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
6REG_DATERegistration Datenvarchar80DATS(N'00000000')NoJ_3RTREG Allow NULL? 
7TTAX_TYPETransport tax declaration typechar10NUMC(N'0')NoFIKZ_TTAX_TYPE Allow NULL? 
8LAUFIAdditional Identificationnvarchar60CHAR(N' ')NoLAUFI Allow NULL? 
9CANC_DATECancellation Datenvarchar80DATS(N'00000000')YesJ_3RTREM Allow NULL? 
10CTYPVTransport Typenvarchar50CHAR(N' ')YesJ_3RTYPV Allow NULL? 
11POWERTax base of transportdecimal133QUAN((0))YesJ_3RTTAXBASE
12UNITPTax base unitnvarchar30UNIT(N' ')Yes*J_3RTTAXUNIT Allow NULL? 
13KOEFUTax coefficientnvarchar70CHAR(N' ')YesJ_3RTKOEFU Allow NULL? 
14THRESTax Base (Low bound)decimal132QUAN((0))YesFIKZ_TT_LBASE
15TAXVLTransport Tax Ratedecimal82DEC((0))YesJ_3RTVAL
16CORCOFFCorrection coefficientdecimal63DEC((0))YesFIKZ_TTCORCOFF
17FULLTFull amount of taxdecimal152CURR((0))YesJ_3RTFULTX
18ADVPAdvance payment 1th Julydecimal152CURR((0))YesFIKZ_TT_ADVP
19TAX_TO_PAYTax Amount (To be paid)decimal152CURR((0))YesFIKZ_TT_TO_PAY
20EXCEEDRATEIncrease amount for each unit above the bounddecimal82DEC((0))YesFIKZ_TTEXCEEDRATE
21EXCEEDBASETax base unit above the bounddecimal133QUAN((0))YesFIKZ_TTEXCEEDBASE
22EXCEEDTAXTransport Tax amount above the bounddecimal152CURR((0))YesFIKZ_TTEXCEEDTRTAX
23WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
24TXT50Asset descriptionnvarchar500CHAR(N' ')YesTXA50_ANLT Allow NULL? 
25LICENSE_NUMLicense plate numbernvarchar150CHAR(N' ')YesLICENSE_NUM Allow NULL? 
26FLEET_VINManufacturer Vehicle Identification Number for Fleet Objectnvarchar300CHAR(N' ')YesFLEET_VIN Allow NULL? 
27CONSTR_DATEManufacturing Datenvarchar80DATS(N'00000000')YesJ_3RTBAUJJ Allow NULL? 
28CNOTXTransport Tax Exemption Codenvarchar50CHAR(N' ')YesFIKZ_TT_NOTX Allow NULL? 
29CPRTXTransport Tax Reduction Codenvarchar50CHAR(N' ')YesFIKZ_TT_PREF Allow NULL? 
30DTBRADate Stolennvarchar80DATS(N'00000000')YesJ_3RTDTBRA Allow NULL? 
31DTBRBReturn Datenvarchar80DATS(N'00000000')YesJ_3RTDTBRB Allow NULL? 
32ANLKLAsset Classnvarchar80CHAR(N' ')Yes*ANLKL Allow NULL? 
33KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
34WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
35STORTAsset locationnvarchar100CHAR(N' ')Yes*STORT Allow NULL? 
36CAUFNInternal ordernvarchar120CHAR(N' ')Yes*CAUFN Allow NULL? 
37PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
38OKATOOKATO Codenvarchar120CHAR(N' ')YesJ_3R_OKATO Allow NULL? 
39REGIONRegionnvarchar50CHAR(N' ')YesJ_3RFREGION Allow NULL? 
40DISTRICTDistrictnvarchar50CHAR(N' ')YesJ_3RFDISTRICT Allow NULL? 
41ITEM_DECLLine item in Tax declarationnvarchar150CHAR(N' ')YesFIKZ_ITEM_DECL Allow NULL? 
42INVNRInventory numbernvarchar250CHAR(N' ')YesINVNR Allow NULL? 
43LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
44DEPONUSLFRate depends on vehicle agechar10CHAR(N' ')YesJ_3RTDEPONUSLF Allow NULL? 
45MONTXValidity in Monthsnvarchar20NUMC(N'00')YesFIKZ_TT_MONTHS Allow NULL? 
46LIGHTTemporary delivery status during wave creationnvarchar40CHAR(N' ')YesICON_4 Allow NULL? 
47ERRCMError commentnvarchar1000CHAR(N' ')YesJ_3RTERRCM Allow NULL? 
NamePrimaryUniqueTypeColumns
FIKZD_TRTAX~0YesYesCLUSTEREDLAUFI, TTAX_TYPE, REG_DATE, GJAHR, ANLN2, ANLN1, BUKRS, 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