VL31_HIST SAP (Structure VL31_HIST for Purchase Order History) Structure details

Dictionary Type: Structure
Description: Structure VL31_HIST for Purchase Order History




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




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

VL31_HIST 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 "Structure VL31_HIST for Purchase Order History" 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_VL31_HIST TYPE VL31_HIST.

The VL31_HIST table consists of various fields, each holding specific information or linking keys about Structure VL31_HIST for Purchase Order History data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), ZEKKN (Sequential Number of Account Assignment), VGABE (Transaction/event type, purchase order history).. 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: Not classified


SAP VL31_HIST 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 MANDTCLNT3T000MANDT
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
ZEKKNSequential Number of Account Assignment DZEKKNNUMC2NUM02
VGABETransaction/event type, purchase order history VGABECHAR1VGABE
GJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
BELNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
BUZEIItem in Material Document MBLPONUMC4MBLPOPOS
BEWTPPO history category BEWTPCHAR1T163BBEWTP
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
BUDATPosting Date in the Document BUDATDATS8DATUM
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
BPMNGQuantity in purchase order price unit MENGE_BPRQUAN13(3) MENG13
BPRMEOrder Price Unit (Purchasing) BBPRMUNIT3Assigned to domainCUNITMEINS
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
HSWAELocal currency key HSWAECUKY5TCURCWAERS
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
AREWRGR/IR account clearing value in local currency AREWRCURR13(2) WERT7
WESBSGoods Receipt Blocked Stock in Order Unit WESBSQUAN13(3) MENG13
BPWESQuantity in GR blocked stock in order price unit BPWESQUAN13(3) MENG13
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
LFGJAFiscal Year of a Reference Document LFBJANUMC4GJAHRGJAHR
LFBNRDocument No. of a Reference Document LFBNRCHAR10ALPHABELNR
LFPOSItem of a Reference Document LFPOSNUMC4MBLPO
GRUNDReason for Movement MB_GRBEWNUMC4T157DMB_GRBEW
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
REEWRInvoice Value Entered (in Local Currency) REEWRCURR13(2) WRTV7
EVERECompliance with Shipping Instructions EVERECHAR2T027CEVERE
REFWRInvoice value in foreign currency REFWRCURR13(2) WRTV7
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
XWSBRReversal of GR allowed for GR-based IV despite invoice XWSBRCHAR1XFELD
ETENSSequential Number of Vendor Confirmation ETENSNUMC4NUM04
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
LSMNGQuantity in Unit of Measure from Delivery Note LSMNGQUAN13(3) MENG13
LSMEHUnit of Measure From Delivery Note LSMEHUNIT3T006CUNITMEINS
EMATNMaterial Number EMATNRCHAR18MARAMATN1MATNRMAT
AREWWClearing value on GR/IR clearing account (transac. currency) AREWWCURR13(2) WERT7
BAMNGQuantity MENGE_DQUAN13(3) MENG13
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
BLDATDocument Date in Document BLDATDATS8DATUM
XWOFFCalculation of val. open XWOFFCHAR1XFELD
XUNPLUnplanned Account Assignment from Invoice Verification XUNPLCHAR1XFELD
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
SRVPOSService number SRVPOSCHAR18Assigned to domainALPHAASNUM
PACKNOPackage Number of Service PACKNO_EKBENUMC10Assigned to domainPACKNO
INTROWLine Number of Service INTROW_EKBENUMC10INTROW
BEKKNNumber of PO Account Assignment BEKKNNUMC2NUM02
BSTYPPurchasing Document Category EBSTYPCHAR1EBSTYP

Key field Non-key field



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

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

How to access SAP table VL31_HIST

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