/OPT/VIM_1ITEM SAP (Document Item) Table details

Dictionary Type: Table
Description: Document Item




ABAP Code to SELECT data from /OPT/VIM_1ITEM
Related tables to /OPT/VIM_1ITEM
Access table /OPT/VIM_1ITEM




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

/OPT/VIM_1ITEM is a standard SAP Table which is used to store Document Item data and is available within R/3 SAP systems depending on the version and release level.

The /OPT/VIM_1ITEM table consists of various fields, each holding specific information or linking keys about Document Item data available in SAP. These include DOCID (Document Ledger Number), ITEMID (Document Item Id), BUKRS (Company Code), EBELN (Purchasing Document Number).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP /OPT/VIM_1ITEM table 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
DOCIDDocument Ledger Number /OPT/DOCIDNUMC12/OPT/VIM_1HEAD/OPT/DOCID/OPT/DOCID/OPT/DOCID
ITEMIDDocument Item Id /OPT/DOCITEMIDNUMC5/OPT/DOCITEMID
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
MENGEQuantity MENGE_DQUAN13(3) MENG13
BSTMEPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LFSNRNumber of External Delivery Note LFSNRCHAR16XBLNR
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
COND_TYPECondition Type KSCHLCHAR4Assigned to domainKSCHLVKS
NETPRNet Price in Purchasing Document (in Document Currency) BPREICURR11(2) WERT11
TAX_RATE1Data element for Tax rate /OPT/VIM_TAX_RATECURR11(2) WERTV6
TAX_CODE1Tax Code /OPT/VIM_TAX_CODECHAR2Assigned to domainMWSKZ
TAX_AMOUNTAmount in document currency WRBTRCURR13(2) WERT7
ZERO_TAX_RATE1Comment CHAR50CHAR50TEXT50
LSTARActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
ZUONRAssignment Number DZUONRCHAR18ZUONR
SGENRBuilding Number SGENRCHAR8Assigned to domainSGENRSGENRGEBMCGE
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
KSTRGCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
KBLNRDocument Number for Earmarked Funds KBLNRCHAR10Assigned to domainALPHAKBLNRKBL
EREKZFinal Invoice Indicator EREKZCHAR1XFELD
FKONTFinancial Budget Item FIPLSNUMC3FIPLS
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
SGTXTItem Text SGTXTCHAR50TEXT50
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
SMIVELease-Out Number SMIVECHAR13ALPHAVVSMIVEMIVMRTA
NPLNRNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
PARGBTrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
PPRCTPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
WRBTR_PROPAmount in document currency WRBTRCURR13(2) WERT7
SGRNRProperty Number for BE SGRNRCHAR8Assigned to domainSGRNRSGRNRGRSMCGR
RECNNRReal Estate Contract Number RECNNRCHAR13ALPHARECNNRRECNNR
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
VBELPSales document item VBELPNUMC6Assigned to domainPOSNR
ETENRDelivery Schedule Line Number ETENRNUMC4Assigned to domainETENR
SNKSLService Charge Key SNKSLCHAR4Assigned to domainALPHASNKSLNKLREFXCLSNKSL
SMENRNumber of Rental Unit SMENRCHAR8Assigned to domainSMENRSMENRMEHMCME
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
VBUNDCompany ID VBUNDCHAR6Assigned to domainALPHARCOMP
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
PS_POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
XSKRLIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
SVWNRManagement Contract Number VVSVWNRCHAR13Assigned to domainALPHAVVSVWNRVWVMCVW
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
CURR_APPROVEROpen Text User Mapping Object ID /ORS/UMOIDCHAR35Assigned to domain/ORS/UMOID/ORS/UMOID/ORS/000007_OPT_ID

Key field Non-key field



How do I retrieve data from SAP table /OPT/VIM_1ITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on /OPT/VIM_1ITEM to SELECT all data from the table
DATA: WA_/OPT/VIM_1ITEM TYPE /OPT/VIM_1ITEM.

SELECT SINGLE *
FROM /OPT/VIM_1ITEM
INTO CORRESPONDING FIELDS OF WA_/OPT/VIM_1ITEM
WHERE...

How to access SAP table /OPT/VIM_1ITEM

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