SAP table AFRH (Header information for confirmation pool)

SAP table AFRH has 3 primary key fields being MANDT,AFORI,AFRUV.

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
AFORI Origin Indicator of PDC Message (Application) CHAR 1 0 ORIND
1 Data from HR (Human Resources Management)
2 Data from PP (production orders)
3 Data from PM (maintenance work orders)
4 Data from PS (network orders)
5 Data from PP-PK (kanban)
6 Data from PP-PI (process orders)
7 Data originate from QM (QM orders)
8 Data originate from QM (results recording)
S Error records which cannot be reposted
AFRUV Confirmation pool CHAR 20 0 AFRUV
AFRVTXT Description of confirmation pool CHAR 40 0 AFRVTXT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
RMNAM Last Person who Confirmed the Confirmation Pool CHAR 12 0 RMNAM
RMDAT Last Confirmation Date of the Confirmation Pool DATS 8 0 RMDAT
AFRHHER Origin of confirmation pool CHAR 1 0 AFRHHER
1 Pool created from collective confirmation
2 Pool created from PDC/BAPI error records
3 Pool created from information system
4 Pool created from workflow
5 Pool created from resource planning
6 Pool created from foreign selection
C Pool created from individual customer selection