DRE_DELIVERY_ITEM SAP (Delivery Item) Structure details

Dictionary Type: Structure
Description: Delivery Item




ABAP Code to SELECT data from DRE_DELIVERY_ITEM
Related tables to DRE_DELIVERY_ITEM
Access table DRE_DELIVERY_ITEM




Structure field list including key, data, relationships and ABAP select examples

DRE_DELIVERY_ITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Delivery Item" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DRE_DELIVERY_ITEM TYPE DRE_DELIVERY_ITEM.

The DRE_DELIVERY_ITEM table consists of various fields, each holding specific information or linking keys about Delivery Item data available in SAP. These include MANDT (Client), VBELN (Delivery), POSNR (Delivery Item), PSTYV (Delivery item category).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP DRE_DELIVERY_ITEM structure 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
VBELNDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
POSNRDelivery Item POSNR_VLNUMC6Assigned to domainPOSNR
PSTYVDelivery item category PSTYV_VLCHAR4Assigned to domainPSTYV
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERZETEntry time ERZETTIMS6UZEIT
ERDATDate on Which Record Was Created ERDATDATS8DATUM
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MATWAMaterial entered MATWACHAR18Assigned to domainMATN1MATNRMAT
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
LICHNVendor Batch Number LICHNCHAR15LICHN
KDMATMaterial belonging to the customer KDMATCHAR35IDNEX
PRODHProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
LFIMGActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
UMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
NTGEWNet weight NTGEW_15QUAN15(3) MENG15
BRGEWGross weight BRGEW_15QUAN15(3) MENG15
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
VOLUMVolume VOLUM_15QUAN15(3) MENG15
VOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
KZTLFPartial delivery at item level KZTLFCHAR1KZTLF
UEBTKIndicator: Unlimited Overdelivery Allowed UEBTKCHAR1XFELD
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
CHSPLBatch split allowed CHSPLCHAR1XFELD
FAKSPBlock FAKSPCHAR2Assigned to domainFAKSP
MBDATMaterial Staging/Availability Date MBDATDATS8DATUM
LGMNGActual quantity delivered in stockkeeping units LGMNGQUAN13(3) MENG13
ARKTXShort text for sales order item ARKTXCHAR40TEXT40
LGPBEStorage Bin LGPBECHAR10CHAR10
VBELVOriginating document VBELVCHAR10Assigned to domainALPHAVBELN
POSNVOriginating item POSNVNUMC6Assigned to domainPOSNR
VBTYVSD document category VBTYPCHAR1VBTYP
VGSYSLogical System in the Preceding Document VGLOGSYSCHAR10Assigned to domainALPHALOGSYS
VGBELDocument number of the reference document VGBELCHAR10Assigned to domainALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6Assigned to domainPOSNR
UPFLUUpdate indicator for delivery document flow UPFLLCHAR1UPFLL
UEPOSHigher-level item in bill of material structures UEPOSNUMC6Assigned to domainPOSNR
FKRELRelevant for Billing FKRELCHAR1FKREL
LADGRLoading Group LADGRCHAR4Assigned to domainLADGR
TRAGRTransportation Group TRAGRCHAR4Assigned to domainTRAGR
KOMKZIndicator for picking control KOMKZCHAR1KOMKZ
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3Assigned to domainLGNUMLGN
LISPLSplit to warehouse number required LNSPL_LIPSCHAR1LNSPL_LIPS
LGTYPStorage Type LGTYPCHAR3Assigned to domainLGTYPLGTH_T301
LGPLAStorage Bin LGPLACHAR10Assigned to domainLGPLALGPLAG1
BWTEXIndicator: Separate valuation BWTEXCHAR1XFELD
BWARTMovement Type (Inventory Management) BWARTCHAR3Assigned to domainBWARTBWA
BWLVSMovement Type for Warehouse Management BWLVSNUMC3Assigned to domainBWLVSBWL
KZDLGIndicator: dynamic storage bin in warehouse management LVS_KZDLGCHAR1XFELD
BDARTRequirement type BDARTCHAR2BDARTBDA
PLARTPlanning type PLARTCHAR1Assigned to domainPLART
MTARTMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
XCHPFBatch management requirement indicator XCHPFCHAR1XFELD
XCHARBatch management indicator (internal) XCHARCHAR1XFELD
VGREFPreceding document has resulted from reference VGREFCHAR1XFELD
POSARItem type POSARCHAR1POSAR
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
SUMBDSumming up of requirements SUMBDCHAR1SUMBD
MTVFPChecking Group for Availability Check MTVFPCHAR2Assigned to domainMTVFP
EANNREuropean Article Number (EAN) - obsolete!!!!! EANNRCHAR13CHAR13EAN
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
VKBURSales Office VKBURCHAR4Assigned to domainVKBURVKB
VKGRPSales Group VKGRPCHAR3Assigned to domainVKGRPVKG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
GRKORDelivery group (items are delivered together) GRKORNUMC3GRKOR
FMENGQuantity is Fixed FMENGCHAR1XFELD
ANTLFMaximum Number of Partial Deliveries Allowed Per Item ANTLFDEC1ANTLF
VBEAFFixed shipping processing time in days (= setup time) VBEAFDEC5(2) DEC3_2
VBEAVVariable shipping processing time in days VBEAVDEC5(2) DEC3_2
STAFOUpdate group for statistics update STAFOCHAR6Assigned to domainALPHASTAFOMCF
WAVWRCost in document currency WAVWRCURR13(2) WERTV7
KZWI1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KZWI2Subtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
KZWI3Subtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
KZWI4Subtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
KZWI5Subtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
KZWI6Subtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
AEDATChanged On AEDATDATS8DATUM
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
KVGR1Customer group 1 KVGR1CHAR3Assigned to domainKVGR1
KVGR2Customer group 2 KVGR2CHAR3Assigned to domainKVGR2
KVGR3Customer group 3 KVGR3CHAR3Assigned to domainKVGR3
KVGR4Customer group 4 KVGR4CHAR3Assigned to domainKVGR4
KVGR5Customer group 5 KVGR5CHAR3Assigned to domainKVGR5
MVGR1Material group 1 MVGR1CHAR3Assigned to domainMVGR1
MVGR2Material group 2 MVGR2CHAR3Assigned to domainMVGR2
MVGR3Material group 3 MVGR3CHAR3Assigned to domainMVGR3
MVGR4Material group 4 MVGR4CHAR3Assigned to domainMVGR4
MVGR5Material group 5 MVGR5CHAR3Assigned to domainMVGR5
VPZUOAllocation Indicator VPZUOCHAR1ZUVKZ
VGTYPSD document category VBTYPCHAR1VBTYP
RFVGTYPType of preceding document in central system RFVGTYPCHAR1VBTYP
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
POSNR_PPOrder Item Number CO_POSNRNUMC4CO_POSNR
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
VPMATPlanning material VPMATCHAR18Assigned to domainMATN1MATNR
VPWRKPlanning plant VPWRKCHAR4Assigned to domainWERKS
PRBMEBase unit of measure for product group PRBMEUNIT3Assigned to domainCUNITMEINS
UMREFConversion factor: quantities UMREFFFLTP16(16) FLTP
KNTTPAccount Assignment Category KNTTPCHAR1Assigned to domainKNTTPKNT
KZVBRConsumption Posting KZVBRCHAR1KZVBR
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
PCKPFPacking control PCKPFCHAR1PCKPF
BEDAR_LFRequirements class BEDARCHAR3Assigned to domainBEDAR
CMPNTID: Item with active credit function / relevant for credit CMPNTCHAR1XFELD
KCMENGCumulative batch quantity of all split items (in StckUnit) KCMENGQUAN15(3) MENG15
KCBRGEWCumulative gross weight of all batch split items KCBRGEWQUAN15(3) MENG15
KCNTGEWCumulative net weight of all batch split items KCNTGEWQUAN15(3) MENG15
KCVOLUMCumulative volume of all batch split items KCVOLUMQUAN15(3) MENG15
UECHAHigher-Level Item of Batch Split Item UECHANUMC6Assigned to domainPOSNR
CUOBJConfiguration CUOBJ_VANUMC18CUOBJ
CUOBJ_CHInternal object number of the batch classification CUOBJ_CHNUMC18CUOBJ
ANZSNNumber of serial numbers ANZSNINT410INT4
SERAILSerial Number Profile SERAILCHAR4Assigned to domainSERAIL
KCGEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
KCVOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
SERNRBOM explosion number SERNRCHAR8Assigned to domainSERNR
ABRLIInternal delivery schedule number ABRLINUMC4Assigned to domainABRLI
ABARTRelease type ABARTCHAR1ABART
ABRVWUsage Indicator ABRVWCHAR3Assigned to domainABRVW
QPLOSInspection Lot Number QPLOSNUMC12Assigned to domainQPLOSQLSQALS
QTLOSPartial lot number QTLOSNUMC6Assigned to domainQTLOSQTL
NACHLCustomer has not posted goods receipt NACHLCHAR1XFELD
MAGRVMaterial Group: Packaging Materials MAGRVCHAR4Assigned to domainMAGRV
OBJKOObject number at header level OBJKOCHAR22Assigned to domainJ_OBJNR
OBJPOObject number at item level OBJPOCHAR22Assigned to domainJ_OBJNR
AESKDCustomer Engineering Change Status AESKDCHAR17AESKD
SHKZGReturns Item SHKZG_VACHAR1XFELD
PROSAID for material determination PROSACHAR1PROSA
UEPVWID for higher-level item usage UEPVWCHAR1UEPVW
EMPSTReceiving point EMPSTCHAR25TEXT25
ABTNRDepartment number ABTNRCHAR4Assigned to domainABTNR
KOQUIPicking is subject to confirmation KOQUICHAR1XFELD
STADATStatistics date STADATDATS8DATUM
AKTNRCOUPON WAKTIONCHAR10Assigned to domainALPHAWAKTIONWAK
KNUMH_CHNumber of condition record from batch determination KNUMH_CHCHAR10KNUMB
PREFEPreference indicator in export/import PREFECHAR1PREFE
EXARTBusiness Transaction Type for Foreign Trade EXARTCHAR2Assigned to domainEXARTEXA
CLINTInternal Class Number CLINTNUMC10Assigned to domainCLINT
CHMVSBatches: Exit to quantity proposal CHMVSNUMC3NUM3
ABELNAllocation Table Number ABELNCHAR10Assigned to domainALPHAABELNABE
ABELPItem number of allocation table ABELPNUMC5Assigned to domainABELP
LFIMG_FLOInternal field/ Do not use / LFIMG in float / MUM LFIMG_FLOFLTP16(16) FLTP
LGMNG_FLOInternal field/ Do not use / LGMNG in float / MUM LGMNG_FLOFLTP16(16) FLTP
KCMENG_FLOInternal field/ Do not use / KCMENG in float / MUM KCMENG_FLOFLTP16(16) FLTP
KZUMWEnvironmentally Relevant KZUMWCHAR1XFELD
KMPMGComponent quantity KMPMGQUAN13(3) MENGV13
AURELRelevant to Allocation Table AURELCHAR1AUREL
KPEINCondition pricing unit KPEINDEC5KPEIN
KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
NETPRNet price NETPRCURR11(2) WERTV6
NETWRNet Value in Document Currency NETWRCURR15(2) WERTV8
KOWRRStatistical values KOWRRCHAR1KOWRR
KZBEWMovement Indicator KZBEWCHAR1KZBEW
MFRGRMaterial freight group MFRGRCHAR8Assigned to domainMFRGR
CHHPVPack accumulated batches / movement type item CHHPVCHAR1XFELD
ABFORForm of payment guarantee ABSFORM_CMCHAR2ABSFORM_CM
ABGESGuaranteed (factor between 0 and 1) ABGES_CMFLTP16(16) FLTP
MBUHRMaterial Staging Time (Local, Relating to a Plant) MBUHRTIMS6TIME_PLANT
WKTNRValue contract no. WKTNRCHAR10Assigned to domainALPHAVBELN
WKTPSValue contract item WKTPSNUMC6Assigned to domainPOSNR
J_1BCFOPCFOP Code and Extension J_1BCFOPCHAR10Assigned to domainCFOBRJ_1BCFOP
J_1BTAXLW1Tax law: ICMS J_1BTAXLW1CHAR3Assigned to domainALPHAJ_1BTAXLW1
J_1BTAXLW2Tax law: IPI J_1BTAXLW2CHAR3Assigned to domainALPHAJ_1BTAXLW2
J_1BTXSDCSD tax code J_1BTXSDC_CHAR2Assigned to domainJ_1BTXSDC
SITUAIndicator for situation SITUACHAR2Assigned to domainSITUA
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
RSARTRecord type RSARTCHAR1RSART
KANNRKANBAN/sequence number KANNRCHAR35CHAR35
KZFMEID: Leading unit of measure for completing a transaction KZFMECHAR1KZFME
PROFLDangerous Goods Indicator Profile ADGE_PROFLCHAR3Assigned to domainADGD_PROFL
KCMENGVMECumulative batch quantity of all split items in sales units KCMENG_VMEQUAN15(3) MENGV15_3
KCMENGVMEFCumulated batch split quantity in VRKME and float KCMENGVMEFFLTP16(16) FLTP
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
PSPNRProject definition (internal) PS_INTNRNUMC8Assigned to domainKONPDPS_PSPNR
EPRIOWithdrawal sequence group for stocks EPRIOCHAR4Assigned to domainEPRIO
RULESStock determination rule BF_RULESCHAR4Assigned to domainBF_RULES
KZBEFIndicator Inventory Management active LVS_KZBEFCHAR1XFELD
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
EMATNMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18Assigned to domainMATN1MATNRHTN
LGBZOStaging Area for Warehouse Complex LGBZOCHAR10Assigned to domainLGBZO
HANDLEWorldwide unique key for LIPS-VBELN & LIPS_POSNR TSEGGUID_LIPSCHAR22SYSUUID_22
VERURPOSDistribution delivery: Original item VERURPOSNUMC6Assigned to domainPOSNR
LIFEXPOSExternal item number LIFEXPOSNUMC6Assigned to domainPOSNR
NOATPIndicator: deactivate availability check NO_ATP_CHECKCHAR1NO_ATP_CHECK
NOPCKIndicator: not relevant for picking NO_PICKINGCHAR1XFELD
RBLVSReference movement type for WM from material movements RBLVSNUMC3LVS_BWREF
BERIDMRP Area BERIDCHAR10Assigned to domainBERIDBERID
BESTQStock Category in the Warehouse Management System BESTQCHAR1BESTQ
UMBSQStock Category in the Warehouse Management System BESTQCHAR1BESTQ
UMMATReceiving/Issuing Material UMMATCHAR18Assigned to domainMATN1MATNR
UMWRKReceiving/Issuing Plant UMWRKCHAR4Assigned to domainWERKS
UMLGOReceiving/Issuing Storage Location UMLGOCHAR4Assigned to domainLGORT
UMCHAReceiving/Issuing Batch UMCHACHAR10Assigned to domainCHARG
UMBARValuation Type of Transfer Batch UMBARCHAR10Assigned to domainBWTAR
UMSOKSpecial Stock Indicator for Physical Stock Transfer UMSOKCHAR1Assigned to domainSOBKZ
SONUMSpecial Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
USONUSpecial Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
AKKURExchange rate for letter-of-credit procg in foreign trade AKKURDEC9(5) KURRF
AKMNGCurrent Qty Field for Arithmetic Operations in Doc.Process. AKMNGCHAR1AKMNG
VKGRURepair Processing: Classification of Items VKGRUCHAR3Assigned to domainRMA_VORGARMA_VORGA
SHKZG_UMIndicator: UNMAT in main posting SHKZG_UMCHAR1SHKZG_UM
INSMKStock Type MB_INSMKCHAR1MB_INSMK
KZECHDetermination of batch entry in the production/process order KZECHCHAR1KZECH
FLGWMIndicator: Copy dest. storage data from preceding document FLGWMCHAR1FLGWM
BERKZMaterial Staging Indicator for Production Supply BERKZCHAR1LVS_BERKZ
HUPOSIndicator: Delivery item is a HU item HUPOSCHAR1HUPOS
NOWABIndicator: Item Not Relevant for Goods Movements NOWABCHAR1NOWAB
KONTOG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
KZEARFinal Issue for This Reservation KZEARCHAR1XFELD
HSDATDate of Manufacture HSDATDATS8DATUM
VFDATShelf Life Expiration or Best-Before Date VFDATDATS8DATUM
LFGJAFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
LFBNRDocument No. of a Reference Document LFBNRCHAR10ALPHABELNR
LFPOSItem of a Reference Document LFPOSNUMC4MBLPO
GRUNDReason for goods movment MB_GRUNDNUMC4NUMC4
FOBWASubsequent movement type FOBWACHAR3Assigned to domainBWART
DLVTPDelivery Category DLVTPCHAR2DLVTP
EXBWRExternally Entered Posting Amount in Local Currency EXBWRCURR13(2) WERT7
BPMNGQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
EXVKWExternally Entered Sales Value in Local Currency EXVKWCURR13(2) WERT7
CMPRE_FLTItem credit price CMPRE_FLTFLTP16(16) FLTP
KZPODPOD indicator (relevance, verification, confirmation) KZPODCHAR1KZPOD
LFDEZNot relevant for distribution for WMS LFDEZCHAR1LFDEZ
UMREVConversion Factor of Delivery Quantity VRKME for MEINS LE_UMREVFLTP16(16) FLTP
PODRELPOD Control (Proof of Delivery) PODRELCHAR1PODREL
KZUMLStock transfer/transfer posting KZUMLCHAR1XFELD
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
KZWSOUnits of measure usage KZWSOCHAR1KZWSO
GMCONTROLGoods Movement Control GMCONTROLCHAR1GMCONTROL
POSTING_CHANGEGoods Movement Control: HU POSTING_CHANGECHAR1POSTING_CHANGE
UM_PS_PSP_PNRReceiving/Issuing (WBS Element) UM_PS_PSP_PNRNUMC8Assigned to domainABPSPPS_POSNR
PRE_VL_ETENSSequential Number of Vendor Confirmation ETENSNUMC4NUM04
SPE_GEN_ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
SPE_SCRAP_INDScrap Indicator for EWM Processing /SPE/DELIVERY_SCRAP_INDCHAR1/SPE/DELIVERY_SCRAP_IND
SPE_AUTH_NUMBERReturn Material Authorization Number /SPE/RET_RMACHAR20ALPHA/SPE/RET_RMA
SPE_INSPOUT_GUIDInspections: Inspection outcome GUID set by EWM /SPE/INSP_OUT_GUID_16RAW16/SPE/RET_GUID16
SPE_FOLLOW_UPDefault Follow-Up Activity Code /SPE/RET_FOLLOW_UPCHAR4/SPE/RET_FOLLOW_UP
SPE_EXP_DATE_EXTEnd date of validity period of returns delivery /SPE/RET_EXPIRY_DATE_EXTDEC15TZNTSTMPS
SPE_EXP_DATE_INTEnd date of internal validity period of returns delivery /SPE/RET_EXPIRY_DATE_INTDEC15TZNTSTMPS
SPE_AUTH_COMPLETRMA completion indicator /SPE/RET_RMA_COMPLETEDCHAR1/SPE/RET_RMA_COMPLETED
ORMNGOriginal Quantity of Delivery Item ORMNG_VLQUAN13(3) MENG13
SPE_ATP_TMSTMPATP Time Stamp /SPE/DE_ATP_TIMESTAMPDEC15TZNTSTMPS
SPE_ORIG_SYSOriginal System Type /SPE/INB_ORIGIN_SYSCHAR1/SPE/SYSTYPE_SHORT
SPE_LIEFFZCumulative Qty for SchedAgr - Vendor's Point of View /SPE/LIEFFZQUAN15(3) MENG15
SPE_IMWRKInbound Delivery item has Status 'In Plant' /SPE/IMWRK_ITEMCHAR1XFELD
SPE_LIFEXPOS2External item identifier /SPE/DE_EXT_IDENTCHAR35CHAR35
SPE_EXCEPT_CODEException Code Warehouse for Quantity Difference /SPE/INB_EXCEPT_CODE_WMCHAR4/SPE/EXCEPT_CODE_WM
SPE_KEEP_QTYRetention Quantity for Scrap. Process in EWM /SPE/KEEP_QUANTITYQUAN13(3) MENG13
SPE_ALTERNATEAlternate Product Number /SPE/DE_ALTERNATE_PART_NRCHAR40/SPE/DE_ALTERNATE_PART_NR
SPE_MAT_SUBSTReason for material substitution /SPE/MAT_SUBSTCHAR1/SPE/MAT_SUBST
SPE_STRUCStructure of Items That Are Delivered Together /SPE/STRUCNUMC3
SPE_EXP_DATE_EXT_BBegin date of validity period of returns delivery /SPE/RET_EXPIRY_DATE_EXT_BDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP structure DRE_DELIVERY_ITEM using ABAP code?

As DRE_DELIVERY_ITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DRE_DELIVERY_ITEM as there is no data to select.

How to access SAP table DRE_DELIVERY_ITEM

Within an ECC or HANA version of SAP you can also view further information about DRE_DELIVERY_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!