1. SAP Tutorial
  2. FI Module

FKKBEP SAP table for – Electronic Bank Statement Line Items

Here we would like to draw your attention to FKKBEP table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). FKKBEP is a SAP standard transp table used for storing Electronic Bank Statement Line Items related data in SAP. It comes under the package FKKB.

SAP FKKBEP table

Table FKKBEP technical data

TableFKKBEP
Data storingElectronic Bank Statement Line Items
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP FKKBEP 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 FKKBEP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • KUKEY : Short key (surrogate)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • ESNUM : Single Record Number (Line Item Number in Account Statement)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • EPERL : Line item completed
    Its data type is CHAR (Character String) with field length 1
  • VB1OK : Update 1 OK
    Its data type is CHAR (Character String) with field length 1
  • VB2BA : 2nd update processed
    Its data type is CHAR (Character String) with field length 1
  • VB2OK : 2nd update OK
    Its data type is CHAR (Character String) with field length 1
  • PIPRE : Line items were interpreted
    Its data type is CHAR (Character String) with field length 1
  • GRPNR : Bundle number for grouping line items
    Its data type is CHAR (Character String) with field length 2
  • ESTAT : Error status
    Its data type is CHAR (Character String) with field length 4
  • 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
  • BVDAT : Posting date at the bank
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting date in the document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALUT : Value date of the item to be cleared
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUTIM : Value date time
    Its data type is CHAR (Character String) with field length 6
  • VOZEI : do not use-> now EPVOZ_EP signs (C,RC,D,RD)
    Its data type is CHAR (Character String) with field length 2
  • KWAER : Account Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KWBTR : Amount in account currency
    Its data type is CURR (Currency Field) with field length 13
  • SPESK : Fees in account currency
    Its data type is CURR (Currency Field) with field length 13
  • FWAER : Foreign currency key (unequal to account currency)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWBTR : Foreign currency amount (different from account cuurency)
    Its data type is CURR (Currency Field) with field length 13
  • SPESF : Fees in foreign currency (not same as account currency)
    Its data type is CURR (Currency Field) with field length 13
  • VORGC : Business transaction code
    Its data type is CHAR (Character String) with field length 3
  • TEXTS : Text key
    Its data type is CHAR (Character String) with field length 4
  • VGEXT : External business transaction
    Its data type is CHAR (Character String) with field length 27
  • VGMAN : Transaction
    Its data type is CHAR (Character String) with field length 4
  • VGINT : Posting rule
    Its data type is CHAR (Character String) with field length 4
  • VGDEF : Posting rule determined using standard value
    Its data type is CHAR (Character String) with field length 1
  • KFMOD : Account modification
    Its data type is CHAR (Character String) with field length 10
  • VGSAP : SAP bank transaction
    Its data type is CHAR (Character String) with field length 4
  • BUTXT : Bank posting text
    Its data type is CHAR (Character String) with field length 50
  • ANZSP : Number of collective items
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • PABKS : Country key of partner bank
    Its data type is CHAR (Character String) with field length 3
  • PABLZ : Bank number of partner bank
    Its data type is CHAR (Character String) with field length 15
  • PASWI : SWIFT code of partner bank
    Its data type is CHAR (Character String) with field length 11
  • PAKTO : Account number at the partner bank
    Its data type is CHAR (Character String) with field length 18
  • PARTN : Business Partner
    Its data type is CHAR (Character String) with field length 55
  • BUSAB : Accounting Clerk
    Its data type is CHAR (Character String) with field length 2
  • KOSTL : Cost center
    Its data type is CHAR (Character String) with field length 10
  • GSBER : Business area
    Its data type is CHAR (Character String) with field length 4
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • VERTN : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • VERTT : Contract Type
    Its data type is CHAR (Character String) with field length 1
  • PNOTA : Daybook number
    Its data type is CHAR (Character String) with field length 10
  • CHECT : Check number
    Its data type is CHAR (Character String) with field length 13
  • STAVV : Financial Assets Management status
    Its data type is CHAR (Character String) with field length 2
  • TXTVV : Financial Assets Management Information Field
    Its data type is CHAR (Character String) with field length 40
  • EPVOZ : Debit/credit key for line items (for bank purposes)
    Its data type is CHAR (Character String) with field length 1
  • INFO1 : Additional information 1
    Its data type is CHAR (Character String) with field length 30
  • INFO2 : Additional information 2
    Its data type is CHAR (Character String) with field length 30
  • AVSID : Payment Advice Number
    Its data type is CHAR (Character String) with field length 16
  • INTAG : Interpretation algorithm
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • NBBLN : Subledger document number
    Its data type is CHAR (Character String) with field length 10
  • AK1BL : Payment on account document number
    Its data type is CHAR (Character String) with field length 10
  • AKBLN : Payment on account document number
    Its data type is CHAR (Character String) with field length 10
  • KNRZA : Account number of an alternative payer
    Its data type is CHAR (Character String) with field length 10
  • AVKOA : Payment Advice Account Type
    Its data type is CHAR (Character String) with field length 1
  • AVKON : Account Number
    Its data type is CHAR (Character String) with field length 10
  • BATCH : Batch number (bundle number)
    Its data type is CHAR (Character String) with field length 3
  • ITMNR : Batch Item Number for Lockbox
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • KURSF : Exchange rate (different from local currency)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • JPDAT : Date of failed bills of exchange in Japan
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • POSAG : Posting algorithm (lockbox only)
    Its data type is CHAR (Character String) with field length 3
  • SDOC2 : Number of second subledger document
    Its data type is CHAR (Character String) with field length 10
  • VGREF : Bank Reference Number
    Its data type is CHAR (Character String) with field length 35
  • XBENR : Object key
    Its data type is CHAR (Character String) with field length 20
  • XBTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • ARRSK : Overdue charges from/to partners in account currency
    Its data type is CURR (Currency Field) with field length 13
  • PFORM : Processing Type
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • KIDNO : Payment Reference
    Its data type is CHAR (Character String) with field length 30
  • KKREF : Customer-to-customer reference
    Its data type is CHAR (Character String) with field length 35
  • KKRF2 : Customer-to-customer reference
    Its data type is CHAR (Character String) with field length 35
  • MANSP : Dunning block
    Its data type is CHAR (Character String) with field length 1
  • FNAM1 : BDC field name
    Its data type is CHAR (Character String) with field length 132
  • FVAL1 : BDC field value
    Its data type is CHAR (Character String) with field length 132
  • FKOA1 : Payment Advice Account Type
    Its data type is CHAR (Character String) with field length 1
  • FNAM2 : BDC field name
    Its data type is CHAR (Character String) with field length 132
  • FVAL2 : BDC field value
    Its data type is CHAR (Character String) with field length 132
  • FKOA2 : Payment Advice Account Type
    Its data type is CHAR (Character String) with field length 1
  • FNAM3 : BDC field name
    Its data type is CHAR (Character String) with field length 132
  • FVAL3 : BDC field value
    Its data type is CHAR (Character String) with field length 132
  • FKOA3 : Payment Advice Account Type
    Its data type is CHAR (Character String) with field length 1
  • IDENR : ID number for cash management and forecast
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • B1APP : Application Indicator
    Its data type is CHAR (Character String) with field length 6
  • B1ERR : Error status
    Its data type is CHAR (Character String) with field length 4
  • B1STD : X – Standard (FI) posting should be suppressed
    Its data type is CHAR (Character String) with field length 1
  • B1DOC : Doc. no. (IDoc number, application document no., etc.)
    Its data type is CHAR (Character String) with field length 70
  • B1TYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • B2APP : Application Indicator
    Its data type is CHAR (Character String) with field length 6
  • B2ERR : Error status
    Its data type is CHAR (Character String) with field length 4
  • B2STD : X – Standard (FI) posting should be suppressed
    Its data type is CHAR (Character String) with field length 1
  • B2DOC : Doc. no. (IDoc number, application document no., etc.)
    Its data type is CHAR (Character String) with field length 70
  • B2TYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • PIBAN : Partner Bank Account: IBAN
    Its data type is CHAR (Character String) with field length 34
  • XREF1 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24

    • FKKBEP related tables

    • TFK100C_S : Activities per Standard Role in Cash Journal
    • TFK056ST : Blocking Reasons for Interest Calculation (Text Table)
    • DFKKCOLFILE_H_W : Subm. of Receivable for Collection: Header Data Buffer
    • TFK021Z : Line layout variants: Header data
    • TFK021KC : Detail Screen Structure for Document Display (Customer)
    • TFKCF : Parallel Update of Cash Management
    • FKKZEST : Control table for payment lot transfer
    • DFKKZV : Payment Lot: Enhancement of Note to Payee
    • TFK000KT : Description of account assignment categories
    • TFK042FG : Level of Detail When Creating Payment Medium (Refinement)
    • TFK_PAYMENTREL_N : FICA: Customizing Payment Release Disbursements – New
    • TFK054CT : NOC Returns: Activity Texts
    • TFK045D : Assign return reasons
    • TFK000C : Central settings in contract accounts receivable/payable
    • TFK044FD : Periods of Valuation Plan Variants
    • TFK033C : Account determination: Control
    • FKKDIPOS : FI-CA: Distribution of intervals – items
    • TFK053R04 : Foll.-Up Acts: Activity Variants for Writing Off Returns Chg
    • DFKKCROWN : CR: Information on Issued Check Forms
    • TFK001AT : Clearing reasons (text table)

    FKKBEP related transaction codes under SAP package FKKB

    • S_KK4_74002324 : IMG Activity: _FICABFDP_V_TFK001C_
    • FQ2101 : FI-CA: Document Type for Perception
    • S_KK4_74002153 : IMG Activity: _ISISFICA_VC_TVSC_PP
    • S_KK4_74002417 : IMG Activity: _FICABFOI_FQZO
    • FPCHR : Check Management
    • S_KK4_74002217 : IMG Activity: _FICAEURO_FPEW7
    • FPEMMAMA : EMMA: Mass Activities
    • S_KK4_74002382 : IMG Activity: _ISTFICABFAD_000007
    • FQKL : Existing settings contract A/R & A/P
    • S_KK4_74002270 : IMG Activity: _FICABTWO_FQZ04
    • S_KK4_74002126 : IMG Activity: _FICABTIC_FQI4
    • S_KK4_74002170 : IMG Activity: _ISISFICA_VY6P
    • FP04M : Mass Run: Write-Off
    • FPR1 : Create Installment Plan
    • FPT1M : Check Totals Records – Mass Run
    • S_KK4_74002344 : IMG Activity: _ISUFICABFDP_000094
    • FQZT : FI-CA: Check Deposit Clearing
    • FPB1 : Document Transfer
    • FQCC : Maintain Bank Sel. IDs for Pymt Run
    • FQC700 : Collective Bill Specifications

    Related References

    Related Tutorials

    EPIC_EBR_FEB SAP table for – Additional Data on Bank Statement Line Item for Bank Receipt

    EPIC_EBR_FEB table in SAP FI (Localization in FI) module. This table is used for storing data of Additional Data on...

    TFK012DCV SAP table for – Electronic Bank Statement: Payment Agreements (Brazil)

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

    FLQITEMBS SAP table for – Liquidity Calculation – Line Items for Bank Statement Docs

    FLQITEMBS table in SAP TR (Treasury) module. This tables is used for storing data of Liquidity Calculation - Line Items...

    EPIC_C_HB_COMM SAP table for – Electronic Payment Integration: House Bank Commun. Settings

    EPIC_C_HB_COMM table in SAP FI (Localization in FI) module. This table is used for storing data of Electronic Payment Integration:...

    EPIC_BRS_HEADER SAP table for – EPIC: Bank Reconciliation Statement

    EPIC_BRS_HEADER table in SAP FI (Localization in FI) module. This table is used for storing data of EPIC: Bank Reconciliation...

    FF_5 SAP tcode for – Import Electronic Bank Statement

    FF_5 tcode in SAP FI Bank Accounting module. This transaction code is used for Import Electronic Bank Statement. Here is...

    FF_6 SAP tcode for – Display Electronic Bank Statement

    FF_6 tcode in SAP FI Bank Accounting module. This transaction code is used for Display Electronic Bank Statement. Here is...

    «
    »