SAP TABLES | Project System | Information System(PS-IS) SAP PS

AFFH01 SAP Order PRT Data (for LDB) - 01 Structure and data







AFFH01 is an SAP Structure so does not store data like a database table does but can be used 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 .

Below is the documentation avaialable and full details of the fields which make up this Structure.

You can view further information about this via relevant transactions such as SE11 or SE80. Also check out the Comments section below to view or add related contributions and example screen shots.



Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Not classified
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP AFFH01 Structure fields within data Dictionary





Field
Component Type
Data Typelength (Decimals)Check tableDescriptionConversion Routine
.INCLUDEAFFHD Structure of the PRTs in orders
.INCLUDEAFFH PRT assignment data for the work order
MANDTMANDTCLNT3 T000Client
AUFPLCO_AUFPLNUMC10 Routing number of operations in the order
PZLFHPZLFHNUMC8 Item counter for production resources/tools
.INCLUDEAFFH_INC PRT assignment data for the work order
LOEKZLKENZCHAR1 Deletion Indicator
PARKZPARKZCHAR1 Indicator: inactive changes
DATUIANDATDATS8 Date record created on
USERIANNAMCHAR12 User who created record
DATUCAEDATDATS8 Changed On
USERCAENAMCHAR12 Name of Person Who Changed Object
OBJTYCR_OBJTYCHAR2 Object types of the CIM resource
OBJIDCR_OBJIDNUMC8 CRIDObject ID of the resource
PLNTY_KEYPLNTYCHAR1 TCA01Task List Type
PLNNR_KEYPLNNRCHAR8 Key for Task List GroupALPHA
PZLFH_KEYPZLFHNUMC8 Item counter for production resources/tools
ZAEHL_KEYCIM_COUNTNUMC8 Internal counter
OBJCTOBJCT_DCHAR1 Object of a task list
APLZLCIM_COUNTNUMC8 Internal counter
PSNFHPSNFHNUMC4 Item Number for Production Resource/Tool
OBJNRJ_OBJNRCHAR22 ONR00Object number
STEUFSTEUFCHAR4 TCF10Control key for management of production resources/tools
KZKBLKZKBLCHAR1 Indicator: Create load records for prod. resources/tools
BZOFFBBZOFFBCHAR2 TCA54Reference date to start of production resource/tool usage
OFFSTBOFFSTBQUAN5 Offset to start of production resource/tool usage
EHOFFBEHOFFBUNIT3 T006Offset unit for start of prod. resource/tool usageCUNIT
BZOFFEBZOFFECHAR2 TCA54Reference date for end of production resource/tool usage
OFFSTEOFFSTEQUAN5 Offset to finish of production resource/tool usage
EHOFFEEHOFFEUNIT3 T006Offset unit for end of production resource/tool usageCUNIT
FSFHDCF_FSFHDDATS8 Earliest scheduled start (date) for PRT usage
FSFHZCF_FSFHZTIMS6 Earliest scheduled start (time) for PRT usage
FEFHDCF_FEFHDDATS8 Earliest scheduled finish (date) of PRT usage
FEFHZCF_FEFHZTIMS6 Earliest scheduled end (time) of PRT usage
SSFHDCF_SSFHDDATS8 Latest scheduled start (date) for PRT usage
SSFHZCF_SSFHZTIMS6 Latest scheduled start (time) for PRT usage
SEFHDCF_SEFHDDATS8 Latest scheduled finish (date) of PRT usage
SEFHZCF_SEFHZTIMS6 Latest scheduled end (time) for PRT usage
ISFHDCF_ISFHDDATS8 Actual start (date) of PRT usage


ISFHZCF_ISFHZTIMS6 Actual start (time) of PRT usage
IEFHDCF_IEFHDDATS8 Actual finish (date) of PRT usage
IEFHZCF_IEFHZTIMS6 Actual finish (time) of PRT usage
DAUFLCF_DAUFLFLTP16(16) Duration of PRT usage
DAUEHCF_DAUEHUNIT3 T006Time unit for duration of PRT usageCUNIT
MGEINHMGEINHUNIT3 T006Quantity unit of production resource/toolCUNIT
MGVGWMGVGWQUAN9(3) Standard value for the PRT quantity
MGSOLEHMGEINHUNIT3 T006Quantity unit of production resource/toolCUNIT
MGSOLMGSOLQUAN9(3) Total planned quantity of production resource/tool
MGISTEHMGEINHUNIT3 T006Quantity unit of production resource/toolCUNIT
MGISTMGISTQUAN9(3) Confirmed quantity of production resource/tool
MGRSTEHMGEINHUNIT3 T006Quantity unit of production resource/toolCUNIT
MGRSTMGRSTQUAN9(3) Remaining quantity of the production resource/tool
MGAUSEHMGEINHUNIT3 T006Quantity unit of production resource/toolCUNIT
MGAUSMGAUSQUAN9(3) Quantity of checked-out production resources/tools
MGFORMCF_MGFORMCHAR6 TC25Formula for calculating the total quantity of PRT
EWEINHEWEINHUNIT3 T006Usage value unit of the production resource/toolCUNIT
EWVGWEWVGWQUAN9(3) Standard usage value for production resources/tools
EWSOLEHEWEINHUNIT3 T006Usage value unit of the production resource/toolCUNIT
EWSOLEWSOLQUAN9(3) Total planned usage value of production resource/tool
EWISTEHEWEINHUNIT3 T006Usage value unit of the production resource/toolCUNIT
EWISTEWISTQUAN9(3) Actual usage value for production resource/tool
EWRSTEHEWEINHUNIT3 T006Usage value unit of the production resource/toolCUNIT
EWRSTEWRSTQUAN9(3) Remaining usage value of the production resource/tool
EWFORMCF_EWFORMCHAR6 TC25Formula for calculating the total usage value of PRT
TXTSPSPRASLANG1 T002Language KeyISOLA
KTSCHCF_KTSCHCHAR7 T435Standard text key for production resources/tools
TXTZ1TXTZ1CHAR40 First line of text for production resources/tools
OBJTYPEOCM_OBJ_TYPECHAR1 Change indicator
CH_PROCOCM_CH_PROCCHAR1 Process that has lead to the change of an object
AENNRAENNRCHAR12
*
Change NumberAENNR
DAUSECF_DAUSEQUAN5(1) Duration of the PRT usage
AUFNRAUFNRCHAR12 AUFKOrder NumberALPHA
FHMARFHMARCHAR1 TCF02Production resources/tools categoryFHMAR
FHMNRFHMNRCHAR33 Production resource/tool number
FHWRKFHWRKCHAR4 T001WProduction resources/tools in plant
MATNRMATNRCHAR18 MARAMaterial NumberMATN1
SFHNRSFHNRCHAR18 Production resources and toolsALPHA
DOKARDOKARCHAR3 TDWADocument Type


