J_3RF_VAT_ANALYSIS SAP (VAT analysis report ALV structure) Structure details

Dictionary Type: Structure
Description: VAT analysis report ALV structure




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




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

J_3RF_VAT_ANALYSIS 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 "VAT analysis report ALV 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_3RF_VAT_ANALYSIS TYPE J_3RF_VAT_ANALYSIS.

The J_3RF_VAT_ANALYSIS table consists of various fields, each holding specific information or linking keys about VAT analysis report ALV structure data available in SAP. These include HKONT (General Ledger Account), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BLART (Document Type).. 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_3RF_VAT_ANALYSIS 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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
BUDATPosting Date in the Document BUDATDATS8DATUM
BLDATDocument Date in Document BLDATDATS8DATUM
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
VATDATETax Reporting Date VATDATEDATS8DATUM
STBLG_INVReverse Document Number STBLGCHAR10ALPHABELNR
XREF1Business partner reference key XREF1CHAR12CHAR12
BELNR_TTDAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BLART_TTDDocument Type BLARTCHAR2Assigned to domainBLARTBAR
BUDAT_TTDPosting Date in the Document BUDATDATS8DATUM
BLDAT_TTDDocument Date in Document BLDATDATS8DATUM
GJAHR_TTDFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
WAERS_TTDCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
VATDATE_TTDTax Reporting Date VATDATEDATS8DATUM
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
MWSKZ_TARGETTarget Tax Code (for Deferred Tax) DZMWSKCHAR2Assigned to domainMWSKZ
STBLGReverse Document Number STBLGCHAR10ALPHABELNR
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
HWBASTax Base Amount in Local Currency HWBASCURR13(2) WERT7
FWBASTax Base Amount in Document Currency FWBASCURR13(2) WERT7
INCOM_BALANCEIncoming VAT Balance J_3RF_INCOME_VATCURR15(2) WERTV8
DEBIT_TURNOVVAT Debit Posting in Current Fiscal Period J_3RF_DEB_TURN_VATCURR15(2) WERTV8
CREDIT_TURNOVVAT Credit Posting in Current Fiscal Period J_3RF_CRD_TURN_VATCURR15(2) WERTV8
OUT_BALANCEOutgoing VAT Balance J_3RF_END_BAL_VATCURR15(2) WERTV8
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
INNTax Number 1 STCD1CHAR16STCD1
KPPTax Number 3 STCD3CHAR18CHAR18
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
EXT_NUMExternal Document Number J_3RF_EXT_NUMBERCHAR50TEXT50
EXT_DATEContract date J_3RS_CDATEDATS8DATE
EXTCNUMExternal Contract Number J_3RF_EXTCNTNUMCHAR40Assigned to domainJ_3RF_EXTCNTNUMJ_3RF_CNT_SH
CNTDATEContract Date J_3RF_CNTDATDATS8DATUM
DP_BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
DP_GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
XBLNRReference Document Number XBLNRCHAR16XBLNR
ZUONRAssignment Number DZUONRCHAR18ZUONR
MWSKZ_TEXTName for value-added tax TEXT1_007SCHAR50TEXT50

Key field Non-key field



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

As J_3RF_VAT_ANALYSIS 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_3RF_VAT_ANALYSIS as there is no data to select.

How to access SAP table J_3RF_VAT_ANALYSIS

Within an ECC or HANA version of SAP you can also view further information about J_3RF_VAT_ANALYSIS 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!