/PF1/DB_ORD_TMPL - Payment Order Template in the Payment Engine
Payment Order Template in the Payment Engine information is stored in SAP table /PF1/DB_ORD_TMPL.
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_ORD_TMPL
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| .INCLUDE | TMPL_KEY | X | /PF1/STR_ORD_TMPL_KEY | 0 | ||
| CLEARING_AREA | Clearing Area | X | /PF1/DTE_BPE_CLEARING_AREA | CHAR | 12 | * |
| TEMPLATE_PO_KEY | Globally Unique Identifier | X | GUID | RAW | 16 | |
| .INCLUDE | GRP_DATA | /PF1/STR_ORD_TMPL_DATA | 0 | |||
| PO_TYPE | Payment Order Type | /PF1/DTE_PO_PO_TYPE | CHAR | 12 | * | |
| PL_PROC_DATE | Execution Date (Planned) | /PF1/DTE_PO_PO_PLANNEDPROCDATE | DATS | 16 | ||
| PL_PROC_TIME | Execution Time (Planned) | /PF1/DTE_PO_PO_PLANNEDPROCTIME | TIMS | 12 | ||
| PRIORITY | Payment Priority | /PF1/DTE_PO_PO_PRIORITY | CHAR | 4 | ||
| .INCLUDE | /PF1/STR_PO_PO_SNDREFINT | 0 | ||||
| SND_INT_COUNTRY | Bank Country/Region (Internal Sender) | /PF1/DTE_PO_BNKCNTRY_INT_SND | CHAR | 6 | T005 | |
| SND_INT_BANKKEY | Bank Key (Internal Sender) | /PF1/DTE_PO_BANKCODE_INT_SND | CHAR | 30 | ||
| SND_INT_BIC | Bank Identifier Code (BIC) of Internal Sender | /PF1/DTE_PO_BIC_INT_SND | CHAR | 22 | ||
| SND_INT_IBAN | IBAN (Internal Sender) | /PF1/DTE_PO_IBAN_INT_SND | CHAR | 68 | ||
| SND_INT_ACC | Account Number (Internal Sender) | /PF1/DTE_PO_PO_SND_ACCNT | CHAR | 68 | ||
| SND_INT_ACC_CUR | Account Currency (Internal Sender) | /PF1/DTE_PO_PO_SND_AC_CUR | CUKY | 10 | * | |
| SND_INT_ACC_HLDR | Sender Name | /PF1/DTE_PO_PO_SND_NAME | CHAR | 160 | ||
| SND_INT_REF | Reference (Internal Sender) | /PF1/DTE_PO_PO_SND_INT_REF | CHAR | 70 | ||
| SND_COMPANY_CODE | Company Code | BUKRS | CHAR | 8 | ||
| SND_BAM_ID | Bank Account Technical ID | FCLM_BAM_ACC_ID | NUMC | 20 | ||
| RCV_COUNTRY | Bank Country/Region Recipient | /PF1/DTE_PO_BNKCNTRY_RCV | CHAR | 6 | T005 | |
| RCV_BANKKEY | Bank Key Recipient | /PF1/DTE_PO_BANKCODE_RCV | CHAR | 30 | ||
| RCV_BIC | Bank Identifier Code (BIC) of Recipient | /PF1/DTE_PO_BIC_RCV | CHAR | 22 | * | |
| RCV_NAME | Recipient Name | /PF1/DTE_PO_PO_RCV_NAME | CHAR | 160 | ||
| REF_EXT_PO | External Payment Order Number | /PF1/DTE_PO_PO_EXTERNAL_REF | CHAR | 70 | ||
| .INCLUDE | /PF1/STR_PO_PO_SEPA | 0 | ||||
| SETT_DATE | (OBSOLETE) Interbank Settlement Date | /PF1/DTE_PO_SETT_DATE | DATS | 16 | ||
| DUE_DATE | Due Date Specified by Ordering Party | /PF1/DTE_PO_DUE_DATE | DATS | 16 | ||
| .INCLUDE | GRP_ADMIN | /PF1/STR_BPE_DBADMIN | 0 | |||
| CRUSR | Creating User | /PF1/DTE_BPE_CRUSR | CHAR | 24 | ||
| CRDAT | Creation Date | /PF1/DTE_BPE_CRDAT | DATS | 16 | ||
| CRTIM | Creation Time | /PF1/DTE_BPE_CRTIM | TIMS | 12 | ||
| CHUSR | Last User Change | /PF1/DTE_BPE_CHUSR | CHAR | 24 | ||
| CHDAT | Change Date | /PF1/DTE_BPE_CHDAT | DATS | 16 | ||
| CHTIM | Changed Time | /PF1/DTE_BPE_CHTIM | TIMS | 12 | ||
| RLUSR | User Who Released Object | /PF1/DTE_BPE_RLUSR | CHAR | 24 | ||
| RLDAT | Release Date | /PF1/DTE_BPE_RLDAT | DATS | 16 | ||
| RLTIM | Release Time | /PF1/DTE_BPE_RLTIM | TIMS | 12 | ||
| SUM_ITEMS | Sum of Amounts | /PF1/DTE_PO_AMNT_SUM_ITEMS | CURR | 12 | ||
| SUM_CURR | Currency of Recipient Items | /PF1/DTE_PO_CURR_SUM_ITEMS | CUKY | 10 | * | |
| TEMPLATE_DESC_SHORT | Description of Order Template (Short) | /PF1/DTE_BPE_ORD_TMPL_TEXT_S | CHAR | 100 | ||
| TEMPLATE_DESC_LONG | Description of Order Template (Long) | /PF1/DTE_BPE_ORD_TMPL_TEXT_L | CHAR | 160 | ||
| IS_PRIVATE | Private Template | /PF1/DTE_BPE_PRIVATE_FLAG | CHAR | 2 | ||
| .INCLUDE | GRP_PMTTPINF | /PF1/STR_ISO_PMT_TP_INFO | 0 | |||
| LCL_INSTRUMENT | ISO20022: Local Instrument Code or Proprietary Code | /PF1/DTE_LOCAL_INSTRUMENT | CHAR | 70 | ||
| CATEGORY_PURPOSE_CODE | ISO20022: Category Purpose Code or Proprietary Code | /PF1/DTE_CATEGORYPURPOSECDPRTY | CHAR | 70 | ||
| SERVICE_LEVEL | ISO20022: Service Level Code or Proprietary Code | /PF1/DTE_SERVICE_LEVEL_CD_PRTY | CHAR | 70 |