J_3RF_TP_BSEGORI SAP table for – Items of Original documents

Here we would like to draw your attention to J_3RF_TP_BSEGORI 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_3RF_TP_BSEGORI is a SAP standard transp table used for storing Items of Original documents related data in SAP. It comes under the package J3RF.

SAP J_3RF_TP_BSEGORI table

Table J_3RF_TP_BSEGORI technical data

TableJ_3RF_TP_BSEGORI
Data storingItems of Original documents
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RF_TP_BSEGORI 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_3RF_TP_BSEGORI 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
  • REP_YEAR : Report Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • CORR_NUM : Number of Correction
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • TRAN_NUMBER : Sequential Transaction Number (010)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • ID : Internal counter
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • .INCLUDE : Common structure for orig/corr documents
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • DMBTR : Amount with sign
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 17
  • WRBTR : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • BEWAR : Consolidation Transaction Type
    Its data type is CHAR (Character String) with field length 3
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • REBZJ : Fiscal Year of the Relevant Invoice (for Credit Memo)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REBZZ : Line Item in the Relevant Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • MENGE : Quantity with sign
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • TEXT_POS : Short text for sales order item
    Its data type is CHAR (Character String) with field length 40
  • VBELN_SD : Billing document
    Its data type is CHAR (Character String) with field length 10
  • POSNR_SD : Billing item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • BELNR_MM : Document Number of an Invoice Document
    Its data type is CHAR (Character String) with field length 10
  • GJAHR_MM : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI_MM : Document Item in Invoice Document
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • BELNR_PREV : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • GJAHR_PREV : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI_PREV : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • BELNR_ORIG : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • GJAHR_ORIG : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI_ORIG : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • AUTYP : SD document category
    Its data type is CHAR (Character String) with field length 1
  • BEWTP : Purchase Order History Category
    Its data type is CHAR (Character String) with field length 1
  • EXCLUDE : General Flag
    Its data type is CHAR (Character String) with field length 1