J_3R_PTAX_EXT2 SAP (Group-key2 Extended Property Tax Structure) Structure details

Dictionary Type: Structure
Description: Group-key2 Extended Property Tax Structure




ABAP Code to SELECT data from J_3R_PTAX_EXT2
Related tables to J_3R_PTAX_EXT2
Access table J_3R_PTAX_EXT2




Structure field list including key, data, relationships and ABAP select examples

J_3R_PTAX_EXT2 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Group-key2 Extended Property Tax Structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_J_3R_PTAX_EXT2 TYPE J_3R_PTAX_EXT2.

The J_3R_PTAX_EXT2 table consists of various fields, each holding specific information or linking keys about Group-key2 Extended Property Tax Structure data available in SAP. These include GR_REGION (Region), GR_DISTRICT (District), GRKEY4 (), GR_BUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_3R_PTAX_EXT2 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
GRTITLE 0
GR_REGIONRegion J_3RFREGIONCHAR5CHAR5
GR_DISTRICTDistrict J_3RFDISTRICTCHAR5CHAR5
GRKEY4 0
GR_BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
GR_STRUCT_DIVStructural Division Name J_3RSTRUCTDIVCHAR80TXT80
GR_OKATOOKATO Code J_3R_OKATOCHAR12
GR_PRIVILEGEFederal Property Tax Concession J_3RFOFPRIVILEGECHAR10CHAR10
GR_TRATEProperty Tax Rate J_3RFPROPTAXRATEDEC8(5) J_3RFPROPTAXRATE
GR_PROPTYPEProperty Type J_3RFPROPTYPECHAR1CHAR1
MANDTClient MANDTCLNT3Assigned to domainMANDT
TAX_TYPETax Type J_3R_TAX_TYPECHAR1J_3R_TAX_TYPE
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
OKATOOKATO Code J_3R_OKATOCHAR12
STRUCT_DIVInternal Code of Structural Division J_3R_STRUCTDIV_INTCHAR40CHAR40
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
VERSIONVersion Of The Transport Tax Entry J_3R_TTAX_VERCHAR5
LIGHTTemporary delivery status during wave creation ICON_4CHAR4ICON_4
TAX01Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX02Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX03Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX04Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX05Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX06Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX07Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX08Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX09Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX10Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX11Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TAX12Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
STATUSStatus of The Transport Tax Entry J_3R_TTAX_STATCHAR1J_3R_TTAX_STATUS
LAST_DECLAREDIndicator If This Entry Is The Last Declared Entry J_3R_FATAX_DECLCHAR1
CREATED_ONField of type DATS DATSDATS8DATS
CALC_IDIdentifier name of the Saved Transport Tax Entry J_3R_TTAX_IDCHAR30CHAR30
DECL_01Field of type DATS DATSDATS8DATS
DECL_NUM1Tax Return Document Number J_3R_DECL_NUMCHAR10
DECL_02Field of type DATS DATSDATS8DATS
DECL_NUM2Tax Return Document Number J_3R_DECL_NUMCHAR10
DECL_03Field of type DATS DATSDATS8DATS
DECL_NUM3Tax Return Document Number J_3R_DECL_NUMCHAR10
DECL_04Field of type DATS DATSDATS8DATS
DECL_NUM4Tax Return Document Number J_3R_DECL_NUMCHAR10
NBV01Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV02Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV03Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV04Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV05Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV06Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV07Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV08Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV09Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV10Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV11Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV12Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV13Monthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
VALID_MONTHNumber of Valid Months with Respect To The Tax J_3R_VALID_MONTHNUMC2
ASSETNAMEAsset Description and Additional Description J_3R_ASSET_DESCCHAR100TEXT100
TTAX01_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX02_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX03_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX04_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX05_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX06_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX07_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX08_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX09_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX10_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX11_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX12_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
TTAX_RATETransport Tax Rate J_3RTVALDEC8(2)
BRANDVehicle Brand J_3R_BRANDCHAR120CHAR120
TAX_SUMAnnual Tax Amount J_3R_TAX_SUMCURR17(5)
PRIVILEGEProperty Tax Reduction J_3RFPRIVILEGECHAR4CHAR04
AMOUNTREDProperty tax amount reduction code J_3RFAMOUNTREDCHAR4CHAR04
EXEMPTIONProperty Tax Exemption Code J_3RFEXEMPTIONCHAR4CHAR04
CNOTXTransport Tax Exemption Code J_3RTNOTXCHAR5
CPRTXTransport Tax Reduction Code J_3RTPREFCHAR5
USAGE_YEARSTerm of Use J_3R_TERMCHAR3
TAX_COEFFTax Coefficient J_3R_USE_COEFFDEC3(2) DEC1_2
PTAX_YEARMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
GLO_RUS_DEPGRDepreciation Group J_3RFAMORTGRCHAR4J_3RFDEPRGROUPORD4X
GLO_RUS_OKOFOKOF Code J_3RFOKOFCHAR9J_3RFTOKOFCHAR009
GLO_RUS_SERNRSerial Number J_3RFSERNRCHAR32CHAR32
GLO_RUS_PRECCTPrecious materials codes J_3RPRECCCHAR30CHAR30
GLO_RUS_PRECQQuantities list of countable precious materials J_3RPRECQCHAR40CHAR40
GLO_RUS_PRECWWeights list of precious materials J_3RPRECWCHAR50
GLO_RUS_TTX_TYPETransport Type J_3RTYPVCHAR5J_3RTTYPVEH
GLO_RUS_TTX_VINManufacturer Vehicle Identification Number for Fleet Object FLEET_VINCHAR30FLEET_VIN
GLO_RUS_TTX_MNFDManufacturing Date J_3RTBAUJJDATS8
GLO_RUS_TTX_ECOCLASSEcological Class J_3R_ECOCLASSNUMC1NUMC1
GLO_RUS_ECOCLASSEcological Class J_3R_ECOCLASSNUMC1NUMC1
GLO_RUS_ECO_CLSEcological Class J_3R_ECO_CLSCHAR1J_3R_ECO_CLS
GLO_RUS_PRT_TYPEProperty Type J_3RFPROPTYPECHAR1J_3RFPROPTYPESCHAR1
ADATUDate for beginning of validity ADATUDATS8DATUMADT
BDATUDate validity ends BDATUDATS8DATUM
AIMMOIndicator: real estate AIMMONUMC1AIMMO
OFPRIV1Federal Property Tax Concession J_3RFOFPRIVILEGECHAR10CHAR10
OFPRIV2Federal Property Tax Concession J_3RFOFPRIVILEGECHAR10CHAR10
RATEProperty Tax Rate J_3RFPROPTAXRATEDEC8(5) J_3RFPROPTAXRATE
KBKKBK Code For Non-UGSS Asset J_3R_KBKCHAR20
REGIONRegion J_3RFREGIONCHAR5CHAR5
DISTRICTDistrict J_3RFDISTRICTCHAR5CHAR5
AVGNBVProperty Tax Average Net Book Value J_3R_PTAX_AVGNBVCURR17(5)
INVNRInventory number INVNRCHAR25INVNR_ANLA
DECL_NUMTax Return Document Number J_3R_DECL_NUMCHAR10
CORR_NUM Number of the Correction of the Same Declaration0
HERSTManufacturer of asset HERSTCHAR30TEXT30
TAX_AUTH_CODETax Office Code J_3R_TAX_AUTHCHAR4
KPPKPP Number of Reporting Company J_3R_KPPCHAR9TEXT9
NBV01_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV02_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV03_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV04_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV05_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV06_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV07_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV08_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV09_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV10_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV11_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV12_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
NBV13_ORIGMonthly Transport Tax Amount For J_3R_TTAX_AMNTCURR17(5)
EXEMP_LAWLaw Article for Exemption Code J_3RFEXEMPLAWCHAR12CHAR12
PRVG_LAWLaw Article for Reduction Code J_3RFPRVGLAWCHAR12CHAR12
AMTR_LAWLaw Article for Amount Reduction Code J_3RFAMTRLAWCHAR12CHAR12

Key field Non-key field



How do I retrieve data from SAP structure J_3R_PTAX_EXT2 using ABAP code?

As J_3R_PTAX_EXT2 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J_3R_PTAX_EXT2 as there is no data to select.

How to access SAP table J_3R_PTAX_EXT2

Within an ECC or HANA version of SAP you can also view further information about J_3R_PTAX_EXT2 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!