SAP ABAP Table AFFHR (PRT Structure for Project Reporting)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ PS-IS (Application Component) Information System
⤷ CNIS (Package) Application development R/3 PS information system
⤷ PS-IS (Application Component) Information System
⤷ CNIS (Package) Application development R/3 PS information system
Basic Data
Table Category | INTTAB | Structure |
Structure | AFFHR | Table Relationship Diagram |
Short Description | PRT Structure for Project Reporting |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | ARNUMMER | ADMI_RUN_D | ADMI_RUN | CHAR | 6 | 0 | Archiving Session Number | ||
2 | VSGRUPPE | VSGRUPPE | TEXT20 | CHAR | 20 | 0 | Group for a project version | ||
3 | VSNUMMER | VSNMR | VSNMR | CHAR | 12 | 0 | Number or description of a version | ||
4 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
5 | PRNAM | IM_PRNAM | IM_PRNAM | CHAR | 8 | 0 | Investment program name | IMTP | |
6 | PRPOS | IM_POSID | IM_POSID | CHAR | 24 | 0 | Identification for an investment program position | ||
7 | PSPID | PS_PSPID | PS_PSPID | CHAR | 24 | 0 | Project definition | ||
8 | POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
9 | KDAUF | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | VBUK | |
10 | KDPOS | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | VBUP | |
11 | AUFNR | AUF_NETNR | AUFNR | CHAR | 12 | 0 | Order/Network number | AUFK | |
12 | VORNR | CN_VORNR | VORNR | CHAR | 4 | 0 | Activity number in network and standard network | ||
13 | PSNFH | PSNFH | PSNFH | NUMC | 4 | 0 | Item Number for Production Resource/Tool | ||
14 | AUTYPTXT | AUTYPTEXT | TEXT40 | CHAR | 40 | 0 | Display field for order category description | ||
15 | STEUF | STEUF | STEUF | CHAR | 4 | 0 | Control key for management of production resources/tools | TCF10 | |
16 | STEUTXT | STEUTXT | TEXT40 | CHAR | 40 | 0 | Control key description | ||
17 | KZKBL | KZKBL | XFELD | CHAR | 1 | 0 | Indicator: Create load records for prod. resources/tools | ||
18 | BZOFFB | BZOFFB | CP_BZOFF | CHAR | 2 | 0 | Reference date to start of production resource/tool usage | TCA54 | |
19 | OFFSTB | OFFSTB | VNZTV | QUAN | 5 | 0 | Offset to start of production resource/tool usage | ||
20 | EHOFFB | EHOFFB | MEINS | UNIT | 3 | 0 | Offset unit for start of prod. resource/tool usage | T006 | |
21 | BZOFFE | BZOFFE | CP_BZOFF | CHAR | 2 | 0 | Reference date for end of production resource/tool usage | TCA54 | |
22 | OFFSTE | OFFSTE | VNZTV | QUAN | 5 | 0 | Offset to finish of production resource/tool usage | ||
23 | EHOFFE | EHOFFE | MEINS | UNIT | 3 | 0 | Offset unit for end of production resource/tool usage | T006 | |
24 | FSFHD | CF_FSFHD | DATUM | DATS | 8 | 0 | Earliest scheduled start (date) for PRT usage | ||
25 | FSFHZ | CF_FSFHZ | UZEIT | TIMS | 6 | 0 | Earliest scheduled start (time) for PRT usage | ||
26 | FEFHD | CF_FEFHD | DATUM | DATS | 8 | 0 | Earliest scheduled finish (date) of PRT usage | ||
27 | FEFHZ | CF_FEFHZ | UZEIT | TIMS | 6 | 0 | Earliest scheduled end (time) of PRT usage | ||
28 | SSFHD | CF_SSFHD | DATUM | DATS | 8 | 0 | Latest scheduled start (date) for PRT usage | ||
29 | SSFHZ | CF_SSFHZ | UZEIT | TIMS | 6 | 0 | Latest scheduled start (time) for PRT usage | ||
30 | SEFHD | CF_SEFHD | DATUM | DATS | 8 | 0 | Latest scheduled finish (date) of PRT usage | ||
31 | SEFHZ | CF_SEFHZ | UZEIT | TIMS | 6 | 0 | Latest scheduled end (time) for PRT usage | ||
32 | ISFHD | CF_ISFHD | DATUM | DATS | 8 | 0 | Actual start (date) of PRT usage | ||
33 | ISFHZ | CF_ISFHZ | UZEIT | TIMS | 6 | 0 | Actual start (time) of PRT usage | ||
34 | IEFHD | CF_IEFHD | DATUM | DATS | 8 | 0 | Actual finish (date) of PRT usage | ||
35 | IEFHZ | CF_IEFHZ | UZEIT | TIMS | 6 | 0 | Actual finish (time) of PRT usage | ||
36 | DAUSE | CF_DAUSE | DAUER_4_1 | QUAN | 5 | 1 | Duration of the PRT usage | ||
37 | DAUEH | CF_DAUEH | MEINS | UNIT | 3 | 0 | Time unit for duration of PRT usage | T006 | |
38 | MGEINH | MGEINH | MEINS | UNIT | 3 | 0 | Quantity unit of production resource/tool | T006 | |
39 | MGVGW | MGVGW | MENG9 | QUAN | 9 | 3 | Standard value for the PRT quantity | ||
40 | MGSOLEH | MGEINH | MEINS | UNIT | 3 | 0 | Quantity unit of production resource/tool | T006 | |
41 | MGSOL | MGSOL | MENG9 | QUAN | 9 | 3 | Total planned quantity of production resource/tool | ||
42 | MGISTEH | MGEINH | MEINS | UNIT | 3 | 0 | Quantity unit of production resource/tool | T006 | |
43 | MGIST | MGIST | MENG9 | QUAN | 9 | 3 | Confirmed quantity of production resource/tool | ||
44 | MGRSTEH | MGEINH | MEINS | UNIT | 3 | 0 | Quantity unit of production resource/tool | T006 | |
45 | MGRST | MGRST | MENG9 | QUAN | 9 | 3 | Remaining quantity of the production resource/tool | ||
46 | MGAUSEH | MGEINH | MEINS | UNIT | 3 | 0 | Quantity unit of production resource/tool | T006 | |
47 | MGAUS | MGAUS | MENG9 | QUAN | 9 | 3 | Quantity of checked-out production resources/tools | ||
48 | MGFORM | CF_MGFORM | AP_FORMEL | CHAR | 6 | 0 | Formula for calculating the total quantity of PRT | TC25 | |
49 | EWEINH | EWEINH | MEINS | UNIT | 3 | 0 | Usage value unit of the production resource/tool | T006 | |
50 | EWVGW | EWVGW | MENG9 | QUAN | 9 | 3 | Standard usage value for production resources/tools | ||
51 | EWSOLEH | EWEINH | MEINS | UNIT | 3 | 0 | Usage value unit of the production resource/tool | T006 | |
52 | EWSOL | EWSOL | MENG9 | QUAN | 9 | 3 | Total planned usage value of production resource/tool | ||
53 | EWISTEH | EWEINH | MEINS | UNIT | 3 | 0 | Usage value unit of the production resource/tool | T006 | |
54 | EWIST | EWIST | MENG9 | QUAN | 9 | 3 | Actual usage value for production resource/tool | ||
55 | EWRSTEH | EWEINH | MEINS | UNIT | 3 | 0 | Usage value unit of the production resource/tool | T006 | |
56 | EWRST | EWRST | MENG9 | QUAN | 9 | 3 | Remaining usage value of the production resource/tool | ||
57 | EWFORM | CF_EWFORM | AP_FORMEL | CHAR | 6 | 0 | Formula for calculating the total usage value of PRT | TC25 | |
58 | TXTSP | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
59 | KTSCH | CF_KTSCH | KTSCH | CHAR | 7 | 0 | Standard text key for production resources/tools | T435 | |
60 | TXTZ1 | TXTZ1 | TEXT40 | CHAR | 40 | 0 | First line of text for production resources/tools | ||
61 | FHMAR | FHMAR | FHMAR | CHAR | 1 | 0 | Production resources/tools category | TCF02 | |
62 | FHMNR | FHMNR | FHMNR | CHAR | 33 | 0 | Production resource/tool number | ||
63 | FHWRK | FHWRK | WERKS | CHAR | 4 | 0 | Production resources/tools in plant | T001W | |
64 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
65 | MTEXT | PS_MATTEXT | TEXT40 | CHAR | 40 | 0 | Material description | ||
66 | SFHNR | SFHNR | SFHNR | CHAR | 18 | 0 | Production resources and tools | ||
67 | DOKAR | DOKAR | DOKAR | CHAR | 3 | 0 | Document Type | TDWA | |
68 | DOKNR | DOKNR | DOKNR | CHAR | 25 | 0 | Document number | DRAW | |
69 | DOKVR | DOKVR | DOKVR | CHAR | 2 | 0 | Document version | ||
70 | DOKTL | DOKTL_D | DOKTL | CHAR | 3 | 0 | Document part | ||
71 | EQUNR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | EQUI | |
72 | EQPNT | IMRC_POINT | IMRC_POINT | CHAR | 12 | 0 | Measuring Point | IMPTT | |
73 | EQPTX | IMRC_PTTXT | TEXT40 | CHAR | 40 | 0 | Description of Measuring Point | ||
74 | MSEHI | MSEHI | MEINS | UNIT | 3 | 0 | Unit of Measurement | T006 | |
75 | FHKTX | FHKTX | TEXT40 | CHAR | 40 | 0 | Description of the production resource/tool | ||
76 | FGRU1 | FGRUA | FGRUA | CHAR | 4 | 0 | Grouping key 1 for production resources/tools | TCF12 | |
77 | FGRU2 | FGRUB | FGRUA | CHAR | 4 | 0 | Grouping key 2 for production resources/tools | TCF12 | |
78 | TXTKZ | CF_TXTKZ | FLAG | CHAR | 1 | 0 | Indicator: Long text exists | ||
79 | STATXT | STATUSTEXT_2 | CHAR80 | CHAR | 80 | 0 | Edited status text |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |