SAP TABLES | Financial Accounting | Accounts Payable | Payment Transactions(FI-AP-AP-PT) SAP FI

FPRL_ITEM SAP Item Data Table and data







FPRL_ITEM is a standard SAP Table which is used to store Item Data data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP FPRL_ITEM Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP FPRL_ITEM Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
GUIDSYSUUID_XRAW16 UUID in X form (binary)
.INCLUDEFPRLS_ITEM_STATUS Item Status
LIST_IDFPRL_LIST_IDNUMC10 FPRL_HEADERPayment Release List ID
STATUSFPRL_ITEM_STATUSCHAR3 FPRL_ITEM_STATItem Status ID
ALEVELFPRL_LEVELNUMC2 FPRL_LEVELSApproval Level
.INCLUDEFPRLS_DATA List Data
CREA_USERFPRL_USERCHAR12 Created By
CREA_TIMEFPRL_CREA_TIMEDEC15 Created OnTSTPS
CHANGE_USERFPRL_USER_CHCHAR12 Last Changed By
CHANGE_TIMEFPRL_CHANGE_TIMEDEC15 Last Changed OnTSTPS
APPLICFPRL_APPLICATIONCHAR10 FPRL_APPLICPayment Release List Application ID
.INCLUDEFPRLS_ITEM_DATA Item Data
BUKRSBUKRSCHAR4 T001Company Code
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
LIFNRLIFNRCHAR10 LFA1Account Number of Vendor or CreditorALPHA
KUNNRKUNNRCHAR10 KNA1Customer NumberALPHA
FILKDFILKDCHAR10 Account Number of the BranchALPHA
EMPFBEMPFBCHAR10 Payee/PayerALPHA
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
SHKZGSHKZGCHAR1 Debit/Credit Indicator
WAERSWAERSCUKY5 TCURCCurrency Key
WRBTRWRBTRCURR13(2) Amount in document currency
SKFBTSKFBTCURR13(2) Amount Eligible for Cash Discount in Document Currency
WSKTOWSKTOCURR13(2) Cash discount amount in document currency
QBSHBQBSHBCURR13(2) Withholding Tax Amount (in Document Currency)
PSWSLPSWSLCUKY5
*
Update Currency for General Ledger Transaction Figures
PSWBTPSWBTCURR13(2) Amount for Updating in General Ledger
PSSKTPSSKTCURR13(2) Cash Discount Deduction for the Item
BLARTBLARTCHAR2 T003Document Type
BUDATBUDATDATS8 Posting Date in the Document
BLDATBLDATDATS8 Document Date in Document
KOARTKOARTCHAR1 Account Type
BSCHLBSCHLCHAR2 TBSLPosting Key
HKONTHKONTCHAR10 SKB1General Ledger AccountALPHA
SAKNRSAKNRCHAR10 SKB1G/L Account NumberALPHA
UMSKZUMSKZCHAR1 T074USpecial G/L Indicator


GSBERGSBERCHAR4 TGSBBusiness Area
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
QSSKZQSSKZCHAR2
*
Withholding Tax Code
SGTXTSGTXTCHAR50 Item Text
ZFBDTDZFBDTDATS8 Baseline Date for Due Date Calculation
ZBD1TDZBD1TDEC3 Cash discount days 1
ZBD2TDZBD2TDEC3 Cash discount days 2
ZBD3TDZBD3TDEC3 Net Payment Terms Period
ZBD1PDZBD1PDEC5(3) Cash Discount Percentage 1
ZBD2PDZBD2PDEC5(3) Cash Discount Percentage 2
XREBZXREBZCHAR1 Indicator: Item is an Invoice-Related Credit Memo
ESRNRESRNRCHAR11 ISR Subscriber Number
ESRREESRRECHAR27 ISR Reference NumberALPHA
ESRPZESRPZCHAR2 ISR Check Digit
EBELNEBELNCHAR10 EKKOPurchasing Document NumberALPHA
EBELPEBELPNUMC5 EKPOItem Number of Purchasing Document
STCEGSTCEGCHAR20 VAT Registration Number
XBLNRXBLNR1CHAR16 Reference Document Number
LZBKZLZBKZCHAR3 T015LState Central Bank Indicator
LANDLLANDLCHAR3 T005Supplying Country
NPLNRNPLNRCHAR12
*
Network Number for Account AssignmentALPHA
AUFPLCO_AUFPLNUMC10 Routing number of operations in the order
ZUONRDZUONRCHAR18 Assignment Number
VERTNRANLCHAR13 Contract NumberALPHA
REBZTREBZTCHAR1 Follow-On Document Type
REBZGREBZGCHAR10 Number of the Invoice the Transaction Belongs toALPHA
REBZJREBZJNUMC4 Fiscal Year of the Relevant Invoice (for Credit Memo)GJAHR
REBZZREBZZNUMC3 Line Item in the Relevant Invoice
KOSTLKOSTLCHAR10
*
Cost CenterALPHA
VBEL2VBELN_VACHAR10
*
Sales DocumentALPHA
POSN2POSNR_VANUMC6
*
Sales Document Item
PRCTRPRCTRCHAR10
*
Profit CenterALPHA
XREF1XREF1CHAR12 Business partner reference key
XREF2XREF2CHAR12 Business partner reference key
XREF3XREF3CHAR20 Reference key for line item
DTWS1DTAT16NUMC2
*
Instruction key 1
DTWS2DTAT17NUMC2
*
Instruction key 2
DTWS3DTAT18NUMC2
*
Instruction key 3
DTWS4DTAT19NUMC2
*
Instruction key 4


