/SAPHT/DRMINVSUM SAP (DRM Inventory Summary) Table details
Dictionary Type: Table
Description: DRM Inventory Summary
Description: DRM Inventory Summary
ABAP Code to SELECT data from /SAPHT/DRMINVSUM
Related tables to /SAPHT/DRMINVSUM
Access table /SAPHT/DRMINVSUM
Related tables to /SAPHT/DRMINVSUM
Access table /SAPHT/DRMINVSUM
Table field list including key, data, relationships and ABAP select examples
/SAPHT/DRMINVSUM is a standard SAP Table which is used to store DRM Inventory Summary data and is available within R/3 SAP systems depending on the version and release level.
The /SAPHT/DRMINVSUM table consists of various fields, each holding specific information or linking keys about DRM Inventory Summary data available in SAP. These include INVNO (Inventory record number), MSBOOKPARTNO (Manufacturer book part number), TRACK_PARTNER (Tracking partner), LOTTYPE (DRM lot type).. 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/DRMINVSUM 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 | ALPHA | BELNR | |||
| MSBOOKPARTNO | Manufacturer book part number | /SAPHT/DRM_MSBOOKPARTNO | CHAR | 18 | Assigned to domain | MATN1 | MATNR | /SAPHT/DRM_MSBOOKPRT | MAT1 |
| TRACK_PARTNER | Tracking partner | /SAPHT/DRM_TRACK_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
| LOTTYPE | DRM lot type | /SAPHT/DRM_LOTTYPE | CHAR | 1 | /SAPHT/DRM_LOTTYPE | ||||
| END_CUST | DRM end customer | /SAPHT/DRM_ENDCST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
| PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| SALES_ORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
| DIST_CHNL | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
| DIVISION | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
| PURCH_ORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
| MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | /SAPHT/DRM_MSDRIND | CHAR | 1 | /SAPHT/DRM_MSDRIND | ||||
| TRANSM_NO | EDI transmission number | /SAPHT/DRM_TRANSMNO | CHAR | 20 | CHAR20 | /SAPHT/DRM_TRANSM_NO | |||
| EFF_DATE | EDI transmission effective date | /SAPHT/DRM_EFFDATE | DATS | 8 | DATS | ||||
| CURR_FIFO_QTY | Current material inventory with distributor/ reseller | /SAPHT/DRM_FIFOQTY | QUAN | 15(3) | MENGV15_3 | ||||
| RECOMP_DATE | Recomputation date. | /SAPHT/DRM_RECOMP_DATE | DATS | 8 | DATS | ||||
| FIFO_QTY | Inventory of material as on effective date | /SAPHT/DRM_EFF_FIFOQTY | QUAN | 15(3) | MENGV15_3 | ||||
| SELLTHRUQT | Reported material quantity in base unit | /SAPHT/DRM_SELLTTHRUQTY | QUAN | 15(3) | MENGV15_3 | ||||
| TRANSIT_QTY | Quantity of material in transit. | /SAPHT/DRM_TRANSIT_QTY | QUAN | 15(3) | MENGV15_3 | ||||
| TRANSIT_DAYS | In-transit days | /SAPHT/DRM_TRANSIT_DAYS | NUMC | 3 | /SAPHT/DRM_TRANSIT_DAYS | ||||
| RECON_QTY | Adjustment quantity | /SAPHT/DRM_RECONQTY | QUAN | 15(3) | MENGV15_3 | ||||
| TOT_RECON_QTY | Total reconciliation applied so far | /SAPHT/DRM_TOT_RECONQTY | QUAN | 15(3) | MENGV15_3 | ||||
| QTY_UNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| IR_STATUS | Reconciliation status of inventory summary record | /SAPHT/DRM_IR_STATUS | CHAR | 2 | /SAPHT/DRM_IR_STATUS | ||||
| MAT_NOT_REP_FLAG | Flag to check whether the material has been reported or not. | /SAPHT/DRM_MAT_NOT_REP_FLAG | CHAR | 1 | /SAPHT/DRM_MAT_NOT_REP_FLAG | ||||
| LOG_HANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
| 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/DRMINVSUM using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPHT/DRMINVSUM to SELECT all data from the tableDATA: WA_/SAPHT/DRMINVSUM TYPE /SAPHT/DRMINVSUM.
SELECT SINGLE *
FROM /SAPHT/DRMINVSUM
INTO CORRESPONDING FIELDS OF WA_/SAPHT/DRMINVSUM
WHERE...
How to access SAP table /SAPHT/DRMINVSUM
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMINVSUM 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