/SAPHT/DRMBUDL SAP (Bill Up Due List) Table details
Dictionary Type: Table
Description: Bill Up Due List
Description: Bill Up Due List
ABAP Code to SELECT data from /SAPHT/DRMBUDL
Related tables to /SAPHT/DRMBUDL
Access table /SAPHT/DRMBUDL
Related tables to /SAPHT/DRMBUDL
Access table /SAPHT/DRMBUDL
Table field list including key, data, relationships and ABAP select examples
/SAPHT/DRMBUDL is a standard SAP Table which is used to store Bill Up Due List data and is available within R/3 SAP systems depending on the version and release level.
The /SAPHT/DRMBUDL table consists of various fields, each holding specific information or linking keys about Bill Up Due List data available in SAP. These include BILLUPDLDOCNO (Bill-up due list document number), CLAIMDOCNO (Ship-and-debit claim document number), STAGDOCNO (IDOC staging table document number), INT_XMNO (DRM internal transmission number).. 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/DRMBUDL 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 | Assigned to domain | MANDT | |||
| BILLUPDLDOCNO | Bill-up due list document number | /SAPHT/DRM_BILLUP_DL_DOC_NO | CHAR | 10 | ALPHA | BELNR | |||
| CLAIMDOCNO | Ship-and-debit claim document number | /SAPHT/DRM_CLAIMDOCNO | CHAR | 10 | ALPHA | BELNR | |||
| STAGDOCNO | IDOC staging table document number | /SAPHT/DRM_STAGDOCNO | CHAR | 10 | ALPHA | BELNR | |||
| INT_XMNO | DRM internal transmission number | /SAPHT/DRM_INTXMNO | CHAR | 20 | ALPHA | /SAPHT/DRM_INTXMNO | |||
| 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 | ||||
| MSBOOKPARTNO | Manufacturer book part number | /SAPHT/DRM_MSBOOKPARTNO | CHAR | 18 | Assigned to domain | MATN1 | MATNR | /SAPHT/DRM_MSBOOKPRT | MAT1 |
| MATERIAL | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| TRACK_PARTNER | Tracking partner | /SAPHT/DRM_TRACK_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
| INT_BRANCH | Manufacturer/ supplier's code for reseller unit | /SAPHT/DRM_INTBRANCH | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
| BRANCH | Distributor/ reseller's code for reseller unit | /SAPHT/DRM_BRANCH | CHAR | 20 | CHAR20 | ||||
| SD_CUS_REF_FLD | Ship-and-debit claim reference number | /SAPHT/DRM_SDCUSREF | CHAR | 35 | /SAPHT/DRM_SDCUSREF | ||||
| CUS_REF_FLD | Ship-and-debit claim reference number | /SAPHT/DRM_SDCUSREF | CHAR | 35 | /SAPHT/DRM_SDCUSREF | ||||
| SALES_ORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
| DIST_CHNL | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
| DIVISION | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
| MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | /SAPHT/DRM_MSDRIND | CHAR | 1 | /SAPHT/DRM_MSDRIND | ||||
| END_CUST | DRM end customer | /SAPHT/DRM_ENDCST | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | DEBI | |
| DR_END_CUST | Resale customer as reported by distributor/ reseller | /SAPHT/DRM_DRENDCST | CHAR | 20 | CHAR20 | ||||
| EXT_REFNO | Resale customer external reference number | /SAPHT/DRM_EXT_CUST_REFNO | CHAR | 11 | CHAR11 | ||||
| LS_EC_INV | Logical System of Resale Invoice | /SAPHT/DRM_LS_ECINV | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| ECRQTY | Change in resale return quantity | /SAPHT/DRM_ECRETQTY | QUAN | 15(3) | MENG15 | ||||
| EC_INV_NO | End customer invoice number | /SAPHT/DRM_ECINVDOC | CHAR | 20 | CHAR20 | ||||
| EC_INV_ITM | Resale invoice item number | /SAPHT/DRM_ECINVITM | NUMC | 6 | Assigned to domain | POSNR | |||
| EC_INV_DT | Resale invoice date | /SAPHT/DRM_ECINVDATE | DATS | 8 | DATUM | ||||
| EC_SHP_DT | Resale shipping date | /SAPHT/DRM_ECSHPDATE | DATS | 8 | DATS | ||||
| LS_SD_AGR | Logical system of ship & debit agreement | /SAPHT/DRM_LS_SDAGR | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| SD_AGR_NO | Ship-and-debit agreement number | /SAPHT/DRM_SDAGRNO | CHAR | 10 | ALPHA | BELNR | |||
| SD_AGR_ITM | Ship-and-debit agreement item number | /SAPHT/DRM_SDAGRITM | NUMC | 6 | Assigned to domain | POSNR | |||
| SD_AGR_TYP | Ship-and-debit agreement type | /SAPHT/DRM_SDAGRTYP | CHAR | 1 | /SAPHT/DRM_SDAGRTYP | ||||
| AGR_CAL_TYP | Ship-and-debit claim amount calculation type | /SAPHT/DRM_SDAGR_CAL | CHAR | 1 | /SAPHT/DRM_SDAGR_CAL | ||||
| SD_AGR_RATE | Ship-and-debit agreement rate | /SAPHT/DRM_SDAGRRATE | CURR | 11(2) | WERTV6 | ||||
| SD_AGR_CURR | Ship-and-debit agreement rate currency | /SAPHT/DRM_SDAGRCURR | CUKY | 5 | Assigned to domain | WAERS | |||
| PRIC_UNIT | Ship-and-debit agreement pricing unit | /SAPHT/DRM_AGR_PRC_UNIT | DEC | 5 | KPEIN | ||||
| SD_AGR_CON_NUM | Numerator for coversion to base unit | /SAPHT/DRM_AGR_COND_NUMER | DEC | 5 | UMBSZ | ||||
| SD_AGR_CON_DEN | Denominator for conversion to base unit of material | /SAPHT/DRM_AGR_COND_DENOM | DEC | 5 | UMBSN | ||||
| SD_AGR_UOM | Unit of measure for SD Agreement | /SAPHT/DRM_SDAGRCUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| SD_COST | DRM lot cost price for resold material | /SAPHT/DRM_SDINVCOST | CURR | 11(2) | WERTV6 | ||||
| SD_COST_CURR | Inventory cost currency | /SAPHT/DRM_SDINVCURR | CUKY | 5 | Assigned to domain | WAERS | |||
| SD_COST_PRC_UNIT | Inventory cost pricing quantity | /SAPHT/DRM_SDINVUNIT | DEC | 5 | KPEIN | ||||
| SD_COST_PRC_UOM | Unit of measure for pricing quantity in inventory cost | /SAPHT/DRM_INVUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| SD_INV_DOCQTY | Ship-and-debit invoice document quantity | /SAPHT/DRM_SD_INVDOCQTY | QUAN | 15(3) | MENGV15 | ||||
| SD_INV_DOCAMT | Amount paid out as ship-and-debit claim | /SAPHT/DRM_SD_INVDOCAMT | CURR | 15(2) | WERTV8 | ||||
| SD_INV_DOCCURR | Currency for ship-and-debit amount in credit/ debit memo | /SAPHT/DRM_SD_INVDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
| CALC_CLAIM_QTY | Calculated bill-up claim quantity | /SAPHT/DRM_CALCCLAIMQTY | QUAN | 15(3) | MENG15 | ||||
| CALC_CLAIM_AMT | Calculated claim amount | /SAPHT/DRM_CALCCLAIMAMT | CURR | 15(2) | WERTV8 | ||||
| CALC_CLAIM_CUR | Currency for calculated claim amount | /SAPHT/DRM_CALCCLAIMCUR | CUKY | 5 | Assigned to domain | WAERS | |||
| BU_SLS_DOCQTY | Bill up claim quantity in credit/ debit memo request | /SAPHT/DRM_BU_SLSDOCQTY | QUAN | 15(3) | MENGV15 | ||||
| BU_SLS_DOCAMT | Bill up claim amount in credit/debit memo request | /SAPHT/DRM_BU_SLSDOCAMT | CURR | 15(2) | WERTV8 | ||||
| BU_SLS_DOCCURR | Currency of bill-up claim amount in Cr/ Dr memo request | /SAPHT/DRM_BU_SLSDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
| BU_INV_DOCQTY | Bill-up claim quantity in credit/ debit memo | /SAPHT/DRM_BU_INVDOCQTY | QUAN | 15(3) | MENGV15 | ||||
| BU_INV_DOCAMT | Bill-up claim amount in credit/ debit memo | /SAPHT/DRM_BU_INVDOCAMT | CURR | 15(2) | WERTV8 | ||||
| BU_INV_DOCCURR | Bill-up credit/ debit memo amount currency | /SAPHT/DRM_BU_INVDOCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
| QTY_UNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| LS_SLS_DOC | Logical System of credit/ debit memo request document | /SAPHT/DRM_LS_SLSDOC | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| BU_SLS_DOCNO | Credit/ debit memo request number | /SAPHT/DRM_SLSDOC_NO | CHAR | 10 | ALPHA | BELNR | |||
| BU_SLS_DOCITM | Credit/ debit memo request item number | /SAPHT/DRM_SLSDOC_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
| ABGRU | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
| COLL_RUN_NO | DRM collective processing number | /SAPHT/DRMCOLLRUNNO | CHAR | 10 | CHAR10 | ||||
| GROUP_NO | DRM claim processing group number | /SAPHT/DRMGROUPNO | CHAR | 10 | CHAR10 | ||||
| BU_INV_DOCNO | Credit/ debit memo number | /SAPHT/DRM_INVDOC_NO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
| BU_INV_DOCITM | Credit/ debit memo item number | /SAPHT/DRM_INVDOC_ITM | NUMC | 6 | Assigned to domain | POSNR | |||
| PROC_STATUS | Bill-up due list item processing status | /SAPHT/DRM_BILLUP_STAT | CHAR | 1 | /SAPHT/DRM_BILLUP_STAT | ||||
| LOGHANDLE | 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/DRMBUDL using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPHT/DRMBUDL to SELECT all data from the tableDATA: WA_/SAPHT/DRMBUDL TYPE /SAPHT/DRMBUDL.
SELECT SINGLE *
FROM /SAPHT/DRMBUDL
INTO CORRESPONDING FIELDS OF WA_/SAPHT/DRMBUDL
WHERE...
How to access SAP table /SAPHT/DRMBUDL
Within an ECC or HANA version of SAP you can also view further information about /SAPHT/DRMBUDL 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