DOKNRDOKNRCHAR25 DRAWDocument numberALPHA
DOKVRDOKVRCHAR2 Document Version
DOKTLDOKTL_DCHAR3 Document Part
EQUNREQUNRCHAR18 EQUIEquipment NumberALPHA
EQWPLWARPLCHAR12 MPLAMaintenance PlanALPHA
EQWTXWPTXTCHAR40 Maintenance Plan Text
EQPNTIMRC_POINTCHAR12 IMPTTMeasuring PointALPHA
EQPTXIMRC_PTTXTCHAR40 Description of Measuring Point
ATNAMATNAMCHAR30 Characteristic Name
ATVORIMRC_INEGVCHAR1 Indicator: Negative Values Allowed
MSEHIMSEHIUNIT3 T006Unit of MeasurementCUNIT
ATDIMATDIMINT25 Exponent display
ANZDZANZDZINT25 Number of Decimal Places
FHKTXFHKTXCHAR40 Description of the production resource/tool
BASEHCF_BASEHUNIT3 T006Base unit of measure for production resources/toolsCUNIT
MEINSMEINSUNIT3 T006Base Unit of MeasureCUNIT
FGRU1FGRUACHAR4 TCF12Grouping key 1 for production resources/tools
FGRU2FGRUBCHAR4 TCF12Grouping key 2 for production resources/tools
STOWKCF_STOWKCHAR4 T001WPlant location of the production resource/tool
STORTCF_STORTCHAR10 T499SLocation of a production resource or tool
FSTTXTCO_STTXTCHAR40 System Status
CF_KZSVSCF_KZSVSCHAR1 Indicator for start of PRT usage: Offset to Operation start
CF_KZSVECF_KZSVECHAR1 Indicator for start of PRT usage: Offset to op. finish
CF_KZEVSCF_KZEVSCHAR1 Indicator for end of PRT usage: Offset to operation start
CF_KZEVECF_KZEVECHAR1 Indicator for end of PRT usage: Offset to operation finish
STEUF_REFCF_STKZRCHAR1 Control key cannot be changed
KTSCH_REFCF_KTKZRCHAR1 Reference Key Cannot be Changed
BZOFFB_REFCF_BBKZRCHAR1 Start reference date cannot be changed
OFFSTB_REFCF_OBKZRCHAR1 Offset to start cannot be changed
BZOFFE_REFCF_BEKZRCHAR1 End reference date cannot be changed
OFFSTE_REFCF_OEKZRCHAR1 Offset to end cannot be changed
MGFORM_REFCF_MFKZRCHAR1 Formula for calculating the total quantity cannot be changed
EWFORM_REFCF_EFKZRCHAR1 Formula to calculate entire usage value cannot be changed
TXTKZCF_TXTKZCHAR1 Indicator: Long text exists
INDBTTABIX_DINT410 Field defined as in SY-TABIX
COMP_RESOCM_COMP_RESCHAR1 OCM: Result of comparison of two order objects
.INCLUDEVSFHMINF Version information about production resources/tools
VSNMRVSNMRCHAR12 Number or description of a version
.INCLUDEVSAFFHORG Original key for production resources/tools (versions)

ORGAUFPLCO_AUFPLNUMC10 Routing number of operations in the order
ORGPZLFHPZLFHNUMC8 Item counter for production resources/tools



Key field
Non-key field

AFFH01 relationships with other tables


ARKOPF-Archiving run header data
     VSKOPF-Version: Header - general data for a
          RSTHIE-BRST structure of the hierarchy table
               PSDYRH-LDB PSJ: Dummy structure under RSTHIE
          PROJ-Project definition
               PSDYPD-LDB PSJ: Dummy structure under PROJ
          VBAK-Sales Document: Header Data
               VBUK-Sales Doc.: Header Status and Administrative Data
               VBKD-Sales Document: Business Data
               VBAP-Sales Document: Item Data
                    VBUP-Sales Document: Item Status
                    VBKDPO-Sales document: Business item data (POSNR > 0)
                         FPLA-Billing plan
                              FPLT-Billing Plan: Dates
                    PSDYVB-LDB PSJ: Dummy structure under VBAP
               PSDYVK-LDB PSJ: Dummy structure under VBAK
          PRPS_R-Project Hierarchy Reporting Structure
               PRTE-Scheduling Data for Project Item
               PSMLST-Milestone I/O Table
               PSTX-PS Texts (Header)
               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
                              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
                              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)
               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
                    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
                              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)
                                   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)
                    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
                              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
                         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
                    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
                    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
                    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
               PSMERK-Characteristics for summarization wo.classificatn
               DRAD-Document-object link