E3FINBU SAP (FI-IDOC: FI-AP and FI-AR data for complete FI document) Structure details

Dictionary Type: Structure
Description: FI-IDOC: FI-AP and FI-AR data for complete FI document




ABAP Code to SELECT data from E3FINBU
Related tables to E3FINBU
Access table E3FINBU




Structure field list including key, data, relationships and ABAP select examples

E3FINBU is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "FI-IDOC: FI-AP and FI-AR data for complete FI document" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_E3FINBU TYPE E3FINBU.

The E3FINBU table consists of various fields, each holding specific information or linking keys about FI-IDOC: FI-AP and FI-AR data for complete FI document data available in SAP. These include MWSTS (Tax Amount in Local Currency), WMWST (Tax amount in document currency), KUNNR (Customer Numbers), FILKD (Account Number of the Branch).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP E3FINBU structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZBD1TCash discount days 1 DZBD1TDEC3ZBDXT
ZBD2TCash discount days 2 DZBD2TDEC3ZBDXT
ZBD3TNet Payment Terms Period DZBD3TDEC3ZBDXT
ZBD1PCash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
ZBD2PCash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
SKFBTAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
SKNTOCash discount amount in local currency SKNTOCURR13(2) WERT7
WSKTOCash discount amount in document currency WSKTOCURR13(2) WERT7
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
ZLSPRPayment Block Key DZLSPRCHAR1Assigned to domainZAHLSSPE
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
REBZTFollow-On Document Type REBZTCHAR1REBZT
LZBKZState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
DIEKZService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
VRSKZInsurance indicator VRSKZCHAR1CHAR1
VRSDTInsurance date VRSDTDATS8DATUM
MSCHLDunning key MSCHLCHAR1Assigned to domainMSCHL
MANSPDunning block MANSPCHAR1Assigned to domainMANSP
MABERDunning Area MABERCHAR2Assigned to domainMABER
MADATLast dunned on MADATDATS8DATUM
MANSTDunning level MAHNS_DNUMC1MAHNS
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
QSSHBWithholding Tax Base Amount QSSHBCURR13(2) WERT7
QSFBTWithholding Tax-Exempt Amount (in Document Currency) QSFBTCURR13(2) WERT7
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
ESRREISR Reference Number ESRRECHAR27ALPHAESRRE
ESRPZISR Check Digit ESRPZCHAR2CHAR2
ZBFIXFixed Payment Terms DZBFIXCHAR1ZBFIX
KIDNOPayment Reference KIDNOCHAR30CHAR30
EMPFBPayee/Payer EMPFBCHAR10ALPHAMAXKK
SKNT2Cash Discount Amount in Second Local Currency SKNT2CURR13(2) WERT7
SKNT3Cash Discount Amount in Third Local Currency SKNT3CURR13(2) WERT7
PYCURCurrency for Automatic Payment PYCURCUKY5Assigned to domainWAERS
PYAMTAmount in Payment Currency PYAMTCURR13(2) WERT7
KKBERCredit control area KKBERCHAR4Assigned to domainKKBERKKB
ABSBTCredit management: Hedged amount ABSBTCURR13(2) WERT7
ZUMSKTarget Special G/L Indicator DZUMSKCHAR1Assigned to domainUMSKZ
CESSION_KZAccounts Receivable Pledging Indicator CESSION_KZCHAR2Assigned to domainCESSION_KZ
DTWS1Instruction key 1 DTAT16NUMC2Assigned to domainDTWSX
DTWS2Instruction key 2 DTAT17NUMC2Assigned to domainDTWSX
DTWS3Instruction key 3 DTAT18NUMC2Assigned to domainDTWSX
DTWS4Instruction key 4 DTAT19NUMC2Assigned to domainDTWSX

Key field Non-key field



How do I retrieve data from SAP structure E3FINBU using ABAP code?

As E3FINBU is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on E3FINBU as there is no data to select.

How to access SAP table E3FINBU

Within an ECC or HANA version of SAP you can also view further information about E3FINBU and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!