SAP table IHC_DB_PN_STATUS (IHC: Payment Order Status)
SAP table IHC_DB_PN_STATUS has 7 primary key fields being MANDT,GUID,STATUS_QUALIF,START_STATUS,TARGET_STATUS,STATUS_COUNTR,DOC_COUNTR.
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 | * | MANDT | |
| GUID | GUID in 'RAW' format | RAW | 16 | 0 | GUID_16 | ||
| STATUS_QUALIF | Type of Status | CHAR | 6 | 0 | IHC_DTE_STATUS_QUALIF | ||
| START_STATUS | Status of a Payment Order | CHAR | 15 | 0 | IHC_DTE_PN_STATUS | ||
| TARGET_STATUS | Status of a Payment Order | CHAR | 15 | 0 | IHC_DTE_PN_STATUS | ||
| STATUS_COUNTR | Status Counter | NUMC | 4 | 0 | IHC_DTE_PN_STAT_CNT | ||
| DOC_COUNTR | Document Index | NUMC | 4 | 0 | IHC_DTE_PN_DOC_CNT | ||
| UNIT | Bank Area | CHAR | 4 | 0 | IHC_DTE_UNIT | ||
| PN_NUMBER | Payment Order Number | NUMC | 10 | 0 | IHC_DTE_PN_NUMBER | ||
| PN_YEAR | Fiscal Year of IHC Payment Order | NUMC | 4 | 0 | IHC_DTE_PN_JAHR | ||
| DOC_QUALIF | Type of Document Created | CHAR | 6 | 0 | IHC_DTE_DOC_QUALIF | ||
| DOC_ID | Identification of Document Created | CHAR | 64 | 0 | IHC_DTE_DOC_ID | ||
| CRUSR | User that created or changed the object | CHAR | 12 | 0 | NIHC_USR | ||
| CRDAT | Date Object Created or Changed | DATS | 8 | 0 | NIHC_DAT | ||
| CRTIM | Time when the object was created or changed | TIMS | 6 | 0 | NIHC_TIM | ||
| BLOCK | Item Is Locked for Automatic Processing | CHAR | 1 | 0 | IHC_DTE_PN_BLOCK | ||
| GUI_STATUS | Status of the Payment Order | CHAR | 2 | 0 | IHC_DTE_GUI_STATUS | ||
| ACTION | IHC: Internal Action in Processes | CHAR | 9 | 0 | IHC_DTE_PROC_ACTION |