/PF1/DB_TCHN - Transaction Chain
Transaction Chain information is stored in SAP table /PF1/DB_TCHN.
It is part of development package /PF1/TRANSACTION_CHAIN in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "Transaction Chain for Cross Border".
It is part of development package /PF1/TRANSACTION_CHAIN in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "Transaction Chain for Cross Border".
Fields for table /PF1/DB_TCHN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| .INCLUDE | BUS_KEY | X | /PF1/STR_TCHN_INST_KEY | 0 | ||
| .INCLUDE | PI_KEY | X | /PF1/STR_PO_PI_KEY_BUSINESS | 0 | ||
| CLEARING_AREA | Clearing Area | X | /PF1/DTE_BPE_CLEARING_AREA | CHAR | 12 | /PF1/T_CLAREA |
| PI_DATE | Payment Item Date | X | /PF1/DTE_PO_PI_KEY_DATE | DATS | 16 | |
| PI_NO | Payment Item Number From Number Range | X | /PF1/DTE_PO_PI_SECONDARY_KEY | NUMC | 24 | |
| TCHN_POSITION | BIC Position in Transaction Chain | X | /PF1/DTE_TCHN_POSITION | INT1 | 1 | |
| BIC | BIC of Financial Institution in Transaction Chain | /PF1/DTE_TCHN_BIC | CHAR | 22 | ||
| TCHN_BIC_INFO | Information about Transaction Chain BIC | /PF1/DTE_TCHN_BIC_INFO | CHAR | 2 | ||
| .INCLUDE | 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 | ||
| SEGMENTATION_KEY | Segmentation Criteria for DB Tables | /PF1/DTE_BPE_SEGMENTATION_KEY | CHAR | 4 | ||
| TIME_PART | Partition field of DB table | /PF1/DTE_BPE_TIME_PART | CHAR | 4 | ||
| COUNTRY | Bank Country/Region | /PF1/DTE_BPE_BANKCOUNTRY | CHAR | 6 | ||
| BANKKEY | Bank Key | /PF1/DTE_BPE_BANKKEY | CHAR | 30 | ||
| NAME | Name | /PF1/DTE_NAME | CHAR | 140 | ||
| .INCLUDE | GRP_ADDITIONAL | /PF1/STR_TCHN_ADDITIONAL | 0 | |||
| .INCLUDE | GRP_BANK_OTHER | /PF1/STR_ISO_OTHER_ID | 0 | |||
| OTHER_ID | ISO Identifier | /PF1/DTE_ISO_ID | CHAR | 70 | ||
| OTHER_ID_CODE | External Financial Institution Identification 1 Code | /PF1/DTE_ISO_ID_CODE4 | CHAR | 8 | ||
| OTHER_ID_PRTRY | Regular or Proprietary ISO Code | /PF1/DTE_ISO_CODE_PROPRIETARY | CHAR | 70 | ||
| OTHER_ID_ISSUER | Issuer | /PF1/DTE_ISO_ISSUER | CHAR | 70 | ||
| .INCLUDE | GRP_BANK_ADDR | /PF1/STR_ISO_ADDRESS | 0 | |||
| ADDRESS_TYPE | Address Type Code | /PF1/DTE_ISO_ADDR_TYPE_CODE | CHAR | 8 | ||
| .INCLUDE | GRP_STRUCTURED | /PF1/STR_ISO_STRUCTUREDADDRESS | 0 | |||
| DEPARTMENT | Address: Department | /PF1/DTE_ISO_DEPARTMENT | CHAR | 140 | ||
| SUB_DEPARTMENT | Address: Sub-Department | /PF1/DTE_ISO_SUB_DEPARTMENT | CHAR | 140 | ||
| STREETNAME | Address: Street Name | /PF1/DTE_ISO_STREETNAME | CHAR | 140 | ||
| BUILDINGNUMBER | Address: Building Number | /PF1/DTE_ISO_BUILDINGNUMBER | CHAR | 32 | ||
| POSTALCODE | Address: Postal Code | /PF1/DTE_ISO_POSTALCODE | CHAR | 32 | ||
| TOWNNAME | Address: Town Name | /PF1/DTE_ISO_TOWNNAME | CHAR | 70 | ||
| COUNTRYSUBDIV | Address: SubDivision | /PF1/DTE_ISO_COUNTRYSUBDIV | CHAR | 70 | ||
| COUNTRY_ADDR | ISO Country Code | /PF1/DTE_BIC_COUNTRYCODE | CHAR | 4 | ||
| .INCLUDE | GRP_UNSTRUCTURED | /PF1/STR_ISO_ADDRESS_UNSTRUC | 0 | |||
| ADDR_LINE1 | Address Line | /PF1/DTE_ISO_ADDR_LINE | CHAR | 140 | ||
| ADDR_LINE2 | Address Line | /PF1/DTE_ISO_ADDR_LINE | CHAR | 140 | ||
| ADDR_LINE3 | Address Line | /PF1/DTE_ISO_ADDR_LINE | CHAR | 140 | ||
| ADDR_LINE4 | Address Line | /PF1/DTE_ISO_ADDR_LINE | CHAR | 140 | ||
| ADDR_LINE5 | Address Line | /PF1/DTE_ISO_ADDR_LINE | CHAR | 140 | ||
| ADDR_LINE6 | Address Line | /PF1/DTE_ISO_ADDR_LINE | CHAR | 140 | ||
| ADDR_LINE7 | Address Line | /PF1/DTE_ISO_ADDR_LINE | CHAR | 140 | ||
| .INCLUDE | GRP_BANK_CLR_SYS | /PF1/STR_ISO_BANK_CLR_IDENT | 0 | |||
| CLR_SYS_CODE | ISO Code Set | /PF1/DTE_BPE_ISO_CODE_SET | CHAR | 10 | ||
| CLR_SYS_PRTRY | Regular or Proprietary ISO Code | /PF1/DTE_ISO_CODE_PROPRIETARY | CHAR | 70 | ||
| CLR_SYS_ID | Clearing System ID | /PF1/DTE_BPE_CLR_SYS_ID | CHAR | 6 | ||
| .INCLUDE | GRP_ACCOUNT | /PF1/STR_ISO_ACCOUNT | 0 | |||
| IBAN | IBAN After Account Substitution | /PF1/DTE_PO_IBAN_AFTER_SUBST | CHAR | 68 | ||
| .INCLUDE | GRP_ACCT_ID | /PF1/STR_ISO_ACCOUNT_ID | 0 | |||
| ACCT_NO | Account Number | /PF1/DTE_PO_ACCT_AFTER_SUBST | CHAR | 68 | ||
| ACCT_CODE | ISO Code Set | /PF1/DTE_BPE_ISO_CODE_SET | CHAR | 10 | ||
| ACCT_PRTRY | Regular or Proprietary ISO Code | /PF1/DTE_ISO_CODE_PROPRIETARY | CHAR | 70 | ||
| ACCT_ISSUER | Issuer | /PF1/DTE_ISO_ISSUER | CHAR | 70 | ||
| .INCLUDE | GRP_ACCT_TYPE | /PF1/STR_ISO_ACCOUNT_TYPE | 0 | |||
| ACCT_TYPE_CD | ISO Code Set | /PF1/DTE_BPE_ISO_CODE_SET | CHAR | 10 | ||
| ACCT_TYPE_PRTRY | Regular or Proprietary ISO Code | /PF1/DTE_ISO_CODE_PROPRIETARY | CHAR | 70 | ||
| ACCT_CUR | Account Currency After Substitution | /PF1/DTE_PO_AC_CUR_AFT_SUBST | CUKY | 10 | * | |
| HOLDER | Substitute Account Holder Name | /PF1/DTE_PO_HOLDERNAME_SUBST | CHAR | 160 | ||
| BANK_TYPE | Branch or Financial Institution Identifier | /PF1/DTE_ISO_BANK_TYPE | CHAR | 2 |