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