SAP Table BAPI_DRMR3XN

DRM BAPI Interface : DRM relevant R/3 Transactions

BAPI_DRMR3XN (DRM BAPI Interface : DRM relevant R/3 Transactions) 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_DRMR3XN to other SAP tables.

BAPI_DRMR3XN table fields

Field Data element Checktable Datatype Length Decimals
LS_DOC_NO Logical System of the SAP Transaction Document /SAPHT/DRM_LS_DOC_NO CHAR 10 0
DOC_TYP Transaction Document Type /SAPHT/DRM_DOCTYP CHAR 2 0
GR Goods Receipt
DN Delivery Note
IV Invoice
IR Invoice Receipt
SO Sales Order
PO Purchase Order
PR Goods Receipt from Production Order
PI Goods Issue to Production Order
PP Production order
CR Credit Memo Request
DR Debit Memo Request
CM Credit Memo
DM Debit Memo
RG Goods Receipt Cancellation
IG Goods Issue Cancellation
VI Invoice Cancellation
RI Invoice Receipt Cancellation
GI Goods Issue
DOC_NO Transaction Document Number /SAPHT/DRM_DOCNO CHAR 10 0
DOC_ITM Transaction Document Item Number /SAPHT/DRM_DOCITM NUMC 6 0
DOC_YEAR Transaction Document Year /SAPHT/DRM_DOCYR NUMC 4 0
COMP_CODE Company Code BUKRS CHAR 4 0
REF_DOC_TYP Reference document type /SAPHT/DRM_RFDOCTYP CHAR 2 0
GR Goods Receipt
DN Delivery Note
IV Invoice
IR Invoice Receipt
SO Sales Order
PO Purchase Order
PR Goods Receipt from Production Order
PI Goods Issue to Production Order
PP Production order
CR Credit Memo Request
DR Debit Memo Request
CM Credit Memo
DM Debit Memo
RG Goods Receipt Cancellation
IG Goods Issue Cancellation
VI Invoice Cancellation
RI Invoice Receipt Cancellation
GI Goods Issue
REF_DOC_NO Reference document number /SAPHT/DRM_RFDOCNO CHAR 12 0
REF_DOC_ITM Reference document item number /SAPHT/DRM_RFDOCITM NUMC 6 0
REF_DOC_YEAR Reference document year /SAPHT/DRM_RFDOCYR NUMC 4 0
ABGRU Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
ORDER_NO Order number /SAPHT/DRM_ORDERNO CHAR 12 0
ORDER_ITM Order item /SAPHT/DRM_ORDERITM NUMC 6 0
PO_ORDER_TYPE Purchasing Document Type ESART CHAR 4 0
INV_DOC_TYPE Billing Type FKART CHAR 4 0
MATDOCNO Goods Issue/ Goods receipt number /SAPHT/DRM_MATDOCNO CHAR 10 0
MATDOCITEM Goods Issue/ Goods receipt item number /SAPHT/DRM_MATDCITM NUMC 6 0
MATDOCYR Goods Issue/ Goods receipt document year /SAPHT/DRM_MATDOCYR NUMC 4 0
DS_ORD_NO Drop-ship sales order number /SAPHT/DRM_DS_ORD_NO CHAR 10 0
DS_ORD_ITM Drop-ship sales order item number /SAPHT/DRM_DSORDITM NUMC 6 0
DOC_QTY Document quantity /SAPHT/DRM_DOCQT QUAN 15 3
MATCHED_QTY Matched quantity /SAPHT/DRM_MATQT QUAN 15 3
QTY_UNIT Base Unit of Measure MEINS UNIT 3 0
PRIC_UNIT Pricing unit for price protectable price /SAPHT/DRM_PRCUNIT DEC 5 0
COND_RATE Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
COND_CURR Price protectable price currency /SAPHT/DRM_COND_CURR CUKY 5 0
COND_NUMER Numerator for converting price protectable price /SAPHT/DRM_COND_NUMERATOR DEC 5 0
COND_DENOM Denominator for conversion to base unit /SAPHT/DRM_COND_DENOM DEC 5 0
COND_UOM Pricing unit of measure /SAPHT/DRM_PRIC_UOM UNIT 3 0
DOC_VALUE Condition rate for BAPI interface /SAPHT/DRM_BAPI_RATE DEC 23 4
DOC_VALUE_CURR SD Document Currency WAERK CUKY 5 0
DOC_DATE Document creation date /SAPHT/DRM_DOCDATE DATS 8 0
MSBOOKPARTNO Manufacturer Book Part Number /SAPHT/DRM_MSBOOKPART CHAR 18 0
MATERIAL Material Number MATNR CHAR 18 0
TRACK_PARTNER DRM Tracking partner /SAPHT/DRM_TRKPARTNER CHAR 10 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
LOTTYPE DRM lot type /SAPHT/DRM_LOTTYPE CHAR 1 0
N Normal
B Special Buy
END_CUST DRM end customer /SAPHT/DRM_ENDCST CHAR 10 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
SALES_ORG Sales Organization VKORG CHAR 4 0
DIST_CHNL Distribution Channel VTWEG CHAR 2 0
DIVISION Division SPART CHAR 2 0
PURCH_ORG Purchasing Organization EKORG CHAR 4 0
PLANT Plant WERKS_D CHAR 4 0
PPTYPE Price protection type /SAPHT/DRM_PPTYPE CHAR 1 0
RB_LOTNO Reconciliation bucket lot number /SAPHT/DRM_RBLOTNO CHAR 10 0
CUS_REF_FLD Ship-and-debit claim reference number /SAPHT/DRM_SDCUSREF CHAR 35 0
IND_ATO_MTS Object ID CCOBJID CHAR 1 0
PROD_ORD_NO Order Number AUFNR CHAR 12 0
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
MS_DR_IND Indicates manufacturer/supplier or distributor/reseller lot /SAPHT/DRM_MSDRIND CHAR 1 0
M Manufacturer
D Distributor
PROC_STATUS Status of transactions /SAPHT/DRM_R3STATUS CHAR 1 0
U Unprocessed by DRM
P Processed by DRM
E Errored
C Cancelled
LOGHANDLE Application Log: Log Handle BALLOGHNDL CHAR 22 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
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