SAP ABAP Table EPIC_S_ITEM (Structure of Payment Item)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-EPIC-GEN-UI (Package) Globalization: E-Payment Integration User Interface Objects
Basic Data
Table Category INTTAB    Structure 
Structure EPIC_S_ITEM   Table Relationship Diagram
Short Description Structure of Payment Item    
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 Data  
2 GUID SYSUUID_X SYSUUID RAW 16   0   UUID in X form (binary)  
3 .INCLUDE       0   0   Item Status  
4 LIST_ID FPRL_LIST_ID NUMC10 NUMC 10   0   Payment Release List ID FPRL_HEADER
5 STATUS FPRL_ITEM_STATUS CHAR3 CHAR 3   0   Item Status ID FPRL_ITEM_STAT
6 ALEVEL FPRL_LEVEL NUM02 NUMC 2   0   Approval Level FPRL_LEVELS
7 .INCLUDE       0   0   List Data  
8 CREA_USER FPRL_USER USNAM CHAR 12   0   Created By  
9 CREA_TIME FPRL_CREA_TIME FPRL_TIMESTAMP DEC 15   0   Created On  
10 CHANGE_USER FPRL_USER_CH USNAM CHAR 12   0   Last Changed By  
11 CHANGE_TIME FPRL_CHANGE_TIME FPRL_TIMESTAMP DEC 15   0   Last Changed On  
12 APPLIC FPRL_APPLICATION FPRL_APPLICATION CHAR 10   0   Payment Release List Application ID FPRL_APPLIC
13 .INCLUDE       0   0   Item Data  
14 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
15 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
16 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
17 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
18 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
19 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
20 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
21 EMPFB EMPFB MAXKK CHAR 10   0   Payee/Payer  
22 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
23 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
24 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
25 WRBTR WRBTR WERT7 CURR 13   2   Amount in document currency  
26 SKFBT SKFBT WERT7 CURR 13   2   Amount Eligible for Cash Discount in Document Currency  
27 WSKTO WSKTO WERT7 CURR 13   2   Cash Discount Amount in Document Currency  
28 QBSHB QBSHB WERT7 CURR 13   2   Withholding Tax Amount (in Document Currency)  
29 PSWSL PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures *
30 PSWBT PSWBT WERT7 CURR 13   2   Amount for Updating in General Ledger  
31 PSSKT PSSKT WRTV7 CURR 13   2   Cash Discount Deduction for the Item  
32 BLART BLART BLART CHAR 2   0   Document type T003
33 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
34 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
35 KOART KOART KOART CHAR 1   0   Account type  
36 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
37 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account SKB1
38 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number SKB1
39 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator T074U
40 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
41 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
42 QSSKZ QSSKZ QSSKZ CHAR 2   0   Withholding Tax Code *
43 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
44 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
45 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
46 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
47 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
48 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
49 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
50 XREBZ XREBZ XFELD CHAR 1   0   Indicator: Item is an Invoice-Related Credit Memo  
51 ESRNR ESRNR ESRNR CHAR 11   0   POR subscriber number  
52 ESRRE ESRRE ESRRE CHAR 27   0   POR reference number  
53 ESRPZ ESRPZ CHAR2 CHAR 2   0   POR check digit  
54 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
55 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
56 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
57 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
58 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator T015L
59 LANDL LANDL LAND1 CHAR 3   0   Supplying Country T005
60 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
61 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
62 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
63 VERTN RANL RANL CHAR 13   0   Contract Number  
64 REBZT REBZT REBZT CHAR 1   0   Follow-On Document Type  
65 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
66 REBZJ REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
67 REBZZ REBZZ BUZEI NUMC 3   0   Line Item in the Relevant Invoice  
68 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
69 VBEL2 VBELN_VA VBELN CHAR 10   0   Sales Document *
70 POSN2 POSNR_VA POSNR NUMC 6   0   Sales Document Item *
71 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
72 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
73 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
74 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
75 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
76 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
77 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
78 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
79 XCPDD XCPDD XFELD CHAR 1   0   Indicator: Address and Bank Data Set Individually  
80 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
81 PPRCT PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
82 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
83 FKBER FKBER FKBER CHAR 16   0   Functional Area *
84 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
85 XINVE XINVE XFELD CHAR 1   0   Indicator: Capital Goods Affected?  
86 KEYNO PRQ_KEYNO PRQ_KEYNO CHAR 10   0   Key Number for Payment Request *
87 PAMTF PRQ_AMTFC WERT7 CURR 13   2   Payment Request Amount in Payment Currency  
88 ORIGIN FIBL_ORIGIN FIBL_ORIGIN CHAR 8   0   Origin Indicator *
89 .INCLU--AP       0   0   EPIC Append Structure for FPRLS_ITEM_DATA  
90 EPIC_PROCESSOR EPIC_PROCESSOR XUBNAME CHAR 12   0   Processor *
91 EPIC_STATUS EPIC_ITEM_STATUS EPIC_ITEM_STATUS CHAR 3   0   Item Status  
92 .INCLU--AP       0   0   Chorus Erweiterungen  
93 EBELN_CO EBELN EBELN CHAR 10   0   Purchasing Document Number *
94 SAPLONGNUM /SAPPSPRO/LONGNUM /SAPPSPRO/LONGNUM CHAR 40   0   Smart Number  
95 KBLNR KBLNR KBLNR CHAR 10   0   Document Number for Earmarked Funds *
96 ACCOUNTANT FPCR_ACCOUNTANT FPCR_ACCOUNTANT CHAR 6   0   Accountant  
97 CO_STATUS FPCL_CO_STAT FPCL_CO_STAT NUMC 2   0   Status of Garnishment  
98 STCD2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
99 .INCLUDE       0   0   Exception Data  
100 POKEN POKEN CHAR3 CHAR 3   0   Item Indicator  
101 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
102 .INCLUDE       0   0   Payment Data  
103 LAUFD_PAY LAUFD DATUM DATS 8   0   Date on Which the Program Is to Be Run  
104 LAUFI_PAY LAUFI LAUFI CHAR 6   0   Additional Identification  
105 VBLNR_PAY VBLNR BELNR CHAR 10   0   Document Number of the Payment Document  
106 PYORD_PAY PYORD PYORD CHAR 10   0   Payment Order  
107 XF110_EXEC FLAG FLAG CHAR 1   0   General Flag  
108 LAUFD FPRL_LAUFD DATUM DATS 8   0   Date of Proposal Run  
109 LAUFI FPRL_LAUFI LAUFI CHAR 6   0   Payment Proposal  
110 JOBCOUNT BTCJOBCNT CHAR8 CHAR 8   0   Job ID  
111 ZBUKR DZBUKR BUKRS CHAR 4   0   Paying company code T001
112 ABSBU ABSBU BUKRS CHAR 4   0   Sending company code *
113 ZNME1 DZNME1 TEXT35 CHAR 35   0   Name of the payee  
114 ZPSTL DZPSTL PSTLZ CHAR 10   0   Postal code of the payee  
115 ZORT1 DZORT1 TEXT35 CHAR 35   0   City of the payee  
116 ZLAND DZLAND LAND1 CHAR 3   0   Country Key *
117 ZREGI DZREGI REGIO CHAR 3   0   Regional code of the payee *
118 ZSPRA DZSPRA SPRAS LANG 1   0   Language key of the payee *
119 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
120 ZBVTY DZBVTY BVTYP CHAR 4   0   Bank Data Indicator for the Payee  
121 ZBNKS DZBNKS LAND1 CHAR 3   0   Country Key *
122 ZBNKY DZBNKY BANKK CHAR 15   0   Bank key of the payee's bank  
123 ZBNKL DZBNKL BANKL CHAR 15   0   Bank number of the payee's bank  
124 ZBNKN DZBNKN BANKN CHAR 18   0   Bank account number of the payee  
125 ZBKON DZBKON BKONT CHAR 2   0   Bank Control Key of the Payee's Bank  
126 BKREF BKREF CHAR20 CHAR 20   0   Reference specifications for bank details  
127 ZSWIF SWIFT SWIFT CHAR 11   0   SWIFT/BIC for International Payments  
128 ZIBAN IBAN IBAN CHAR 34   0   IBAN (International Bank Account Number)  
129 KOINH KOINH_FI KOINH CHAR 60   0   Account Holder Name  
130 HKTID HKTID HKTID CHAR 5   0   ID for account details *
131 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank T012
132 UBNKS BANKS LAND1 CHAR 3   0   Bank country key *
133 UBNKY UBNKY BANKK CHAR 15   0   Bank key of our bank  
134 UBNKL UBNKL BANKL CHAR 15   0   Bank number of our bank  
135 UBKNT UBKNT BANKN CHAR 18   0   Our account number at the bank  
136 UBKON UBKON BKONT CHAR 2   0   Bank control key at our bank  
137 UBHKT UBHKT SAKNR CHAR 10   0   G/L Account Number for Our Bank Account / Bank Sub-Account *
138 RZAWE DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
139 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
140 DTAWS DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange *
141 ZALDT DZALDT_ZHL DATUM DATS 8   0   Posting date of the payment document  
142 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
143 AUSFD AUSFD DATUM DATS 8   0   Due date of the paid items  
144 ANFAE ANFAE DATUM DATS 8   0   Bill of Exchange Payment Request Due Date  
145 WEFAE WEFAE DATUM DATS 8   0   Bill of Exchange Due Date  
146 WDATE WDATE DATUM DATS 8   0   Bill of Exchange Issue Date  
147 BUSAB BUSAB BUSAB CHAR 2   0   Accounting clerk *
148 EIKTO EIKTO CHAR12 CHAR 12   0   Shipper's (Our) Account Number at the Customer or Vendor  
149 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
150 RFTTRN RFTTRN_BF RFTTRN_BF CHAR 20   0   Payment code  
151 BTYP1 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
152 BNKS1 BANKS LAND1 CHAR 3   0   Bank country key *
153 BNKL1 BANKK BANKK CHAR 15   0   Bank Keys  
154 BNKN1 BANKN BANKN CHAR 18   0   Bank account number  
155 BTYP2 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
156 BNKS2 BANKS LAND1 CHAR 3   0   Bank country key *
157 BNKL2 BANKK BANKK CHAR 15   0   Bank Keys  
158 BNKN2 BANKN BANKN CHAR 18   0   Bank account number  
159 BTYP3 BNTYP BNTYP CHAR 1   0   Type of bank in a bank chain (correspondent, intermediary)  
160 BNKS3 BANKS LAND1 CHAR 3   0   Bank country key *
161 BNKL3 BANKK BANKK CHAR 15   0   Bank Keys  
162 BNKN3 BANKN BANKN CHAR 18   0   Bank account number  
163 MGUID SEPA_MGUID   RAW 16   0   SEPA Mandate: GUID of Mandate  
164 MNDID SEPA_MNDID ID035 CHAR 35   0   Unique Referene to Mandate per Payment Recipient  
165 .INCLUDE       0   0   Item Data Invoice Reference  
166 INV_NO FPRL_REBZG BELNR CHAR 10   0   Document Number or Invoice Reference Number  
167 INV_YEAR FPRL_REBZJ GJAHR NUMC 4   0   Fiscal Year of DocNo/Inf.ref.  
168 INV_ITEM FPRL_REBZZ BUZEI NUMC 3   0   Line Item within Accounting Document or Relevant Invoice  
169 .INCLUDE       0   0    
170 .INCLUDE       0   0   Item Texts and Amounts  
171 .INCLUDE       0   0   Item Status Text  
172 STATUS_DESCR FPRL_ITEM_STATUS_DESCR TEXT40 CHAR 40   0   Item Status  
173 LEVEL_DESCR FPRL_LEVEL_DESCR TEXT40 CHAR 40   0   Approval Level Description  
174 .INCLUDE       0   0   Item Data Text  
175 LTEXT LTEXT_003T TEXT20 CHAR 20   0   Document Type Description  
176 TEXT_BSLT TEXT_BSLT TEXT20 CHAR 20   0   Name of the Posting Key  
177 .INCLUDE       0   0   Item Data Amounts (with Sign)  
178 WRBTR_V WRBTV WRTV7 CURR 13   2   Gross Amount in Foreign Currency with +/- Signs  
179 SKFBT_V SKFBT_VZ WRTV7 CURR 13   2   Amount Subject to Discount in Document Curr. with +/- Sign  
180 WSKTO_V FPRL_WSKTO_VZ WRTV7 CURR 13   2   Cash discount amount in document curr. with +/- sign for PRL  
181 QBSHB_V QBSHB_VZ WRTV7 CURR 13   2   Withholding Tax Amount (in Doc. Currency) with +/- Sign  
182 PSWBT_V PSWBTV WRTV7 CURR 13   2   G/L Amount with +/- Sign  
183 PSSKT_V FPRL_PSSKT WRTV7 CURR 13   2   Cash Discount Deduction for the Item at proposal date  
184 .INCLUDE       0   0   Payment Data Text  
185 SNAME SNAME_001S TEXT30 CHAR 30   0   Name of Accounting Clerk  
186 BANKA BANKA TEXT60 CHAR 60   0   Name of bank  
187 TEXT1 TEXT1_042Z TEXT30 CHAR 30   0   Name of Payment Method in Language of the Country  
188 .INCLUDE       0   0   Exception Data Text  
189 TEXT NATXT NATXT CHAR 73   0   Message Text  
190 COLOR CHAR04 CHAR4 CHAR 4   0   Data Type 4 Characters  
191 .INCLUDE       0   0   Transient Fields  
192 EPIC_LINECOLOR     CHAR 4   0    
193 EPIC_CELLTAB LVC_T_STYL   TTYP 0   0    
194 EPIC_STATUS_ICON EPIC_AS_ITEM_STATUS_ICON   CHAR 30   0   Approval Step Status  
195 EPIC_STATUS_DESCR EPIC_ITEM_STATUS_DESCR TEXT40 CHAR 40   0   Item Status  
196 EPIC_VENDOR_NAME EPIC_ITEM_VENDOR_NAME NAME CHAR 35   0   Vendor Name  
197 EPIC_CUSTOMER_NAME EPIC_ITEM_CUSTOMER_NAME NAME CHAR 35   0   Customer Name  
198 EPIC_FILE_EXISTS FLAG FLAG CHAR 1   0   General Flag  
199 EPIC_FILE_EXISTS_ICON EPIC_FILE_EXISTS_ICON   CHAR 30   0   File Created  
200 EPIC_CCB_CONSUMED_LITEMS EPIC_CCB_CONSUMED_LITEMS   CHAR 18   0   Assigned Liquidity Items from Cash Budget  
201 EPIC_ITEM_SOURCE EPIC_ITEM_SOURCE EPIC_ITEM_SOURCE CHAR 3   0   Source of Item to Be Paid  
202 EPIC_ITEM_SOURCE_DESCR EPIC_ITEM_SOURCE_DESCR TEXT40 CHAR 40   0   Description of Source of Item to Be Paid  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 EPIC_S_ITEM ALEVEL FPRL_LEVELS ALEVEL KEY    
2 EPIC_S_ITEM APPLIC FPRL_APPLIC APPLICATION KEY    
3 EPIC_S_ITEM BLART T003 BLART REF 1 CN
4 EPIC_S_ITEM BSCHL TBSL BSCHL REF 1 CN
5 EPIC_S_ITEM BUKRS T001 BUKRS KEY 1 CN
6 EPIC_S_ITEM EBELN EKKO EBELN REF C CN
7 EPIC_S_ITEM EBELP EKPO EBELP REF C CN
8 EPIC_S_ITEM GSBER TGSB GSBER REF C CN
9 EPIC_S_ITEM HBKID T012 HBKID REF 1 CN
10 EPIC_S_ITEM HKONT SKB1 SAKNR REF 1 CN
11 EPIC_S_ITEM KUNNR KNA1 KUNNR    
12 EPIC_S_ITEM LANDL T005 LAND1 REF C CN
13 EPIC_S_ITEM LIFNR LFA1 LIFNR KEY 1 CN
14 EPIC_S_ITEM LIST_ID FPRL_HEADER LIST_ID KEY    
15 EPIC_S_ITEM LZBKZ T015L LZBKZ REF C CN
16 EPIC_S_ITEM RZAWE T042Z ZLSCH REF 1 CN
17 EPIC_S_ITEM SAKNR SKB1 SAKNR REF C CN
18 EPIC_S_ITEM STATUS FPRL_ITEM_STAT STATUS    
19 EPIC_S_ITEM UMSKZ T074U UMSKZ REF C CN
20 EPIC_S_ITEM UZAWE T042F UZAWE REF C CN
21 EPIC_S_ITEM VBUND T880 RCOMP REF C CN
22 EPIC_S_ITEM WAERS TCURC WAERS REF 1 CN
23 EPIC_S_ITEM ZBUKR T001 BUKRS KEY 1 CN
24 EPIC_S_ITEM ZLSPR T008 ZAHLS REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 606