| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | INVNO | Inventory record number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | /SAPHT/DRM_INVNO | Allow NULL? |
| 3 | MSBOOKPARTNO | Manufacturer book part number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_MSBOOKPARTNO | Allow NULL? |
| 4 | TRACK_PARTNER | Tracking partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_TRACK_PARTNER | Allow NULL? |
| 5 | LOTTYPE | DRM lot type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_LOTTYPE | Allow NULL? |
| 6 | END_CUST | DRM end customer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_ENDCST | Allow NULL? |
| 7 | PLANT | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 9 | DIST_CHNL | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWEG | Allow NULL? |
| 10 | DIVISION | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART | Allow NULL? |
| 11 | PURCH_ORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EKORG | Allow NULL? |
| 12 | MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_MSDRIND | Allow NULL? |
| 13 | TRANSM_NO | EDI transmission number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_TRANSMNO | Allow NULL? |
| 14 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_EFFDATE | Allow NULL? |
| 15 | CURR_FIFO_QTY | Current material inventory with distributor/ reseller | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_FIFOQTY | |
| 16 | RECOMP_DATE | Recomputation date. | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_RECOMP_DATE | Allow NULL? |
| 17 | FIFO_QTY | Inventory of material as on effective date | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_EFF_FIFOQTY | |
| 18 | SELLTHRUQT | Reported material quantity in base unit | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_SELLTTHRUQTY | |
| 19 | TRANSIT_QTY | Quantity of material in transit. | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_TRANSIT_QTY | |
| 20 | TRANSIT_DAYS | In-transit days | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /SAPHT/DRM_TRANSIT_DAYS | Allow NULL? |
| 21 | RECON_QTY | Adjustment quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_RECONQTY | |
| 22 | TOT_RECON_QTY | Total reconciliation applied so far | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_TOT_RECONQTY | |
| 23 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 24 | IR_STATUS | Reconciliation status of inventory summary record | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_IR_STATUS | Allow NULL? |
| 25 | MAT_NOT_REP_FLAG | Flag to check whether the material has been reported or not. | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_MAT_NOT_REP_FLAG | Allow NULL? |
| 26 | LOG_HANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | BALLOGHNDL | Allow NULL? |
| 27 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 28 | CREATED_DT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_CRDATE | Allow NULL? |
| 29 | CREATED_TM | Time created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | C_TIME | Allow NULL? |
| 30 | LASTCHGDBY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UPNAM | Allow NULL? |
| 31 | LASTCHGDDT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 32 | CHANGED_TM | Last changed at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AS4TIME | Allow NULL? |
| 33 | DUMMY_1 | Dummy function in length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | DUMMY | Allow NULL? |
