FPRL_ITEM is a SAP table coming under FI module and SAP_FIN component.View details, Fields & related tables of FPRL_ITEM in SAP.
- Table description : Item Data
- Module : FI-AP-AP-PT
- Parent Module : FI
- Package : FIN_PRL
- Software Component : SAP_FIN
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP FPRL_ITEM Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
GUID | UUID in X form (binary) | SYSUUID_X | SYSUUID |
.INCLUDE | Item Status | ||
LIST_ID | Payment Release List ID | FPRL_LIST_ID | NUMC10 |
STATUS | Item Status ID | FPRL_ITEM_STATUS | CHAR3 |
ALEVEL | Approval Level | FPRL_LEVEL | NUM02 |
.INCLUDE | List Data | ||
CREA_USER | Created By | FPRL_USER | USNAM |
CREA_TIME | Created On | FPRL_CREA_TIME | FPRL_TIMESTAMP |
CHANGE_USER | Last Changed By | FPRL_USER_CH | USNAM |
CHANGE_TIME | Last Changed On | FPRL_CHANGE_TIME | FPRL_TIMESTAMP |
APPLIC | Payment Release List Application ID | FPRL_APPLICATION | FPRL_APPLICATION |
.INCLUDE | Item Data | ||
BUKRS | Company Code | BUKRS | BUKRS |
BELNR | Accounting Document Number | BELNR_D | BELNR |
GJAHR | Fiscal Year | GJAHR | GJAHR |
BUZEI | Number of Line Item Within Accounting Document | BUZEI | BUZEI |
LIFNR | Account Number of Vendor or Creditor | LIFNR | LIFNR |
KUNNR | Customer Number | KUNNR | KUNNR |
FILKD | Account Number of the Branch | FILKD | MAXKK |
EMPFB | Payee/Payer | EMPFB | MAXKK |
VBUND | Company ID of trading partner | RASSC | RCOMP |
SHKZG | Debit/Credit Indicator | SHKZG | SHKZG |
WAERS | Currency Key | WAERS | WAERS |
WRBTR | Amount in document currency | WRBTR | WERT7 |
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | WERT7 |
WSKTO | Cash Discount Amount in Document Currency | WSKTO | WERT7 |
QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB | WERT7 |
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | WAERS |
PSWBT | Amount for Updating in General Ledger | PSWBT | WERT7 |
PSSKT | Cash Discount Deduction for the Item | PSSKT | WRTV7 |
BLART | Document type | BLART | BLART |
BUDAT | Posting Date in the Document | BUDAT | DATUM |
BLDAT | Document Date in Document | BLDAT | DATUM |
KOART | Account type | KOART | KOART |
BSCHL | Posting Key | BSCHL | BSCHL |
HKONT | General Ledger Account | HKONT | SAKNR |
SAKNR | G/L Account Number | SAKNR | SAKNR |
UMSKZ | Special G/L Indicator | UMSKZ | UMSKZ |
GSBER | Business Area | GSBER | GSBER |
MWSKZ | Tax on sales/purchases code | MWSKZ | MWSKZ |
QSSKZ | Withholding Tax Code | QSSKZ | QSSKZ |
SGTXT | Item Text | SGTXT | TEXT50 |
ZFBDT | Baseline date for due date calculation | DZFBDT | DATUM |
ZBD1T | Cash discount days 1 | DZBD1T | ZBDXT |
ZBD2T | Cash discount days 2 | DZBD2T | ZBDXT |
ZBD3T | Net Payment Terms Period | DZBD3T | ZBDXT |
ZBD1P | Cash discount percentage 1 | DZBD1P | PRZ23 |
ZBD2P | Cash Discount Percentage 2 | DZBD2P | PRZ23 |
XREBZ | Indicator: Item is an Invoice-Related Credit Memo | XREBZ | XFELD |
ESRNR | POR subscriber number | ESRNR | ESRNR |
ESRRE | POR reference number | ESRRE | ESRRE |
ESRPZ | POR check digit | ESRPZ | CHAR2 |
EBELN | Purchasing Document Number | EBELN | EBELN |
EBELP | Item Number of Purchasing Document | EBELP | EBELP |
STCEG | VAT Registration Number | STCEG | STCEG |
XBLNR | Reference Document Number | XBLNR1 | XBLNR1 |
LZBKZ | State central bank indicator | LZBKZ | LZBKZ |
LANDL | Supplying Country | LANDL | LAND1 |
NPLNR | Network Number for Account Assignment | NPLNR | AUFNR |
AUFPL | Routing number of operations in the order | CO_AUFPL | AUFPL |
ZUONR | Assignment number | DZUONR | ZUONR |
VERTN | Contract Number | RANL | RANL |
REBZT | Follow-On Document Type | REBZT | REBZT |
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | BELNR |
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | GJAHR |
REBZZ | Line Item in the Relevant Invoice | REBZZ | BUZEI |
KOSTL | Cost Center | KOSTL | KOSTL |
VBEL2 | Sales Document | VBELN_VA | VBELN |
POSN2 | Sales Document Item | POSNR_VA | POSNR |
PRCTR | Profit Center | PRCTR | PRCTR |
XREF1 | Business partner reference key | XREF1 | CHAR12 |
XREF2 | Business partner reference key | XREF2 | CHAR12 |
XREF3 | Reference key for line item | XREF3 | CHAR20 |
DTWS1 | Instruction key 1 | DTAT16 | DTWSX |
DTWS2 | Instruction key 2 | DTAT17 | DTWSX |
DTWS3 | Instruction key 3 | DTAT18 | DTWSX |
DTWS4 | Instruction key 4 | DTAT19 | DTWSX |
XCPDD | Indicator: Address and Bank Data Set Individually | XCPDD | XFELD |
BUPLA | Business Place | BUPLA | J_1BBRANCH |
PPRCT | Partner Profit Center | PPRCTR | PRCTR |
GRANT_NBR | Grant | GM_GRANT_NBR | GM_GRANT_NBR |
FKBER | Functional Area | FKBER | FKBER |
GEBER | Fund | BP_GEBER | BP_GEBER |
XINVE | Indicator: Capital Goods Affected? | XINVE | XFELD |
KEYNO | Key Number for Payment Request | PRQ_KEYNO | PRQ_KEYNO |
PAMTF | Payment Request Amount in Payment Currency | PRQ_AMTFC | WERT7 |
ORIGIN | Origin Indicator | FIBL_ORIGIN | FIBL_ORIGIN |
.INCLU--AP | EPIC Append Structure for FPRLS_ITEM_DATA | ||
EPIC_PROCESSOR | Processor | EPIC_PROCESSOR | XUBNAME |
EPIC_STATUS | Item Status | EPIC_ITEM_STATUS | EPIC_ITEM_STATUS |
.INCLU--AP | Chorus Erweiterungen | ||
EBELN_CO | Purchasing Document Number | EBELN | EBELN |
SAPLONGNUM | Smart Number | /SAPPSPRO/LONGNUM | /SAPPSPRO/LONGNUM |
KBLNR | Document Number for Earmarked Funds | KBLNR | KBLNR |
ACCOUNTANT | Accountant | FPCR_ACCOUNTANT | FPCR_ACCOUNTANT |
CO_STATUS | Status of Garnishment | FPCL_CO_STAT | FPCL_CO_STAT |
STCD2 | Tax Number 2 | STCD2 | STCD2 |
.INCLUDE | Exception Data | ||
POKEN | Item Indicator | POKEN | CHAR3 |
ZLSPR | Payment Block Key | DZLSPR | ZAHLS |
.INCLUDE | Payment Data | ||
LAUFD_PAY | Date on Which the Program Is to Be Run | LAUFD | DATUM |
LAUFI_PAY | Additional Identification | LAUFI | LAUFI |
VBLNR_PAY | Document Number of the Payment Document | VBLNR | BELNR |
PYORD_PAY | Payment Order | PYORD | PYORD |
XF110_EXEC | General Flag | FLAG | FLAG |
LAUFD | Date of Proposal Run | FPRL_LAUFD | DATUM |
LAUFI | Payment Proposal | FPRL_LAUFI | LAUFI |
JOBCOUNT | Job ID | BTCJOBCNT | CHAR8 |
ZBUKR | Paying company code | DZBUKR | BUKRS |
ABSBU | Sending company code | ABSBU | BUKRS |
ZNME1 | Name of the payee | DZNME1 | TEXT35 |
ZPSTL | Postal code of the payee | DZPSTL | PSTLZ |
ZORT1 | City of the payee | DZORT1 | TEXT35 |
ZLAND | Country Key | DZLAND | LAND1 |
ZREGI | Regional code of the payee | DZREGI | REGIO |
ZSPRA | Language key of the payee | DZSPRA | SPRAS |
NAME1 | Name 1 | NAME1_GP | NAME |
ZBVTY | Bank Data Indicator for the Payee | DZBVTY | BVTYP |
ZBNKS | Country Key | DZBNKS | LAND1 |
ZBNKY | Bank key of the payee's bank | DZBNKY | BANKK |
ZBNKL | Bank number of the payee's bank | DZBNKL | BANKL |
ZBNKN | Bank account number of the payee | DZBNKN | BANKN |
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | BKONT |
BKREF | Reference specifications for bank details | BKREF | CHAR20 |
ZSWIF | SWIFT/BIC for International Payments | SWIFT | SWIFT |
ZIBAN | IBAN (International Bank Account Number) | IBAN | IBAN |
KOINH | Account Holder Name | KOINH_FI | KOINH |
HKTID | ID for account details | HKTID | HKTID |
HBKID | Short key for a house bank | HBKID | HBKID |
UBNKS | Bank country key | BANKS | LAND1 |
UBNKY | Bank key of our bank | UBNKY | BANKK |
UBNKL | Bank number of our bank | UBNKL | BANKL |
UBKNT | Our account number at the bank | UBKNT | BANKN |
UBKON | Bank control key at our bank | UBKON | BKONT |
UBHKT | G/L Account Number for Our Bank Account / Bank Sub-Account | UBHKT | SAKNR |
RZAWE | Payment method | DZLSCH | ZLSCH |
UZAWE | Payment method supplement | UZAWE | UZAWE |
DTAWS | Instruction key for data medium exchange | DTAWS | DTAWS |
ZALDT | Posting date of the payment document | DZALDT_ZHL | DATUM |
VALUT | Fixed Value Date | VALUT | DATUM |
AUSFD | Due date of the paid items | AUSFD | DATUM |
ANFAE | Bill of Exchange Payment Request Due Date | ANFAE | DATUM |
WEFAE | Bill of Exchange Due Date | WEFAE | DATUM |
WDATE | Bill of Exchange Issue Date | WDATE | DATUM |
BUSAB | Accounting clerk | BUSAB | BUSAB |
EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR12 |
KIDNO | Payment Reference | KIDNO | CHAR30 |
RFTTRN | Payment code | RFTTRN_BF | RFTTRN_BF |
BTYP1 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | BNTYP |
BNKS1 | Bank country key | BANKS | LAND1 |
BNKL1 | Bank Keys | BANKK | BANKK |
BNKN1 | Bank account number | BANKN | BANKN |
BTYP2 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | BNTYP |
BNKS2 | Bank country key | BANKS | LAND1 |
BNKL2 | Bank Keys | BANKK | BANKK |
BNKN2 | Bank account number | BANKN | BANKN |
BTYP3 | Type of bank in a bank chain (correspondent, intermediary) | BNTYP | BNTYP |
BNKS3 | Bank country key | BANKS | LAND1 |
BNKL3 | Bank Keys | BANKK | BANKK |
BNKN3 | Bank account number | BANKN | BANKN |
MGUID | SEPA Mandate: GUID of Mandate | SEPA_MGUID | |
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | ID035 |
.INCLUDE | Item Data Invoice Reference | ||
INV_NO | Document Number or Invoice Reference Number | FPRL_REBZG | BELNR |
INV_YEAR | Fiscal Year of DocNo/Inf.ref. | FPRL_REBZJ | GJAHR |
INV_ITEM | Line Item within Accounting Document or Relevant Invoice | FPRL_REBZZ | BUZEI |
.INCLUDE |
FPRL_ITEM related tables
Table | Note |
---|---|
CDBD_SRV_I | CDB table for Item Extension - Transaction Item - Service |
CMP_POSTYP | Item Category Customizing Complaints Proc. Credit Memo Item |
CRMC_FICA_AR_ITM | Item Categories (Adjustment Request Item - FI-CA Document) |
CRMC_FS_MGP_MG | Item Grouping Assignment to Item Grouping Profile |
CRMC_IT_COPY_IF | Copy Item Categories - Item Category Determination |
CRMC_UIU_IL_CNTL | Function Profile to control item list and item search |
CRMC_UIU_IL_CNTT | Function Profile to control item list and item search |
CWTY012Z | Assignment Item Type - Item Types Group |
DBERDLB | Reference of a Print Doc. Line Item to a Bill.Doc. Line Item |
HUMSEG | Reference-HU-Item for Material Doc.Item that was Posted Last |
LSOTACASEGRPITEM | Assignment: Test - Section - Item Group - Item |
LSOTACITEM200 | Item and Item Attributes |
OIJEDIITYP | Assign nomination item type to IDoc item |
RSZWMDITEM | BW Web Metadata: Template Item ( Dataprovider, Item, ... ). |
TFMIG04 | Allocation: FS Item -> FS Item |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP