J_3RFSEC_ITEM SAP table for - Data for Secondary events for deferred tax

Table of Contents

Here we would like to draw your attention to J_3RFSEC_ITEM table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_3RFSEC_ITEM is a SAP standard transp table used for storing Data for Secondary events for deferred tax related data in SAP. It comes under the package J3RF.

SAP J_3RFSEC_ITEM table

Table J_3RFSEC_ITEM technical data

Table	J_3RFSEC_ITEM
Data storing	Data for Secondary events for deferred tax
Module	FI
Sub Module	FI-LOC
SAP Package	J3RF
Delivery Class	A – Application table (master and transaction data)
Component	SAP_FIN
Table Category	TRANSP

SAP J_3RFSEC_ITEM Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_3RFSEC_ITEM table.

MANDT : Client
Its a key field. Its data type is CLNT (Character with length 3) with field length 3

BUKRS : Company Code
Its a key field. Its data type is CHAR (Character String) with field length 4

BELNR : Accounting Document Number
Its a key field. Its data type is CHAR (Character String) with field length 10

GJAHR : Fiscal Year
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4

BUZEI : Number of Line Item Within Accounting Document
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3

ZBUKR : Company Code
Its a key field. Its data type is CHAR (Character String) with field length 4

ZBELN : Accounting Document Number
Its a key field. Its data type is CHAR (Character String) with field length 10

ZGJAH : Fiscal Year
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4

ZBUZE : Number of Line Item Within Accounting Document
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3

CBELN : Clearing document number
Its a key field. Its data type is CHAR (Character String) with field length 10

CGJAH : Clearing document fiscal year
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4

CBUZE : Number of Line Item Within Accounting Document
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3

MWSKZ : Tax on sales/purchases code
Its data type is CHAR (Character String) with field length 2

MWSKZ_TO : Target Tax Code (for Deferred Tax)
Its data type is CHAR (Character String) with field length 2

SHKZG : Debit/Credit Indicator
Its data type is CHAR (Character String) with field length 1

HKONT : General Ledger Account
Its data type is CHAR (Character String) with field length 10

HKONT_TO : General Ledger Account
Its data type is CHAR (Character String) with field length 10

LIFNR : Account Number of Vendor or Creditor
Its data type is CHAR (Character String) with field length 10

KUNNR : Customer Number
Its data type is CHAR (Character String) with field length 10

KBETR : Tax Rate
Its data type is CURR (Currency Field) with field length 11

HWBTR : Gross Amount in Local Currency
Its data type is CURR (Currency Field) with field length 15

FWBTR : Gross Amount in Document Currency
Its data type is CURR (Currency Field) with field length 15

HWBAS : Tax Base Amount in Local Currency
Its data type is CURR (Currency Field) with field length 15

FWBAS : Tax base amount in document currency
Its data type is CURR (Currency Field) with field length 15

HWSTE : Tax Amount in Local Currency
Its data type is CURR (Currency Field) with field length 13

FWSTE : Tax Amount in Document Currency
Its data type is CURR (Currency Field) with field length 13

LWAER : Country currency
Its data type is CUKY (Currency key for a currency field) with field length 5

XAUSG : Relevant Document Has Been Cleared
Its data type is CHAR (Character String) with field length 1

STMD1 : Date from which Advance Tax Reporting Must Be Executed
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

STMD2 : Date on Which the Tax Return Was Made
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

STMT2 : Time of Program Run for the Tax Return
Its data type is CHAR (Character String) with field length 6

UMSKZ : Special G/L Indicator
Its data type is CHAR (Character String) with field length 1

TBELN : Tax transfer document
Its data type is CHAR (Character String) with field length 10

TGJAH : Transfer document fiscal year
Its data type is NUMC (Character String with Digits Only) with field length 4

RBELN : Tax transfer reversal document
Its data type is CHAR (Character String) with field length 10

RGJAH : Reversal document year
Its data type is NUMC (Character String with Digits Only) with field length 4

LINE_TYPE : Line category
Its data type is CHAR (Character String) with field length 2

REFERENCE : Reference Field
Its data type is CHAR (Character String) with field length 20

EVENT : Secondary Event Type
Its data type is CHAR (Character String) with field length 2

J_3RFSEC_ITEM related tables

J_3RFOKATO : Classifier of the administrative and territorial division
J_3RFGTDMATT : Define Material Movement Types for Customs Decl. Tracking
J_3RFDI_ARC : Table for archiving and logging digital invoices
J_3RFBS_EXCODES : Exteranl codes for FSV-items
J_3RF_SURP_SW : Customizing for surplus price switching
J_3RFBS_XMLDELT : Balance sheet forms: XML-tags to be removed:Text table
J_3RF_TP_FORG : Foreign organization data for transfer pricing
J_3RTAXOPT : Operation Code Names
J_3RSL_BK_HTABL : Table head for EXTRACT
J_3RF_DI_CCOP : Assign Electronic ID to Company Code (new)
J_3RFBS_VERSION : Financial Statement versions used in balance sheet forms
J_3RF_TP_SCRS : Select options for accounts
J_3RF_REGCUS_OUT : Customizing for Outgoing Invoice Registration Journal
J_3RF_DI_PVEND : Assign Electronic ID to Vendor
J_3RF_DI_OCCODE : Assign Operator to Company Code
J_3RFDI_DEADLINE : Deadline for Digital Invoices
J_3RFDEPRGROUPT : Depreciation gropus descriptions of fixed asset Russia
J_3RF_PRECMETT : Precious materials (metals and diamonds) for assets
J_3RF_SURP_PRICE : Market prices for inventory surplus (Russia)
J_3RFPRTXPRIV : Property tax priviliges

J_3RFSEC_ITEM related transaction codes under SAP package J3RF

J3RTAXTEST : Print Sample VAT Returns (Russia)
J3RFREGINVK : Vendor Invoice Journal (Russia)
J3RFTPTRANPCV : Transaction participant codes
J3RFKSLD : Vendor Turnover Balance Sheet
J3RTAX21 : VAT Return (Russia)
J3RFTRPRSEL : Transfer Pricing Document Selection
J3RFPURB : Purchase Ledger (Russia)
J3RFCASH15 : Cash Journal Reports (Russia)
J3RFTPFORGV : Foreign organization data
J3RSSEPINCVAT : Separate Input VAT
S_EBS_44000455 : J_3RF_ACCOUNTING_STATEMENT
J3RFTAXAMTEST : Tax Depreciation Report (Russia)
J3RFTAXFINREZLIST : Gains and Losses (Russia)
J3RFTPTRANSTV : Transaction types
J3RFSELB : Sales Ledger (Russia)
J3RFINVTARG : Redetermination of Invoices (Russia)
J3RTSEMAINT : Secondary Events Table Maintenance
J3RFOCCODE : Assign Electronic IDs to Operators
J3RFBAL01 : Balance Sheet Analysis (Russia)
J3RFACC16 : 16th account distribution

J_3RFSEC_ITEM SAP table for – Data for Secondary events for deferred tax

Table J_3RFSEC_ITEM technical data

SAP J_3RFSEC_ITEM Table Fields

J_3RFSEC_ITEM related tables

J_3RFSEC_ITEM related transaction codes under SAP package J3RF

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

J_3RFSEC_ITEM SAP table for – Data for Secondary events for deferred tax

Table J_3RFSEC_ITEM technical data

SAP J_3RFSEC_ITEM Table Fields

J_3RFSEC_ITEM related tables

J_3RFSEC_ITEM related transaction codes under SAP package J3RF

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References