1. Home
  2. Resources
  3. SAP Tables
  4. BAPI_DRMSDDL - DRM BAPI Interface : DRM SD Due List

SAP Table BAPI_DRMSDDL

DRM BAPI Interface : DRM SD Due List

BAPI_DRMSDDL (DRM BAPI Interface : DRM SD Due List) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BAPI_DRMSDDL to other SAP tables.

BAPI_DRMSDDL table fields

Field Data element Checktable Datatype Length Decimals
CLAIMDOCNO Ship-and-debit claim document number /SAPHT/DRM_CLAIMDOCNO CHAR 10 0
STAGDOCNO IDOC staging table document number /SAPHT/DRM_STAGDOCNO CHAR 10 0
MATCH_RESALENO Matching Resale record for a SDDL record (STAGDOCNO) /SAPHT/DRM_MATCHRESALE CHAR 10 0
INT_XMNO DRM internal transmission number /SAPHT/DRM_INTXMNO CHAR 20 0
TRANSM_NO EDI transmission number /SAPHT/DRM_TRANSMNO CHAR 20 0
EFF_DATE EDI transmission effective date /SAPHT/DRM_EFFDATE DATS 8 0
SALES_ORG Sales Organization VKORG CHAR 4 0
DIST_CHNL Distribution Channel VTWEG CHAR 2 0
DIVISION Division SPART CHAR 2 0
TRANSM_DATE EDI transmission date /SAPHT/DRM_TRANSMDATE DATS 8 0
TRACK_PARTNER Tracking partner /SAPHT/DRM_TRACK_PARTNER CHAR 10 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
MS_DR_IND Indicates manufacturer/supplier or distributor/reseller lot /SAPHT/DRM_MSDRIND CHAR 1 0
M Manufacturer
D Distributor
MSBOOKPARTNO Manufacturer book part number /SAPHT/DRM_MSBOOKPARTNO CHAR 18 0
MATERIAL Material Number MATNR CHAR 18 0
END_CUST DRM end customer /SAPHT/DRM_ENDCST CHAR 10 0
DR_END_CUST Resale customer as reported by distributor/ reseller /SAPHT/DRM_DRENDCST CHAR 20 0
EXT_REFNO Resale customer external reference number /SAPHT/DRM_EXT_CUST_REFNO CHAR 11 0
LS_EC_INV Logical System of Resale Invoice /SAPHT/DRM_LS_ECINV CHAR 10 0
EC_INV_NO End customer invoice number /SAPHT/DRM_ECINVDOC CHAR 20 0
EC_INV_ITM Resale invoice item number /SAPHT/DRM_ECINVITM NUMC 6 0
EC_INV_DT Resale invoice date /SAPHT/DRM_ECINVDATE DATS 8 0
EC_SHP_DT Resale shipping date /SAPHT/DRM_ECSHPDATE DATS 8 0
CLAIM_STATUS Processing Status of ship-and-debit claim /SAPHT/DRM_CLMSTATUS CHAR 1 0
Z Claim Invoice created
Y Claim Request created
N Claim Request Call issued
X Claim Request can be created
Q Error in Claim Amount calculation
S Claim Amount to be calculated
O Claim Approved by Manufacturer
W Claim Rejected by Manufacturer
V Error in Claim document creation
C Cancelled
XN_CODE DRM relevant transaction code /SAPHT/DRM_XNCODE CHAR 20 0
PROC_CODE DRM relevant processing code /SAPHT/DRM_PROCCODE CHAR 2 0
0A Reversal - Sell-in at DR
0B Reversal - DropShip Sellin at DR w backtoback Doc(Reserved)
0C Reversal - Sellthrough at DR
0D Reversal - DropShip Sellthru at DR with backtoback(Reserved)
0F Reversal - DR-MS returns at DR(Reserved)
0G Reversal - Sellin at MS
0H Reversal - Drop-Ship Sellin at MS(Reserved)
0I Reversal - DR-MS returns at MS(Reserved)
0M Reversal - Ship & Debit Claims at MS (Staging)(Reserved)
0N Reversal - Manual Lot Creation/Update(Reserved)
1A Reversal - Compnnt gds iss. to prodctn - assembly (Reserved)
1B Reversal - DropShip Sellin DR w/ot backtoback Doc(Reserved)
1C Reversal - Sellthrough of ATO/MTO item at DR(Reserved)
1D Reversal - DropShip Sellthu DR w/o backtoback(Reserved)
1E Reversal - EC-DR Returns at DR (With EC Inv No)(Reserved)
1J Reversal - Normal Sellthrough at MS
1K Reversal - Normal Drop-Ship Sellthrough at MS (Reserved)
1L Reversal - Normal EC-DR Return DR ( EC Inv first)(Reserved)
1M Reversal - Ship & Debit Claims Audit Trail at MS(Reserved)
1P Reversal - Ship & Debit Claims Audit Trail at DR(Reserved)
1Q Reversal - Price Protection at MS(Reserved)
1R Reversal - Price Protection at DR(Reserved)
1U Reversal - Normal Inv. Reconciliation received at MS(Reserve
1V Reversal - Bill Up Audit Trail at DR(Reserved)
1W Reversal - Bill Up Audit Trail at MS(Reserved)
2A Reversal - Goods receipt of assembly fr production(Reserved)
2C Reversal - Sellthrough of MTS item at DR(Reserved)
2J Reversal - Special Buy Sellthrough at MS
2K Reversal - Special Buy Drop-Ship Sellthrough at MS(Reserved)
2L Reversal - Special Buy EC-DR Ret DR ( EC Inv first)(Reserved
2M Reversal - Ship & Debit Claim Document at MS (Reserved)
2P Reversal - Ship & Debit Claim Document at DR(Reserved)
2Q Reversal - Price Protection document at MS(Reserved)
2R Reversal - Price Protection document at DR(Reserved)
2U Reversal - Spl Buy Inv. Recon received at MS(Reserved)
2V Reversal - Bill Up Claim Document at DR(Reserved)
2W Reversal - Bill Up Claim Document at MS(Reserved)
3E Reversal - EC-DR Returns at DR (W/o EC Inv No)(Reserved)
3U Reversal - Inv. Reconciliation Adjustment at MS(Reserved)
A Sell-in at DR
A1 Components goods issue to production for assembly
A2 Goods receipt of assembly from production
B Drop-Ship Sellin at DR with back-to-back Documents
B1 Drop-Ship Sellin at DR without back-to-back Documents
C Sellthrough at DR
C1 Sellthrough of ATO/MTO item at DR
C2 Sellthrough of MTS item at DR
D Drop-Ship Sellthrough at DR with back-to-back Documents
D1 Drop-Ship Sellthrough at DR without back-to-back Documents
E1 EC-DR Returns at DR (With EC Invoice No ONLY)
E3 EC-DR Returns at DR (Without EC Invoice No)
F DR-MS returns at DR
G Sell-in at MS
G1 Sell-in at MS (billing document only)
H Drop-Ship Sell-in at MS
H1 Drop-Ship Sell-in at MS (billing document only)
I DR-MS returns at MS
IS DR-MS returns (w/o physical receipt) at MS
J1 Normal Sell-through at MS
J2 Special Buy Sell-through at MS
J3 Resale at MS - indistringuishable
K1 Normal Drop-Ship Sell-through at MS
K2 Special Buy Drop-Ship Sell-through at MS
K3 Mnf Drop Ship Sell Thru - Indist.
L1 Normal EC-DR Return at MS (With EC Invoice No first)
L2 Special Buy EC-DR Return at MS (With EC Invoice No first)
L3 EC to DR Return at MS -Indstngsbl
M Ship & Debit Claim at MS (Staging)
M1 Ship & Debit Claim calculation audit trail at MS
M2 Ship & Debit Claim Document audit trail at MS
N Manual Lot Creation/Update at MS
N1 Manual Lot Creation/Update at DR
O1 Ship & Debit Claim Acceptance receipt at DR
O2 Ship & Debit Claim Rejection receipt at DR
P Ship & Debit Claim Report at DR
P1 Ship & Debit Claim calculation Audit Trail at DR
P2 Ship & Debit Claim Document audit trail at DR
Q1 Price Protection claim calculation Audit Trail at MS
Q2 Price Protection Document audit trail at MS
R1 Price Protection claim calculation Audit Trail at DR
R2 Price Protection Document audit trail at DR
U1 Normal Inv. Report receipt for reconciliation at MS
U2 Special Buy Inv. Report receipt for reconciliation at MS
U3 Inv. Reconciliation Adjustment audit trail at MS
V1 Bill Up claim calculation Audit Trail at DR
V2 Bill Up Claim Document audit trail at DR
W1 Bill Up claim calculation Audit Trail at MS
W2 Bill Up Claim Document audit trail at MS
S Samples Claim receipt at MS
S1 Samples Claim calculation Audit Trail at MS
S2 Samples Claim Document audit trail at MS
PA Price Adjustment at MS
RA Re-application for credit, rebill at MS
IA Inventory Adjustment at MS
IB Inter-branch transfer at MS
DT Distributor transfer at MS
ERRORCODE Error Code for storing errors in a record /SAPHT/DRM_ERROR_CODE CHAR 100 0
REROUTEFLAG Reroute flag /SAPHT/DRM_RERTFLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
COST Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
COST_CURR Inventory cost currency /SAPHT/DRM_INVCURR CUKY 5 0
COST_PRC_UNIT Inventory pricing unit /SAPHT/DRM_INVCOSTUNIT DEC 5 0
PRC_UOM Unit of measure for inventory cost pricing quantity /SAPHT/DRM_INVCOSTUOM UNIT 3 0
REP_COST Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
REP_COST_CURR Currency of reported ship-and-debit agreement rate /SAPHT/DRM_REPAGRCURR CUKY 5 0
REP_COS_PRC_UNIT Inventory cost pricing quantity /SAPHT/DRM_SDINVUNIT DEC 5 0
REP_COST_PRC_UOM Unit of measure for pricing quantity in inventory cost /SAPHT/DRM_INVUOM UNIT 3 0
RESALEPRC Resale price /SAPHT/DRM_RESPRC CURR 11 2
RESALECURR Resale price currency /SAPHT/DRM_RESCURR CUKY 5 0
RESL_PRC_UNIT Pricing quantity for resale price /SAPHT/DRM_RESPRCUNIT DEC 5 0
RESL_PRC_UOM Unit of measure for pricing quantity /SAPHT/DRM_RESPRCUOM UNIT 3 0
INT_BRANCH Manufacturer/ supplier's code for reseller unit /SAPHT/DRM_INTBRANCH CHAR 10 0
BRANCH Distributor/ reseller's code for reseller unit /SAPHT/DRM_BRANCH CHAR 20 0
CUS_REF_FLD Ship-and-debit claim reference number /SAPHT/DRM_SDCUSREF CHAR 35 0
REP_AGR_RATE Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
REP_AGR_CURR Currency of reported ship-and-debit agreement rate /SAPHT/DRM_REPAGRCURR CUKY 5 0
REP_PRIC_UNIT Pricing unit for reported ship-and-debit agreement price /SAPHT/DRM_REPPRICUNIT DEC 5 0
REP_PRC_UOM Unit of measure for pricing quantity /SAPHT/DRM_REPPRICUOM UNIT 3 0
LS_SD_AGR Logical system of ship & debit agreement /SAPHT/DRM_LS_SDAGR CHAR 10 0
SD_AGR_NO Ship-and-debit agreement number /SAPHT/DRM_SDAGRNO CHAR 10 0
SD_AGR_ITM Ship-and-debit agreement item number /SAPHT/DRM_SDAGRITM NUMC 6 0
SD_AGR_TYP Ship-and-debit agreement type /SAPHT/DRM_SDAGRTYP CHAR 1 0
B Down By Agreement
T Down To Agreement
AGR_CAL_TYP Ship-and-debit claim amount calculation type /SAPHT/DRM_SDAGR_CAL CHAR 1 0
A Percentage
B Fixed Amount
C Quantity dependent
SD_AGR_RATE Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
SD_AGR_CURR Ship-and-debit agreement rate currency /SAPHT/DRM_SDAGRCURR CUKY 5 0
PRIC_UNIT Ship-and-debit agreement pricing unit /SAPHT/DRM_AGR_PRC_UNIT DEC 5 0
AGR_CON_NUM Numerator for coversion to base unit /SAPHT/DRM_AGR_COND_NUMER DEC 5 0
AGR_CON_DEN Denominator for conversion to base unit of material /SAPHT/DRM_AGR_COND_DENOM DEC 5 0
SD_AGR_UOM Unit of measure for SD Agreement /SAPHT/DRM_SDAGRCUOM UNIT 3 0
REP_CLAIM_QTY Reported claim quantity /SAPHT/DRM_REPCLAIMQTY QUAN 15 3
REP_CLAIM_AMOUNT Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
REP_CLAIM_CURR Reported ship-and-debit claim amount currency /SAPHT/DRM_REPCLAIMCURR CUKY 5 0
CALC_CLAIM_QTY Calculated bill-up claim quantity /SAPHT/DRM_CALCCLAIMQTY QUAN 15 3
CALC_CLAIM_AMT Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
CALC_CLAIM_CUR Currency for calculated claim amount /SAPHT/DRM_CALCCLAIMCUR CUKY 5 0
SD_SLS_DOCQTY Ship and Debit qty in the credit/debit memo request /SAPHT/DRM_SD_SLSDOCQTY QUAN 15 3
SD_SLS_DOCAMT Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
SD_SLS_DOCCURR Currency of the credit/debit memo request amount /SAPHT/DRM_SD_SLSDOCCURR CUKY 5 0
SD_INV_DOCQTY Ship-and-debit invoice document quantity /SAPHT/DRM_SD_INVDOCQTY QUAN 15 3
SD_INV_DOCAMT Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
SD_INV_DOCCURR Currency for ship-and-debit amount in credit/ debit memo /SAPHT/DRM_SD_INVDOCCURR CUKY 5 0
BILLUP_QTY_LEFT Remaining Bill Up Quantity /SAPHT/DRM_BUQTYLEFT QUAN 15 3
QTY_UNIT Base Unit of Measure MEINS UNIT 3 0
SLS_DOCNO Credit/ debit memo request number /SAPHT/DRM_SLSDOC_NO CHAR 10 0
SLS_DOCITM Credit/ debit memo request item number /SAPHT/DRM_SLSDOC_ITM NUMC 6 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
COLL_RUN_NO DRM collective processing number /SAPHT/DRMCOLLRUNNO CHAR 10 0
GROUP_NO DRM claim processing group number /SAPHT/DRMGROUPNO CHAR 10 0
INV_DOCNO Credit/ debit memo number /SAPHT/DRM_INVDOC_NO CHAR 10 0
INV_DOCITM Credit/ debit memo item number /SAPHT/DRM_INVDOC_ITM NUMC 6 0
LOGHANDLE Application Log: Log Handle BALLOGHNDL CHAR 22 0
RES_IDOCNO IDoc number EDI_DOCNUM NUMC 16 0
CREATED_BY Name of Person who Created the Object ERNAM CHAR 12 0
CREATED_DT Created on /SAPHT/DRM_CRDATE DATS 8 0
CREATED_TM Time created C_TIME TIMS 6 0
LASTCHGDBY Last Changed By UPNAM CHAR 12 0
LASTCHGDDT Changed On AEDAT DATS 8 0
CHANGED_TM Last changed at AS4TIME TIMS 6 0
CANCEL_INVNO Credit/ debit memo number /SAPHT/DRM_INVDOC_NO CHAR 10 0
CANCELLED_BY Canceled by /SAPHT/CNNAM CHAR 12 0
CANCELLED_DT Canceled on /SAPHT/CNDAT DATS 8 0
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field MGV_MATERIAL_EXTERNAL CHAR 40 0
MATERIAL_GUID External GUID for MATERIAL Field MGV_MATERIAL_GUID CHAR 32 0
MATERIAL_VERSION Version Number for MATERIAL Field MGV_MATERIAL_VERSION CHAR 10 0
MSBOOKPARTNO_EXTERNAL Long Material Number for MSBOOKPARTNO Field MGV_MSBOOKPARTNO_EXTERNAL CHAR 40 0
MSBOOKPARTNO_GUID External GUID for MSBOOKPARTNO Field MGV_MSBOOKPARTNO_GUID CHAR 32 0
MSBOOKPARTNO_VERSION Version Number for MSBOOKPARTNO Field MGV_MSBOOKPARTNO_VERSION CHAR 10 0