XCPDDXCPDDCHAR1 Indicator: Address and bank data set individually
BUPLABUPLACHAR4
*
Business Place
PPRCTPPRCTRCHAR10
*
Partner Profit CenterALPHA
GRANT_NBRGM_GRANT_NBRCHAR20 GrantALPHA
FKBERFKBERCHAR16
*
Functional Area
GEBERBP_GEBERCHAR10
*
Fund
XINVEXINVECHAR1 Indicator: Capital Goods Affected?
KEYNOPRQ_KEYNOCHAR10
*
Key Number for Payment RequestALPHA
PAMTFPRQ_AMTFCCURR13(2) Payment Request Amount in Payment Currency
ORIGINFIBL_ORIGINCHAR8
*
Origin Indicator
.APPENDEPIC_FPRLS_ITEM_DATA EPIC Append Structure for FPRLS_ITEM_DATA
EPIC_PROCESSOREPIC_PROCESSORCHAR12
*
Processor
EPIC_STATUSEPIC_ITEM_STATUSCHAR3 Item Status
.APPENDFMCCAVC_PRLS_ITEM_DATA FMCCAVC append structure for PRL structures
AVC_STATUSFMCCAVC_STATUSCHAR1 Cash Control Status
AVC_PRIORITYFMCCAVC_PRIORITYNUMC6 Cash Control Priority
.APPENDFMPRLS_ES_ITEM_DATA Spain specific fields
FIPOS_ESFIPOSCHAR14
*
Commitment ItemFMCIS
FISTL_ESFISTLCHAR16
*
Funds Center
GRANT_NBR_ESGM_GRANT_NBRCHAR20 GrantALPHA
FKBER_ESFKBERCHAR16
*
Functional Area
GEBER_ESBP_GEBERCHAR10
*
Fund
PROJK_ESPS_PSP_PNRNUMC8
*
Work Breakdown Structure Element (WBS Element)ABPSP
CISUB1_ESFM_CISUB1CHAR10 Substring 1 of Commitment Item
CISUB2_ESFM_CISUB2CHAR10 Substring 2 of Commitment Item
CISUB3_ESFM_CISUB3CHAR10 Substring 3 of Commitment Item
CISUB4_ESFM_CISUB4CHAR10 Substring 4 of Commitment Item
CISUB5_ESFM_CISUB5CHAR10 Substring 5 of Commitment Item
LOTKZ_ESPSO_LOTKZCHAR10 Lot Number for RequestsALPHA
.APPENDFPCLS_CO_ITEM_DATA Chorus Erweiterungen
EBELN_COEBELNCHAR10
*
Purchasing Document NumberALPHA
SAPLONGNUM/SAPPSPRO/LONGNUMCHAR40 Smart Number
KBLNRKBLNRCHAR10
*
Document Number for Earmarked FundsALPHA
ACCOUNTANTFPCR_ACCOUNTANTCHAR6 Accountant
CO_STATUSFPCL_CO_STATNUMC2 Status of Garnishment
STCD2STCD2CHAR11 Tax Number 2
.INCLUDEFPRLS_EXCEPTION_DATA Exception Data
POKENPOKENCHAR3 Item Indicator
ZLSPRDZLSPRCHAR1 T008Payment Block Key

.INCLUDEFPRLS_PAYMENT_DATA Payment Data
LAUFD_PAYLAUFDDATS8 Date on Which the Program Is to Be Run
LAUFI_PAYLAUFICHAR6 Additional Identification
VBLNR_PAYVBLNRCHAR10 Document Number of the Payment DocumentALPHA
PYORD_PAYPYORDCHAR10 Payment OrderALPHA
XF110_EXECFLAGCHAR1 General Flag
LAUFDFPRL_LAUFDDATS8 Date of Proposal Run
LAUFIFPRL_LAUFICHAR6 Payment Proposal
JOBCOUNTBTCJOBCNTCHAR8 Job ID
ZBUKRDZBUKRCHAR4 T001Paying company code
ABSBUABSBUCHAR4
*
Sending company code
ZNME1DZNME1CHAR35 Name of the payee
ZPSTLDZPSTLCHAR10 Postal code of the payee
ZORT1DZORT1CHAR35 City of the payee
ZLANDDZLANDCHAR3
*
Country Key
ZREGIDZREGICHAR3
*
Regional code of the payee
ZSPRADZSPRALANG1
*
Language key of the payeeISOLA
NAME1NAME1_GPCHAR35 Name 1
ZBVTYDZBVTYCHAR4 Bank Data Indicator for the Payee
ZBNKSDZBNKSCHAR3
*
Country Key
ZBNKYDZBNKYCHAR15 Bank key of the payee's bank
ZBNKLDZBNKLCHAR15 Bank number of the payee's bank
ZBNKNDZBNKNCHAR18 Bank account number of the payee
ZBKONDZBKONCHAR2 Bank Control Key of the Payee's Bank
BKREFBKREFCHAR20 Reference specifications for bank details
ZSWIFSWIFTCHAR11 SWIFT/BIC for International Payments
ZIBANIBANCHAR34 IBAN (International Bank Account Number)
KOINHKOINH_FICHAR60 Account Holder Name
HKTIDHKTIDCHAR5
*
ID for account details
HBKIDHBKIDCHAR5 T012Short Key for a House Bank
UBNKSBANKSCHAR3
*
Bank country key
UBNKYUBNKYCHAR15 Bank key of our bank
UBNKLUBNKLCHAR15 Bank number of our bank
UBKNTUBKNTCHAR18 Our account number at the bank
UBKONUBKONCHAR2 Bank control key at our bank
UBHKTUBHKTCHAR10
*
G/L Account Number for Our Bank Account / Bank Sub-AccountALPHA
RZAWEDZLSCHCHAR1 T042ZPayment Method
UZAWEUZAWECHAR2 T042FPayment Method Supplement
DTAWSDTAWSCHAR2
*
Instruction key for data medium exchange
ZALDTDZALDT_ZHLDATS8 Posting date of the payment document
VALUTVALUTDATS8 Value date
AUSFDAUSFDDATS8 Due date of the paid items
ANFAEANFAEDATS8 Bill of Exchange Payment Request Due Date
WEFAEWEFAEDATS8 Bill of Exchange Due Date
WDATEWDATEDATS8 Bill of Exchange Issue Date
BUSABBUSABCHAR2
*
Accounting clerk
EIKTOEIKTOCHAR12 Shipper's (Our) Account Number at the Customer or Vendor
KIDNOKIDNOCHAR30 Payment Reference
RFTTRNRFTTRN_BFCHAR20 Payment code
BTYP1BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS1BANKSCHAR3
*
Bank country key
BNKL1BANKKCHAR15 Bank Keys
BNKN1BANKNCHAR18 Bank account number
BTYP2BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS2BANKSCHAR3
*
Bank country key
BNKL2BANKKCHAR15 Bank Keys
BNKN2BANKNCHAR18 Bank account number
BTYP3BNTYPCHAR1 Type of bank in a bank chain (correspondent, intermediary)
BNKS3BANKSCHAR3
*
Bank country key
BNKL3BANKKCHAR15 Bank Keys
BNKN3BANKNCHAR18 Bank account number
MGUIDSEPA_MGUIDRAW16 SEPA Mandate: GUID of Mandate
MNDIDSEPA_MNDIDCHAR35 Unique Referene to Mandate per Payment Recipient
.INCLUDEFPRLS_ITEM_DATA_INV Item Data Invoice Reference
INV_NOFPRL_REBZGCHAR10 Document Number or Invoice Reference NumberALPHA
INV_YEARFPRL_REBZJNUMC4 Fiscal Year of DocNo/Inf.ref.GJAHR
INV_ITEMFPRL_REBZZNUMC3 Line Item within Accounting Document or Relevant Invoice



Key field
Non-key field