SAP VBAPI PSIS - Individual Overviews: SD Document Items Table data and field list

VBAPI 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 "PSIS - Individual Overviews: SD Document Items" 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_VBAPI TYPE VBAPI.

The VBAPI table consists of various fields, each holding specific information or linking keys about PSIS - Individual Overviews: SD Document Items data available in SAP. These include ARNUMMER (Archiving Session Number), VSGRUPPE (Group for a project version), VSNUMMER (Number or description of a version), PRCTR (Profit Center)... 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. .

VBAPI structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VBAPI structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VBAPI table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
ARNUMMERArchiving Session Number ADMI_RUN_DCHAR6ADMI_RUN
VSGRUPPEGroup for a project version VSGRUPPECHAR20TEXT20
VSNUMMERNumber or description of a version VSNMRCHAR12VSNMRVS2
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
PSPIDProject Definition PS_PSPIDCHAR24ABPSNPS_PSPIDPSPPD_DUMMY
POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
KDAUFSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
KDPOSSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MATWAMaterial entered MATWACHAR18MARAMATN1MATNRMAT
PMATNPricing Reference Material PMATNCHAR18MARAMATN1MATNRMAT
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
ARKTXShort text for sales order item ARKTXCHAR40TEXT40
PSTYVSales document item category PSTYVCHAR4TVPTPSTYV
POSARItem type POSARCHAR1POSAR
LFRELItem is relevant for delivery LFREL_APCHAR1XFELD
FKRELRelevant for Billing FKRELCHAR1FKREL
UEPOSHigher-level item in bill of material structures UEPOSNUMC6Assigned to domainPOSNR
GRPOSItem for which this item is an alternative GRPOSNUMC6GRPOS
ZWERTTarget Value for Outline Agreement in Document Currency DZWERTCURR13(2) WERT7
ZMENGTarget quantity in sales units DZMENGQUAN13(3) MENG13
ZIEMETarget quantity UoM DZIEMEUNIT3T006CUNITMEINS
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
SMENGScale quantity in base unit of measure SMENGQUAN13(3) MENG13
ABSFZAllowed deviation in quantity (absolute) ABSFZQUAN13(3) MENG13
POSEXItem Number of the Underlying Purchase Order POSEXCHAR6ALPHAPOSEX
KDMATMaterial Number Used by Customer MATNR_KUCHAR35IDNEX
KBVERAllowed deviation in quantity (in percent) KBVERDEC3PACK2
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
NETWRNet value of the order item in document currency NETWR_APCURR15(2) WERTV8
WAERKSD Document Currency WAERKCUKY5TCURCWAERSFWS
KWMENGCumulative Order Quantity in Sales Units KWMENGQUAN15(3) MENG15
LSMENGCumulative required delivery qty (all dlv-relev.sched.lines) LSMENGQUAN15(3) MENG15
KBMENGCumulative confirmed quantity in sales unit KBMENGQUAN15(3) MENG15
KLMENGCumulative confirmed quantity in base unit KLMENGQUAN15(3) MENG15
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
VBELVOriginating document VBELVCHAR10VBUKALPHAVBELN
POSNVOriginating item POSNVNUMC6VBUPPOSNR
VGBELDocument number of the reference document VGBELCHAR10VBUKALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6VBUPPOSNR
LPRIODelivery Priority LPRIONUMC2TPRIOLPRIO
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
VSTELShipping Point/Receiving Point VSTELCHAR4TVSTVSTELVST
ROUTERoute ROUTECHAR6TVROROUTE
STKEYOrigin of the bill of material STKEYCHAR1STKEY
STDATKey date of the bill of material STDATDATS8DATUM
STLNRBill of material STNUMCHAR8NUMCVSTNUMSTLNR
STPOSBill of material item number VBAP not used STPOS_VBAPDEC5STPOS_VBAP
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERZETEntry time ERZETTIMS6UZEIT
NETPRNet price NETPRCURR11(2) WERTV6
KPEINCondition pricing unit KPEINDEC5KPEIN
KMEINCondition unit KMEINUNIT3T006CUNITMEINS
AEDATChanged On AEDATDATS8DATUM
KMPMGComponent quantity KMPMGQUAN13(3) MENGV13
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
VPMATPlanning material VPMATCHAR18MARAMATN1MATNR
VPWRKPlanning plant VPWRKCHAR4T001WWERKS
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
SERNRBOM explosion number SERNRCHAR8SNUMSERNR
ABGRSResults Analysis Key ABGR_SCHLCHAR6TKKAAABGR_SCHLACS
SPOSNBOM Item Number SPOSNCHAR4NUMCVSPOSN
STATXTEdited status text STATUSTEXT_2CHAR80CHAR80
OBJNRObject number at header level OBJKOCHAR22Assigned to domainJ_OBJNR
PSPNRCurrent number of the appropriate project PS_PSPHINUMC8Assigned to domainKONPDPS_PSPNR
POSNRWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
INT_IDID/Object key OBJEKT_IDCHAR30CHAR30
LOEKZDeletion Indicator LOEVMCHAR1XFELD
LIGHTALV control: Exception as LED LVC_EXLEDCHAR1CHAR1

Key field Non-key field



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

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

How to access SAP table VBAPI

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

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