VBDPA SAP (Document Item View for Inquiries,Quotation,Order) Structure details

Dictionary Type: Structure
Description: Document Item View for Inquiries,Quotation,Order




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




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

VBDPA 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 "Document Item View for Inquiries,Quotation,Order" 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_VBDPA TYPE VBDPA.

The VBDPA table consists of various fields, each holding specific information or linking keys about Document Item View for Inquiries,Quotation,Order data available in SAP. These include GRPOS (Item for which this item is an alternative), UEPOS (Higher-level item in bill of material structures), GRKOR (Delivery group (items are delivered together)), POSEX (Item Number of the Underlying Purchase Order).. 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 VBDPA 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
POSNRItem number of the SD document POSNRNUMC6VBUPPOSNR
GRPOSItem for which this item is an alternative GRPOSNUMC6GRPOS
UEPOSHigher-level item in bill of material structures UEPOSNUMC6Assigned to domainPOSNR
GRKORDelivery group (items are delivered together) GRKORNUMC3GRKOR
POSEXItem Number of the Underlying Purchase Order POSEXCHAR6ALPHAPOSEX
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MATWAMaterial entered MATWACHAR18Assigned to domainMATN1MATNRMAT
PMATNPricing Reference Material PMATNCHAR18Assigned to domainMATN1MATNRMAT
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
IDNKDMaterial Number Used by Customer MATNR_KUCHAR35IDNEX
ARKTXShort text for sales order item ARKTXCHAR40TEXT40
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
MATKL_BEZMaterial Group Description WGBEZCHAR20TEXT20
PRODHProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
PRODH_BEZDescription of product hierarchy PRODH_BEZCHAR20TEXT20
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
SPART_BEZDescription of division SPART_BEZCHAR20TEXT20
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
LGOBEDescription of Storage Location LGOBECHAR16TEXT16
VSTELShipping Point/Receiving Point VSTELCHAR4Assigned to domainVSTELVST
VSTEL_BEZDescription of shipping point VSTEL_BEZCHAR30TEXT30
ROUTERoute ROUTECHAR6Assigned to domainROUTE
ROUTE_BEZRoute description ROUTE_BEZCHAR40TEXT40
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PSTYVSales document item category PSTYVCHAR4Assigned to domainPSTYV
PSTYV_BEZDescription of item category PSTYV_BEZCHAR20TEXT20
POSARItem type POSARCHAR1POSAR
HERKLThree-digit character field for IDocs CHAR03CHAR3CHAR3
BRGEWGross Weight of the Item BRGEW_APQUAN15(3) MENG15
NTGEWNet Weight of the Item NTGEW_APQUAN15(3) MENG15
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
VOLUMVolume of the item VOLUM_APQUAN15(3) MENG15
VOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
NETWRNet value of the order item in document currency NETWR_APCURR15(2) WERTV8
WAERKSD Document Currency WAERKCUKY5TCURCWAERSFWS
NETPRNet price NETPRCURR11(2) WERTV6
KPEINCondition pricing unit KPEINDEC5KPEIN
KMEINCondition unit KMEINUNIT3T006CUNITMEINS
LFDATDelivery date LFDAT_EXTCHAR10CHAR10
LSMENGCumulative required delivery qty (all dlv-relev.sched.lines) LSMENGQUAN15(3) MENG15
KWMENGCumulative Order Quantity in Sales Units KWMENGQUAN15(3) MENG15
KBMENGCumulative confirmed quantity in sales unit KBMENGQUAN15(3) MENG15
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
FMENGQuantity is Fixed FMENGCHAR1XFELD
ZMENGTarget quantity in sales units DZMENGQUAN13(3) MENG13
ZIEMETarget quantity UoM DZIEMEUNIT3Assigned to domainCUNITMEINS
ZWERTTarget Value for Outline Agreement in Document Currency DZWERTCURR13(2) WERT7
UMZIZFactor for converting sales units to base units (target qty) UMZIZDEC5UMBSZ
UMZINFactor for converting sales units to base units (target qty) UMZINDEC5UMBSN
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
SMENGScale quantity in base unit of measure SMENGQUAN13(3) MENG13
UEBTKUnlimited overdelivery allowed UEBTK_VCHAR1XFELD
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
VBELN_VANGPreceding sales and distribution document VBELN_VONCHAR10VBUKALPHAVBELNAUF
VBTYP_VANGDocument category of preceding SD document VBTYP_VCHAR1VBTYP
AUDAT_VANGQuotation Date AUDAT_VANGDATS8DATUM
KUNWEShip-to party KUNWECHAR10KNA1ALPHAKUNNR
ANRED_WETitle ANREDCHAR15TEXT15
ADRNR_WEAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
ADRNP_WEPerson number AD_PERSNUMCHAR10Assigned to domainALPHAAD_PERSNUMCDTADDRESS
ADDRESS_TYPE_WEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
NAME1_WEName 1 NAME1_GPCHAR35NAME
NAME2_WEName 2 NAME2_GPCHAR35NAME
NAME3_WEName 3 NAME3_GPCHAR35NAME
NAME4_WEName 4 NAME4_GPCHAR35NAME
STRAS_WEHouse number and street STRAS_GPCHAR35TEXT35
PFACH_WEPO Box PFACHCHAR10PFACH
PFORT_WEPO Box city PFORT_GPCHAR35TEXT35
PSTL2_WEP.O. Box Postal Code PSTL2CHAR10PSTLZ
LAND1_WECountry Key LAND1CHAR3T005LAND1LND
SPRAS_WELanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
PSTLZ_WEPostal Code PSTLZCHAR10PSTLZ
ORT01_WECity ORT01_GPCHAR35TEXT35
ORT02_WEDistrict ORT02_GPCHAR35TEXT35
REGIO_WESTATE (State, Province, County) REGIOCHAR3T005SREGIO
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
KURSK_DATTranslation Date WWERT_DDATS8DATUM
INCO1Incoterms (Part 1) INCO1CHAR3TINCINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
INCO1_BEZIncoterm description INCO1_BEZCHAR30TEXT30
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
ZTERM_BEZDescription of terms of payment DZTERM_BEZCHAR30TEXT30
ZTERM_TX1Text (80 Characters) TEXT80CHAR80TEXT80UEB
ZTERM_TX2Text (80 Characters) TEXT80CHAR80TEXT80UEB
ZTERM_TX3Text (80 Characters) TEXT80CHAR80TEXT80UEB
ZTERM_TX4Text (80 Characters) TEXT80CHAR80TEXT80UEB
ABGRUReason for rejection of quotations and sales orders ABGRUCHAR2ABGRU
ABGRU_BEZDescription of reason for rejection ABGRU_BEZCHAR40TEXT40
TDNAMEName TDOBNAMECHAR70TDOBNAME
ATPKZReplacement part ATPKZCHAR1ATPKZ
FAKSPBlock FAKSPCHAR2Assigned to domainFAKSP
LFRELItem is relevant for delivery LFRELCHAR1XFELD
FKRELRelevant for Billing FKRELCHAR1FKREL
ANTLFMaximum Number of Partial Deliveries Allowed Per Item ANTLFDEC1ANTLF
KZTLFPartial delivery at item level KZTLFCHAR1KZTLF
SKTOFCash discount indicator SKTOFCHAR1XFELD
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
CHSPLBatch split allowed CHSPLCHAR1XFELD
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
BONUSVolume rebate group BONUSCHAR2Assigned to domainBONUS
PROVGCommission group PROVGCHAR2Assigned to domainPROVG
KTGRMAccount assignment group for this material KTGRMCHAR2Assigned to domainKTGRM
KONDMMaterial Pricing Group KONDMCHAR2Assigned to domainKONDMVKM
KDGRPCustomer group KDGRPCHAR2Assigned to domainKDGRPVKD
KDGRP_BEZDescription of customer group KDGRP_BEZCHAR20TEXT20
BZIRKSales district BZIRKCHAR6Assigned to domainBZIRKBZI
BZIRK_BEZName of the district BZTXTCHAR20TEXT20
VALTGAdditional value days VALTGNUMC2TAGE2
VALDTFixed value date VALDTDATS8DATUM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
BMENGConfirmed Quantity BMENGQUAN13(3) MENG13
EDATUSchedule line date EDATUDATS8DATUM
EZEITArrival time EZEIT_VBEPTIMS6UZEIT
DATBEZDescription of the date format (day, week, month) DATBEZCHAR8TEXT8
PRGRSDate type (day, week, month, interval) PRGRSCHAR1PRGRS
POSNR_NEUNew item POSNR_NEUCHAR1XFELD
ETENR_DAThere is more than one confirmed schedule line ETENR_DACHAR1XFELD
CUOBJConfiguration CUOBJ_VANUMC18CUOBJ
CUOBJ_CHInternal object number of the batch classification CUOBJ_CHNUMC18CUOBJ
VSMNGDelivered quantity in sales units VSMNGQUAN13(3) MENG13
ANZSNNumber of serial numbers ANZSNINT410INT4
FPLNRBilling plan number / invoicing plan number FPLNRCHAR10Assigned to domainFPLNR
DELCOAgreed delivery time DELCOCHAR3DELCO
DELCO_BEZDescription BEZEI20CHAR20TEXT20
BSTKDCustomer purchase order number BSTKDCHAR35BSTKD
BSTDKCustomer purchase order date BSTDKDATS8DATUM
BSARKCustomer purchase order type BSARKCHAR4Assigned to domainBSARK
BSARK_BEZDescription of purchase order type BSARK_BEZCHAR20TEXT20
IHREZYour Reference IHREZCHAR12TEXT12
BSTKD_EShip-to Party's Purchase Order Number BSTKD_ECHAR35BSTKD
BSTDK_EShip-to party's PO date BSTDK_EDATS8DATUM
BSARK_EShip-to party purchase order type BSARK_ECHAR4Assigned to domainBSARK
BSARK_BEZEDescription of purchase order type BSARK_BEZCHAR20TEXT20
IHREZ_EShip-to party character IHREZ_ECHAR12TEXT12
POSEX_EItem Number of the Underlying Purchase Order POSEX_ECHAR6ALPHAPOSEX
VGBELDocument number of the reference document VGBELCHAR10Assigned to domainALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6Assigned to domainPOSNR
UEPVWID for higher-level item usage UEPVWCHAR1UEPVW
DRAGRNot relevant for printing DRAGRCHAR1CHAR1
PREFEPreference indicator in export/import PREFECHAR1PREFE
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
MSR_IDProcess Identification Number MSR_PROCESS_IDCHAR10ALPHAMSR_PROCESS_ID
MSR_ITEMItem Number MSR_PROCESS_ITEMNUMC6MSR_PROCESS_ITEM
RMA_CUSTOMERCustomer RMA Number MSR_CRMA_NRCHAR20MSR_RMA_NR
MSR_RET_REASONReturn Reason MSR_RETURNS_REASONCHAR3Assigned to domainMSR_RETURNS_REASON
MSR_RET_REASON_TEXTReturn Reason Description MSR_RET_REASON_TEXTCHAR60TEXT60
MSR_MAT_RECEIVEDMaterial Received MSR_MATERIAL_RECEIVEDCHAR1XFELD
MSR_FU_CODEFollow-Up Activity Code MSR_FU_CODECHAR4Assigned to domainMSR_FU_CODE
MSR_FU_CODE_TEXTFollow-Up Activity Description MSR_FU_CODE_TEXTCHAR60TEXT60
MSR_FORW_VENDORAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
MSR_FWV_TITLEForm-of-Address Key AD_TITLECHAR4Assigned to domainAD_TITLE
MSR_FWV_ADDRNUMAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
MSR_FWV_NAME1Name 1 AD_NAME1CHAR40TEXT40
MSR_FWV_NAME2Name 2 AD_NAME2CHAR40TEXT40
MSR_FWV_NAME3Name 3 AD_NAME3CHAR40TEXT40
MSR_FWV_NAME4Name 4 AD_NAME4CHAR40TEXT40
MSR_FWV_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
MSR_FWV_PO_BOXPO Box AD_POBXCHAR10CHAR10
MSR_FWV_PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
MSR_FWV_CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12Assigned to domainALPHACITY_CODE
MSR_FWV_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
MSR_FWV_LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
MSR_FWV_POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
MSR_FWV_CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
MSR_FWV_CITY2District AD_CITY2CHAR40TEXT40CITY_PART
MSR_FWV_REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
MSR_DDA_TITLEForm-of-Address Key AD_TITLECHAR4Assigned to domainAD_TITLE
MSR_DDA_ADDRNUMAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
MSR_DDA_NAME1Name 1 AD_NAME1CHAR40TEXT40
MSR_DDA_NAME2Name 2 AD_NAME2CHAR40TEXT40
MSR_DDA_NAME3Name 3 AD_NAME3CHAR40TEXT40
MSR_DDA_NAME4Name 4 AD_NAME4CHAR40TEXT40
MSR_DDA_STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
MSR_DDA_PO_BOXPO Box AD_POBXCHAR10CHAR10
MSR_DDA_PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
MSR_DDA_CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12Assigned to domainALPHACITY_CODE
MSR_DDA_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
MSR_DDA_LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
MSR_DDA_POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
MSR_DDA_CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
MSR_DDA_CITY2District AD_CITY2CHAR40TEXT40CITY_PART
MSR_DDA_REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
RMA_VENDORVendor RMA Number MSR_VRMA_NRCHAR20MSR_RMA_NR
MSR_INSP_CODEInspection Code MSR_INSPECTION_CODECHAR4Assigned to domainQCODE
MSR_INSP_CODE_TXInspection Comment MSR_INSPECTION_COMMENTCHAR40MSR_INSPECTION_COMMENT
INSPECTION_CODE_FTEXT1Text (80 Characters) TEXT80CHAR80TEXT80UEB
INSPECTION_CODE_FTEXT2Text (80 Characters) TEXT80CHAR80TEXT80UEB
INSPECTION_CODE_FTEXT3Text (80 Characters) TEXT80CHAR80TEXT80UEB
INSPECTION_CODE_FTEXT4Text (80 Characters) TEXT80CHAR80TEXT80UEB
AT_CUSTOMER_SITEInspection at Customer Site MSR_AT_CUSTOMER_SITECHAR1XFELD
MSR_REFUND_CODEReturns Refund Code MSR_RETURNS_REFUND_CODECHAR3MSR_RETURNS_REFUND_CODE
MSR_REFUND_CODE_TEXTRefund Code Description MSR_REFUND_CODE_TEXTCHAR60TEXT60
MSR_FORW_PLANT1Plant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MSR_PLANT1_TXTName NAME1CHAR30TEXT30
MSR_FORW_PLANT2Plant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MSR_PLANT2_TXTName NAME1CHAR30TEXT30
MSR_FORW_PLANT3Plant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
MSR_PLANT3_TXTName NAME1CHAR30TEXT30
DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
/BEV1/EMMVGR1Material group 1 MVGR1CHAR3Assigned to domainMVGR1
/BEV1/EMMVGR2Material group 2 MVGR2CHAR3Assigned to domainMVGR2
/BEV1/EMMVGR3Material group 3 MVGR3CHAR3Assigned to domainMVGR3
/BEV1/EMMVGR4Material group 4 MVGR4CHAR3Assigned to domainMVGR4
/BEV1/EMMVGR5Material group 5 MVGR5CHAR3Assigned to domainMVGR5
/BEV1/EMNEUPOSItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
.INCLU--AP 0
ACTIVITY_TYPEReload Activity Type /DSD/SV_RELOAD_ACTIVITY_TYPECHAR2CHAR2
.INCLU--AP 0
BUMPSpecifies bump items, design item 8; Golden Gate BUMPCHAR1BUMP
.INCLU--AP 0
STKEYOrigin of the bill of material STKEYCHAR1STKEY
VGBEL_VKTSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
KTDATDate on Which Record Was Created ERDATDATS8DATUM
.INCLU--AP 0
SCNBRService contract number /SAPHT/SW_SCNBRCHAR10Assigned to domainALPHAVBELN
SCITEMService contract item number /SAPHT/SW_SCITEMNUMC6Assigned to domainPOSNR
SCMATNRService Material /SAPHT/SW_SCMATNRCHAR18Assigned to domainMATN1MATNR

Key field Non-key field



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

As VBDPA 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 VBDPA as there is no data to select.

How to access SAP table VBDPA

Within an ECC or HANA version of SAP you can also view further information about VBDPA 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!