/PF1/DB_CA - Database Table for Clearing Agreements
Database Table for Clearing Agreements information is stored in SAP table /PF1/DB_CA.
It is part of development package /PF1/RP_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "Route Processing Persistence Layer".
It is part of development package /PF1/RP_PERSISTENCY_LAYER in software component FIN-FSCM-PF. This development package consists of objects that can be grouped under "Route Processing Persistence Layer".
Fields for table /PF1/DB_CA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | CA_KEY | X | /PF1/STR_BPE_CA_KEY | 0 | ||
| CLEARING_AREA | Clearing Area | X | /PF1/DTE_BPE_CLEARING_AREA | CHAR | 12 | /PF1/T_CLAREA |
| ROUTE_ID | Route ID | X | /PF1/DTE_BPE_ROUTE_ID | CHAR | 22 | /PF1/DB_ROUTE |
| CLEARING_ID | Clearing Agreement ID | X | /PF1/DTE_BPE_CLEARING_ID | CHAR | 22 | |
| RELEASE_STATUS | Release Status | X | /PF1/DTE_BPE_RELEASE_STATUS | CHAR | 4 | |
| .INCLUDE | CA_DATA | /PF1/STR_BPE_CA_DATA | 0 | |||
| .INCLUDE | GRP_CA_GENERAL | /PF1/STR_BPE_CA_DATA_GENERAL | 0 | |||
| CLEARING_STATUS | Clearing Agreement Status | /PF1/DTE_BPE_STATUS_CA | NUMC | 4 | ||
| CLEARING_TYPE | Clearing Agreement Type | /PF1/DTE_BPE_CLEARING_TYPE | CHAR | 4 | ||
| VA_RULESET | Rule Set ID of Value Date Agreement | /PF1/DTE_BPE_VA_RULESET_ID | CHAR | 44 | * | |
| COURSE_TYPE_CRED | Exchange Rate Type for Credit Item | /PF1/DTE_BPE_COURSE_TYPE_CRED | CHAR | 8 | TCURV | |
| COURSE_TYPE_DEB | Exchange Rate Type for Debit Item | /PF1/DTE_BPE_COURSE_TYPE_DEB | CHAR | 8 | TCURV | |
| FLG_GROUPING | Payment Grouping | /PF1/DTE_BPE_FLG_GROUPING | CHAR | 2 | ||
| FLG_COLLECTION | Collection of Items | /PF1/DTE_BPE_FLG_COLLECTION | CHAR | 2 | ||
| FLG_IND_ADVICE | Individual Advice | /PF1/DTE_BPE_FLG_IND_ADVICE | CHAR | 2 | ||
| FLG_CLEARING_TIME | Cut-Off Time - Channel Availability | /PF1/DTE_BPE_FLG_CLEARING_TIME | CHAR | 2 | ||
| CLEARING_START | Begin of Clearing | /PF1/DTE_BPE_STARTTIME | TIMS | 12 | ||
| CLEARING_END | End of Clearing | /PF1/DTE_BPE_ENDTIME | TIMS | 12 | ||
| CLEARING_TZ_SEL | Time Zone Selection for Clearing Time | /PF1/DTE_BPE_CLEARING_TZ_SEL | CHAR | 2 | ||
| CLEARING_TZ | Time Zone of Clearing Time | /PF1/DTE_BPE_CLEARING_TZ | CHAR | 12 | TTZZ | |
| INT_ACCT_SYMBOL | Account Symbol | /PF1/DTE_BPE_ACCOUNT_SYMBOL | CHAR | 20 | /PF1/T_ACCSYMB | |
| FLG_ONLINE | Forward Items Online | /PF1/DTE_BPE_FLG_ONLINE | CHAR | 2 | ||
| FLG_LOCK_OUTPUT | Lock Outgoing Payment Orders for Route/Clearing Agreement | /PF1/DTE_BPE_FLG_LOCK_OUTPUT | CHAR | 2 | ||
| FLG_MAX_AMOUNT | Maximum Amount for Outgoing Payment Orders | /PF1/DTE_BPE_FLG_MAX_AMOUNT | CHAR | 2 | ||
| FLG_ITEM_SPLIT | Split Payment Items When Maximum Amount Exceeded | /PF1/DTE_BPE_FLG_ITEM_SPLIT | CHAR | 2 | ||
| LMR_MGMT_FLAG | Liquidity Management Report | /PF1/DTE_RP_LMR_FLG | CHAR | 2 | ||
| CALENDAR | Calendar for Controlling The Closure of Collectors | /PF1/DTE_BPE_CALENDAR_ID | CHAR | 4 | TFACD | |
| FLG_FWD_REQUEST | Processing Option - Message Forwarding vs. Clearing | /PF1/DTE_BPE_FLG_FWD_REQUEST | CHAR | 2 | ||
| RCV_DETERMINATION | Receiving Bank Account Determination | /PF1/DTE_RCV_DETERMINATION | CHAR | 6 | ||
| FLG_POST_TIME | Planned Execution Time | /PF1/DTE_RP_FLG_POST_TIME | CHAR | 2 | ||
| POST_TIME_UNIT | Time Unit for Posting Date/Time determination | /PF1/DTE_RP_POST_TIME_UNIT | CHAR | 2 | ||
| POST_TIME_BASE | Base Time for Posting Date/Time Determination | /PF1/DTE_RP_POST_TIME_BASE | CHAR | 2 | ||
| POST_TIME_VALUE | Value for Posting Date/Time Determination | /PF1/DTE_RP_POST_TIME_VALUE | DEC | 5 | ||
| POST_TIME_UPDOWN | Markup/Markdown for Posting Date/Time Determination | /PF1/DTE_RP_POST_TIME_UPDOWN | CHAR | 2 | ||
| .INCLUDE | GRP_CA_INT | /PF1/STR_BPE_CA_DATA_INTERNAL | 0 | |||
| .INCLUDE | /PF1/STR_BPE_CA_DATA_INT_AVIS | 0 | ||||
| AVIS_CONVERTER | Converter ID | /PF1/DTE_BPE_CONVERTER_ID | CHAR | 12 | * | |
| AVIS_FORMAT | Format | /PF1/DTE_BPE_FORMAT | CHAR | 20 | /PF1/T_FORMAT | |
| AVIS_CHANNEL | Channel | /PF1/DTE_BPE_CHANNEL | CHAR | 20 | /PF1/T_CHANNEL | |
| AVIS_MEDIUM | Medium | /PF1/DTE_BPE_MEDIUM | CHAR | 8 | /PF1/T_MEDIUM | |
| AVIS_BULK_TYPE | Character Field with Length 10 | CHAR10 | CHAR | 20 | * | |
| AVIS_PRIORITY | Payment Priority | /PF1/DTE_PO_PO_PRIORITY | CHAR | 4 | ||
| AVIS_POTYPE | Payment Order Type | /PF1/DTE_PO_PO_TYPE | CHAR | 12 | /PF1/T_POTYPE | |
| INT_TTYP_CLR_C | Credit Transaction Type for CLRs | /PF1/DTE_PO_CLR_TTYP_CRD | CHAR | 12 | /PF1/T_TRANSTYPE | |
| INT_TTYP_CLR_D | Debit Transaction Type for CLRs | /PF1/DTE_PO_CLR_TTYP_DEB | CHAR | 12 | /PF1/T_TRANSTYPE | |
| FLG_RESERV | Prenote Required | /PF1/DTE_BPE_FLG_PRENOTE | CHAR | 2 | ||
| FLG_SPLIT_POSTDATE | Value Date Split | /PF1/DTE_BPE_VAL_SPLIT | CHAR | 2 | ||
| .INCLUDE | GRP_CA_EXT | /PF1/STR_BPE_CA_DATA_EXTERNAL | 0 | |||
| CL_INSTITUT | Clearing Institute | /PF1/DTE_BPE_CL_INSTITUT | CHAR | 20 | * | |
| BAM_ID | Bank Account Technical ID | FCLM_BAM_ACC_ID | NUMC | 20 | FCLM_BAM_AMD | |
| .INCLUDE | GRP_ROUTE_ACCOUNT | /PF1/STR_BPE_CA_ROUTE_ACC | 0 | |||
| ROUTE_ACCT_NO | Account Number for Account at Route | /PF1/DTE_BPE_ROUTE_ACCT_NO | CHAR | 68 | ||
| ROUTE_ACCT_CUR | Account Currency for Route Account | /PF1/DTE_BPE_ROUTE_AC_CUR | CUKY | 10 | * | |
| ROUTE_COUNTRY | Bank Country/Region for Account at Route | /PF1/DTE_BPE_ROUTE_COUNTRY | CHAR | 6 | * | |
| ROUTE_BANKKEY | Bank Key for Account at Route | /PF1/DTE_BPE_ROUTE_BANKKEY | CHAR | 30 | ||
| ROUTE_IBAN | IBAN for Account at Route | /PF1/DTE_BPE_ROUTE_IBAN | CHAR | 68 | ||
| ROUTE_BIC | Bank Identifier Code (BIC) | /PF1/DTE_BPE_ROUTE_BIC | CHAR | 22 | * | |
| ROUTE_HOLDERNAME | Account Holder for Account at Route | /PF1/DTE_BPE_ROUTE_HOLDERNAME | CHAR | 160 | ||
| .INCLUDE | GRP_OPO | /PF1/STR_BPE_CA_OUT_ORDER | 0 | |||
| OUT_CONVERTER | Converter ID | /PF1/DTE_BPE_CONVERTER_ID | CHAR | 12 | * | |
| OUT_FORMAT | Format | /PF1/DTE_BPE_FORMAT | CHAR | 20 | /PF1/T_FORMAT | |
| OUT_CHANNEL | Channel | /PF1/DTE_BPE_CHANNEL | CHAR | 20 | /PF1/T_CHANNEL | |
| OUT_MEDIUM | Medium | /PF1/DTE_BPE_MEDIUM | CHAR | 8 | /PF1/T_MEDIUM | |
| OUT_BULK_TYPE | Character Field with Length 10 | CHAR10 | CHAR | 20 | * | |
| OUT_PRIORITY | Payment Priority | /PF1/DTE_PO_PO_PRIORITY | CHAR | 4 | ||
| OUT_POTYPE | Payment Order Type | /PF1/DTE_PO_PO_TYPE | CHAR | 12 | /PF1/T_POTYPE | |
| OUT_SND_ACCTSYMB | Sender Identification | /PF1/DTE_BPE_SNDACCOUNT_SYMBOL | CHAR | 20 | /PF1/T_SNDACCSYM | |
| OUT_DECOUPLING | Apply Decoupling in Emergency Cases | /PF1/DTE_BPE_DECOUPLE | 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 | ||
| FLG_BANK_CONFIRMATION | Bank Confirmation Indicator | /PF1/DTE_FH_CONFIRMATION_REQ | CHAR | 2 | ||
| TTYPE_CLR_ITEM_C | Transaction Type Clearing Credit | /PF1/DTE_BPE_TTYPE_CLR_CRED | CHAR | 12 | /PF1/T_TRANSTYPE | |
| TTYPE_CLR_ITEM_D | Debit Transaction Type for Clearing Item | /PF1/DTE_BPE_TTYPE_CLR_DEB | CHAR | 12 | /PF1/T_TRANSTYPE | |
| PRIO_CLR_ITEM | Payment Priority | /PF1/DTE_PO_PO_PRIORITY | CHAR | 4 | ||
| FLG_PLANNED_TIME | Planned Execution Time (Internal) | /PF1/DTE_RP_FLG_PLANNED_TIME | CHAR | 2 | ||
| PL_TIME_UNIT | Time Unit for Planned Execution Time and Closing Date | /PF1/DTE_RP_PL_TIME_TIME_UNIT | CHAR | 2 | ||
| PL_TIME_BASE | Base Time for Planned Execution Time and Closing Date | /PF1/DTE_RP_PL_TIME_BASE_VALUE | CHAR | 2 | ||
| PL_TIME_INDEC | Markup/Markdown for Execution Time and Closing Date | /PF1/DTE_RP_PL_DATE_INDECREASE | DEC | 5 | ||
| PL_TIME_FLG_ID | Sign: Markup/Markdown | /PF1/DTE_RP_PL_TIME_FLG_INDEC | CHAR | 2 | ||
| CUTOFF_TIME_FLG | Bank Cut-Off Time | /PF1/DTE_RP_CUTOFF_TIME_FLG | CHAR | 2 | ||
| CUTOFF_TIME_BASE | Base Time for Cut-Off Time | /PF1/DTE_RP_CUTOFF_TIME_BASE | CHAR | 2 | ||
| CUTOFF_TIME_SIGN | Markup/Markdown Sign for Cut-Off Time | /PF1/DTE_RP_CUTOFF_TIME_SIGN | CHAR | 2 | ||
| CUTOFF_TIME_OFFSET | Markup/Markdown Offset for Cut-Off Time | /PF1/DTE_RP_CUTOFF_TIME_OFFSET | DEC | 5 | ||
| CUTOFF_TIME_UNIT | Markup/Markdown Time Unit for Cut-Off Time | /PF1/DTE_RP_CUTOFF_TIME_UNIT | CHAR | 2 | ||
| CUTOFF_TIME_OF_DAY | Cut-Off Time of Day | /PF1/DTE_RP_CUTOFF_TIME_OF_DAY | TIMS | 12 | ||
| BUKRS | Company Code | BUKRS | CHAR | 8 | ||
| TREEID | DMEE: unique description for a DMEE format tree | DMEE_TREEID | CHAR | 60 | ||
| TREETYPE | DMEE: tree type | DMEE_TREETYPE | CHAR | 8 | * | |
| FLG_BTCHBOOKG | Batch Booking Indicator (Single Posting) | /PF1/DTE_RP_FLG_BBOOK | CHAR | 2 | ||
| .INCLUDE | GRP_ROUTING_CHECKS | /PF1/STR_BPE_CA_DATA_EXT_ROUTE | 0 | |||
| BALANCE_CHECK | Route Processing - Balance Check for Clearing Account | /PF1/DTE_RP_CA_BALANCE_CHECK | CHAR | 2 | ||
| AVOID_DUE_DATE_SHIFT | Skip Due Date Shift | /PF1/DTE_RP_DUE_DATE_SHIFT | CHAR | 2 | ||
| CUTOFF_TIME_TZ_SEL | Time Zone Selection for Clearing Time | /PF1/DTE_BPE_CLEARING_TZ_SEL | CHAR | 2 | ||
| CUTOFF_TIME_TZ | Time Zone of Clearing Time | /PF1/DTE_BPE_CLEARING_TZ | CHAR | 12 | TTZZ | |
| .INCLUDE | GRP_CA_ALTERNATIVE | /PF1/STR_BPE_CA_DATA_ALT | 0 | |||
| ALT_ROUTE | Alternate Route | /PF1/DTE_RP_ALT_ROUTE | CHAR | 22 | ||
| ALT_CA | Alternate Clearing Agreement | /PF1/DTE_RP_ALT_CA | CHAR | 22 | ||
| REACT_CA_LOCK | Response to Locked Clearing Agreement | /PF1/DTE_RP_REACT_CA_LOCK | CHAR | 4 | ||
| REACT_MIN_RQ_NOT | Response if Minimum Requirements for Closing not Met | /PF1/DTE_RP_REACT_REQ_MIN_NOT | CHAR | 4 | ||
| ALREADY_ALT | Already used as an Alternate Clearing Agreement. | /PF1/DTE_RP_ALREADY_ALTERNATE | CHAR | 2 | ||
| NODE_ID | Globally Unique Identifier | GUID | RAW | 16 | ||
| .INCLUDE | /PF1/STR_BPE_RELEASE_CD | 0 | ||||
| RELEASE_STATUSCD | Release Status | /PF1/DTE_BPE_RELEASE_STATUS | CHAR | 4 | ||
| .INCLUDE | DBADMIN | /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 | ||
| .INCLUDE | ARCH | AFX_STATUS_DATA_EXT | 0 | |||
| ARCHIVE_STATUS | Archiving Status | TYP_ARCHIVE_STATUS | CHAR | 2 | ||
| ARCHIVE_FLUD | Resubmission Date | TYP_ARCHIVE_FLUD | DATS | 16 | ||
| REJECTION | Rejection Reason | TYP_REJECTION | CHAR | 4 |