SAP ABAP Table FPRLS_ITEM_SEARCH (Payment Release List: Item fields to be used in search list)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-AP-AP-PT (Application Component) Payment Transactions
     ⤷ FIN_PRL (Package) Payment Release List
Basic Data
Table Category INTTAB    Structure 
Structure FPRLS_ITEM_SEARCH   Table Relationship Diagram
Short Description Payment Release List: Item fields to be used in search list    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   Item Status  
2 LIST_ID FPRL_LIST_ID NUMC10 NUMC 10   0   Payment Release List ID FPRL_HEADER
3 STATUS FPRL_ITEM_STATUS CHAR3 CHAR 3   0   Item Status ID FPRL_ITEM_STAT
4 ALEVEL FPRL_LEVEL NUM02 NUMC 2   0   Approval Level FPRL_LEVELS
5 .INCLUDE       0   0   Item Data  
6 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
7 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
8 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
9 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
10 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
11 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
12 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
13 EMPFB EMPFB MAXKK CHAR 10   0   Payee/Payer  
14 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
15 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
16 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
17 WRBTR WRBTR WERT7 CURR 13   2   Amount in document currency  
18 SKFBT SKFBT WERT7 CURR 13   2   Amount Eligible for Cash Discount in Document Currency  
19 WSKTO WSKTO WERT7 CURR 13   2   Cash Discount Amount in Document Currency  
20 QBSHB QBSHB WERT7 CURR 13   2   Withholding Tax Amount (in Document Currency)  
21 PSWSL PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures *
22 PSWBT PSWBT WERT7 CURR 13   2   Amount for Updating in General Ledger  
23 PSSKT PSSKT WRTV7 CURR 13   2   Cash Discount Deduction for the Item  
24 BLART BLART BLART CHAR 2   0   Document type T003
25 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
26 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
27 KOART KOART KOART CHAR 1   0   Account type  
28 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
29 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account SKB1
30 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number SKB1
31 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator T074U
32 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
33 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
34 QSSKZ QSSKZ QSSKZ CHAR 2   0   Withholding Tax Code *
35 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
36 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
37 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
38 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
39 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
40 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
41 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
42 XREBZ XREBZ XFELD CHAR 1   0   Indicator: Item is an Invoice-Related Credit Memo  
43 ESRNR ESRNR ESRNR CHAR 11   0   POR subscriber number  
44 ESRRE ESRRE ESRRE CHAR 27   0   POR reference number  
45 ESRPZ ESRPZ CHAR2 CHAR 2   0   POR check digit  
46 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
47 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
48 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
49 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
50 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator T015L
51 LANDL LANDL LAND1 CHAR 3   0   Supplying Country T005
52 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
53 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
54 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
55 VERTN RANL RANL CHAR 13   0   Contract Number  
56 REBZT REBZT REBZT CHAR 1   0   Follow-On Document Type  
57 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
58 REBZJ REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
59 REBZZ REBZZ BUZEI NUMC 3   0   Line Item in the Relevant Invoice  
60 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
61 VBEL2 VBELN_VA VBELN CHAR 10   0   Sales Document *
62 POSN2 POSNR_VA POSNR NUMC 6   0   Sales Document Item *
63 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
64 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
65 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
66 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
67 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
68 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
69 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
70 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
71 XCPDD XCPDD XFELD CHAR 1   0   Indicator: Address and Bank Data Set Individually  
72 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
73 PPRCT PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
74 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
75 FKBER FKBER FKBER CHAR 16   0   Functional Area *
76 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
77 XINVE XINVE XFELD CHAR 1   0   Indicator: Capital Goods Affected?  
78 KEYNO PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request *
79 PAMTF PRQ_AMTFC WERT7 CURR 13   2   Payment Request Amount in Payment Currency  
80 ORIGIN FIBL_ORIGIN FIBL_ORIGIN CHAR 8   0   Origin Indicator *
81 .INCLU--AP       0   0   EPIC Append Structure for FPRLS_ITEM_DATA  
82 EPIC_PROCESSOR EPIC_PROCESSOR XUBNAME CHAR 12   0   Processor *
83 EPIC_STATUS EPIC_ITEM_STATUS EPIC_ITEM_STATUS CHAR 3   0   Item Status  
84 .INCLU--AP       0   0   Chorus Erweiterungen  
85 EBELN_CO EBELN EBELN CHAR 10   0   Purchasing Document Number *
86 SAPLONGNUM /SAPPSPRO/LONGNUM /SAPPSPRO/LONGNUM CHAR 40   0   Smart Number  
87 KBLNR KBLNR KBLNR CHAR 10   0   Document Number for Earmarked Funds *
88 ACCOUNTANT FPCR_ACCOUNTANT FPCR_ACCOUNTANT CHAR 6   0   Accountant  
89 CO_STATUS FPCL_CO_STAT FPCL_CO_STAT NUMC 2   0   Status of Garnishment  
90 STCD2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
91 .INCLUDE       0   0   List Data  
92 CREA_USER FPRL_USER USNAM CHAR 12   0   Created By  
93 CREA_TIME FPRL_CREA_TIME FPRL_TIMESTAMP DEC 15   0   Created On  
94 CHANGE_USER FPRL_USER_CH USNAM CHAR 12   0   Last Changed By  
95 CHANGE_TIME FPRL_CHANGE_TIME FPRL_TIMESTAMP DEC 15   0   Last Changed On  
96 APPLIC FPRL_APPLICATION FPRL_APPLICATION CHAR 10   0   Payment Release List Application ID FPRL_APPLIC
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FPRLS_ITEM_SEARCH ALEVEL FPRL_LEVELS ALEVEL KEY    
2 FPRLS_ITEM_SEARCH APPLIC FPRL_APPLIC APPLICATION KEY    
3 FPRLS_ITEM_SEARCH BLART T003 BLART REF 1 CN
4 FPRLS_ITEM_SEARCH BSCHL TBSL BSCHL REF 1 CN
5 FPRLS_ITEM_SEARCH BUKRS T001 BUKRS KEY 1 CN
6 FPRLS_ITEM_SEARCH EBELN EKKO EBELN REF C CN
7 FPRLS_ITEM_SEARCH EBELP EKPO EBELP REF C CN
8 FPRLS_ITEM_SEARCH GSBER TGSB GSBER REF C CN
9 FPRLS_ITEM_SEARCH HKONT SKB1 SAKNR REF 1 CN
10 FPRLS_ITEM_SEARCH KUNNR KNA1 KUNNR    
11 FPRLS_ITEM_SEARCH LANDL T005 LAND1 REF C CN
12 FPRLS_ITEM_SEARCH LIFNR LFA1 LIFNR KEY 1 CN
13 FPRLS_ITEM_SEARCH LIST_ID FPRL_HEADER LIST_ID KEY    
14 FPRLS_ITEM_SEARCH LZBKZ T015L LZBKZ REF C CN
15 FPRLS_ITEM_SEARCH SAKNR SKB1 SAKNR REF C CN
16 FPRLS_ITEM_SEARCH STATUS FPRL_ITEM_STAT STATUS    
17 FPRLS_ITEM_SEARCH UMSKZ T074U UMSKZ REF C CN
18 FPRLS_ITEM_SEARCH VBUND T880 RCOMP REF C CN
19 FPRLS_ITEM_SEARCH WAERS TCURC WAERS REF 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 617