SAP table PLFH (Task list - production resources/tools)

SAP table PLFH has 5 primary key fields being MANDT,PLNTY,PLNNR,PZLFH,ZAEHL.

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
PLNTY Task List Type CHAR 1 0 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PZLFH Item Counter for Production Resources/Tools NUMC 8 0 PZLFH
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
DATUV Valid-From Date DATS 8 0 DATUV
TECHV Technical status from CHAR 12 0 TECHV
LOEKZ Deletion Indicator CHAR 1 0 LKENZ
PARKZ Indicator: inactive changes CHAR 1 0 PARKZ
AENNR Change Number CHAR 12 0 AENR AENNR
DATUI Date Record Created On DATS 8 0 ANDAT
USERI User who created record CHAR 12 0 ANNAM
DATUC Last Changed On DATS 8 0 AEDAT
USERC Name of Person Who Changed Object CHAR 12 0 AENAM
OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
OBJID Object ID of the resource NUMC 8 0 CRID CR_OBJID
OBJCT Object of a task list CHAR 1 0 OBJCT_D
PLNAL Group Counter CHAR 2 0 PLNAL
PLNFL Sequence CHAR 6 0 PLNFOLGE
PLNKN Number of the Task List Node NUMC 8 0 PLNKN
PSNFH Item Number for Production Resource/Tool NUMC 4 0 PSNFH
STEUF Control Profile for Management of Production Resources/Tools CHAR 4 0 TCF10 STEUF
KZKBL Indicator: Create load records for prod. resources/tools CHAR 1 0 KZKBL
BZOFFB Reference Date for Start of Production Resource/Tool Usage CHAR 2 0 TCA54 BZOFFB
OFFSTB Offset to start of production resource/tool usage QUAN 5 0 OFFSTB
EHOFFB Offset Unit for Start of Prodn Resource/Tool Usage UNIT 3 0 T006 EHOFFB
BZOFFE Reference date for end of production resource/tool usage CHAR 2 0 TCA54 BZOFFE
OFFSTE Offset to finish of production resource/tool usage QUAN 5 0 OFFSTE
EHOFFE Offset Unit for End of Production Resource/Tool Usage UNIT 3 0 T006 EHOFFE
MGEINH Unit for Quantity of Production Resources/Tools UNIT 3 0 T006 MGEINH
MGVGW Standard Value for Quantity of Production Resources/Tools QUAN 9 3 MGVGW
MGFORM Formula for Calculating the Total Quantity of PRT CHAR 6 0 TC25 CF_MGFORM
EWEINH Usage Value Unit of the Production Resource/Tool UNIT 3 0 T006 EWEINH
EWVGW Standard Usage Value for Production Resources/Tools QUAN 9 3 EWVGW
EWFORM Formula for Calculating the Total Usage Value of PRT CHAR 6 0 TC25 CF_EWFORM
TXTSP Language Key LANG 1 0 T002 SPRAS
KTSCH Standard Text Key for Production Resources/Tools CHAR 7 0 T435 CF_KTSCH
TXTZ1 First Line of Text for Production Resources/Tools CHAR 40 0 TXTZ1
KNOBJ Number of Object with Assigned Dependencies NUMC 18 0 KNOBJ
GP_KRIT1 Planning object CHAR 18 0 PLOBJ
VALID_TO Valid-to date DATS 8 0 DATUB
LOEKZ_INHERITED Deletion Indicator CHAR 1 0 LKENZ
VERSN Routing Version CHAR 4 0 PLNVERSN
VERSN_SOURCE Source Routing Version CHAR 4 0 PLNVERSN_SOURCE_VERSN
VERSN_SOURCE_PZLFH Task List Version: Item counter Source production res./tools NUMC 8 0 PLNVERSN_SOURCE_PZLFH
VERSN_ORIGIN_ROUTING Origin of an Object in a Reference Template CHAR 1 0 MPE_TEMPLATE_OBJECT_ORIGIN
Template
X Routing
CLAIMABLE Specifies that PRT can be Claimed at Production Execution CHAR 1 0 MPE_PRT_CLAIMABLE
REGISTRABLE Specifies that the PRT can be Registered in Execution CHAR 1 0 MPE_PRT_REGISTRABLE

PLFH foreign key relationships

Table Field Check Table Check Field
0 PLFH AENNR AENR Change Master AENNR
1 PLFH BZOFFB TCA54 Key for reference dates used in offset scheduling BZOFF
0 PLFH BZOFFE TCA54 Key for reference dates used in offset scheduling BZOFF
1 PLFH EHOFFB T006 Units of Measurement MANDT
0 PLFH EHOFFE T006 Units of Measurement MANDT
1 PLFH EWEINH T006 Units of Measurement MANDT
0 PLFH EWFORM TC25 Work center formulas MANDT
1 PLFH KTSCH T435 Standard texts for routing/ref. op set items MANDT
0 PLFH MANDT T000 Clients MANDT
1 PLFH MGEINH T006 Units of Measurement MANDT
0 PLFH MGFORM TC25 Work center formulas MANDT
1 PLFH OBJID CRID CIM Resource - Entities MANDT
1 PLFH OBJID CRID CIM Resource - Entities OBJID
0 PLFH STEUF TCF10 PRT control key MANDT
1 PLFH TXTSP T002 Language Keys (Component BC-I18) SPRAS