E3FINBU SAP (FI-IDOC: FI-AP and FI-AR data for complete FI document) Structure details
Description: FI-IDOC: FI-AP and FI-AR data for complete FI document
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 |
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | Assigned to domain | ZAHLS | SPE | ||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | Assigned to domain | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | Assigned to domain | LAND1 | |||
DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
VRSKZ | Insurance indicator | VRSKZ | CHAR | 1 | CHAR1 | ||||
VRSDT | Insurance date | VRSDT | DATS | 8 | DATUM | ||||
MSCHL | Dunning key | MSCHL | CHAR | 1 | Assigned to domain | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | Assigned to domain | QSSKZ | |||
QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 13(2) | WERT7 | ||||
QSFBT | Withholding Tax-Exempt Amount (in Document Currency) | QSFBT | CURR | 13(2) | WERT7 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
ESRRE | ISR Reference Number | ESRRE | CHAR | 27 | ALPHA | ESRRE | |||
ESRPZ | ISR Check Digit | ESRPZ | CHAR | 2 | CHAR2 | ||||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
SKNT2 | Cash Discount Amount in Second Local Currency | SKNT2 | CURR | 13(2) | WERT7 | ||||
SKNT3 | Cash Discount Amount in Third Local Currency | SKNT3 | CURR | 13(2) | WERT7 | ||||
PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 5 | Assigned to domain | WAERS | |||
PYAMT | Amount in Payment Currency | PYAMT | CURR | 13(2) | WERT7 | ||||
KKBER | Credit control area | KKBER | CHAR | 4 | Assigned to domain | KKBER | KKB | ||
ABSBT | Credit management: Hedged amount | ABSBT | CURR | 13(2) | WERT7 | ||||
ZUMSK | Target Special G/L Indicator | DZUMSK | CHAR | 1 | Assigned to domain | UMSKZ | |||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | Assigned to domain | CESSION_KZ | |||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | Assigned to domain | DTWSX |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects