| 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 | LS_DOC_NO | Logical System of the SAP Transaction Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /SAPHT/DRM_LS_DOC_NO | Allow NULL? |
| 3 | DOC_TYP | Transaction Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | /SAPHT/DRM_DOCTYP | Allow NULL? |
| 4 | DOC_NO | Transaction Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | /SAPHT/DRM_DOCNO | Allow NULL? |
| 5 | DOC_ITM | Transaction Document Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | /SAPHT/DRM_DOCITM | Allow NULL? |
| 6 | DOC_YEAR | Transaction Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | /SAPHT/DRM_DOCYR | Allow NULL? |
| 7 | COMP_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 8 | REF_DOC_TYP | Reference document type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_RFDOCTYP | Allow NULL? |
| 9 | REF_DOC_NO | Reference document number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_RFDOCNO | Allow NULL? |
| 10 | REF_DOC_ITM | Reference document item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /SAPHT/DRM_RFDOCITM | Allow NULL? |
| 11 | REF_DOC_YEAR | Reference document year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /SAPHT/DRM_RFDOCYR | Allow NULL? |
| 12 | ABGRU | Reason for rejection of quotations and sales orders | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABGRU_VA | Allow NULL? |
| 13 | ORDER_NO | Order number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_ORDERNO | Allow NULL? |
| 14 | ORDER_ITM | Order item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /SAPHT/DRM_ORDERITM | Allow NULL? |
| 15 | PO_ORDER_TYPE | Purchasing Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ESART | Allow NULL? |
| 16 | INV_DOC_TYPE | Billing Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FKART | Allow NULL? |
| 17 | MATDOCNO | Goods Issue/ Goods receipt number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_MATDOCNO | Allow NULL? |
| 18 | MATDOCITEM | Goods Issue/ Goods receipt item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | /SAPHT/DRM_MATDCITM | Allow NULL? |
| 19 | MATDOCYR | Goods Issue/ Goods receipt document year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /SAPHT/DRM_MATDOCYR | Allow NULL? |
| 20 | DS_ORD_NO | Drop-ship sales order number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_DS_ORD_NO | Allow NULL? |
| 21 | DS_ORD_ITM | Drop-ship sales order item number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | /SAPHT/DRM_DSORDITM | Allow NULL? |
| 22 | DOC_QTY | Document quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_DOCQT | |
| 23 | MATCHED_QTY | Matched quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | /SAPHT/DRM_MATQT | |
| 24 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 25 | PRIC_UNIT | Pricing unit for price protectable price | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_PRCUNIT | |
| 26 | COND_RATE | Price protectable price condition rate | decimal | 11 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_COND_RATE | |
| 27 | COND_CURR | Price protectable price currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPHT/DRM_COND_CURR | Allow NULL? |
| 28 | COND_NUMER | Numerator for converting price protectable price | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_COND_NUMERATOR | |
| 29 | COND_DENOM | Denominator for conversion to base unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_COND_DENOM | |
| 30 | COND_UOM | Pricing unit of measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /SAPHT/DRM_PRIC_UOM | Allow NULL? |
| 31 | DOC_VALUE | Net value of the order item in document currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | NETWR_AP | |
| 32 | DOC_VALUE_CURR | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERK | Allow NULL? |
| 33 | DOC_DATE | Document creation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_DOCDATE | Allow NULL? |
| 34 | MSBOOKPARTNO | Manufacturer book part number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_MSBOOKPARTNO | Allow NULL? |
| 35 | MATERIAL | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 36 | TRACK_PARTNER | Tracking partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_TRACK_PARTNER | Allow NULL? |
| 37 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 38 | LOTTYPE | DRM lot type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_LOTTYPE | Allow NULL? |
| 39 | END_CUST | DRM end customer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /SAPHT/DRM_ENDCST | Allow NULL? |
| 40 | RESALEPRC | Resale price | decimal | 11 | 2 | CURR | ((0)) | Yes | | /SAPHT/DRM_RESPRC | |
| 41 | RESALECURR | Resale price currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPHT/DRM_RESCURR | Allow NULL? |
| 42 | RESL_PRC_UNIT | Pricing quantity for resale price | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPHT/DRM_RESPRCUNIT | |
| 43 | RESL_PRC_UOM | Unit of measure for pricing quantity | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | /SAPHT/DRM_RESPRCUOM | Allow NULL? |
| 44 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 45 | DIST_CHNL | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWEG | Allow NULL? |
| 46 | DIVISION | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPART | Allow NULL? |
| 47 | PURCH_ORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T024E | EKORG | Allow NULL? |
| 48 | PLANT | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 49 | PPTYPE | Price protection type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_PPTYPE | Allow NULL? |
| 50 | RB_LOTNO | Reconciliation bucket lot number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_RBLOTNO | Allow NULL? |
| 51 | CUS_REF_FLD | Ship-and-debit claim reference number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_SDCUSREF | Allow NULL? |
| 52 | IND_ATO_MTS | Object ID | char | 1 | 0 | CHAR | (N' ') | Yes | | CCOBJID | Allow NULL? |
| 53 | PROD_ORD_NO | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 54 | XN_CODE | DRM relevant transaction code | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | /SAPHT/DRMCXNCD | /SAPHT/DRM_XNCODE | Allow NULL? |
| 55 | PROC_CODE | DRM relevant processing code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_PROCCODE | Allow NULL? |
| 56 | MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_MSDRIND | Allow NULL? |
| 57 | PROC_STATUS | Status of transactions | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPHT/DRM_R3STATUS | Allow NULL? |
| 58 | LOGHANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | BALLOGHNDL | Allow NULL? |
| 59 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 60 | CREATED_DT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPHT/DRM_CRDATE | Allow NULL? |
| 61 | CREATED_TM | Time created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | C_TIME | Allow NULL? |
| 62 | LASTCHGDBY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UPNAM | Allow NULL? |
| 63 | LASTCHGDDT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 64 | CHANGED_TM | Last changed at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AS4TIME | Allow NULL? |
