/PF1/DB_ROUTE - Database Table for Route
Database Table for Route information is stored in SAP table /PF1/DB_ROUTE.
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_ROUTE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | ROUTE_KEY | X | /PF1/STR_BPE_ROUTE_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 | |
| RELEASE_STATUS | Release Status | X | /PF1/DTE_BPE_RELEASE_STATUS | CHAR | 4 | |
| .INCLUDE | ROUTE_DATA | /PF1/STR_BPE_ROUTE_DATA | 0 | |||
| CL_INSTITUT | Clearing Institute | /PF1/DTE_BPE_CL_INSTITUT | CHAR | 20 | * | |
| ROUTE_STATUS | Route Status | /PF1/DTE_BPE_STATUS_ROUTE | NUMC | 4 | ||
| ROUTE_COUNTRY | Bank Country/Region for Account at Route | /PF1/DTE_BPE_ROUTE_COUNTRY | CHAR | 6 | T005 | |
| ROUTE_BANKKEY | Bank Key for Account at Route | /PF1/DTE_BPE_ROUTE_BANKKEY | CHAR | 30 | ||
| ROUTE_BIC | Bank Identifier Code (BIC) | /PF1/DTE_BPE_ROUTE_BIC | CHAR | 22 | * | |
| 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_IBAN | IBAN for Account at Route | /PF1/DTE_BPE_ROUTE_IBAN | CHAR | 68 | ||
| ROUTE_HOLDERNAME | Account Holder for Account at Route | /PF1/DTE_BPE_ROUTE_HOLDERNAME | CHAR | 160 | ||
| FLG_INTERNAL | Internal Route | /PF1/DTE_BPE_FLG_INTERNAL | CHAR | 2 | ||
| CALENDAR | Calendar for Value Calculation | /PF1/DTE_BPE_CALENDAR | CHAR | 4 | TFACD | |
| VA_RULESET | Rule Set ID of Value Date Agreement | /PF1/DTE_BPE_VA_RULESET_ID | CHAR | 44 | * | |
| AM_AREA | Account Managing Area | /PF1/DTE_BPE_AM_AREA | CHAR | 12 | /PF1/T_AM_AREA | |
| NODE_ID | Globally Unique Identifier | GUID | RAW | 16 | ||
| FLG_LOCK_OUTPUT | Lock Outgoing Payment Orders for Route/Clearing Agreement | /PF1/DTE_BPE_FLG_LOCK_OUTPUT | CHAR | 2 | ||
| DEFAULT_CURRENCY | Account Currency for Route Account | /PF1/DTE_BPE_ROUTE_AC_CUR | CUKY | 10 | TCURC | |
| .INCLUDE | CLR_TIME | /PF1/STR_RP_CLEARING_TIME | 0 | |||
| 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 | |
| FX_APP | Foreign Exchange Application | /PF1/DTE_FX_APPLICATION | CHAR | 20 | /PF1/T_LM_AREA | |
| BAM_ID | Bank Account Technical ID | FCLM_BAM_ACC_ID | NUMC | 20 | FCLM_BAM_AMD | |
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| .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 |