SAP Table E3FIPRT
FI IDoc: Vendor and customer data of the FI document
E3FIPRT (FI IDoc: Vendor and customer data of the FI document) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link E3FIPRT to other SAP tables.
Source: E3FIPRT (FI IDoc: Vendor and customer data of the FI document)
E3FIPRT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | 0 | |||||||||
| ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | 0 | |||||||||
| ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | 0 | |||||||||
| ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | 0 | |||||||||
| ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5 | 3 | |||||||||
| ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5 | 3 | |||||||||
| SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13 | 2 | |||||||||
| SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13 | 2 | |||||||||
| SKNT2 | Cash Discount Amount in Second Local Currency | SKNT2 | CURR | 13 | 2 | |||||||||
| SKNT3 | Cash Discount Amount in Third Local Currency | SKNT3 | CURR | 13 | 2 | |||||||||
| WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13 | 2 | |||||||||
| ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | 0 | |||||||||
| ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | 0 | |||||||||
| ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | 0 |
Possible values
|
||||||||
| REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | 0 | |||||||||
| REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | 0 | |||||||||
| REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | 0 | |||||||||
| MSCHL | Dunning key | MSCHL | CHAR | 1 | 0 | |||||||||
| MANSP | Dunning block | MANSP | CHAR | 1 | 0 | |||||||||
| RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | 0 | |||||||||
| QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | 0 | |||||||||
| QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 13 | 2 | |||||||||
| QSFBT | Withholding Tax-Exempt Amount (in Document Currency) | QSFBT | CURR | 13 | 2 | |||||||||
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | 0 | |||||||||
| UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | 0 | |||||||||
| LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | 0 | |||||||||
| LANDL | Supplying Country | LANDL | CHAR | 3 | 0 | |||||||||
| DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | 0 | |||||||||
| ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | 0 | |||||||||
| ESRRE | ISR Reference Number | ESRRE | CHAR | 27 | 0 | |||||||||
| ESRPZ | ISR Check Digit | ESRPZ | CHAR | 2 | 0 | |||||||||
| HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | 0 | |||||||||
| BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | 0 | |||||||||
| EMPFB | Payee/Payer | EMPFB | CHAR | 10 | 0 | |||||||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | 0 | |||||||||
| KIDNO | Payment Reference | KIDNO | CHAR | 30 | 0 | |||||||||
| PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 5 | 0 | |||||||||
| PYAMT | Amount in Payment Currency | PYAMT | CURR | 13 | 2 | |||||||||
| KKBER | Credit control area | KKBER | CHAR | 4 | 0 | |||||||||
| ABSBT | Credit management: Hedged amount | ABSBT | CURR | 13 | 2 | |||||||||
| ZUMSK | Target Special G/L Indicator | DZUMSK | CHAR | 1 | 0 | |||||||||
| CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | 0 | |||||||||
| DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | 0 | |||||||||
| DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | 0 | |||||||||
| DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | 0 | |||||||||
| DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | 0 | |||||||||
