| 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 | * | MANDT | Allow NULL? |
| 2 | LOTNO | DRM lot number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | /SAPHT/DRM_LOTNO | Allow NULL? |
| 3 | DELETE_FLAG | Lot deletion flag | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_DELETE_FLAG | Allow NULL? |
| 4 | MSBOOKPARTNO | Manufacturer book part number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_MSBOOKPARTNO | Allow NULL? |
| 5 | MATERIAL | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 6 | TRACK_PARTNER | Tracking partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_TRACK_PARTNER | Allow NULL? |
| 7 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 8 | LOTTYPE | DRM lot type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_LOTTYPE | Allow NULL? |
| 9 | END_CUST | DRM end customer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_ENDCST | Allow NULL? |
| 10 | PLANT | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 11 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 12 | DIST_CHNL | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VTWEG | Allow NULL? |
| 13 | DIVISION | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART | Allow NULL? |
| 14 | PURCH_ORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EKORG | Allow NULL? |
| 15 | BUCKETTYPE | DRM bucket type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_BUCKTYP | Allow NULL? |
| 16 | MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_MSDRIND | Allow NULL? |
| 17 | ASSEMBLY_IND | Assembly indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_ASSIND | Allow NULL? |
| 18 | MATDOCQTY | Material document quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_MDQTY | |
| 19 | INVOICQTY | Invoice quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_INVQTY | |
| 20 | DRAVLQTY | Unresold quantity in DRM lot | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_AVLQTY | |
| 21 | DRSTQTY | Sell-through quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_STQTY | |
| 22 | PRISSQTY | Quantity of material issued to production | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_PRISSQTY | |
| 23 | ECRETQTY | Change in resale return quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_ECRETQTY | |
| 24 | MSRETQTY | Quantity returned by distributor/ reseller | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_MSRETQTY | |
| 25 | DSSELLINQTY | Drop-Ship Sell-in qty awaiting Resale Reporting | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_DSSELLINQTY | |
| 26 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 27 | ALT_UOM | Alternate unit of measure for quantities | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | /SAPHT/DRM_ALT_UOM | Allow NULL? |
| 28 | QTY_NUMER | Numerator to convert quantities | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_QTY_NUMER | |
| 29 | QTY_DENOM | Denominator to convert quantities | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_QTY_DENOM | |
| 30 | PRIC_UNIT | Pricing unit for price protectable price | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_PRCUNIT | |
| 31 | COND_RATE | Price protectable price condition rate | decimal | 11 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_COND_RATE | |
| 32 | COND_CURR | Price protectable price currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | /SAPHT/DRM_COND_CURR | Allow NULL? |
| 33 | COND_NUMER | Numerator for converting price protectable price | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_COND_NUMERATOR | |
| 34 | COND_DENOM | Denominator for conversion to base unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_COND_DENOM | |
| 35 | COND_UOM | Pricing unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | /SAPHT/DRM_PRIC_UOM | Allow NULL? |
| 36 | LAST_SELLIN_DT | Latest Sell In Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_SELLINDT | Allow NULL? |
| 37 | PPTYPE | Price protection type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_PPTYPE | Allow NULL? |
| 38 | LASTAUDITNO | Total number of audit trails for DRM lot | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | /SAPHT/DRM_AUDITM | Allow NULL? |
| 39 | PP_STATUS | Price protection status of DRM lot | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_PPSTATUS | Allow NULL? |
| 40 | REF_ASMB_PRODORD | Production order number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_PRODNO | Allow NULL? |
| 41 | REF_ASMB_SLSORD | Reference assembly sales order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_REF_ASMB_SLSORD | Allow NULL? |
| 42 | REF_ASMB_SLSITM | Reference sales order item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /SAPHT/DRM_REF_ASMB_SLSITM | Allow NULL? |
| 43 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 44 | CREATED_DT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_CRDATE | Allow NULL? |
| 45 | CREATED_TM | Time created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | C_TIME | Allow NULL? |
| 46 | LASTCHGDBY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UPNAM | Allow NULL? |
| 47 | LASTCHGDDT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 48 | CHANGED_TM | Last changed at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AS4TIME | Allow NULL? |
| 49 | DUMMY_1 | Dummy function in length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | DUMMY | Allow NULL? |
