AFFH_CLEAR SAP (AFFHB fields which are initialized for a referenced order) Structure details
Description: AFFHB fields which are initialized for a referenced order
Structure field list including key, data, relationships and ABAP select examples
AFFH_CLEAR 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 "AFFHB fields which are initialized for a referenced order" 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_AFFH_CLEAR TYPE AFFH_CLEAR.
The AFFH_CLEAR table consists of various fields, each holding specific information or linking keys about AFFHB fields which are initialized for a referenced order data available in SAP. These include LOEKZ (Deletion Indicator), PARKZ (Indicator: inactive changes), DATUI (Date record created on), USERI (User who created record).. 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. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AFFH_CLEAR structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
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 | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
MGISTEH | Quantity unit of production resource/tool | MGEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MGIST | Confirmed quantity of production resource/tool | MGIST | QUAN | 9(3) | MENG9 | ||||
MGRSTEH | Quantity unit of production resource/tool | MGEINH | UNIT | 3 | Assigned to domain | 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 | Assigned to domain | CUNIT | MEINS | ||
MGAUS | Quantity of checked-out production resources/tools | MGAUS | QUAN | 9(3) | MENG9 | ||||
EWISTEH | Usage value unit of the production resource/tool | EWEINH | UNIT | 3 | Assigned to domain | 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 | Assigned to domain | CUNIT | MEINS | ||
EWRST | Remaining usage value of the production resource/tool | EWRST | QUAN | 9(3) | MENG9 | ||||
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 | Assigned to domain | CUNIT | MEINS | ||
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 | ||||
OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | OCM_OBJ_TYPE |
Key field | Non-key field |
How do I retrieve data from SAP structure AFFH_CLEAR using ABAP code?
As AFFH_CLEAR 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 AFFH_CLEAR as there is no data to select.How to access SAP table AFFH_CLEAR
Within an ECC or HANA version of SAP you can also view further information about AFFH_CLEAR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects