SAP Table /SAPHT/DRMCONEXT - DRM Ship and debit agreement extracts

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
LS_SD_AGR X /SAPHT/DRM_LS_SDAGR CHAR 3 10 0 Logical system of ship & debit agreement
SD_AGR_NO X /SAPHT/DRM_SDAGRNO CHAR 13 10 0 Ship-and-debit agreement number
SD_AGR_ITM X /SAPHT/DRM_SDAGRITM NUMC 23 6 0 Ship-and-debit agreement item number
TRACK_PARTNER /SAPHT/DRM_TRACK_PARTNER CHAR 29 10 0 Tracking partner
SOLD_TO_PARTY KUNNR CHAR 39 10 0 KNA1 Customer Number
MSBOOKPARTNO /SAPHT/DRM_MSBOOKPARTNO CHAR 49 18 0 MARA Manufacturer book part number
MATERIAL MATNR CHAR 67 18 0 MARA Material Number
SD_AGR_TYP /SAPHT/DRM_SDAGRTYP CHAR 85 1 0 Ship-and-debit agreement type
AGR_STATUS /SAPHT/DRM_AGRSTATUS CHAR 86 1 0 DRM Ship and Debit agreement status
AGR_CAL_TYP /SAPHT/DRM_SDAGR_CAL CHAR 87 1 0 Ship-and-debit claim amount calculation type
BRANCH_FLAG CHAR1 CHAR 88 1 0 Single-Character Indicator
COND_RATE /SAPHT/DRM_COND_RATE CURR 89 11 2 Price protectable price condition rate
COND_CURR /SAPHT/DRM_COND_CURR CUKY 95 5 0 TCURC Price protectable price currency
COND_NUMER /SAPHT/DRM_COND_NUMERATOR DEC 100 5 0 Numerator for converting price protectable price
COND_DENOM /SAPHT/DRM_COND_DENOM DEC 103 5 0 Denominator for conversion to base unit
COND_UOM /SAPHT/DRM_PRIC_UOM UNIT 106 3 0 T006 Pricing unit of measure
COND_PRIC_UNIT /SAPHT/DRM_PRCUNIT DEC 109 5 0 Pricing unit for price protectable price
RESALEPRC /SAPHT/DRM_RESPRC CURR 112 11 2 Resale price
RESALECURR /SAPHT/DRM_RESCURR CUKY 118 5 0 TCURC Resale price currency
RESALENUMER /SAPHT/DRM_RESNUMER DEC 123 5 0 Numerator for converting resale price
RESALEDENOM /SAPHT/DRM_RESDENOM DEC 126 5 0 Denominator for conversion to base unit
RESALEUOM /SAPHT/DRM_RESUOM UNIT 129 3 0 T006 Pricing unit of measure
RESALE_PRCUNIT /SAPHT/DRM_RES_PRCUNIT DEC 132 5 0 Pricing Unit for Resale price
SD_AGR_RATE /SAPHT/DRM_SDAGRRATE CURR 135 11 2 Ship-and-debit agreement rate
SD_AGR_CURR /SAPHT/DRM_SDAGRCURR CUKY 141 5 0 TCURC Ship-and-debit agreement rate currency
PRIC_UNIT /SAPHT/DRM_AGR_PRC_UNIT DEC 146 5 0 Ship-and-debit agreement pricing unit
AGR_CON_NUM /SAPHT/DRM_AGR_COND_NUMER DEC 149 5 0 Numerator for coversion to base unit
AGR_CON_DEN /SAPHT/DRM_AGR_COND_DENOM DEC 152 5 0 Denominator for conversion to base unit of material
SD_AGR_UOM /SAPHT/DRM_SDAGRCUOM UNIT 155 3 0 T006 Unit of measure for SD Agreement
END_CUST /SAPHT/DRM_ENDCST CHAR 158 10 0 DRM end customer
TOT_AGR_QTY KWMENG QUAN 168 15 3 Cumulative Order Quantity in Sales Units
CALLED_OFF_QTY KWMENG QUAN 176 15 3 Cumulative Order Quantity in Sales Units
QTY_UNIT MEINS UNIT 184 3 0 T006 Base Unit of Measure
AGR_VALID_FR GUEBG DATS 187 8 0 Valid-from date (outline agreements, product proposals)
AGR_VALID_TO GUEEN DATS 195 8 0 Valid-to date (outline agreements, product proposals)
BOOKING_FR /SAPHT/DRM_BOOK_FROM DATS 203 8 0 Booking Date- From
BOOKING_TO /SAPHT/DRM_BOOK_TO DATS 211 8 0 Booking Date - To
SHIPPING_FR /SAPHT/DRM_SHIP_FROM DATS 219 8 0 Shipping Date - From
SHIPPING_TO /SAPHT/DRM_SHIP_TO DATS 227 8 0 Shipping Date - To
BILLING_FR /SAPHT/DRM_BILL_FROM DATS 235 8 0 Billing Date - From
BILLING_TO /SAPHT/DRM_BILL_TO DATS 243 8 0 Billing Date - To
EXERCISE_FR /SAPHT/DRM_EXER_FROM DATS 251 8 0 Exercise Date -To
EXERCISE_TO /SAPHT/DRM_EXER_TO DATS 259 8 0 Exercise Date - From
DESIGN_REG_NO /SAPHT/DRM_DESIGN_REG_NO CHAR 267 30 0 Design registration number
STSMA J_STSMA CHAR 297 8 0 Status Profile
ESTAT J_ESTAT CHAR 305 5 0 User Status
CREATED_BY ERNAM CHAR 310 12 0 Name of Person who Created the Object
CREATED_DT /SAPHT/DRM_CRDATE DATS 322 8 0 Created on
CREATED_TM C_TIME TIMS 330 6 0 Time created
LASTCHGDBY UPNAM CHAR 336 12 0 Last Changed By
LASTCHGDDT AEDAT DATS 348 8 0 Changed On
CHANGED_TM AS4TIME TIMS 356 6 0 Last changed at