SAP PHINT Phase In Table Table data and field list

PHINT is a standard SAP Table which is used to store Phase In Table data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The PHINT table consists of various fields, each holding specific information or linking keys about Phase In Table data available in SAP. These include PHIN_GUID (Generic Key for Takeover/Handover), TL_KEY (Key (Numc 8) for Table PHINT), KTX01 (Description of technical object), QUANT (Quantity)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

PHINT table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PHINT table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the PHINT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
PHIN_GUIDGeneric Key for Takeover/Handover PHIN_D_PHINGUIDCHAR32SDOK_DOCID
TL_KEYKey (Numc 8) for Table PHINT PHIN_D_GUIDNUMC8PHIN_DOM_GUID
KTX01Description of technical object KTX01CHAR40TEXT40
QUANTQuantity PHIN_D_QTYQUAN13(3) MENGV13
QUNITUnit of Measure PHIN_D_QUNITUNIT3Assigned to domainCUNITMEINS
IDATEInstallation Date (UTC Timestamp) PHIN_D_ID_TSTAMPDEC15TZNTSTMPS
BAUJJYear of construction BAUJJCHAR4GJAHRCJAHR
BAUMMMonth of Construction PHIN_D_BAUMMCHAR2PHIN_DOM_BAUMM
PHIN_LOCAdditional Information (Example: ATA) PHIN_D_LOCCHAR30PHIN_DOM_LOC
DOCNUMIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
EXTEQUIExternal Equipment Number PHIN_D_EXTEQUICHAR30CHAR30
H_EXTEQUISuperior External Equipment Number PHIN_D_HEXTEQUICHAR30CHAR30
TO_TYPType Takeover / Handover Object PHIN_D_TYPECHAR1PHIN_DOM_TOTYPE
DD_TSTAMPDismantle Date (UTC Timestamp) PHIN_D_DD_TSTAMPDEC15TZNTSTMPS
FUNCIDFID (Function Identifier) PHIN_D_FUNCIDCHAR40CHAR40
VALID_ONValid Date PHIN_D_VALID_DATEDATS8DATUM
EQUNREquipment Number EQUNRCHAR18Assigned to domainALPHAEQUNREQNEQUI
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
SERNRSerial Number GERNRCHAR18GERNRGERNRSER
REF_EQUNR'Copy Reference' for Equipment PHIN_D_REFECHAR18Assigned to domainALPHAEQUNREQUI
HEQUISuperordinate Equipment HEQUICHAR18Assigned to domainALPHAEQUNR
TPLNRFunctional Location PHIN_D_TPLNR40CHAR40ILOM_STRNOIFL
TPLMASuperior Functional location PHIN_D_TPLMA40CHAR40ILOM_STRNO
H_TL_KEYTable Line Key of Superior Object PHIN_D_HGUIDNUMC8PHIN_DOM_GUID
TMPL_FL'Copy Reference' for Functional Location PHIN_D_TMPLFL40CHAR40ILOM_STRNO
NEW_H_TL_KEYTable Line Key of Superior Object PHIN_D_HGUIDNUMC8PHIN_DOM_GUID
NH_MATNRSuperior Mat. Number PHIN_D_NH_MATNRCHAR18Assigned to domainMATN1MATNR
NH_SERNRSuperior Serial Number PHIN_D_NH_SERNRCHAR18GERNRGERNR
PARTNER_MATNRMaterial number used by the business partner PHIN_D_PARTNER_MATNRCHAR40CHAR40
RECENT_MATNRMaterial Number Used During Last Takeover PHIN_D_RECENT_MATNRCHAR40CHAR40
UII Unique Item Identifier PHIN_D_UIICHAR72UII_CHAR72UIIH_UII
MD_TSN_TSTAMPTime Since New: Measurement Date (UTC Timestamp) PHIN_D_MD_TSN_TZNTSTMPSDEC15TZNTSTMPS
MD_TSNTime Since New PHIN_D_MD_TSNCHAR22FLTP_INOUT
MD_CSN_TSTAMPCycles Since New: Measurement Date (UTC Timestamp) PHIN_D_MD_CSN_TZNTSTMPSDEC15TZNTSTMPS
MD_CSNCycles Since New PHIN_D_MD_CSNCHAR22FLTP_INOUT
MD_DISN_TSTAMPDays Installed Since New: Measurement Date (UTC Timestamp) PHIN_D_MD_DISN_TZNTSTMPSDEC15TZNTSTMPS
MD_DISNDays Installed Since New PHIN_D_MD_DISNCHAR22FLTP_INOUT
MD_TSO_TSTAMPTime Since Overhaul: Measurement Date (UTC Timestamp) PHIN_D_MD_TSO_TZNTSTMPSDEC15TZNTSTMPS
MD_TSOTime Since Overhaul PHIN_D_MD_TSOCHAR22FLTP_INOUT
MD_CSO_TSTAMPCycles Since Overhaul: Measurement Date (UTC Timestamp) PHIN_D_MD_CSO_TZNTSTMPSDEC15TZNTSTMPS
MD_CSOCycles Since Overhaul PHIN_D_MD_CSOCHAR22FLTP_INOUT
MD_DISO_TSTAMPDays Installed Since Overhaul: MeasuremDate (UTC Timestamp) PHIN_D_MD_DISO_TZNTSTMPSDEC15TZNTSTMPS
MD_DISODays Installed Since Overhaul PHIN_D_MD_DISOCHAR22FLTP_INOUT
MD_TSR_TSTAMPTime Since Repair: Measurement Date (UTC Timestamp) PHIN_D_MD_TSR_TZNTSTMPSDEC15TZNTSTMPS
MD_TSRTime Since Repair PHIN_D_MD_TSRCHAR22FLTP_INOUT
MD_CSR_TSTAMPCycles Since Repair: Measurement Date (UTC Timestamp) PHIN_D_MD_CSR_TZNTSTMPSDEC15TZNTSTMPS
MD_CSRCycles Since Repair PHIN_D_MD_CSRCHAR22FLTP_INOUT
MD_DISR_TSTAMPDays Installed Since Repair: MeasuremDate (UTC Timestamp) PHIN_D_MD_DISR_TZNTSTMPSDEC15TZNTSTMPS
MD_DISRDays Installed Since Repair PHIN_D_MD_DISRCHAR22FLTP_INOUT
IND_DELDeletion Indicator PHIN_D_DELCHAR1PHIN_DOM_DEL
SOURCETakeover / Handover: Source Indicator PHIN_D_SOURCECHAR1PHIN_DOM_SOURCE
EQCATTechnical Object Category PHIN_D_EQTYPCHAR1PHIN_DOM_EQTYP
FLOCDELINDDeletion Indicator PHIN_D_DELCHAR1PHIN_DOM_DEL
OBJ_LEVELLevel in Object Structure PHIN_D_LEVELINT13
TPLKZFunctional location structure indicator TPLKZCHAR5Assigned to domainTPLKZISR
STAT_CONSTakeover State Consistency PHIN_D_STATE_CONSCHAR1CHAR1
STAT_EXISTTakeover State Existence PHIN_D_STATE_EXISTCHAR1CHAR1
STAT_CREATEDTakeover State Object Created PHIN_D_STATE_CREATECHAR1CHAR1
STAT_UPDATEDTakeover State Updated PHIN_D_STATE_UPDATECHAR1CHAR1
STAT_FLOCTakeover / Handover State Functional Location Assignment PHIN_D_STATE_FLOCCHAR1CHAR1

Key field Non-key field



How do I retrieve data from SAP table PHINT using ABAP code

The following ABAP code Example will allow you to do a basic selection on PHINT to SELECT all data from the table
DATA: WA_PHINT TYPE PHINT.

SELECT SINGLE *
FROM PHINT
INTO CORRESPONDING FIELDS OF WA_PHINT
WHERE...

How to access SAP table PHINT

Within an ECC or HANA version of SAP you can also view further information about PHINT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).