/PF1/DB_ITEM_TL - Payment Items Template in the Payment Engine
Payment Items Template in the Payment Engine information is stored in SAP table /PF1/DB_ITEM_TL.
It is part of development package /PF1/PO_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "PO Processing Persistence Layer".
It is part of development package /PF1/PO_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "PO Processing Persistence Layer".
Fields for table /PF1/DB_ITEM_TL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| .INCLUDE | BUS_KEY | X | /PF1/STR_ITEM_TMPL_KEY | 0 | ||
| CLEARING_AREA | Clearing Area | X | /PF1/DTE_BPE_CLEARING_AREA | CHAR | 12 | * |
| TEMPLATE_PI_KEY | Globally Unique Identifier | X | GUID | RAW | 16 | |
| TEMPLATE_PO_KEY | Globally Unique Identifier | GUID | RAW | 16 | ||
| .INCLUDE | DATA | /PF1/STR_ITEM_TMPL_DATA | 0 | |||
| PI_KIND | Payment Item Category | /PF1/DTE_PO_PI_KIND | CHAR | 4 | ||
| REF_ITEM_EXT | External Item Reference | /PF1/DTE_PO_PI_REFITEM_SEC_KEY | CHAR | 70 | ||
| .INCLUDE | /PF1/STR_PO_PI_ACCT_SUB | 0 | ||||
| COUNTRY | Bank Country/Region | /PF1/DTE_PO_BNKCTY_AFTER_SUBST | CHAR | 6 | T005 | |
| BANKKEY | Bank Number | /PF1/DTE_PO_BNKCDE_AFTER_SUBST | CHAR | 30 | ||
| BIC | Bank Identifier Code (BIC) | /PF1/DTE_PO_BIC_AFTER_SUBST | CHAR | 22 | ||
| IBAN | IBAN After Account Substitution | /PF1/DTE_PO_IBAN_AFTER_SUBST | CHAR | 68 | ||
| ACCT_NO | Account Number | /PF1/DTE_PO_ACCT_AFTER_SUBST | CHAR | 68 | ||
| ACCT_CUR | Account Currency After Substitution | /PF1/DTE_PO_AC_CUR_AFT_SUBST | CUKY | 10 | TCURC | |
| HOLDER | Substitute Account Holder Name | /PF1/DTE_PO_HOLDERNAME_SUBST | CHAR | 160 | ||
| CLRSYSIDCD | Clearing System Member ID Code | /PF1/DTE_PO_CLRSYSMMBIDCD | CHAR | 10 | ||
| REF_COUNTRY | Ordering Party Bank Country/Region | /PF1/DTE_PO_ORP_COUNTRY | CHAR | 6 | T005 | |
| REF_BANKKEY | Ordering Party Domestic Bank Key | /PF1/DTE_PO_ORP_BANKKEY | CHAR | 30 | ||
| REF_BIC | Ordering Party Bank Internation Code(BIC) | /PF1/DTE_PO_ORP_BIC | CHAR | 22 | ||
| REF_IBAN | Ordering Party Account IBAN | /PF1/DTE_PO_ORP_IBAN | CHAR | 68 | ||
| REF_ACCT_NO | Ordering Party Account Number | /PF1/DTE_PO_ORP_ACCT_NO | CHAR | 68 | ||
| REF_ACCT_CUR | Ordering Party Account Currency | /PF1/DTE_PO_ORP_AC_CUR_NO | CUKY | 10 | TCURC | |
| REF_HOLDER | Reference Account Holder | /PF1/DTE_PO_ORP_HOLDER | CHAR | 160 | ||
| TR_CURR | Transaction Currency | /PF1/DTE_BPE_CURR | CUKY | 10 | * | |
| TR_AMOUNT | Amount in Transaction Currency | /PF1/DTE_BPE_AMOUNT | CURR | 12 | ||
| TR_DEBCREDIND | Transaction Debit/Credit | /PF1/DTE_BPE_DCFLG | CHAR | 2 | ||
| TR_FEE | Charge Amount | /PF1/DTE_PO_FEE_AMOUNT | CURR | 12 | ||
| FEE_DEBCRED | Charge Debit/Credit | /PF1/DTE_BPE_FEE_DC_FLG | CHAR | 2 | ||
| FEE_INFO | Charge Bearer | /PF1/DTE_BPE_CHARGE_DETAIL | CHAR | 12 | ||
| TRANS_TYPE | Transaction Type (Advanced Payment Management) | /PF1/DTE_BPE_TRNSTYPE | CHAR | 12 | * | |
| PRIORITY | Payment Item Priority | /PF1/DTE_PO_PI_PRIORITY | CHAR | 4 | ||
| COM_AMOUNT | Refund Compensation | /PF1/DTE_PO_COM_AMOUNT | CURR | 12 | ||
| COM_CURR | Refund Compensation Currency | /PF1/DTE_PO_COM_CURR | CUKY | 10 | * | |
| REF_UND_CON | Contract Reference | /PF1/DTE_PO_REF_UND_CON | CHAR | 100 | ||
| MANDATE_ID | Mandate Identification | /PF1/DTE_PO_MANDATE_ID | CHAR | 70 | ||
| UCI | Creditor ID | /PF1/DTE_UCI | CHAR | 70 | ||
| END_TO_END_ID | Ordering Party Reference (Unique Number for ISO Payment) | /PF1/DTE_PO_PI_REF_ORDPARTY | CHAR | 70 | ||
| DIRECT_DEB_TYPE | Direct Debit Type | /PF1/DTE_SDD_TYPE | CHAR | 2 | ||
| COSTCENTER | Cost Center | KOSTL | CHAR | 20 | * | |
| BUS_AREA | Business Area | GSBER | CHAR | 8 | * | |
| STREET | Street | /PF1/DTE_RD_BANK_STREET | CHAR | 120 | ||
| HOUSE_NUM | House Number | /PF1/DTE_RD_BANK_HOUSE_NUMBER | CHAR | 20 | ||
| CITY | City Heading | /PF1/DTE_RD_CITY | CHAR | 70 | ||
| COUNTRY_ADDRESS | Country/Region Name | /PF1/DTE_RD_COUNTRY | CHAR | 140 | ||
| PAYMENT_NOTE | Payment Note | /PF1/DTE_PR_PAYMENT_NOTE | CHAR | 300 | ||
| PAYMENT_NOTE_LENGTH | Payment Note Length | /PF1/DTE_PR_PAYMENT_NOTE_LENG | DEC | 5 | ||
| A_CURR | Account Currency | /PF1/DTE_PO_ITEM_ACCOUNT_CURR | CUKY | 10 | * | |
| A_AMOUNT | Monetary Amount in Account Currency | /PF1/DTE_PO_ITEM_ACC_AMOUNT | CURR | 12 | ||
| A_FEE | External Charge (Third Party) | /PF1/DTE_PO_ITEM_FEE_ACCT_CURR | CURR | 12 | ||
| EXCHNGRATE | Exchange Rate | /PF1/DTE_PO_ITEM_EXCHANGERATE | DEC | 9 | ||
| .INCLUDE | XML | /PF1/STR_ITEM_TMPL_XML | 0 | |||
| ISO_XML | ISO XML | /PF1/DTE_ISO_XML | RSTR | 8 | ||
| ISO_XML_MSG_TYPE | XML Message Identifier | /PF1/DTE_MESSAGE_TYPE | CHAR | 60 |