/SAPHT/DRMFIFINV SAP (DRM Inventory Reconciliation FIFO Inventory) Table details
Dictionary Type: Table
Description: DRM Inventory Reconciliation FIFO Inventory
Description: DRM Inventory Reconciliation FIFO Inventory
ABAP Code to SELECT data from /SAPHT/DRMFIFINV
Related tables to /SAPHT/DRMFIFINV
Access table /SAPHT/DRMFIFINV
Related tables to /SAPHT/DRMFIFINV
Access table /SAPHT/DRMFIFINV
Table field list including key, data, relationships and ABAP select examples
/SAPHT/DRMFIFINV is a standard SAP Table which is used to store DRM Inventory Reconciliation FIFO Inventory data and is available within R/3 SAP systems depending on the version and release level.
The /SAPHT/DRMFIFINV table consists of various fields, each holding specific information or linking keys about DRM Inventory Reconciliation FIFO Inventory data available in SAP. These include INVNO (Inventory record number), LOTNO (DRM lot number), IRCURRQTY (Lot quatity as on current date), RECOMP_DATE (Recomputation date.).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /SAPHT/DRMFIFINV table 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| INVNO | Inventory record number | /SAPHT/DRM_INVNO | CHAR | 10 | /SAPHT/DRMINVSUM | ALPHA | BELNR | ||
| LOTNO | DRM lot number | /SAPHT/DRM_LOTNO | CHAR | 10 | /SAPHT/DRMHEAD | ALPHA | BELNR | ||
| IRCURRQTY | Lot quatity as on current date | /SAPHT/DRM_CURRQTY | QUAN | 15(3) | /SAPHT/DRM_CURRQTY | ||||
| RECOMP_DATE | Recomputation date. | /SAPHT/DRM_RECOMP_DATE | DATS | 8 | DATS | ||||
| QTY_UNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| CUR_COND_RATE | IR rate as on current date | /SAPHT/DRM_CURR_COND_RATE | CURR | 15(2) | /SAPHT/DRM_CURR_COND_RATE | ||||
| CUR_COND_CURR | Lot price currency on current date | /SAPHT/DRM_CURR_COND_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| CUR_PRICE_UNIT | unit as on Current date | /SAPHT/DRM_CURR_PRCUNIT | DEC | 5 | KPEIN | ||||
| IREFFQTY | Lot quantity on effective date as per manufacturer/ supplier | /SAPHT/DRM_EFFQTY | QUAN | 15(3) | /SAPHT/DRM_EFFQTY | ||||
| EFF_COND_RATE | Rate on effective date | /SAPHT/DRM_EFF_COND_RATE | CURR | 11(2) | WERTV6 | ||||
| EFF_COND_CURR | Currency on effective date | /SAPHT/DRM_EFF_COND_CURR | CUKY | 5 | Assigned to domain | WAERS | |||
| EFF_PRICE_UNIT | Unit on effective date | /SAPHT/DRM_EFF_PRCUNIT | DEC | 5 | KPEIN | ||||
| RECON_QTY | Adjustment quantity | /SAPHT/DRM_RECONQTY | QUAN | 15(3) | MENGV15_3 | ||||
| TRANSIT_QTY | Adjustment quantity | /SAPHT/DRM_RECONQTY | QUAN | 15(3) | MENGV15_3 | ||||
| TRANSIT_DAYS | In-transit days | /SAPHT/DRM_TRANSIT_DAYS | NUMC | 3 | /SAPHT/DRM_TRANSIT_DAYS | ||||
| TOT_ADJ_QTY | Adjustment quantity | /SAPHT/DRM_RECONQTY | QUAN | 15(3) | MENGV15_3 | ||||
| BUCKETTYPE | DRM bucket type | /SAPHT/DRM_BUCKTYP | CHAR | 2 | /SAPHT/DRM_BUCKTYPE | ||||
| MATERIAL | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| MSBOOKPARTNO | Manufacturer book part number | /SAPHT/DRM_MSBOOKPARTNO | CHAR | 18 | Assigned to domain | MATN1 | MATNR | /SAPHT/DRM_MSBOOKPRT | MAT1 |
| CREATED_BY | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| CREATED_DT | Created on | /SAPHT/DRM_CRDATE | DATS | 8 | DATUM | ||||
| CREATED_TM | Time created | C_TIME | TIMS | 6 | UZEIT | ||||
| LASTCHGDBY | Last Changed By | UPNAM | CHAR | 12 | USNAM | ||||
| LASTCHGDDT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| CHANGED_TM | Last changed at | AS4TIME | TIMS | 6 | AS4TIME | ||||
| DUMMY_1 | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
| Key field | Non-key field |
How do I retrieve data from SAP table /SAPHT/DRMFIFINV using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPHT/DRMFIFINV to SELECT all data from the tableDATA: WA_/SAPHT/DRMFIFINV TYPE /SAPHT/DRMFIFINV.
SELECT SINGLE *
FROM /SAPHT/DRMFIFINV
INTO CORRESPONDING FIELDS OF WA_/SAPHT/DRMFIFINV
WHERE...
How to access SAP table /SAPHT/DRMFIFINV
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMFIFINV 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