SAP AFFH01 Order PRT Data (for LDB) - 01 Table data and field list

AFFH01 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Order PRT Data (for LDB) - 01" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_AFFH01 TYPE AFFH01.

The AFFH01 table consists of various fields, each holding specific information or linking keys about Order PRT Data (for LDB) - 01 data available in SAP. These include MANDT (Client), AUFPL (Routing number of operations in the order), PZLFH (Item counter for production resources/tools), LOEKZ (Deletion Indicator)... 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. .

AFFH01 structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP AFFH01 structure 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 AFFH01 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
AUFPL	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
PZLFH	Item counter for production resources/tools	PZLFH	NUMC	8			PZLFH
LOEKZ	Deletion Indicator	LKENZ	CHAR	1			XFELD
PARKZ	Indicator: inactive changes	PARKZ	CHAR	1			XFELD
DATUI	Date record created on	ANDAT	DATS	8			DATUM
USERI	User who created record	ANNAM	CHAR	12			USNAM
DATUC	Changed On	AEDAT	DATS	8			DATUM
USERC	Name of Person Who Changed Object	AENAM	CHAR	12			USNAM
OBJTY	Object types of the CIM resource	CR_OBJTY	CHAR	2			CR_OBJTY
OBJID	Object ID of the resource	CR_OBJID	NUMC	8	CRID		CR_OBJID
PLNTY_KEY	Task List Type	PLNTY	CHAR	1	TCA01		PLNTY	PTY	H_TCA01
PLNNR_KEY	Key for Task List Group	PLNNR	CHAR	8		ALPHA	PLNNR	PLN	PLKS
PZLFH_KEY	Item counter for production resources/tools	PZLFH	NUMC	8			PZLFH
ZAEHL_KEY	Internal counter	CIM_COUNT	NUMC	8			CIM_COUNT
OBJCT	Object of a task list	OBJCT_D	CHAR	1			OBJKT
APLZL	Internal counter	CIM_COUNT	NUMC	8			CIM_COUNT
PSNFH	Item Number for Production Resource/Tool	PSNFH	NUMC	4			PSNFH
OBJNR	Object number	J_OBJNR	CHAR	22	ONR00		J_OBJNR	ONR
STEUF	Control key for management of production resources/tools	STEUF	CHAR	4	TCF10		STEUF
KZKBL	Indicator: Create load records for prod. resources/tools	KZKBL	CHAR	1			XFELD
BZOFFB	Reference date to start of production resource/tool usage	BZOFFB	CHAR	2	TCA54		CP_BZOFF
OFFSTB	Offset to start of production resource/tool usage	OFFSTB	QUAN	5			VNZTV
EHOFFB	Offset unit for start of prod. resource/tool usage	EHOFFB	UNIT	3	T006	CUNIT	MEINS
BZOFFE	Reference date for end of production resource/tool usage	BZOFFE	CHAR	2	TCA54		CP_BZOFF
OFFSTE	Offset to finish of production resource/tool usage	OFFSTE	QUAN	5			VNZTV
EHOFFE	Offset unit for end of production resource/tool usage	EHOFFE	UNIT	3	T006	CUNIT	MEINS
FSFHD	Earliest scheduled start (date) for PRT usage	CF_FSFHD	DATS	8			DATUM
FSFHZ	Earliest scheduled start (time) for PRT usage	CF_FSFHZ	TIMS	6			UZEIT
FEFHD	Earliest scheduled finish (date) of PRT usage	CF_FEFHD	DATS	8			DATUM
FEFHZ	Earliest scheduled end (time) of PRT usage	CF_FEFHZ	TIMS	6			UZEIT
SSFHD	Latest scheduled start (date) for PRT usage	CF_SSFHD	DATS	8			DATUM
SSFHZ	Latest scheduled start (time) for PRT usage	CF_SSFHZ	TIMS	6			UZEIT
SEFHD	Latest scheduled finish (date) of PRT usage	CF_SEFHD	DATS	8			DATUM
SEFHZ	Latest scheduled end (time) for PRT usage	CF_SEFHZ	TIMS	6			UZEIT
ISFHD	Actual start (date) of PRT usage	CF_ISFHD	DATS	8			DATUM
ISFHZ	Actual start (time) of PRT usage	CF_ISFHZ	TIMS	6			UZEIT
IEFHD	Actual finish (date) of PRT usage	CF_IEFHD	DATS	8			DATUM
IEFHZ	Actual finish (time) of PRT usage	CF_IEFHZ	TIMS	6			UZEIT
DAUFL	Duration of PRT usage	CF_DAUFL	FLTP	16(16)			CX_ZEIT
DAUEH	Time unit for duration of PRT usage	CF_DAUEH	UNIT	3	T006	CUNIT	MEINS
MGEINH	Quantity unit of production resource/tool	MGEINH	UNIT	3	T006	CUNIT	MEINS
MGVGW	Standard value for the PRT quantity	MGVGW	QUAN	9(3)			MENG9
MGSOLEH	Quantity unit of production resource/tool	MGEINH	UNIT	3	T006	CUNIT	MEINS
MGSOL	Total planned quantity of production resource/tool	MGSOL	QUAN	9(3)			MENG9
MGISTEH	Quantity unit of production resource/tool	MGEINH	UNIT	3	T006	CUNIT	MEINS
MGIST	Confirmed quantity of production resource/tool	MGIST	QUAN	9(3)			MENG9
MGRSTEH	Quantity unit of production resource/tool	MGEINH	UNIT	3	T006	CUNIT	MEINS
MGRST	Remaining quantity of the production resource/tool	MGRST	QUAN	9(3)			MENG9
MGAUSEH	Quantity unit of production resource/tool	MGEINH	UNIT	3	T006	CUNIT	MEINS
MGAUS	Quantity of checked-out production resources/tools	MGAUS	QUAN	9(3)			MENG9
MGFORM	Formula for calculating the total quantity of PRT	CF_MGFORM	CHAR	6	TC25		AP_FORMEL
EWEINH	Usage value unit of the production resource/tool	EWEINH	UNIT	3	T006	CUNIT	MEINS
EWVGW	Standard usage value for production resources/tools	EWVGW	QUAN	9(3)			MENG9
EWSOLEH	Usage value unit of the production resource/tool	EWEINH	UNIT	3	T006	CUNIT	MEINS
EWSOL	Total planned usage value of production resource/tool	EWSOL	QUAN	9(3)			MENG9
EWISTEH	Usage value unit of the production resource/tool	EWEINH	UNIT	3	T006	CUNIT	MEINS
EWIST	Actual usage value for production resource/tool	EWIST	QUAN	9(3)			MENG9
EWRSTEH	Usage value unit of the production resource/tool	EWEINH	UNIT	3	T006	CUNIT	MEINS
EWRST	Remaining usage value of the production resource/tool	EWRST	QUAN	9(3)			MENG9
EWFORM	Formula for calculating the total usage value of PRT	CF_EWFORM	CHAR	6	TC25		AP_FORMEL
TXTSP	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
KTSCH	Standard text key for production resources/tools	CF_KTSCH	CHAR	7	T435		KTSCH
TXTZ1	First line of text for production resources/tools	TXTZ1	CHAR	40			TEXT40
OBJTYPE	Change indicator	OCM_OBJ_TYPE	CHAR	1			OCM_OBJ_TYPE
CH_PROC	Process that has lead to the change of an object	OCM_CH_PROC	CHAR	1			OCM_CH_PROC
AENNR	Change Number	AENNR	CHAR	12	Assigned to domain	AENNR	AENNR	AEN
DAUSE	Duration of the PRT usage	CF_DAUSE	QUAN	5(1)			DAUER_4_1
AUFNR	Order Number	AUFNR	CHAR	12	AUFK	ALPHA	AUFNR	ANR
FHMAR	Production resources/tools category	FHMAR	CHAR	1	TCF02	FHMAR	FHMAR	FHA
FHMNR	Production resource/tool number	FHMNR	CHAR	33			FHMNR
FHWRK	Production resources/tools in plant	FHWRK	CHAR	4	T001W		WERKS	WRK
MATNR	Material Number	MATNR	CHAR	18	MARA	MATN1	MATNR	MAT	S_MAT1
SFHNR	Production resources and tools	SFHNR	CHAR	18		ALPHA	SFHNR	FHS	FHMS
DOKAR	Document Type	DOKAR	CHAR	3	TDWA		DOKAR	CV2
DOKNR	Document number	DOKNR	CHAR	25	DRAW	ALPHA	DOKNR	CV1
DOKVR	Document Version	DOKVR	CHAR	2			DOKVR	CV3
DOKTL	Document Part	DOKTL_D	CHAR	3			DOKTL	CV4
EQUNR	Equipment Number	EQUNR	CHAR	18	EQUI	ALPHA	EQUNR	EQN	EQUI
EQWPL	Maintenance Plan	WARPL	CHAR	12	MPLA	ALPHA	WARPL	MPL	MPLAL
EQWTX	Maintenance Plan Text	WPTXT	CHAR	40			TEXT40
EQPNT	Measuring Point	IMRC_POINT	CHAR	12	IMPTT	ALPHA	IMRC_POINT	IPT	IMPM
EQPTX	Description of Measuring Point	IMRC_PTTXT	CHAR	40			TEXT40
ATNAM	Characteristic Name	ATNAM	CHAR	30			ATNAM	FEA
ATVOR	Indicator: Negative Values Allowed	IMRC_INEGV	CHAR	1			X
MSEHI	Unit of Measurement	MSEHI	UNIT	3	T006	CUNIT	MEINS
ATDIM	Exponent display	ATDIM	INT2	5			EXP10
ANZDZ	Number of Decimal Places	ANZDZ	INT2	5			ANZDZ
FHKTX	Description of the production resource/tool	FHKTX	CHAR	40			TEXT40
BASEH	Base unit of measure for production resources/tools	CF_BASEH	UNIT	3	T006	CUNIT	MEINS
MEINS	Base Unit of Measure	MEINS	UNIT	3	T006	CUNIT	MEINS
FGRU1	Grouping key 1 for production resources/tools	FGRUA	CHAR	4	TCF12		FGRUA
FGRU2	Grouping key 2 for production resources/tools	FGRUB	CHAR	4	TCF12		FGRUA
STOWK	Plant location of the production resource/tool	CF_STOWK	CHAR	4	T001W		WERKS	WRK
STORT	Location of a production resource or tool	CF_STORT	CHAR	10	T499S		AP_STAND
FSTTXT	System Status	CO_STTXT	CHAR	40			CHAR40
CF_KZSVS	Indicator for start of PRT usage: Offset to Operation start	CF_KZSVS	CHAR	1			XFELD
CF_KZSVE	Indicator for start of PRT usage: Offset to op. finish	CF_KZSVE	CHAR	1			XFELD
CF_KZEVS	Indicator for end of PRT usage: Offset to operation start	CF_KZEVS	CHAR	1			XFELD
CF_KZEVE	Indicator for end of PRT usage: Offset to operation finish	CF_KZEVE	CHAR	1			XFELD
STEUF_REF	Control key cannot be changed	CF_STKZR	CHAR	1			XFELD
KTSCH_REF	Reference Key Cannot be Changed	CF_KTKZR	CHAR	1			XFELD
BZOFFB_REF	Start reference date cannot be changed	CF_BBKZR	CHAR	1			XFELD
OFFSTB_REF	Offset to start cannot be changed	CF_OBKZR	CHAR	1			XFELD
BZOFFE_REF	End reference date cannot be changed	CF_BEKZR	CHAR	1			XFELD
OFFSTE_REF	Offset to end cannot be changed	CF_OEKZR	CHAR	1			XFELD
MGFORM_REF	Formula for calculating the total quantity cannot be changed	CF_MFKZR	CHAR	1			XFELD
EWFORM_REF	Formula to calculate entire usage value cannot be changed	CF_EFKZR	CHAR	1			XFELD
TXTKZ	Indicator: Long text exists	CF_TXTKZ	CHAR	1			FLAG
INDBT	Field defined as in SY-TABIX	TABIX_D	INT4	10			TABIX
COMP_RES	OCM: Result of comparison of two order objects	OCM_COMP_RES	CHAR	1			OCM_COMP_RES
VSNMR	Number or description of a version	VSNMR	CHAR	12			VSNMR	VS2
ORGAUFPL	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
ORGPZLFH	Item counter for production resources/tools	PZLFH	NUMC	8			PZLFH

Key field

Non-key field

< AFFH - PRT assignment data for the work order AFFHB - Structure of the doc. table for PRT allocations in work ord. >

How do I retrieve data from SAP structure AFFH01 using ABAP code?

As AFFH01 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AFFH01 as there is no data to select.

How to access SAP table AFFH01

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

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

Related SAP tables and the relationships to AFFH01

    ARKOPF - Archiving run header data
        VSKOPF - Version: Header - general data for a
    VBUP - Sales Document: Item Status
    CKIP1 - Periodic Values for Unit Costing Item
    COSP1 - CO Object: Cost Totals for External Postings
        COVP11 - CO object: Line items with doc. header (by period)
            COEPD11 - CO object: Unvaluated ln. item settlement w/status
                COEPBR11 - CO Object: Valuated Line Item Settlement
        COVJ11 - CO object: Line items with doc header (by year)
        COVO1 - CO Object: Open Items for Line Items (w/o doc.Hdr)
    COSPD1 - CO object: External cost totals - calculated
    COSPP - Transfer of Order in the COSP Table to the Project
    COKS1 - CO Object: Control Data for Secondary Planning
    VBKDPO - Sales document: Business item data (POSNR > 0)
    HEAD13 - SAPscript: Text Header
        LINE13 - SAPscript: Text Lines
    COSS1 - CO Object: Cost Totals for Internal Postings
        COVP12 - CO object: Line items with doc. header (by period)
            COEPD12 - CO object: Unvaluated ln. item settlement w/status
                COEPBR12 - CO Object: Valuated Line Item Settlement
        COVJ12 - CO object: Line items with doc header (by year)
        COVO12 - CO object: Fxd price agreement commitment ln items
    COSSD1 - CO object: Internal cost totals - calculated
    COSSP - Transfer of the Order COSS Table to the Project
    FPLA - Billing plan
    COKR1 - CO Object: Control Data for Statistical Key Figs
        HEAD14 - SAPscript: Text Header
            LINE14 - SAPscript: Text Lines
    COSR1 - CO Object: Statistical Key Figure Totals
        COVPR1 - CO object: Stat. key figure line items by period
        COVJR1 - CO object: Line items stat. key figures (by year)
    COSL1 - CO Object: Activity Type Totals
        COVPL1 - CO object: Activity type line items by period
        COVJL1 - CO object: Line items for acty types (by year)
    COSLD - CO object: Activity type sums - calculated
    FPLT - Billing Plan: Dates
    COSB1 - CO Object: Total Variances/Results Analyses
        COVPB1 - CO object: Variance/accrual line items by period
    COSBD1 - CO object: Sums of variance/accrual - calculated
    ANIA1 - Depr. simulation for invest. projects
        ANIB1 - Invest. projects: Depr. simulation analysis report
    ANLI1 - Link table for capital investment measure -> AuC
    FMSU1 - FM totals records for financial data
        COVFP1 - CO object: Financial data line items with doc. hdr
    TPI031 - CO Objects: Date of Last Interest Run
    EKKO - Purchasing Document Header
    PSDYVB - LDB PSJ: Dummy structure under VBAP
    EKPO - Purchasing Document Item
        EKET - Scheduling Agreement Schedule Lines
        EKKN - Account Assignment in Purchasing Document
        EKBE - Purchasing Document History
    EBAN - Purchase requisition
        EBKN - Purchase Requisition Account Assignment
    FPLAPS - Billing plan for PSP network plan
        FPLTPS - Billing plan for PSP/network (dates)
    LIKP - SD Document: Delivery Header Data
        LIPS - SD document: Delivery: Item data
    PSDYVK - LDB PSJ: Dummy structure under VBAK
    PSMERK - Characteristics for summarization wo.classificatn
    DRAD - Document-object link
    PRPS_R - Project Hierarchy Reporting Structure
        PRTE - Scheduling Data for Project Item
        PSMLST - Milestone I/O Table
        PSTX - PS Texts (Header)
    RSTHIE - BRST structure of the hierarchy table
        PLAF - Planned order
        PSMERK_PRPS - Characteristics for Summarization for WBS Elements
    KBED04 - Capacity Requirement Recs for Planned Orders (LDB)
    RESB04 - Reservation/dependent reqs for plan order (LDB)
        PSDYPR - LDB PSJ: Dummy structure under PRPS_R
    AUFK - Order master data
        AFKO - Order Header Data PP Orders
            AFPO - Order Item
            AFFL - Work order sequence
                ACT01 - Activity for LDB 01
    PSDYRH - LDB PSJ: Dummy structure under RSTHIE
    AFAB01 - Network Relationship (for LDB) - 01
    MLSTD - Milestone I/O Table
    PSTX1 - PS Texts (Header) for Activity (1)
    AFFH01 - Order PRT Data (for LDB) - 01
    KBED01 - Capacity Requirement Records (for LDB) - 01
        KBEZ - Additional data for table KBED (for ind.req/split)
            KPER - Additional data for KBEZ (person split in days)
        AFRU02 - Order Confirmations (for LDB) -02
    RESB01 - Reservation/Dependent Requirement for LDB-01
        PSDYOK - LDB PSJ: Dummy structure under RESB01
    PROJ - Project definition
    AFRU01 - Order Confirmations (for LDB) - 01
    PSMERK_ACT - Charactersitics for Summarization for Activity
    PSDYNV - LDB PSJ: Dummy structure under ACT01
        AFIH - Maintenance order header
        PSDYNP - LDB PSJ: Dummy structure under AUFK
    IMTP - Investment programs
        IMPR - Investment Program Positions
            PSDYIP - LDB PSJ: Dummy structure under IMPR
        PSDYPG - LDB PSJ: Dummy structure under IMTP
    PEGOB - Peg (master data of the CO object)
    PSDYPD - LDB PSJ: Dummy structure under PROJ
    PEGQTY - Assigned pegging object quantities
    PSDYPEG - LDB PSJ: Dummy Structure Under PEGOB
    ELM_PS - Additional data for hierarchy nodes (LDB PSJ)
        JSTO - Status object information
            PSTAT - Condensed status display
            JCDO - Change Documents for Status Object (Table JSTO)
            JEST - Individual Status per Object
                JCDS - Change docs. for system/user status (table JEST)
        ONR00 - General Object Number
            RPSCO1 - Summarization Table for Project Reporting
    VBAK - Sales Document: Header Data
            RPSQT - Summarization table for project reporting (quants)
            EV_PARAM - Object parameters for earned value analysis
            EV_POC - Earned value analysis: percentage of completion
            EV_VAL - Earned value analysis: earned value
            COBRA - Settlement Rule for Order Settlement
                COBRB - Distribution rules for sett. rule for order sett.
            BPHI1 - Cross-hierarchy data Control
            BPTR1 - Object Data Control
                BPGE1 - Totals record total value Control
                    BPVG1 - Table Generated for View BPVG1
    VBUK - Sales Doc.: Header Status and Administrative Data
                    BKHS1 - Header - Unit Costing (Control + Totals)
                        HEAD10 - SAPscript: Text Header
                            LINE10 - SAPscript: Text Lines
                        BKHT1 - Texts for CKHS
                        BKIS1 - Individual calculation/verification item gen.
                            BKIT1 - Texts for CKIS
                        BKIP1 - Periodic Values for Unit Costing Item
                BPJA1 - Totals record for total year value Control
                    BPVJ1 - Table Generated for View BPVJ1
                    BKHS2 - Header - Unit Costing (Control + Totals)
    VBKD - Sales Document: Business Data
    HEAD20 - SAPscript: Text Header
        LINE20 - SAPscript: Text Lines
    BKHT2 - Texts for CKHS
    BKIS2 - Individual calculation/verification item gen.
        BKIT2 - Texts for CKIS
    BKIP2 - Periodic Values for Unit Costing Item
                BPPE1 - Totals Record for Period Values Control
                    BPVP1 - Table Generated for View BPVP1
                BPIG1 - Budget Object Index (Overall Budget)
                BPIJ1 - Budget Object Index (Annual Budget)
    VBAP - Sales Document: Item Data
            COKA1 - CO Object: Cost Element Control Data
            COKP1 - CO Object: Primary Planning Control Data
                HEAD11 - SAPscript: Text Header
                    LINE11 - SAPscript: Text Lines
                CKHS1 - Header - Unit Costing (Control + Totals)
                    CKHT1 - Texts for CKHS
                    HEAD12 - SAPscript: Text Header
                        LINE12 - SAPscript: Text Lines
                    CKIS1 - Individual calculation/verification item gen.
                        CKIT1 - Texts for CKIS