| 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 | BILLUPDLDOCNO | Bill-up due list document number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | /SAPHT/DRM_BILLUP_DL_DOC_NO | Allow NULL? |
| 3 | CLAIMDOCNO | Ship-and-debit claim document number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_CLAIMDOCNO | Allow NULL? |
| 4 | STAGDOCNO | IDOC staging table document number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_STAGDOCNO | Allow NULL? |
| 5 | INT_XMNO | DRM internal transmission number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_INTXMNO | Allow NULL? |
| 6 | TRANSM_NO | EDI transmission number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_TRANSMNO | Allow NULL? |
| 7 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_EFFDATE | Allow NULL? |
| 8 | MSBOOKPARTNO | Manufacturer book part number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_MSBOOKPARTNO | Allow NULL? |
| 9 | MATERIAL | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 10 | TRACK_PARTNER | Tracking partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_TRACK_PARTNER | Allow NULL? |
| 11 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 12 | INT_BRANCH | Manufacturer/ supplier's code for reseller unit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_INTBRANCH | Allow NULL? |
| 13 | BRANCH | Distributor/ reseller's code for reseller unit | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_BRANCH | Allow NULL? |
| 14 | SD_CUS_REF_FLD | Ship-and-debit claim reference number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_SDCUSREF | Allow NULL? |
| 15 | CUS_REF_FLD | Ship-and-debit claim reference number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_SDCUSREF | Allow NULL? |
| 16 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 17 | DIST_CHNL | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VTWEG | Allow NULL? |
| 18 | DIVISION | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART | Allow NULL? |
| 19 | MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_MSDRIND | Allow NULL? |
| 20 | END_CUST | DRM end customer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_ENDCST | Allow NULL? |
| 21 | DR_END_CUST | Resale customer as reported by distributor/ reseller | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_DRENDCST | Allow NULL? |
| 22 | EXT_REFNO | Resale customer external reference number | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_EXT_CUST_REFNO | Allow NULL? |
| 23 | LS_EC_INV | Logical System of Resale Invoice | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_LS_ECINV | Allow NULL? |
| 24 | ECRQTY | Change in resale return quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_ECRETQTY | |
| 25 | EC_INV_NO | End customer invoice number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_ECINVDOC | Allow NULL? |
| 26 | EC_INV_ITM | Resale invoice item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /SAPHT/DRM_ECINVITM | Allow NULL? |
| 27 | EC_INV_DT | Resale invoice date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_ECINVDATE | Allow NULL? |
| 28 | EC_SHP_DT | Resale shipping date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_ECSHPDATE | Allow NULL? |
| 29 | LS_SD_AGR | Logical system of ship & debit agreement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_LS_SDAGR | Allow NULL? |
| 30 | SD_AGR_NO | Ship-and-debit agreement number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_SDAGRNO | Allow NULL? |
| 31 | SD_AGR_ITM | Ship-and-debit agreement item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /SAPHT/DRM_SDAGRITM | Allow NULL? |
| 32 | SD_AGR_TYP | Ship-and-debit agreement type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_SDAGRTYP | Allow NULL? |
| 33 | AGR_CAL_TYP | Ship-and-debit claim amount calculation type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_SDAGR_CAL | Allow NULL? |
| 34 | SD_AGR_RATE | Ship-and-debit agreement rate | decimal | 11 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_SDAGRRATE | |
| 35 | SD_AGR_CURR | Ship-and-debit agreement rate currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPHT/DRM_SDAGRCURR | Allow NULL? |
| 36 | PRIC_UNIT | Ship-and-debit agreement pricing unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_AGR_PRC_UNIT | |
| 37 | SD_AGR_CON_NUM | Numerator for coversion to base unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_AGR_COND_NUMER | |
| 38 | SD_AGR_CON_DEN | Denominator for conversion to base unit of material | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_AGR_COND_DENOM | |
| 39 | SD_AGR_UOM | Unit of measure for SD Agreement | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /SAPHT/DRM_SDAGRCUOM | Allow NULL? |
| 40 | SD_COST | DRM lot cost price for resold material | decimal | 11 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_SDINVCOST | |
| 41 | SD_COST_CURR | Inventory cost currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPHT/DRM_SDINVCURR | Allow NULL? |
| 42 | SD_COST_PRC_UNIT | Inventory cost pricing quantity | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_SDINVUNIT | |
| 43 | SD_COST_PRC_UOM | Unit of measure for pricing quantity in inventory cost | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /SAPHT/DRM_INVUOM | Allow NULL? |
| 44 | SD_INV_DOCQTY | Ship-and-debit invoice document quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_SD_INVDOCQTY | |
| 45 | SD_INV_DOCAMT | Amount paid out as ship-and-debit claim | decimal | 15 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_SD_INVDOCAMT | |
| 46 | SD_INV_DOCCURR | Currency for ship-and-debit amount in credit/ debit memo | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPHT/DRM_SD_INVDOCCURR | Allow NULL? |
| 47 | CALC_CLAIM_QTY | Calculated bill-up claim quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_CALCCLAIMQTY | |
| 48 | CALC_CLAIM_AMT | Calculated claim amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_CALCCLAIMAMT | |
| 49 | CALC_CLAIM_CUR | Currency for calculated claim amount | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPHT/DRM_CALCCLAIMCUR | Allow NULL? |
| 50 | BU_SLS_DOCQTY | Bill up claim quantity in credit/ debit memo request | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_BU_SLSDOCQTY | |
| 51 | BU_SLS_DOCAMT | Bill up claim amount in credit/debit memo request | decimal | 15 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_BU_SLSDOCAMT | |
| 52 | BU_SLS_DOCCURR | Currency of bill-up claim amount in Cr/ Dr memo request | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPHT/DRM_BU_SLSDOCCURR | Allow NULL? |
| 53 | BU_INV_DOCQTY | Bill-up claim quantity in credit/ debit memo | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_BU_INVDOCQTY | |
| 54 | BU_INV_DOCAMT | Bill-up claim amount in credit/ debit memo | decimal | 15 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_BU_INVDOCAMT | |
| 55 | BU_INV_DOCCURR | Bill-up credit/ debit memo amount currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPHT/DRM_BU_INVDOCCURR | Allow NULL? |
| 56 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 57 | LS_SLS_DOC | Logical System of credit/ debit memo request document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_LS_SLSDOC | Allow NULL? |
| 58 | BU_SLS_DOCNO | Credit/ debit memo request number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_SLSDOC_NO | Allow NULL? |
| 59 | BU_SLS_DOCITM | Credit/ debit memo request item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /SAPHT/DRM_SLSDOC_ITM | Allow NULL? |
| 60 | ABGRU | Reason for rejection of quotations and sales orders | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABGRU_VA | Allow NULL? |
| 61 | COLL_RUN_NO | DRM collective processing number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRMCOLLRUNNO | Allow NULL? |
| 62 | GROUP_NO | DRM claim processing group number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRMGROUPNO | Allow NULL? |
| 63 | BU_INV_DOCNO | Credit/ debit memo number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_INVDOC_NO | Allow NULL? |
| 64 | BU_INV_DOCITM | Credit/ debit memo item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /SAPHT/DRM_INVDOC_ITM | Allow NULL? |
| 65 | PROC_STATUS | Bill-up due list item processing status | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_BILLUP_STAT | Allow NULL? |
| 66 | LOGHANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | BALLOGHNDL | Allow NULL? |
| 67 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 68 | CREATED_DT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_CRDATE | Allow NULL? |
| 69 | CREATED_TM | Time created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | C_TIME | Allow NULL? |
| 70 | LASTCHGDBY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UPNAM | Allow NULL? |
| 71 | LASTCHGDDT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 72 | CHANGED_TM | Last changed at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AS4TIME | Allow NULL? |
| 73 | DUMMY_1 | Dummy function in length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | DUMMY | Allow NULL? |
