J_3RSL_BK_TABLE SAP table for - Transparent table for SaleBook (ALV)

Table of Contents

Here we would like to draw your attention to J_3RSL_BK_TABLE 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_3RSL_BK_TABLE is a SAP standard transp table used for storing Transparent table for SaleBook (ALV) related data in SAP. It comes under the package J3RF.

SAP J_3RSL_BK_TABLE table

Table J_3RSL_BK_TABLE technical data

Table	J_3RSL_BK_TABLE
Data storing	Transparent table for SaleBook (ALV)
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_3RSL_BK_TABLE 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_3RSL_BK_TABLE 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_TRN : Accounting Document Number
Its a key field. Its data type is CHAR (Character String) with field length 10

GJAHR_TRN : 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

MONAT_TRN : Fiscal period
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2

EX_INDEX : DE for EX index
Its a key field. Its data type is CHAR (Character String) with field length 10

LAUFD : Date on Which the Program Is to Be Run
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

LAUFI : Additional Identification
Its data type is CHAR (Character String) with field length 6

BUDAT_TRN : Posting Date in the Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

BLDAT_TRN : Document Date in Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DMBTR_TRN : Amount in local currency
Its data type is CURR (Currency Field) with field length 13

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

WRBTR_TRN : Amount in document currency
Its data type is CURR (Currency Field) with field length 13

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

FLG_BELNR_TRN : Reversal (Tax Transfer)
Its data type is CHAR (Character String) with field length 1

GSBER : Business Area
Its data type is CHAR (Character String) with field length 4

BELNR_PAY : Accounting Document Number
Its data type is CHAR (Character String) with field length 10

GJAHR_PAY : Fiscal Year
Its data type is NUMC (Character String with Digits Only) with field length 4

BUDAT_PAY : Posting Date in the Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

BLDAT_PAY : Document Date in Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DMBTR_PAY : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

WRBTR_PAY : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FLG_BELNR_PAY : Reversal (Payment)
Its data type is CHAR (Character String) with field length 1

FLG_XRAGL_PAY : Indicator: Clearing was Reversed
Its data type is CHAR (Character String) with field length 1

BELNR_INV : Accounting Document Number
Its data type is CHAR (Character String) with field length 10

GJAHR_INV : Fiscal Year
Its data type is NUMC (Character String with Digits Only) with field length 4

BUDAT_INV : Posting Date in the Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

BLDAT_INV : Document Date in Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

DMBTR_INV : Amount in local currency
Its data type is CURR (Currency Field) with field length 13

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

WRBTR_INV : Amount in document currency
Its data type is CURR (Currency Field) with field length 13

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

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

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

FLG_BELNR_INV : Reversal (Invoice)
Its data type is CHAR (Character String) with field length 1

FLG_BELNR_ALL : Reversal (Clearing)
Its data type is CHAR (Character String) with field length 1

BASGRUNO : Group Number for Tax Base Amounts
Its data type is NUMC (Character String with Digits Only) with field length 2

HWBAS_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWBAS_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

HWBAS2_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWBAS2_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

HWBAS3_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWBAS3_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

HWBAS4_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWBAS4_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWBAS5_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

HWBAS5_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

STEGRUNO : Group Number for Tax Amounts
Its data type is NUMC (Character String with Digits Only) with field length 2

HWSTE_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWSTE_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

HWSTE2_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWSTE2_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

HWSTE3_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWSTE3_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

HWSTE5_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

FWSTE5_TRN : Amount Posted in Display Currency
Its data type is CURR (Currency Field) with field length 13

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

BKTXT_TRN : Document Header Text
Its data type is CHAR (Character String) with field length 25

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

NAME1_CRED : Name 1
Its data type is CHAR (Character String) with field length 35

NAME2_CRED : Name 2
Its data type is CHAR (Character String) with field length 35

STCD1_CRED : Tax Number 1
Its data type is CHAR (Character String) with field length 16

STCD3_CRED : Tax Number 3
Its data type is CHAR (Character String) with field length 18

XBLNR_INV : Reference Document Number
Its data type is CHAR (Character String) with field length 16

BKTXT_INV : Document Header Text
Its data type is CHAR (Character String) with field length 25

XBLNR_PAY : Reference Document Number
Its data type is CHAR (Character String) with field length 16

BKTXT_PAY : Document Header Text
Its data type is CHAR (Character String) with field length 25

MM_INV_BUDAT : Date of Goods Receipt
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

MM_INV_EBELN : Purchasing Document Number
Its data type is CHAR (Character String) with field length 10

MM_INV_EBELP : Item Number of Purchasing Document
Its data type is NUMC (Character String with Digits Only) with field length 5

MM_INV_VOISO : Prelim. doc.: ISO code of ctry issuing the preliminary doc.
Its data type is CHAR (Character String) with field length 2

MM_INV_VORNU : Preliminary document: No. of preliminary doc.f.import procg
Its data type is CHAR (Character String) with field length 25

LIGHTS : Icon ID (incl. @)
Its data type is CHAR (Character String) with field length 4

BOX : Flag for mark rec 01
Its data type is CHAR (Character String) with field length 1

NUM_LINE : Accounting Document Number
Its data type is CHAR (Character String) with field length 10

EBELN : Purchasing Document Number
Its data type is CHAR (Character String) with field length 10

EBELJ : Fiscal Year
Its data type is NUMC (Character String with Digits Only) with field length 4

ZUONR : Assignment Number
Its data type is CHAR (Character String) with field length 18

SGTXT : Item Text
Its data type is CHAR (Character String) with field length 50

XREF1_INV : Business partner reference key
Its data type is CHAR (Character String) with field length 12

XFER1_DAT : Document Date in Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

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

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

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

BELNR_ORIGPAY : Accounting Document Number
Its data type is CHAR (Character String) with field length 10

GJAHR_ORIGPAY : Fiscal Year
Its data type is NUMC (Character String with Digits Only) with field length 4

BKTXT_ORIGPAY : Document Header Text
Its data type is CHAR (Character String) with field length 25

XBLNR_ORIGPAY : Reference Document Number
Its data type is CHAR (Character String) with field length 16

BUDAT_ORIGPAY : Posting Date in the Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

BLDAT_ORIGPAY : Document Date in Document
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

J_3RSL_BK_TABLE related tables

J_3RF_TP_MERGED : Merged Items
J_3RF_T052S : Terms of Payment for Splitting by Goods Shelf Life
J_3RFGTDINVT : Define Billing Types for Customs Declaration Tracking
J_3RFPRTEXEMP : Exemption codes from property tax payment
J_3RF_DI_CCCUST : Assign Operator to Company Code and Customer
J_3RCLASSSAKNR : General ledger accounts classification
J_3RF_TP_COCATT : Transfer pricing company category codes
J_3RF_REGCUS_REV : Customizing for Reversals for Invoice Registration Journal
J_3RNDSNKS : Tax categories for AuC
J_3RTAX21_DT : Table of parameters Document Type
J_3RF_ATTRTYP_TT : Attribute types text table
J_3RF_BK_TOTALS : Incoming Totals for Add. Sheets of Sales/ Purchase Ledgers
J_3RF_TP_TRANSTT : Transfer pricing: type of transaction text table
J_3RF_TP_STATUSL : Transfer pricing: list of statuses of transaction parties
J_3RFBS_VAR : Variants of Financial Statement Versions
J_3RF_TP_BSEGCOR : Items of Corrective documents
J_3RFBS_VERSION : Financial Statement versions used in balance sheet forms
J_3RFPRTXAMTRT : Propert tax amount reduction privileges
J_3ROS6_TB5BWASL : Movement types for table 5 of form OS-6
J_3RFTAXRA : Tax Accounting: Actual line item table

J_3RSL_BK_TABLE related transaction codes under SAP package J3RF

J3RF_FCHA : Net wealth calculation
J3RFREGINV : Invoice Journal (Russia)
J3RFTRPRSEL : Transfer Pricing Document Selection
J3RFZDBPDF : Print Payment Orders (Russia)
S_EBS_44000455 : J_3RF_ACCOUNTING_STATEMENT
J3RF_F3S2 : References (was received)
J3RF_F3S1 : References (net wealth)
J3RFTPCCPROV : CompanyCategories, LiquidationCodes
J3RFNKSREGISTR : Asset Registration (Russia)
J3RF_F2 : Profit and loss report Russia (F.2)
J3RFBALANCE : Balance Sheet Key Figures (Russia)
J3RFF2 : P&L Statement, Main Section (Russia)
J_3RINV : Incoming Invoice Number Ranges
J3RFVATANALYSIS : Incoming VAT Account Analysis
J3RFWORKWEAR : Employee Workwear Record
J3RFVATEXP : Export Data Analysis for VAT
J3RFINVTARG : Redetermination of Invoices (Russia)
J3RXMLTRANS : XML invoices transformations mapping
J3RFTRPRDOC : Transfer Pricing Document Types
J3RFASD : Customer Balance Notification

J_3RSL_BK_TABLE SAP table for – Transparent table for SaleBook (ALV)

Table J_3RSL_BK_TABLE technical data

SAP J_3RSL_BK_TABLE Table Fields

J_3RSL_BK_TABLE related tables

J_3RSL_BK_TABLE related transaction codes under SAP package J3RF

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

J_3RSL_BK_TABLE SAP table for – Transparent table for SaleBook (ALV)

Table J_3RSL_BK_TABLE technical data

SAP J_3RSL_BK_TABLE Table Fields

J_3RSL_BK_TABLE related tables

J_3RSL_BK_TABLE related transaction codes under SAP package J3RF

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References