SAP table TBNK_XST_2_IST (Mapp external status to internal status)
SAP table TBNK_XST_2_IST has 4 primary key fields being MANDT,COMPANY_CODE,HOUSE_BANK_ID,EXT_STAT.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| COMPANY_CODE | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| HOUSE_BANK_ID | Short Key for a House Bank | CHAR | 5 | 0 | T012 | HBKID | |
| EXT_STAT | Status Code | CHAR | 35 | 0 | BNK_COM_STSCD | ||
| INT_BUS_TRAN | Payment business transaction | CHAR | 4 | 0 | TJ01 | BNK_COM_INTBUSTRAN | |
| ALRT_CAT | Alert Category | CHAR | 30 | 0 | SALRTCAT | SALRTDCAT | |
| ACT_INC_FLAG | Activate Processing of Incomplete CPON Files (Flag) | CHAR | 1 | 0 | BNK_COM_ACT_INC_FLAG | ||
| INC_EXT_STAT_DEF | Default Value of External Status Code for Incomplete Files | CHAR | 35 | 0 | BNK_COM_INC_EXT_STAT_DEF |
TBNK_XST_2_IST foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TBNK_XST_2_IST | ALRT_CAT | SALRTCAT | Alert Category: Definition Table | MANDT |
| 0 TBNK_XST_2_IST | ALRT_CAT | SALRTCAT | Alert Category: Definition Table | CATEGORY |
| 1 TBNK_XST_2_IST | COMPANY_CODE | T001 | Company Codes | BUKRS |
| 0 TBNK_XST_2_IST | HOUSE_BANK_ID | T012 | House Banks | BUKRS |
| 1 TBNK_XST_2_IST | INT_BUS_TRAN | TJ01 | Business Transactions | VRGNG |