SAP ABAP Table /SAPHT/DRMINVSUM (DRM Inventory Summary)
Hierarchy
ECC-DIMP (Software Component) DIMP
   IS-HT-DRM (Application Component) Distributor-Reseller-Management
     /SAPHT/DRM02 (Package) DRM Development
Basic Data
Table Category TRANSP    Transparent table 
Transparent table /SAPHT/DRMINVSUM   Table Relationship Diagram
Short Description DRM Inventory Summary    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 INVNO /SAPHT/DRM_INVNO BELNR CHAR 10   0   Inventory record number  
3 .INCLUDE       0   0   DRM Inventory Summary: Logical Key  
4 MSBOOKPARTNO /SAPHT/DRM_MSBOOKPARTNO MATNR CHAR 18   0   Manufacturer book part number *
5 TRACK_PARTNER /SAPHT/DRM_TRACK_PARTNER BU_PARTNER CHAR 10   0   Tracking partner *
6 LOTTYPE /SAPHT/DRM_LOTTYPE /SAPHT/DRM_LOTTYPE CHAR 1   0   DRM lot type  
7 END_CUST /SAPHT/DRM_ENDCST BU_PARTNER CHAR 10   0   DRM end customer *
8 PLANT WERKS_D WERKS CHAR 4   0   Plant *
9 SALES_ORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
10 DIST_CHNL VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
11 DIVISION SPART SPART CHAR 2   0   Division *
12 PURCH_ORG EKORG EKORG CHAR 4   0   Purchasing organization *
13 MS_DR_IND /SAPHT/DRM_MSDRIND /SAPHT/DRM_MSDRIND CHAR 1   0   Indicates manufacturer/supplier or distributor/reseller lot  
14 TRANSM_NO /SAPHT/DRM_TRANSMNO CHAR20 CHAR 20   0   EDI transmission number  
15 EFF_DATE /SAPHT/DRM_EFFDATE DATS DATS 8   0   EDI transmission effective date  
16 CURR_FIFO_QTY /SAPHT/DRM_FIFOQTY MENGV15_3 QUAN 15   3   Current material inventory with distributor/ reseller  
17 RECOMP_DATE /SAPHT/DRM_RECOMP_DATE DATS DATS 8   0   Recomputation date.  
18 FIFO_QTY /SAPHT/DRM_EFF_FIFOQTY MENGV15_3 QUAN 15   3   Inventory of material as on effective date  
19 SELLTHRUQT /SAPHT/DRM_SELLTTHRUQTY MENGV15_3 QUAN 15   3   Reported material quantity in base unit  
20 TRANSIT_QTY /SAPHT/DRM_TRANSIT_QTY MENGV15_3 QUAN 15   3   Quantity of material in transit.  
21 TRANSIT_DAYS /SAPHT/DRM_TRANSIT_DAYS /SAPHT/DRM_TRANSIT_DAYS NUMC 3   0   In-transit days  
22 RECON_QTY /SAPHT/DRM_RECONQTY MENGV15_3 QUAN 15   3   Adjustment quantity  
23 TOT_RECON_QTY /SAPHT/DRM_TOT_RECONQTY MENGV15_3 QUAN 15   3   Total reconciliation applied so far  
24 QTY_UNIT MEINS MEINS UNIT 3   0   Base Unit of Measure *
25 IR_STATUS /SAPHT/DRM_IR_STATUS /SAPHT/DRM_IR_STATUS CHAR 2   0   Reconciliation status of inventory summary record  
26 MAT_NOT_REP_FLAG /SAPHT/DRM_MAT_NOT_REP_FLAG /SAPHT/DRM_MAT_NOT_REP_FLAG CHAR 1   0   Flag to check whether the material has been reported or not.  
27 LOG_HANDLE BALLOGHNDL SYSUUID_22 CHAR 22   0   Application Log: Log Handle  
28 .INCLUDE       0   0   DRM Structure for tracking Created By/Changed By...  
29 CREATED_BY ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
30 CREATED_DT /SAPHT/DRM_CRDATE DATUM DATS 8   0   Created on  
31 CREATED_TM C_TIME UZEIT TIMS 6   0   Time created  
32 LASTCHGDBY UPNAM USNAM CHAR 12   0   Last Changed By  
33 LASTCHGDDT AEDAT DATUM DATS 8   0   Last Changed On  
34 CHANGED_TM AS4TIME AS4TIME TIMS 6   0   Last changed at  
35 .INCLUDE       0   0   Addtional Fields to be stored in DRM Transaction tables  
36 DUMMY_1 DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPHT/DRMINVSUM DIST_CHNL TVTW VTWEG REF    
2 /SAPHT/DRMINVSUM MANDT T000 MANDT KEY    
3 /SAPHT/DRMINVSUM SALES_ORG TVKO VKORG REF    
History
Last changed by/on SAP  20110901 
SAP Release Created in