1. SAP Tutorial
  2. FI Module

J_3RBUE_BK_TABLE SAP table for – Transparent table for PurBook (ALV)

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

SAP J_3RBUE_BK_TABLE table

Table J_3RBUE_BK_TABLE technical data

TableJ_3RBUE_BK_TABLE
Data storingTransparent table for PurBook (ALV)
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RBUE_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_3RBUE_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_TEST : 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
  • EX_INDEX_POS : Extracts counter for PBOOK_03
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • LAUFI : Additional Identification
    Its data type is CHAR (Character String) with field length 6
  • LAUFD : Date on Which the Program Is to Be Run
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GSBER_TRN : Business Area
    Its data type is CHAR (Character String) with field length 4
  • BLDAT_TRN : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT_TRN : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DMBTR_TRN : Amount in company code currency
    Its data type is CURR (Currency Field) with field length 15
  • DMBTR_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WRBTR_TRN : Gross Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • 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
  • 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
  • BLDAT_PAY : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT_PAY : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DMBTR_PAY : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • DMBTR_WRS_PAY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WRBTR_PAY : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • 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_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
  • BLDAT_ORIGPAY : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT_ORIGPAY : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XBLNR_ORIGPAY : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • BKTXT_ORIGPAY : Document Header Text
    Its data type is CHAR (Character String) with field length 25
  • 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
  • BLDAT_INV : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT_INV : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DMBTR_INV : Amount in company code currency
    Its data type is CURR (Currency Field) with field length 15
  • DMBTR_WRS_INV : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WRBTR_INV : Gross Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • 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 : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWBAS_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWBAS_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWBAS2_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS2_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWBAS2_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWBAS2_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWBAS3_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS3_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWBAS3_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWBAS3_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWBAS4_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS4_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWBAS4_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWBAS4_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWBAS5_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWBAS5_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWBAS5_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWBAS5_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 : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWSTE_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWSTE_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWSTE2_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE2_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWSTE2_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWSTE2_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWSTE3_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE3_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWSTE3_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWSTE3_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWSTE5_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWSTE5_WRS_TRN : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWSTE5_TRN : Tax Base Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • 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
  • NAME3_CRED : Name 3
    Its data type is CHAR (Character String) with field length 35
  • NAME4_CRED : Name 4
    Its data type is CHAR (Character String) with field length 35
  • NAME1_CRED_R : Name 1
    Its data type is CHAR (Character String) with field length 35
  • NAME2_CRED_R : Name 2
    Its data type is CHAR (Character String) with field length 35
  • NAME3_CRED_R : Name 3
    Its data type is CHAR (Character String) with field length 35
  • NAME4_CRED_R : Name 4
    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_EBLN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • MM_INV_VOISO : Prelim. doc.: ISO code of ctry issuing the preliminary doc.
    Its data type is CHAR (Character String) with field length 2
  • PART_PAYMENT : Partial Payment
    Its data type is CHAR (Character String) with field length 1
  • 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
  • MM_INV_EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • EKBE_BELNR_MM : Number of Material Document
    Its data type is CHAR (Character String) with field length 10
  • XREF1_INV : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XREF1_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
  • USNAM_INV : User name
    Its data type is CHAR (Character String) with field length 12
  • USNAM_PAY : User name
    Its data type is CHAR (Character String) with field length 12
  • USNAM_PAY_FCT : User name
    Its data type is CHAR (Character String) with field length 12
  • RESERV : Reservation Flag
  • MM_INV_VORNU : Character String – 256 User-Defined Characters
    Its data type is LCHR (Long character string, requires preceding INT2 field) with field length 256

    • J_3RBUE_BK_TABLE related tables

    • J_3RF_OPERCOD : Operation Type Codes
    • J_3RFPRTXAMTRT : Propert tax amount reduction privileges
    • J_3RNDSINV : Target use of ingoing invoice positions for AuC
    • J_3RF_TP_TRANSTT : Transfer pricing: type of transaction text table
    • J_3RFBS_PERIOD : Financial statement forms: Fiscal periods
    • J_3RF_WW_SIZES : Rersonnel sizes of working wear
    • J_3RFBS_XMLDELT : Balance sheet forms: XML-tags to be removed:Text table
    • J_3RF_STR_DIV : Structural divisions
    • J_3RFOKATOREG : Relation OKATO -> Region, District
    • J_3RFGTDMAT : GTD usage in material documents
    • J_3RFSTOPREASONT : Reasons for asset shutdown
    • J_3RFPRTEXEMP : Exemption codes from property tax payment
    • J_3RNKSACTION : Start-up for asset types
    • J_3RF_TP_COCATT : Transfer pricing company category codes
    • J_3RFBS_VART : Financial Statement versions used in balance sheet forms
    • J_3RF_DI_PVEND : Assign Electronic ID to Vendor
    • J_3RCLASSSAKNR : General ledger accounts classification
    • J_3RF_BCCT : Budget Classification code text for CIS
    • J_3RFPTREGIONT : Regions and districts for property tax
    • J_3RFCNTSET : Define Rules for Automatic Contract Number Filling

    J_3RBUE_BK_TABLE related transaction codes under SAP package J3RF

    • J3RFTPMATOCV : Mapping material codes to OCP codes
    • J3RFGTDINT : Maintain CDec Data (Russia)
    • J3RFAB08 : FI-AA reversal documet posting
    • J3RFDSLD : Customer Turnover Balance Sheet
    • J3RFCCCUST : Set Up Multiple Operators
    • J3RTAXTEST : Print Sample VAT Returns (Russia)
    • J3RFREGINV : Invoice Journal (Russia)
    • S_EBS_44000565 : Invoice Journal (Russia)
    • J3RFCNTI : Contract Numbers Maintenance
    • J3RFCNTOFFP : Offline Contract Accounting Update
    • J3RFVENDORV : Maint. view of Vendor Data
    • J3RFSTRDIV : Structural divisions customizing
    • J3RFTPDEL : Transfer Pricing Delete Notification
    • J3RFTPCOCATV : Company categories
    • J3RFTPCCPROV : CompanyCategories, LiquidationCodes
    • J3RFRATECALC : Down Payments in Foreign Currency
    • J3RFWORKWEAR : Employee Workwear Record
    • J3RFNEGP : Negative posting partial payment(RU)
    • J3RFTPTRANSTV : Transaction types
    • J3RFF3 : Changes in Equity, Main Section

    Related References

    Related Tutorials

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

    J_3RSL_BK_TABLE table in SAP FI (Localization in FI) module. This table is used for storing data of Transparent table for...

    J_1AWITH SAP table for – Withholding transaction data

    J_1AWITH table in SAP FI (Localization in FI) module. This table is used for storing data of Withholding transaction data....

    J_3RBUE_BOOK_NUM SAP table for – Table for PurBook (ALV) numbers of lines

    J_3RBUE_BOOK_NUM table in SAP FI (Localization in FI) module. This table is used for storing data of Table for PurBook...

    RFUMSV00_HIST SAP table for – Maintain data for previous VAT return run

    RFUMSV00_HIST table in SAP FI (Localization in FI) module. This table is used for storing data of Maintain data for...

    J_3RBUE_BOOK_IND SAP table for – Table for PurBook (ALV) NAMES for Num lines IND-

    J_3RBUE_BOOK_IND table in SAP FI (Localization in FI) module. This table is used for storing data of Table for PurBook...

    DFKKHUREPDS SAP table for – Recording Data for Domestic Sales Hungary

    DFKKHUREPDS table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    IDWT_EMPDATA_VE SAP table for – To store the employee data for Venezuela payroll

    IDWT_EMPDATA_VE table in SAP FI (Localization in FI) module. This table is used for storing data of To store the...

    «
    »